{ "currentVersion": 10.91, "id": 2, "name": "Ljuskälla", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Notes", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJEKTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALTID", "length": 38, "domain": null }, { "name": "RecordStatus", "type": "esriFieldTypeSmallInteger", "alias": "Poststatus", "domain": { "type": "codedValue", "name": "streetRecordCode", "description": "", "codedValues": [ { "name": "Arbete pågår", "code": 0 }, { "name": "Gällande", "code": 5 }, { "name": "Ersatt", "code": 6 }, { "name": "Upphörde", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EntityStatus", "type": "esriFieldTypeSmallInteger", "alias": "Objektstatus", "domain": { "type": "codedValue", "name": "streetEntityCode", "description": "", "codedValues": [ { "name": "Föreslagen", "code": 1 }, { "name": "Granskning", "code": 2 }, { "name": "Projekt", "code": 3 }, { "name": "Reell slutförande", "code": 5 }, { "name": "Öppen för trafik", "code": 6 }, { "name": "Godkänd, i drift", "code": 7 }, { "name": "Skadad", "code": 11 }, { "name": "Under reparation", "code": 12 }, { "name": "Överförd till ansvarig organisation", "code": 21 }, { "name": "Stängd för trafik", "code": 31 }, { "name": "Tagen ur drift", "code": 32 }, { "name": "Nedlagt", "code": 33 }, { "name": "Överskott", "code": 34 }, { "name": "I lager", "code": 35 }, { "name": "Demonterad", "code": 86 }, { "name": "Föreslagen demontering", "code": 87 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FromDate", "type": "esriFieldTypeDate", "alias": "FrånDatum", "length": 8, "domain": null }, { "name": "ToDate", "type": "esriFieldTypeDate", "alias": "TillDatum", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Anmärkningar", "length": 100, "domain": null }, { "name": "DeviceID", "type": "esriFieldTypeGUID", "alias": "UtrustningsID", "length": 38, "domain": null }, { "name": "ImportedID", "type": "esriFieldTypeString", "alias": "ImportID", "length": 255, "domain": null }, { "name": "LightingAssemblyID", "type": "esriFieldTypeGUID", "alias": "BelysningsutrustningsID", "length": 38, "domain": null }, { "name": "Type", "type": "esriFieldTypeSmallInteger", "alias": "Lamptyp", "domain": { "type": "codedValue", "name": "lightingDevice", "description": "", "codedValues": [ { "name": "SAKNAS LJUSKÄLLA", "code": 17 }, { "name": "OKÄNT", "code": 16 }, { "name": "SOT-T", "code": 33 }, { "name": "SON T", "code": 32 }, { "name": "SON H", "code": 31 }, { "name": "SON-T TPP", "code": 30 }, { "name": "SON-T PLUS", "code": 29 }, { "name": "SON-E 210", "code": 28 }, { "name": "LED54", "code": 27 }, { "name": "LED33", "code": 26 }, { "name": "LED POSTTOP HPL 42W", "code": 25 }, { "name": "FORCEORCE", "code": 24 }, { "name": "CITWHITE CDO-ET PLUS", "code": 23 }, { "name": "CDO-TT", "code": 22 }, { "name": "3LED CDO-ET M-CITY PLUS", "code": 21 }, { "name": "150-250WSON-T,MH", "code": 20 }, { "name": "150-250WSON-T", "code": 19 }, { "name": "150-250WSON", "code": 18 }, { "name": "CLEARWAY2LED45/740SR", "code": 15 }, { "name": "LED60/83", "code": 14 }, { "name": "LED42", "code": 13 }, { "name": "LED", "code": 12 }, { "name": "LED119", "code": 11 }, { "name": "SON-T PLUS 100W-E", "code": 10 }, { "name": "TRUEFORCE LED URBAN", "code": 9 }, { "name": "SON-E", "code": 8 }, { "name": "NORDIC LED", "code": 7 }, { "name": "SON-T", "code": 6 }, { "name": "LED49", "code": 5 }, { "name": "SON-H", "code": 4 }, { "name": "ECO LED", "code": 3 }, { "name": "3LED", "code": 2 }, { "name": "TRUEFORCE", "code": 1 }, { "name": "ÄLDRE PARKARMATUR", "code": 104 }, { "name": "ÄLDRE ARMATURTYP", "code": 103 }, { "name": "ÄLDRE", "code": 102 }, { "name": "VITSIPPA", "code": 101 }, { "name": "VICTOR 1", "code": 100 }, { "name": "VIALUME 75", "code": 99 }, { "name": "VIALUME 1", "code": 98 }, { "name": "URBANGLOW", "code": 97 }, { "name": "TRUEFORCE", "code": 96 }, { "name": "STÅSTOLPE NY STOLPE", "code": 95 }, { "name": "STÅSTOLPE", "code": 94 }, { "name": "STRÅLKASTARE", "code": 93 }, { "name": "STREETSAVER / BPP007", "code": 92 }, { "name": "STREET", "code": 91 }, { "name": "STOCKHOLMS ARMATUR", "code": 90 }, { "name": "SGS203", "code": 89 }, { "name": "SGP340", "code": 88 }, { "name": "SELENIUM SGP340", "code": 87 }, { "name": "SC50", "code": 86 }, { "name": "SATURN 2", "code": 85 }, { "name": "SATURN 1", "code": 84 }, { "name": "PARKARMATUR", "code": 83 }, { "name": "OKÄND", "code": 82 }, { "name": "PARKARMATUR", "code": 81 }, { "name": "MOTION STREET", "code": 80 }, { "name": "MOTION", "code": 79 }, { "name": "MARKBELYSNING", "code": 78 }, { "name": "LYRA", "code": 77 }, { "name": "LYKTA", "code": 76 }, { "name": "KOMPSIT-ÖVERDRAG", "code": 75 }, { "name": "KOMPOSIT-ÖVERDRAG", "code": 74 }, { "name": "JOHANNA 7351B", "code": 73 }, { "name": "JOHANNA 7351", "code": 72 }, { "name": "ISARO", "code": 71 }, { "name": "INNERSTAN", "code": 70 }, { "name": "INNERSTAD LJUSLYKTA", "code": 69 }, { "name": "INNERSTAD LYKTA", "code": 68 }, { "name": "INNERSTAD & SPOTLIGH", "code": 67 }, { "name": "INNERSTAD", "code": 66 }, { "name": "GRN16/827 II CLO LS6", "code": 65 }, { "name": "CREE XSPM+", "code": 64 }, { "name": "COPENHAGEN CITY LED", "code": 63 }, { "name": "CLEARWAY", "code": 62 }, { "name": "CIVIC 2", "code": 61 }, { "name": "CITYSWAN GEN2", "code": 60 }, { "name": "CITY SPIRIT", "code": 59 }, { "name": "CIRCLED", "code": 58 }, { "name": "BRS761", "code": 57 }, { "name": "BRP435", "code": 56 }, { "name": "BRP 435 GRN45/740 DW", "code": 55 }, { "name": "BPP435/MONITION STRE", "code": 54 }, { "name": "BPP435 GRN45/740", "code": 53 }, { "name": "BPP435", "code": 52 }, { "name": "BPP007", "code": 51 }, { "name": "BPP 435 GRN 45/740", "code": 50 }, { "name": "BGP352 GRN56-2S/830", "code": 49 }, { "name": "BGP352", "code": 48 }, { "name": "BGP307I", "code": 47 }, { "name": "BGP303", "code": 46 }, { "name": "BGP283I", "code": 45 }, { "name": "BGP243N", "code": 44 }, { "name": "BGP213N", "code": 43 }, { "name": "BGP213 SMALL", "code": 42 }, { "name": "BGP213 MEDIUM", "code": 41 }, { "name": "BGP213", "code": 40 }, { "name": "BETA 79", "code": 39 }, { "name": "BDP265I", "code": 38 }, { "name": "APOLLO LED LXSL1", "code": 37 }, { "name": "ALPHA 8", "code": 36 }, { "name": "622 37", "code": 35 }, { "name": "203/100G", "code": 34 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DeviceNumber", "type": "esriFieldTypeInteger", "alias": "Nummer", "domain": null }, { "name": "Armature", "type": "esriFieldTypeSmallInteger", "alias": "Armatur", "domain": { "type": "codedValue", "name": "lightingArmature", "description": "", "codedValues": [ { "name": "620 37", "code": 1 }, { "name": "BDP100 LW10", "code": 2 }, { "name": "SAKNAS ARMATUR", "code": 38 }, { "name": "OKÄNT", "code": 37 }, { "name": "PHILIPS BGP307 LED45-4S/830", "code": 39 }, { "name": "BDP100I", "code": 3 }, { "name": "BGP202N", "code": 4 }, { "name": "BGP203 BGP213 LW10", "code": 5 }, { "name": "BGP203N", "code": 6 }, { "name": "BGP203NBGP213 LW10", "code": 7 }, { "name": "BGP215", "code": 8 }, { "name": "BYHATT", "code": 9 }, { "name": "CEBE91", "code": 10 }, { "name": "CLEARWAY GEN 2", "code": 11 }, { "name": "CLEARWAY GEN2", "code": 12 }, { "name": "CREE XSPCREE XS T210", "code": 13 }, { "name": "CREE XSPM", "code": 14 }, { "name": "CREE XSPR CREE T210", "code": 15 }, { "name": "CREE XSPR T210", "code": 16 }, { "name": "CREE XSPR T210CREE X", "code": 17 }, { "name": "CREE XSPRCREE X T210", "code": 18 }, { "name": "CREE XSPRCREE XST210", "code": 19 }, { "name": "JÄRNKONST", "code": 20 }, { "name": "LUMI- UNISTREET LS", "code": 21 }, { "name": "LUMISTREET", "code": 22 }, { "name": "MOTION STREET 35/740", "code": 23 }, { "name": "MOTION STREET 35M740", "code": 24 }, { "name": "MOTOIN STREET", "code": 25 }, { "name": "MYRA", "code": 26 }, { "name": "SGS 203", "code": 27 }, { "name": "SGS 203/100G", "code": 28 }, { "name": "SIEMENS 620 37", "code": 29 }, { "name": "ST STREET 49/740", "code": 30 }, { "name": "ST STREET 91/740", "code": 31 }, { "name": "SUNDSVÄGEN", "code": 32 }, { "name": "UNI/LUMISTREET MEDIU", "code": 33 }, { "name": "UNI/LUMISTREET MINI", "code": 34 }, { "name": "UNI/LUMISTREET SMALL", "code": 35 }, { "name": "XSPR T210", "code": 36 }, { "name": "PHILIPS BDP100 PCTR LED35/830 II DM CLO", "code": 41 }, { "name": "PHILIPS BDP100 PCTR LED35/830 II DS CLO", "code": 40 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Attachment", "type": "esriFieldTypeSmallInteger", "alias": "Fäste", "domain": { "type": "codedValue", "name": "lightingArmatureAttachment", "description": "", "codedValues": [ { "name": "BÅGE", "code": 1 }, { "name": "SAKNAS FÄSTE", "code": 3 }, { "name": "OKÄNT", "code": 2 }, { "name": "THORN VICTOR HOOK R295 96187415", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "År", "domain": null }, { "name": "RegSign", "type": "esriFieldTypeString", "alias": "Skapad av", "length": 255, "domain": null }, { "name": "RegDate", "type": "esriFieldTypeDate", "alias": "Skapad datum", "length": 8, "domain": null }, { "name": "ModificationSign", "type": "esriFieldTypeString", "alias": "Modifierad av", "length": 255, "domain": null }, { "name": "ModificationDate", "type": "esriFieldTypeDate", "alias": "Modifierat datum", "length": 8, "domain": null } ], "indexes": [ { "name": "R93_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_93", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G194LightingAsse", "fields": "LightingAssemblyID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_93", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "lightingAssembly", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "LightingAssemblyID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }