508 questions
0
votes
1
answer
72
views
How to group by geography in Bigquery
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
...
- 67
4
votes
1
answer
223
views
Calculate rotation of a point around another point on earth (or sphere)
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 ...
- 43
0
votes
1
answer
52
views
Azure SQL Server, Geographic Data and Scalar Variable Error
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 ...
- 1,779
0
votes
0
answers
82
views
Transact SQL geography polygon contains point
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)...
1
vote
1
answer
154
views
How could I add bodies of water to raster data?
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 ...
- 77
0
votes
1
answer
292
views
How calculate distance between two points in EF Core and PostgreSql database
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 ...
- 21
0
votes
0
answers
94
views
Formatting a geographical STBuffer output to reduce length of the returned Latitude and Longitude string
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 ...
- 473
1
vote
1
answer
100
views
Issues to convert Postal code in lat and lng
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 ...
- 33
-1
votes
2
answers
95
views
How do I interpret these coordinates I got from the website of the german statistical bureau?
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 ...
0
votes
1
answer
274
views
Postgres geography crossing date line, intersecting a polygon
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 ...
- 109
1
vote
1
answer
163
views
Excel choropleth map - find/get regions?
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 ...
- 302
0
votes
0
answers
76
views
NaturalEarth GDP and population Data: What year are they from?
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&...
- 13
0
votes
1
answer
277
views
Encountering with a problem while calculating the geoid height at a point in RAWVAL method with NETGeographicLib
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 ...
- 3
0
votes
0
answers
26
views
Continuous model of geographic direction (e.g. as ML predictor)
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 ...
1
vote
2
answers
328
views
Obtaining standard deviation ellipse geometry in R
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,...
- 11
