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
27 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
80 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
24 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
63 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
30 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
0answers
27 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
18 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
61 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
69 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
89 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
35 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
273 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
52 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
67 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
120 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
41 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
330 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
62 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
85 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
101 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
48 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
51 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
45 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
57 views

OSGEO/GDAL and Rotated Pole Grids

I have a netCDF containing a raster in a rotated pole grid. I have a script for converting the desired information to GeoTiff, however it requires projection information in the form of WKT string. ...
1
vote
0answers
38 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
275 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
67 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
59 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
418 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
4answers
172 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 ...
2
votes
1answer
162 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
202 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?
5
votes
3answers
3k 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
97 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
143 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
22 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
138 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
357 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
119 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
209 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
66 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 ...
0
votes
1answer
35 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 ...
1
vote
1answer
597 views

How can I convert WKT to SHP?

Using ArcGIS, ArcInfo and fme, I would like to transform data which contains wkt geometries (points, lines and polygons) into SHP. Has anyone a workflow for doing such a transformation?
5
votes
0answers
83 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 ...
1
vote
1answer
377 views

How to create WKT file readable by QGIS 2.4.0

I am trying to create a well-known text (wkt) file that can be imported into QGIS ver. 2.4.0 Here's a minimal working example of the geometry I wish to represent. POLYGON((-125 52, -125 21, -98 21, ...
2
votes
1answer
229 views

Transform wkb to gml geometry using FME

Maybe (and probably) this is stupid question, but I am totaly new to FME and geometry conversion. I need to transform WKB field from SQLServer to GML geometry using FME software. How can I do this?
2
votes
0answers
30 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 ...
0
votes
1answer
511 views

Reproject WKT Polygon with Javascript

I have a polygon in WKT in EPSG:4326: polygonWKT = 'POLYGON((13.215179443359373 52.588032137196755,13.42803955078125 52.592620721000365,13.454132080078125 52.46897854656702,13.347015380859375 ...
1
vote
3answers
550 views

geography, geometry, distance, and wkt - PostGIS

I'm trying to understand the data conversions that happen in PostGIS when calculating distances in SRID 4326. Why is it that when I run on my marin_jobs points table: select cast (the_geom as ...
0
votes
2answers
717 views

Returning string from OpenLayers.Format.WKT write? [closed]

How to return a string from OpenLayers.Format.WKT write this.innerHTML = new OpenLayers.Format.WKT().write( layer.selectedFeatures[0] ); my full code is like this please suggest me... ...