Laserfiche WebLink
<br />Figure 2-1. Ideal database and query system <br /> <br />SOURCE DATA <br /> <br />A INFORMATION <br />~ DISPLAY <br /> <br /> <br /># of parcels <br />size <br />zo n i n g <br />services <br />etc. <br /> <br /> <br />database 1 <br /> <br />CUSTOM DATA <br />QUERY/SYNTHESIS <br /> <br /> <br />Compi led Vi ew of <br />Databases <br /> <br />DA T ABASE <br />QUERY - <br />STORED <br />ROCEDURE <br /> <br /> <br /> <br />database 2 <br /> <br />commercial and industrial <br />parcels <br /> <br /> <br />wh at if? <br />zone definition change <br />con stra i nts in c re a s e <br /> <br />database 3 <br /> <br />alter formula assumptions and <br />view results <br /> <br />TABLE <br />databases and <br />ta b I e s <br />current and <br />conti n u 0 u s Iy <br />maintained <br /> <br />SOL query fed live <br />from databases or <br />tri g g e re d up date <br />upon change in <br />source data <br /> <br />~E <br /> <br />PRINTED REPORTS <br /> <br />Source: Ken Kato and ECONorthwest <br /> <br />Figure 2-1 shows how the source data would feed into a central database <br />system, which would then feed into a web interface and/or printed reports and <br />maps. <br /> <br />The ideas are clearer with an example. In an ideal system for the Metro area, <br />Springfield, Eugene, and Lane County might all enter building permit and <br />occupancy in a common form on their own servers, and those servers would be <br />queried either in real time by end users, or periodically by a database manager <br />(e.g., LCOG) to create updated tables. <br /> <br />Two key issues limit the possibility of building such an ideal system: <br /> <br />. Technology. The methods for deploying a fully dynamic system as <br />described above are extremely complex. Such systems require a high level <br />of expertise and large budgets to pay for that expertise. Additionally, the <br />hardware and software infrastructure investment necessary to deploy such <br />a system can also be enormous. <br /> <br />. Process. The largest hurdles are often the administrative procedures <br />required to see the project through to completion. Issues such as inter- <br />agency agreements, data licensing, cost sharing, and the time and staff <br /> <br />DRAFT: Commercial and Industrial Lands Database <br /> <br />ECONorthwest <br /> <br />July 2006 <br /> <br />Page 6 <br />