Layers:

Layer: DOIT.SAM_PROPERTY_ASSESSMENT_PARCEL_JOIN_FY23 (0)

Name: DOIT.SAM_PROPERTY_ASSESSMENT_PARCEL_JOIN_FY23

Display Field: FULL_STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: eb44603e56074f4ebe2737c191c8db3e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 741292.7962154746
YMin: 2909139.162622303
XMax: 802406.1802220494
YMax: 2969427.026626393
Spatial Reference: 102686  (2249)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Join_Count ( type: esriFieldTypeInteger, alias: Join_Count, editable: true, nullable: true, defaultValue: null, modelName: Join_Count )
• TARGET_FID ( type: esriFieldTypeInteger, alias: TARGET_FID, editable: true, nullable: true, defaultValue: null, modelName: TARGET_FID )
• RELATIONSHIP_TYPE ( type: esriFieldTypeInteger, alias: RELATIONSHIP_TYPE, editable: true, nullable: true, defaultValue: null, modelName: RELATIONSHIP_TYPE )
• BUILDING_ID ( type: esriFieldTypeInteger, alias: BUILDING_ID, editable: true, nullable: true, defaultValue: null, modelName: BUILDING_ID )
• FULL_ADDRESS ( type: esriFieldTypeString, alias: FULL_ADDRESS, editable: true, nullable: true, length: 256, defaultValue: null, modelName: FULL_ADDRESS )
• STREET_NUMBER ( type: esriFieldTypeString, alias: STREET_NUMBER, editable: true, nullable: true, length: 21, defaultValue: null, modelName: STREET_NUMBER )
• IS_RANGE ( type: esriFieldTypeSmallInteger, alias: IS_RANGE, editable: true, nullable: true, defaultValue: null, modelName: IS_RANGE )
• RANGE_FROM ( type: esriFieldTypeString, alias: RANGE_FROM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RANGE_FROM )
• RANGE_TO ( type: esriFieldTypeString, alias: RANGE_TO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RANGE_TO )
• UNIT ( type: esriFieldTypeString, alias: UNIT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• FULL_STREET_NAME ( type: esriFieldTypeString, alias: FULL_STREET_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULL_STREET_NAME )
• STREET_ID ( type: esriFieldTypeInteger, alias: STREET_ID, editable: true, nullable: true, defaultValue: null, modelName: STREET_ID )
• STREET_PREFIX ( type: esriFieldTypeString, alias: STREET_PREFIX, editable: true, nullable: true, length: 1, defaultValue: null, modelName: STREET_PREFIX )
• STREET_BODY ( type: esriFieldTypeString, alias: STREET_BODY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET_BODY )
• STREET_SUFFIX_ABBR ( type: esriFieldTypeString, alias: STREET_SUFFIX_ABBR, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STREET_SUFFIX_ABBR )
• STREET_FULL_SUFFIX ( type: esriFieldTypeString, alias: STREET_FULL_SUFFIX, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_FULL_SUFFIX )
• STREET_SUFFIX_DIR ( type: esriFieldTypeString, alias: STREET_SUFFIX_DIR, editable: true, nullable: true, length: 1, defaultValue: null, modelName: STREET_SUFFIX_DIR )
• STREET_NUMBER_SORT ( type: esriFieldTypeDouble, alias: STREET_NUMBER_SORT, editable: true, nullable: true, defaultValue: null, modelName: STREET_NUMBER_SORT )
• MAILING_NEIGHBORHOOD ( type: esriFieldTypeString, alias: MAILING_NEIGHBORHOOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAILING_NEIGHBORHOOD )
• ZIP_CODE ( type: esriFieldTypeString, alias: ZIP_CODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP_CODE )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• SAM_STREET_ID ( type: esriFieldTypeInteger, alias: SAM_STREET_ID, editable: true, nullable: true, defaultValue: null, modelName: SAM_STREET_ID )
• WARD ( type: esriFieldTypeString, alias: WARD, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WARD )
• PRECINCT_WARD ( type: esriFieldTypeString, alias: PRECINCT_WARD, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRECINCT_WARD )
• PARCEL ( type: esriFieldTypeString, alias: PARCEL, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PARCEL )
• PID ( type: esriFieldTypeString, alias: PID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PID )
• CM_ID ( type: esriFieldTypeString, alias: CM_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CM_ID )
• GIS_ID ( type: esriFieldTypeString, alias: GIS_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GIS_ID )
• ST_NUM ( type: esriFieldTypeInteger, alias: ST_NUM, editable: true, nullable: true, defaultValue: null, modelName: ST_NUM )
• ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ST_NAME )
• UNIT_NUM ( type: esriFieldTypeString, alias: UNIT_NUM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UNIT_NUM )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CITY )
• ZIP_CODE_1 ( type: esriFieldTypeString, alias: ZIP_CODE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ZIP_CODE_1 )
• BLDG_SEQ ( type: esriFieldTypeInteger, alias: BLDG_SEQ, editable: true, nullable: true, defaultValue: null, modelName: BLDG_SEQ )
• NUM_BLDGS ( type: esriFieldTypeInteger, alias: NUM_BLDGS, editable: true, nullable: true, defaultValue: null, modelName: NUM_BLDGS )
• LUC ( type: esriFieldTypeString, alias: LUC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LUC )
• LU ( type: esriFieldTypeString, alias: LU, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LU )
• LU_DESC ( type: esriFieldTypeString, alias: LU_DESC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LU_DESC )
• BLDG_TYPE ( type: esriFieldTypeString, alias: BLDG_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BLDG_TYPE )
• OWN_OCC ( type: esriFieldTypeString, alias: OWN_OCC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWN_OCC )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNER )
• OWNER_MAIL_ADDRESS ( type: esriFieldTypeString, alias: OWNER_MAIL_ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNER_MAIL_ADDRESS )
• RES_FLOOR ( type: esriFieldTypeDouble, alias: RES_FLOOR, editable: true, nullable: true, defaultValue: null, modelName: RES_FLOOR )
• CD_FLOOR ( type: esriFieldTypeString, alias: CD_FLOOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CD_FLOOR )
• RES_UNITS ( type: esriFieldTypeInteger, alias: RES_UNITS, editable: true, nullable: true, defaultValue: null, modelName: RES_UNITS )
• COM_UNITS ( type: esriFieldTypeInteger, alias: COM_UNITS, editable: true, nullable: true, defaultValue: null, modelName: COM_UNITS )
• RC_UNITS ( type: esriFieldTypeInteger, alias: RC_UNITS, editable: true, nullable: true, defaultValue: null, modelName: RC_UNITS )
• LAND_SF ( type: esriFieldTypeDouble, alias: LAND_SF, editable: true, nullable: true, defaultValue: null, modelName: LAND_SF )
• GROSS_AREA ( type: esriFieldTypeDouble, alias: GROSS_AREA, editable: true, nullable: true, defaultValue: null, modelName: GROSS_AREA )
• LIVING_AREA ( type: esriFieldTypeDouble, alias: LIVING_AREA, editable: true, nullable: true, defaultValue: null, modelName: LIVING_AREA )
• LAND_VALUE ( type: esriFieldTypeInteger, alias: LAND_VALUE, editable: true, nullable: true, defaultValue: null, modelName: LAND_VALUE )
• BLDG_VALUE ( type: esriFieldTypeInteger, alias: BLDG_VALUE, editable: true, nullable: true, defaultValue: null, modelName: BLDG_VALUE )
• TOTAL_VALUE ( type: esriFieldTypeInteger, alias: TOTAL_VALUE, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_VALUE )
• GROSS_TAX ( type: esriFieldTypeDouble, alias: GROSS_TAX, editable: true, nullable: true, defaultValue: null, modelName: GROSS_TAX )
• YR_BUILT ( type: esriFieldTypeInteger, alias: YR_BUILT, editable: true, nullable: true, defaultValue: null, modelName: YR_BUILT )
• YR_REMODEL ( type: esriFieldTypeInteger, alias: YR_REMODEL, editable: true, nullable: true, defaultValue: null, modelName: YR_REMODEL )
• STRUCTURE_CLASS ( type: esriFieldTypeString, alias: STRUCTURE_CLASS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STRUCTURE_CLASS )
• ROOF_STRUCTURE ( type: esriFieldTypeString, alias: ROOF_STRUCTURE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROOF_STRUCTURE )
• ROOF_COVER ( type: esriFieldTypeString, alias: ROOF_COVER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROOF_COVER )
• INT_WALL ( type: esriFieldTypeString, alias: INT_WALL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INT_WALL )
• EXT_FNISHED ( type: esriFieldTypeString, alias: EXT_FNISHED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXT_FNISHED )
• INT_COND ( type: esriFieldTypeString, alias: INT_COND, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INT_COND )
• EXT_COND ( type: esriFieldTypeString, alias: EXT_COND, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EXT_COND )
• OVERALL_COND ( type: esriFieldTypeString, alias: OVERALL_COND, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OVERALL_COND )
• BED_RMS ( type: esriFieldTypeInteger, alias: BED_RMS, editable: true, nullable: true, defaultValue: null, modelName: BED_RMS )
• FULL_BTH ( type: esriFieldTypeInteger, alias: FULL_BTH, editable: true, nullable: true, defaultValue: null, modelName: FULL_BTH )
• HLF_BTH ( type: esriFieldTypeInteger, alias: HLF_BTH, editable: true, nullable: true, defaultValue: null, modelName: HLF_BTH )
• KITCHENS ( type: esriFieldTypeInteger, alias: KITCHENS, editable: true, nullable: true, defaultValue: null, modelName: KITCHENS )
• TT_RMS ( type: esriFieldTypeInteger, alias: TT_RMS, editable: true, nullable: true, defaultValue: null, modelName: TT_RMS )
• BDRM_COND ( type: esriFieldTypeString, alias: BDRM_COND, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BDRM_COND )
• BTHRM_STYLE1 ( type: esriFieldTypeString, alias: BTHRM_STYLE1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BTHRM_STYLE1 )
• BTHRM_STYLE2 ( type: esriFieldTypeString, alias: BTHRM_STYLE2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BTHRM_STYLE2 )
• BTHRM_STYLE3 ( type: esriFieldTypeString, alias: BTHRM_STYLE3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BTHRM_STYLE3 )
• KITCHEN_TYPE ( type: esriFieldTypeString, alias: KITCHEN_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KITCHEN_TYPE )
• KITCHEN_STYLE1 ( type: esriFieldTypeString, alias: KITCHEN_STYLE1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KITCHEN_STYLE1 )
• KITCHEN_STYLE2 ( type: esriFieldTypeString, alias: KITCHEN_STYLE2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KITCHEN_STYLE2 )
• KITCHEN_STYLE3 ( type: esriFieldTypeString, alias: KITCHEN_STYLE3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KITCHEN_STYLE3 )
• HEAT_TYPE ( type: esriFieldTypeString, alias: HEAT_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HEAT_TYPE )
• HEAT_FUEL ( type: esriFieldTypeString, alias: HEAT_FUEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HEAT_FUEL )
• AC_TYPE ( type: esriFieldTypeString, alias: AC_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AC_TYPE )
• FIREPLACES ( type: esriFieldTypeInteger, alias: FIREPLACES, editable: true, nullable: true, defaultValue: null, modelName: FIREPLACES )
• ORIENTATION ( type: esriFieldTypeString, alias: ORIENTATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ORIENTATION )
• NUM_PARKING ( type: esriFieldTypeInteger, alias: NUM_PARKING, editable: true, nullable: true, defaultValue: null, modelName: NUM_PARKING )
• PROP_VIEW ( type: esriFieldTypeString, alias: PROP_VIEW, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROP_VIEW )
• CORNER_UNIT ( type: esriFieldTypeString, alias: CORNER_UNIT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CORNER_UNIT )
• MAP_PAR_ID ( type: esriFieldTypeString, alias: MAP_PAR_ID, editable: true, nullable: true, length: 26, defaultValue: null, modelName: MAP_PAR_ID )
• LOC_ID ( type: esriFieldTypeString, alias: LOC_ID, editable: true, nullable: true, length: 18, defaultValue: null, modelName: LOC_ID )
• POLY_TYPE ( type: esriFieldTypeString, alias: POLY_TYPE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: POLY_TYPE )
• MAP_NO ( type: esriFieldTypeInteger, alias: MAP_NO, editable: true, nullable: true, defaultValue: null, modelName: MAP_NO )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SOURCE )
• PLAN_ID ( type: esriFieldTypeString, alias: PLAN_ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PLAN_ID )
• LAST_EDIT ( type: esriFieldTypeInteger, alias: LAST_EDIT, editable: true, nullable: true, defaultValue: null, modelName: LAST_EDIT )
• BND_CHK ( type: esriFieldTypeString, alias: BND_CHK, editable: true, nullable: true, length: 2, defaultValue: null, modelName: BND_CHK )
• NO_MATCH ( type: esriFieldTypeString, alias: NO_MATCH, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NO_MATCH )
• TOWN_ID ( type: esriFieldTypeSmallInteger, alias: TOWN_ID, editable: true, nullable: true, defaultValue: null, modelName: TOWN_ID )
• FULL_ADDRESS_1 ( type: esriFieldTypeString, alias: FULL_ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULL_ADDRESS_1 )
• ADDRESS_ID ( type: esriFieldTypeInteger, alias: ADDRESS_ID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_ID )
• is_residential ( type: esriFieldTypeString, alias: is_residential, editable: true, nullable: true, length: 512, defaultValue: null, modelName: is_residential )
Templates:
• Name: DOIT.SAM_PROPERTY_ASSESSMENT_PARCEL_JOIN_FY23
  Description:
  Prototype:
  ADDRESS_ID: null
  is_residential: null
  Join_Count: null
  TARGET_FID: null
  RELATIONSHIP_TYPE: null
  BUILDING_ID: null
  FULL_ADDRESS: null
  STREET_NUMBER: null
  IS_RANGE: null
  RANGE_FROM: null
  RANGE_TO: null
  UNIT: null
  FULL_STREET_NAME: null
  STREET_ID: null
  STREET_PREFIX: null
  STREET_BODY: null
  STREET_SUFFIX_ABBR: null
  STREET_FULL_SUFFIX: null
  STREET_SUFFIX_DIR: null
  STREET_NUMBER_SORT: null
  MAILING_NEIGHBORHOOD: null
  ZIP_CODE: null
  X_COORD: null
  Y_COORD: null
  SAM_STREET_ID: null
  WARD: null
  PRECINCT_WARD: null
  PARCEL: null
  PID: null
  CM_ID: null
  GIS_ID: null
  ST_NUM: null
  ST_NAME: null
  UNIT_NUM: null
  CITY: null
  ZIP_CODE_1: null
  BLDG_SEQ: null
  NUM_BLDGS: null
  LUC: null
  LU: null
  LU_DESC: null
  BLDG_TYPE: null
  OWN_OCC: null
  OWNER: null
  OWNER_MAIL_ADDRESS: null
  RES_FLOOR: null
  CD_FLOOR: null
  RES_UNITS: null
  COM_UNITS: null
  RC_UNITS: null
  LAND_SF: null
  GROSS_AREA: null
  LIVING_AREA: null
  LAND_VALUE: null
  BLDG_VALUE: null
  TOTAL_VALUE: null
  GROSS_TAX: null
  YR_BUILT: null
  YR_REMODEL: null
  STRUCTURE_CLASS: null
  ROOF_STRUCTURE: null
  ROOF_COVER: null
  INT_WALL: null
  EXT_FNISHED: null
  INT_COND: null
  EXT_COND: null
  OVERALL_COND: null
  BED_RMS: null
  FULL_BTH: null
  HLF_BTH: null
  KITCHENS: null
  TT_RMS: null
  BDRM_COND: null
  BTHRM_STYLE1: null
  BTHRM_STYLE2: null
  BTHRM_STYLE3: null
  KITCHEN_TYPE: null
  KITCHEN_STYLE1: null
  KITCHEN_STYLE2: null
  KITCHEN_STYLE3: null
  HEAT_TYPE: null
  HEAT_FUEL: null
  AC_TYPE: null
  FIREPLACES: null
  ORIENTATION: null
  NUM_PARKING: null
  PROP_VIEW: null
  CORNER_UNIT: null
  MAP_PAR_ID: null
  LOC_ID: null
  POLY_TYPE: null
  MAP_NO: null
  SOURCE: null
  PLAN_ID: null
  LAST_EDIT: null
  BND_CHK: null
  NO_MATCH: null
  TOWN_ID: null
  FULL_ADDRESS_1: null
  
  Drawing Tool: esriFeatureEditToolPoint