gis.68227
2005-04-08, 02:42 PM
I am looking for information on being more productive with object data, databases and queries.
Here is an example:
You have a large numbers of nodes(text, points, blocks etc) with object data (addresses, node_id from topology, etc) that has been converted to database links. The object data in the database has been to filtered (queried) (in the database) to produce a list of node_ids. How do you select just the nodes from the list?
Simplified - Can you select based a list from a database?
The long way I can see -
Do a node topology on the points-
export shp_file w/ od / import w/ od as text of node_id
convert to db_links
do filtering and make query(the list)
create link template
generate links based on text.
select all from link template.
This seems cumbersome.
There should be a way of selecting features without create another link template or creating text.
Thanks,
TC
Here is an example:
You have a large numbers of nodes(text, points, blocks etc) with object data (addresses, node_id from topology, etc) that has been converted to database links. The object data in the database has been to filtered (queried) (in the database) to produce a list of node_ids. How do you select just the nodes from the list?
Simplified - Can you select based a list from a database?
The long way I can see -
Do a node topology on the points-
export shp_file w/ od / import w/ od as text of node_id
convert to db_links
do filtering and make query(the list)
create link template
generate links based on text.
select all from link template.
This seems cumbersome.
There should be a way of selecting features without create another link template or creating text.
Thanks,
TC