View In:   ArcGIS Online Map Viewer

Name: Utility Billing Location

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4b0e7e1c8ae0444fabee9c5dc8e8ba76

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9026.0

Max Scale: 0.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: -9835470.643205833
YMin: 5076949.219790759
XMax: -9795212.475831436
YMax: 5100412.298335663
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [LOC_ID]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 4511.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• ZONING ( type: esriFieldTypeString, alias: ZONING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ZONING )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RowID ( type: esriFieldTypeInteger, alias: RowID, editable: true, nullable: true, defaultValue: null, modelName: RowID )
• LOC_ID ( type: esriFieldTypeString, alias: LOC_ID, editable: true, nullable: false, length: 30, defaultValue: null, modelName: LOC_ID )
• AddrRowID ( type: esriFieldTypeInteger, alias: AddrRowID, editable: true, nullable: true, defaultValue: null, modelName: AddrRowID )
• ADDR_OID ( type: esriFieldTypeInteger, alias: ADDR_OID, editable: true, nullable: true, defaultValue: null, modelName: ADDR_OID )
• utacm_key ( type: esriFieldTypeInteger, alias: utacm_key, editable: true, nullable: false, defaultValue: null, modelName: utacm_key )
• utacm_account ( type: esriFieldTypeString, alias: utacm_account, editable: true, nullable: false, length: 30, defaultValue: null, modelName: utacm_account )
• utacm_parcel ( type: esriFieldTypeString, alias: utacm_parcel, editable: true, nullable: true, length: 30, defaultValue: null, modelName: utacm_parcel )
• utacm_start_date ( type: esriFieldTypeDate, alias: utacm_start_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utacm_start_date )
• utacm_stop_date ( type: esriFieldTypeDate, alias: utacm_stop_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utacm_stop_date )
• utacm_cplm_key ( type: esriFieldTypeInteger, alias: utacm_cplm_key, editable: true, nullable: true, defaultValue: null, modelName: utacm_cplm_key )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: false, length: 1, defaultValue: null, modelName: STATUS )
• utacm_loc_no ( type: esriFieldTypeInteger, alias: utacm_loc_no, editable: true, nullable: true, defaultValue: null, modelName: utacm_loc_no )
• utacm_loc_no_suff ( type: esriFieldTypeString, alias: utacm_loc_no_suff, editable: true, nullable: true, length: 5, defaultValue: null, modelName: utacm_loc_no_suff )
• utacm_loc_pre_dir ( type: esriFieldTypeString, alias: utacm_loc_pre_dir, editable: true, nullable: true, length: 4, defaultValue: null, modelName: utacm_loc_pre_dir )
• utacm_loc_street ( type: esriFieldTypeString, alias: utacm_loc_street, editable: true, nullable: true, length: 25, defaultValue: null, modelName: utacm_loc_street )
• utacm_loc_str_typ ( type: esriFieldTypeString, alias: utacm_loc_str_typ, editable: true, nullable: true, length: 10, defaultValue: null, modelName: utacm_loc_str_typ )
• utacm_loc_post_dir ( type: esriFieldTypeString, alias: utacm_loc_post_dir, editable: true, nullable: true, length: 4, defaultValue: null, modelName: utacm_loc_post_dir )
• utacm_loc_unit_typ ( type: esriFieldTypeString, alias: utacm_loc_unit_typ, editable: true, nullable: true, length: 10, defaultValue: null, modelName: utacm_loc_unit_typ )
• utacm_loc_apt ( type: esriFieldTypeString, alias: utacm_loc_apt, editable: true, nullable: true, length: 5, defaultValue: null, modelName: utacm_loc_apt )
• utacm_loc_city ( type: esriFieldTypeString, alias: utacm_loc_city, editable: true, nullable: true, length: 4, defaultValue: null, modelName: utacm_loc_city )
• utacm_loc_state ( type: esriFieldTypeString, alias: utacm_loc_state, editable: true, nullable: true, length: 2, defaultValue: null, modelName: utacm_loc_state )
• utacm_loc_zip ( type: esriFieldTypeString, alias: utacm_loc_zip, editable: true, nullable: true, length: 10, defaultValue: null, modelName: utacm_loc_zip )
• utacm_full_address ( type: esriFieldTypeString, alias: utacm_full_address, editable: true, nullable: true, length: 83, defaultValue: null, modelName: utacm_full_address )
• utacm_full_address_sub ( type: esriFieldTypeString, alias: utacm_full_address_sub, editable: true, nullable: true, length: 102, defaultValue: null, modelName: utacm_full_address_sub )
• HOUSE_NUM ( type: esriFieldTypeInteger, alias: HOUSE_NUM, editable: true, nullable: true, defaultValue: null, modelName: HOUSE_NUM )
• HOUSE_SFX ( type: esriFieldTypeString, alias: HOUSE_SFX, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HOUSE_SFX )
• STREET_PREFIX ( type: esriFieldTypeString, alias: STREET_PREFIX, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STREET_PREFIX )
• STREET_PRE_TYPE ( type: esriFieldTypeString, alias: STREET_PRE_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_PRE_TYPE )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET_NAME )
• STREET_TYPE ( type: esriFieldTypeString, alias: STREET_TYPE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STREET_TYPE )
• STREET_SUFFIX ( type: esriFieldTypeString, alias: STREET_SUFFIX, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STREET_SUFFIX )
• STREET_POST_TYPE ( type: esriFieldTypeString, alias: STREET_POST_TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STREET_POST_TYPE )
• FULL_ADDRESS ( type: esriFieldTypeString, alias: FULL_ADDRESS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FULL_ADDRESS )
• MUNI ( type: esriFieldTypeString, alias: MUNI, editable: true, nullable: false, length: 24, defaultValue: null, modelName: MUNI )
• POSTAL_CODE ( type: esriFieldTypeString, alias: POSTAL_CODE, editable: true, nullable: false, length: 24, defaultValue: null, modelName: POSTAL_CODE )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COUNTY )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ZIPCODE )
• ADDR_LOC ( type: esriFieldTypeString, alias: ADDR_LOC, editable: true, nullable: false, length: 10, defaultValue: null, modelName: ADDR_LOC )
• UNIT_OID ( type: esriFieldTypeInteger, alias: UNIT_OID, editable: true, nullable: true, defaultValue: null, modelName: UNIT_OID )
• UNIT_TYPE ( type: esriFieldTypeString, alias: UNIT_TYPE, editable: true, nullable: true, length: 11, defaultValue: null, modelName: UNIT_TYPE )
• UNIT_NUM ( type: esriFieldTypeString, alias: UNIT_NUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNIT_NUM )
• UNIT_NUM2 ( type: esriFieldTypeString, alias: UNIT_NUM2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNIT_NUM2 )
• FULL_ADDRESS_SUB ( type: esriFieldTypeString, alias: FULL_ADDRESS_SUB, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: FULL_ADDRESS_SUB )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: false, length: 3, defaultValue: null, modelName: SOURCE )
• LAST_OWNER ( type: esriFieldTypeString, alias: LAST_OWNER, editable: true, nullable: true, length: 64, defaultValue: null, modelName: LAST_OWNER )
• OWNER_PHONE ( type: esriFieldTypeString, alias: OWNER_PHONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OWNER_PHONE )
• OWNER_STATUS ( type: esriFieldTypeString, alias: OWNER_STATUS, editable: true, nullable: true, length: 1, defaultValue: null, modelName: OWNER_STATUS )
• LAST_CUSTOMER ( type: esriFieldTypeString, alias: LAST_CUSTOMER, editable: true, nullable: true, length: 64, defaultValue: null, modelName: LAST_CUSTOMER )
• CUSTOMER_PHONE ( type: esriFieldTypeString, alias: CUSTOMER_PHONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CUSTOMER_PHONE )
• CUSTOMER_STATUS ( type: esriFieldTypeString, alias: CUSTOMER_STATUS, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CUSTOMER_STATUS )
• MW ( type: esriFieldTypeString, alias: MW, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MW )
• SW_CON ( type: esriFieldTypeString, alias: SW_CON, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SW_CON )
• SW_UNMEAS ( type: esriFieldTypeString, alias: SW_UNMEAS, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SW_UNMEAS )
• WT ( type: esriFieldTypeString, alias: WT, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WT )
• SEP ( type: esriFieldTypeString, alias: SEP, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SEP )
• QC_NOTE ( type: esriFieldTypeString, alias: QC_NOTE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QC_NOTE )
• FIELD_CHECK ( type: esriFieldTypeSmallInteger, alias: FIELD_CHECK, editable: true, nullable: true, defaultValue: null, modelName: FIELD_CHECK )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• NEW_CPLM_KEY ( type: esriFieldTypeInteger, alias: NEW CPLM KEY, editable: true, nullable: true, defaultValue: null, modelName: NEW_CPLM_KEY )
• LAST_UPDATE ( type: esriFieldTypeDate, alias: LAST_UPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_UPDATE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DELINQUENT ( type: esriFieldTypeSmallInteger, alias: Delinquent, editable: true, nullable: true, defaultValue: 0, modelName: DELINQUENT , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• VACANT ( type: esriFieldTypeSmallInteger, alias: Vacant, editable: true, nullable: true, defaultValue: 0, modelName: VACANT , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• SHUTOFF ( type: esriFieldTypeString, alias: ShutofF, editable: true, nullable: true, length: 20, defaultValue: On, modelName: SHUTOFF , Coded Values: [On: On (Cancel Work Order)] , [Off: Off] , [Work Order - Off: Work Order - Off] , ...1 more... )

Templates:

• Name: Utility Billing Location
  Description:
  Prototype:
  VACANT: 0
  ZONING: null
  DELINQUENT: 0
  RowID: null
  LOC_ID:
  AddrRowID: null
  ADDR_OID: null
  utacm_key: 0
  utacm_account:
  utacm_parcel: null
  utacm_start_date: null
  utacm_stop_date: null
  utacm_cplm_key: null
  STATUS:
  utacm_loc_no: null
  utacm_loc_no_suff: null
  utacm_loc_pre_dir: null
  utacm_loc_street: null
  utacm_loc_str_typ: null
  utacm_loc_post_dir: null
  utacm_loc_unit_typ: null
  utacm_loc_apt: null
  utacm_loc_city: null
  utacm_loc_state: null
  utacm_loc_zip: null
  utacm_full_address: null
  utacm_full_address_sub: null
  HOUSE_NUM: null
  HOUSE_SFX: null
  STREET_PREFIX: null
  STREET_PRE_TYPE: null
  STREET_NAME: null
  STREET_TYPE: null
  STREET_SUFFIX: null
  STREET_POST_TYPE: null
  FULL_ADDRESS: null
  MUNI:
  POSTAL_CODE:
  COUNTY: null
  ZIPCODE: null
  ADDR_LOC:
  UNIT_OID: null
  UNIT_TYPE: null
  UNIT_NUM: null
  UNIT_NUM2: null
  FULL_ADDRESS_SUB: null
  SOURCE:
  LAST_OWNER: null
  OWNER_PHONE: null
  OWNER_STATUS: null
  LAST_CUSTOMER: null
  CUSTOMER_PHONE: null
  CUSTOMER_STATUS: null
  MW: null
  SW_CON: null
  SW_UNMEAS: null
  WT: null
  SEP: null
  QC_NOTE: null
  FIELD_CHECK: null
  POINT_X: null
  POINT_Y: null
  NEW_CPLM_KEY: null
  LAST_UPDATE: null
  SHUTOFF: On
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata