This content has been marked as final. Show 3 replies
How about telling us a lot more about your environment:
1. Oracle version
2. PostgreSQL version
3. PostGIS version
4. Operating system (linux, windows server ???, solaris)
5. Client tools (eg QuantumGIS, FME, etc)
6. Command line tools eg ogr2ogr
7. Can the two databases "see" each other?
... because until you do all suggestions we may put forward may be useless to you and a waste of time for us.
Also, what were your first thoughts on how to go about it?
Well I don;t have a lot of the information your are asking about. I presume it will be the latest Enterprise Edition of Oracle ( since I get to pick it ) and as to the PostGis I am pretty sure they are using the latest version of that as well ( I am still on the outside for now ) but I am trying to get a jump on the whole thing.
Given this is for traffic flow analysis I don't imaging the Geo-coding will be all that complex but again I don't know at the moment.
Now having said all that I have availed myself of google and not found much in the way of conversion concepts.
So, I have posted this to get some general information to white:
Is it a huge thing?
Are the coding methods that different?
Since this I see this as only 2 dimensional ( a rode does not exist free floating in space ( well I suppose a bridge that crosses over a roadway could or possibly should have a limited Z axis ) then we simply need to correlate the location of traffic withing those spatial boundaries, thus giving us the ability to analyze volume and density through a given area.