Contribute > apps > CivicApps Data Installer


CivicApps Data Installer (CADI) is intended for the use of other developers. It helps you work with data available on the website by download, extracting, and parsing the data into a local spatially enabled sqlite database. It is also very easy to then dump the sqlite db into some other spatial db engine - Oracle, PostGIS, etc. The goal is to assist anyone who wants to work with the data in getting into a format they can work with. By putting it in an sqlite database, almost any language can be easily supported. It currently supports about 10 datasets, with a goal of supporting all shapefile and CSV based datasets. It also supports plugins, to allow easily adding more datasets of any type.

Targeted demographic (who is the app intended for?): 
Other developers, or anyone who wants to query the data using SQL.
Who and what will be impacted by the app, and how?: 
Primary impact is to app developers, in making civicapps data easier to use. as an example, multiple other app developers, including, have used CADI as a starting point to work with the data.
What is the specific need that is addressed by the app?: 
Allowing people to work with a more common data format, namely SQL, rather than shapefiles and CSV files.
Anticipated usage of the app (by whom, under what circumstances, etc)?: 
Any developer who wants to query or use datasets available through civicapps, but doesn't have expertise in working with shapefiles. a.
How is information presented, that's not presented elsewhere; how is it unique?: 
CADI presents the data in a format that almost any application developer knows how to work with; and that almost any language can deal with easily.
What are a few of the primary strengths of the design?: 
Since CADI is written in Perl, it will run on any platform. It generates SQLite database files, which is a free, open source, embeddable file based SQL engine, that is also easily convertable to other RDBMS' - including MySQL, Microsoft SQL, Oracle, etc.
GNU General Public License (GPL)
romero :: March 24, 2011 - 4:10am