Name: Lead_Violation_Data_Spreadsheet

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId2

Unique ID Field:

Name : ObjectId2

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• property_address (type: esriFieldTypeString, alias: property_address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_zip (type: esriFieldTypeString, alias: property_zip, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• case_number (type: esriFieldTypeString, alias: case_number, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_owner_name (type: esriFieldTypeString, alias: property_owner_name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• case_open_date (type: esriFieldTypeDate, alias: case_open_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• nature_of_complaint (type: esriFieldTypeString, alias: nature_of_complaint, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• case_type (type: esriFieldTypeString, alias: case_type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• case_status (type: esriFieldTypeString, alias: case_status, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_id (type: esriFieldTypeString, alias: property_id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• vacant_property (type: esriFieldTypeString, alias: vacant_property, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_owner_address (type: esriFieldTypeString, alias: property_owner_address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_owner_city (type: esriFieldTypeString, alias: property_owner_city, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_owner_state (type: esriFieldTypeString, alias: property_owner_state, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• property_owner_zip (type: esriFieldTypeString, alias: property_owner_zip, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: neighborhood, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• identifier (type: esriFieldTypeString, alias: identifier, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• long (type: esriFieldTypeDouble, alias: long, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• lat (type: esriFieldTypeDouble, alias: lat, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• TNT_NAME (type: esriFieldTypeString, alias: TNT_NAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeInteger, alias: ObjectId, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId2 (type: esriFieldTypeOID, alias: ObjectId2, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat