#POSTGIS IRC Log - 2008-06-25

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
00:51:36 synsol: anyone alive in here?
07:43:09 jalmeida: in postgis exist some function for network, ??
07:43:40 jalmeida: similar to oracle database manager ???
07:44:44 bitnerd: jalmeida: I don't understand what you are asking / am not familiar with oracle databse manager
07:46:06 jalmeida: bitnerd, in postgis exist some finctionality for short and path ??
07:47:32 bitnerd: short = shortest distance along a network??
07:47:52 bitnerd: I still don't quite know what you are asking
07:49:16 jalmeida: yes sorry shortest path
07:49:39 bitnerd: do a google search on pgrouting
07:50:05 bitnerd: routing is not built in with postgis, but pgrouting is built on top of postgis and provides for routing functionality
07:51:43 jalmeida: ok , thanks
10:41:40 synsol--: can someone explain what an SRID is, does it have to be unique for every record?
10:42:31 bitnerd: no, in fact it generally is constrained to be the same for all records in a table
10:42:41 bitnerd: it is the Spatial Reference Identifier
10:42:58 synsol--: thats what i thought, since it is specified in the migration using georuby
10:43:05 bitnerd: it is a code that basically says what coordinate system the data is in
10:43:31 bitnerd: it refers to data that is stored in the spatial_ref_sys table
10:44:03 synsol--: what do you mean by coordinate system, like if all i was storing was long/lat info for google maps, would it all be the same SRID if it was using the same map
10:45:42 bitnerd: http://www.bostongis.com/?content_name=srid#82
10:45:47 sigq: Title: SRID, SRS ID: Spatial Reference System Identifiers ( at www.bostongis.com )
18:40:36 CIA-6: kneufeld * r2812 /trunk/lwgeom/lwpostgis.sql.in.c: ST_SnapToGrid SQL functions were referencing the deprecated SnapToGrid instead of their ST_.. equivalents.