Name: pghdb.sde.Addresses_XAPO

Display Field: st_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8915834.36881062
YMin: 4918708.32255988
XMax: -8890768.81205066
YMax: 4938936.35285843
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid_12

Unique ID Field:

Name : objectid_12

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• objectid_12 (type: esriFieldTypeOID, alias: objectid_12, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• objectid (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• feature_ke (type: esriFieldTypeInteger, alias: FEATURE_KE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• address_id (type: esriFieldTypeInteger, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parent_id (type: esriFieldTypeString, alias: PARENT_ID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• street_id (type: esriFieldTypeInteger, alias: STREET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dup_street (type: esriFieldTypeInteger, alias: DUP_STREET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• address_ty (type: esriFieldTypeInteger, alias: ADDRESS_TY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• addr_num_p (type: esriFieldTypeString, alias: ADDR_NUM_P, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• addr_num (type: esriFieldTypeString, alias: ADDR_NUM, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• addr_num_s (type: esriFieldTypeString, alias: ADDR_NUM_S, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_premodi (type: esriFieldTypeString, alias: ST_PREMODI, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_prefix (type: esriFieldTypeString, alias: ST_PREFIX, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_pretype (type: esriFieldTypeString, alias: ST_PRETYPE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_name (type: esriFieldTypeString, alias: ST_NAME, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_type (type: esriFieldTypeString, alias: ST_TYPE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_postmod (type: esriFieldTypeString, alias: ST_POSTMOD, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• unit_type (type: esriFieldTypeString, alias: UNIT_TYPE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• unit (type: esriFieldTypeString, alias: UNIT, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• floor (type: esriFieldTypeString, alias: FLOOR, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• municipali (type: esriFieldTypeString, alias: MUNICIPALI, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• zip_code4 (type: esriFieldTypeString, alias: ZIP_CODE4, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• comment (type: esriFieldTypeString, alias: COMMENT, SQL Type: sqlTypeOther, length: 217, nullable: true, editable: true)
• edit_date (type: esriFieldTypeString, alias: EDIT_DATE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• edit_user (type: esriFieldTypeString, alias: EDIT_USER, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• source (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• exp_flag (type: esriFieldTypeString, alias: EXP_FLAG, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• full_addre (type: esriFieldTypeString, alias: FULL_ADDRE, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• enforce_va (type: esriFieldTypeString, alias: ENFORCE_VA, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• source_id (type: esriFieldTypeString, alias: SOURCE_ID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• st_suffix (type: esriFieldTypeString, alias: ST_SUFFIX, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• globalid (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• objectid_1 (type: esriFieldTypeInteger, alias: OBJECTID_1, SQL Type: sqlTypeOther, nullable: true, editable: false)
• pin (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• mapblocklo (type: esriFieldTypeString, alias: MAPBLOCKLO, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• municode (type: esriFieldTypeInteger, alias: MUNICODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• pseudono (type: esriFieldTypeString, alias: PSEUDONO, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: HOOD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• planning_sectors (type: esriFieldTypeInteger, alias: PLANNING_SECTORS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• census_tract (type: esriFieldTypeString, alias: CENSUS_TRACT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• historic_type (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• historic_name (type: esriFieldTypeString, alias: historic_name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ward (type: esriFieldTypeInteger, alias: WARD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• zoning (type: esriFieldTypeString, alias: zon_new, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• status_1 (type: esriFieldTypeString, alias: status_1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• dpw_divisions (type: esriFieldTypeInteger, alias: dpwdiv, SQL Type: sqlTypeOther, nullable: true, editable: true)
• council_district (type: esriFieldTypeInteger, alias: COUNCIL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• baumcentre (type: esriFieldTypeString, alias: baumcentre, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• nscpo_overlay (type: esriFieldTypeString, alias: nscpo_overlay, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• uptown_ipod (type: esriFieldTypeString, alias: uptown_ipod, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• riverfront_ipod (type: esriFieldTypeString, alias: riverfront_ipod, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• parking_reduction_areas (type: esriFieldTypeString, alias: parking_reduction_areas, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• landslide (type: esriFieldTypeString, alias: CODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• undermined (type: esriFieldTypeString, alias: Und_AA_Field, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• flood_zone (type: esriFieldTypeString, alias: FLD_ZONE, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
• floodway (type: esriFieldTypeString, alias: FLOODWAY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• historic_individual (type: esriFieldTypeString, alias: historic_in_name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• pli_cond (type: esriFieldTypeString, alias: pli_cond, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• parid (type: esriFieldTypeString, alias: PARID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• propertyow (type: esriFieldTypeString, alias: PropertyOwner, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• propertyfr (type: esriFieldTypeString, alias: PropertyFraction, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• propertyad (type: esriFieldTypeString, alias: PropertyAddNumPrefix, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• propertyst (type: esriFieldTypeString, alias: PROPERTYST, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• propertyun (type: esriFieldTypeString, alias: PropertyUnit, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• propertyzi (type: esriFieldTypeDouble, alias: PropertyZip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• munidesc (type: esriFieldTypeString, alias: MUNIDESC, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
• schoolcode (type: esriFieldTypeDouble, alias: SchoolCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• schooldesc (type: esriFieldTypeString, alias: SchoolDesc, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• legal1 (type: esriFieldTypeString, alias: LEGAL1, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• legal2 (type: esriFieldTypeString, alias: LEGAL2, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• legal3 (type: esriFieldTypeString, alias: LEGAL3, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• neighcode (type: esriFieldTypeString, alias: NeighCode, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• neighdesc (type: esriFieldTypeString, alias: NeighDesc, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
• taxcode (type: esriFieldTypeString, alias: TaxCode, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• taxdesc (type: esriFieldTypeString, alias: TaxDesc, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• taxsubcode (type: esriFieldTypeString, alias: TAXSUBCODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ownerdesc (type: esriFieldTypeString, alias: OwnerDesc, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
• usecode (type: esriFieldTypeDouble, alias: UseCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• usedesc (type: esriFieldTypeString, alias: UseDesc, SQL Type: sqlTypeOther, length: 33, nullable: true, editable: true)
• lotarea (type: esriFieldTypeDouble, alias: LotArea, SQL Type: sqlTypeOther, nullable: true, editable: true)
• homesteadf (type: esriFieldTypeString, alias: HomesteadFlag, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• farmsteadf (type: esriFieldTypeString, alias: FarmsteadFlag, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• cleangreen (type: esriFieldTypeString, alias: CleanGreen, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• recorddate (type: esriFieldTypeString, alias: RECORDDATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• saledate (type: esriFieldTypeString, alias: SaleDate, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• saleprice (type: esriFieldTypeDouble, alias: SalePrice, SQL Type: sqlTypeOther, nullable: true, editable: true)
• salecode (type: esriFieldTypeDouble, alias: SaleCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• saledesc (type: esriFieldTypeString, alias: SALEDESC, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• deedbook (type: esriFieldTypeDouble, alias: DeedBook, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deedpage (type: esriFieldTypeDouble, alias: DeedPage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prevsaleda (type: esriFieldTypeString, alias: PREVSALEDA, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• prevsalepr (type: esriFieldTypeDouble, alias: PREVSALEPR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• agent (type: esriFieldTypeString, alias: AGENT, SQL Type: sqlTypeOther, length: 81, nullable: true, editable: true)
• taxfulladd (type: esriFieldTypeString, alias: TAXFULLADD, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
• changenoti (type: esriFieldTypeString, alias: CHANGENOTI, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• countybuil (type: esriFieldTypeDouble, alias: CountyBuilding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• countyland (type: esriFieldTypeDouble, alias: CountyLand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• localbuild (type: esriFieldTypeDouble, alias: LOCALBUILD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• localland (type: esriFieldTypeDouble, alias: LOCALLAND, SQL Type: sqlTypeOther, nullable: true, editable: true)
• localtotal (type: esriFieldTypeDouble, alias: LOCALTOTAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fairmarket (type: esriFieldTypeDouble, alias: FairMarketBuilding, SQL Type: sqlTypeOther, nullable: true, editable: true)
• style (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• styledesc (type: esriFieldTypeString, alias: STYLEDESC, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• stories (type: esriFieldTypeString, alias: Stories, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• yearblt (type: esriFieldTypeString, alias: YEARBLT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• exteriorfi (type: esriFieldTypeString, alias: ExteriorFinish, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• extfinish_ (type: esriFieldTypeString, alias: ExtFinish_Desc, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• roof (type: esriFieldTypeString, alias: Roof, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• roofdesc (type: esriFieldTypeString, alias: ROOFDESC, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• basement (type: esriFieldTypeString, alias: Basement, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• basementde (type: esriFieldTypeString, alias: BASEMENTDE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• grade (type: esriFieldTypeString, alias: Grade, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• gradedesc (type: esriFieldTypeString, alias: GRADEDESC, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• condition (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• conditiond (type: esriFieldTypeString, alias: CONDITIOND, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• totalrooms (type: esriFieldTypeString, alias: TotalRooms, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• bedrooms (type: esriFieldTypeString, alias: BedRooms, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• fullbaths (type: esriFieldTypeString, alias: FullBaths, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• halfbaths (type: esriFieldTypeString, alias: HalfBaths, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• heatingcoo (type: esriFieldTypeString, alias: HeatingCooling, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• fireplaces (type: esriFieldTypeString, alias: Fireplaces, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• finishedli (type: esriFieldTypeString, alias: FinishedLivingArea, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• taxyear (type: esriFieldTypeDouble, alias: TAXYEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• stpredir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• stpretype (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• stname (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• sttype (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• stdir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• state_1 (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• taxsubco_1 (type: esriFieldTypeString, alias: TAXSUBCO_1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• prevsale_1 (type: esriFieldTypeString, alias: PREVSALE_1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• prevsale_2 (type: esriFieldTypeDouble, alias: PREVSALE_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• taxfulla_1 (type: esriFieldTypeString, alias: TAXFULLA_1, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
• taxfulla_2 (type: esriFieldTypeString, alias: TAXFULLA_2, SQL Type: sqlTypeOther, length: 79, nullable: true, editable: true)
• taxfulla_3 (type: esriFieldTypeString, alias: TAXFULLA_3, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
• changeno_1 (type: esriFieldTypeString, alias: CHANGENO_1, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• changeno_2 (type: esriFieldTypeString, alias: CHANGENO_2, SQL Type: sqlTypeOther, length: 61, nullable: true, editable: true)
• changeno_3 (type: esriFieldTypeString, alias: CHANGENO_3, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
• fairmark_1 (type: esriFieldTypeDouble, alias: FairMarketLand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fairmark_2 (type: esriFieldTypeDouble, alias: FairMarketTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• heatingc_1 (type: esriFieldTypeString, alias: HEATINGC_1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)

Templates:

Name: pghdb.sde.Addresses_XAPO
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/22/2019 7:19:57 PM

Schema Last Edit Date: 5/22/2019 7:19:57 PM

Data Last Edit Date: 5/22/2019 7:19:57 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat