Name: Etapid

Display Field: Staatus

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c4c837f302ad4f41ae0a59375baa8daa

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Staatus ( type: esriFieldTypeSmallInteger, alias: Staatus , editable: true, nullable: true, defaultValue: null, modelName: Staatus , Coded Values: [1: Töös] , [2: Valmis] , [3: Alustamata] )
• Tyyp ( type: esriFieldTypeSmallInteger, alias: Tüüp, editable: true, nullable: true, defaultValue: null, modelName: Tyyp , Coded Values: [1: Kaevamine] , [2: Teekatte ootel] , [3: Katendi taastamine] , ...11 more... )
• Algus ( type: esriFieldTypeDate, alias: Algus, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Algus )
• Lopp ( type: esriFieldTypeDate, alias: Lõpp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Lopp )
• Aadress ( type: esriFieldTypeString, alias: Objekti aadressid, editable: true, nullable: true, length: 3000, defaultValue: null, modelName: Aadress )
• Yhis_tanav ( type: esriFieldTypeSmallInteger, alias: Ühistranspordi tänav, editable: true, nullable: true, defaultValue: null, modelName: Yhis_tanav , Coded Values: [0: Ei] , [1: Jah] )
• Yhistransport ( type: esriFieldTypeSmallInteger, alias: Yhistransport, editable: true, nullable: true, defaultValue: 0, modelName: Yhistransport , Coded Values: [0: Ei] , [1: Jah] )
• Parkimiskoht ( type: esriFieldTypeSmallInteger, alias: Parkimiskohad, editable: true, nullable: true, defaultValue: null, modelName: Parkimiskoht )
• Haljastus ( type: esriFieldTypeSmallInteger, alias: Tööd haljasalal, editable: true, nullable: true, defaultValue: null, modelName: Haljastus , Coded Values: [0: Ei] , [1: Jah] )
• Liiklus_vastutaja ( type: esriFieldTypeString, alias: Liikluskorralduse eest vastutaja, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Liiklus_vastutaja )
• Telefon ( type: esriFieldTypeString, alias: Telefon, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Telefon )
• Epost ( type: esriFieldTypeString, alias: Epost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Epost )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Sulgemisala_GID ( type: esriFieldTypeGUID, alias: Sulgemisala_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Sulgemisala_GID )
• Too_kaitsetsoon ( type: esriFieldTypeSmallInteger, alias: Tööd puude kaitsetsoonis, editable: true, nullable: true, defaultValue: null, modelName: Too_kaitsetsoon , Coded Values: [0: Ei] , [1: Jah] )
• Haljasala_too ( type: esriFieldTypeString, alias: Haljasala tööde kirjeldus, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: Haljasala_too )
• Perioodiline ( type: esriFieldTypeSmallInteger, alias: Perioodiline sulgemine, editable: true, nullable: true, defaultValue: null, modelName: Perioodiline , Coded Values: [0: Ei] , [1: Jah] )
• Tapsustus ( type: esriFieldTypeString, alias: Täpsustus, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Tapsustus )
• Emajogi ( type: esriFieldTypeSmallInteger, alias: Emajõgi, editable: true, nullable: true, defaultValue: null, modelName: Emajogi , Coded Values: [0: Määramata] , [1: Liiklejatele suletud] , [2: Ohutu läbipääs tagatud] , ...2 more... )

Templates:

• Name: Etapid
  Description:
  Prototype:
  Tapsustus: null
  Perioodiline: null
  Staatus: null
  Tyyp: null
  Algus: null
  Lopp: null
  Aadress: null
  Yhis_tanav: null
  Yhistransport: 0
  Parkimiskoht: null
  Haljastus: null
  Liiklus_vastutaja: null
  Telefon: null
  Epost: null
  Emajogi: null
  Sulgemisala_GID: null
  Too_kaitsetsoon: null
  Haljasala_too: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.Suletav_parkimisala (1) -- Related To: Suletavad parkimisalad tulevikus (2)
• DBO.Suletav_parkimisala (4) -- Related To: Suletavad parkimisalad (5)
• DBO.Suletav_tee (0) -- Related To: Suletav tee tulevikus (1)
• DBO.Suletav_tee (3) -- Related To: Suletav tee (4)
• DBO.Sulgemisala (2) -- Related To: Sulgemisalad tulevikus (3)
• DBO.Sulgemisala (5) -- Related To: Sulgemisalad (6)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: 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: false

Child Resources:   Field Groups   Contingent Values

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