CAD注釈で方位角と距離を分ける方法

MatthewUpchurch

<\/HEAD>

以下に示すCAD情報を分離する賢い方法を考えています。距離と方位角は同じレイヤー内にあり、ほぼ同一の属性を持っています。CAD注釈をジオデータベースに変換する際に、不要な方位角の注釈を手動で一つずつ削除する手間を省くために、これらを分ける方法を模索しています。例については下記のイラストをご覧ください。使用環境はArcMap 10.2.2、64ビットWindows 7 SP1マシン、SQL-serverです。どんなご提案でも歓迎します！<\/P>

<\/P>

<\/P>

<\/P>

<\/P><\/BODY><\/HTML>

BrianOevermann

If all of your bearings are formatted as quadrant bearing with an "N" or "S" as the first character, why not use a string function as part of your query? You can query the first character of the field and if it contains an "N" or "S" then put it in the selected set. Invert the selected set for the distances.

Your 'Select by attributes' query would look something like:

SUBSTRING( Text,1,1) = 'N'      (or maybe you need/want to use RefName...)

This is basically "select out of this field, starting at character x, the next y characters")

Use the OR connector to build the query out to include the "S" bearings.