Well-known text (WKT) is a text markup language for representing vector geometry objects on a map, spatial reference systems of spatial objects and transformations between spatial reference systems.

learn more… | top users | synonyms

1
vote
1answer
14 views

How do I convert WKT geometry from 3D to 2D

I'm working with kml files using Python gdal.ogr module. When I extract feature's geometry using feature.GetGeometryRef(), I get: POLYGON ((44.184069865521963 41.971859752507207 0,44.355248797385123 ...
2
votes
3answers
884 views

Iterating polygons on a SpatialPolygonsDataFrame in R with readWKT

I have fetched some data (39 objects) from my PostGIS database and converted this data into a matrix: rs <- dbSendQuery(con, "SELECT ST_AsText(polygon_accumulation) AS ShapeWKT from accumulation;")...
0
votes
1answer
25 views

Verify with WKT point is in a polygon SQL

I'm using SQL Server and WKT to deal with geographic data. What I'd like to do is have something like : SELECT pt FROM point_table, polygon_table where pt.point_table WITHIN ply.polygon_table Here ...
0
votes
1answer
356 views

Parsing XML file with hundred polygons using OpenLayers

I'm using this script but It's not working. <script type="text/javascript"> var raster = new ol.layer.Tile({ source: new ol.source.OSM() }); var xml = new OpenLayers.Format.XML(), wkt = new ...
1
vote
1answer
215 views

Parsing large GeoJson geometry to WKT

I'm reading a very large json file as an InputStream in Android with JsonReader. This json has a geometry object like so.. "geometry":{ "type":"MultiPolygon", "coordinates":[ ...
0
votes
1answer
216 views

Using Well-Known Text and geocoding on Load

So, I have tested adding columns with the WKT format into Carto, and it has always worked great (I tried 1 row, then 1000 random rows from our data). I geocoded it on load by naming the column with ...
1
vote
1answer
224 views

What is the difference between ST_GEOMETRY and WKT?

What is the difference between ST_GEOMETRY and WKT? Is ST_GEOMETRY just a database type and WKT (well-known text) is a textual representation of the data?
1
vote
1answer
115 views

Finding all polygons inside of a polygon

How to find all the polygons inside of a polygon? I tried ST_Intersects and ST_Contains but they are booleans variables. I have a list of polygons in WKT format, so I am trying to pull all the ...
0
votes
1answer
44 views

ST_Transform error

I am getting an error from ST_Tranform while using ST_Intersection: No function matches the given name and argument types. You might need to add explicit type casts. select ST_Intersection(...
1
vote
0answers
44 views

Getting H2GIS functions to work in Spherical Space?

I've been playing around with H2GIS (http://www.h2gis.org/) for a project at work and am struggling to get the H2 functions to operate in spherical space (lat/ lon), rather than cartesian space. The ...
10
votes
4answers
9k views

Online WKT and GeoJSON viewer

I once found a great but simple webpage that has a drop down with several text-based GIS formats such as GeoJSON and WKT, and a text box to copy/paste your data. The feature is then drawn on a world ...
1
vote
1answer
28 views

QGIS How to draw lines from two points in a CSV?

I have a largely identical query to How to draw lines from two points in a CSV?, however the solution listed isnt working for me. My original text format is PID, Start Northing, Start Easting, End ...
3
votes
1answer
1k views

Converting wkt to geojson with OpenLayers

I am trying to convert wkt to geojson wiht OpenLayers. I wrote my code based on this question (geojson to wkt). That's what I have so far, but it is not working. Any ideas? var = '...
0
votes
0answers
16 views

WKT for Local Mine Grid (Again)

I came across WKT for local mine grid which is very close to the question I have. Unfortunately that post doesn't detail a method that I can repeat, just a very good solution. I too would like the ...
1
vote
1answer
28 views

How to copy the geometry WKT from a temporary scratch layer in QGIS?

It seems in the 2.14.2 version of QGIS the ability to copy the WKT from the geometry of a temporary scratch layer has been removed. Previously you could create, for example, a new polygon feature in ...
4
votes
3answers
134 views

How to get WKT for various Spatial Reference Systems?

I need to provide WKTs of spatial reference systems in the APIs provided by GDAL/OGR. Is there some specific place where I can look for WKTs of the spatial reference systems that I'm working with? Or ...
3
votes
1answer
44 views

PostGIS: floating point representation problem with ST_AsText

I have a table with geometries, all with about 13 digits of accuracy. While trying to represent them with ST_AsText though, most vertices come out in decimal notation, but some come out in scientific ...
3
votes
1answer
233 views

Problem with precision when convert from WKT to shapefile

I have a problem with converting from WKT to shapefile in pygdal. In wkt I have fields with precision (for example real 7.2). When I create a shapefile I have field numeric with no precision (numeric ...
3
votes
0answers
41 views

GDAL c# API returned different WKT from gdalinfo

I've found completely different results in WKT strings while using gdalinfo utility and method from c# API GetProjectionRef(). In the first case the result was: PROJCS["WGS 84 / Pseudo-Mercator", ...
12
votes
1answer
4k views

Where can I find the WKT standard or reference?

I had a little confusion about the representation of a geometry as well-known-text (WKT). I was searching for the WKT Specs to search for the exact representation, but I did not find the Standard. Is ...
2
votes
1answer
289 views

Geoserver projection recognize problem

I'm publishing shape files in geoserver through curl,my problem is that geoserver didn't recognizing the projection which is in ESRI WKT format(layer was publishing).I searched for this problem i ...
2
votes
0answers
136 views

From where can i download WKT files for US zip codes? [duplicate]

From where can i download WKT files for US zip codes ?? i need to plot zip code boundary on a map using open layers
1
vote
0answers
19 views

Proj4 WKT - Cartesian with origin to EPSG900913

I'm converting wgs84 to cartesian with origin using simple function in c# public static double[] LL_TO_XY(double latitude, double longitude, double originLatitude, double originLongitude) { ...
1
vote
2answers
34 views

What is the format for OSM lat/lon in .osm/.osh files and how to import correctly into PostGIS?

I've been having issues converting OpenStreetMap geometries to valid points in PostGIS. MY PostGIS table has the this definition for the geom column: SELECT AddGeometryColumn('node','geom',900913,'...
6
votes
1answer
6k views

What's the proper format for WKT linestrings when importing into QGIS?

I'm trying to run the following test CSV through the Delimited Text plugin as WKT data: oid,Line 1,LINESTRING((45.554194 -122.686101, 45.433001 -122.762632)) 2,LINESTRING((45.432505 -122.598327, 45....
1
vote
1answer
31 views

How to convert image type into wkt

I’m working with a GIS that uses SQL Server as its DBMS. So I have to insert some data into a column called dbo.CidadesGeo, but before do that I have to understand how the geometry (geometria) column ...
0
votes
0answers
31 views

Using JTS to rotate a Polygon doesn't seem to be working

I am using JTS to create a Polygon - the Polygon creates properly (with the right dimensions and in the right place), but rotation seems to stretch the shape and not rotate properly. I have a video ...
0
votes
0answers
44 views

Mapnik, MemoryDatasource and StyleSheet: Rendering WKT

I want to render linestring with the help of mapnik but I get blank picture. Python code: import mapnik stylesheet = 'python-wkt.xml' image = 'python-wkt.png' m = mapnik.Map(600, 300) context = ...
5
votes
0answers
541 views

What traits identify 2D, 2.5D, 3D geometries, and how can you convert downward, such as from 2.5D to 2D? [closed]

In answering OGR - Weird GeomType -2147483645 on polygon shapefile, posed by @Burton449, I came to realize I don't have a definitive grasp on what distinguishes 2D, 2.5D, and 3D geometries. I ...
1
vote
1answer
139 views

Visualize WKT polygon on a map

Is there any tool that will let me visualize a WKT polygon on a world map such as google maps?
0
votes
0answers
53 views

Z and M values get lost when extending MS SQL geography Linestring by .STUnion

I'm trying to add new geography points with Z and M values to a geography linestring. This has to be SQL 2008 R2 compatible. I've found some references to .STUnion() and tried that. The linestrings ...
1
vote
1answer
1k views

OpenLayers create marker (feature with icon) from WKT

I have a point object WKT. Like this: POINT (25.04568 48.221548). Also I have an icon in my project folder. My goal is to show on a map an icon that represents a feature. Can it be just a normal ...
0
votes
0answers
42 views

Converting WKT to Coordinates using RGeo?

I want to convert the WKT text that I have in a csv file to Coordinates. I am trying the following: :geometry => RGeo::Geos.factory(:srid => 4326).parse_wkt(row['GEOMETRY']) My WKT is in ...
7
votes
2answers
3k views

what is the best way to programmatically convert between WKT and Proj4 string?

some shapefiles have a .prj file associated with it. and the .prj file contains the projection info of the shapefile in the format of WKT. Sometimes I need to convert WKT to proj4 string, and ...
3
votes
1answer
305 views

Adding a WKT specified coordinate system to ArcGIS?

I've got a WKT specified coordinate system, how do I add this to ArcGIS?
4
votes
5answers
322 views

How do you generate WKT from a graphic drawn on a map?

All, In order to do some quick analysis using SQL spatial, I'd like to generate spatial objects using the STGeomFromText / ST_GeomFromText function. With point data, I can do this by geocoding an ...
0
votes
0answers
62 views

GeoServer support for WKT geospatial data that is read from a database

I have geospatial data stored in a MemSQL database in the Well-Known Text (WKT) format. I would like to visualize it in GeoServer. MemSQL supports the MySQL Wire Protocol and therefore I used the ...
4
votes
2answers
8k views

How to convert a shapefile to WKT?

I'm trying to convert a shapefile into the simple Well Known Text (WKT) format in the example below (from http://en.wikipedia.org/wiki/Well-known_text). MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)), (...
0
votes
0answers
37 views

Axis order in user Shapefile

I have a shapefile which has the following PRJ GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]], ...
1
vote
1answer
185 views

From featureclass (or shp) to WKT e GeoJSON

I use ArcGIS 10.1 without Data Interoperability extension and I want to convert some feature classes (point, lines and polygons) contained in an .mdb. I read some posts but can't convert my file. ...
2
votes
0answers
26 views

What does EMPTY mean in WKT? [duplicate]

The OGC Simple Features standard (OGC 06-103r4, Version: 1.2.1), section 7, defines the formal grammar of Well Known Text (WKT) representation. A small excerpt (omitting a large subset of geometry ...
0
votes
3answers
145 views

How do I go from the WKT results of Calculate UTM Zone (Cartography) to a spatial reference object?

Calculate UTM Zone (Cartography) assigns a UTM zone to each feature within a feature class as a field value. The value returned is a 'UTM spatial reference string', which is a long string that looks ...
1
vote
0answers
52 views

QGIS Copy Attribute Table To Excel - where does the new lines come from?

I have an attribute table with 3100 lines. I selected the whole table and pressed the button 'copy selected rows to clipboard', afterwards I pasted them into an excel-table. Now I have 27 lines ...
3
votes
4answers
9k views

How to convert WKB to WKT?

how can i convert wkb to wkt form ... i stored coordinates in wkb but now can it will display to use in wkt form
1
vote
2answers
902 views

Convert WKT to GeoJSON with leaflet

I have a point type WKT geometry column in a MySQL table storing the location of some stores. I want to display it on a leaflet map on my website. I've found plenty of tutorials to doing this on ...
1
vote
1answer
72 views

Does SQL Server Data Need to be Spatial

In reference to my previous question. I am looking for the benefits of telling SQL Server your data is spatial. For instance, I have a duplicate of that table generated by the Shape2SQL tool (see ...
3
votes
1answer
215 views

Converting a CSV with a WKT column to a Shapefile

Using ogr2ogr in Python, I am trying to convert a CSV to a shapefile. One column in the CSV, named "Polygon", contains WKT like this: POLYGON((long lat, long lat, long lat, etc.)) Currently, I can ...
3
votes
3answers
832 views

How are ESRI WKT projections different from OGC WKT projections?

Does anyone know the precise list of differences between esri wkt and ogc wkt projection format strings? I know there are various tools to help convert from esri wkt to ogc wkt, incl gdal utilities ...
0
votes
1answer
1k views

Using WKT.writeGeometry for 'Circle' Geometry in OpenLayers?

In my application which I'm building using OpenLayers3, I'm trying to extract the geometry of a feature to WKT using var format = new ol.format.WKT(); console.log(format.writeGeometry(geometry)); by ...
0
votes
1answer
278 views

Converting polygon feature class to WKT for ArcGIS [duplicate]

I am currently trying to export the geodata from a series of polygons in several .lyr files within my geodatabase in ArcGIS 10.2. I want to export the series of polygons within my layer as WKT (well ...