resedlar
asked on
Program to transform Vector data into image file.
I have building sketch information stored in a database in vector format. I need to find a program to change this data to an image that I can then display on a web page.
We have aproximately 550,000 sketches stored, these sketches do not change very often, and there is a flag in the database to tell me when they were last modified.
I would like either a program to grab the data from the database, create the image, and let the browser know where the image is.
OR
A program that I could run once to create all the sketch images, and then run weekly and only update the sketches that have changed.
Here is a sample of the data for one sketch:
A0CU24R29D24L29
A1R10CR9D4L9U4
A2R11D4CR7D3L7U3
A3U4CL2U8R2D8
A4U5R29CU19R11D19L11
A5U24CU5R19D5L15
A6U24R19CU8R10D8L10
The image that this information represents can be found at this link:
http://www.geocities.com/robsgames2001/Sketch.png
I know that the first two characters of the record are a sequence number and represent the different rectangles on the sketch (A0=A, A1=B, A2=C, etc)
All units are in Feet
Directions are U=up, D=down, R=right, L=left
The record assumes the same starting point for each record. The directions and distances then move to the starting point of the rectangle, C tells you to start the rectangle, and the remaining information describes the rectangle.
Let me know if any additional information is needed.
We have aproximately 550,000 sketches stored, these sketches do not change very often, and there is a flag in the database to tell me when they were last modified.
I would like either a program to grab the data from the database, create the image, and let the browser know where the image is.
OR
A program that I could run once to create all the sketch images, and then run weekly and only update the sketches that have changed.
Here is a sample of the data for one sketch:
A0CU24R29D24L29
A1R10CR9D4L9U4
A2R11D4CR7D3L7U3
A3U4CL2U8R2D8
A4U5R29CU19R11D19L11
A5U24CU5R19D5L15
A6U24R19CU8R10D8L10
The image that this information represents can be found at this link:
http://www.geocities.com/robsgames2001/Sketch.png
I know that the first two characters of the record are a sequence number and represent the different rectangles on the sketch (A0=A, A1=B, A2=C, etc)
All units are in Feet
Directions are U=up, D=down, R=right, L=left
The record assumes the same starting point for each record. The directions and distances then move to the starting point of the rectangle, C tells you to start the rectangle, and the remaining information describes the rectangle.
Let me know if any additional information is needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Currently we have a vendor who created the vector information from gif images that we had on file. The vendor sold us a back end program for doing property assessments. They offered to sell us the program to transform the vectors to images at first. However we have two web sites, one is free to the public and does not contain the sketch and the second is a paid site that contains the sketch along with other information that is not needed by the public. The vendor now wants to host the paid site for us for a percentage of the proceeds, they realize that the only thing we need is a way to transform the vectors to images so they are now claiming that they don't have a program that they can sell us. Even though the vendor is currently transforming the vector data to images on it's own version of the paid site.
Unfortunately I am just a lowly ASP program and don't have the abilty to tell the vendor to got to ....
Unfortunately I am just a lowly ASP program and don't have the abilty to tell the vendor to got to ....
Apologies that I didn't follow up on this more, but thanks for the points. Seemed to me something that could be easily tackled in a variety of ways. But you need to play around with it, or hire someone to spit out your diagrams. A couple of days work at the most I think.
Hope it worked out.
Hope it worked out.
ASKER
Hey Snazzy,
I have written a VB application that creates the images. Still need to do some finish work on it. I'm sure someone better in VB would be done already. But the lead with Logo gave me some ideas on how this needed to be done.
Thanks for the help.
I have written a VB application that creates the images. Still need to do some finish work on it. I'm sure someone better in VB would be done already. But the lead with Logo gave me some ideas on how this needed to be done.
Thanks for the help.
Personally I haven't run across Logo since the 70's, so I won't be much more help than pointing you here:
http://el.media.mit.edu/logo-foundation/resources/links.html
Logo is alive and kicking. What you need is someone who knows something about it to write you a little program to read your data. Apparently there is a Windows version of Logo, free.