{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 131, "name": "Byggnad", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayFieldExpressionInfo": { "expression": "var result = \"#\" + $feature.HOUSENUMBER + \" - \";\nvar buildingPurposeCode = $feature.BALPURPOSE;\nvar buildingPurpose = DomainName($feature, 'BALPURPOSE');\nvar buildingStatus = DomainName($feature, 'BALSTATUS');\n\nif (IsEmpty(buildingPurposeCode)){result += 'Inget detaljerat ändamål'};\nIIf (buildingPurposeCode != 0, result += buildingPurpose, result += 'Ospecificerat detaljerat ändamål'); //add detailed purpose only when it is defined (not 0)\nif (!IsEmpty(buildingStatus)) {result += \" - \" + buildingStatus};\n\nreturn result;", "title": "" }, "displayField": "CREATEDBY", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "EXTERNALID", "type": "esriFieldTypeGUID", "alias": "Externt ID", "length": 38 }, { "name": "BALVERSION", "type": "esriFieldTypeInteger", "alias": "BALVersion" }, { "name": "BALSTATUS", "type": "esriFieldTypeSmallInteger", "alias": "BALStatus" }, { "name": "BALSYNCDATE", "type": "esriFieldTypeDate", "alias": "Synkroniseringsdatum", "length": 8 }, { "name": "BALACTIVITYTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Verksamhetsåtgärd" }, { "name": "BUILDINGTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Byggnadsändamål" }, { "name": "BALPURPOSE", "type": "esriFieldTypeSmallInteger", "alias": "Detaljerat ändamål" }, { "name": "CONSTRUCTIONYEAR", "type": "esriFieldTypeSmallInteger", "alias": "Nybyggnadsår" }, { "name": "EXTENSIONYEAR", "type": "esriFieldTypeSmallInteger", "alias": "Tillbyggnadsår" }, { "name": "UNCERTAINUSE", "type": "esriFieldTypeSmallInteger", "alias": "Osäkert ändamål" }, { "name": "USEFULFLOORSPACE", "type": "esriFieldTypeInteger", "alias": "Total boarea" }, { "name": "SUPPLIER", "type": "esriFieldTypeSmallInteger", "alias": "Leverantör" }, { "name": "EASEMENTBUILDING", "type": "esriFieldTypeSmallInteger", "alias": "Byggnadservitut" }, { "name": "EXEMPTADDRESSING", "type": "esriFieldTypeSmallInteger", "alias": "Undantagen från adressättning" }, { "name": "HOUSENUMBER", "type": "esriFieldTypeSmallInteger", "alias": "Husnummer" }, { "name": "ISMAINBUILDING", "type": "esriFieldTypeSmallInteger", "alias": "Huvudbyggnad" }, { "name": "NONFREEHOLDPROPERTY", "type": "esriFieldTypeSmallInteger", "alias": "Ofri grund" }, { "name": "UNDEFINEDLOCATION", "type": "esriFieldTypeSmallInteger", "alias": "Oidentifierat område" }, { "name": "COMMENTARY", "type": "esriFieldTypeString", "alias": "Byggnadsanmärkning", "length": 2000 }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Adress", "length": 255 }, { "name": "BELONGSTO", "type": "esriFieldTypeString", "alias": "Tillhör fastighet", "length": 36 }, { "name": "LIESON", "type": "esriFieldTypeString", "alias": "Ligger på fastighet", "length": 36 }, { "name": "PURPOSEOLD", "type": "esriFieldTypeString", "alias": "Byggnadsändamål historiskt", "length": 255 }, { "name": "BALPENDINGSYNC", "type": "esriFieldTypeSmallInteger", "alias": "Väntar på synkronisering" }, { "name": "METADATA", "type": "esriFieldTypeString", "alias": "Metadata", "length": 255 } ], "indexes": [ { "name": "R27_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I190EXTERNALID", "fields": "EXTERNALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "Hyperlänk", "relatedTableId": 140, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{68D51E91-4238-48C3-B2AA-3451375DE099}" }, { "id": 13, "name": "Entré", "relatedTableId": 135, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7C083BAF-F86D-4BBF-BCA3-6796D4E58605}" }, { "id": 15, "name": "Byggnad namn", "relatedTableId": 136, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{A145C890-F3A6-4FAC-AF53-A5607CFC7690}" }, { "id": 6, "name": "Byggnadsdel", "relatedTableId": 42, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F597126D-AD0A-44E2-BE6A-D081EA076A45}" }, { "id": 16, "name": "Berörs av fastighet", "relatedTableId": 134, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{FED199D8-AAE3-4A63-887E-E646CD16E982}" }, { "id": 14, "name": "Andra ändamål", "relatedTableId": 137, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{09DA36D0-F2F3-4CA0-BEB6-F2472A77CD11}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "d42c6f4ea90649f7b08b2a41ecb0da21" }