New answers tagged pgadmin3
You are looking for ST_Intersection, not ST_Intersects. http://postgis.refractions.net/docs/ST_Intersection.html also: http://postgis.net/docs/ST_Intersection.html If you have lines that intersect at multiple locations (sometimes it happens), you may need to look into ST_Dump to get all of those intersection points. The query might look like this (not ...
No and yes. You can configure pgadmin to call external programs, like shp2pgsql-gui, out of a menu option, which can make things easier for new users (see OpenGeo Suite, for example). But a full commandline like shp2pgsql has too many parameters needed to be effectively called by pgadmin.
Top 50 recent answers are included