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

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 ...
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
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 ...
0
votes
1answer
120 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 ...
0
votes
1answer
82 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
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
1answer
41 views

Failing to get wkt to reference for a multiline

I apologize, I'm quite new to WKT (and most everything else). I have a shape that I've exported to csv. & geoJson to be loaded into CartoDB. Unfortunately, the geoJson doesn't work so I am trying ...
0
votes
1answer
159 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 ...
5
votes
0answers
130 views

Is there a limit to the number of polygon points you can export to CSV in QGIS 2.4?

Using QGIS 2.4 I am currently importing a csv file with ~30,000 polygons (polygons in WKT format). I also have a United States shapefile. I have used the Clip function to get only the polygons that ...
4
votes
0answers
435 views

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

In answering this question, posed by @Burton449, I came to realize I don't have a definitive grasp on what distinguishes 2D, 2.5D, and 3D geometries. I certainly realize Z/elevation values are ...
3
votes
0answers
807 views

What is the best way to convert WKT String to GML String

What is the best way to programatically convert WKT String to GML String? Every reasonable library (at best available in some Maven repository) can be used. Till now I came up with this solution ...
3
votes
0answers
200 views

ArcGIS and SqlServer.Types: Does feature.Shape.SpatialReference.FactoryCode == srid?

I created a test implementation of the ESRI Geometry to WKT recipe provided by @SagebrushGIS. It seems to work great, but I'm wondering if the SRID value expected by Microsoft.SqlServer.Types ...
3
votes
0answers
709 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
36 views

EPSG codes and water level datums

I'm curious if, and how, people use EPSG defined water level vertical datums such as Mean Low Water. There is specific guidance to not use the OGP EPSG definition: Remarks: Users are advised to ...
2
votes
0answers
130 views

Working with WKT data in XML File in SQL Server

Anyone have experience with importing XML files into SQL server 2008 or 2012 that have a WKT element that includes the geometry for each feature? I can get this to easily work using FME software but ...
2
votes
0answers
348 views

QGIS 2.2 saving layer as CSV with GEOMETRY=AS_WKT not working

Just upgraded to QGIS 2.2 and it looks like saving a layer as CSV doesn't support GEOMETRY=AS_WKT anymore. The new Layer Options portion of the save dialog is cool but it looks like GEOMETRY and ...
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
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?
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 ...
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 ...
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 ...
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", ...
1
vote
0answers
193 views

Write WKT/WKB to File Geodatabase using FGDB API

Is there a way to set the geometry of a row using either WKT or WKB with the File Geodatabase API? Is there any other way to write spatial data to the file gdb using the fgdb api without having to go ...
1
vote
0answers
170 views

Trying to convert to EPSG:27700 (Ordnance Survey) projection, unable to do so

I'm trying to code an interface that allows a user to draw a vector shape on openstreetmap, which is then converted to a WKT string, processed by the server and sent of as a WFS query to emapsite ...
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"]], ...
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 ...
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, ...
0
votes
0answers
108 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 ...
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?
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 ...
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 ...
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 ...
0
votes
0answers
192 views

Using Terraformer to convert to WKT

I'm using Terraformer to parse some ArcGIS JSON into a Terraformer primitive. I'd like to store the geometry in PostGIS for other purposes. So I'm trying to use the WKT.convert tool to convert this ...