{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "都市計畫案件動態", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "case_number", "type": "esriFieldTypeString", "alias": "都計案件編號", "length": 255, "domain": null }, { "name": "update_type_id", "type": "esriFieldTypeSmallInteger", "alias": "更新類別", "domain": { "type": "codedValue", "name": "urban_planning_case_update_type", "description": "都市計畫案動態類型", "codedValues": [ { "name": "一般消息", "code": 999 }, { "name": "計畫圖發布", "code": 9 }, { "name": "計畫書發布", "code": 8 }, { "name": "公告發布實施", "code": 7 }, { "name": "內政部核定", "code": 6 }, { "name": "內政部都委會審議", "code": 5 }, { "name": "雲林縣都委會審議", "code": 4 }, { "name": "公開展覽", "code": 3 }, { "name": "鄉鎮市都委會審議", "code": 2 }, { "name": "規劃階段", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "related_meeting_id", "type": "esriFieldTypeGUID", "alias": "會議ID", "length": 38, "domain": null }, { "name": "parent_update_id", "type": "esriFieldTypeGUID", "alias": "母動態ID", "length": 38, "domain": null }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "事件起日", "length": 8, "domain": null }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "事件訖日", "length": 8, "domain": null }, { "name": "title", "type": "esriFieldTypeString", "alias": "標題", "length": 2000, "domain": null }, { "name": "content", "type": "esriFieldTypeString", "alias": "內容(辦理情形)", "length": 2000, "domain": null }, { "name": "author_name", "type": "esriFieldTypeString", "alias": "發文單位/來源", "length": 255, "domain": null }, { "name": "related_url", "type": "esriFieldTypeString", "alias": "相關連結", "length": 2000, "domain": null }, { "name": "is_important", "type": "esriFieldTypeSmallInteger", "alias": "是否為重要消息", "domain": { "type": "codedValue", "name": "yes_no", "description": "是否", "codedValues": [ { "name": "是", "code": 1 }, { "name": "否", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "is_approval", "type": "esriFieldTypeSmallInteger", "alias": "是否為審議通過", "domain": { "type": "codedValue", "name": "yes_no", "description": "是否", "codedValues": [ { "name": "是", "code": 1 }, { "name": "否", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "is_public", "type": "esriFieldTypeSmallInteger", "alias": "是否向民眾公開", "domain": { "type": "codedValue", "name": "yes_no", "description": "是否", "codedValues": [ { "name": "是", "code": 1 }, { "name": "否", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "assigned_to_user_id", "type": "esriFieldTypeGUID", "alias": "指派給 (承辦人)", "length": 38, "domain": null }, { "name": "is_completed", "type": "esriFieldTypeSmallInteger", "alias": "是否已辦結", "domain": { "type": "codedValue", "name": "yes_no", "description": "是否", "codedValues": [ { "name": "是", "code": 1 }, { "name": "否", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_by", "type": "esriFieldTypeGUID", "alias": "新增者", "length": 38, "domain": null }, { "name": "created_at", "type": "esriFieldTypeDate", "alias": "建立時間", "length": 8, "domain": null }, { "name": "document_number", "type": "esriFieldTypeString", "alias": "相關文號", "length": 255, "domain": null }, { "name": "is_deleted", "type": "esriFieldTypeSmallInteger", "alias": "是否已刪除", "domain": { "type": "codedValue", "name": "yes_no", "description": "是否", "codedValues": [ { "name": "是", "code": 1 }, { "name": "否", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "source", "type": "esriFieldTypeSmallInteger", "alias": "來源", "domain": { "type": "codedValue", "name": "source", "description": "來源", "codedValues": [ { "name": "系統自動產生", "code": 0 }, { "name": "手動新增", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R32_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_32", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_434_related_", "fields": "related_meeting_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_434_case_num", "fields": "case_number", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "DBO.committee_meetings", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "related_meeting_id", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{1E727D14-EFC2-4C0A-9F21-575FE3997C2C}" }, { "id": 0, "name": "DBO.urban_planning_cases", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "case_number", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{161FD8A4-A193-462E-A6B3-C069A6F91F0D}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "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": "92522d9aa9cc44c49cc76a2b518843e0" }