New answers tagged sql
2
Ok, since the polygon seems to be inverted, here is the explanation:
Each polygon on a sphere has complimentary one that occupies everything else on the planet. They share the same boundary, and are described by exactly same vertices. Say, oceans and continents are described by exactly the same coastal line. How do geospatial systems distinguish between them?...
0
Came across this recently. I am not stating that this is the optimal solution for large-scale datasets. However, it is an alternative that is a little easier to interpret and understand than all the solutions using joins.
Performance-wise it worked out pretty well for me on a large dataset.
select * from <tableA>
where <tableA>.id not in (
...
1
To change the type of a column, you need to use ALTER TABLE. Use NULLIF to convert empty strings into NULLs:
ALTER TABLE MyTable
ALTER COLUMN geom
SET DATA TYPE geometry(geometry, 27700) -- or geometry(point, 27700)
USING ST_SetSRID(ST_GeomFromText(NULLIF(geom, '')), 27700);
0
According to Esri security support, this is a false positive:
Without additional information to indicate otherwise, this is a false positive as indicated in the application response.
AppScan only reads the HTTP 200 response code without validating the actual response body that indicates that the request is unsuccessful because the URL requested is invalid – ...
3
The syntax for exporting one table is the following
pg_dump --format plain --verbose --file /path/to_export.sql --table your_table_name your_db_name`
Be aware that most SQL syntax is common between database engines but because of some differences, do not expect to reuse a PostgreSQL dump within MySQL. You may experience failure to import.
You should better ...
0
I find thast using RecoverGeometryColumn adds the record to geometry_columnns, and also allows QGIS to read the table. However, ArcGIS cannot read the geometries in the table. Still looking for a way to issue a CREATE TABLE AS statement and have it be a valid table that other GIS products can read.
0
Oracle's TREAT() function solves this issue:
select
treat( sde.st_pointonsurface(sde.st_buffer(shape,0.05) ) as sde.st_geometry) as midpoint
from
active_transportation
This blurb actually describes the opposite of what I'm looking for (supertype to subtype, not subtype to supertype). But I still found it helpful:
The Oracle TREAT function allows ...
Top 50 recent answers are included
