Hello everybody,
I'm porting an application based on OpenMap(tm) from Oracle Spatial to
PostGIS.
In the oracle db there are those schemas:
Schema: ATTRIBUTE_MAP
* AREA_LDMK_TABLE
* FEATURE_CCB$_TABLE
* LANDMARK_TABLE
Schema: GEOMETRY_MAP
* GEOM_POINT$_TABLE
* GEOM_POLYGON$_TABLE
* GEOM_POLYLINE_TABLE
The geo-objects stored in those schemas are loaded via spatial queries such
as:
select a1.polygon, a1.polyid from GEOMETRY_MAP.geom_polygon$_table
a1, attribute_map.landmark_table a2,
attribute_map.area_ldmk_table a3
where a1.polyid = a3.polyid and a2.land = a3.land and a2.land
in
(select land from attribute_map.landmark_table where cfcc =
'"+cfcc+"');
Those schemas contain a US county imported from a Tiger file. Does this
set-up ring a bell with you or is it just an arbitrary way of storing it?
I managed to load the Tiger content into PostGIS, but the structure is very
different and I don't know how to handle this correctly.
Thanks a million in advance!
Mulone
--
View this message in context:
http://www.nabble.com/-from-Oracle-to-PostGIS--Tiger-Line-files-tp23266627p23266627.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
