{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 6,
 "name": "DBO.KRAKENN_ID_KARTTA",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "C_KIINTEISTOTUNNUS",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "KG_KRAKENN",
   "type": "esriFieldTypeInteger",
   "alias": "KG_KRAKENN",
   "domain": null
  },
  {
   "name": "I_PYRAKNRO",
   "type": "esriFieldTypeInteger",
   "alias": "I_PYRAKNRO",
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "C_KIINTEISTOTUNNUS",
   "type": "esriFieldTypeString",
   "alias": "C_KIINTEISTOTUNNUS",
   "length": 17,
   "domain": null
  },
  {
   "name": "C_RAKENNUSNUMERO",
   "type": "esriFieldTypeString",
   "alias": "C_RAKENNUSNUMERO",
   "length": 3,
   "domain": null
  },
  {
   "name": "C_VTJ_PRT",
   "type": "esriFieldTypeString",
   "alias": "C_VTJ_PRT",
   "length": 10,
   "domain": null
  },
  {
   "name": "C_SIJAINTIKUNTA",
   "type": "esriFieldTypeString",
   "alias": "C_SIJAINTIKUNTA",
   "length": 3,
   "domain": null
  },
  {
   "name": "C_RAKENNUSTUNNUS",
   "type": "esriFieldTypeString",
   "alias": "C_RAKENNUSTUNNUS",
   "length": 17,
   "domain": null
  },
  {
   "name": "I_PKOORD",
   "type": "esriFieldTypeInteger",
   "alias": "I_PKOORD",
   "domain": null
  },
  {
   "name": "I_IKOORD",
   "type": "esriFieldTypeInteger",
   "alias": "I_IKOORD",
   "domain": null
  },
  {
   "name": "I_XKOORD",
   "type": "esriFieldTypeInteger",
   "alias": "I_XKOORD",
   "domain": null
  },
  {
   "name": "I_YKOORD",
   "type": "esriFieldTypeInteger",
   "alias": "I_YKOORD",
   "domain": null
  },
  {
   "name": "I_NKOORD",
   "type": "esriFieldTypeInteger",
   "alias": "I_NKOORD",
   "domain": null
  },
  {
   "name": "I_EKOORD",
   "type": "esriFieldTypeInteger",
   "alias": "I_EKOORD",
   "domain": null
  },
  {
   "name": "I_NKOORD_TM35FIN",
   "type": "esriFieldTypeInteger",
   "alias": "I_NKOORD_TM35FIN",
   "domain": null
  },
  {
   "name": "I_EKOORD_TM35FIN",
   "type": "esriFieldTypeInteger",
   "alias": "I_EKOORD_TM35FIN",
   "domain": null
  },
  {
   "name": "C_KAYTTARK",
   "type": "esriFieldTypeString",
   "alias": "C_KAYTTARK",
   "length": 3,
   "domain": null
  },
  {
   "name": "C_KAYTTARK_SELITE",
   "type": "esriFieldTypeString",
   "alias": "C_KAYTTARK_SELITE",
   "length": 100,
   "domain": null
  },
  {
   "name": "C_VALMPVM",
   "type": "esriFieldTypeDate",
   "alias": "C_VALMPVM",
   "length": 8,
   "domain": null
  },
  {
   "name": "C_RAUKEAMISPVM",
   "type": "esriFieldTypeDate",
   "alias": "C_RAUKEAMISPVM",
   "length": 8,
   "domain": null
  },
  {
   "name": "I_KOKALA",
   "type": "esriFieldTypeInteger",
   "alias": "I_KOKALA",
   "domain": null
  },
  {
   "name": "I_KERROSALA",
   "type": "esriFieldTypeInteger",
   "alias": "I_KERROSALA",
   "domain": null
  },
  {
   "name": "C_RAKSELITE",
   "type": "esriFieldTypeString",
   "alias": "C_RAKSELITE",
   "length": 50,
   "domain": null
  },
  {
   "name": "I_RAKOIK_KERROSALA",
   "type": "esriFieldTypeInteger",
   "alias": "I_RAKOIK_KERROSALA",
   "domain": null
  },
  {
   "name": "I_RAKTILAV",
   "type": "esriFieldTypeInteger",
   "alias": "I_RAKTILAV",
   "domain": null
  },
  {
   "name": "D_HUONEISTOALA",
   "type": "esriFieldTypeDouble",
   "alias": "D_HUONEISTOALA",
   "domain": null
  },
  {
   "name": "I_HUONEISTOJA",
   "type": "esriFieldTypeInteger",
   "alias": "I_HUONEISTOJA",
   "domain": null
  },
  {
   "name": "C_KATUOSOITE",
   "type": "esriFieldTypeString",
   "alias": "C_KATUOSOITE",
   "length": 75,
   "domain": null
  },
  {
   "name": "C_POSTINRO",
   "type": "esriFieldTypeString",
   "alias": "C_POSTINRO",
   "length": 5,
   "domain": null
  },
  {
   "name": "C_POSTITOIMIPAIKKA",
   "type": "esriFieldTypeString",
   "alias": "C_POSTITOIMIPAIKKA",
   "length": 50,
   "domain": null
  },
  {
   "name": "I_ASUKKAITA",
   "type": "esriFieldTypeSmallInteger",
   "alias": "I_ASUKKAITA",
   "domain": null
  },
  {
   "name": "C_OLOTILA",
   "type": "esriFieldTypeString",
   "alias": "C_OLOTILA",
   "length": 1,
   "domain": null
  },
  {
   "name": "C_KUKA",
   "type": "esriFieldTypeString",
   "alias": "C_KUKA",
   "length": 17,
   "domain": null
  },
  {
   "name": "C_KAYTTARK_TEEMOITUS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "C_KAYTTARK_TEEMOITUS",
   "domain": null
  },
  {
   "name": "C_SYMBOLVALUE",
   "type": "esriFieldTypeString",
   "alias": "C_SYMBOLVALUE",
   "length": 100,
   "domain": null
  },
  {
   "name": "C_KAYTOSSAOLOTILANNE",
   "type": "esriFieldTypeString",
   "alias": "C_KAYTOSSAOLOTILANNE",
   "length": 60,
   "domain": null
  },
  {
   "name": "I_VERO_LAHETYS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "I_VERO_LAHETYS",
   "domain": null
  },
  {
   "name": "C_VERO_LAHETETTYPVM",
   "type": "esriFieldTypeDate",
   "alias": "C_VERO_LAHETETTYPVM",
   "length": 8,
   "domain": null
  },
  {
   "name": "C_RAKENNUSLUOKKA",
   "type": "esriFieldTypeString",
   "alias": "C_RAKENNUSLUOKKA",
   "length": 4,
   "domain": null
  },
  {
   "name": "C_RAKENNUSLUOKKA_SELITE",
   "type": "esriFieldTypeString",
   "alias": "C_RAKENNUSLUOKKA_SELITE",
   "length": 100,
   "domain": null
  },
  {
   "name": "C_RAKENNUSLUOKKA_SELITE_RUOTSI",
   "type": "esriFieldTypeString",
   "alias": "C_RAKENNUSLUOKKA_SELITE_RUOTSI",
   "length": 100,
   "domain": null
  },
  {
   "name": "C_KAYTTARK_SELITE_RUOTSI",
   "type": "esriFieldTypeString",
   "alias": "C_KAYTTARK_SELITE_RUOTSI",
   "length": 100,
   "domain": null
  },
  {
   "name": "C_KATUOSOITE_RUOTSI",
   "type": "esriFieldTypeString",
   "alias": "C_KATUOSOITE_RUOTSI",
   "length": 75,
   "domain": null
  },
  {
   "name": "C_POSTITOIMIPAIKKA_RUOTSI",
   "type": "esriFieldTypeString",
   "alias": "C_POSTITOIMIPAIKKA_RUOTSI",
   "length": 50,
   "domain": null
  },
  {
   "name": "C_OLOTILA_SELITE",
   "type": "esriFieldTypeString",
   "alias": "C_OLOTILA_SELITE",
   "length": 50,
   "domain": null
  },
  {
   "name": "C_OLOTILA_SELITE_RUOTSI",
   "type": "esriFieldTypeString",
   "alias": "C_OLOTILA_SELITE_RUOTSI",
   "length": 50,
   "domain": null
  },
  {
   "name": "C_RAKENNUSLUOKKA_TEEMOITUS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "C_RAKENNUSLUOKKA_TEEMOITUS",
   "domain": null
  },
  {
   "name": "C_KAYTOSSAOLOTILANNE_RUOTSI",
   "type": "esriFieldTypeString",
   "alias": "C_KAYTOSSAOLOTILANNE_RUOTSI",
   "length": 60,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "KRAKENN_ID_KARTTA_PK",
   "fields": "KG_KRAKENN",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_KAYTTARK",
   "fields": "C_KAYTTARK_TEEMOITUS",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_KAYTTARK3",
   "fields": "C_KAYTTARK",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_NE_TM35_2",
   "fields": "I_NKOORD_TM35FIN,I_EKOORD_TM35FIN",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_NE2",
   "fields": "I_NKOORD,I_EKOORD",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_OBJECTID",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_OLOTILA2",
   "fields": "C_OLOTILA",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_OSOITE",
   "fields": "C_KATUOSOITE",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_PI2",
   "fields": "I_PKOORD,I_IKOORD",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_PRT2",
   "fields": "C_VTJ_PRT",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_PYRAKNRO2",
   "fields": "I_PYRAKNRO",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_RAKENNUSLUOKKA2",
   "fields": "C_RAKENNUSLUOKKA_TEEMOITUS",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_RL7",
   "fields": "C_RAKENNUSLUOKKA",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_RN",
   "fields": "C_KIINTEISTOTUNNUS,C_RAKENNUSNUMERO",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_RT3",
   "fields": "C_RAKENNUSTUNNUS",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "XP_KRAKENN_XY2",
   "fields": "I_XKOORD,I_YKOORD",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 100000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "66433d01228c411b8002c57ae1854de2"
}