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
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 ...
3
votes
1answer
1k 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?
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 ...
4
votes
1answer
645 views

Adding a WKT specified coordinate system to ArcGIS?

I've got a WKT specified coordinate system, how do I add this to ArcGIS?
4
votes
5answers
877 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
0answers
467 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 ...
0
votes
3answers
403 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
0answers
226 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
1answer
223 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 ...
3
votes
1answer
781 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
4k 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 ...
1
vote
1answer
302 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
858 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 (-...
8
votes
1answer
11k views

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

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 ...
0
votes
1answer
3k 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 ...
3
votes
3answers
444 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 ...
3
votes
0answers
241 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
309 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
478 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 ...
10
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
2answers
2k views

Does OpenLayers3 support WKT format?

How can i show spatial data(Point, LineString,Polygon) on bing map using openlayer3?
2
votes
1answer
844 views

WKT for local mine grid

I have been trying to create a WKT entry to use in gdalwarp etc. I need an affine transform from coordinates in MGA94 Zone 54 to our local mine grid. All efforts have so far failed, including using ...
4
votes
1answer
486 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 ...
5
votes
1answer
442 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
666 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?
1
vote
2answers
719 views

Project WGS84 to Google using MapGuide and WKT

I'm having trouble projecting a simple WGS84 formatted layer over google maps. I can't find a good WKT "API" that not only shows parameters, but explains what each parameter is. The coordinate system ...
2
votes
1answer
653 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
72 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 "...
1
vote
0answers
469 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 ...
2
votes
1answer
3k 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 ...
3
votes
1answer
2k 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, ...
1
vote
2answers
2k 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... //...
2
votes
1answer
2k 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?
3
votes
1answer
4k 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, -...
5
votes
3answers
5k views

How to unproject WKT to WKT in .NET?

I have WKT in this format: GEOMETRYCOLLECTION(POLYGON((491990.250718 6212873.59755,491492.160493 6212904.94117,491265.64715 6212790.54445,491319.517251 6212550.36334,491579.624164 6212637.87553,...
2
votes
1answer
714 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
47 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
2k 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 52....
5
votes
1answer
5k views

Well-known text (wkt) validator

Is there anything like http://jsonlint.com or http://geojsonlint.com for WKT? How can I validate a complex WKT string, say e.g. a Multipolygon?
1
vote
1answer
337 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
0answers
211 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
553 views

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

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
1answer
92 views

Trying to read string-based binary (?) code into something like WKT to be read by a spatial database

I've recently received some parcel data that has "shape" columns which are strings by default and look something like this: "...
7
votes
2answers
6k 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,...
3
votes
2answers
2k 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 (...
0
votes
1answer
662 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 ...
1
vote
1answer
930 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=...
4
votes
2answers
434 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 ...
0
votes
1answer
247 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 ...