Name: 都市計畫案件動態

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 92522d9aa9cc44c49cc76a2b518843e0

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• case_number ( type: esriFieldTypeString, alias: 都計案件編號, length: 255 )
• update_type_id ( type: esriFieldTypeSmallInteger, alias: 更新類別 , Coded Values: [999: 一般消息] , [9: 計畫圖發布] , [8: 計畫書發布] , ...7 more... )
• related_meeting_id ( type: esriFieldTypeGUID, alias: 會議ID, length: 38 )
• parent_update_id ( type: esriFieldTypeGUID, alias: 母動態ID, length: 38 )
• start_date ( type: esriFieldTypeDate, alias: 事件起日, length: 8 )
• end_date ( type: esriFieldTypeDate, alias: 事件訖日, length: 8 )
• title ( type: esriFieldTypeString, alias: 標題, length: 2000 )
• content ( type: esriFieldTypeString, alias: 內容(辦理情形), length: 2000 )
• author_name ( type: esriFieldTypeString, alias: 發文單位/來源, length: 255 )
• related_url ( type: esriFieldTypeString, alias: 相關連結, length: 2000 )
• is_important ( type: esriFieldTypeSmallInteger, alias: 是否為重要消息 , Coded Values: [1: 是] , [0: 否] )
• is_approval ( type: esriFieldTypeSmallInteger, alias: 是否為審議通過 , Coded Values: [1: 是] , [0: 否] )
• is_public ( type: esriFieldTypeSmallInteger, alias: 是否向民眾公開 , Coded Values: [1: 是] , [0: 否] )
• assigned_to_user_id ( type: esriFieldTypeGUID, alias: 指派給 (承辦人), length: 38 )
• is_completed ( type: esriFieldTypeSmallInteger, alias: 是否已辦結 , Coded Values: [1: 是] , [0: 否] )
• created_by ( type: esriFieldTypeGUID, alias: 新增者, length: 38 )
• created_at ( type: esriFieldTypeDate, alias: 建立時間, length: 8 )
• document_number ( type: esriFieldTypeString, alias: 相關文號, length: 255 )
• is_deleted ( type: esriFieldTypeSmallInteger, alias: 是否已刪除 , Coded Values: [1: 是] , [0: 否] )
• source ( type: esriFieldTypeSmallInteger, alias: 來源 , Coded Values: [0: 系統自動產生] , [1: 手動新增] )

Relationships:

• DBO.committee_meetings (3) -- Related To: 委員會會議記錄 (1)
• DBO.urban_planning_cases (0) -- Related To: 都市計畫案件 (6)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata