Name: HCD_VIOLATIONS_PUBLIC

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: vl_all - all complaints received by address an activity number could (and often does) have multiple addresses associated with it - there will be a record for each address(which means duplicate activity numbers)fields:ACT_NUM - activity numberSTATUS_1 - description belowSUB_TYPE - type of complaintTYPE_DESC - description of activity number type (sub-type in permits+)DT_ENT - date complaint was receivedDESCRIPTION - description of complaint receivedINSP_AREA - inspection areasINSP_ASSIGN - inspector assigned by location (could differ from actualinspector in vl_nov) - from base screen RED_FOLDER - if case has been called in by Ward officeNOV - if activity has received a notice of violationADDRESS_FULL - address from permits+ with Struc, Floor and UnitADDRESS_MATCH - address record actually matched toWARD - Ward number from geoprocessing, not permits+TRS - TRS, from geoprocessing, not permits+statuses (same for both layers):CLOSED:CANCEL- case was cancelled administratively - no inspection occurredCOMPLAIN- case is closed as compliantCOURTCMP- closed case where case was heard in court and now is in complianceCOURTNCM- closed case where case was heard in court but owner did not complyINVALID- case was inspected and no violation found. NOVERIFY- case was inspected and no violation foundSUSPENDED- another type of administrative closure of a case that is now seldom usedREFERRED- case opened and it is determined that issue is the responsibility of another department so case has been referred to them.OPEN:FIELD- newly opened case where inspection has not occurred yetOBSERVE- typically used for cases where the owner is granted time to comply either though an appeal or other administrative extensions where the inspector is not required to inspect every 30 days.PENDING- case opened, violation(s) identified and Notice has been mailed out. Waiting for compliance.PERMIT- Case opened and owner issued Notice to obtain permit for work done that needs one. Permit has then been issued and inspector is waiting for permit inspections by PDSD to be completed.CITATION- case is open, owner has not responded to Notice therefore a citation has been issuedCOURT- citation was issued and case has now been heard in court

Copyright Text: Published by City of Tucson Information Technology Department, GIS Services

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: 967739.992454067
YMin: 389736.492454067
XMax: 1069920.13681103
YMax: 481057.874015749
Spatial Reference: 2868 (2868)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[117,150,69,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: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FID_HCD_VIOLATIONS_EXPORT_N_2 (type: esriFieldTypeInteger, alias: FID_HCD_VIOLATIONS_EXPORT_NHA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FID_HCD_VIOLATIONS_EXPORT (type: esriFieldTypeInteger, alias: FID_HCD_VIOLATIONS_EXPORT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACT_NUM (type: esriFieldTypeString, alias: ACT_NUM, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• STATUS_1 (type: esriFieldTypeString, alias: STATUS_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SUB_TYPE (type: esriFieldTypeString, alias: SUB_TYPE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TYPE_DESC (type: esriFieldTypeString, alias: TYPE_DESC, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• INSP_AREA (type: esriFieldTypeString, alias: INSP_AREA, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSP_ASSIGN (type: esriFieldTypeString, alias: INSP_ASSIGN, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• RED_FOLDER (type: esriFieldTypeString, alias: RED_FOLDER, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ADDRESSFULL (type: esriFieldTypeString, alias: ADDRESSFULL, SQL Type: sqlTypeOther, length: 96, nullable: true, editable: true)
• WARD (type: esriFieldTypeString, alias: WARD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• TRS (type: esriFieldTypeString, alias: TRS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADDRESSMATCH (type: esriFieldTypeString, alias: ADDRESSMATCH, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• NOV (type: esriFieldTypeString, alias: NOV, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MAPTIP (type: esriFieldTypeString, alias: MAPTIP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• DATASOURCE (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FID_NHA_CITY (type: esriFieldTypeInteger, alias: FID_NHA_CITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• COT_MAP_NO (type: esriFieldTypeDouble, alias: COT_MAP_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KEYID (type: esriFieldTypeDouble, alias: KEYID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• WARD_1 (type: esriFieldTypeDouble, alias: WARD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COALITIONS (type: esriFieldTypeString, alias: COALITIONS, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• MAPTIP_1 (type: esriFieldTypeString, alias: MAPTIP, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• URL_1 (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DATASOURCE_1 (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FID_PAREGION (type: esriFieldTypeInteger, alias: FID_PAREGION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• vectorsde_GISDATA_PAREGION__32 (type: esriFieldTypeDouble, alias: vectorsde.GISDATA.PAREGION.AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERIMETER (type: esriFieldTypeDouble, alias: PERIMETER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARCELIDX (type: esriFieldTypeString, alias: PARCELIDX, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• DPARCEL (type: esriFieldTypeString, alias: DPARCEL, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• PARCEL (type: esriFieldTypeString, alias: PARCEL, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• OID_ (type: esriFieldTypeInteger, alias: OID_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FILEID (type: esriFieldTypeString, alias: FILEID, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GROUPCODE (type: esriFieldTypeString, alias: GROUPCODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• COUNTYCODE (type: esriFieldTypeString, alias: COUNTYCODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• MP (type: esriFieldTypeString, alias: MP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SEQ_NUM_S_old (type: esriFieldTypeString, alias: SEQ_NUM_S, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• ASRAREA (type: esriFieldTypeString, alias: ASRAREA, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• EXEMPT (type: esriFieldTypeString, alias: EXEMPT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PRIORLMTD (type: esriFieldTypeInteger, alias: PRIORLMTD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURRENTLMT (type: esriFieldTypeInteger, alias: CURRENTLMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USE_ (type: esriFieldTypeString, alias: USE_, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LANDCLASS (type: esriFieldTypeString, alias: LANDCLASS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LANDRATIO (type: esriFieldTypeDouble, alias: LANDRATIO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LANDMEAS (type: esriFieldTypeString, alias: LANDMEAS, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• LANDUNIT (type: esriFieldTypeString, alias: LANDUNIT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANDFCV (type: esriFieldTypeInteger, alias: LANDFCV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IMPCLASS (type: esriFieldTypeString, alias: IMPCLASS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• IMPRATIO (type: esriFieldTypeDouble, alias: IMPRATIO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IMPFCV (type: esriFieldTypeInteger, alias: IMPFCV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IMPSOURCE (type: esriFieldTypeString, alias: IMPSOURCE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TOTALFCV (type: esriFieldTypeInteger, alias: TOTALFCV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOCKET (type: esriFieldTypeString, alias: DOCKET, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• PAGE (type: esriFieldTypeString, alias: PAGE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SEQ_NUM_D (type: esriFieldTypeString, alias: SEQ_NUM_D, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• RECORDDATE (type: esriFieldTypeString, alias: RECORDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TRS_OL (type: esriFieldTypeString, alias: TRS_OL, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• TRS_1 (type: esriFieldTypeString, alias: TRS, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• SECTMODIF (type: esriFieldTypeString, alias: SECTMODIF, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• OWNERIDX (type: esriFieldTypeString, alias: OWNERIDX, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• TRACT (type: esriFieldTypeString, alias: TRACT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BLOCK (type: esriFieldTypeString, alias: BLOCK, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• LOT (type: esriFieldTypeString, alias: LOT, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LOT_R (type: esriFieldTypeString, alias: LOT_R, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MAIL1 (type: esriFieldTypeString, alias: MAIL1, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
• MAIL2 (type: esriFieldTypeString, alias: MAIL2, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• MAIL3 (type: esriFieldTypeString, alias: MAIL3, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• MAIL4 (type: esriFieldTypeString, alias: MAIL4, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• MAIL5 (type: esriFieldTypeString, alias: MAIL5, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true)
• ZIP9 (type: esriFieldTypeString, alias: ZIP9, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• STREETIDX (type: esriFieldTypeString, alias: STREETIDX, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• STREETNO (type: esriFieldTypeString, alias: STREETNO, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• STREETNO_R (type: esriFieldTypeInteger, alias: STREETNO_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREETDIR (type: esriFieldTypeString, alias: STREETDIR, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• STREETNAME (type: esriFieldTypeString, alias: STREETNAME, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
• STREETCITY (type: esriFieldTypeString, alias: STREETCITY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• JURIS_OL (type: esriFieldTypeString, alias: JURIS_OL, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LEGAL1 (type: esriFieldTypeString, alias: LEGAL1, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
• LEGAL2 (type: esriFieldTypeString, alias: LEGAL2, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
• LEGAL3 (type: esriFieldTypeString, alias: LEGAL3, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
• LEGAL4 (type: esriFieldTypeString, alias: LEGAL4, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
• PETCODE (type: esriFieldTypeString, alias: PETCODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PETYEAR (type: esriFieldTypeString, alias: PETYEAR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PROBCODE (type: esriFieldTypeString, alias: PROBCODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PROBDATE (type: esriFieldTypeString, alias: PROBDATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• LEGAL5 (type: esriFieldTypeString, alias: LEGAL5, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
• TXCREDIT (type: esriFieldTypeString, alias: TXCREDIT, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• TXCREDITYY (type: esriFieldTypeString, alias: TXCREDITYY, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• AFFIDCODE (type: esriFieldTypeString, alias: AFFIDCODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AFFIDDATE (type: esriFieldTypeString, alias: AFFIDDATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• BRDORCODE (type: esriFieldTypeString, alias: BRDORCODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BRDORDDATE (type: esriFieldTypeString, alias: BRDORDDATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• AUXISTAT (type: esriFieldTypeString, alias: AUXISTAT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MRKT (type: esriFieldTypeString, alias: MRKT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• CENSUS (type: esriFieldTypeString, alias: CENSUS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CURZONE (type: esriFieldTypeString, alias: CURZONE, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• ZONEAUTH (type: esriFieldTypeString, alias: ZONEAUTH, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ZONEFLAG (type: esriFieldTypeString, alias: ZONEFLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PARCEL_R (type: esriFieldTypeDouble, alias: PARCEL_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINK (type: esriFieldTypeString, alias: LINK, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• ACRES (type: esriFieldTypeDouble, alias: ACRES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X_HPGN (type: esriFieldTypeDouble, alias: X_HPGN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_HPGN (type: esriFieldTypeDouble, alias: Y_HPGN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LON (type: esriFieldTypeDouble, alias: LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATASOURCE_12 (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MAPTIP_12 (type: esriFieldTypeString, alias: MAPTIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• URL_12 (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• URL2 (type: esriFieldTypeString, alias: URL2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PARCEL_USE (type: esriFieldTypeString, alias: PARCEL_USE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MP_OL (type: esriFieldTypeString, alias: MP_OL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTCHANGE (type: esriFieldTypeDate, alias: LASTCHANGE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DT_ENT (type: esriFieldTypeString, alias: DT_ENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SEQ_NUM_S (type: esriFieldTypeString, alias: SEQ_NUM_S, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: HCD_VIOLATIONS_PUBLIC
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ACT_NUM:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 11:16:00 AM

Schema Last Edit Date: 8/13/2026 11:16:00 AM

Data Last Edit Date: 8/13/2026 11:15:53 AM

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