I have recently taken a developer's position at a utility location facility. Though I am a programmer, I have 4 years+ as a GIS specialist back in the mid-90s. I came from ArcInfo and MapInfo background. With my client seeing that in my resume, I been asked to help with a long running problem.
They locate utilities in the Seattle, Wa area using OSP Viewer, an outdated program circa 1999. It uses PIC files are its images. PIC was made for PC Paint and never went much further.
I believe the data simply stores the pixel coordinates of the node and the OPS viewer takes you there.
Having said that, my client would simply like to have the locations in Lat. Long., which would be suitable for their purposes, since that is what they provide the locators with.
The Cross Wire Boxes each have a data entry of:
1204 QUEEN ANNE N
2261 MONTAVISTA PL W
2601 11TH W
3209-02 17TH W
The first figure(6866543) is a sequential index that I can see being referenced through the program. But it is resolved to the information below.
The second is the street address for Seattle area(1204 QUEEN ANNE N). Only included in the Wire Center data. Not in the utility data so there is no hope in geocoding addresses.
The 1757 249 may be Row and Col of the drawing but I am not sure. (just took on this challenge)
The last value pair looked suspicious. I called the data providers, who were tight lipped, and he assured me they were meaningly database values inserted from Oracle!? So what I did was charted the first 100 wire centers on an Excel scatter chart. I then geocoded the same 100 addresses using Google Maps, by hand, saving the points on teh map. I set the alpha of the chart to 50% (transparency) and was able to overlay an image of the scatter chart directly over the google map, matching point by point to the addresses I had saved. So, without a doubt, these are projection (or coordinate) values. Using Google Map's "What's Here" function, I can see that the first address is: 47.629606, -122.356529 (LatLon).
If I knew the projection, (the north/south looks nearly like a latitude), I should be able to convert these values to Lat. Long.
At this point, the only GIS tool I have is an old version of MapInfo 6 but I think I have access to ESRI suite or I can write a conversion myself. I am dealing with several hundred thousand drawing, so Ican't do this by hand.
Does anyone recognize the projection values?