Name: Planning_Activities_Join

Display Field: TRAKiT_ID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text: Bismarck GIS

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: -11230708.0856718
YMin: 5895686.274
XMax: -11195527.8329344
YMax: 5929677.9094
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[255,170,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":3}}},"scaleSymbols":true,"transparency":50,"labelingInfo":[{"labelExpression":"[TRAKiT_ID]","labelPlacement":"esriServerPolygonPlacementAlwaysHorizontal","multiPart":"labelPerPart","allowOverrun":true,"deconflictionStrategy":"dynamic","repeatLabel":false,"useClippedGeometry":false,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Default","priority":3,"symbol":{"type":"esriTS","color":[115,76,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tw Cen MT","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• TRAKiT_ID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Annexation: Annexation], [Adjustment: Adjustment], [Downtown Design Review: Downtown Design Review], ... 10 more ...)
• DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• HearingBoard (type: esriFieldTypeString, alias: Hearing Board, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City Commission: City Commission], [Planning and Zoning Commission: Planning and Zoning Commission], [Board of Adjustment: Board of Adjustment], ... 2 more ...)
• HearingDate (type: esriFieldTypeDate, alias: Hearing Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Final_ID (type: esriFieldTypeString, alias: Final_ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• GeodesicArea (type: esriFieldTypeDouble, alias: Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 6, 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: 30, nullable: true, editable: true)
• PROJECT_NAME (type: esriFieldTypeString, alias: PROJECT_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PROJECTTYPE (type: esriFieldTypeString, alias: PROJECTTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PROJECTSUBTYPE (type: esriFieldTypeString, alias: PROJECTSUBTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PRIMARY_PIN (type: esriFieldTypeString, alias: PRIMARY_PIN, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SITE_APN (type: esriFieldTypeString, alias: SITE_APN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_OWNER (type: esriFieldTypeString, alias: SITE_OWNER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• SITE_ADDR (type: esriFieldTypeString, alias: SITE_ADDR, SQL Type: sqlTypeOther, length: 85, 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: 12, nullable: true, editable: true)
• SITE_STREETNAME (type: esriFieldTypeString, alias: SITE_STREETNAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SITE_UNIT_NO (type: esriFieldTypeString, alias: SITE_UNIT_NO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SITE_CITY (type: esriFieldTypeString, alias: SITE_CITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SITE_STATE (type: esriFieldTypeString, alias: SITE_STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• SITE_ZIP (type: esriFieldTypeString, alias: SITE_ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SITE_LOT_NO (type: esriFieldTypeString, alias: SITE_LOT_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SITE_BLOCK (type: esriFieldTypeString, alias: SITE_BLOCK, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SITE_TRACT (type: esriFieldTypeString, alias: SITE_TRACT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_SUBDIVISION (type: esriFieldTypeString, alias: SITE_SUBDIVISION, SQL Type: sqlTypeOther, length: 100, 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: 20, nullable: true, editable: true)
• GENPLAN (type: esriFieldTypeString, alias: GENPLAN, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LAND_USE (type: esriFieldTypeString, alias: LAND_USE, SQL Type: sqlTypeOther, length: 20, 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: 200, nullable: true, editable: true)
• PLANNER (type: esriFieldTypeString, alias: PLANNER, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• DESCRIPTION_1751388662151 (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: 6, 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: 6, 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: 6, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STATUS_BY (type: esriFieldTypeString, alias: STATUS_BY, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• STATUS_DATE (type: esriFieldTypeDate, alias: STATUS_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RESOLUTION_NO (type: esriFieldTypeString, alias: RESOLUTION_NO, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• PARENT_PROJECT_NO (type: esriFieldTypeString, alias: PARENT_PROJECT_NO, SQL Type: sqlTypeOther, length: 30, 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: 6, 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: 6, nullable: true, editable: true)
• OWNER_NAME (type: esriFieldTypeString, alias: OWNER_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• APPLICANT_NAME (type: esriFieldTypeString, alias: APPLICANT_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DEVELOPER_NAME (type: esriFieldTypeString, alias: DEVELOPER_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• RECORDID (type: esriFieldTypeString, alias: RECORDID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LOCKID (type: esriFieldTypeString, alias: LOCKID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LOC_RECORDID (type: esriFieldTypeString, alias: LOC_RECORDID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DEPOSITTYPE (type: esriFieldTypeString, alias: DEPOSITTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• HISTORICAL_APN (type: esriFieldTypeString, alias: HISTORICAL_APN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CONTRACTOR_NAME (type: esriFieldTypeString, alias: CONTRACTOR_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• REFERENCE_NO (type: esriFieldTypeString, alias: REFERENCE_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SITE_ALTERNATE_ID (type: esriFieldTypeString, alias: SITE_ALTERNATE_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SITE_GEOTYPE (type: esriFieldTypeString, alias: SITE_GEOTYPE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Parent_Generic1_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic1_ActivityNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Parent_Generic2_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic2_ActivityNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Parent_Generic3_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic3_ActivityNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Parent_Generic4_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic4_ActivityNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Parent_Generic5_ActivityNo (type: esriFieldTypeString, alias: Parent_Generic5_ActivityNo, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TSstatus (type: esriFieldTypeInteger, alias: TSstatus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ActivityTypeID (type: esriFieldTypeInteger, alias: ActivityTypeID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Unique_Key (type: esriFieldTypeGUID, alias: Unique_Key, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: Planning Activities (Database)
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/12/2026 6:03:19 PM

Schema Last Edit Date: 7/1/2025 2:34:15 PM

Data Last Edit Date: 7/1/2025 2:34:15 PM

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