PSC_COM_PARCEL_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name

PARCEL_ID PARCEL_ID_ENTERED PROV_PARCEL_ID_ENTERED FINAL_PARCEL_ID_ENTERED PARENT_PARCEL_ID PARCEL_TYPE ENABLED_FLAG JURISDICTION PRIMARY_ZONING_ID BLOCK_NUM UNIT_NUM LOT_NUM BOOK_NUM SECTION_NUM PAGE_NUM SUBDIVISION LAND_USE_CODE MAP_NAME MAP_BOOK_PAGE LONGITUDE LATITUDE SRID SHAPE BOUNDARY_DESCRIPTION PROPERTY_DESCRIPTION ZONING_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER COORDINATE_X COORDINATE_Y PARCEL_STATUS PARCEL_SIZE1 PARCEL_SIZE1_UNIT PARCEL_SIZE2 PARCEL_SIZE2_UNIT STRUCTURE_SIZE1 STRUCTURE_SIZE1_UNIT STRUCTURE_SIZE2 STRUCTURE_SIZE2_UNIT DWELLING_UNIT_COUNT ZONING_CODE2 GENERAL_PLAN2 TAX_RATE_AREA CENSUS_TRACT CENSUS_BLOCK CLIMATE_ZONE FLOOD_ZONE FLOOD_INS_RATE_MAP LIQUEFACTION_RISK FIRE_RISK LANDSLIDE_RISK SOIL_TYPE YEAR_BUILT BEDROOMS BATHROOMS POOL PATIO ADDITIONAL_STRUCTURE

Query

SQL_Statement

select B.PARCEL_ID, B.PARCEL_ID_ENTERED, B.PROV_PARCEL_ID_ENTERED, B.FINAL_PARCEL_ID_ENTERED, B.PARENT_PARCEL_ID, B.PARCEL_TYPE, B.ENABLED_FLAG, B.JURISDICTION, B.PRIMARY_ZONING_ID, B.BLOCK_NUM, B.UNIT_NUM, B.LOT_NUM, B.BOOK_NUM, B.SECTION_NUM, B.PAGE_NUM, B.SUBDIVISION, B.LAND_USE_CODE, B.MAP_NAME, B.MAP_BOOK_PAGE, B.LONGITUDE, B.LATITUDE, B.SRID, B.SHAPE, L.BOUNDARY_DESCRIPTION, L.PROPERTY_DESCRIPTION, L.ZONING_DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER,B.COORDINATE_X,B.COORDINATE_Y,B.PARCEL_STATUS,B.PARCEL_SIZE1,B.PARCEL_SIZE1_UNIT,B.PARCEL_SIZE2,B.PARCEL_SIZE2_UNIT,B.STRUCTURE_SIZE1,B.STRUCTURE_SIZE1_UNIT,B.STRUCTURE_SIZE2,B.STRUCTURE_SIZE2_UNIT,B.DWELLING_UNIT_COUNT,ZONING_CODE2,GENERAL_PLAN2,TAX_RATE_AREA,CENSUS_TRACT,CENSUS_BLOCK,CLIMATE_ZONE,FLOOD_ZONE,FLOOD_INS_RATE_MAP,LIQUEFACTION_RISK,FIRE_RISK,LANDSLIDE_RISK,SOIL_TYPE,YEAR_BUILT,BEDROOMS,BATHROOMS,POOL,PATIO,ADDITIONAL_STRUCTURE from PSC_COM_PARCEL_B B,PSC_COM_PARCEL_TL L where B.PARCEL_ID = L.PARCEL_ID AND L.LANGUAGE = USERENV('LANG')