Hi all,When i try to login to Oracle Workflow Manager with the following linkhttp://localhost:7778/s...
By user502230
Hi All,Im a Jr. Database Analyst Im trying to make some documentation of ourSCM Plan for my manageme...
By mitch_gillespie_rmc
Hi All,Im a Jr. Database Analyst Im trying to make some documentation of ourSCM Plan for my manageme...
By mitch_gillespie_rmc
I'm looking for references and advice on the best way to managetable schema and stored procedur...
By mark_harrison
Hi All,Im pasting some queries that can do optimization. Can you check the queries whether it is fea...
By pratheej, 1 Comments
Hi DBAs,i need to create a new database base, so trying to login as sysdba after exporting <ORACL...
By mohammadasif, 1 Comments
Dear Oracle DBA (or anyone good with dos commands...)I ran into something quirky in WinNT4.0 with re...
By desbyleo, 10 Comments
HiI am not that good in query optimization ...can anyone think that below query can be optimized fur...
By chandrashekhar_, 10 Comments
I'm looking for a solution (odbc driver, ado...) that would allow me to develop a software (wit...
By didsyl, 3 Comments
I believe the term you look for is 'geocode'. If I understand correctly, the software is documented in the Oracle SPatial manual and referenced in the Pro Oracle Spatial book ... but you need to get a data source to meet your needs.
hansforbrich | Sat, 23 Feb 2008 12:30:00 GMT |
Hello David:
At this US Census Bureau site:
http://www.census.gov/geo/www/cob/z52000.html
You can download the 5-digit zip code tabulation areas (ZCTA). I think they are for 1990.
From there, you could use the shp2sdo.exe program to laod this into an Oracle table.
After it is in Oracle, you could use SDO_GEOM.SDO_CENTROID to derive a point at the centroid of each polygon.
Just a suggestion - I have not actually done all of the above.
R Clement
richardclement | Sat, 23 Feb 2008 12:31:00 GMT |
Hi Richard,
That is exactly what I did when I was going to respond to this note. The process is correct (I migrated the data after loading with the .exe version of the converter using sdo_migrate.to_current), got and stored the centroid and the name (zip code) for each polygon.
Then I went to check the results to make sure the centroid was in the zip code (because Oracle's centroid function doesn't require the centroid to be inside the polygon), and that was when I found a lot of duplicate zips, and some funny zips too (378HH, 378XX) that I couldn't decode the meaning of.
So I will hope someone else finds good zip code data...
danabugov | Sat, 23 Feb 2008 12:31:00 GMT |