{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 67, "name": "Asemakaavan kaavamääräykset", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "KAAVAMERKINTA", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASEMAKAAVAGUID", "type": "esriFieldTypeGUID", "alias": "ASEMAKAAVAGUID", "length": 38, "domain": null }, { "name": "KAAVAMERKINTA", "type": "esriFieldTypeString", "alias": "Vantaan käyttötarkoitusmerkintä", "length": 50, "domain": null }, { "name": "KAAVATUNNUS", "type": "esriFieldTypeString", "alias": "Kaavan yksilöivä tunnus", "length": 50, "domain": null }, { "name": "MERKINTA_TEKSTI_FI", "type": "esriFieldTypeString", "alias": "Määräysteksti", "length": 2000, "domain": null }, { "name": "MERKINTA_TEKSTI_SWE", "type": "esriFieldTypeString", "alias": "Määräysteksti ruotsiksi", "length": 2000, "domain": null }, { "name": "SELITE_IKONI", "type": "esriFieldTypeString", "alias": "Selitteen pikkukuva", "length": 100, "domain": null }, { "name": "TULOSTUSJARJESTYS", "type": "esriFieldTypeSmallInteger", "alias": "Tulostusjärjestys", "domain": null }, { "name": "YMPARISTOMINISTERIONKOODI", "type": "esriFieldTypeString", "alias": "Ympäristöministeriön kaavamerkinnän koodi", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PAIVITTAJA", "type": "esriFieldTypeString", "alias": "Päivittäjä", "length": 50, "domain": null }, { "name": "PAIVITYSAJANKOHTA", "type": "esriFieldTypeDate", "alias": "Päivitysajankohta", "length": 8, "domain": null }, { "name": "LIITTYY_MERKINTAAN", "type": "esriFieldTypeString", "alias": "Liittyy merkintään", "length": 50, "domain": null }, { "name": "TALLENNUSAJANKOHTA", "type": "esriFieldTypeDate", "alias": "Tallennusajankohta", "length": 8, "domain": null }, { "name": "ASEMAKAAVA", "type": "esriFieldTypeString", "alias": "Asemakaava", "length": 255, "domain": null }, { "name": "TALLENTAJA", "type": "esriFieldTypeString", "alias": "Tallentaja", "length": 50, "domain": null }, { "name": "MERKINTA", "type": "esriFieldTypeString", "alias": "Määräyksen kaavamerkintä", "length": 50, "domain": null }, { "name": "KAAVAMAARAYSPANKKIGUID", "type": "esriFieldTypeGUID", "alias": "KAAVAMAARAYSPANKKIGUID", "length": 38, "domain": null }, { "name": "MERKINTAGUID", "type": "esriFieldTypeGUID", "alias": "MERKINTAGUID", "length": 38, "domain": null }, { "name": "VIITTEELLINEN", "type": "esriFieldTypeSmallInteger", "alias": "Viitteellinen", "domain": { "type": "codedValue", "name": "WS1_KYLLA_EI_NUMEROT", "description": "Kyllä/Ei valinta (kokonaisluku)", "codedValues": [ { "name": "Ei", "code": 0 }, { "name": "Kyllä", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ALINARVO", "type": "esriFieldTypeDouble", "alias": "Alin numeerinen arvo", "domain": null }, { "name": "YLINARVO", "type": "esriFieldTypeDouble", "alias": "Ylin numeerinen arvo", "domain": null }, { "name": "TEKSTIARVO", "type": "esriFieldTypeString", "alias": "Tekstiarvo", "length": 255, "domain": null }, { "name": "TEKSTIARVO_SWE", "type": "esriFieldTypeString", "alias": "Ruotsinkielinen tekstiarvo", "length": 255, "domain": null }, { "name": "ALKUPVM", "type": "esriFieldTypeDate", "alias": "Alkupäivämäärä", "length": 8, "domain": null }, { "name": "LOPPUPVM", "type": "esriFieldTypeDate", "alias": "Loppupäivämäärä", "length": 8, "domain": null }, { "name": "RYHMAGUID", "type": "esriFieldTypeGUID", "alias": "RYHMAGUID", "length": 38, "domain": null }, { "name": "MERKINTAA_KOSKEVA_MAARAYS", "type": "esriFieldTypeString", "alias": "Merkintää koskeva määräys", "length": 1073741822, "domain": null }, { "name": "MERKINTAA_KOSKEVA_MAARAYS_SE", "type": "esriFieldTypeString", "alias": "Merkintää koskeva määräys ruotsiksi", "length": 1073741822, "domain": null }, { "name": "LIHAVOITU", "type": "esriFieldTypeSmallInteger", "alias": "LIHAVOITU", "domain": { "type": "codedValue", "name": "WS1_KYLLA_EI_NUMEROT", "description": "Kyllä/Ei valinta (kokonaisluku)", "codedValues": [ { "name": "Ei", "code": 0 }, { "name": "Kyllä", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } } ], "indexes": [ { "name": "UUID_14", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I182KAAVATUNNUS", "fields": "KAAVATUNNUS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_182_ASEMAKAA", "fields": "ASEMAKAAVAGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_182_RYHMAGUI", "fields": "RYHMAGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Kaavamääräyspisteet", "relatedTableId": 39, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{533569D5-EA7B-4642-971C-755ED579680B}" }, { "id": 9, "name": "Asemakaavan käyttötarkoitusalueet", "relatedTableId": 66, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FF066CB8-CF82-45F6-8B5D-15148BE4C8F8}" }, { "id": 8, "name": "Kaavamääräysalueet", "relatedTableId": 41, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A52A1A09-5FC8-44AB-B6CC-88258D427BE1}" } ], "capabilities": "Map", "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1540551907000 } }