View In:   ArcGIS Online Map Viewer

Name: DOIT.ADDRESSES_MATTRESS_PICKUP_311

Display Field: FULL_STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5d4700a1bb404808b192f0bf340ba63d

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.781451717
YMin: 2909139.1045515537
XMax: 802406.1962981373
YMax: 2969427.0860094726
Spatial Reference: 102686  (2249)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [71, 82, 153, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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 )
• ADDRESS_ID ( type: esriFieldTypeInteger, alias: ADDRESS_ID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS_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 )
• FULL_STREET_NAME ( type: esriFieldTypeString, alias: FULL_STREET_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULL_STREET_NAME )
• UNIT ( type: esriFieldTypeString, alias: UNIT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UNIT )
• 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 )
• 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 )
• 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 )
• MAP_PAR_ID ( type: esriFieldTypeString, alias: MAP_PAR_ID, editable: true, nullable: true, length: 26, defaultValue: null, modelName: MAP_PAR_ID )
• 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 )
• is_residential ( type: esriFieldTypeString, alias: is_residential, editable: true, nullable: false, length: 3, defaultValue: null, modelName: is_residential )
• DIST ( type: esriFieldTypeString, alias: DIST, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DIST )
• PWD_DIST_JOIN ( type: esriFieldTypeString, alias: PWD_DIST_JOIN, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PWD_DIST_JOIN )
• Mattress_Group ( type: esriFieldTypeInteger, alias: Mattress_Group, editable: true, nullable: true, defaultValue: null, modelName: Mattress_Group )
• bulk_item_pickup_day ( type: esriFieldTypeString, alias: bulk_item_pickup_day, editable: true, nullable: true, length: 3, defaultValue: null, modelName: bulk_item_pickup_day )
• Bulk_Group ( type: esriFieldTypeString, alias: Bulk_Group, editable: true, nullable: false, length: 1, defaultValue: null, modelName: Bulk_Group )
• building_address_count ( type: esriFieldTypeInteger, alias: building_address_count, editable: true, nullable: true, defaultValue: null, modelName: building_address_count )

Templates:

• Name: DOIT.ADDRESSES_MATTRESS_PICKUP_311
  Description:
  Prototype:
  Bulk_Group:
  building_address_count: null
  ADDRESS_ID: null
  FULL_ADDRESS: null
  STREET_NUMBER: null
  FULL_STREET_NAME: null
  UNIT: null
  RELATIONSHIP_TYPE: null
  BUILDING_ID: null
  MAILING_NEIGHBORHOOD: null
  ZIP_CODE: null
  X_COORD: null
  Y_COORD: null
  PARCEL: null
  PID: null
  MAP_PAR_ID: null
  BLDG_SEQ: null
  NUM_BLDGS: null
  LUC: null
  LU: null
  LU_DESC: null
  BLDG_TYPE: null
  is_residential:
  DIST: null
  PWD_DIST_JOIN: null
  Mattress_Group: null
  bulk_item_pickup_day: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata