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

0
votes
1answer
51 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
13 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 ...
0
votes
0answers
38 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 ...
0
votes
0answers
29 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"]], ...
2
votes
0answers
25 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 ...
1
vote
1answer
101 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. ...
0
votes
0answers
34 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
0answers
39 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 ...
1
vote
2answers
295 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 ...
0
votes
3answers
107 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
1answer
59 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 ...
2
votes
1answer
145 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 ...
0
votes
1answer
113 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 ...
0
votes
0answers
133 views

Code converting lat/long coordinates (WKT) to polygon (shapefile) not working

I am having a problem converting WKT to shapefile. I have a csv file consisting of three columns: ID, Name (of the area) and WKT comprising set of lat/long coordinates of area boundaries. For example, ...
1
vote
1answer
58 views

Valid shapely dumps WKT becomes None when used as input to QgsGeometry

I'm trying to produce a multipolygon feature in QGIS. I am producing filled contours with Matplotlib, taking the multipolygons representing each contour level, using shapely to produce WKT, and then ...
0
votes
1answer
121 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?
0
votes
1answer
36 views

How do I generate 3d WKT FROM A Sql Server geometry or geography types

If I have the point POINT (-75.45454 25.12345 1024 ) in a geometry or geography column in SQL Server, but render it with STAsText() I lose the Z dimension. SELECT geography::STGeomFromText('POINT ...
-1
votes
1answer
145 views

Adding a column of WKT format in the table (postgreSQL)

I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use? I need to create this database for mapping. There are about 30000 features ...
1
vote
0answers
96 views

Differences beetween proj4 string and WKT

What are the differences between proj4 strings and well-known text in terms of the ability to represent a projection, other than for WKT being more human readable?
0
votes
1answer
321 views

Understanding the format: WKB from WKT and how to convert the first into the latter

I don't understand which kind of format I have my data. The column name is wkb_geom, so I supposed that data were in WKB format, but then I was checking around and I couldn't find example of it. Data ...
1
vote
0answers
51 views

ogr2ogr latitute longitude conversion formats

trying to convert shape files into mysql tables. Able to create table and load data successfully using OGR2OGR. Only challenge I see is latitude/longitude is not exactly the same format as one of my ...
0
votes
1answer
679 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
79 views

Problem with importing WKT to PostGIS

I'm trying to import WKT (http://polygons.openstreetmap.fr/get_wkt.py?id=2413177&params=0 - boundary of one of districts of Łódź) into PostGIS database and convert it to geometry. I've created ...
0
votes
1answer
121 views

How can I get public transport maps in WKT format?

I can get street maps from openstreetmaps.org (XML) and convert it into WKT with the tool osm2wkt. There are several people creating specialist public transport maps: The Transport Map layer on ...
0
votes
1answer
257 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
0answers
54 views

PyQGIS - Syntax for importing WKT file

I couldn't find any proper example of how to import a .csv with WKT coordinates (Polygon) in PyQGIS. Here are more details on my .csv. I am working with polygons. The delimiter is a semi colum, and ...
0
votes
4answers
967 views

Fix Self Intersecting Polygons Manually

I are looking to implement a method to fix self-intersecting polygons by editing the vertex order. We want to take the polygon rings and re-arrange/add in vertices to make a valid polygon. This is ...
0
votes
0answers
109 views

How to add new SRS/Projection/WKT to the GDAL database

I'm using GeoServer, OpenLayers(3.0) and the GDAL utilities. GeoServer has one (or more) SRS/Projections that is/are NOT present in the GDAL database of SRS/Projections. I can get the well-known ...
3
votes
1answer
154 views

Why does projection WKT differ between osr.SpatialReference and gdalinfo

I am writing a simple geotiff using the GDAL python bindings, but the projection WKT reported by gdalinfo differs from the source. The script from osgeo import gdal, osr import numpy # Create ...
1
vote
1answer
161 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
83 views

How can I convert bytes to geometry?

Recently I have reviewed that postgreSQL provides support for Geometry objects in database. But in my old sql servers I have bytes data type for shape in database. Now I want to convert those bytes ...
0
votes
0answers
67 views

GeoServer GeoJson with coodinates in WKB?

I'm using a GeoJson query to GeoServer to update data in existing sqlite database used in an android app. The geometry column in that database is in WKB format, because like this the database is ...
0
votes
0answers
64 views

NDVI Web services over Victoria australia

Does anyone know of any web services that are available where you can pass...say a WKT polygon or point and return the mean NDVI or NDVI from that point from an array of the most recent NDVI runs?
1
vote
0answers
50 views

Max length for WKT name

First of all, sorry if this is obvious or stupid questions. I am not very familiar with geographic information system. My question is, is there max length limitation on WKT name? see the bold text ...
2
votes
3answers
540 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
0answers
73 views

strange result of spatial functions postgis

I have a problem with different result of spatial functions for same geometry. For some reason result I get when I use geometry from database is different then result when I load same geometry from ...
1
vote
0answers
99 views

How to change Axis Order when transfering data from WFS to Postgis DB

I am using GeoKettle to transfer data from a WFS service to a Postgis DB. The projection of the geometries is WGS 84 : GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", ...
3
votes
2answers
788 views

What is the best way to get from wkt to shapefile in Python?

I am querying tables from a SQL-Server database and would like to convert the table into a shapefile. It has wkt geometries and wkb as columns in the table, along with other attributes that need to ...
4
votes
5answers
264 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 ...
3
votes
1answer
213 views

Ideal file format for QGIS that allows mixed geometry types?

I have a spreadsheet for an archaeological project that is hosted on Google docs. This allows multiple contributors to edit and update the table as revisions and field data comes in. The table is not ...
0
votes
1answer
270 views

How to transfer a WKT string from OpenLayers to Geoserver or PostGIS?

Supposing I have created a Vector Layer in OpenLayers and then transformed it to WKT or GeoJson, how can I export it from OpenLayers, and possible import it to PostGIS or GeoServer?
9
votes
3answers
6k 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 ...
0
votes
0answers
136 views

R PostGIS convert SpatialPolygon to PostGIS table

I've been having some success in scraping some webdata and converting it from HTML to spatial data as originally asked here: Parse PHP/HTML to shapefile or similar I've been using R to both fetch the ...
1
vote
1answer
201 views

Java library for reading geojson from MySQL

I am looking for a way to retrieve mysql geometry data as geojson from the database either using a java library or for converting wkt to geojson using either java or javascript. Currently I am doing ...
0
votes
1answer
29 views

Is OpenLayers compatible with OGC WKT SRS definitions?

I'm trying to use WKT in OpenLayers. Proj4js seems to have no problem with this but the OGC definition describes the units as "US survey foot" whereas OpenLayers has an INCHES_PER_UNIT definition of ...
0
votes
0answers
175 views

Convert series of WKT to Shapefile

I have seen am ability in SQL Server 2008 Spatial Tools here that saves result of query as shapefile..I am intrested in how to do this task using C#..Is there any way to do this?I found ways to ...
1
vote
1answer
480 views

Convert WKT (or geojson) geometry to numpy array of coordinates

I am looking for the fastest way to convert WKT or geojson geometry from string to numpy array of coordinates. Is it possible to do it strictly in Python and without creating geometry object such ...
1
vote
1answer
222 views

WKT: What is the reasoning behind the concept of a POINT EMPTY?

In data formats like WKT and WKB, we have ways of representing "empty" geometries. That all pretty much makes sense: a "LINESTRING EMPTY" is a LINESTRING type with 0 vertices. Same with a MULTIPOINT, ...
3
votes
1answer
316 views

extract vertices from dbgeometry value

Who knows the elegant way to extract coordinates of polygon vertices from well known text representation of DbGeometry value? Here's my polygon for example: {POLYGON ((52.808019 -1.345367, ...
1
vote
0answers
71 views

from shape files to a database [closed]

I've previously converted simple shape files to WKT so that I can store them in RDMS that has spatial capabilities. I'm a new user to QGIS, which I'm using to browse a shape file. But now I have a ...