...
Page Properties | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
|
Info | ||
---|---|---|
| ||
These stored procedures have been deprecated from v6.0.0 |
With Innogistic sites running on SQL Server we have a 'proxy' type SQL Server database, normally called iShare, that references all the other SQL Server databases. This way if a customer needs to create custom views etc. they have one point of call.
...
Database view for BuildAddresses
...
Field | Description |
---|---|
UPRN | Unique Property Reference Number |
USRN | Unique Street Reference Number |
EASTING | Coordinate |
NORTHING | Coordinate |
POSTCODE | Postcode |
SAON_START_NUM | Secondary Addressable Object Start Number |
SAON_START_SUFFIX | Secondary Addressable Object Start Suffix |
SAON_END_NUM | Secondary Addressable Object End Number |
SAON_END_SUFFIX | Secondary Addressable Object End Suffix |
SAON_TEXT | Secondary Addressable Object Text |
PAON_START_NUM | Primary Addressable Object Start Number |
PAON_START_SUFFIX | Primary Addressable Object Start Suffix |
PAON_END_NUM | Primary Addressable Object End Number |
PAON_END_SUFFIX | Primary Addressable Object End Suffix |
PAON_TEXT | Primary Addressable Object Text |
DESCRIPTION | Street text |
POSTTOWN | Town |
TOWN | Town |
LOC | Locality |
DISTRICT | County |
COUNTY | County |
SQL View in the iShare Database
...