PSC_COM_APO_MAPPING
The PSC_COM_APO_MAPPING table stores URLs of GIS feature service informantion and the mapping between GIS attributes of GIS feature to columns of Address, Parcel, Owner table
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PSC_COM_APO_MAPPING_PK |
AGENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| AGENCY_ID | NUMBER | 8 | Yes | Agency Identifier. This is the primary key | Active | |
| PARCEL_REST_URL | VARCHAR2 | 300 | To specify the URL of GIS Parcel feature service | Obsolete | ||
| ADDRESS_REST_URL | VARCHAR2 | 300 | To specify the URL of GIS Address feature service | Obsolete | ||
| OWNER_REST_URL | VARCHAR2 | 300 | To specify the URL of GIS Owner feature service | Obsolete | ||
| PARCEL_LAYER_PID | VARCHAR2 | 30 | To specify the parcel identify attribute of the parcel layer | |||
| ADDRESS_LAYER_PID | VARCHAR2 | 30 | To specify the parcel identify attribute of the parcel address layer | |||
| OWNER_LAYER_PID | VARCHAR2 | 30 | To specify the parcel identify attribute of the parcel owner layer | |||
| P_PARCEL_ID_ENTERED | VARCHAR2 | 50 | Yes | To specify which GIS attribute maps to column PARCEL_ID_ENTERED of the parcel table | Active | |
| P_PRIMARY_FLAG | VARCHAR2 | 30 | To specify which GIS attribute maps to column PRIMARY_FLAG of the parcel table | |||
| P_PARCEL_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column PARCEL_TYPE of the parcel table | Active | ||
| P_JURISDICTION | VARCHAR2 | 30 | To specify which GIS attribute maps to column JURISDICTION of the parcel table | Active | ||
| P_DISTRICT_NAME | VARCHAR2 | 30 | To specify which GIS attribute maps to column DISTRICT_NAME of the parcel table | Active | ||
| P_PROPERTY_DESCRIPTION | VARCHAR2 | 30 | To specify which GIS attribute maps to column PROPERTY_DESCRIPTION of the parcel table | Active | ||
| P_PRIMARY_ZONING_ID | VARCHAR2 | 30 | To specify which GIS attribute maps to column PRIMARY_ZONING_ID of the parcel table | Active | ||
| P_ZONING_DESCRIPTION | VARCHAR2 | 30 | To specify which GIS attribute maps to column ZONING_DESCRIPTION of the parcel table | Active | ||
| P_BLOCK_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column BLOCK_NUM of the parcel table | Active | ||
| P_UNIT_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column UNIT_NUM of the parcel table | Active | ||
| P_LOT_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column LOT_NUM of the parcel table | Active | ||
| P_BOOK_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column BOOK_NUM of the parcel table | Active | ||
| P_SECTION_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column SECTION_NUM of the parcel table | Active | ||
| P_PAGE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column PAGE_NUM of the parcel table | Active | ||
| P_SUBDIVISION | VARCHAR2 | 30 | To specify which GIS attribute maps to column SUBDIVISION of the parcel table | Active | ||
| P_LAND_USE_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LAND_USE_CODE of the parcel table | Active | ||
| P_MAP_NAME | VARCHAR2 | 30 | To specify which GIS attribute maps to column MAP_NAME of the parcel table | Active | ||
| P_MAP_BOOK_PAGE | VARCHAR2 | 30 | To specify which GIS attribute maps to column MAP_BOOK_PAGE of the parcel table | Active | ||
| P_BOUNDARY_DESCRIPTION | VARCHAR2 | 30 | To specify which GIS attribute maps to column BOUNDARY_DESCRIPTION of the parcel table | Active | ||
| P_LONGITUDE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LONGITUDE of the parcel table | Active | ||
| P_LATITUDE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LATITUDE of the parcel table | Active | ||
| P_COORDINATE_X | VARCHAR2 | 30 | To specify which GIS attribute maps to column COORDINATE_X of the parcel table | Active | ||
| P_COORDINATE_Y | VARCHAR2 | 30 | To specify which GIS attribute maps to column COORDINATE_Y of the parcel table | Active | ||
| P_SRID | VARCHAR2 | 30 | To specify which GIS attribute maps to column SRID of the parcel table | Active | ||
| A_PRIMARY_FLAG | VARCHAR2 | 30 | To specify which GIS attribute maps to column PRIMARY_FLAG of the parcel address table | Active | ||
| A_COUNTRY_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTRY_CODE of the parcel address table | Obsolete | ||
| A_STATE_CODE_ISO | VARCHAR2 | 30 | To specify which GIS attribute maps to column STATE_CODE_ISO of the parcel address table | Obsolete | ||
| A_COUNTY_CODE_INCITS | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTY_CODE_INCITS of the parcel address table | Obsolete | ||
| A_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTRY of the parcel address table | Active | ||
| A_STATE | VARCHAR2 | 30 | To specify which GIS attribute maps to column STATE of the parcel address table | Active | ||
| A_COUNTY | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTY of the parcel address table | Active | ||
| A_MUNICIPALITY_ID | VARCHAR2 | 30 | To specify which GIS attribute maps to column MUNICIPALITY_ID of the parcel address table | Active | ||
| A_ADDRESS1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS1 of the parcel address table | Active | ||
| A_ADDRESS2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS2 of the parcel address table | Active | ||
| A_ADDRESS3 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS3 of the parcel address table | Active | ||
| A_ADDRESS4 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS4 of the parcel address table | Active | ||
| A_CITY_NAME | VARCHAR2 | 30 | To specify which GIS attribute maps to column CITY_NAME of the parcel address table | Obsolete | ||
| A_ZIP_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column ZIP_CODE of the parcel address table | Obsolete | ||
| A_HOUSE_NUMBER1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOUSE_NUMBER1 of the parcel address table | Obsolete | ||
| A_HOUSE_NUMBER2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOUSE_NUMBER2 of the parcel address table | Obsolete | ||
| A_CITY | VARCHAR2 | 30 | To specify which GIS attribute maps to column CITY of the parcel address table | Active | ||
| A_PROVINCE | VARCHAR2 | 30 | To specify which GIS attribute maps to column PROVINCE of the parcel address table | |||
| A_POSTAL_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column POSTAL_CODE of the parcel address table | Active | ||
| A_POSTAL_PLUS4_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column POSTAL_PLUS4_CODE of the parcel address table | |||
| A_STREET_NUMBER | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_NUMBER of the parcel address table | Active | ||
| A_STREET_DIRECTION | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_DIRECTION of the parcel address table | Active | ||
| A_STREET_NAME | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_NAME of the parcel address table | Active | ||
| A_STREET_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_TYPE of the parcel address table | Active | ||
| A_BUILDING_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column BUILDING_TYPE of the parcel address table | Active | ||
| A_FLOOR | VARCHAR2 | 30 | To specify which GIS attribute maps to column FLOOR of the parcel address table | Active | ||
| A_UNIT_NUMBER | VARCHAR2 | 30 | To specify which GIS attribute maps to column UNIT_NUMBER of the parcel address table | Active | ||
| A_ADDRESS_FIELD1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_FIELD1 of the parcel address table | Active | ||
| A_ADDRESS_FIELD2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_FIELD2 of the parcel address table | Active | ||
| A_ADDRESS_FIELD3 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_FIELD3 of the parcel address table | Active | ||
| A_ADDRESS_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_TYPE of the parcel address table | Active | ||
| A_EMAIL_ID | VARCHAR2 | 30 | To specify which GIS attribute maps to column EMAIL_ID of the parcel address table | Active | ||
| A_HOME_PHONE_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOME_PHONE_COUNTRY of the parcel address table | Active | ||
| A_HOME_PHONE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOME_PHONE_NUM of the parcel address table | Active | ||
| A_WORK_PHONE_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column WORK_PHONE_COUNTRY of the parcel address table | Active | ||
| A_WORK_PHONE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column WORK_PHONE_NUM of the parcel address table | Active | ||
| A_CELL_PHONE_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column CELL_PHONE_COUNTRY of the parcel address table | Active | ||
| A_CELL_PHONE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column CELL_PHONE_NUM of the parcel address table | Active | ||
| A_FAX_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column FAX_COUNTRY of the parcel address table | Active | ||
| A_FAX_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column FAX_NUM of the parcel address table | Active | ||
| A_LONGITUDE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LONGITUDE of the parcel address table | Active | ||
| A_LATITUDE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LATITUDE of the parcel address table | Active | ||
| A_COORDINATE_X | VARCHAR2 | 30 | To specify which GIS attribute maps to column COORDINATE_X of the parcel address table | Active | ||
| A_COORDINATE_Y | VARCHAR2 | 30 | To specify which GIS attribute maps to column COORDINATE_Y of the parcel address table | Active | ||
| A_SRID | VARCHAR2 | 30 | To specify which GIS attribute maps to column SRID of the parcel address table | Active | ||
| O_PRIMARY_FLAG | VARCHAR2 | 30 | To specify which GIS attribute maps to column PRIMARY_FLAG of the parcel owner table | Active | ||
| O_OWNER_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column OWNER_TYPE of the parcel owner table | Active | ||
| O_NAME1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column NAME1 of the parcel owner table | Active | ||
| O_NAME2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column NAME2 of the parcel owner table | Active | ||
| O_ADDRESS1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS1 of the parcel owner table | Active | ||
| O_ADDRESS2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS2 of the parcel owner table | Active | ||
| O_ADDRESS3 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS3 of the parcel owner table | Active | ||
| O_ADDRESS4 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS4 of the parcel owner table | Active | ||
| O_CITY_NAME | VARCHAR2 | 30 | To specify which GIS attribute maps to column CITY_NAME of the parcel owner table | Obsolete | ||
| O_ZIP_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column ZIP_CODE of the parcel owner table | Obsolete | ||
| O_COUNTRY_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTRY_CODE of the parcel owner table | Obsolete | ||
| O_STATE_CODE_ISO | VARCHAR2 | 30 | To specify which GIS attribute maps to column STATE_CODE_ISO of the parcel owner table | Obsolete | ||
| O_HOUSE_NUMBER1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOUSE_NUMBER1 of the parcel owner table | Obsolete | ||
| O_HOUSE_NUMBER2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOUSE_NUMBER2 of the parcel owner table | Obsolete | ||
| O_CITY | VARCHAR2 | 30 | To specify which GIS attribute maps to column CITY of the parcel owner table | Active | ||
| O_POSTAL_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column POSTAL_CODE of the parcel owner table | Active | ||
| O_POSTAL_PLUS4_CODE | VARCHAR2 | 30 | To specify which GIS attribute maps to column POSTAL_PLUS4_CODE of the parcel owner table | |||
| O_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTRY of the parcel owner table | Active | ||
| O_STATE | VARCHAR2 | 30 | To specify which GIS attribute maps to column STATE of the parcel owner table | Active | ||
| O_PROVINCE | VARCHAR2 | 30 | To specify which GIS attribute maps to column PROVINCE of the parcel owner table | |||
| O_COUNTY | VARCHAR2 | 30 | To specify which GIS attribute maps to column COUNTY of the parcel owner table | |||
| O_STREET_NUMBER | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_NUMBER of the parcel owner table | Active | ||
| O_STREET_DIRECTION | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_DIRECTION of the parcel owner table | Active | ||
| O_STREET_NAME | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_NAME of the parcel owner table | Active | ||
| O_STREET_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column STREET_TYPE of the parcel owner table | Active | ||
| O_BUILDING_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column BUILDING_TYPE of the parcel owner table | Active | ||
| O_FLOOR | VARCHAR2 | 30 | To specify which GIS attribute maps to column FLOOR of the parcel owner table | Active | ||
| O_UNIT_NUMBER | VARCHAR2 | 30 | To specify which GIS attribute maps to column UNIT_NUMBER of the parcel owner table | Active | ||
| O_ADDRESS_FIELD1 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_FIELD1 of the parcel owner table | Active | ||
| O_ADDRESS_FIELD2 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_FIELD2 of the parcel owner table | Active | ||
| O_ADDRESS_FIELD3 | VARCHAR2 | 30 | To specify which GIS attribute maps to column ADDRESS_FIELD3 of the parcel owner table | Active | ||
| O_EMAIL_ID | VARCHAR2 | 30 | To specify which GIS attribute maps to column EMAIL_ID of the parcel owner table | Active | ||
| O_HOME_PHONE_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOME_PHONE_COUNTRY of the parcel owner table | Active | ||
| O_HOME_PHONE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column HOME_PHONE_NUM of the parcel owner table | Active | ||
| O_WORK_PHONE_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column WORK_PHONE_COUNTRY of the parcel owner table | Active | ||
| O_WORK_PHONE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column WORK_PHONE_NUM of the parcel owner table | Active | ||
| O_CELL_PHONE_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column CELL_PHONE_COUNTRY of the parcel owner table | Active | ||
| O_CELL_PHONE_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column CELL_PHONE_NUM of the parcel owner table | Active | ||
| O_FAX_COUNTRY | VARCHAR2 | 30 | To specify which GIS attribute maps to column FAX_COUNTRY of the parcel owner table | Active | ||
| O_FAX_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column FAX_NUM of the parcel owner table | Active | ||
| O_LAST_TRANSFER_TYPE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LAST_TRANSFER_TYPE of the parcel owner table | Active | ||
| O_LAST_TRANSFER_DATE | VARCHAR2 | 30 | To specify which GIS attribute maps to column LAST_TRANSFER_DATE of the parcel owner table | Active | ||
| O_DOCUMENT_NUM | VARCHAR2 | 30 | To specify which GIS attribute maps to column DOCUMENT_NUM of the parcel owner table | Active | ||
| NEG_BUFF_DISTANCE | NUMBER | Yes | To specify the distance of negative buffer | |||
| NEG_BUFF_UNIT | VARCHAR2 | 30 | Yes | To specify the distance unit of negative buffer | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PSC_COM_APO_MAPPING_PK | Unique | Default | AGENCY_ID | Active |