I'm still getting the hang of some of the finer points of creating queries in PostGIS, as is probably obvious with my last post.
I've two tables, parcel2 that is a collection of parcels in a county and a table election, which is a table of voting precincts in the same county. I'd like to select all of the parcels in each precinct. I have this query: select precinct, sit_st_num, sit_st_dir, sit_st_nam, sit_st_typ, city_code from election, parcel2 where ST_contains(election.the_geom, ST_pointonsurface(parcel2.wkb_geometry)); This gets the job done, but it's very slow. What can I do to speed this up? Eric -- View this message in context: http://www.nabble.com/I%27ve-got-a-silly-question-about-performance-tp14910258p14910258.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
