191 questions
0
votes
1
answer
82
views
How can I filter invalid WKT geometries before calling ST_GEOMETRYFROMWKT in Snowflake?
I am trying to convert WKT strings in a column to WKB in Snowflake using ST_GEOMETRYFROMWKT so that I can visualize them in Spotfire. Some rows cause this error:
ERROR [P0000] Geometry validation ...
- 21
0
votes
1
answer
212
views
Handling failed geography validation from crossing edges in Snowflake
I am attempting to load WKT representations of polygons and multipolygons into a Snowflake GEOGRAPHY-type column. Each polygon has thousands of points, each of which is defined by lat/long points ...
- 1
0
votes
0
answers
122
views
Looker Studio Custom Map Visualization Breaks After Reload
I'm currently working on an online dashboard in Google Looker Studio, with BigQuery as the database backend.
One of the visualizations involves displaying polygons on a map, which had been working ...
0
votes
1
answer
648
views
WKT Point Geometry to Coordinates (latitude and longitude)
I am working on a Tableau project that provides an analysis of congestion in NYC. I have a data set that shows the daily volume of cars, the borough, the origin street (fromst), destination street (...
- 9
3
votes
1
answer
240
views
Create MultiPolygon objects from struct type and list[list[list[f64]]] columns using Polars
I have downloaded the NYC Taxi Zones dataset (downloaded from SODA Api and saved as json file - Not GeoJson or Shapefile). The dataset is rather small, thus I am using the whole information included. ...
- 1,589
0
votes
1
answer
167
views
How to drop SRID=4326 from GeoPandas MultiPolygon Geometry column
I am using shape data from .shp files and using geopandas to convert those into Multipolygons for my postgresql table with a column of type geometry(multipolygon, 4326) NULL. The issue I'm running ...
- 3
1
vote
0
answers
223
views
MySQL check if Point in Polygon (GeoJSON)
I have a table named fields with a column named geoJSON. The geoJSON column is of type JSON which stores an actual GeoJSON object. I am trying to take a list of coordinates which are POINTS (single ...
- 532
-1
votes
1
answer
153
views
MYSQL ST_Union returning weird polygon-multipolygon hybrid
I'm using PHP to physically locate items in a MYSQL table based on their relationship to other items. Specifically, I'm creating the spatial WKT by running a series of ST_UNIONs on the result. In most ...
0
votes
1
answer
194
views
What is this error and how to fix it?: ValueError: Invalid value supplied 'WktVersion.WKT2_2019'
I am trying to read a .shx file into my Python script using geopandas and I receive:
"ValueError: Invalid value supplied 'WktVersion.WKT2_2019'. Only ('WKT2_2015', 'WKT2_2015_SIMPLIFIED', '...
- 77
0
votes
1
answer
366
views
Alternatives for Ingesting Oracle SDO_GEOMETRY Data into GeoMesa
I am currently working on a project that involves ingesting spatial data from an Oracle database into GeoMesa using the JDBC converter. My source data is in the Oracle-specific SDO_GEOMETRY format.
My ...
- 1
2
votes
1
answer
1k
views
NetTopologySuite WKTReader ignores SRID
I implemented NetTopologySuite into EF Core (SQLServer). I'm getting coordinates from the Google APIs, transforming them into Point and Polygon and saving them into the database without trouble.
I ...
- 35
0
votes
2
answers
245
views
Regex for MultiPolygon WKT
I am looking for a regex expression for validating a MultiPolygon in WKT format.
- 77
0
votes
1
answer
964
views
Generating Multipolygon WKT from a Shapefile
I have a Shapefile with multiple polygons. When using the following method to generate a WKT the resultant output is only the first polygon of the Shapefile. The method works fine for single polygon ...
- 45
1
vote
1
answer
734
views
R function to convert polygon (sf, wkt) into mask (matrix, array)
I have an image stored as matrix with grayscale for each pixel.
On this image I use SLIC algorithm to divide it into areas.
So I get a simple feature (sf) with polygons, I am able to extract in well-...
- 115
0
votes
1
answer
189
views
Plot .geojson coordinates
For those wanting to test the contents of their .geojson files, by visualising/ plotting coordinates.
I didn't see a go-to solution online.
- 2,045
1
vote
1
answer
220
views
mapview and plot show different output for the same rasterLayer, why?
Below is the rasterLayer RASTER_slope in a plot (4 NAs are shown in white):
Here is the metadata of RASTER_slope
class : RasterLayer
dimensions : 4, 4, 16 (nrow, ncol, ncell)
resolution : 500, ...
- 51
0
votes
1
answer
69
views
Aggregate vertices-as-rows to string
I have multi-part polyline vertices stored as individual rows in an Oracle 18c table.
ASSET_ID PART_NUM VERTEX_NUM X Y M
---------- ---------- ---------- ---------- -----...
- 366
1
vote
0
answers
337
views
geopandas shapefile wkt column not visible
I have a dataset like the image below. I want to save it as shp file.
enter image description here
I tried with this code.
df['geometry'] = geopandas.GeoSeries.from_wkt(df['geometry'])
gdf = geopandas....
- 37
1
vote
1
answer
1k
views
how transform R list to polygons
The data is a csv with colum like this :
"list(c(-72.6689780388482, -72.6697951984133, ...... -37.8155440677891, -37.8164165487739, ......))"
The original archive is a .RDS file
My goal is ...
0
votes
1
answer
1k
views
GeoTools transform from CRS in meters to CRS in degree (WGS84)
I am trying to use GeoTools to transform between two coordinate systems, one in meter and the other in degree, but no matter what i try the converted values are not correct. I have tried to follow ...
- 5,656
1
vote
1
answer
2k
views
A faster way of loading shapely.wkt geometries into a pandas dataframe from a dataframe of WKT strings
How it's currently done is as follows:
geoms = df["wkt"].apply(shapely.wkt.loads).values
Here df["wkt"] has rows with data like:
"MULTIPOLYGON (((24.2401805 70.8385222,24....
- 207
1
vote
3
answers
2k
views
convert csv to shp in r where geometry is in single column
I have a csv file that contains the point geometry information in a single column. Is there a straight forward way to convert from csv to a spatial data file in r given the format of the geometry ...
- 11
1
vote
1
answer
165
views
Difference between wkt and str
I have a shapely Polygon. What is the difference between converting it to wkt and converting it to string:
import shapely.wkt
P = shapely.wkt.loads('POLYGON ((8.0 3.0, 8.3 3.3, 8.3 3.0, 8.0
3.0))')
...
- 1,176
0
votes
0
answers
885
views
Does a conversion by shapely.wkt.loads return the same polygon?
One thing I can't explain. Why the new created polygon converted to string by str() or .wkt is not recognized in the list after shapely.wkt.loads? The last print returns no.
import shapely.wkt
liste =...
- 583
1
vote
1
answer
640
views
Errors converting Geometry to Geography
I am getting an error trying to convert data from a Geometry field to a geography field in a separate table.
INSERT INTO PIGeoData
([ID], [geo_name], [geo_wkt] ,[port_geography_binary] )
...
- 311