✕
Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
507 questions
Newest Active Bountied Unanswered

Question list filters

Filter by
Sorted by
Tagged with
Filter by Employee ID
Score of 0
1 answer
79 views

I have the following code: SELECT h3s.h3id, h3s.geog, MIN(ST_DISTANCE(`carto-os`.carto.H3_CENTER(htsp.h3id), `carto-os`.carto.H3_CENTER(h3s.h3id))) OVER (PARTITION BY h3s.h3id) FROM ...
Score of 4
1 answer
230 views

Essentially what I'm trying to do is moving a point relative to two different scales. The reason is to edit values in a database of a 3d party application. So basically I want to relocate the red ...
Score of 0
1 answer
57 views

I have a dedicated Azure SQL environment where I am using a loop to get US States names like 'AB' or 'NY' etc and also geographical boundaries from the same table. Code and error below: DECLARE ...
Score of 0
0 answers
87 views

I have a polygon surrounding the country of Luxemburg (Europe). I have two points: one (more or less) in the center of Luxemburg City (Luxemburg) one (more of less) in the center of Brussels (Belgium)...
Score of 1
1 answer
158 views

I have a raster layer, which has latitudes and longitudes at a given resolution that determines the total number of grid cells. My goal is to find the distance from each cell to a body of water. How ...
Score of 0
1 answer
300 views

I am trying to calculate the distance of the user current point with another point in the database. I wrote the following code but I get function st_x(geography) does not exist error. var ...
Score of 0
0 answers
97 views

I am using the geography datatypes in SQL server to output a string of longitude's and latitude's with a set distance (1 meter in this instance) from a input longitude and latitude. DECLARE @g ...
Score of 1
1 answer
117 views

I'm currently working on converting some postal codes into latitude and longitude coordinates. I've successfully imported the PCCF, but I've run into an issue. The smallest geography unit in the PCCF ...
Score of -1
2 answers
101 views

Thanks for clicking. During my research, I stumbled upon the "Unfallatlas", which is essentially a collection of all the accidents that happened in a specific year. For me, only the ...
Score of 0
1 answer
285 views

My geography object in postresql DB intersects with date line, but postgres mean what the object don't intersect date line. Actually, the square of the polygon is much smaller. Why it is happens? The ...
Score of 1
1 answer
176 views

I'm working on an Excel file with municipalities in NL. With the data->data type->geography I can label those municipalities. Next, I can add a value and create a map (image on the left). There ...
Score of 0
0 answers
78 views

I am using NaturalEarth in geopandas to get GDP and population estimates per country: world = gpd.read_file(gpd.datasets.get_path("naturalearth_lowres")) world = world.set_index("iso_a3&...
Score of 0
1 answer
284 views

I'm developing an app that is like a simulation which has to have geoid height for a point(Latitude, Longitude) continuously. Due to the reason that NETGeographicLib demonstrates high performance ...
Score of 0
0 answers
28 views

Imagine the geographical direction from N, over NNE, NE, E ,... and so on. They are also represented from 0 to 360 degrees. So far so easy. Now I want to use the arc degree as a predictor in a machine ...
Score of 1
2 answers
335 views

I am working with a data frame consisting of points. Take the data below as fake example of the points I observe for individual i: D <- tibble(trip_long = c(-87.7, -87.6, -87.6, -87.7, -87.7, -87.8,...

15 30 50 per page
1
2 3 4 5
…
34