{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "sde_geostreet.GNG.lightingDevice", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "Extrafält", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "composite": true }, { "id": 0, "name": "lightingAssembly", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LightingAssemblyID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "Notes", "typeIdField": "", "subtypeField": "", "fields": [ { "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 }, { "name": "LED", "code": 36 }, { "name": "MT400", "code": 35 }, { "name": "MT150", "code": 34 }, { "name": "MT100", "code": 33 }, { "name": "MT70", "code": 32 }, { "name": "MT50", "code": 31 }, { "name": "MT35", "code": 30 }, { "name": "LED 32", "code": 37 }, { "name": "LED 35", "code": 38 }, { "name": "LED 50", "code": 39 }, { "name": "LED 69", "code": 42 }, { "name": "LED 45", "code": 41 }, { "name": "LED 18", "code": 40 }, { "name": "LED 60", "code": 43 }, { "name": "LED 40", "code": 44 }, { "name": "LED 66", "code": 45 }, { "name": "LED 15", "code": 47 }, { "name": "LED 90", "code": 48 }, { "name": "LED 26", "code": 49 }, { "name": "LED 37", "code": 50 }, { "name": "LED410", "code": 79 }, { "name": "LED 20,2", "code": 54 }, { "name": "LED 27", "code": 53 }, { "name": "LED 54", "code": 55 }, { "name": "70 MasterCityWhite", "code": 56 }, { "name": "LED 46", "code": 60 }, { "name": "LED 109", "code": 62 }, { "name": "LED 99", "code": 61 }, { "name": "LED 84", "code": 63 }, { "name": "LED 21", "code": 64 }, { "name": "LED 35,5", "code": 65 }, { "name": "Led 5", "code": 68 }, { "name": "LED 14", "code": 70 }, { "name": "LED 100", "code": 46 }, { "name": "LED 11", "code": 78 }, { "name": "ST50", "code": 58 }, { "name": "LED 25,5", "code": 66 }, { "name": "LED 11,6", "code": 67 }, { "name": "LED 10,9", "code": 73 }, { "name": "LED 36", "code": 76 }, { "name": "LED 46,2", "code": 77 }, { "name": "LED 29", "code": 57 }, { "name": "LED 20", "code": 59 }, { "name": "LED 26,5", "code": 75 }, { "name": "LED 3", "code": 69 }, { "name": "LED 33", "code": 72 }, { "name": "LED 12", "code": 74 }, { "name": "Node1-38W", "code": 82 }, { "name": "Node1-28W", "code": 81 }, { "name": "Node1-10W", "code": 80 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Type" }, { "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": "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": "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": "Demolerad", "code": 86 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EntityStatus" }, { "name": "FromDate", "type": "esriFieldTypeDate", "alias": "FrånDatum", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FromDate" }, { "name": "ToDate", "type": "esriFieldTypeDate", "alias": "TillDatum", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ToDate" }, { "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": "Aura Light", "code": 57 }, { "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": "Tunnel", "code": 58 }, { "name": "Farmarlampa", "code": 47 }, { "name": "STRIHL", "code": 48 }, { "name": "Hg-ARMATUR", "code": 49 }, { "name": "SGS101", "code": 50 }, { "name": "Cobra", "code": 51 }, { "name": "BGP307", "code": 59 }, { "name": "INDICO", "code": 53 }, { "name": "SITECO", "code": 54 }, { "name": "Thorn", "code": 56 }, { "name": "Philips", "code": 55 }, { "name": "Fagerhult", "code": 60 }, { "name": "Stockh Park", "code": 61 }, { "name": "Köpenhamn", "code": 62 }, { "name": "PL 222", "code": 63 }, { "name": "Karlskrona", "code": 64 }, { "name": "Fergin Nightspot", "code": 65 }, { "name": "IGuzzini Palco", "code": 67 }, { "name": "Karlskrona 5", "code": 71 }, { "name": "Karlskrona 3", "code": 70 }, { "name": "Karlskrona 1", "code": 69 }, { "name": "BEGA Pollare", "code": 72 }, { "name": "Eluttag mark", "code": 73 }, { "name": "BGP 293", "code": 74 }, { "name": "Noral-Avenue", "code": 75 }, { "name": "VarioLED Hydra", "code": 86 }, { "name": "Light 21", "code": 79 }, { "name": "Hercules-L", "code": 87 }, { "name": "iGuzzini Linealuce Markinfälld", "code": 68 }, { "name": "Light Up Earth", "code": 77 }, { "name": "Nanocube", "code": 78 }, { "name": "Ecospot Mini", "code": 84 }, { "name": "Monospot GC", "code": 81 }, { "name": "Monospot Allé", "code": 80 }, { "name": "Monospot 3", "code": 83 }, { "name": "Monospot 2", "code": 82 }, { "name": "IGuzzini Megazip Tonda Markinfälld", "code": 85 }, { "name": "Entrence", "code": 88 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Armature" }, { "name": "DeviceNumber", "type": "esriFieldTypeInteger", "alias": "Nummer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DeviceNumber" }, { "name": "Attachment", "type": "esriFieldTypeSmallInteger", "alias": "Fäste", "domain": { "type": "codedValue", "name": "lightingArmatureAttachment", "description": "", "codedValues": [ { "name": "BÅGE", "code": 1 }, { "name": "DDF 3", "code": 4 }, { "name": "DDF 2", "code": 3 }, { "name": "DDF 1", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Attachment" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "År", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Anmärkningar", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Notes" }, { "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" }, "editable": false, "nullable": true, "defaultValue": null, "modelName": "RecordStatus" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJEKTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ModificationSign", "type": "esriFieldTypeString", "alias": "Modifierad av", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ModificationSign" }, { "name": "ModificationDate", "type": "esriFieldTypeDate", "alias": "Modifierat datum", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ModificationDate" }, { "name": "RegSign", "type": "esriFieldTypeString", "alias": "Skapad av", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RegSign" }, { "name": "RegDate", "type": "esriFieldTypeDate", "alias": "Skapad datum", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RegDate" }, { "name": "ImportedID", "type": "esriFieldTypeString", "alias": "ImportID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ImportedID" }, { "name": "LightingAssemblyID", "type": "esriFieldTypeGUID", "alias": "BelysningsutrustningsID", "domain": null, "editable": false, "nullable": true, "length": 38, "defaultValue": null, "modelName": "LightingAssemblyID" }, { "name": "DeviceID", "type": "esriFieldTypeGUID", "alias": "UtrustningsID", "domain": null, "editable": false, "nullable": true, "length": 38, "defaultValue": null, "modelName": "DeviceID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALTID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "indexes": [ { "name": "R87_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G193LightingAsse", "fields": "LightingAssemblyID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "sde_geostreet.GNG.lightingDevice", "description": "", "prototype": { "attributes": { "ImportedID": null, "Type": null, "EntityStatus": null, "FromDate": null, "ToDate": null, "Armature": null, "DeviceNumber": null, "Attachment": null, "Year": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 20000, "maxRecordCountFactor": 1 }