spandex
spandex copied to clipboard
UDST
Spatial Analysis and Data Extraction
In targets/synthesis, when a count column is passed, the adding or removing rows is done in two functions: `_add_rows_by_count` or `_remove_rows_by_count`. Inside these functions, there is a case that is...
In spandex/targets/synthesis, when a count column is passed, the target value is matched by the sum of the count column instead of counting the number of rows. In the allocation...
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')