{ "currentVersion": 10.91, "id": 3, "name": "sde_geostreet_gislaved.GNG.lightingDevice", "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": "RecordStatus", "type": "esriFieldTypeSmallInteger", "alias": "Poststatus", "domain": { "type": "codedValue", "name": "streetRecordCode", "description": "", "codedValues": [ { "name": "Gällande", "code": 5 }, { "name": "Ersatt", "code": 6 }, { "name": "Upphörde", "code": 7 }, { "name": "Arbete pågår", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EntityStatus", "type": "esriFieldTypeSmallInteger", "alias": "Objektstatus", "domain": { "type": "codedValue", "name": "streetEntityCode", "description": "", "codedValues": [ { "name": "Granskning", "code": 2 }, { "name": "Projekt", "code": 3 }, { "name": "Under uppbyggnad", "code": 4 }, { "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": "Stängd för trafik", "code": 31 }, { "name": "Nedlagt", "code": 33 }, { "name": "Överskott", "code": 34 }, { "name": "I lager", "code": 35 }, { "name": "Föreslagen", "code": 1 }, { "name": "Under reparation", "code": 12 }, { "name": "Överförd till ansvarig organisation", "code": 21 }, { "name": "Tagen ur drift", "code": 32 }, { "name": "Demolerad", "code": 86 } ], "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": "GLÖ100", "code": 1 }, { "name": "GLÖ1000", "code": 2 }, { "name": "GLÖ18", "code": 3 }, { "name": "GLÖ200", "code": 4 }, { "name": "GLÖ300", "code": 5 }, { "name": "GLÖ60", "code": 6 }, { "name": "HALO", "code": 7 }, { "name": "HG", "code": 8 }, { "name": "HG125", "code": 9 }, { "name": "HG250", "code": 10 }, { "name": "HG400", "code": 11 }, { "name": "HG50", "code": 12 }, { "name": "HG80", "code": 13 }, { "name": "KAND20", "code": 14 }, { "name": "LE20", "code": 15 }, { "name": "LY20", "code": 16 }, { "name": "LY36", "code": 17 }, { "name": "LY40", "code": 18 }, { "name": "MAH100", "code": 19 }, { "name": "NAH", "code": 20 }, { "name": "NAH100", "code": 21 }, { "name": "NAH150", "code": 22 }, { "name": "NAH250", "code": 23 }, { "name": "NAH400", "code": 24 }, { "name": "NAH50", "code": 25 }, { "name": "NAH70", "code": 26 }, { "name": "NAL180", "code": 27 }, { "name": "TELE60", "code": 28 }, { "name": "TRAF", "code": 29 } ], "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": "70106", "code": 1 }, { "name": "7373", "code": 2 }, { "name": "7375", "code": 3 }, { "name": "7395", "code": 4 }, { "name": "7401B", "code": 5 }, { "name": "7403B", "code": 6 }, { "name": "7416", "code": 7 }, { "name": "7417", "code": 8 }, { "name": "7418", "code": 9 }, { "name": "7420", "code": 10 }, { "name": "7428", "code": 11 }, { "name": "7440", "code": 12 }, { "name": "7449", "code": 13 }, { "name": "7453", "code": 14 }, { "name": "7455", "code": 15 }, { "name": "7481", "code": 16 }, { "name": "7906", "code": 17 }, { "name": "9111", "code": 18 }, { "name": "A-BETA", "code": 19 }, { "name": "ALBERT", "code": 20 }, { "name": "ANST50", "code": 21 }, { "name": "CGS443", "code": 22 }, { "name": "CIVIC1", "code": 23 }, { "name": "G7355", "code": 24 }, { "name": "G7455", "code": 25 }, { "name": "GASLYK", "code": 26 }, { "name": "GLOB", "code": 27 }, { "name": "JK", "code": 28 }, { "name": "KINESH", "code": 29 }, { "name": "L_SITE", "code": 30 }, { "name": "MEX", "code": 31 }, { "name": "NOKALU", "code": 32 }, { "name": "NORLYX", "code": 33 }, { "name": "PH203", "code": 34 }, { "name": "SGS201", "code": 35 }, { "name": "SGS203", "code": 36 }, { "name": "STOCKH", "code": 37 }, { "name": "STRATA", "code": 38 }, { "name": "STRATU", "code": 39 }, { "name": "STREET", "code": 40 }, { "name": "STRÅLK", "code": 41 }, { "name": "THORNB", "code": 42 }, { "name": "VENUS", "code": 43 }, { "name": "VICT-A", "code": 44 }, { "name": "VIKTOR", "code": 45 }, { "name": "WEST", "code": 46 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Attachment", "type": "esriFieldTypeSmallInteger", "alias": "Fäste", "domain": { "type": "codedValue", "name": "lightingArmatureAttachment", "description": "", "codedValues": [ { "name": "BÅGE", "code": 1 }, { "name": "RAK", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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 }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALTID", "length": 38, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "År", "domain": null } ], "indexes": [ { "name": "R25_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G161LightingAsse", "fields": "LightingAssemblyID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_25", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_25", "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 }