06-15-2017 12:17 AM - edited 06-15-2017 12:17 AM
Dear All
I need some advice.
Let me know asap if this is even possible in GM2016!
Kind regards
Phil
Solved! Go to Solution.
06-15-2017 03:41 PM
Hi Phil
It should be possible to generate the grid: Fill a data table with the grid elements/ centerpoint of the rectangles (should be easy with a table calculation like excel). Use functional attributes to build the rectangle geometries (construct the vertices of the rectangle geometrie with four shifts of the centerpoint).
What you can do with spatial query depends on the data. Your question/example is not very concret regarding the data model. Your first output example looks like the result of an aggregation query, the second output like a "normal" spatial query (operator overlaps or something like that).
Best regards,
hesrah
06-16-2017 04:40 AM - edited 06-16-2017 04:40 AM
Hi hesrah
Thank you for your answer.
Reading the first part, I have no clue what you mean.
The second part I fully understand.
Regarding the first part, is it possible to send me a dummy / demo excel file so I can load it into GM? Btw, how do I load an excel file?
At the end I only need a spatial grid in which I can perform queries…
Kind regards
Phil
06-17-2017 03:25 AM
Hi Phil
The Excel list looks like (3x3 grid, victive coordinates):
row line x y
1 1 235000 756000
1 2 235000 756100
1 3 235000 756200
2 1 235100 756000
2 2 235100 756100
2 3 235100 756200
3 1 235200 756000
3 2 235200 756100
3 3 235200 756200
Should be easy to generate with Excel expressions.
To load an Excel file in GeoMedia, you need a read-write connection. In the dialog feature class definition there is a function to attach Ecxel (office 97) data.
Or you copy the Excel data in a new database table, it's easy done with copy-paste.
Now you can geocode the grid points. And use a functional attribute to create the rectangle to each geocoded point geometry
The funtional attribute expression looks like
CREATEPOLYGON(MOVE(Input.GeocodedPointGeometry;-50;-50;0;ProjectedMeas);MOVE(Input.GeocodedPointGeometry;50;-50;0;ProjectedMeas);MOVE(Input.GeocodedPointGeometry;50;50;0;ProjectedMeas);MOVE(Input.GeocodedPointGeometry;-50;50;0;ProjectedMeas))
Of course the parameters vary depending to your desired settings.
Best regards,
hesrah
06-19-2017 05:10 AM
Hi,
What is your goal?
1- Is it a dynamic query? For example, you select a block number (B8) for example, and you get different lists of features (building, trees, ...). In this case, you can use a method described by hesrah
2- You need a static result, with the block identifier for each feature (like an index on a city map). In this case, you can use the layout window, create a map, insert an index grid (A,B, ... / 1,2,...) on your map, and generate an index on your features