Questions tagged [wkt]

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.

Filter by
Sorted by
Tagged with
0
votes
2answers
2k views

Converting WKT to WKB in Java using PostGIS?

How can I convert a WKT string to a WKB byte[] in Java using PostGIS functions? I need to save that WKT string in a PostGIS database (geometry column.
0
votes
1answer
641 views

Probably base64 encoded WKB - Reading in QGis/ArcGIS?

I have a probably base64 encoded WKB string. How would I load that feature represented by the string into QGis or ArcGIS? I found the QGis QuickWKT plugin, but that does not handle my base64 encoded ...
0
votes
1answer
1k views

get wkt from geometry in lat lon format

Using the plane geometry editor plugin in qgis 2.0, WKT representation of a feature is shown. The result is in the lon1 lat1,lon2 lat2 format. e.g. POLYGON((85.43523762804622379 27.69592296476042037,...
1
vote
1answer
2k views

Converting GeoJSON to WKT with OpenLayers2

I was just wondering if there was a good way to convert GeoJSONdata to WKT data using OpenLayers. The method I've tried is to create a Feature.Vector with the GeoJson and then tried using WKT.write(...
1
vote
1answer
894 views

add wkt representation of the geometry as field in qgis

I have the shapefile of boundaries loaded in qgis. I want to add a field in the file which is WKT representation of the feature. Update As Nathan W answered I used geomToWKT( $geometry ) and got ...
2
votes
1answer
194 views

How to construct geographies from WKTs

I am using a SQL Server 2012 database. I have noticed that geometries and geographies interpret WKTs differently. For instance, if I construct a square polygon, clockwise: DECLARE @geom Geometry=...
2
votes
3answers
1k views

OpenLayers is very slow when using WKT multipolygon with a large number of points

I'm showing the boundaries of Cyprus regions using OpenLayers with vector layer, I get the coordinates from a shapefile which has a lot of points, for instance some regions can have a multipolygon ...
4
votes
2answers
433 views

can Well Known Text tables be used effectively, stored in Access or Base?

My question is: How do I import WKT text data back into QGIS, and how useful could Base or Access be in storing the data using WKT rather than spatially enabling it within a proper GIS database, like ...
2
votes
1answer
312 views

How can i programmaticly get the WKT from WKID?

Is there some way (in C#/silverlight) to get the WKT from some web service with just the WKID?
0
votes
1answer
243 views

Mapguide and OpenLayers SRS WKT

I am trying to create OpenLayers vector features based on WKT strings that I retrieve from a MapGuide server. I have successfully gotten the proper geometry to be rendered, but I do not know how to ...
1
vote
1answer
333 views

Represent full globe in Oracle Spatial

In SQL Server 2012 I can do this: -- Construct a new FullGlobe object (a WGS84 ellipsoid) DECLARE @Earth geography = 'FULLGLOBE' -- Calculate the area of the earth SELECT PlanetArea = @Earth.STArea()...
2
votes
3answers
2k 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;")...
3
votes
3answers
443 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 ...
2
votes
2answers
1k 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 ...
7
votes
2answers
5k 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: HGID,...
0
votes
1answer
546 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. I'...
5
votes
1answer
3k 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" = geometry::...
3
votes
0answers
200 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
413 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
1answer
4k 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
1k 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
229 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 OpenLayers,
1
vote
0answers
204 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
961 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 EPSG::900913 and I need them to be in lat/lon.
9
votes
2answers
7k 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 ...
2
votes
2answers
450 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 comma ...
14
votes
2answers
17k views

Seeking online WKT editor?

We need to do are very simple administrative boundary drawings over a (insert fav map here) via some website. Our requirements are: click to create points which then form a polygon drag existing ...
1
vote
2answers
701 views

Finding SRID from WKT out of 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 ...
9
votes
6answers
4k views

WKB to WKT JavaScript function

Turns out json isn'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
417 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
507 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 10))"...
13
votes
4answers
11k views

Converting 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 non-...
4
votes
2answers
2k 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 ...
5
votes
0answers
1k 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 ...
2
votes
1answer
3k 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 30,...
12
votes
2answers
21k 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
2k 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 ...
5
votes
1answer
2k 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 ...
8
votes
2answers
7k 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
568 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 ...
1
vote
1answer
1k 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 (...
19
votes
1answer
9k 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
434 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 ...
1
vote
1answer
2k views

OpenLayers2: 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
620 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 geography::STPointFromText('POINT('+convert(...
12
votes
2answers
20k views

Creating CSV with geometry as WKT in QGIS (with choosing field delimiter)

Is there a way to choose the field delimiter when exporting a 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
2k 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 ...
7
votes
1answer
16k 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....
4
votes
3answers
6k 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
797 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 ...