I have a table with this data : x,y column 0 0,1 2,5 2,5 1,2 1 (they are random points) with this point how can i get the biggest area posible. Sample: select area(ST_GEOMFROMTEXT( ‘POLYGON( (0 0,1 3,5 3,5 1,3 1,0 0) )’ )) = 10 select area(ST_GEOMFROMTEXT( ‘POLYGON( (0 0,1 3,5 3,5 1,0 0) )&#…
Tag: spatial
Mysql use 2 functions in 1 query
I’m trying to use 2 same functions in 1 query which is this This uses only the first function and give right result for the first latlngs only. I need the row which is almost near to the 2 latlngs (the latlngs is just example don’t care if it’s wrong <3 ) I want it to Give me the row
Subquery returned more than 1 value – STIntersects
I have three tables 2x tables of observational point data with a point geom column (for different time periods) A table of hexbins across the study area, with a polygon geom column Both are in the …
Intersect two sf data.frames based on date and geometry using R
So, I have two R “sf” “data.frames”, one with millions of linestring geometries (vsr_segments: see below) and the other with 5 polygons (vsr_zones: see below). Each linestring has a datetime and each polygon has a unique date range. I’m trying to intersect the linestrings datafra…
Oracle – Coordinate extraction from vertices (first, last and all vertices)
For a given feature (line or area) and for all of its members I need to extract the coordinates of (1) all the vertices, (2) the first vertex and (3) the last vertex (3 separate queries to create 3 …
MSSql server jpa spatial exception
Is it possible to use sql spatial data in jpa? I ve MS SQL Server 2014 Express Edition. I m trying to use spatial data as follows; maven (pom.xml) dependencies; db dialect; spring.jpa.hibernate.dialect=org.hibernate.spatial.dialect.sqlserver.SqlServer2008SpatialDialect entity definition; @Column(columnDefinit…
SQL Geometry find all points in a radius
I am fluent in SQL but new to using the SQL Geometry features. I have what is probably a very basic problem to solve, but I haven’t found any good resources online that explain how to use geometry objects. (Technet is a lousy way to learn new things…) I have a collection of 2d points on a Cartesia…
MySQL INSERT/UPDATE on POINT column
I’m trying to populate my DB with geographical places of my country. One of my tables have 4 fields: ID[PK], latitude. longitude ande geoPoint EDIT `SCDBs`.`Punto_Geografico`; SET @lat = 18.469692; …