Iowa Geographic Information Council 2007 NSDI 50 States

Iowa Geographic Information Council 2007 NSDI 50 States Cap Grant A Business Plan for the Iowa Geospatial Infrastructure (IGI) Jim Giglierano james. giglierano@dnr. iowa. gov June 12, 2008 Iowa Geological Survey

What is the IGI? • Iowa Geospatial Infrastructure (IGI) is Iowa’s contribution to the National Spatial Data Infrastructure (NSDI) • IGI’s central focus is on the collection of consistent, common, integrated, standardized local, state, federal and other GIS data layers (“framework” data layers in NSDI terminology) that are freely available to the public through the Internet • IGI will follow NSDI practices for metadata and data standards, and use Iowa’s data clearinghouse for data discovery • IGI includes people, technology and agreements to make this happen Iowa Geological Survey

Lots of GIS pieces out there State Agency #1 City #1 Federal Agency #2 County #2 University #1 Iowa Geological Survey State Agency #3 Utility State Agency #2 County #1 Federal Agency #1 City #2 University #2 County #3 State Agency #4

Existing Relationships County #1 County #2 County #3 Federal Agency #1 City #1 State Agency #2 City #2 State Agency #3 University #2 State Agency #4 University #1 County #4 Iowa Geological Survey Utility Federal Agency #2

IGI: Delivering consistent framework data from centralized locations on the web Statewide GIS Infrastructure County #1 County #2 City #1 City #2 County #3 County #4 Iowa Geological Survey Utility State Agency #1 State Agency #2 State Agency #3 State Agency #4 Federal Agency #1 Federal Agency #2 University #1 • Master agreement to participate • Content standards/best practices and metadata • Different ways to provide content • Includes crossed linked GIS service bureaus

County and State GIS Service Bureaus • Provide assistance to data stewards to get data into the IGI • Provide assistance to data stewards to get benefit from participating in IGI • Provide information and assistance to all GIS users to gain benefits from using IGI Iowa Geological Survey

IGI: Facilitating development of seamless statewide applications Web-based Application Statewide GIS Infrastructure Counties Cities and towns Iowa Geological Survey Private Entities Application building blocks: for example, a geocoding service, a routing service, various web mapping services State Agencies Federal Agencies Universities colleges

IGI: Fostering Communities of Practice Economic Dev Applications Environmental Applications Public Health Applications Emergency Management Applications Statewide GIS Infrastructure County #1 City #1 Iowa Geological Survey Utility State Agency #1 Federal Agency #1 University #2

IGI Components: • Framework data layers – Best practices/standards for seamless, statewide databases – Metadata – Public access • Data and web application servers • Services to framework data providers and users – – – Coordination assistance Contracting assistance Web hosting and application development assistance Training Technical assistance • Agreements between data providers, service bureaus and funding sources Iowa Geological Survey

IGI Framework Layers 1. Geodetic control: county GPS control monuments and NGS benchmarks 2. Ortho imagery: BW, color and CIR orthorectified aerial imagery 3. Administrative boundaries: city, county and state boundaries 4. Cadastral data: public land survey section corners, section lines and parcel boundaries 5. Transportation: road centerlines, railroads, trails, airports, waterways 6. Elevation: digital elevation models and contours 7. Hydrography: rivers and streams, water bodies, watershed boundaries 8. Address points 9. Structures: 2 D building footprints, bridges, towers Iowa Geological Survey

IGI Framework Layers: Data Sources 1. 2. 3. 4. 5. 6. 7. 8. 9. Control points – counties Administration boundaries - counties Ortho-imagery – counties, state, federal Cadastral - counties Transportation – state and counties Hydrography – state and federal Elevation – state (and federal? ) Address points – state and counties Structures – state and counties Iowa Geological Survey

Framework layers – ground control Iowa Geological Survey

Framework Layers – high resolution orthophotos Iowa Geological Survey

Framework Layers – transportation – road centerlines Iowa Geological Survey

Framework Layers – hydrography - streams Iowa Geological Survey

Framework Layers – cadastral – parcels and right of ways Iowa Geological Survey

Framework Layers – address points Iowa Geological Survey

Framework Layers – structures – building footprints Iowa Geological Survey

Framework layers – elevation – digital elevation models and 2’ contours Iowa Geological Survey

Framework Layers – what we need Iowa Geological Survey

Framework Layers – what we have now Iowa Geological Survey

Framework Layers – city boundaries From Johnson County GIS More accurate and up-to-date From DNR’s NRGIS Library – 2000 Census boundaries – out-dated Iowa Geological Survey

Why we need good framework layers: provides the base for accurate operational management layers City Boundaries Voting Districts Fire Districts TIF Districts School Districts Iowa Geological Survey

Why we need good framework layers – address points to map clients and service providers Iowa Geological Survey

Our Approach to IGI Business Plan: Study Return on Investment (ROI) IGIC used its CAP grant to hire the Geospatial Information and Technology Association (GITA) to help us study costs and benefits of building, maintaining and using a statewide spatial data infrastructure – study completion June 2008 Grant report to FGDC due end of September 2008 Iowa Geological Survey

ROI - Costs Capital and One-time costs: • Hardware and Software • Data Acquisition/Conversion • Start-up Services – Planning & Design Activities – Training – Legal & Financial Review – Application Development Iowa Geological Survey

ROI - Costs Operating and Ongoing costs • Staff Positions/Time (requires burdened labor rates, overtime rates for all relevant positions applied to the following task categories) – Data Maintenance – Technical Support – Application Use • Hardware & Software Maintenance • Training • Support Services Iowa Geological Survey

ROI - Productivity Benefits • Faster data updates (collect metrics for current maintenance effort) • Reduced queries to office staff from public or staff (collect metrics for current effort) • Reduced need to collect data (collect metrics for redundant efforts) • Enhanced query capabilities due to timely statewide data • Reduce time spent collecting data from/providing data to area partners (collect metrics for current effort) Iowa Geological Survey

ROI - Other Benefits • Eliminate contracts for obtaining data (collect cost of contracts) • Eliminate redundant software contracts (collect cost of contracts) • Eliminate/reduce redundant communications, network costs • Reduce costs of outsourced contracts due to improved data (estimate changes to consulting) Iowa Geological Survey

Quantitative Measures Subtract Costs from Benefits Cumulative Benefits Equal Cumulative Costs NPV Break Even ROI Divide Benefits by Cost Iowa Geological Survey Pay Back Time from Now to Breakeven Point

Each Measure Has a Best Use • NPV – Net Present Value – Best overall measure of financial value – Higher NPV always identifies better investment • ROI – Return on Investment (specific definition) – Shows whether benefits outweigh costs – Inappropriate for comparing investments (can have high ROI with low NPV, etc. ) • Breakeven Point and Payback Period – Shows whether benefits outweigh costs – Important political measure – Inappropriate for comparing investments Iowa Geological Survey

Strategic Benefits: shared data and services; Competitive improved accuracy, Advantage Safety consistency, timeliness of data; better access to data; Goodwill facilitating communication Can We between various entities; Morale Stay in lost opportunity costs Business? Sometimes strategic benefits are enough to launch a project – to stay in business or fold up shop? Iowa Geological Survey Regulatory Compliance Clean Environment Growth

ROI Interviews • Collect costs and benefits for state and county data producers to participate in IGI • Collect costs and benefits of having a GIS for counties with GIS (different than IGI ROI – helps us extrapolate to counties without GIS) • Collect benefits of IGI to other users • Dozens of counties interviewed • State agencies and private entities too Iowa Geological Survey

Initial ROI Interviews: Counties WITH GIS • Some minor costs to counties to provide framework data layers to IGI • Some decent benefits for counties by access to IGI data layers (elevation, structures, etc. ) • But most counties in Iowa sell their data – issues with ownership, control, fairness to taxpayers, etc. • There needs to be more of an incentive to participate and provide framework data Iowa Geological Survey

Additional IGI Benefits • Ortho-imagery Coordination – merge state and local acquisition programs; assistance with RFPs, contracting, eventually get help from IFTN • Data Hosting and Web Applications • Training • Technical Assistance and Framework Data Modernization Iowa Geological Survey

Additional IGI Benefits: A County GIS Service Bureau • A county GIS service bureau collects framework GIS data layers from participating counties, processes them into statewide databases and distributes them using web applications. • It assists existing and new county GIS programs with ortho-imagery acquisition, web applications, training and technical support for county GIS projects. Iowa Geological Survey

IGI County GIS Service Bureau • Job functions: about 4 FTEs – County IGI coordinator – County ortho-imagery coordinator – GIS web application developer – GIS tech/training specialist • Funded by the state – free to counties who participate in IGI Iowa Geological Survey

Benefits to Counties with GIS Participating in IGI • Using lidar in county engineer office for road maintenance $12 k-90 k/yr • Using lidar in county engineer office for surveying and design $10 k-50 k/yr • Cost avoidance for web server $10 k/yr • Cost avoidance for aerial photography $20 k/yr through participation in IFTN Iowa Geological Survey

Benefits to Counties with GIS Participating in IGI • • GIS Coordinator – reduced aerial contracting Emergency planner – automated mapping Sheriff dispatcher – locating addresses Economic Dev staff – producing information packets faster • Conservation staff – faster project planning • Public Health inspector – locating inspection sites From $10 k to $60 k in benefits per county per year – requires training for the department staff, hence the training specialist position in the service bureau Iowa Geological Survey

Costs to Participate in IGI • GIS Coordinator – providing data • County Staff – learning to use lidar elevation, other data layers • Participate in Imagery for the Nation (IFTN) ~ $5000 k in real costs per county per year to participate in IGI Iowa Geological Survey

66 Counties WITH GIS participating in IGI Breakeven Year: 2009 Payback Period (in Years): 1 Net Present Value: $210, 869, 204 Present Value of Costs: $5, 808, 835 Return on Investment: 181. 51% Iowa Geological Survey (Annualized)

ICIT Data Repository and IGI • Data Repository automatically collects county data in one place, provides backup, different levels of access to users via ftp • IGI county GIS service bureau only works with publicly accessible framework data, transforms county framework data into statewide coverages, provides web application servers, training and other services • DR and IGI are complimentary Iowa Geological Survey

Special Emphasis: Counties without GIS Iowa Geological Survey

Pete Buckingham Iowa Geological Survey

ROI Results: Counties WITHOUT GIS • Here’s the typical approach for counties wanting to adopt GIS: – Initial outlay of $200 k to $500 k for GPS control, orthos, centerlines and parcel conversion project – GIS staff: coordinator and half-time tech – 2 or more copies of desktop GIS software; GIS hardware, servers, plotter – Web mapping server – OR all above services provided by a vendor • Many of the remaining counties can’t afford startup or maintenance costs of GIS Iowa Geological Survey

Counties adopting GIS: parcel maintenance and tax assessment only Does Not Breakeven Year: Even Payback Period (in No Payback Years): Anticipated Net Present Value: ($1, 106, 613) Present Value of Costs: $2, 423, 193 Return on Investment: -2. 28% Annualized Iowa Geological Survey

Problems • “Standard” GIS approach is not cost effective for smaller counties if parcel maintenance and tax assessment are the only applications of GIS • Many counties WITH GIS are not getting all the possible benefits of their GIS if all they do is parcel maintenance and tax assessment • May feel compelled to sell data to recoup costs • IGI (and therefore NSDI) won’t happen without major assistance to local data producers to lower their ongoing costs, and expand their overall benefits of having a GIS Iowa Geological Survey

IGI Benefits • IGI County Coordinator helps with regional approach starting a GIS – Sets up agreement to share a GIS person among 3 counties – Assists with contracting for GIS data conversion among 3 or more counties; parcel maintenance outsourcing – Data hosting and web application by service bureau • Benefits of access to IGI data (lidar contours, etc). Iowa Geological Survey

County Adopting GIS with IGI Assistance – sharing costs with 3 other counties Breakeven Year: 2019 Payback Period (in Years): 11 Net Present Value: $556, 954 Present Value of Costs: $1, 021, 680 Return on Investment: 2. 73% Iowa Geological Survey

ROI Results – IGI Costs to State Agencies • Costs for DNR hydrography development and maintenance related to IGI: $500 k-1000 k • Costs for DOT transportation maintenance related to IGI: $25 -50 k • Costs for DNR/DOT elevation from lidar, maintenance related to IGI: $25 -50 k Iowa Geological Survey

ROI Results – Benefits to State Agencies • Contacted and interviewed DNR, DOT, DALS, PD/HLSEMD, DPH, DHS, Education, DOR, DOM, Attorney General, Sec. of State • Benefits of IGI to state agencies: mainly related to use of parcels for land ownership information, and address points to map locations of people – large benefits to education, human services and health Iowa Geological Survey

ROI Results – Benefits to other Groups • • Federal agencies – NRCS, FSA, COE Regional agencies – COGs, RC+Ds Towns and cities – not interviewed Private Business – consulting engineers, utilities – some interviewed • Education – community colleges, universities – not interviewed Iowa Geological Survey

IGI State GIS Service Bureau • A state GIS service bureau collects and distributes state framework data layers through web mapping applications. – It maintains the Iowa Geospatial Data Clearinghouse server. – It assists state agencies w/ GIS projects, training and web applications related to the use of the IGI framework layers, especially address points for geocoding Both GIS service bureaus are interconnected and provide redundant backups of each other for emergencies. They work closely with each other to provide assistance to participating county and state agencies. Iowa Geological Survey

IGI State GIS Service Bureau* • Job functions – 4 FTEs – GIS database/clearinghouse administrator – Web application developer – GIS tech/training specialist – Community of Practice coordinator • Funded by the state – free to state agencies * Not equivalent to a state agency “bureau” Iowa Geological Survey

Communities of Practice • • Economic Development Education Health and Humans Services Environment Public Safety Emergency Management Gov’t Efficiency Iowa Geological Survey

Economic Development: Joel Akason - Marshalltown Chamber of Commerce • • • Takes days and weeks out of the decision timeframe. He knows that GIS capabilities brought in two (soon to be three) large deals for them in the past year. These would be on the scale of $5 M projects and larger. Maps got the clients to come to town and then Joel must make the sale. Joel uses the GIS to look at empty spots by existing buildings and other already developed areas. He needs the ability to look from the top down. If he is able to close a project in under 30 days vs. someone else taking 6 months, the company will build at his sites even if it doesn’t like the sites as much. Time is money. These little projects would be in the range of $1 -5 M and he closes approximately five a year. They would be something like retail or hotel businesses. GIS provides at least 50% of the resources for bringing in projects. He always starts with a picture. If you can get them to visit your town and the property, you are already on the short list. Adding the large and small projects gives 50% (3 x $5 M + 5 x $2. 5 M) = $13. 6 M benefits in economic development projects/year. Iowa Geological Survey

Economic Development: La. Von Schiltz Nevada Economic Development (Story Co) • • Benefits from a statewide GIS: useful when negotiating to buy land. Often there absentee owners who don’t want to sell outright because that would create a tax occurrence, so they are looking for an exchange. Often there is nothing available in the county that meets their specifications. La. Von needs to search the state for properties, equate by CSR, etc. to make comparisons. Currently she could bring in a $130 M project where only one property will suit the project. Property owner has specified certain locations where they would accept a trade. She gets help from Matt for professional proposals. GIS helps show the community has its act together. Typically she uses GIS for projects requiring at least 40 acres. Lots of energy projects – wind and ethanol. Saving time: saves a day of time for each proposal. Timeliness of response is of utmost importance in her field. Last month she did four proposals. Result would be a saving of 48 days a year by using GIS. La. Von does not have an assistant. She’s a one person office. GIS contributed to bringing in a project this year assessed value $10 M which translates to $400 K in real estate taxes. Mill rate might be lower in Ames but this is probably representative of these type of projects. She notes that location is so important in economic development so scaling benefits according to population of counties may not capture everything in economic development. Iowa Geological Survey

Economic Development Application Iowa Geological Survey

The IGI ROI Calculation – 20 year cost scenario • 20 counties w/o GIS will build county GIS programs, phased into GIS/IGI over 10 years • 79 counties w/ GIS, will participate in IGI, phased in over 10 years • State and federal agencies will participate • Costs of participating were phased in over first 10 years, then full cost of maintaining for next 10 years Iowa Geological Survey

State IGI Costs • Salary and benefits 4 FTEs - $260 k/yr • Staff Travel and Training - $25 k/yr • Hardware, Software and Office expenses - $100 k/yr • IFTN Orthos and Lidar Data - $600 k/yr Total $985 k/yr (paid by the state) Iowa Geological Survey

County IGI Costs • Salary and benefits 4 FTEs - $260 k/yr • Framework Data Acquisition/Modernization Assistance - $250 k/yr • Staff Travel and Training - $25 k/yr • Hardware, Software and Office expenses $100 k/yr • Control Monument Maintenance Program $50 k/yr Total $685 k/yr (paid by the state) Iowa Geological Survey

Other IGI Costs • Data Conversion Projects – Convert USGS National Hydrography Dataset to high-resolution, lidar-based lines: $100 k/yr for 5 years – Create address point and structures framework layers; merge county boundary and parcels into statewide coverages with metadata: $300 k/yr for 5 years Total $2 M (paid by the state) Iowa Geological Survey

Costs for Counties to Participate • Counties with GIS: $5 k per county per year to contribute framework data and IFTN local share (based on 25% of 60 k for a typical county) • Counties without GIS: cost to adopt GIS with assistance from IGI: $1 M over 20 years (~$50 k/yr) based on the regional sharing of GIS staff person These costs paid by counties Iowa Geological Survey

Quantitative Measures Subtract Costs from Benefits Cumulative Benefits Equal Cumulative Costs NPV Break Even ROI Divide Benefits by Cost Iowa Geological Survey Pay Back Time from Now to Breakeven Point

Multi-agency IGI Study Breakeven Year: 2010 Payback Period (in Years): 3 Net Present Value: $211, 860, 906 Present Value of Costs: $59, 265, 718 Return on Investment: 17. 9% annualized Iowa Geological Survey

Summary! • A program to build a statewide spatial data infrastructure in Iowa is possible, and financially compelling • By providing funding for services to county and state GIS programs, the state can insure that everyone benefits by participating in IGI • Now we’ve got financial data to help make the case with decision makers, we can now move ahead cautiously optimistic to our funding sources in the next year Iowa Geological Survey

Why are we doing this? California Enterprise GIS example Iowa Geological Survey