nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Joined reporting for features from different layers

PetrBocharnikov

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.

picture for geonet.png

Encontre mais publicações marcadas com

Accepted answers

Anonymous User

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

JesseWickizer_2-1778091284776.png

All comments

Anonymous User

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

JesseWickizer_2-1778091284776.png

PetrBocharnikov

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.

Anonymous User

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_

MatthiasBuehler

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

AlanKlys

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.

Anonymous User

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

AlanKlys

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))

PetrBocharnikov

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.

AlanKlys

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

Anonymous User

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

Anonymous User

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

PetrBocharnikov

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 xyz

Total_SiteArea xyz

Site_East123_GFA xyz

Site_East123_SiteArea xyz

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?

Brian_McLeer_0-1778094865326.png

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.