Laserfiche WebLink
<br />Figure 2-1. Ideal dat ase and query system <br /> <br />SOURCE DATA A INFORMATION <br />~ DISPLAY <br /> <br /> <br />CUSTOM DATA <br />UERY/SYNTHESIS <br /> <br /> <br />..~ l>!-_~, ,'lIl'": .:" . <br /> <br />Compiled View of <br />Databases <br /> <br />#- of parcels <br />size <br />zoning <br />services <br />etc. <br /> <br />DATABASE <br />QUERY - <br />STORED <br />ROCEDURE <br /> <br />DIGIT Al PLANNING.lMODElING <br />!QQb. <br /> <br />database 3 <br /> <br /> <br />commerdaJ and imJuslriaJ <br />parcels <br /> <br />wh at if? <br />zone derinition change <br />constraints increase <br /> <br />aner formula assumptions and <br />'Uiew resuns <br /> <br />T.A.BLE <br />databases and <br />tables <br />current and <br />continuously <br />maintained <br /> <br />SOL query fed live <br />from databases or <br />tri ggered update <br />upon change in <br />source data <br /> <br />~~G <br /> <br />PRINTED REPORTS <br /> <br />Source: Ken Kato and ECONort <br /> <br />The ideas are cleare <br />Springfield, Eugene, an <br />occupancy In a commo <br />queried either in real ti <br />(e.g., LCOG) to create <br /> <br /> <br />the source data would feed into a central database <br />feed into a web interface and/or printed reports and <br /> <br />Figure 2-1 shows ho <br />system, which would th <br />maps. <br /> <br />ith an example. In an ideal system for the Metro area, <br />ane County might all enter building permit and <br />orm on their own servers, and those servers would be <br />by end users, or periodically by a database manager <br />ated tables. <br /> <br />,he possibility of building such an ideal system: <br /> <br />. Technology. Th ethods for deploying a fully dynamic system as <br />described above a e extremely complex. Such systems require a high level <br />of expertise and rge budgets to pay for that expertise. Additionally, the <br />hardware and so t are infrastructure investment necessary to deploy such <br />a system can als e enormous. <br /> <br />. Process. The lar st hurdles are often the administrative procedures <br />required to see t project through to completion. Issues such as inter- <br />agency agreeme s, data licensing, cost sharing, and the time. and staff <br />costs behind the cessary meetings often present a barrier greater than the <br />technology. <br /> <br />Commercial and Industrial Lands Database <br /> <br />ECONorthwest <br /> <br />September 2006 <br /> <br />Page 6 <br />