]> gitweb.michael.orlitzky.com - dead/census-tools.git/log
dead/census-tools.git
14 years agoAdd the example linear programming problem solution via lp_solve.
Michael Orlitzky [Mon, 5 Apr 2010 19:26:17 +0000 (15:26 -0400)]
Add the example linear programming problem solution via lp_solve.

14 years agoAdd a wrapper which sets the LD_LIBRARY_PATH for lp_solve before executing a python...
Michael Orlitzky [Mon, 5 Apr 2010 19:24:28 +0000 (15:24 -0400)]
Add a wrapper which sets the LD_LIBRARY_PATH for lp_solve before executing a python script.

14 years agoSwitch lp_solve.py to solve a minimization problem.
Michael Orlitzky [Mon, 5 Apr 2010 19:22:46 +0000 (15:22 -0400)]
Switch lp_solve.py to solve a minimization problem.

14 years agoMerge branch 'master' of michael.orlitzky.com:/var/www/orlitzky.com/michael/public...
Michael Orlitzky [Mon, 5 Apr 2010 18:35:44 +0000 (14:35 -0400)]
Merge branch 'master' of michael.orlitzky.com:/var/www/orlitzky.com/michael/public/git/census-tools

14 years agoAdd a new makefile for the third-party libraries.
Michael Orlitzky [Mon, 5 Apr 2010 18:33:36 +0000 (14:33 -0400)]
Add a new makefile for the third-party libraries.
Change the 'lib' target in the main makefile to recurse into the 'lib' directory.
Add 'lp_solve' and 'lp_solve_55' directories to the library .gitignore.
Update the readme with new instructions.

14 years agoSwitched the order of the lat/long output in the KML routes to match the API.
Michael Orlitzky [Wed, 31 Mar 2010 22:18:03 +0000 (18:18 -0400)]
Switched the order of the lat/long output in the KML routes to match the API.

14 years agoAdded the wkt_n-gon script.
Michael Orlitzky [Thu, 4 Mar 2010 19:34:30 +0000 (14:34 -0500)]
Added the wkt_n-gon script.

14 years agoFixed a typo.
Michael Orlitzky [Thu, 4 Mar 2010 19:00:14 +0000 (14:00 -0500)]
Fixed a typo.

14 years agoMoved the line-height definition into the body element.
Michael Orlitzky [Thu, 4 Mar 2010 18:59:31 +0000 (13:59 -0500)]
Moved the line-height definition into the body element.

14 years agoFixed the performance of the distance CSV generation.
Michael Orlitzky [Wed, 24 Feb 2010 19:47:10 +0000 (14:47 -0500)]
Fixed the performance of the distance CSV generation.

14 years agoFixed a big array index bug.
Michael Orlitzky [Wed, 24 Feb 2010 19:15:13 +0000 (14:15 -0500)]
Fixed a big array index bug.

14 years agoFixed multiple newlines in the distances output.
Michael Orlitzky [Wed, 24 Feb 2010 18:44:58 +0000 (13:44 -0500)]
Fixed multiple newlines in the distances output.

14 years agoRemoved the Javascript controller.
Michael Orlitzky [Wed, 24 Feb 2010 18:44:41 +0000 (13:44 -0500)]
Removed the Javascript controller.

14 years agoAdded the postback_url parameter to the LocationController.
Michael Orlitzky [Wed, 24 Feb 2010 18:11:15 +0000 (13:11 -0500)]
Added the postback_url parameter to the LocationController.

14 years agoAdded a distances() method returning the distances between consumers/producers.
Michael Orlitzky [Wed, 24 Feb 2010 18:10:44 +0000 (13:10 -0500)]
Added a distances() method returning the distances between consumers/producers.

14 years agoAdded a postback_url parameter to determine where the JSON data is posted.
Michael Orlitzky [Wed, 24 Feb 2010 18:09:09 +0000 (13:09 -0500)]
Added a postback_url parameter to determine where the JSON data is posted.
Modified the construction of the DirectionsRequest so that latitude and longitude are optional.

14 years agoAdded the distances section to the home page.
Michael Orlitzky [Wed, 24 Feb 2010 18:08:18 +0000 (13:08 -0500)]
Added the distances section to the home page.
Updated the file format instructions for the routing section.

14 years agoRenamed the MapUtils class to Form.
Michael Orlitzky [Fri, 19 Feb 2010 15:08:28 +0000 (10:08 -0500)]
Renamed the MapUtils class to Form.

14 years agoCreated a MapUtils object to contain the post_data function.
Michael Orlitzky [Fri, 19 Feb 2010 14:43:59 +0000 (09:43 -0500)]
Created a MapUtils object to contain the post_data function.

14 years agoMoved the post_data() function in to its own static Javascript file.
Michael Orlitzky [Fri, 19 Feb 2010 14:08:52 +0000 (09:08 -0500)]
Moved the post_data() function in to its own static Javascript file.
Added the route template (missing from a previous commit).

14 years agoRenamed the post_directions_result() function to post_data().
Michael Orlitzky [Fri, 19 Feb 2010 14:03:41 +0000 (09:03 -0500)]
Renamed the post_directions_result() function to post_data().

14 years agoMade the routing Javascript render inline on a new view, location/route.
Michael Orlitzky [Fri, 19 Feb 2010 13:56:05 +0000 (08:56 -0500)]
Made the routing Javascript render inline on a new view, location/route.

14 years agoAdded the "maps" Pylons project.
Michael Orlitzky [Mon, 15 Feb 2010 21:01:44 +0000 (16:01 -0500)]
Added the "maps" Pylons project.

14 years agoAdded a Coordinates class, and updated the LineString class to refer to Coordinates...
Michael Orlitzky [Sat, 13 Feb 2010 05:41:01 +0000 (00:41 -0500)]
Added a Coordinates class, and updated the LineString class to refer to Coordinates.OPEN_TAG and CLOSE_TAG.

14 years agoUpdated all of the queries within the Database class to refer to the 'blocks' table.
Michael Orlitzky [Tue, 9 Feb 2010 18:55:57 +0000 (13:55 -0500)]
Updated all of the queries within the Database class to refer to the 'blocks' table.

14 years agoUpdated the queries in blocks2kml to use the new "blocks" table.
Michael Orlitzky [Fri, 29 Jan 2010 14:37:10 +0000 (09:37 -0500)]
Updated the queries in blocks2kml to use the new "blocks" table.

14 years agoFixed a few hard-coded database names in the makefile.
Michael Orlitzky [Fri, 29 Jan 2010 14:24:20 +0000 (09:24 -0500)]
Fixed a few hard-coded database names in the makefile.
Updated the makefile with some new targets to separate the block data from that of the lines.
Include the SF1/TIGER blocks combination in the blocks_db and db targets.

14 years agoAdded the SQL scripts to combine the sf1_blocks and tiger_blocks tables.
Michael Orlitzky [Wed, 27 Jan 2010 23:04:48 +0000 (18:04 -0500)]
Added the SQL scripts to combine the sf1_blocks and tiger_blocks tables.

15 years agoAdded New Jersey to the download_data script.
Michael Orlitzky [Thu, 26 Nov 2009 01:20:51 +0000 (20:20 -0500)]
Added New Jersey to the download_data script.

15 years agoModified the default_option_parser function to return a parser using a VerbatimHelpFo...
Michael Orlitzky [Mon, 16 Nov 2009 01:38:05 +0000 (20:38 -0500)]
Modified the default_option_parser function to return a parser using a VerbatimHelpFormatter.
Updated the scripts using default_option_parser to account for the whitespace changes.

15 years agoAdded an LEHD module, with classes to parse Origin-Destination matrix files.
Michael Orlitzky [Mon, 16 Nov 2009 01:26:15 +0000 (20:26 -0500)]
Added an LEHD module, with classes to parse Origin-Destination matrix files.
Added tests and fixtures for the LEHD module.
Updated the run_tests script to include the new LEHD tests.

15 years agoMoved RecordError in to its own file, Errors.py.
Michael Orlitzky [Mon, 16 Nov 2009 01:01:23 +0000 (20:01 -0500)]
Moved RecordError in to its own file, Errors.py.

15 years agoAdded the LEHD (OnTheMap) technical documentation.
Michael Orlitzky [Mon, 16 Nov 2009 00:09:53 +0000 (19:09 -0500)]
Added the LEHD (OnTheMap) technical documentation.

15 years agoModified the makefile to use the find_file_paths script rather than guessing at some...
Michael Orlitzky [Fri, 13 Nov 2009 02:47:47 +0000 (21:47 -0500)]
Modified the makefile to use the find_file_paths script rather than guessing at some important file locations.

15 years agoRemoved an unnecessary import.
Michael Orlitzky [Fri, 13 Nov 2009 02:23:00 +0000 (21:23 -0500)]
Removed an unnecessary import.

15 years agoMoved the multiple-filename logic inside the find_file_paths function.
Michael Orlitzky [Fri, 13 Nov 2009 02:21:15 +0000 (21:21 -0500)]
Moved the multiple-filename logic inside the find_file_paths function.
Added tests for the FileUtils module, and in particular for the find_file_paths function.
Added two fixtures for the new tests.
Updated the test suite.

15 years agoAdded the find_file_paths script which utilizes the new find_file_paths function...
Michael Orlitzky [Fri, 13 Nov 2009 01:07:42 +0000 (20:07 -0500)]
Added the find_file_paths script which utilizes the new find_file_paths function within the FileUtils module.

15 years agoAdded the find_file_paths function to the FileUtils module.
Michael Orlitzky [Fri, 13 Nov 2009 01:07:11 +0000 (20:07 -0500)]
Added the find_file_paths function to the FileUtils module.

15 years agoAdded the VerbatimHelpFormatter class to the CLI module.
Michael Orlitzky [Fri, 13 Nov 2009 00:59:08 +0000 (19:59 -0500)]
Added the VerbatimHelpFormatter class to the CLI module.

15 years agoFixed a method name in the download_lines function.
Michael Orlitzky [Thu, 12 Nov 2009 23:26:58 +0000 (18:26 -0500)]
Fixed a method name in the download_lines function.

15 years agoModified the makefile to import all of the Summary File 1 data.
Michael Orlitzky [Wed, 11 Nov 2009 21:59:52 +0000 (16:59 -0500)]
Modified the makefile to import all of the Summary File 1 data.

15 years agoModified the Data module and download script to download the Summary File 1 data.
Michael Orlitzky [Wed, 11 Nov 2009 15:57:20 +0000 (10:57 -0500)]
Modified the Data module and download script to download the Summary File 1 data.

15 years agoAdded the path2pop script.
Michael Orlitzky [Wed, 11 Nov 2009 04:40:01 +0000 (23:40 -0500)]
Added the path2pop script.

15 years agoRemoved an unnecessary include.
Michael Orlitzky [Wed, 11 Nov 2009 04:39:44 +0000 (23:39 -0500)]
Removed an unnecessary include.

15 years agoRemoved rows length checks in two places, and replaced them with first-column-not...
Michael Orlitzky [Wed, 11 Nov 2009 04:35:07 +0000 (23:35 -0500)]
Removed rows length checks in two places, and replaced them with first-column-not-None checks.
Removed an unnecessary conditional from get_block_geometry_as_wkt().

15 years agoRenamed pg2kml to blocks2kml; this is more consistent with the lines2kml script.
Michael Orlitzky [Wed, 11 Nov 2009 00:40:19 +0000 (19:40 -0500)]
Renamed pg2kml to blocks2kml; this is more consistent with the lines2kml script.

15 years agoSet a default usage=None for the CLI.default_option_parser() function.
Michael Orlitzky [Wed, 11 Nov 2009 00:39:00 +0000 (19:39 -0500)]
Set a default usage=None for the CLI.default_option_parser() function.
Updated all of the scripts to use the default_option_parser().

15 years agoAdded the CLI module with a default_option_parser() function.
Michael Orlitzky [Wed, 11 Nov 2009 00:31:13 +0000 (19:31 -0500)]
Added the CLI module with a default_option_parser() function.

15 years agoModified the download_data script to download the TIGER blocks.
Michael Orlitzky [Tue, 10 Nov 2009 15:06:40 +0000 (10:06 -0500)]
Modified the download_data script to download the TIGER blocks.
Removed the blocks download targets from the makefile.

15 years agoAdded the Delaware lines to the download_data script.
Michael Orlitzky [Tue, 10 Nov 2009 05:40:22 +0000 (00:40 -0500)]
Added the Delaware lines to the download_data script.

15 years agoAdded a "Related Projects" heading containing a description of TRAGIS.
Michael Orlitzky [Sat, 7 Nov 2009 17:16:00 +0000 (12:16 -0500)]
Added a "Related Projects" heading containing a description of TRAGIS.

15 years agoReplaced a missing "not".
Michael Orlitzky [Sat, 7 Nov 2009 17:15:20 +0000 (12:15 -0500)]
Replaced a missing "not".

15 years agoAdded Python itself, and Shapely to the software requirements.
Michael Orlitzky [Sat, 7 Nov 2009 17:14:37 +0000 (12:14 -0500)]
Added Python itself, and Shapely to the software requirements.

15 years agoChanged most of the <em> elements to <q>.
Michael Orlitzky [Sat, 7 Nov 2009 17:13:46 +0000 (12:13 -0500)]
Changed most of the <em> elements to <q>.

15 years agoAdded styles for blockquotes and regular quotes (<q> elements).
Michael Orlitzky [Sat, 7 Nov 2009 17:11:50 +0000 (12:11 -0500)]
Added styles for blockquotes and regular quotes (<q> elements).
Changed some of the reset styles to use 'inherit' since we don't have to worry about Internet Explorer screwing them up.

15 years agoAdded the first draft of drag_wkt_along_kml_path, most of which is basically cut...
Michael Orlitzky [Sun, 25 Oct 2009 22:23:53 +0000 (18:23 -0400)]
Added the first draft of drag_wkt_along_kml_path, most of which is basically cut-and-pasted from the wkt2kml script.

15 years agoAdded the KML tests to the test script.
Michael Orlitzky [Sun, 25 Oct 2009 22:23:36 +0000 (18:23 -0400)]
Added the KML tests to the test script.

15 years agoAdded the KMLTest module containing the LineString tests.
Michael Orlitzky [Sun, 25 Oct 2009 22:12:34 +0000 (18:12 -0400)]
Added the KMLTest module containing the LineString tests.

15 years agoMerged branch 'master' with the to_kml() fix.
Michael Orlitzky [Sun, 25 Oct 2009 22:11:24 +0000 (18:11 -0400)]
Merged branch 'master' with the to_kml() fix.

15 years agoAdded the LineString class.
Michael Orlitzky [Sun, 25 Oct 2009 22:09:44 +0000 (18:09 -0400)]
Added the LineString class.

15 years agoModified the Geometry.Polygon.from_wkt() method to return a Geometry.Polygon.
Michael Orlitzky [Sun, 25 Oct 2009 22:08:03 +0000 (18:08 -0400)]
Modified the Geometry.Polygon.from_wkt() method to return a Geometry.Polygon.

15 years agoFixed a bug where the Document open/close tags were not output with to_kml().
Michael Orlitzky [Sun, 25 Oct 2009 05:16:28 +0000 (01:16 -0400)]
Fixed a bug where the Document open/close tags were not output with to_kml().

15 years agoUpdated the Geometry tests to use the new operator overloads.
Michael Orlitzky [Sun, 25 Oct 2009 05:14:56 +0000 (01:14 -0400)]
Updated the Geometry tests to use the new operator overloads.

15 years agoChanged the TwoVector add() method to an operator overload.
Michael Orlitzky [Sun, 25 Oct 2009 05:10:30 +0000 (01:10 -0400)]
Changed the TwoVector add() method to an operator overload.
Added an operator overload for TwoVector subtraction.
Added the wkt() method for Polygons.

15 years agoChanged the wording of a comment.
Michael Orlitzky [Sun, 25 Oct 2009 03:35:43 +0000 (23:35 -0400)]
Changed the wording of a comment.

15 years agoAdded the Geometry module and its tests.
Michael Orlitzky [Sat, 24 Oct 2009 23:43:15 +0000 (19:43 -0400)]
Added the Geometry module and its tests.

15 years agoChanged my mind about using the SVN version of Shapely. Now using v1.0.14.
Michael Orlitzky [Wed, 21 Oct 2009 19:26:12 +0000 (15:26 -0400)]
Changed my mind about using the SVN version of Shapely. Now using v1.0.14.

15 years agoAdded the "lib" makefile task.
Michael Orlitzky [Wed, 21 Oct 2009 18:53:44 +0000 (14:53 -0400)]
Added the "lib" makefile task.
Created a README in the "lib" directory explaining the Shapely checkout procedure.

15 years agoAdded a space between the road name and its tlid.
Michael Orlitzky [Wed, 21 Oct 2009 05:42:16 +0000 (01:42 -0400)]
Added a space between the road name and its tlid.
Fixed the query to actually return KML.

15 years agoAdded XML escaping to the KML classes.
Michael Orlitzky [Wed, 21 Oct 2009 05:41:50 +0000 (01:41 -0400)]
Added XML escaping to the KML classes.

15 years agoAdded the lines2kml script.
Michael Orlitzky [Mon, 19 Oct 2009 14:56:26 +0000 (10:56 -0400)]
Added the lines2kml script.

15 years agoUpdated the KML classes with a print_kml() method.
Michael Orlitzky [Mon, 19 Oct 2009 14:17:02 +0000 (10:17 -0400)]
Updated the KML classes with a print_kml() method.
Abstracted the to_kml() and print_kml() methods out in to the KmlObject class for most subclasses.
Modified pg2kml to use the print_kml() method instead of to_kml().

15 years agoAdded a unique index on the tiger_lines "tlid" column.
Michael Orlitzky [Mon, 19 Oct 2009 11:51:40 +0000 (07:51 -0400)]
Added a unique index on the tiger_lines "tlid" column.
Created a quick sed script to filter "BEGIN;" and "END;" from the shp2pgsql output.
Updated the makefile to import the tiger_lines data one row at a time, outside of a transaction.

15 years agoFixed the "all lines" shapefile importing.
Michael Orlitzky [Sun, 11 Oct 2009 18:01:52 +0000 (14:01 -0400)]
Fixed the "all lines" shapefile importing.

15 years agoRemoved a no-longer-correct comment from the makefile.
Michael Orlitzky [Sun, 11 Oct 2009 16:50:21 +0000 (12:50 -0400)]
Removed a no-longer-correct comment from the makefile.

15 years agoAdded the West Virginia county lines files to download_data.
Michael Orlitzky [Sun, 11 Oct 2009 16:49:15 +0000 (12:49 -0400)]
Added the West Virginia county lines files to download_data.

15 years agoAdded the NY and VA county "all lines" files to download_data.
Michael Orlitzky [Thu, 8 Oct 2009 11:38:51 +0000 (07:38 -0400)]
Added the NY and VA county "all lines" files to download_data.

15 years agoAdded a new script, download_data, to aid in the retrieval of the census data.
Michael Orlitzky [Wed, 7 Oct 2009 15:06:05 +0000 (11:06 -0400)]
Added a new script, download_data, to aid in the retrieval of the census data.
Moved the 'all lines' data retrieval out of the makefile and in to the new script (currently: D.C., MD, PA only).

15 years agoAdded the Data module which contains the classes and functions used to download the...
Michael Orlitzky [Wed, 7 Oct 2009 15:02:57 +0000 (11:02 -0400)]
Added the Data module which contains the classes and functions used to download the online census data files.

15 years agoAdded the FileUtils module.
Michael Orlitzky [Wed, 7 Oct 2009 14:58:13 +0000 (10:58 -0400)]
Added the FileUtils module.

15 years agoAdded the MD lines import to the makefile.
Michael Orlitzky [Sun, 4 Oct 2009 17:18:51 +0000 (13:18 -0400)]
Added the MD lines import to the makefile.
Reworked the data target to be more modular.
Made the blocks/lines import via wildcard.
Fixed all of the index/append inconsistencies in the shp2pgsql usage.

15 years agoAdded the D.C. blocks download/import.
Michael Orlitzky [Sun, 4 Oct 2009 05:35:04 +0000 (01:35 -0400)]
Added the D.C. blocks download/import.
Created a tiger_lines task initially handling only the D.C. lines.
Added URLs for all of the MD county all-lines shapefiles.

15 years agoMoved the default initialization for the Census class in to its constructor.
Michael Orlitzky [Sat, 3 Oct 2009 20:51:26 +0000 (16:51 -0400)]
Moved the default initialization for the Census class in to its constructor.
Removed an unnecessary GPS import from CensusTest.

15 years agoAdded a style for the <strong> element.
Michael Orlitzky [Sat, 3 Oct 2009 19:26:29 +0000 (15:26 -0400)]
Added a style for the <strong> element.

15 years agoAdded some possible optimizations to the project overview.
Michael Orlitzky [Sat, 3 Oct 2009 19:20:58 +0000 (15:20 -0400)]
Added some possible optimizations to the project overview.

15 years agoUpdated the makefile to import TIGER block data for MD, VA, PA, and NY.
Michael Orlitzky [Sat, 3 Oct 2009 18:59:51 +0000 (14:59 -0400)]
Updated the makefile to import TIGER block data for MD, VA, PA, and NY.
Removed quotes from some makefile variables.
Redirected psql output to /dev/null.

15 years agoRenamed the "tiger" table to "tiger_blocks" in preparation for the addition of the...
Michael Orlitzky [Sat, 3 Oct 2009 17:26:14 +0000 (13:26 -0400)]
Renamed the "tiger" table to "tiger_blocks" in preparation for the addition of the TIGER road data.
Shortened the name of the "tiger_blkidfp00" method/column to just "blkidfp00".

15 years agoUpdated the makefile to use the 2009 TIGER/Line shapefiles.
Michael Orlitzky [Sat, 3 Oct 2009 04:28:31 +0000 (00:28 -0400)]
Updated the makefile to use the 2009 TIGER/Line shapefiles.

15 years agoSwitched the order of longitude/latitude in a comment.
Michael Orlitzky [Sat, 3 Oct 2009 04:27:51 +0000 (00:27 -0400)]
Switched the order of longitude/latitude in a comment.

15 years agoUpdated the TIGER/Line technical documentation for the 2009 shapefiles.
Michael Orlitzky [Fri, 2 Oct 2009 20:32:27 +0000 (16:32 -0400)]
Updated the TIGER/Line technical documentation for the 2009 shapefiles.

15 years agoAdded default values for the GPS.Coordinates constructor.
Michael Orlitzky [Thu, 1 Oct 2009 13:44:54 +0000 (09:44 -0400)]
Added default values for the GPS.Coordinates constructor.

15 years agoRemoved the math import from GPS.
Michael Orlitzky [Thu, 1 Oct 2009 13:37:14 +0000 (09:37 -0400)]
Removed the math import from GPS.

15 years agoRemoved unused code from the GPS and SummaryFile1 modules.
Michael Orlitzky [Mon, 28 Sep 2009 02:26:56 +0000 (22:26 -0400)]
Removed unused code from the GPS and SummaryFile1 modules.
Removed the tests utilizing that unused code.

15 years agoAdded unit tests for the Census.Database class.
Michael Orlitzky [Mon, 28 Sep 2009 02:24:12 +0000 (22:24 -0400)]
Added unit tests for the Census.Database class.
Created a new method in the Census.Database class for testing.
Updated the test script with the new suite.

15 years agoChanged the default SRID constant to an integer (as opposed to a string).
Michael Orlitzky [Mon, 28 Sep 2009 02:21:22 +0000 (22:21 -0400)]
Changed the default SRID constant to an integer (as opposed to a string).

15 years agoFactored out the contained population code in to the Census.Database class.
Michael Orlitzky [Sun, 27 Sep 2009 21:17:25 +0000 (17:17 -0400)]
Factored out the contained population code in to the Census.Database class.
Modified wkt2pop to use the new Census.Database method.

15 years agoAdded the Census module.
Michael Orlitzky [Sun, 27 Sep 2009 20:56:04 +0000 (16:56 -0400)]
Added the Census module.
Factored out the find_average_population_density database code into the Census.Database class.

15 years agoConverted the SRID argument to type="int".
Michael Orlitzky [Sun, 27 Sep 2009 20:26:43 +0000 (16:26 -0400)]
Converted the SRID argument to type="int".

15 years agoAdded the wkt2pop script.
Michael Orlitzky [Thu, 24 Sep 2009 04:56:46 +0000 (00:56 -0400)]
Added the wkt2pop script.

15 years agoUpdated the docstring for wkt2kml.
Michael Orlitzky [Thu, 24 Sep 2009 04:52:17 +0000 (00:52 -0400)]
Updated the docstring for wkt2kml.