{"id":974,"date":"2009-09-24T13:54:28","date_gmt":"2009-09-24T13:54:28","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=974"},"modified":"2017-02-06T14:33:07","modified_gmt":"2017-02-06T05:33:07","slug":"arcobjects-%ec%86%8d%ec%84%b1%ea%b0%92%ec%9c%bc%eb%a1%9c-%ec%bf%bc%eb%a6%acquery%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=974","title":{"rendered":"[GIS] ArcObjects, \uc18d\uc131\uac12\uc73c\ub85c \ucffc\ub9ac(Query)\ud558\uae30"},"content":{"rendered":"<p>GIS\uc758 \uac15\ub825\ud55c \uae30\ub2a5 \uc911\uc5d0 \ud558\ub098\ub294 \uc18d\uc131 \ub370\uc774\ud130\uc5d0 \uae30\ubc18\ud55c \uacf5\uac04\uc801\uc778 \ucc98\ub9ac \ubc0f \uac00\uc2dc\ud654\uc778\ub370, \uc774 \uae00\uc740 ArcObjects\uc5d0\uc11c \uc18d\uc131\uac12 \uc870\uac74\uc5d0 \ub300\ud574 \ucffc\ub9ac(Query)\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc77c\ub2e8&#8230;. \uc18d\uc131\uac12\uc5d0 \ub300\ud55c \ucffc\ub9ac\uac00 \ubaa9\uc801\uc774\ubbc0\ub85c \uba3c\uc800 \uc18d\uc131\uac12\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub294 ITable \uc778\ud130\ud398\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 d:\\__data__ \ud3f4\ub354 \uc548\uc758 seoul.dbf \ud30c\uc77c\ub85c\ubd80\ud130 ITable \uc778\ud130\ud398\uc774\uc2a4\uc758 \uad6c\uccb4 \ud074\ub798\uc2a4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc5bb\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nESRI.ArcGIS.Geodatabase.IWorkspaceFactory pWF;\r\nESRI.ArcGIS.Geodatabase.IFeatureWorkspace pFW;\r\n\r\npWF = new ESRI.ArcGIS.DataSourcesFile.ShapefileWorkspaceFactory();\r\npFW = pWF.OpenFromFile(\"d:\/__data__\", 0) \r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 as ESRI.ArcGIS.Geodatabase.IFeatureWorkspace;\r\n\r\nESRI.ArcGIS.Geodatabase.ITable pTable;\r\npTable = pFW.OpenTable(\"seoul\");<\/pre>\n<p>ITable\uc758 \uad6c\uccb4 \ud074\ub798\uc2a4\uc758 \uc778\uc2a4\ud134\uc2a4\uc778 pTable\uc740 \uc18d\uc131\uac12\uc73c\ub85c \uac80\uc0c9\ud560 \uc218 \uc788\ub294 \ub9e4\uc11c\ub4dc\uc778 Search \ud568\uc218\ub97c \uac00\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 Search \ud568\uc218\ub294 \ub450\uac1c\uc758 \uc778\uc218\ub97c \uac00\uc9c0\uba70 \uccab\ubc88\uc9f8 \uc778\uc218\uc758 \ud0c0\uc785\uc740 IQueryFilter\ub85c\uc368 SQL \ubb38\uc758 WHERE \uc808\uc758 \uc870\uac74\ubb38\uc744 \uc9c0\uc815\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub450\ubc88\uc9f8 \uc778\uc218\ub294 \uac80\uc0c9 \uacb0\uacfc\uc5d0 \ub300\ud55c Row\uc5d0 \ub300\ud55c \uc7ac\ud65c\uc6a9 \uc5ec\ubd80\uc5d0 \ub300\ud55c bool \ud615\uc785\ub2c8\ub2e4. \uc774\uc5d0 \ub300\ud574\uc11c\ub294 \uc774 \uae00\uc758 \ub9c8\uc9c0\ub9c9\uc5d0 \uac04\ub2e8\ud788 \ub2e4\uc2dc \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc18d\uc131\uac12\uc73c\ub85c \ucffc\ub9ac\ud558\uae30 \uc704\ud558\uc5ec \uc870\uac74\ubb38\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c&#8230; \uba3c\uc800 \uc55e\uc758 \ucf54\ub4dc\ub97c \ud1b5\ud574 \uc624\ud508\ud55c seoul.dbf \ud30c\uc77c\uc758 \ud544\ub4dc \uad6c\uc870\ub97c \uc54c \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ud78c\ud2b8\ub97c \uc900\ub2e4\uba74 seoul.dbf\uc758 \uc18d\uc131 \uc911\uc758 \ud558\ub098\ub294 SGG_NM\uc73c\ub85c\uc368 \uc11c\uc6b8\uc2dc\ub97c \uad6c\uc131\ud558\ub294 \ud589\uc815\uad6c\uc758 \uc774\ub984\uac12\uc774 \uc800\uc7a5\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 \ud589\uc815\uad6c \uc774\ub984\uc5d0 &#8216;\ub3d9&#8217;\uc790\uac00 \ub4e4\uc5b4\uac00\ub294 \ubaa8\ub4e0 Row\ub97c \uac80\uc0c9\ud558\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ub7f0 \uc870\uac74\uc744 \uc704\ud55c ITable\uc758 Search\uc758 \uccab\ubc88\uc9f8 \uc778\uc790\uc778 IQueryFilter\uc758 CoClass(\uad6c\uccb4 \ud074\ub798\uc2a4)\uc758 \uc815\uc758\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nESRI.ArcGIS.Geodatabase.IQueryFilter pQF;\r\npQF = new ESRI.ArcGIS.Geodatabase.QueryFilter();\r\npQF.WhereClause = \"SGG_NM LIKE '%\ub3d9%'\";<\/pre>\n<p>IQueryFilter\uc758 WhereClause \ud504\ub85c\ud37c\ud2f0\uac00 \ubc14\ub85c &#8216;\uadf8\uac83&#8217;\uc778\ub370.. \uc77c\ubc18\uc801\uc778 SQL\uc758 SELECT \ubb38\uc758 WHERE \uc808\uc758 \ubc14\ub85c \uc815\ud655\ud788 &#8216;\uadf8\uac83&#8217;\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. SQL\ubb38\uc758 SELECT\ubb38\uc744 \uc54c\uace0 \uc788\ub294 \uac1c\ubc1c\uc790\ub77c\uba74 \uc544~!\ub77c\ub294 \ud0c4\uc2dd\uc774 \ub098\uc62c\uc815\ub3c4\ub85c ArcObjects\ub294 \uc18d\uc131\uac12\uc73c\ub85c \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\ub294 \ud0c1\uc6d4\ud55c \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ub9cc\ub4e0 IQueryFilter\ub97c \uc774\uc6a9\ud558\uc5ec \ucffc\ub9ac\ud558\ub294 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nESRI.ArcGIS.Geodatabase.IFeatureCursor pFC;\r\npFC = pTable.Search(pQF, true) as ESRI.ArcGIS.Geodatabase.IFeatureCursor;<\/pre>\n<p>ITable\uc758 Search \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba70 \uac80\uc0c9 \uacb0\uacfc Row\ub294 IFeatureCursor \ud0c0\uc785\uc73c\ub85c \ubc18\ud658\ub429\ub2c8\ub2e4. \uac80\uc0c9 \uc870\uac74\uacfc \uc77c\uce58\ud558\ub294 Row\ub97c \uc5bb\uae30 \uc704\ud574 IFeatureCursor \ud0c0\uc785\uc758 \uc778\uc2a4\ud134\uc2a4 \ubcc0\uc218\uc778 pFC\ub97c \uc0ac\uc6a9\ud558\ub294\ub370.. \uc544\ub798\uc758 \ucf54\ub4dc\uac00 \ubc14\ub85c \uadf8\uac83\uc774\uba70, listBox1 \uc774\ub984\uc758 ListBox \ucee8\ud2b8\ub864\uc5d0 \uadf8 \uacb0\uacfc\ub97c \ucc44\uc6c1\ub2c8\ub2e4.<\/p>\n<pre>\r\nESRI.ArcGIS.Geodatabase.IFeature pFeature;\r\nint cntFields = pFC.Fields.FieldCount;\r\n\r\nlistBox1.Items.Clear();\r\npFeature = pFC.NextFeature();\r\nwhile(pFeature != null) {\r\n\u00a0 \u00a0 for(int iField=0; iField<cntFields; ++iField) {\r\n\u00a0 \u00a0 \u00a0 \u00a0 string FieldName = pFC.Fields.get_Field(iField).Name;\r\n\u00a0 \u00a0 \u00a0 \u00a0 string FieldValue = pFeature.get_Value(iField).ToString();\r\n\u00a0 \u00a0 \u00a0 \u00a0 listBox1.Items.Add(FieldName + \": \" + FieldValue);\r\n\u00a0 \u00a0 }\r\n\u00a0 \u00a0 \r\n\u00a0 \u00a0 listBox1.Items.Add(\"\");\r\n\u00a0 \u00a0 pFeature = pFC.NextFeature();\r\n}<\/pre>\n<p>5\ubc88\uc9f8 \ucf54\ub4dc\uc5d0\uc11c \uac00\uc7a5 \uba3c\uc800 IFeatureClass\uc758 NextFeature \ub9e4\uc11c\ub4dc\ub97c \ud638\ucd9c\ud558\uc5ec \uccab\ubc88\uc9f8 \uac80\uc0c9 \uacb0\uacfc\uc758 Row\uc5d0 \ud574\ub2f9\ub418\ub294 IFeature \ud074\ub798\uc2a4 \ud0c0\uc785\uc758 \uc778\uc2a4\ud134\uc2a4\ub97c \ubc18\ud658\ubc1b\uace0 \uccab\ubc88\uc9f8 Row\uc5d0 \ub300\ud55c \uac12\uc744 \uc5bb\uae30 \uc704\ud558\uc5ec IFeature\uc758 get_Value \ub9e4\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac12\uc744 \uc5bb\uc2b5\ub2c8\ub2e4. \uadf8 \ub2e4\uc74c \uacb0\uacfc Row\ub97c \uc5bb\uae30 \uc704\ud558\uc5ec \ub2e4\uc2dc NextFeature\ub97c \ud638\ucd9c\ud569\ub2c8\ub2e4. NextFeature\uc758 \ubc18\ud658\uac12\uc774 null\uc774\uba74 \ub354 \uc774\uc0c1 \uc870\uac74\uc5d0 \ub9de\ub294 Row\uac00 \uc5c6\ub2e4\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4. \uc2e4\ud589 \uacb0\uacfc\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uac15\ub3d9\uad6c, \uc131\ub3d9\uad6c, \ub3d9\uc791\uad6c, \ub3d9\ub300\ubb38\uad6c\uc640 \uac19\uc774 '\ub3d9'\uc790\uac00 \ub4e4\uc5b4\uac04 \ub370\uc774\ud130\ub9cc\uc774 \uac80\uc0c9\ub41c \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1284965324.jpg\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"250\" height=\"278\" \/><br \/>\n\ub05d\uc73c\ub85c \uc55e\uc11c \uc5b8\uae09\ud55c... \uc774 \uae00\uc758 \ud575\uc2ec \ub9e4\uc11c\ub4dc\uc778 ITable\uc758 Search \ub9e4\uc11c\ub4dc\uc758 \ub450\ubc88\uc9f8 \uc778\uc790\uc758 \uc758\ubbf8\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud558\uba74... \ub9cc\uc57d true\ub77c\uba74 IFeatureClass\uc758 NextFeature\uc758 \uacb0\uacfc\uc5d0 \ub300\ud55c \uc778\uc2a4\ud134\uc2a4\ub97c \uc7ac\ud65c\uc6a9\ud55c\ub2e4\ub294 \uc758\ubbf8\uc774\uba70 false\uc774\uba74 \uc7ac\ud65c\uc6a9\ud558\uc9c0 \uc54a\uace0 NextFeature\ub97c \ud638\ucd9c\ud560\ub54c \ub9c8\ub2e4 \uc0c8\ub85c\uc6b4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4. \uc774\ub97c \ubaa9\uc801\uc5d0 \ub300\ud574 \uc0dd\uac01\ud574\ubcf4\uba74 true\uc774\uba74 Feature\ub97c \uc77d\uae30 \uc804\uc6a9\uc73c\ub85c\ub9cc \uc0ac\uc6a9\ud574\uc57c \ud558\uba70 false\uc77c \uacbd\uc6b0 IFeature\ub97c \ud1b5\ud574 \uc18d\uc131\uac12\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>GIS\uc758 \uac15\ub825\ud55c \uae30\ub2a5 \uc911\uc5d0 \ud558\ub098\ub294 \uc18d\uc131 \ub370\uc774\ud130\uc5d0 \uae30\ubc18\ud55c \uacf5\uac04\uc801\uc778 \ucc98\ub9ac \ubc0f \uac00\uc2dc\ud654\uc778\ub370, \uc774 \uae00\uc740 ArcObjects\uc5d0\uc11c \uc18d\uc131\uac12 \uc870\uac74\uc5d0 \ub300\ud574 \ucffc\ub9ac(Query)\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc77c\ub2e8&#8230;. \uc18d\uc131\uac12\uc5d0 \ub300\ud55c \ucffc\ub9ac\uac00 \ubaa9\uc801\uc774\ubbc0\ub85c \uba3c\uc800 \uc18d\uc131\uac12\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub294 ITable \uc778\ud130\ud398\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 d:\\__data__ \ud3f4\ub354 \uc548\uc758 seoul.dbf \ud30c\uc77c\ub85c\ubd80\ud130 ITable \uc778\ud130\ud398\uc774\uc2a4\uc758 \uad6c\uccb4 \ud074\ub798\uc2a4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc5bb\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4. ESRI.ArcGIS.Geodatabase.IWorkspaceFactory pWF; ESRI.ArcGIS.Geodatabase.IFeatureWorkspace pFW; pWF &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=974\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[GIS] ArcObjects, \uc18d\uc131\uac12\uc73c\ub85c \ucffc\ub9ac(Query)\ud558\uae30&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[31,48,5],"class_list":["post-974","post","type-post","status-publish","format-standard","hentry","category-arcobjects","tag-arcgis","tag-arcobjects","tag-gis"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=974"}],"version-history":[{"count":2,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/974\/revisions"}],"predecessor-version":[{"id":4416,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/974\/revisions\/4416"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=974"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}