Hello Pat, and thanks for your reply,
Here are some answers to your questions:
Tell us more about exactly what you want to do…
I am drawing Room Polygons on Floor Plans in Vectorworks to seed Emergency Response Indoor Mapping and Tracking web apps.
I am using Safe Software FME to transform and translate Vectorworks building models to various formats such as:
Apple Indoor Mapping Data Format (IMSD)
Google Maps JavaScript API & KML
Esri ArcGIS Indoors
SVG (Scalable Vector Graphics)
OGC IndoorGML
Selected objects or all polys?
Multiple polygons are created on Layers for Rooms, MEP Equipment Footprints, and POIs (Points of Interest).
Layers of these polygons need to be described in plain text coordinates relative to a given x,y origin and scale, to facilitate translation to other formats.
One long text string for multiple objects or a separate row for each object?
Each polygon is identified with a unique ID (name) and attributed with User Parameters such as Room Name, and Space Category through a Record Resource. Other parameters are functions such as Area, and Perimeter.
There is no built-in function to retrieve the individual point coordinates of the vertices.
So for each Polygon in the worksheet, there would be a space or comma delimited string of these coordinate pairs.
Typical floor can contain 20 to 200 rooms.
What do you expect the maximum number of vertices to be?
50 to 100
What are you going to do with the data after you get it into the worksheet?
The data export from the worksheet will feed a FileMaker application to “data model” the building, along with the Vectorworks CAD model.
Is there a different form that would be better than the worksheet?
No
See attached
Sample file available upon request
HelloPat.pdf