Category "geospatial"

Linq .Distinct() add extraneous ordering

My entity has a computable geography::point column (represented by DbGeography type in code) When I call a .Distinct() method on query for this entity it adds O

Spatial with SparkSQL/Python in Synapse Spark Pool using apache-sedona?

I would like to run spatial queries on large data sets; e.g. geopandas would be too slow. Inspiration I found here: https://anant-sharma.medium.com/apache-sedon

Convert Canadian Postal Code to Longitude and Latitude

I have a list of 100 Canadian postal codes (e.g. M4B 1C7). Is there anyway to convert these postal codes into approximate longitude and latitude values? Current

Find in which polygon certain coordinate (latitude, longitude) lies with MongoDB?

Let's say 100 documents (so to say polygons) in a collection named Areas with this structure: { ...otherFields, commonName: "Butwal", area: { type: "

Creating custom colourmap for geopandas.explore plot

all code: def rgb2hex(r,g,b): return '#{:02x}{:02x}{:02x}'.format(r,g,b) def rg(num): num = int(np.round((num / 100) * 124)) r = (124 - num) g

Geospatial 2dsphere index not creating in MongoDB Atlas and manually

I am trying to create a 2sphere index in my mongodb collection. The index needs to be on location field which is at GeoJSON format: location: { coordinat

Adding colormap legend to Folium map

I'm trying to make a map in Folium with multiple layers, each consisting of shaded areas (using GeoJSON) with colors given by a colormap. I'd like to add legend

Plot polygons with buffer of some radius using folium not working properly

I am trying plot the intersection between a buffer circle and the mesh blocks (or boundaries) within that circle of some radius (in this case, 80 km). I got the

Plot polygons with buffer of some radius using folium not working properly

I am trying plot the intersection between a buffer circle and the mesh blocks (or boundaries) within that circle of some radius (in this case, 80 km). I got the

Can't install geoplot package

I'm trying to install geoplot package for a few hours now but I can't understand why I can't do it. I saw several links in here just saying "only use conda and

Save lat & lng values into point field in mysql

I have a table with fields latitude and longitude stored as float values, and I want to start saving them into points in a new column to use spatial features. C

Can I bound an st_distance call by a polygon?

I have seen similar posts on this topic (see, for example, here and here) but not one that is specific to the sf-tidyverse ecosystem. I have a series of lakes,

Best way to find distance between two geopoints(lats, longs) in node.js [duplicate]

Can anyone pls tell me what is the best way to find distance between two geopoints (lats, longs) in node.js . If there is any good node js lib

How to deal with the colorbar axis space in matplotlib subplots

I am plotting seven different parameters over four seasons, as shown in below image. but on last column (Post-Monsoon) sub_plots axis compromised with colorbar

Convert UDT subtype to supertype

I use a user-defined type (UDT) in Oracle 18c called ST_GEOMETRY: The ST_Geometry storage type ST_Geometry in Oracle SQL functions used with ST_Geometry I have

Construct DbGeography point from Latitude and Longitude doubles?

I want to construct a DbGeography point from latitude and longitude doubles. I know I can convert my doubles to strings and use the DbGeography.FromText method