This release includes over 830,000 unique residential neighborhoods, concentrated in – but not limited to – the top 500 metropolitan areas in the US.
As part of an initiative at Precisely to standardize documentation and improve product interoperability, a number of changes were made to the Residential Boundaries Data Schema workbook in this release:
- All CHAR and VARCHAR fields are now represented as TEXT
- Data type and length are displayed in two separate columns
- The following columns were added to the Data Schema tab. Columns with an asterisk ( * ) are for use with Precisely Software Solutions –
- product_table_name
- index
- primary_key
- type_code*
- table_name
- grouping*
- field_friendly_name
- Existing columns were renamed as shown in the following table –
| Current Column Name | New Column Name |
|---|---|
| Table Name | table_friendly_name |
| Seq. | sequence_number |
| Field Name | field_name |
| Data Type (Length) | data type |
| field_length | |
| Field Value Key Reference | field_value_key_reference |
| Description | description |