Subscribe to this thread
Home - General / All posts - Looking best workflow or solution for Manifold 8 or Radian Studio
CuDomagoj64 post(s)
#07-Sep-17 11:15

I'm looking for the best solution and workflow for Manifold 8 or Radian Studio!

.

I have about 6000 polygons which representing building zones. Also have all the buildings by their type of building. There are 85 different types of buildings. (See picture).

As a result I need to get a table where I will have summation data by polygons zone about:

- number of objects of a certain type

- total area of ​​these objects

- total area of ​​all objects

-calc (area of ​​the zone / total area of ​​all objects).

In addition to this information, I need data on the percentage of a certain type of objects in the total number of objects per that zone, and the share of the sum of the surface of a certain type of object in the total area of ​​all objects in that zone).

Which is the best scenario?

Is it possible to write a script for Manifold 8 or Radian?

Is there anything that already exists?

The data I'm talking about are in SHP files.

Attachments:
Zone01.png

adamw


7,215 post(s)
#10-Sep-17 08:05

All of the above is easily done with queries, either in Manifold 8 or in Radian.

Ie, number of objects of a certain type is just:

--SQL

SELECT type, Count(*) FROM buildings GROUP BY (type)

Applying "but I want to know the number of objects of a certain type not just in general, but for each polygon" adds a second table and some conditions, possibly written as a join. Ie:

--SQL

SELECT zones.name, buildings.type, Count(buildings.ID)

FROM buildings INNER JOIN zones ON Touches(zones.ID, buildings.ID)

GROUP BY zones.name, buildings.type

(The above queries are for Manifold 8, but only because I could make them more likely to work on random data by referring to the ID field. Queries for Radian are very similar.)

Have you used SQL before? If so, just dive right in, launch Radian, import / link your data, then open a command window and start writing queries, you are going to feel at home. If not, here is the starter help topic for Radian: Basics - Queries. There are plenty of resources teaching SQL on the web, and there is some initial time investment, but (a) it isn't big, what you are asking to do is pretty basic and does not go into the complex areas of SQL, and (b) it is very worthwhile, SQL is a very powerful tool used everywhere, not just in Manifold / Radian.

If you have issues figuring out how to compute anything specific, post an example file and the queries you tried and someone will help you.

You can also do the above using scripts, but SQL is simply easier, it has been designed to do what you are asking for.

CuDomagoj64 post(s)
#13-Sep-17 14:33

Thanks a lot!

Manifold User Community Use Agreement Copyright (C) 2007-2017 Manifold Software Limited. All rights reserved.