Forwarding as FYI, and to archive. -----Original Message----- From: Richard Moe [mailto:rlmoe@berkeley.edu] Sent: Tuesday, June 29, 2010 5:35 PM To: Patrick Schmitz Cc: Brent Mishler Subject: Re: [Talk] spatial capacity Hi Patrick: I have faked up find specimens within 3 miles and find specimens in a box I can draw so those are known to be useful. Find records inside National Park Boundary (or some other known shape or drawn polygon) is a search that is asked for but can't be obliged now. We have enough records with coordinates that implementation of spatial searches will be important. Spatial queries as part of data cleanup are interesting also: find records that don't seem to be in the counties they are supposed to be in. Find records on the same day that are more than 500 miles apart, etc. At the moment we have only data associated with point coordinates and error radii. Dick On Jun 29, 2010, at 5:12 PM, Patrick Schmitz wrote: > Hi Dick - > > Thanks for the question. The 1.0 release will not include spatial > search, although it should be smart about searching on geographical > entities that contain other entities (e.g., search for things by > county would find things in the contained cities), subject to the > hierarchic relationships in the Place authority. > > A high priority moving forward is a move to a PostgreSQL db and > support for OpenGIS (PostGIS) extensions to support proper spatial > queries. > We've had > some requests from various partners, but we will almost certainly come > back to you with questions about what functionality you need, whether > you already have GIS data and if so, in what form, etc. > > Have you already got some specific use-cases you need to be able to > satisfy? > Is it more like "find specimens within some distance of a place", or > "find specimens in a known polygon (for a county, region, geographic > feature)", or "find specimens in a polygon I can draw", or something > else? > > Thanks - Patrick > >> -----Original Message----- >> From: talk-bounces@lists.collectionspace.org >> [mailto:talk-bounces@lists.collectionspace.org] On Behalf Of Richard >> Moe >> Sent: Tuesday, June 29, 2010 4:28 PM >> To: talk@lists.collectionspace.org >> Subject: [Talk] spatial capacity >> >> Hi >> >> What will be CSpace's attitude towards spatial queries? >> searching on geographic polygons or shapefiles? >> >> Dick Moe >> >> _______________________________________________ >> Talk mailing list >> Talk@lists.collectionspace.org >> http://lists.collectionspace.org/mailman/listinfo/talk_lists.c >> ollectionspace.org >> >