Tables:

Table: Valgusti (5)

Name: Valgusti

Display Field: v_paigaldaja_reg_kood

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: cfd138bdd59a4465b45d0be2f95f0b0c

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 10000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: Valguspunkt_ID )
• fs_tahis ( type: esriFieldTypeSmallInteger, alias: Kaablisoone tähis , Coded Values: [0: määramata] , [1: L1] , [2: L2] , ...3 more... )
• v_materj ( type: esriFieldTypeSmallInteger, alias: Valgusallika materjal , Coded Values: [0: määramata] , [1: LED] , [2: naatrium (HPS)] , ...5 more... )
• n_voog ( type: esriFieldTypeSmallInteger, alias: Nimivalgusvoog (Lm) )
• liigpinge_kaitse ( type: esriFieldTypeSmallInteger, alias: Liigpingekaitse (kV) , Coded Values: [0: määramata] , [1: puudub] , [2: 4] , ...3 more... )
• kaitseklass ( type: esriFieldTypeSmallInteger, alias: Kaitseklass , Coded Values: [0: määramata] , [1: I] , [2: II] , ...1 more... )
• v_paigaldaja_reg_kood ( type: esriFieldTypeString, alias: Paigaldaja reg kood, length: 255 )
• v_paigaldaja_nimi ( type: esriFieldTypeString, alias: Paigaldaja ettevõtte nimi, length: 255 )
• p_aeg ( type: esriFieldTypeDate, alias: Paigaldusaeg, length: 8 )
• g_lopp ( type: esriFieldTypeDate, alias: Garantii lõpp, length: 8 )
• korgus ( type: esriFieldTypeDouble, alias: Kõrgus maapinnast (m) )
• kn_pikkus ( type: esriFieldTypeDouble, alias: Konsooli pikkus (m) )
• v_suund ( type: esriFieldTypeSmallInteger, alias: Suund (kraadides, 0 = N) )
• fiider_id ( type: esriFieldTypeInteger, alias: Fiider ID )
• n_vool ( type: esriFieldTypeDouble, alias: Nimivool (A) )
• n_voimsus ( type: esriFieldTypeDouble, alias: Nimivõimsus (W) )
• v_tootja ( type: esriFieldTypeString, alias: Valgusti tootja, length: 50 )
• v_mark ( type: esriFieldTypeString, alias: Valgusti mark, length: 25 )
• v_meta ( type: esriFieldTypeString, alias: Valgusti metainfo, length: 50 )
• varv_temp ( type: esriFieldTypeSmallInteger, alias: Värvustemperatuur (K) , Coded Values: [0: määramata] , [1: 2000] , [2: 2700] , ...9 more... )
• kon_id ( type: esriFieldTypeString, alias: Kontrolleri ID, length: 50 )
• v_omanik ( type: esriFieldTypeSmallInteger, alias: Valgusti omanik , Coded Values: [0: määramata] , [1: Rae vald] , [2: Eesti Vabariik] , ...4 more... )
• pesa_arv ( type: esriFieldTypeSmallInteger, alias: Pesade arv )
• pohipesa ( type: esriFieldTypeSmallInteger, alias: Põhipesa , Coded Values: [0: määramata] , [1: valgustikontroller] , [2: tühi] )
• abipesa ( type: esriFieldTypeSmallInteger, alias: Abipesa , Coded Values: [0: määramata] , [1: valgustikontroller] , [2: tühi] )
• klass ( type: esriFieldTypeString, alias: Valgusti klass, length: 50 )
• markused ( type: esriFieldTypeString, alias: Märkused, length: 255 )
• valguspunkti_tahis_id ( type: esriFieldTypeString, alias: valguspunkti_tahis_id, length: 50 )
• allasutus ( type: esriFieldTypeString, alias: allasutus, length: 50 )
• valgusti_tyyp ( type: esriFieldTypeSmallInteger, alias: Valgusti tüüp , Coded Values: [0: määramata] , [1: pargivalgusti] , [2: jalg- ja jalgrattatee valgusti] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• markused_2 ( type: esriFieldTypeString, alias: Valgustite vahetus, length: 255 )