Eddie Janowicz

Diagnostic function for detecting unfilled holes in a geometry

1

Land in the hole is unrepresented in the parcel dataset

Currently 'point in poly' is supported. Add 'nearest'. Also add support for tagging 0/1 and populating a dummy variable in the target table.

Function that extracts building data from parcel data, assuming the case when building information is embedded in the parcel data. Example: buildings = extract_buildings(parcels)

Function to slice geometry along the boundaries of another geometry.  Example SQL (using the small spandex test data to slice parcels along block group boundaries): with a as( select...

Populate parcel fields with values from raster datasets. Examples: aggregate(parcels, slope, how='mean') aggregate(parcels, altitude, how='centroid')

Function used to detect condo ownership records that have been stored as tiny parcels or stacked parcels. Ownership records are merged into a single building/parcel record with one geometry.

Function used to clear attributes/agents from parcels. Applied when land is to be treated off-model or when land is known to be vacant. Examples: clear_attributes(parcels, vacant) clear_attributes(parcels, gov_land) clear_attributes(parcels, tribal_land)

Function used to make and track one-off fixes/assertions/look-up-based-corrections to the data. Examples: assert(buildings, 'sqft_per_unit','>250') assert(buildings, 'non_residential_sqft',0,'building_type_id=1') assert(buildings, 'non_residential_sqft','footprint_area*stories','building_type_id>2') assert(parcels, 'land_use_type_id',10,'parcel_id==2314')

Function to impute missing/invalid/outlying values using predictions from a regression model or other statistical model (e.g. poisson). Applies regression equation, which may have been estimated in urbansim or statsmodels. Examples:...

Function to add/impute values in the disaggregate data (e.g. buildings, establishments) from spatial points representing observed values, such as from commercial data sources (e.g. InfoUSA, Metrostudy, Costar, Exceligent, REIS, Axiometric,...