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
1
vote
0answers
219 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 ...
4
votes
2answers
8k views

Convert WKT to GeoJSON with leaflet

I have a point type WKT geometry column in a MySQL table storing the location of some stores. I want to display it on a leaflet map on my website. I've found plenty of tutorials to doing this on ...
1
vote
1answer
218 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
759 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
3k 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
291 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
839 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
10k 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
2k 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
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 ...
3
votes
0answers
239 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
303 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
471 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
823 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
478 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 ...
4
votes
1answer
436 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
659 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
717 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
644 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
71 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
464 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
2k 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 ...
2
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
3k 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
703 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
334 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
210 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
552 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
90 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
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,...
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 (...
0
votes
1answer
645 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
897 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
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 ...
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 ...
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?
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 ...
0
votes
1answer
547 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
201 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
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 (...