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
2answers
442 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 ...
2
votes
3answers
218 views

How to change 0,360 WKT string to -180,180?

I'm reading POLYGON WKT strings using OpenLayers.Format.WKT().read(). The polygons use 0,360 longitudes but my map is -180,180. When I display the polygons on the map they are displayed outside of the ...
1
vote
2answers
347 views

How does MYSQL accept the WKT representation of a polygon with holes?

I have a set of coordinates that creates a polygon with holes in it. I'm using qgis with mmqgis to extract. How does MYSQL accept the WKT representation of a polygon with holes? By holes I mean ...
2
votes
2answers
923 views

How to read csv with WKT geometry in Arcmap?

I have found several parcels I need on a county map viewer. However, the only option to download any of the data is found on a click context menu to "Copy selection as csv" which gives me this: ...
0
votes
1answer
278 views

OpenLayers - changing layer type (wms to OSM) and WKT transformation problems

I've created the very simple tool which utilizes OpenLayers.Format.WKT with DrawFeature - polygon and ModifyFeature together, so I can create and modify, load and save polygons in/from WKT format. ...
2
votes
1answer
514 views

Detecting invalid WKT in text column in SQL Server

I've got a whole load of WKT data in a SQL Server table, of which I'm trying to detect the validity. I'm currently doing a query like this: UPDATE f SET f."CurrentGeomValid" = ...
3
votes
0answers
110 views

PostGis functions vs. EWKT [duplicate]

While using PostGis, we can query using EWKT format like: SRID=4326;POINT(lon lat) or use the functions defined by PostGis itself. For example: ST_SetSRID( ST_MakePoint( lon , lat ) , 4326 ) I'm ...
1
vote
0answers
124 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 ...
0
votes
1answer
942 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 ...
3
votes
2answers
461 views

Google Maps Polygon to WKT

I need to convert a Google Maps polygon object (can has multi paths and holes) to wkt string (multipolygon) at client. Then i'll able to save polygon as geography in Sql Server 2012. I tried Wicket ...
2
votes
0answers
130 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
0
votes
0answers
28 views

How to convert EPSG:900913 or EPSG:4326 to EPSG:27700 using Proj4js (or to set displayProjection to EPSG:27700) [duplicate]

I'm using openlayers to create a vector feature (e.g. polygon, point) and i would like the geometry values of these vectors to be stored as EPSG:27700 coordinates (so when i send them off in WKT ...
1
vote
0answers
126 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
1answer
339 views

How to convert drawn vector feature from EPSG:900913 to EPSG:4326

My script allows you to drawn shapes on an openlayers map, and then to get the WKT information from that shape, except the returned coordinates are in 900913 and i need them to be in lat/lon. thanks
3
votes
2answers
2k views

Is there any efficient way to convert Geojson to WKT?

I want to use ST_GeomFromText() to load vector data to PostGIS. However, I don't know how to convert from Geojson type to WKT. N.B. I know I can use OGR2OGR to upload the geojson directly, but I just ...
1
vote
2answers
85 views

WKT number format inconsistent?

The WKT specification allows both period and comma to be the decimal separator in floating-point numbers (section 7.2.1): <decimal point> ::= <period> | <comma> However, a ...
6
votes
2answers
2k views

Are there any online WKT editors?

I've been using QGIS and it's great. However, we can't use that because it has to be installed (please, don't ask). Instead, what we need to do are very simple administrative boundary drawings over a ...
0
votes
2answers
214 views

How can I find the SRID from the WKT out of a GRIB file?

I have a grib2 file which I'm trying to import into PostGIS 2.0 Raster and process. Trouble is, I can't figure out what the SRID is supposed to be, or one close enough for government work. Running ...
5
votes
5answers
817 views

javascript WKB to WKT function

Turns out json ain't so good at transporting binary data. But with HTML5, XHR2 is now capable of transferring blobs cleanly. I'm looking to transfer binary geometry (to save bandwidth) and decode it ...
1
vote
1answer
213 views

ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?

In the system I'm building, we've got a facility that can be represented as either a point, or a point within a polygon (the point in the polygon may or may not be the polygon's centroid). I'm using ...
1
vote
2answers
212 views

QGIS on Mac WKT import problem

QGIS 1.8.0 Mac OSX 10.6.8 These problems seem to be specific to Mac, as two Windows users don't have the problem. Import a file as a vector: TEST.CSV id;wkt 1;"POLYGON((10 10,20 20,20 30,20 ...
6
votes
4answers
2k views

How to convert geometry to WKT using ArcPy?

I would like to be able to convert a single feature (or potentially many features) in an ArcGIS layer into Well Known Text (WKT) format during a geoprocessing operation using Python and ArcPy (no ...
1
vote
2answers
549 views

Plotting large numbers of objects on a chart using R and WKT format

I am retrieving thousands of geometry lines in WKT format from a Microsoft SQL Server database. I would like to plot all of those lines in one map, but I am having some difficulty with the code. How ...
4
votes
0answers
247 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 ...
0
votes
0answers
57 views

How a PHP script can perform point, line and polygon operation on Geoserver and PostGIS (+wkt) [duplicate]

I want to show my shape file and LULC map (vector and raster data) on internet explorer (locally). How should I configure PHP and Geoserver so that I can show data on localhost on an IE or browser? It ...
2
votes
1answer
514 views

Can you explain this WKT multipolygon format?

I am confused by the output I'm getting from ogr2ogr when converting a shapefile to WKT. What I'm expecting to see is something in the form below (from Wikipedia): MULTIPOLYGON (((40 40, 20 45, 45 ...
2
votes
1answer
4k 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)), ...
3
votes
4answers
740 views

converting oracle geometry to postgis with 3d data (wkt?)

I am converting Oracle spatial database to postgis. Most of of the spatial data is 2.5d. Meaning we have a Z-coordinate which indicates the depth/height of the element compared to soil level. Getting ...
3
votes
0answers
485 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 ...
7
votes
2answers
1k views

Converting KML files for use with Python library Shapely

I am trying to get a KML-file (wijken.kml) into Shapely. The KML-file is validated against the proper XML schema, so I guess the input is correct. Routes I have tried: 1) Converting to WKT or WKB ...
1
vote
1answer
288 views

Point plus distance along great circle using RGeo or WKT

I'm racking my brains (and google) trying to figure out how to get RGeo to do the following geospatial calculation: Imagine I start off at some arbitrary geographic point (let's say (45, 45) which ...
0
votes
1answer
219 views

Geostationary satellite projection to be introduced in GDAL

I'm working on raster files and their spatial reference system is: PROJCS["Geostationary_Satellite", GEOGCS["GCS_Unknown datum based upon the custom ellipsoid", DATUM["D_Not specified ...
8
votes
1answer
1k 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 ...
3
votes
1answer
203 views

How can I get KML into JTS TestBuilder?

JTS Topology Suite TestBuilder supports WKT, WKB and GML inputs. What's a quick and easy way to get the geometry for a KML feature into one of these formats for input into JTS TestBuilder? For ...
0
votes
1answer
1k views

OpenLayers: Showing WKT data via JSON from MVC

I am trying to read geographic data from MS SQL Server 2012 and display it using the JavaScript library OpenLayers in an MVC4 view. I can confirm that the data leaves MVC OK but I have problem is ...
1
vote
2answers
284 views

SQL Server STpointfromText comes from PHP into javascript as garbage

Sorry for the sloppy title. Here's the scenario - I have a table in SQL Server 2008 R2 It has a geographyColumn, created thusly: add geographyColumn as ...
8
votes
1answer
5k views

Create a csv with geometry as WKT in QGIS (and choosing the field delimiter)

Is there a way to choose the field delimiter when exporting to CSV with geometry as wkt in QGIS? I have a shapefile with donut holes and I'd like to export it as a CSV. It's for a partner whose DB ...
3
votes
3answers
433 views

I have a list of coordinates that make up a route - how can I easily render this shape on a map?

Additional info - I don't need this to be on a map - I just need the shape of the route. Is there anything that can return that shape easily? The list of coordinates are in an xml document and I'd ...
3
votes
1answer
2k 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, ...
2
votes
3answers
2k views

how to extract lat long from WKT data?

i want to extract lat long form WKT data and stores into arary list i have tried one solution which is proposed by a user but it has some problems String str = tv.getText().toString(); str = ...
1
vote
1answer
402 views

Mapnik WKT rendering problem

I have a rendering problem with the mapnik GEOS plugin. I try to input a polygon WKT definition containing floats with around 16 digits. Mapnik however does not render these. When I decrease the ...
1
vote
1answer
156 views

How can I Transfer mysql wkt directly into a postgis table?

I have wkt geometry data in mysql stored in blob format. I need to get this data into a postgis db and am looking for the quickest-easiest way to do it. I have managed to select the data "ASTEXT" but ...
3
votes
0answers
176 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 ...
2
votes
0answers
459 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 ...
1
vote
1answer
204 views

What are AGF Files, how do we put them in PostGIS?

I came across term which says AGF, after Googling I found its Autodesk Geo Files, But some other say, Atlas Geo Files, Which one of them is right. I also came to know that It is an extension to WKT ...
7
votes
1answer
255 views

What are the differences between the OGC and ISO WKT/WKB specification?

Are the OGC-Simple feature access and the ISO (ISO/IEC 13249-3:2011 "Information technology - Database languages - SQL multimedia and application packages - Part 3: Spatial") significantly different ...
4
votes
1answer
1k views

Write out a WKT file from a loaded shapefile

We are looking to load and display a shapefile, simple polygons, then write out a WKT string of that shapefile and have the user save it somewhere. Does anyone have some code snippets of that very ...
3
votes
1answer
321 views

SQLServer generating invalid WKT

I am a GIS novice using SQL 2008, with C# and the NetTopologySuite WKTReader type to work with some geometries. I have some data which I have been able to save into the database but when I read back ...
3
votes
1answer
204 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
1answer
297 views

Shape looks like big Square in SQL Server 2008

I was provided with a polygon defined in WKT which has 4741 points and am able to insert it as a geography data type within a database in SQL Server 2008. However, when I view it using the spatial ...