Name: blight_violation_notices

Display Field: agency_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: development.dbt_mart_incidents.blight_violation_notices_90

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.28746
YMin: 42.25577
XMax: -82.91112
YMax: 42.45002
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[110,31,147,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ESRI_OID

Unique ID Field:

Name : ESRI_OID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ticket_id (type: esriFieldTypeInteger, alias: Ticket ID, SQL Type: sqlTypeOther, nullable: true, editable: false)
• ticket_number (type: esriFieldTypeString, alias: Ticket Number, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• agency_name (type: esriFieldTypeString, alias: Agency Name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• inspector_name (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• violator_name (type: esriFieldTypeString, alias: Violator Name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• violation_street_number (type: esriFieldTypeDouble, alias: Violation Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• violation_street_name (type: esriFieldTypeString, alias: Violation Street Name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• violation_address (type: esriFieldTypeString, alias: Violation Address, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• violation_zip_code (type: esriFieldTypeString, alias: Violation Zip Code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• violator_id (type: esriFieldTypeInteger, alias: Violator ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mailing_address_street_number (type: esriFieldTypeString, alias: Mailing Address Street Number, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• mailing_address_street_name (type: esriFieldTypeString, alias: Mailing Address Street Name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• mailing_address (type: esriFieldTypeString, alias: Mailing Street Address, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: Mailing City, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: Mailing State, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: Mailing Zip Code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• non_us_str_code (type: esriFieldTypeString, alias: International Mailing Address, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• country (type: esriFieldTypeString, alias: Mailing Country, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• violation_date (type: esriFieldTypeDate, alias: Violation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ticket_issued_time (type: esriFieldTypeDate, alias: Ticket Issued Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• hearing_date (type: esriFieldTypeDate, alias: Hearing Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• hearing_time (type: esriFieldTypeString, alias: Hearing Time, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• judgment_date (type: esriFieldTypeDate, alias: Judgment Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ordinance_law (type: esriFieldTypeString, alias: Ordinance Law, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• ordinance_description (type: esriFieldTypeString, alias: Ordinance Description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• disposition (type: esriFieldTypeString, alias: Disposition, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• fine_amount (type: esriFieldTypeDouble, alias: Fine Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• admin_fee (type: esriFieldTypeDouble, alias: Admin Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• state_fee (type: esriFieldTypeDouble, alias: State Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• late_fee (type: esriFieldTypeDouble, alias: Late Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• discount_amount (type: esriFieldTypeDouble, alias: Discount Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• clean_up_cost (type: esriFieldTypeDouble, alias: Clean Up Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• judgment_amount (type: esriFieldTypeDouble, alias: Judgment Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payment_amount (type: esriFieldTypeDouble, alias: Payment Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• balance_due (type: esriFieldTypeDouble, alias: Balance Due, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payment_date (type: esriFieldTypeDate, alias: Payment Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• payment_status (type: esriFieldTypeString, alias: Payment Status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• collection_status (type: esriFieldTypeString, alias: Collection Status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• parcelno (type: esriFieldTypeString, alias: Parcel Number, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• address_id (type: esriFieldTypeInteger, alias: Address ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• updated_at (type: esriFieldTypeDate, alias: Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: blight_violation_notices
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/7/2025 7:53:42 PM

Schema Last Edit Date: 4/7/2025 7:53:42 PM

Data Last Edit Date: 4/7/2025 7:53:42 PM

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