Guest User

Untitled

a guest
Jan 17th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. 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
  2. Shapefile type: Polygon
  3. PostGIS type: MULTIPOLYGON[2]
  4. Shapefile import completed.
  5.  
  6. select ST_IsValid(a.geom) from
  7. public.reg_2016_wgs84_new a
  8. where a.cod_reg = 6
  9.  
  10. select a.*, St_contains(a.geom, ST_SetSRID(ST_MakePoint(45.462360, 9.185939),4326))
  11. from
  12. public.reg_2016_wgs84_new a
  13. where a.cod_reg = 6
  14.  
  15. SELECT a.*, St_contains(a.geom, ST_SetSRID(ST_MakePoint(46.062340, 13.237270), 4326))
  16. FROM
  17. public.reg_2016_wgs84_new a
  18. where a.cod_reg = 6
  19.  
  20. 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