Name: PERMIT_MAIN

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: 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)
• PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• YRMO (type: esriFieldTypeDouble, alias: YRMO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEQ_NO (type: esriFieldTypeDouble, alias: SEQ_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERMIT_NO (type: esriFieldTypeString, alias: PERMIT_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• APPLICATION_NO (type: esriFieldTypeString, alias: APPLICATION_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PLANCHECK_NO (type: esriFieldTypeString, alias: PLANCHECK_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• REFERENCE_NO (type: esriFieldTypeString, alias: REFERENCE_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• APPLIED (type: esriFieldTypeDate, alias: APPLIED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• APPLIED_BY (type: esriFieldTypeString, alias: APPLIED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• APPROVED (type: esriFieldTypeDate, alias: APPROVED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• APPROVED_BY (type: esriFieldTypeString, alias: APPROVED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ISSUED (type: esriFieldTypeDate, alias: ISSUED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ISSUED_BY (type: esriFieldTypeString, alias: ISSUED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• FINALED (type: esriFieldTypeDate, alias: FINALED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FINALED_BY (type: esriFieldTypeString, alias: FINALED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• EXPIRED (type: esriFieldTypeDate, alias: EXPIRED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXPIRED_BY (type: esriFieldTypeString, alias: EXPIRED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• VALID_FOR (type: esriFieldTypeDouble, alias: VALID_FOR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARENT_PROJECT_NO (type: esriFieldTypeString, alias: PARENT_PROJECT_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PARENT_PERMIT_NO (type: esriFieldTypeString, alias: PARENT_PERMIT_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PermitType (type: esriFieldTypeString, alias: PermitType, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PermitSubType (type: esriFieldTypeString, alias: PermitSubType, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• OCCUPANCY_TYPE (type: esriFieldTypeString, alias: OCCUPANCY_TYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• GROUPCODE (type: esriFieldTypeString, alias: GROUPCODE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ZONING_CODE1 (type: esriFieldTypeString, alias: ZONING_CODE1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ZONING_CODE2 (type: esriFieldTypeString, alias: ZONING_CODE2, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CONST_TYPE (type: esriFieldTypeString, alias: CONST_TYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_LOT_NO (type: esriFieldTypeString, alias: SITE_LOT_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_BLOCK (type: esriFieldTypeString, alias: SITE_BLOCK, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_TRACT (type: esriFieldTypeString, alias: SITE_TRACT, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_SUBDIVISION (type: esriFieldTypeString, alias: SITE_SUBDIVISION, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_DESCRIPTION (type: esriFieldTypeString, alias: SITE_DESCRIPTION, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• TAX_RATE_AREA (type: esriFieldTypeString, alias: TAX_RATE_AREA, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SCHOOL (type: esriFieldTypeString, alias: SCHOOL, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CENSUS (type: esriFieldTypeString, alias: CENSUS, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• FWDODGE (type: esriFieldTypeString, alias: FWDODGE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_APN (type: esriFieldTypeString, alias: SITE_APN, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_ADDR (type: esriFieldTypeString, alias: SITE_ADDR, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_NUMBER (type: esriFieldTypeString, alias: SITE_NUMBER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_STREETID (type: esriFieldTypeDouble, alias: SITE_STREETID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITE_STREETNAME (type: esriFieldTypeString, alias: SITE_STREETNAME, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_UNIT_NO (type: esriFieldTypeString, alias: SITE_UNIT_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_CITY (type: esriFieldTypeString, alias: SITE_CITY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_STATE (type: esriFieldTypeString, alias: SITE_STATE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_ZIP (type: esriFieldTypeString, alias: SITE_ZIP, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_ST_NO (type: esriFieldTypeString, alias: SITE_ST_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LOCATION_DESC (type: esriFieldTypeString, alias: LOCATION_DESC, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• LOT_SF (type: esriFieldTypeDouble, alias: LOT_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_SF (type: esriFieldTypeDouble, alias: BLDG_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG2_SF (type: esriFieldTypeDouble, alias: BLDG2_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GAR_SF (type: esriFieldTypeDouble, alias: GAR_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GAR2_SF (type: esriFieldTypeDouble, alias: GAR2_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PORCH_SF (type: esriFieldTypeDouble, alias: PORCH_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PORCH2_SF (type: esriFieldTypeDouble, alias: PORCH2_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEIGHT (type: esriFieldTypeDouble, alias: HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_STORIES (type: esriFieldTypeDouble, alias: NO_STORIES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_UNITS (type: esriFieldTypeDouble, alias: NO_UNITS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_BLDGS (type: esriFieldTypeDouble, alias: NO_BLDGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOBVALUE (type: esriFieldTypeDouble, alias: JOBVALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEES_CHARGED (type: esriFieldTypeDouble, alias: FEES_CHARGED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEE_ADJUSTMENTS (type: esriFieldTypeDouble, alias: FEE_ADJUSTMENTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEES_PAID (type: esriFieldTypeDouble, alias: FEES_PAID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BALANCE_DUE (type: esriFieldTypeDouble, alias: BALANCE_DUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OTHER_DATE1 (type: esriFieldTypeDate, alias: OTHER_DATE1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OTHER_BY1 (type: esriFieldTypeString, alias: OTHER_BY1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• OWNER_NAME (type: esriFieldTypeString, alias: OWNER_NAME, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• APPLICANT_NAME (type: esriFieldTypeString, alias: APPLICANT_NAME, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• CONTRACTOR_NAME (type: esriFieldTypeString, alias: CONTRACTOR_NAME, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• RECORDID (type: esriFieldTypeString, alias: RECORDID, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LOCKID (type: esriFieldTypeString, alias: LOCKID, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LOC_RECORDID (type: esriFieldTypeString, alias: LOC_RECORDID, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PIN (type: esriFieldTypeInteger, alias: PIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPOSITTYPE (type: esriFieldTypeString, alias: DEPOSITTYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• HISTORICAL_APN (type: esriFieldTypeString, alias: HISTORICAL_APN, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• NOTES2 (type: esriFieldTypeString, alias: NOTES2, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• SITE_ALTERNATE_ID (type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• SITE_GEOTYPE (type: esriFieldTypeString, alias: SITE_GEOTYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• update_originator_id (type: esriFieldTypeInteger, alias: update_originator_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• update_timestamp (type: esriFieldTypeString, alias: update_timestamp, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• create_timestamp (type: esriFieldTypeString, alias: create_timestamp, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• Parent_Generic1_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic1_ActivityNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• Parent_Generic2_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic2_ActivityNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• Parent_Generic3_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic3_ActivityNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• Parent_Generic4_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic4_ActivityNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• Parent_Generic5_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic5_ActivityNo, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• insert_originator_id (type: esriFieldTypeInteger, alias: insert_originator_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARENT_BUS_LIC_NO (type: esriFieldTypeString, alias: PARENT_BUS_LIC_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• TSstatus (type: esriFieldTypeInteger, alias: TSstatus, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/4/2026 10:30:38 PM

Schema Last Edit Date: 8/4/2026 10:30:38 PM

Data Last Edit Date: 8/4/2026 10:30:38 PM

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