Name: Planning Table
Display Field: GNMasterProjectID
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: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID_1, SQL Type: sqlTypeOther, nullable: false, editable: true)
- GNMasterProjectID (type: esriFieldTypeInteger, alias: GNMasterProjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GNCommonID (type: esriFieldTypeInteger, alias: GNCommonID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PL_RecordID (type: esriFieldTypeInteger, alias: PL_RecordID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ApplicationNumber (type: esriFieldTypeString, alias: ApplicationNumber, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ApplicationDate (type: esriFieldTypeDate, alias: ApplicationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ApplicationDescription (type: esriFieldTypeString, alias: ApplicationDescription, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- ProjectTypeCode (type: esriFieldTypeString, alias: ProjectTypeCode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ProjectTypeDesc (type: esriFieldTypeString, alias: ProjectTypeDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- ApplicationTypeCode (type: esriFieldTypeString, alias: ApplicationTypeCode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ApplicationTypeDesc (type: esriFieldTypeString, alias: ApplicationTypeDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- ApplicationReviewStatusCode (type: esriFieldTypeString, alias: ApplicationReviewStatusCode, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ApplicationReviewStatusDesc (type: esriFieldTypeString, alias: ApplicationReviewStatusDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- AppTypeUKID (type: esriFieldTypeString, alias: AppTypeUKID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- AppStatus (type: esriFieldTypeString, alias: AppStatus, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- AppStatusDesc (type: esriFieldTypeString, alias: AppStatusDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- AppReviewType (type: esriFieldTypeString, alias: AppReviewType, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- AppReviewDesc (type: esriFieldTypeString, alias: AppReviewDesc, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- AssignedPlanner (type: esriFieldTypeString, alias: AssignedPlanner, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
- LOCID (type: esriFieldTypeInteger, alias: LOCID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SITEADDID (type: esriFieldTypeString, alias: SITEADDID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TAXLOT (type: esriFieldTypeString, alias: TAXLOT, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
- DecisionDate (type: esriFieldTypeDate, alias: DecisionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Units (type: esriFieldTypeInteger, alias: Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OverallStatus (type: esriFieldTypeString, alias: OverallStatus, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
Templates:
Name: Planning Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/13/2026 10:00:57 AM
Schema Last Edit Date: 8/13/2026 10:00:57 AM
Data Last Edit Date: 8/13/2026 10:00:37 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat