topic Joined reporting for features from different layers in ArcGIS CityEngine Questions

Joined reporting for features from different layers

PetrBocharnikov — Fri, 19 Sep 2014 15:59:47 GMT

Hello!

I am wondering, what is the best way to join reports for several shape layers? In my project, I have existing buildings (white), which are extruded from footprints shapes; new buildings (yellow), which are created from blocks of street network layer; and an underground parking (blue), which is extruded from a shape in another layer. How can I can report their attributes together - shall I create a forth layer to which I pass on the attributes of these three layers?

My general goal is to implement an interactive editing of new building volumes through the editing of street network. As a part of that, I would like to have the floor areas of existing buildings, new buildings and garage to appear together in the report panel. So that they could be assessed together.

Re: Joined reporting for features from different layers

Anonymous User — Fri, 19 Sep 2014 16:47:40 GMT

All you need to do is name the reports with the same name, and those reports will be summed for all selected items...

So in the rules for the yellow, white, and blue shapes, you might have a reporting rule for each building. Sample CGA code:

YourBuilding -->

# Some code here resulting in a building and the values below.

ReportMetrics("GFA", 16000, "East123","Tower01")

ReportMetrics("UnitCount", 20, "East123","Tower01")

ReportMetrics(key, value, siteID, buildingID) -->

report("Total_" + key, value)

report("Site_" + siteID + "_" + key, value)

report("Building_" + buildingID + "_" + key, value)

NIL

The Reports view would have GFA and UnitCount entries, summed for the Total, for each Site, and for each Building.

Total_GFA 1200000

Total_UnitCount 400

Site_East123_GFA 22000

Site_East123_UnitCount 210

Building_Tower01_ GFA 16000

Building_Tower02_ GFA 17000

Building_Tower03_ GFA 16000

Building_Tower04_ GFA 18000

Hope this explanation is clear. Yes?

Chris

Re: Joined reporting for features from different layers

PetrBocharnikov — Fri, 19 Sep 2014 17:04:34 GMT

Looks neat and easy. I will get a chance to run it on CE after the weekend. I will get back to you on that.

Re: Joined reporting for features from different layers

Anonymous User — Fri, 19 Sep 2014 17:07:51 GMT

This is kind of the reverse of having buildings sample a larger polygon. Since you can't sample from the large polygon and find each building upon it, this is another way.

The prefixes are what makes everything group together:

Total_

Site_siteName_

Building_buildingName_

Re: Joined reporting for features from different layers

MatthiasBuehler — Sat, 20 Sep 2014 10:18:14 GMT

Well explained .. you like that one, huh ?

Matthias Buehler

Head of 3D Technologies

twitter: @MattB3D

--------------------------------

Garsdale Design Limited
matthias.buehler@garsdaledesign.co.uk

www.garsdaledesign.co.uk

Re: Joined reporting for features from different layers

Anonymous User — Sat, 20 Sep 2014 14:23:32 GMT

You probably taught it to me.

Sent from my iPhone

Re: Joined reporting for features from different layers

AlanKlys — Thu, 26 Feb 2015 13:09:14 GMT

This summation of totals during reporting is very handy indeed. Thanks a lot for the tip!

Is there a way to set an attribute to one of these totals tho ? Nothing I've tried seems to work.

Re: Joined reporting for features from different layers

Anonymous User — Fri, 27 Feb 2015 17:11:51 GMT

Yes, that is possible. You have to use the Python scripted reports for that. In that case you get the reports from each model and then change the object attributes of the models, and connect your rule attributes to the object attributes. From Python.

Chris

Re: Joined reporting for features from different layers

AlanKlys — Tue, 03 Mar 2015 03:08:48 GMT

Thanks again Chris,

I've found bits and pieces on this in the manual and in the tutorials, just trying to wrap my head around how to actually do this. Wish there were a few more Python examples floating around.

As per your above example, is there a way to accomplish something like this ... as in set a float value to one of these summed up reports ?

report("Total_" + key, value)

set (T_Total,(+ key, value))

Re: Joined reporting for features from different layers

Anonymous User — Tue, 03 Mar 2015 17:09:21 GMT

I have an example somewhere, but everything is in disarray on my machine. I've made myself a note to find it. If I don't reply within the next week, then leave a comment here again to prompt me.

Re: Joined reporting for features from different layers

AlanKlys — Tue, 03 Mar 2015 22:47:04 GMT

That would be great thanks a lot Chris

Re: Joined reporting for features from different layers

PetrBocharnikov — Tue, 31 Mar 2015 12:00:24 GMT

Chris Wilkins,

Good six months later, I have implemented your suggestion. It works nicely! Thank you.

Now I would like to develop this a little further, while keeping the aggregation into "Total_" and "Site_". Summing up the totals works well for GFA, but I don't think it works for FAR. I wouldn't want the sum of FAR values or the average of them. Instead, I want to take the sum of GFA and divide it by the sum of site areas. Any thoughts on how I can implement that?

If I can make Alan Klys's suggestion to set a float value to work that could be a solution. I could set values for Total_GFA, Site_GFA, Total_PlotArea, Site_PlotArea, and then report Total_FAR as Total_GFA/Total_PlotArea and Site_FAR as Site_GFA/Site_PlotArea.

Re: Joined reporting for features from different layers

AlanKlys — Thu, 02 Apr 2015 07:07:50 GMT

If my suggestion worked...

report("Total_" + key, value)

set (T_Total,(+ key, value))

...then I guess you could accomplish what you want Petr, but alas I don't think it's possible. Seems like Python is the way to go in this case ... and a timely way to bump this for Chris

Re: Joined reporting for features from different layers

Anonymous User — Thu, 02 Apr 2015 14:16:22 GMT

Thanks for the bump. I'm currently in the middle of a major cleanup/organization of ALL of the rules and scripts I've written for CityEngine. This will be going on for the next few weeks. Since you bumped me, I'm now putting a yellow sticky note on the wall in from of me. In the meantime you could try the Python documentation in the CityEngine manual... wink!

Chris

Re: Joined reporting for features from different layers

AlanKlys — Thu, 02 Apr 2015 23:06:06 GMT

Muchos gracias amigo I wonder what gems you'll find ?

Re: Joined reporting for features from different layers

Anonymous User — Mon, 06 Apr 2015 16:05:23 GMT

Here's one - Pergola.cga - it makes a pergola. If you make it small, it could be an arbor. Columns are not included. Someone should add columns to the rule. There are three layers of wood/material. I think I've just colored it. I'd make the columns be attached to the largest members on the bottom. -Chris

Re: Joined reporting for features from different layers

Anonymous User — Thu, 16 Apr 2015 18:18:27 GMT

Petr and Alan,

I've got some scripts gathered now. Let me get this right before I start.

Petr said, "I want to take the sum of GFA and divide it by the sum of site areas. Any thoughts on how I can implement that?" So for each site, you have a site area (like a parcel or lot), and there is a building on the site that has a GFA. To keep it easy, we'll suppose the building is generated on the parcel shape from a rule applied to the parcel. For each site and building we report:

report("SiteArea", siteArea)

report("GFA", gfa)

Then you wanted to add those two totals for every parcel/building that is reporting these, and then set an object attribute on those shapes, so that the rules have access to the average FAR of all of them?

Is that right? If so, I'll try and set up an example of this.

Thanks!

Chris

Re: Joined reporting for features from different layers

PetrBocharnikov — Thu, 16 Apr 2015 19:50:42 GMT

Hi Chris,

Thank you for coming back on this!

Yes, your premise about a building on a site is correct. With your initial answer, I am able to report something like this:

Total_GFA xxx

Total_SiteArea xxx

Site_East123_GFA xxx

Site_East123_SiteArea xxx

But, I think, FAR requires a little different treatment: summarising FAR values for all parcels doesn't make sense. Instead, I need to take at the very end Total_GFA and divide it by Total_SiteArea, and the same for Site_East123_GFA and Site_East123_SiteArea.

Do you follow?

Re: Joined reporting for features from different layers

Anonymous User — Thu, 16 Apr 2015 21:59:33 GMT

Alan, Petr,

As promised, here is a script that finds the average FAR. You must select all objects for the calculation, since this uses the "python-based export" feature in CityEngine.

Find attached zipped CityEngine project. It is set up so you can just select all items and then run the script. The math can be double checked by manually calculating the average FAR using the reported values.

Also, there are a million print() statements from where I was debugging.

Try it out and let me know if you have questions.

Chris

Re: Joined reporting for features from different layers

AlanKlys — Thu, 16 Apr 2015 23:45:06 GMT

Thanks a whole bunch Chris Having a peek at this now.