Changes between Version 21 and Version 22 of GoogleSummerCode
- Timestamp:
- Feb 17, 2014, 11:45:02 AM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
GoogleSummerCode
v21 v22 73 73 Mentor: Regina Obe[[BR]] 74 74 75 Skills required: C /C++, PL/pgSQL, knowledge of PostGIS and PostGIS topology75 Skills required: C, PL/pgSQL, knowledge of PostGIS and PostGIS topology 76 76 77 77 In writing chapters of the book, one exercise is to load the data with shp2pgsql and then a second step to load into a specific topology. Aside from speed issues, we could just go straight to a topogeom column much like we do with geography is -G is chosen. This would require another switch for topology name and name of topology. The only tricky part is that for the toTopogeom calls we need the generated layer id, which would require a connection to the database to get unless we have a lookup function of some sort that can lookup the layerid based on topo column table/name. … … 84 84 Mentor: Regina Obe[[BR]] 85 85 86 Skills required: C/C++,PL/pgSQL, knowledge of PostGIS and PostGIS topology86 Skills required: PL/pgSQL, knowledge of PostGIS and PostGIS topology 87 87 88 88 The scenario: You are the master maintainer of a topology for say a city or something and have meticulously laid out the topology that should account for all department topogeometry needs. … … 116 116 Mentor: Regina Obe [[BR]] 117 117 118 Skills required: C /C++, knowledge of PostGIS library, knowledge of PostgreSQL SQL118 Skills required: C, knowledge of PostGIS library, knowledge of PostgreSQL SQL 119 119 120 120 If you can't create a temporary table, then you can't get a shapefile out of a query using pgsql2shp. You can by using ogr2ogr. … … 128 128 Mentor: Regina Obe[[BR]] 129 129 130 Skills required: C /C++, knowledge of PostGIS library130 Skills required: C, knowledge of PostGIS library 131 131 132 132 Just when -d flag is passed … … 138 138 Mentor: Regina Obe[[BR]] 139 139 140 Skills required: C /C++, GTK, knowledge of PostGIS library140 Skills required: C, GTK, knowledge of PostGIS library 141 141 142 142 Right now a user has no way of knowing what options are available in shp2pgsql-gui. … … 148 148 Mentor: Regina Obe [[BR]] 149 149 150 Skills required: C /C++, GTK, knowledge of PostGIS library150 Skills required: C, GTK, knowledge of PostGIS library 151 151 152 152 If you try to load shapefiles with only dbf available and select spatial index option, you will see an error
