Table-NLPG_STREET
Created by: Lester Caine, Last modification: 20 Aug 2008 (09:47 UTC)
| Field | Type | NULL | Default | Description |
| USRN | Numeric(18,0) | Primary | ||
| RECORD_TYPE | Integer | NOT NULL | ||
| SWA_ORG_REF_NAMING | Integer | NOT NULL | ||
| STATE | Smallint | |||
| STATE_DATE | Date | |||
| STREET_SURFACE | Smallint | |||
| STREET_CLASSIFICATION | Smallint | |||
| VERSION | Smallint | NOT NULL | ||
| RECORD_ENTRY_DATE | Date | NOT NULL | ||
| LAST_UPDATE_DATE | Date | NOT NULL | ||
| STREET_START_DATE | Date | NOT NULL | ||
| STREET_END_DATE | Date | |||
| STREET_START_X | Double precision | NOT NULL | ||
| STREET_START_Y | Double precision | NOT NULL | ||
| STREET_END_X | Double precision | NOT NULL | ||
| STREET_END_Y | Double precision | NOT NULL | ||
| STREET_TOLERANCE | Smallint |
Links to
NLPG_STREET_XREF
NLPG_STREET_DESCRIPTOR