close
Skip to main content
507 questions
Newest Active Bountied Unanswered

Question list filters

Filter by
Sorted by
Tagged with
Score of 0
1 answer
80 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
232 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
160 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
302 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
98 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
118 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
104 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
287 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
79 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
29 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
338 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