Name: Planning Applications

Display Field: FileNum

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• FileNum ( type: esriFieldTypeString, alias: File Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FileNum )
• Applicant ( type: esriFieldTypeString, alias: Applicant, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Applicant )
• Agent ( type: esriFieldTypeString, alias: Agent, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Agent )
• DateReceived ( type: esriFieldTypeDate, alias: Date Received, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOpen )
• DateIncomplete ( type: esriFieldTypeDate, alias: Date Deemed Incomplete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateIncomplete )
• DateComplete ( type: esriFieldTypeDate, alias: Date Deemed Complete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateDComp )
• Status ( type: esriFieldTypeString, alias: Process Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Status , Coded Values: [Received: Received] , [Deemed Incomplete: Deemed Incomplete] , [Deemed Complete: Deemed Complete] , ...4 more... )
• DatePublicMtg ( type: esriFieldTypeDate, alias: Public Meeting, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DatePublicMtg )
• OpenClosed ( type: esriFieldTypeString, alias: Open Application, editable: true, nullable: true, length: 50, defaultValue: Open, modelName: OpenApplication , Coded Values: [Open: Open] , [Closed: Closed] )
• AppType ( type: esriFieldTypeString, alias: Application Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AppType , Coded Values: [Official Plan and Zoning By-law Amendment: Official Plan and Zoning By-law Amendment] , [Part Lot Control: Part Lot Control] , [Plan of Condominium: Plan of Condominium] , ...5 more... )
• Proposal ( type: esriFieldTypeString, alias: Proposal, editable: true, nullable: true, length: 600, defaultValue: null, modelName: Request )
• Progress ( type: esriFieldTypeString, alias: Progress Summary, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: NextAction )
• Planner ( type: esriFieldTypeString, alias: Planner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Planner , Coded Values: [Brandon Ward: Brandon Ward] , [Larysa Russell: Larysa Russell] , [Mary Adams: Mary Adams] , ...2 more... )
• Related ( type: esriFieldTypeString, alias: Related Applications, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Related )
• ComGFA ( type: esriFieldTypeSmallInteger, alias: Commercial GFA (sq m), editable: true, nullable: true, defaultValue: null, modelName: ComGFA )
• IndGFA ( type: esriFieldTypeSmallInteger, alias: Industrial GFA (sq m), editable: true, nullable: true, defaultValue: null, modelName: IndGFA )
• InstGFA ( type: esriFieldTypeSmallInteger, alias: Institutional GFA (sq m), editable: true, nullable: true, defaultValue: null, modelName: InstGFA )
• InstBeds ( type: esriFieldTypeSmallInteger, alias: Institutional Number of Beds, editable: true, nullable: true, defaultValue: null, modelName: InstBeds )
• UnitsTH ( type: esriFieldTypeSmallInteger, alias: Townhouse Units, editable: true, nullable: true, defaultValue: null, modelName: UnitsTH )
• UnitsSD ( type: esriFieldTypeSmallInteger, alias: Single Detached Units, editable: true, nullable: true, defaultValue: null, modelName: UnitsSD )
• UnitsSemi ( type: esriFieldTypeSmallInteger, alias: Semi Detached Units, editable: true, nullable: true, defaultValue: null, modelName: UnitsSemi )
• UnitsApt ( type: esriFieldTypeSmallInteger, alias: Apartment Units, editable: true, nullable: true, defaultValue: null, modelName: UnitsApt )
• Units ( type: esriFieldTypeSmallInteger, alias: Number of Units, editable: true, nullable: true, defaultValue: null, modelName: Units )
• Approved ( type: esriFieldTypeString, alias: Approved, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Approved , Coded Values: [Yes: Yes] , [No: No] )
• DateDecision ( type: esriFieldTypeDate, alias: Decision Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateDecision )
• BylawNum ( type: esriFieldTypeString, alias: Bylaw Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BylawNum )
• Appealed ( type: esriFieldTypeString, alias: Appealed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Appealed , Coded Values: [Yes: Yes] , [No: No] )
• PropertyGUID ( type: esriFieldTypeGUID, alias: PropertyGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PropertyGUID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Planning Applications
  Description:
  Prototype:
  Appealed: null
  FileNum: null
  Applicant: null
  Agent: null
  DateReceived: null
  DateIncomplete: null
  DateComplete: null
  Status: null
  DatePublicMtg: null
  OpenClosed: Open
  AppType: null
  Proposal: null
  PropertyGUID: null
  Progress: null
  Planner: null
  Related: null
  ComGFA: null
  IndGFA: null
  InstGFA: null
  InstBeds: null
  UnitsTH: null
  UnitsSD: null
  UnitsSemi: null
  UnitsApt: null
  Units: null
  Approved: null
  DateDecision: null
  BylawNum: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Property (0) -- Related To: Planning Application Properties (0)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata