Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Importing with configuration: reg_2016_wgs84_new, public, geom, [myHome]/Limiti_2016_WGS84/Reg2016_WGS84/Reg_2016_WGS84.shp, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=4326
- Shapefile type: Polygon
- PostGIS type: MULTIPOLYGON[2]
- Shapefile import completed.
- select ST_IsValid(a.geom) from
- public.reg_2016_wgs84_new a
- where a.cod_reg = 6
- select a.*, St_contains(a.geom, ST_SetSRID(ST_MakePoint(45.462360, 9.185939),4326))
- from
- public.reg_2016_wgs84_new a
- where a.cod_reg = 6
- SELECT a.*, St_contains(a.geom, ST_SetSRID(ST_MakePoint(46.062340, 13.237270), 4326))
- FROM
- public.reg_2016_wgs84_new a
- where a.cod_reg = 6
- POSTGIS="2.4.4 r16526" PGSQL="100" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.1, released 2015/09/15 GDAL_DATA not found" LIBXML="2.9.4" LIBJSON="0.12" TOPOLOGY RASTER
Add Comment
Please, Sign In to add comment