sql

json.json

{
    "sql": "UPDATE jobs SET id = 'ASB123', data = '{\"created_at\":\"2015-05-18T16:07:48.734Z\",\"created_by\":\"layer\",\"delay\":\"\",\"duration\":2501.706172004342,\"errors\":[],\"fingerprint\":\"a4d21bc9befc77aa1ef96a8eee9b6864\",\"id\":\"aac7de9c-1f09-4c1b-999e-69aba6075c19\",\"inputs\":{\"item_id\":\"ed2289c75ac244f8a2a5ce7ff1395b77\",\"service_id\":\"f4cf6e3aa83c1de12b4f400cb483a81130b9dcd6\",\"layer_info\":{\"currentVersion\":\"10.3\",\"id\":\"0\",\"name\":\"幼児園_幼稚園_その他保育施設\",\"type\":\"Feature Layer\",\"displayField\":\"名称\",\"description\":\"\",\"copyrightText\":\"\",\"defaultVisibility\":\"true\",\"editingInfo\":{\"lastEditDate\":\"1413708740396\"},\"isDataVersioned\":\"false\",\"supportsCalculate\":\"true\",\"supportsAttachmentsByUploadId\":\"true\",\"supportsRollbackOnFailureParameter\":\"true\",\"supportsStatistics\":\"true\",\"supportsAdvancedQueries\":\"true\",\"supportsValidateSql\":\"true\",\"supportsCoordinatesQuantization\":\"true\",\"advancedQueryCapabilities\":{\"supportsPagination\":\"true\",\"supportsQueryWithDistance\":\"true\",\"supportsReturningQueryExtent\":\"true\",\"supportsStatistics\":\"true\",\"supportsOrderBy\":\"true\",\"supportsDistinct\":\"true\"},\"geometryType\":\"esriGeometryPoint\",\"minScale\":\"0\",\"maxScale\":\"0\",\"extent\":{\"xmin\":\"136.2891935\",\"ymin\":\"36.069476700000045\",\"xmax\":\"136.4022268000001\",\"ymax\":\"36.106790500000045\",\"spatialReference\":{\"wkid\":\"104111\",\"latestWkid\":\"104111\"}},\"drawingInfo\":{\"renderer\":{\"type\":\"simple\",\"symbol\":{\"type\":\"esriSMS\",\"style\":\"esriSMSCircle\",\"color\":[\"156\",\"54\",\"0\",\"255\"],\"size\":\"4\",\"angle\":\"0\",\"xoffset\":\"0\",\"yoffset\":\"0\",\"outline\":{\"color\":[\"0\",\"0\",\"0\",\"255\"],\"width\":\"1\"}},\"label\":\"\",\"description\":\"\"},\"transparency\":\"0\",\"labelingInfo\":\"\"},\"allowGeometryUpdates\":\"true\",\"hasAttachments\":\"false\",\"htmlPopupType\":\"esriServerHTMLPopupTypeAsHTMLText\",\"hasM\":\"false\",\"hasZ\":\"false\",\"objectIdField\":\"OBJECTID\",\"globalIdField\":\"\",\"typeIdField\":\"\",\"fields\":[{\"name\":\"OBJECTID\",\"type\":\"esriFieldTypeOID\",\"alias\":\"OBJECTID\",\"sqlType\":\"sqlTypeOther\",\"nullable\":\"false\",\"editable\":\"false\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"名称\",\"type\":\"esriFieldTypeString\",\"alias\":\"名称\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"略称\",\"type\":\"esriFieldTypeString\",\"alias\":\"略称\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"電話番号\",\"type\":\"esriFieldTypeString\",\"alias\":\"電話番号\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"郵便番号\",\"type\":\"esriFieldTypeString\",\"alias\":\"郵便番号\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"住所\",\"type\":\"esriFieldTypeString\",\"alias\":\"住所\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"開館時間\",\"type\":\"esriFieldTypeString\",\"alias\":\"開館時間\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"休館\",\"type\":\"esriFieldTypeString\",\"alias\":\"休館\",\"sqlType\":\"sqlTypeOther\",\"length\":\"255\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"緯度\",\"type\":\"esriFieldTypeDouble\",\"alias\":\"緯度\",\"sqlType\":\"sqlTypeOther\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"},{\"name\":\"経度\",\"type\":\"esriFieldTypeDouble\",\"alias\":\"経度\",\"sqlType\":\"sqlTypeOther\",\"nullable\":\"true\",\"editable\":\"true\",\"domain\":\"\",\"defaultValue\":\"\"}],\"indexes\":[{\"name\":\"PK__Eiheiji___F4B70D8558CA0D69\",\"fields\":\"OBJECTID\",\"isAscending\":\"true\",\"isUnique\":\"true\",\"description\":\"clustered, unique, primary key\"},{\"name\":\"user_4939.Eiheiji_cho_Yochien_etc_幼児園_幼稚園_その他保育施設_Shape_sidx\",\"fields\":\"Shape\",\"isAscending\":\"false\",\"isUnique\":\"false\",\"description\":\"Shape Index\"}],\"templates\":[{\"name\":\"幼児園_幼稚園_その他保育施設\",\"description\":\"\",\"drawingTool\":\"esriFeatureEditToolPoint\",\"prototype\":{\"attributes\":{\"経度\":\"\",\"名称\":\"\",\"略称\":\"\",\"電話番号\":\"\",\"郵便番号\":\"\",\"住所\":\"\",\"開館時間\":\"\",\"休館\":\"\",\"緯度\":\"\"}}}],\"supportedQueryFormats\":\"JSON\",\"hasStaticData\":\"true\",\"maxRecordCount\":\"1000\",\"capabilities\":\"Query\"},\"url\":\"http://services3.arcgis.com/iH4Iz7CEdh5xTJYb/arcgis/rest/services/Eiheiji_cho_Yochien_etc/FeatureServer/0\"},\"messages\":[{\"type\":\"info\",\"log\":\"Saved dataset saved for ed2289c75ac244f8a2a5ce7ff1395b77_0\",\"i18n\":\"messages.processors.feature_layer.progress.dataset_inputs_saved\"}],\"output\":{\"dataset_id\":\"ed2289c75ac244f8a2a5ce7ff1395b77_0\"},\"parent_id\":\"5705eae2-415b-451d-ac00-4a8d063a2a17\",\"priority\":\"critical\",\"retries\":\"0\",\"started_at\":\"2015-05-18T16:07:52.172Z\",\"status\":\"finished\",\"type\":\"harvest:feature-layer\"}'",
    "data": []
}