Boundary XY to Excel
បំបែកព្រំដែនពហុកោណជាជួរដេកមួយក្នុងមួយកូអរដោនេកំពូល រួចបើកលទ្ធផលភ្លាមក្នុង Microsoft Excel ជា CSV ឬ XLSX។
- រកឃើញនៅឯណា
- KGA Toolbox ▸ Data Management ▸ Attribute ▸ Boundary XY to Excel
ទិដ្ឋភាពទូទៅ
Where Coordinate Listing writes a file you then go and find, this tool hands the coordinates straight to Excel — the fastest route from a parcel on screen to a coordinate table you can work on.
ការប្រើប្រាស់
- Anchor field is required. It is the identifier copied onto every vertex row, and it is what lets the rows be grouped back into parcels. It is always included in the output, whatever else you select.
- Attribute inclusion is controlled in two steps: Attribute Inclusion sets the broad policy, and Custom Field Selection picks individual fields when you want a specific subset.
- Coordinate Options hold the choices that matter for how the table reads:
| Option | Effect |
|---|---|
| Decimal precision | Decimal places written for each coordinate |
| Repeat first vertex as last row (close ring) | Writes the start vertex again at the end, so the ring closes explicitly |
| Remove duplicate consecutive vertices | Drops repeated points |
| Include Vertex Sequence column | Numbers the vertices in traversal order |
| Include interior rings (holes) | Includes the vertices of holes as well as the outer boundary |
| Include centroid coordinate per feature | Adds the parcel centroid |
| Include ring direction (CW / CCW) column | Records whether each ring is clockwise or anticlockwise |
- Repeat first vertex as last row is a format decision, not a cosmetic one. A survey table that must close explicitly needs it; one that will be re-imported to rebuild the polygon usually should not have it, since the duplicate row creates a repeated vertex.
- Include ring direction is a diagnostic worth using on suspect data. Ring direction encodes whether a ring is an outer boundary or a hole; an unexpected direction points to a geometry problem.
- Include interior rings (holes) must be checked for parcels with internal exclusions, or the excluded areas are silently missing from the coordinate table.
- Output Format offers CSV (fastest) or XLSX (better formatting). Choose CSV for a large layer or for onward import; XLSX when the table is the deliverable.
- Microsoft Excel must be installed for the file to open automatically.
ប៉ារ៉ាម៉ែត្រ
| ផ្ទាំងគ្រប់គ្រង | ការពិពណ៌នា |
|---|---|
| Anchor field | Required. The identifier copied onto every vertex row. Always included in the output. |
| Attribute Inclusion | The policy for which attribute fields are carried into the output. |
| Custom Field Selection | Individual fields to include. The anchor field is included automatically. |
| Decimal precision | The number of decimal places written for each coordinate. |
| Repeat first vertex as last row (close ring) | Writes the start vertex again at the end of each ring. |
| Remove duplicate consecutive vertices | Drops repeated consecutive points. |
| Include Vertex Sequence column | Adds a column numbering the vertices in traversal order. |
| Include interior rings (holes) | Includes hole vertices as well as the outer boundary. |
| Include centroid coordinate per feature | Adds the centroid coordinate for each feature. |
| Include ring direction (CW / CCW) column | Records each ring's direction — a useful geometry diagnostic. |
| CSV (fastest) / XLSX (better formatting) | The output format. |
| OK | Generates the table and opens it in Excel. |
របៀបប្រើ
- Select the polygon layer in the Contents pane. To export a subset, select those features on the map first.
- On the KGA Toolbox tab, in the Data Management group, open the Attribute menu and click Boundary XY to Excel.
- Set Anchor field to the parcel number or other identifier.
- Set the attribute inclusion policy, and pick specific fields in Custom Field Selection if needed.
- Under Coordinate Options, set Decimal precision to match the survey's real precision.
- Check Include Vertex Sequence column so the traversal order is explicit.
- Check Include interior rings (holes) if any parcel has an internal exclusion.
- Check Repeat first vertex as last row only if the table format requires an explicit closing row.
- Choose CSV for a large layer or XLSX for a deliverable, then click OK. Excel opens with the result.
ព័ត៌មានអាជ្ញាបណ្ណ
Requires an active KGA Toolbox license. The tool validates the license before running.