I have list of IDs (of polygons) in csv and I would like to extract those polygons from Oracle Spatial.Number of polygons may run in tens of thousands. After extracting would like to aggregate them and put it back in database or create a shape file.
What's tha best and efficient way to do it.
Cheers,
John
one way would be to read the list of IDs using the CSV reader, then send each ID to a FeatureReader to extract the polygons from Oracle. After processing, either write them back to Oracle using a writer in Update-mode, or write it out to a shape file.
David
+13
Another option would be to aggregate the ID's and use it in the FeatureReader or SQLExecutor using a IN syntax in your where clause.
Itay
+3
....Aggregate maybe (tens of) thousands of id's into a string..
Might as well use inlinequerier then.
When you have (tens of) thousand of polygons and maybe thaousands of ID's i think it is wise to create an external reference tabel.
I think its more efficient use ODBC
Save it to a Excel and make a datalink to it.
(connect to Excel and Access by using Oracle Heterogeneous Service...which has been available since Oracle 8i.)
https://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm
+13
Then again you can just do it all in Oracle, no need to extract the data and write it back.
+3
+13
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
