Monday, June 21, 2010

New MAR Batch Geocoder Available for Download

The District of Columbia GIS program is releasing a new version of the MAR Batch Geocoder. The new version will allow users to geocode a spreadsheet from Microsoft Excel in lieu of Microsoft Access database tables*. Users can also individually select fields, from the Master Address Repository (MAR), to include in their geocoded results. Find out more by visiting the Master Address Repository Website and clicking Download and Install the MAR Batch Geocoder (.zip).

Geocoding is the process of assigning a location, in the form of coordinate values, to an address. This is done by comparing the descriptive location elements in the address (street name, number, etc.) to those present in the MAR. The MAR is a database of every address in the District of Columbia stored as a point.

*Please uninstall previous versions of the tool by navigating to Start →Programs → MAR Batch Geocoder → Uninstall MAR Batch Geocoder. Users may still continue to use Microsoft Access databases to geocode.

Wednesday, June 9, 2010

Field Research On Tuesday

My coworker and traveled to the field yesterday to make some ground observations. Among the locations we travelled to were:

  • Henson Ridge Phase II: Found and reported an incorrect street sign there (Robinson Street SE), activated addresses of under construction or newly constructed townhouses, and check on the status of 3233 15th Place SE.
  • Asheford Court: No new construction in many months
  • 4th Street Vistas: Some new construction since last visit. No construction workers on site.
  • A new townhouse in Anacostia
  • 5135 F Street SE - no construction there
  • Woodson Heights: No new construction in many months.
  • The Renee Condominiums
  • L Street SE & 8th Street SE
  • 2nd Street NE & G Street NE: Many demolished rownhouses here. These addresses were retired in the MAR.

The weather was lovely and based on the field research dozens of changes were made to the MAR.

Tuesday, June 1, 2010

MAR Monthly Report: May 2010

May 2010 Data Loads:

Dataset Numbers:
  • Addresses: 142,179
  • Residential Units: 193,664
  • Aliases: 5,378
  • Street Name Aliases: 1,055
  • Intersections: 16,740
  • Blocks: 15,856
  • Address / SSL Cross Reference: 23,4317
MAR News:

  • A large number of residential units have been added, updated or deleted. Most of these are due to the processing of the most recent Condo Relate table
  • A new program which will automate most of the process to update intersections in almost complete.
  • Work continues on adding intersections for ramps (example: IRVING STREET NE EASTBOUND AND RAMP FROM NORTH CAPITOL STREET NE NORTHBOUND)