Name: PROJECT_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)
• PROJECT_NO (type: esriFieldTypeString, alias: PROJECT_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PROJECT_NAME (type: esriFieldTypeString, alias: PROJECT_NAME, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PROJECTTYPE (type: esriFieldTypeString, alias: PROJECTTYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PROJECTSUBTYPE (type: esriFieldTypeString, alias: PROJECTSUBTYPE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PRIMARY_PIN (type: esriFieldTypeString, alias: PRIMARY_PIN, 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_OWNER (type: esriFieldTypeString, alias: SITE_OWNER, 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_STREETID (type: esriFieldTypeInteger, alias: SITE_STREETID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITE_NUMBER (type: esriFieldTypeString, alias: SITE_NUMBER, SQL Type: sqlTypeOther, length: 512, 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_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)
• ZONING (type: esriFieldTypeString, alias: ZONING, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• GENPLAN (type: esriFieldTypeString, alias: GENPLAN, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• LAND_USE (type: esriFieldTypeString, alias: LAND_USE, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• FEES_CHARGED (type: esriFieldTypeDouble, alias: FEES_CHARGED, 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)
• PROJECT_LOC (type: esriFieldTypeString, alias: PROJECT_LOC, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PLANNER (type: esriFieldTypeString, alias: PLANNER, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 2000, 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)
• CLOSED (type: esriFieldTypeDate, alias: CLOSED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CLOSED_BY (type: esriFieldTypeString, alias: CLOSED_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• STATUS_BY (type: esriFieldTypeString, alias: STATUS_BY, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• STATUS_DATE (type: esriFieldTypeDate, alias: STATUS_DATE, SQL Type: sqlTypeOther, length: 8, 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)
• 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)
• RESOLUTION_NO (type: esriFieldTypeString, alias: RESOLUTION_NO, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• PARENT_PROJECT_NO (type: esriFieldTypeString, alias: PARENT_PROJECT_NO, 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)
• DEVELOPER_NAME (type: esriFieldTypeString, alias: DEVELOPER_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)
• SIGN (type: esriFieldTypeString, alias: SIGN, SQL Type: sqlTypeOther, length: 2000, 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)
• REFERENCE_NO (type: esriFieldTypeString, alias: REFERENCE_NO, SQL Type: sqlTypeOther, length: 512, 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)
• 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