# 1.arcGIS- KML import as query Service操作流程

###### tags: `arcgis`,`db`

1. import initial .kml

:::info
Catalog-> kml to layer
:::

2. import this KML to DB

:::info
Catalog-> database Connections -> select connected DB -> Import -> Feature Class(single)
:::

:::info
拖曳layer到 input features -> 匯入Layer到db table
output feature class 匯入後table名稱
:::

3. db modify schema

:::info
修改schema 新增自訂欄位
:::

4. import db table as layer

SELECT *
  FROM [arcgis_demo].[dbo].[SHILIN_TABLE]
  --alter table shilin_table add city varchar(15), county varchar(15);
  update shilin_table set city= SUBSTRING(name,1,3);
  update shilin_table set county= SUBSTRING(name,4,6);

:::info
拖曳db table 到 arcMap為layer

檢驗layer包含自訂資料

:::

5. 發布service

:::info

選擇服務所在資料夾

analyze無error

publish

:::

6. 查詢service運行

:::info
範例位置: https://210.68.105.171:6443/arcgis/rest/services/Ctop/

確認有對應custom column
:::