Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
43 views

SQL server seems to refuse to build Point at specific coordinate [closed]

I have a very odd problem here. At some time I was able to construct a Point in Java with the SQL server jdbc driver and insert it into a SQL server table. The WKT of the point should be: POINT (-...
1
vote
0answers
39 views

Implicitly convert Geometry to WKT string in PostGIS

Suppose I have a table defined as follows: CREATE TABLE gtest (name varchar, geom geometry); To insert, I am able to simply do this: INSERT INTO gtest VALUES ( 'Polygon', 'SRID=4326;POLYGON(...
0
votes
2answers
42 views

ST_GeomFromText fails on syntax error inside tuple of coordinates?

I am receiving the following error when trying to execute ST_GeomFromText(wkt) psycopg2.ProgrammingError: syntax error at or near "1187780.76" LINE 1: ...0822.05,(ST_GeomFromTEXT(POLYGON ((...
1
vote
1answer
51 views

Export MultiPolygon data as WKT from QGIS 3

I have the polygon data for the city of Kamloops in QGIS 3. When I try to copy features of this polygon and try to paste it over here: https://arthur-e.github.io/Wicket/sandbox-gmaps3.html I don't get ...
3
votes
2answers
54 views

Convert WKT coordinate reference system to PROJ4

I'm currently working on a better support of LAS 1.4 file format in the rlas R package. In LAS 1.4 format the CRS of the point cloud can be stored as a WKT string. For example this is what I read from ...
1
vote
2answers
86 views

Seeking for a solution to convert GeoTIFF to 3d WKT

I am trying to convert some DEM in .tif image to polygon geometries representing 3 dimensional triangles that is Well-known text (WKT) - 3D (x, y, z) I was able to use SAGA to convert my GeoTIFF ...
1
vote
1answer
32 views

State Plane Scale Factor in WKT

I need to convert an old-style projection file (created with Global Mapper) to a WKT format for use in my GIS program (ArcMap or GDAL or whatever). The problem is that my old-style projection file ...
2
votes
1answer
48 views

What is the history behind WKT and proj.4? [closed]

What is the history behind WKT and proj.4 formats for defining coordinate systems? Does one have advantages over the other? Why do both exist? I'm guessing they were developed independently for ...
1
vote
2answers
42 views

Need to zoom into a vector Layer of a multipolygon

I am getting a multipolygon coordinates from DB in WKT format. I am able show the same on the map. But the problem I am facing is while zooming to center of the Multipolygon. Is there any way to zoom ...
2
votes
1answer
97 views

Getting SRID Well Known Text (WKT) metadata from PostgreSQL?

The SRID metadata is showed by, e.g., this web page: Definition: Well Known Text (WKT) PROJCS["UTM Zone 24, Northern Hemisphere", GEOGCS["GRS 1980(IUGG, 1980)", DATUM["...
1
vote
1answer
236 views

ProjNet. Coordinate reference system transformation deviation

I have a project with C# that contains a CEFSharp viewer showing a webpage with a map that I've created.I'm trying to add a marker in the map sending the parameters from C# to a function in the ...
4
votes
1answer
78 views

Pretty-printing WKT strings?

Is there a tool that will pretty-print well-known-text strings? One that would accept for instance MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)), ((20 35, 45 20, 30 5, 20 35))) and output something ...
1
vote
1answer
318 views

Create geometry from WKT in FME

How to create geoemtry from WKT in FME? We have a csv file in WKT format: "ID";"GEOM" "1";"LINESTRING ( 15, 20 16, 20 21, 12)" "2";"LINESTRING ( 15, 20 16, 20 21, 12)" "3";"LINESTRING ( 15, 20 16, ...
0
votes
0answers
74 views

Getting well known text from varchar in redshift.

As you know, redshift does not support geometry types. There is a column in a dataset on my redshift db that has varchar column and the format looks like: ...
0
votes
1answer
178 views

including SRID in WKBWriter in Shapely doesn't work

I want to encode coordinates of LineString in WKB with the SRID included wkbwriter = shapely.geos.WKBWriter(shapely.geos.lgeos, big_endian=False, include_srid=True) geo = wkbwriter.write_hex(...
1
vote
1answer
64 views

Visualising multiple points using QuickWKT plugin in QGIS?

Using the QuickWKT plugin in QGIS, a command of the form POINT (30 10) draws a point at the desired location. However, how can I achieve to draw multiple points in one go? I am looking for something ...
3
votes
1answer
248 views

SQL WKT draws well with geometry, but not with geography data type

I have a following piece of code DECLARE @g geometry; DECLARE @borders geography; SET @g = geometry::STGeomFromText('SOME WKT', 0); SET @borders = GEOGRAPHY::STGeomFromText(@g.MakeValid()....
1
vote
1answer
112 views

How to obtain a WKT from a DotSpatial IFeature geometry?

I am using DotSpatial 1.9 and I have a feature (sourced from a shapefile). According to the docs, I should be able to call: ToString() on IFeature. // // Summary: // Returns the Well-...
2
votes
0answers
167 views

Storing Shapely polygons in MySQL

I have to store some polygons in a MySQL database. The polygons are in Plate Carrée (ESPG 32662) projection, but I also tried to first converting them to the usual latitude-longitude projection (ESPG ...
0
votes
1answer
80 views

GeoTools and GDAL: CRS WKT

I would like to achieve the same output as for GDAL using the GeoTools library: CoordinateReferenceSystem crs = CRS.decode("EPSG:32632"); String wkt = crs.toWKT(); System.out.println(wkt);...
4
votes
0answers
501 views

When does WKT orientation matter for polygon and multipolygon in geography spatial (left/right hand rule, counter-clockwise, clockwise)

I've decide to use sql server on Azure for my gis database. I'll be dealing with spatial Geography not Geometry. While inserting some country boundaries using the spatial data in SQL Server, some ...
0
votes
0answers
61 views

Get coordinates from web mercator projection to Lan & Lot (JavaScript/ node.js) [duplicate]

I have the WKT coordinates like below. LINESTRING (16139582.976129573 -4541142.959679384,16139974.715899538 -4540837.211566243) How can I get the Longitude and Latitude from that. I am using ...
1
vote
1answer
147 views

Converting coordinates in metres to Longitude & Latitude (CRS conversion) in OGC WKT format?

I have two tools that produce output in OGC WKT format. But they look different. Could you please explain this(I am very new to GIS). For my project I want the coordinates in the second format. Is ...
1
vote
1answer
71 views

How to create geom object from list of lat long coordinates

I have this geometry key that looks like this from which I want to create a Geom object so something like this MultiPolygon(((-xx.73833882299999 yy.41161324700006, -xx.73826573899998 yy.41172750400005....
0
votes
1answer
166 views

Athena: querying GeoJSON

Let's say I have a dataset with one column being GeoJSONs encoded as string. AWS Athena supports ESRI and hence geo queries on geometries: https://docs.aws.amazon.com/athena/latest/ug/geospatial-...
2
votes
1answer
116 views

PyShp error: Object does not implement __geo_interface__

I'd like to convert geometry to WKT with pyshp and pygeoif using this suggestion, but pyshp throws a following error: Traceback (most recent call last): File "E:/!Projects/imScrape/...
0
votes
1answer
78 views

Converting CRS?

I am trying to convert an N-triple RDF file which has geometries with WKT which use EPSG/3857 and I need to convert all WKTs to EPSG/4326 (I think it is the same as WGS84). As a first step, I tried ...
1
vote
1answer
80 views

fromWKT - how to pull all info from source data?

I have a CSV storing addresses, reference numbers, etc... and also a WKT string of boundary coordinates for each property: The script (ammended from another user's post in 2012) sccessfully converts ...
2
votes
1answer
182 views

PyQGIS - How to import WKT string from a CSV to a polygon shapefile? [duplicate]

In QGIS, I can add WKT data stored in a CSV by clicking the 'Add Delimited Text Layer' tool and setting it to 'WKT'. This works fine: But how can I do it as a python script? Ideally I'd like a ...
1
vote
0answers
36 views

Getting information on geo file projection in Python?

I have many geo files with different extensions, from different sources (mid/mif, shape, geojson, dat). I'd like to get information on their projection (i've no access to epsg code). Maybe, I search ...
3
votes
3answers
209 views

Plain geometry editor for QGIS 3.0?

In QGIS 2.18, I had been using the plugin "Plain Geometry Editor" to view, copy and paste the WKT geometry of features (as a solution to this question). However, this plugin is not available for QGIS ...
2
votes
1answer
576 views

is it possible to open a geotiff file in python without using gdal?

Trying to get gdal and whichever associated python bindings installed with the oldish OS my company uses is extremely painful, especially so in ci/cd and testing situations. I keep coming across ...
0
votes
0answers
92 views

EPSG WKT Rasterio

I have a question regarding the warping options in rasterio. I have two raster datasets from Albania. The first raster is the product of a clipping, and the second one is the country's boundaries. For ...
0
votes
1answer
118 views

WKT to shapefile using arcpy

I'm trying to convert WKT from an API to a shapefile via arcpy (there is a requirement to use the ArcGIS GUI) and am unable to get arcpy to create the shapefile. My code: def create_shapefile(self, ...
0
votes
0answers
130 views

What does wkt in GDAL intersection method do?

I don't think I understand WKT in the GDAL intersection method. When we use it are we suppose to change the numbers? from osgeo import ogr wkt1 = "POLYGON ((1208064.271243039 624154.6783778917, ...
0
votes
0answers
114 views

How to display CSV with WKT in ArcMap

I have been given a CSV which has a mixture of point and polygon data. I am trying to open this up in ArcMap 10.5.1 I have no idea what I should be doing! I have tried to look for answers online ...
1
vote
0answers
50 views

Reduce coordinate precision in MSSQL WKT

When you use the AsText() function on geometry objects in MSSQL Server 2008+ you get something like this: "LINESTRING (8.8446177236171337 47.721989356913951, 8.844617919281065 47.721977134398223, 8....
2
votes
1answer
320 views

Is MULTICURVE geometry in WKT valid according to the standard and open source community?

We are using Oracle function (SDO_UTIL.TO_WKTGEOMETRY) for exporting geometry to WKT. Some geometries have MULTICURVE in WKT, like this one: MULTICURVE (COMPOUNDCURVE (LINESTRING (3451418.006 5481808....
2
votes
1answer
170 views

Reduce geojson/wkt source data density

I have administrative boundary data in geojson/wkt format, which I retrieve from my REST service and display, using mapbox gl. This works well enough, but the data points are (depending on the country)...
0
votes
1answer
103 views

Polygons in CSV, WKT coordinate order

I have a text file with the data: 98923|Place1|31.144562;33.741344:31.171932;33.873543:31.103771;33.884808:31.073994;33.786865 342342|Place2|36.995064;7.632923:36.995880;7.849720:36.832218;7.848527:...
8
votes
5answers
736 views

Is there a way in QGIS 3 to get a selected feature WKT?

In QGIS 2.x, I used the getWkt plugin: https://github.com/hugoledoux/QGIS-getWKT to get a WKT of a selected feature. But that plugin isn't present in QGIS 3.x. Was that capability built into core ...
1
vote
1answer
292 views

Read a CSV with two Polygons(WKT) with GDAL

I am trying to read a CSV file where the geometries of neighbouring polygons are stored in couples. The file looks like this. I usually read shapefiles in GDAL using the following syntax ...
1
vote
1answer
176 views

arcpy FromWKT to functioning in_memory layer to be used in geoprocessing tools

As part of a larger script I am extracting postgis geometries from WKT(got that part down) then I am trying to create an in_memory polygon geometry to be used in arcpy tools. so far: ...
1
vote
1answer
690 views

Converting GeoJSON pixel coordinates to lat long coordinates for use with Google Maps API?

The entire process is quite a bit more complex than the question, so let me briefly describe it: An SVG overlay of map features is parsed. Each path is converted to WKT using SVG-to-WKT and then ...
-2
votes
1answer
63 views

How do I get the location from an unidentified coordinate system point?

I'm working in C# and I have this JSON: {"id":429,"name":null,"address":"10 Wooleys La.", "city":"Great Neck", "decadeBlt":0,"totalUnits":12,"propertyType":null, "yea‌​rBlt":0,"expectedCom‌​pletion":...
1
vote
1answer
78 views

How to use old WKT(version1) coordinate reference system in ArcGIS Desktop?

I have a local coordinate reference system defined with WKT: COMPD_CS[ "test", FITTED_CS[ "", PARAM_MT[ ...
4
votes
2answers
546 views

gdalwarp cutline without using a shapefile

I'm currently working with gdalwarp to split some tiffs. gdalwarp -cutline file.shp -dstalpha -of GTiff image.tif split_image.tif I wanted to know if I can use an other source rather than use a ...
2
votes
1answer
204 views

st_astext generate an invalid wkt in postgis

The query: select st_astext(dn_geom), st_isvalid(dn_geom), st_area(dn_geom) from t$table Generates an incorrect WKT from a geometry apparently valid: POLYGON((-2.96954161967213 41.4400844183428,-...
1
vote
3answers
129 views

Listing coordinates of polygons in WKT format

I have a polygon shapefile made up of 2 shapes (independent of each other). I'm using the code below to print in the ArcMap python console, a list of each shapes coordinates in WKT format. I get an ...
1
vote
1answer
155 views

Understand way field (type geometry) in planet_osm_polygon

I'm new to QGIS and I'm using PostGreSQL and QGIS DB Manager to get information from the polygon_osm tables. I'm currently working on the _polygon table and I'd like to get the coordinates for each ...