View In:   ArcGIS Online Map Viewer

Name: Active Leases

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 021fdc39c7284c0597d035da1861da4f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 625107.4933000002
YMin: 6921582.2762
XMax: 638639.3653999995
YMax: 6937245.719999999
Spatial Reference: 26911  (26911)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 235, 175, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECT ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created by User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Date Created, 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: Date Last Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• active ( type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 50, defaultValue: null, modelName: active , Coded Values: [Yes: Yes] , [No: No] , [NA: Not Applicable] , ...1 more... )
• description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 500, defaultValue: null, modelName: description )
• notes_staff ( type: esriFieldTypeString, alias: Staff Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: notes_staff )
• notes_planning ( type: esriFieldTypeString, alias: Planning Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: notes_planning )
• term_start ( type: esriFieldTypeDate, alias: Term Start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: term_start )
• term_end ( type: esriFieldTypeDate, alias: Term End, editable: true, nullable: true, length: 8, defaultValue: null, modelName: term_end )
• term_length ( type: esriFieldTypeSmallInteger, alias: Term Length, editable: true, nullable: true, defaultValue: null, modelName: term_length )
• expiry ( type: esriFieldTypeDate, alias: Expiry, editable: true, nullable: true, length: 8, defaultValue: null, modelName: expiry )
• lot ( type: esriFieldTypeString, alias: Lot, editable: true, nullable: true, length: 36, defaultValue: null, modelName: lot )
• block ( type: esriFieldTypeString, alias: Block, editable: true, nullable: true, length: 36, defaultValue: null, modelName: block )
• plan_ ( type: esriFieldTypeString, alias: Plan, editable: true, nullable: true, length: 36, defaultValue: null, modelName: plan_ )
• use_ ( type: esriFieldTypeString, alias: Use, editable: true, nullable: true, length: 36, defaultValue: null, modelName: use_ )
• file_number ( type: esriFieldTypeString, alias: File Number, editable: true, nullable: true, length: 36, defaultValue: null, modelName: file_number )
• gnwt_number ( type: esriFieldTypeString, alias: GNWT Number, editable: true, nullable: true, length: 36, defaultValue: null, modelName: gnwt_number )
• sublease ( type: esriFieldTypeString, alias: Sublease, editable: true, nullable: true, length: 3, defaultValue: null, modelName: sublease )
• sublease1 ( type: esriFieldTypeString, alias: Sublease 1, editable: true, nullable: true, length: 72, defaultValue: null, modelName: sublease1 )
• sublease2 ( type: esriFieldTypeString, alias: Sublease 2, editable: true, nullable: true, length: 72, defaultValue: null, modelName: sublease2 )
• sublease3 ( type: esriFieldTypeString, alias: Sublease 3, editable: true, nullable: true, length: 72, defaultValue: null, modelName: sublease3 )
• lease_sketch ( type: esriFieldTypeString, alias: Lease Sketch, editable: true, nullable: true, length: 36, defaultValue: null, modelName: lease_sketch )
• annual_fee ( type: esriFieldTypeString, alias: Annual Fee, editable: true, nullable: true, length: 16, defaultValue: null, modelName: annual_fee )
• royalty_fee ( type: esriFieldTypeString, alias: Royalty Fee, editable: true, nullable: true, length: 3, defaultValue: null, modelName: royalty_fee )
• insurance_expiry ( type: esriFieldTypeDate, alias: Insurance Expiry, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insurance_expiry )
• insurance_dm ( type: esriFieldTypeInteger, alias: Insurance DM, editable: true, nullable: true, defaultValue: null, modelName: insurance_dm )
• deposit_paid ( type: esriFieldTypeString, alias: Deposit Paid, editable: true, nullable: true, length: 36, defaultValue: null, modelName: deposit_paid )
• invoice_month ( type: esriFieldTypeString, alias: Invoice Month, editable: true, nullable: true, length: 16, defaultValue: null, modelName: invoice_month )
• annual_rent ( type: esriFieldTypeString, alias: Annual Rent, editable: true, nullable: true, length: 36, defaultValue: null, modelName: annual_rent )
• contact ( type: esriFieldTypeString, alias: Contact, editable: true, nullable: true, length: 500, defaultValue: null, modelName: contact )
• statement_DM ( type: esriFieldTypeInteger, alias: Statment DM, editable: true, nullable: true, defaultValue: null, modelName: statement_DM )
• city_leasee ( type: esriFieldTypeString, alias: City Lease, editable: true, nullable: true, length: 72, defaultValue: null, modelName: city_leasee )
• agreeement1_dm ( type: esriFieldTypeInteger, alias: Agreement(1) DM, editable: true, nullable: true, defaultValue: null, modelName: agreeement1_dm )
• agreeement2_dm ( type: esriFieldTypeInteger, alias: Agreement(2) DM, editable: true, nullable: true, defaultValue: null, modelName: agreeement2_dm )
• agreement3_dm ( type: esriFieldTypeInteger, alias: Agreement(3) DM, editable: true, nullable: true, defaultValue: null, modelName: agreement3_dm )
• agreement4_dm ( type: esriFieldTypeInteger, alias: Agreement(4) DM, editable: true, nullable: true, defaultValue: null, modelName: agreement4_dm )
• bylaw ( type: esriFieldTypeString, alias: Bylaw, editable: true, nullable: true, length: 36, defaultValue: null, modelName: bylaw )
• DateOfPayment ( type: esriFieldTypeDate, alias: Date Of Payment, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOfPayment )
• PaymentComments ( type: esriFieldTypeString, alias: Payment Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PaymentComments )
• InvoiceDMNum ( type: esriFieldTypeInteger, alias: Invoice DM Number, editable: true, nullable: true, defaultValue: null, modelName: InvoiceDMNum )
• GNWTInvoiceNum ( type: esriFieldTypeString, alias: GNWT Invoice Number, editable: true, nullable: true, length: 13, defaultValue: null, modelName: GNWTInvoiceNum )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape ST Area(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape ST Length(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Templates:

• Name: Active Leases
  Description:
  Prototype:
  GNWTInvoiceNum: null
  InvoiceDMNum: null
  PaymentComments: null
  DateOfPayment: null
  bylaw: null
  agreement4_dm: null
  active: null
  description: null
  notes_staff: null
  notes_planning: null
  term_start: null
  term_end: null
  term_length: null
  expiry: null
  lot: null
  block: null
  plan_: null
  use_: null
  file_number: null
  gnwt_number: null
  sublease: null
  sublease1: null
  sublease2: null
  sublease3: null
  lease_sketch: null
  annual_fee: null
  royalty_fee: null
  insurance_expiry: null
  insurance_dm: null
  deposit_paid: null
  invoice_month: null
  annual_rent: null
  contact: null
  statement_DM: null
  city_leasee: null
  agreeement1_dm: null
  agreeement2_dm: null
  agreement3_dm: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata