Stack Overflow
Stack Overflow

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.

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. A binary equivalent, known as well-known binary (WKB) is used to transfer and store the same information on databases, such as PostGIS, Microsoft SQL Server and DB2.

The formats were originally defined by the Open Geospatial Consortium (OGC) and described in their Simple Feature Access and Coordinate Transformation Service specifications. The current standard definition is in the ISO/IEC 13249-3:2011 standard, "Information technology -- Database languages -- SQL multimedia and application packages -- Part 3: Spatial" (SQL/MM).

http://en.wikipedia.org/wiki/Well-known_text

185 questions
3
votes
0 answers

SQL Server 2012 WKT differs from OGC specification

It is said that SQL Server is following OGC standards. In SQL Server 2012 WKT representation of a 2D point (e.g. 10,10) with measure value (e.g. 40) is like this: "POINT (10 10 NULL 40)" however in OGC it is defined as follow: "Point M (10 10…
Hossein Narimani Rad
  • 31,361
  • 18
  • 86
  • 116
3
votes
5 answers

How to handle WKT data in Android?

I have data in this format: POINT(73.0166738279393 33.6788721326803) MULTILINESTRING((73.0131224998036 33.679001500419,73.0119635003153 33.678392400389,73.0119205001311 33.6783781002692),(73.0131224998036 33.679001500419,73.0136031002029…
Sarah Salar
  • 193
  • 1
  • 3
  • 14
2
votes
1 answer

PHP Validate WKT values

I'm trying to validate data passing between client/server for a location-based application and I can't find any way to validate WKT strings in PHP. I'd prefer not to implement it myself, not because I'm lazy or incompetent but because I'm afraid of…
meustrus
  • 6,637
  • 5
  • 42
  • 53
2
votes
0 answers

How to use mysql spatial with prepared statements

I've got two scenarios, using the following statement: INSERT INTO areas (name, polygon) VALUES (?, POLYGON(?,?,?,?,?,?)) Will result in errors like this: Illegal non geometric ''58.03665463092348 14.974815566795314'' value found during…
Bisa
  • 154
  • 1
  • 1
  • 9
2
votes
1 answer

How to get coordinates from wkt MultiPolygon

I have a MultiPolygon list in wkt format and I have to get the coordinates from those points. Could anyone help me please? Thanks in advance
Alberto Sanmartin Martinez
  • 970
  • 13
  • 37
2
votes
2 answers

How to filter WKT strings with invalid geometries in pandas or GeoPandas

I'm trying to convert an Excel file into a GeoPandas dataframe. I'm trying to use Shapely and WKT to do so. After reading the file into pandas, I have a geometry column. I'm trying to do the following to convert the geometry column to an 'object'…
Erich Purpur
  • 1,337
  • 3
  • 14
  • 34
2
votes
0 answers

How do you convert Geometry in WKT to GeoJSON?

I'm looking for a package / library in Scala where you can convert Geometry in WKT to GeoJSON. Thanks alot
Jonah Nio
  • 31
  • 1
2
votes
1 answer

Parse WKT strings to get array of points

POLYGON ((162353.9901277053 564298.9605047705,162352.3101277038 564286.9905047683, 162353.9901277053 564298.9605047705)) output need [[162353.9901277053, 564298.9605047705], [162352.3101277038, 564286.9905047683],[ 162353.9901277053,…
BKS
  • 21
  • 1
  • 3
2
votes
3 answers

How to read, plot and convert WKT to table in R?

I have a WKT file with a few hundred POLYGON((...,...,...)) entries. Is there an R package to read, plot and convert such data? I did not find anything explicit. Just want to avoid working with strings when there might be a more elaborate existing…
user7295926
2
votes
0 answers

Directly read a zipped shapefile using DotSpatial

I have an application in which users can upload a shapefile which is then converted to WKT in C# and saved to the database. I'm using DotSpatial for this purpose. In this case, I can use the following code and then proceed to do what I…
Raj
  • 315
  • 4
  • 15
2
votes
1 answer

Populate polygon from Microsoft.Maps.WellKnownText [ WKT ] on Bing map

I am trying to populate polygon on Bing map from the code below. But it doesn't draw polygon on the map at all. Please check the code below and let me know what am I missing ? Please note the credentials I set xxxx for security…
user740022
  • 39
  • 1
  • 8
2
votes
1 answer

Pandas DataFrame: convert WKT into GeoJSON in a new column using Lambda function

I have some data in this format: Dep Dest geom ---- ---- ----- EDDF KIAD LINESTRING(3.961389 43.583333, 3.968056 43.580.... Which contains flight trajectories. The geom column contains the coordinates in WKT…
Ulu83
  • 523
  • 9
  • 20
2
votes
2 answers

Store circles in Postgres geometry field

Ideally it would be something like this, but WKT doesn't have circle type. ST_GeomFromText('CIRCLE(10 20, 10)',4326) Although, circle type is listed among geometric types, circle <(x,y),r> (center point and radius) I wonder if it's possible to…
karser
  • 1,625
  • 2
  • 20
  • 24
2
votes
1 answer

Saving arc or fan to postgis as geometry

How would I save the following in a postgis geometry field? How would the WKT look like for the arc or fan. Is there a ARC well known text to save this?
Theuns Heydenrych
  • 449
  • 1
  • 4
  • 12
2
votes
1 answer

Efcore Spatial Query: A number is expected at position 9 of the input. The input has @p0. -

I'm trying to get around the fact that Entity Framework Core doesn't have support for Spatial Types by using the DBSet.FromSQL Method, and hand rolling a migration to add a geography column on SQL Server. Here's my DataContext public interface…
MrBliz
  • 5,830
  • 15
  • 57
  • 81
1 2
3
…
12 13