|What is the best web solution for the following scenario?|
Requesting advice/solution for visual databases
Dear Web Developers of all Sorts,
If given the following scenario, what is the best web solution?:
A company has information of pieces of land around the world. This information is not in a database of any sort. The company would like to have a setup to where their prospective customers would be able to visit the company's website and submit specific coordinates to search the company's records to see if the company has any information on that piece of land. The company's setup would then do a search through their records to see if they have information on that piece of land with those coordinates. If the company does, then that information would be fed back to the website to display to the inquirer. If not, then a message communicating this would be display to the user. How does the company go about setting this up?
I would first assume that all the information that could be searched through must be entered into some sort of database. Then a program would have to be written for the company's website for visitors to interact with.
What kind of people does the company need to hire to complete this job? What are their titles in the web development world?
What languages would all this be written in? Java? C++? VB?
What kind/type of database would be best for this information to be stored for the website program to access and query?
I don't know if it's the best solution for what you need, but you might consider looking into Mapinfo-- it's interactive mapping software that allows queries based on coordinates, street intersections, etc and is easy for ordinary people to use. Might be pricey for what you need though, because it requires its own server, some pretty elaborate softare, enormous amounts of data, and probably a GIS technician to set it up & keep it running. I don't know of a hosted application service for mapinfo but it's something to check into with the company. In any case, the results can't be beat. There are demos you can check out at [dynamo.mapinfo.com...] (click demos on the sidebar menu-- B of A cash machine locations sounds pretty close to what you're looking for.)
ESRI also produces interactive GIS software but theirs is targeted at GIS users doing more complex queries and analysis and probably not the best for everyday users.
Hope that helps.
Looks like they do offer a hosting arrangement-- check out [mapinfo.com...]
I can't tell if it accesses worldwide map data though.
Nice info Bentler, never heard of that site before, very interesting.
I was wondering about a few points on this case.
>>would like to have a setup to where their prospective customers would be able to visit the company's website.
Does this mean the company already has a website? If they do then it may be that most of the required pieces are already in place, such as, db support and available languages to script in. I don't think that you necessarily have to go to one of the big languages. You could get away with php depending on the amount of imformation this company has and how it was decided that it was to be searched.
It seems that you would need someone experienced in db design and a solid web developer who could access this info quickly and efficiently with out creating too much overhead. They would have to be careful about the speed of queries depending on the amount of info to be searched.
The company also might want this to be proprietary so they may need someone on staff for development and maintenance.
If they have a website they could talk to their host and find out what options are a available to them and then proceed from there. They may have to get a new host.
You need someone (or a company) that provides a bunch of solutions and that you can communicate well with to make sure that they execute your goals effectively.
>Does this mean the company already has a website?
Yes, the company already has a website.
Thanks for all the information and help.
I forgot to mention that the company wishes to have the website visitor first register with a credit card on the website and then login with a username and password, and then the website visitor will have access to a screen to enter in the exact longitude and latitude coordinates to search for information about that piece of land that might be on the company's database. Does this change the solution that you've told me so far? If so, how?
I don't know if it pertains to mapping, but there is CAD software that translates info into databases and integrates visually into websites, as well as being printable. I've seen such information for buildings, visually presented with very precise data and for some reason it had to be .asp-enabled hosting in that situation.
If there are search engine promotional plans and directory submissions to be considered in this case, there are issues with requiring a password for access to the site that would have to be dealt with.
Can you please post or email with more information on this software you are talking about, because the information on the pieces of land are all in CAD files. My email address is firstname.lastname@example.org
Brennan P. Johnson
Brennan, I had the general concept but not specific knowledge, so I did a Google search for cad software, cad mapping software, etc., since the company I know of that used it had no information on their site.
There's lots of info to research and much to choose from, but this particular site I found has content related to the latest CAD release in relation to HTML, file formats and web presentation, which is the specific need here, so the information could be relevant, at least as a starting point:
I also looked under cad utilities:
where I found this site with some free downloadable utilities for CAD file conversion, among a couple of others:
There were some other open source utilities listed on the same Google search page, which might work if you'll be developing a custom application in-house. Interesting to find out that Linux is also in the picture for this.
Hope this helps.
(edited by: Marcia at 2:19 am (gmt) on Aug. 25, 2001)
>Does this change the solution
You could have the publicly viewable site optimized for search engines and directories and use a second domain as the password-protected client area. You'd have to check the Yahoo/ODP requirements for regulations on sites with passwords, which could influence whether a separate client section could be used on the same domain.
The answers for this issue are probably already in our Yahoo and Directory forums, or could easily be answered. If I'm not mistaken, I believe the passwords for protected sites may need to be made available to the editors for a certain length of time to be considered for inclusion, if they're on the site. You'd have to double-check on this.