{ "currentVersion": 10.91, "id": 1, "name": "sde_geostreet.GNG.lightingDevice", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "lightingAssembly", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "LightingAssemblyID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "Notes", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJEKTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALTID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Anmärkningar", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Notes" }, { "name": "LightingAssemblyID", "type": "esriFieldTypeGUID", "alias": "BelysningsutrustningsID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "LightingAssemblyID" }, { "name": "Type", "type": "esriFieldTypeSmallInteger", "alias": "Lamptyp", "domain": { "type": "codedValue", "name": "lightingDevice", "description": "", "codedValues": [ { "name": "Okänd", "code": 1 }, { "name": " CDO70", "code": 2 }, { "name": " HG125", "code": 3 }, { "name": " HGH100", "code": 4 }, { "name": " LED17W", "code": 5 }, { "name": " NAH100", "code": 6 }, { "name": " NAH50", "code": 7 }, { "name": " NAH70", "code": 8 }, { "name": "Ellipsoid CDO150", "code": 9 }, { "name": "Ellipsoid CDO70", "code": 10 }, { "name": "Ellipsoid HG125", "code": 11 }, { "name": "Ellipsoid HG250", "code": 12 }, { "name": "Ellipsoid HG80", "code": 13 }, { "name": "Ellipsoid HGH100", "code": 14 }, { "name": "Ellipsoid HGH150", "code": 15 }, { "name": "Ellipsoid HGH250", "code": 16 }, { "name": "Ellipsoid HGH70", "code": 17 }, { "name": "Ellipsoid NAH100", "code": 18 }, { "name": "Ellipsoid NAH150", "code": 19 }, { "name": "Ellipsoid NAH250", "code": 20 }, { "name": "Ellipsoid NAH400", "code": 21 }, { "name": "Ellipsoid NAH50", "code": 22 }, { "name": "Ellipsoid NAH70", "code": 23 }, { "name": "Ellipsoid NAV-E70", "code": 24 }, { "name": "komp.lysrör HG125", "code": 25 }, { "name": "komp.lysrör ROR26", "code": 26 }, { "name": "LED LED24", "code": 27 }, { "name": "LED LED31", "code": 28 }, { "name": "Lysrör L36", "code": 29 }, { "name": "Lågenergi LÅGENERGI", "code": 30 }, { "name": "Lågenergi LÅGENERGI23W", "code": 31 }, { "name": "Lågenergi LÅGENRGI42W", "code": 32 }, { "name": "Tub CDO70", "code": 33 }, { "name": "Tub HGH150", "code": 34 }, { "name": "Tub HGH70", "code": 35 }, { "name": "Tub NAH100", "code": 36 }, { "name": "Tub NAH150", "code": 37 }, { "name": "Tub NAH400", "code": 38 }, { "name": "Tub NAH50", "code": 39 }, { "name": "Tub NAH70", "code": 40 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Type" }, { "name": "Armature", "type": "esriFieldTypeSmallInteger", "alias": "Armatur", "domain": { "type": "codedValue", "name": "lightingArmature", "description": "", "codedValues": [ { "name": "Okänd", "code": 1 }, { "name": "Okänd", "code": 2 }, { "name": "Ahlsell AHLSEL E 77 603 51", "code": 9 }, { "name": "Annell SITECO E 77 379 00", "code": 10 }, { "name": "Atelje Lyktan ORIGO Besnr205710", "code": 11 }, { "name": "Atelje Lyktan STH590 5927-08/79", "code": 12 }, { "name": "Bega ORIENT artnr.2928", "code": 13 }, { "name": "Celsius Tech SOLAR1", "code": 14 }, { "name": "Elektroskandia RAY E 77 518 24", "code": 15 }, { "name": "Exaktor ANITA E 77 491 28", "code": 16 }, { "name": "hhDesign CIVIC E 77 339 02", "code": 17 }, { "name": "hhDesign KOKKO", "code": 18 }, { "name": "hhDesign NORDEN", "code": 19 }, { "name": "JK 7453 E 77 337 18", "code": 20 }, { "name": "JK 7455 E 77 333 09", "code": 21 }, { "name": "JK BYHATT E 77 330 33", "code": 22 }, { "name": "JK BYHATT E 77 330 43", "code": 23 }, { "name": "Philips E 77 329 23", "code": 24 }, { "name": "Philips 7455 E 77 333 01", "code": 25 }, { "name": "Philips ATHENA", "code": 26 }, { "name": "Philips ATHENA E 77 529 80", "code": 27 }, { "name": "Philips BISPEL E 77 529 25", "code": 28 }, { "name": "Philips CAMBR", "code": 29 }, { "name": "Philips CITYSP", "code": 30 }, { "name": "Philips HGS203 E 77 323 40", "code": 31 }, { "name": "Philips HGS203 E 77 323 63", "code": 32 }, { "name": "Philips IRID E 77 325 62", "code": 33 }, { "name": "Philips IRID E 77 326 02", "code": 34 }, { "name": "Philips IRID E 77 326 32", "code": 35 }, { "name": "Philips IRID E 77 326 33", "code": 36 }, { "name": "Philips IRID E 77 326 65", "code": 37 }, { "name": "Philips IRID E 77 327 04", "code": 38 }, { "name": "Philips IRID E77 381 11", "code": 39 }, { "name": "Philips IRILED E77 385 10", "code": 40 }, { "name": "Philips KOKKO E 77 528 25", "code": 41 }, { "name": "Philips KOKKO E 77 528 27", "code": 42 }, { "name": "Philips METROB", "code": 43 }, { "name": "Philips NORDEN E 77 528 27", "code": 44 }, { "name": "Philips NORDEN E77 329 22", "code": 45 }, { "name": "Philips SELEN E 77 329 22", "code": 46 }, { "name": "Philips SELEN E 77 329 23", "code": 47 }, { "name": "Philips SELEN E 77 329 24", "code": 48 }, { "name": "Philips SELEN E 77 329 25", "code": 49 }, { "name": "Philips SELEN E 77 333 01", "code": 50 }, { "name": "Philips SELEN E 83 329 23", "code": 51 }, { "name": "Philips SELEN E77 329 22", "code": 52 }, { "name": "Philips SELEN E77 329 23", "code": 53 }, { "name": "Philips SGS203 E 77 323 40", "code": 54 }, { "name": "Philips SGS203 E 77 323 63", "code": 55 }, { "name": "Reciano Zero R6060", "code": 56 }, { "name": "Scandidelux ALTTOR E 77 566 61", "code": 57 }, { "name": "Scandidelux KVARNH E 77 562 08", "code": 58 }, { "name": "Scandidelux LKLOCK E 77 566 11", "code": 59 }, { "name": "Scandidelux POLAR E 77 563 08", "code": 60 }, { "name": "Scandidelux SCANDI E77 260 64", "code": 61 }, { "name": "Scandidelux SCANDI E77 260 84", "code": 62 }, { "name": "Scandidelux STKLOC E 77 566 61", "code": 63 }, { "name": "Scandidelux TUN701 E 77 460 13", "code": 64 }, { "name": "Scandidelux VIADUK E 77 460 07", "code": 65 }, { "name": "Scandidelux VIADUK E77 460 07", "code": 66 }, { "name": "Siemens", "code": 67 }, { "name": "Siemens SIOPT", "code": 68 }, { "name": "Siemens SIOPT E 77 260 08", "code": 69 }, { "name": "Siemens SIOPT E 77 260 23", "code": 70 }, { "name": "Siemens SIOPT E 77 263 05", "code": 71 }, { "name": "Siemens SIOPT E77 260 23", "code": 72 }, { "name": "Siemens SIOPT SIOPTAL", "code": 73 }, { "name": "Siemens VIADUK E 77 460 07", "code": 74 }, { "name": "Thorn E 77 333 01", "code": 75 }, { "name": "Thorn 7390 E 77 335 47", "code": 76 }, { "name": "Thorn 7390 E 77 533 14", "code": 77 }, { "name": "Thorn 7390 E77 335 43", "code": 78 }, { "name": "Thorn 7390 E77 533 04", "code": 79 }, { "name": "Thorn 7405 E 77 335 43", "code": 80 }, { "name": "Thorn 7418 E 77 331 25", "code": 81 }, { "name": "Thorn 7418 E 77 331 32", "code": 82 }, { "name": "Thorn 7418 E 77 331 34", "code": 83 }, { "name": "Thorn 7418 E 77 731 34", "code": 84 }, { "name": "Thorn 7418 E77 331 28", "code": 85 }, { "name": "Thorn 7418 E77 331 32", "code": 86 }, { "name": "Thorn 7449 E 77 337 23", "code": 87 }, { "name": "Thorn 7453 E 77 337 18", "code": 88 }, { "name": "Thorn 7453 E 77 337 18, E 77 337 05", "code": 89 }, { "name": "Thorn 7455 E 77 333 01", "code": 90 }, { "name": "Thorn 7455 E 77 333 02", "code": 91 }, { "name": "Thorn 7455 E 77 333 09", "code": 92 }, { "name": "Thorn 7455 E 77 333 23", "code": 93 }, { "name": "Thorn 7455 E 77 999 00", "code": 94 }, { "name": "Thorn 7455 E 77 999 00", "code": 95 }, { "name": "Thorn 7455 E77 333 09", "code": 96 }, { "name": "Thorn 7455 E77 333 23", "code": 97 }, { "name": "Thorn AT.LED E 77 338 65", "code": 98 }, { "name": "Thorn AT.LED E77 338 66", "code": 99 }, { "name": "Thorn BORST", "code": 100 }, { "name": "Thorn BORST E 77 531 24", "code": 101 }, { "name": "Thorn BYHATT", "code": 102 }, { "name": "Thorn BYHATT E 77 330 33", "code": 103 }, { "name": "Thorn BYHATT E 77 330 43", "code": 104 }, { "name": "Thorn BYHATT E77 330 33", "code": 105 }, { "name": "Thorn BYHATT E77 330 43", "code": 106 }, { "name": "Thorn CIVIC E 77 339 02", "code": 107 }, { "name": "Thorn GL\"KUG 7405.006", "code": 108 }, { "name": "Thorn KINESH E 77 530 23", "code": 109 }, { "name": "Thorn NORDEN", "code": 110 }, { "name": "Thorn R6060 E 77 999 00", "code": 111 }, { "name": "Thorn SELEN E 77 329 23", "code": 112 }, { "name": "Thorn SGS203 E 77 323 63", "code": 113 }, { "name": "Thorn SIOPT E 77 260 08", "code": 114 }, { "name": "Thorn SIOPT E 77 332 46", "code": 115 }, { "name": "Thorn SP7359 E 77 533 72", "code": 116 }, { "name": "Thorn STRATA E 77 337 85", "code": 117 }, { "name": "Thorn STRATA E77 337 85", "code": 118 }, { "name": "Thorn STREET E 77 332 46", "code": 119 }, { "name": "Thorn STREET E 77 332 46", "code": 120 }, { "name": "Thorn STREET E 77 332 48", "code": 121 }, { "name": "Thorn STREET E 77 332 53", "code": 122 }, { "name": "Thorn STREET E 77 332 58", "code": 123 }, { "name": "Thorn STREET E 77 334 04", "code": 124 }, { "name": "Thorn STREET E 77 334 05", "code": 125 }, { "name": "Thorn STREET E 77 334 06", "code": 126 }, { "name": "Thorn STREET E 77 334 38", "code": 127 }, { "name": "Thorn STREET E 77 334 42", "code": 128 }, { "name": "Thorn STREET E 77 334 44", "code": 129 }, { "name": "Thorn STREET E 77 334 46", "code": 130 }, { "name": "Thorn STREET E 77 732 53", "code": 131 }, { "name": "Thorn STREET E77 332 42", "code": 132 }, { "name": "Thorn STREET E77 332 46", "code": 133 }, { "name": "Thorn STREET E77 334 04", "code": 134 }, { "name": "Thorn STREET E77 334 05", "code": 135 }, { "name": "Thorn STREET E77 334 38", "code": 136 }, { "name": "Thorn STREET E7733248", "code": 137 }, { "name": "Thorn STREET E83 467 10", "code": 138 }, { "name": "Thorn STREET STREETUS", "code": 139 }, { "name": "Thorn VICTA E 77 336 12", "code": 140 }, { "name": "Thorn VICTA E 77 336 14", "code": 141 }, { "name": "Thorn VICTA E 77 336 22", "code": 142 }, { "name": "Thorn VICTA E 77 336 24", "code": 143 }, { "name": "Thorn VICTOR E 77 335 12", "code": 144 }, { "name": "Thorn VICTOR E 77 335 19", "code": 145 }, { "name": "Thorn VICTOR E 77 336 12", "code": 146 }, { "name": "Wendler ALTTOR 7592.010", "code": 147 }, { "name": "Wendler ALTTOR 7592.010 (ALTES TOR)", "code": 148 }, { "name": "Wendler GL\"KUG", "code": 149 }, { "name": "Wendler GL\"KUG 7405.006", "code": 150 }, { "name": "Wendler GL\"KUG Beställ.Nr7405.006", "code": 151 }, { "name": "Wendler MNFSNF 7592.010 (ALTES TOR)", "code": 152 }, { "name": "Wendler STREET E 77 334 38", "code": 153 }, { "name": "Vulkan 744284", "code": 154 }, { "name": "ANITA E 77 491 25", "code": 3 }, { "name": "NORDEN", "code": 4 }, { "name": "SELEN", "code": 5 }, { "name": "SELEN E 77 329 23", "code": 6 }, { "name": "SIOPT E 77 260 08", "code": 7 }, { "name": "STREET", "code": 8 }, { "name": "Philips ISARO LED 19W", "code": 155 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Armature" }, { "name": "Attachment", "type": "esriFieldTypeSmallInteger", "alias": "Fäste", "domain": { "type": "codedValue", "name": "lightingArmatureAttachment", "description": "", "codedValues": [ { "name": "OKÄND", "code": 1 }, { "name": " E77 711 15", "code": 2 }, { "name": "Arm 1,2", "code": 3 }, { "name": "Arm 1,2 m", "code": 4 }, { "name": "Arm 1,2m", "code": 5 }, { "name": "ARM E 77 567 76", "code": 6 }, { "name": "Armaturkrona AK3F", "code": 7 }, { "name": "Armaturkrona E 77 792 12", "code": 8 }, { "name": "Armaturkrona E 77 792 13", "code": 9 }, { "name": "Atelje lyktan dubbel 205052-1005", "code": 10 }, { "name": "Atelje lyktan enkel 205017-1029", "code": 11 }, { "name": "Dubbelarm 205052-1005", "code": 12 }, { "name": "Dubbelarm E 77 712 30", "code": 13 }, { "name": "Dubbelarm E 77 717 00", "code": 14 }, { "name": "Dubbelfäste E 77 712 30", "code": 15 }, { "name": "DUBBELFÄSTE E 77 712 30\n", "code": 16 }, { "name": "Dubbellarm 205052-1005", "code": 17 }, { "name": "E06C Svartlack", "code": 18 }, { "name": "Enkel arm 201517-1029", "code": 19 }, { "name": "Enkelarm 201517-1029", "code": 20 }, { "name": "Halvböj E 77 712 46", "code": 21 }, { "name": "KROK", "code": 22 }, { "name": "KRONA E 77 792 12", "code": 23 }, { "name": "KRONA E 77 792 13", "code": 24 }, { "name": "KRONA E 77 792 34", "code": 25 }, { "name": "KRONA E 77 792 35", "code": 26 }, { "name": "Rör arm 1m E77 711 30", "code": 27 }, { "name": "Rörarm 0,5m E77 711 30", "code": 28 }, { "name": "Rörarm 1 m E 77 711 30", "code": 29 }, { "name": "Rörarm 1 m E77 711 30", "code": 30 }, { "name": "Rörarm 1,5 E 77 711 15", "code": 31 }, { "name": "Rörarm 1,5 E77 711 15", "code": 32 }, { "name": "Rörarm 1,5 m E 77 711 15", "code": 33 }, { "name": "Rörarm 1,5 m E77 711 15", "code": 34 }, { "name": "Rörarm 1,5 m E77 711 33", "code": 35 }, { "name": "Rörarm 1,5m E77 711 15", "code": 36 }, { "name": "Rörarm 1,5m E77 711 33", "code": 37 }, { "name": "Rörarm 1.5 m E77 711 15", "code": 38 }, { "name": "Rörarm 1.5m E77 711 15", "code": 39 }, { "name": "Rörarm 1m", "code": 40 }, { "name": "Rörarm 1m E 77 711 30", "code": 41 }, { "name": "Rörarm 1m E77 711 15", "code": 42 }, { "name": "Rörarm 1m E77 711 30", "code": 43 }, { "name": "Rörarm 1m kapad", "code": 44 }, { "name": "Rörarm 1m kapad E 77 711 30", "code": 45 }, { "name": "Rörarm 1m kapad E77 711 30", "code": 46 }, { "name": "Rörarm E 77 711 15", "code": 47 }, { "name": "Rörarm E77 711 30", "code": 48 }, { "name": "Rörarm E77 715 01", "code": 49 }, { "name": "Rörarm saknas", "code": 50 }, { "name": "SCAPE Enkelarm E 77 726 64", "code": 51 }, { "name": "Stolparm enkel V03 660 04", "code": 52 }, { "name": "Stolparm V03 660 04", "code": 53 }, { "name": "Stolpböj E 77 712 46", "code": 54 }, { "name": "Stolpkrok E 77 712 44", "code": 55 }, { "name": "Stolpkrok E 77 712 46", "code": 56 }, { "name": "Stopböj E 77 712 46", "code": 57 }, { "name": "Strålkastarställ E 77 794 11", "code": 58 }, { "name": "VÄGGAR ZPW920", "code": 59 }, { "name": "VÄGGARM ZPW920", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Attachment" }, { "name": "Alternativ_armatur", "type": "esriFieldTypeString", "alias": "Alternativ armatur", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Alternativ_armatur" } ], "indexes": [ { "name": "R272_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_272", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1246LightingAss", "fields": "LightingAssemblyID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_272", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sde_geostreet.GNG.lightingDevice", "description": "", "prototype": { "attributes": { "Armature": null, "Attachment": null, "Alternativ_armatur": null, "Notes": null, "LightingAssemblyID": null, "Type": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }