-
Notifications
You must be signed in to change notification settings - Fork 12
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Define the land use types using the CityScope Types system #9
Comments
Hi Ronan, I have uploaded land use type code here. |
Hi @doorleyr and @dangbuingochan , I think that @markus and I will make a first pass of the correlation between NAICS and LBCS and the proposed types. We will share it ASAP |
Dear @doorleyr and @dangbuingochan , Please let me share the 1st pass through the Types document that we have made. We recommend to have a-meeting and re-visit the list together: List of landuse type name (landuse-1) R-M_L.xlsx In the document, you will find: All this types are being correlated by using the codes in the following link: Here is the table: <style> </style>
|
Hi @LAAP , thank you for your supporting. Data team will review the table quickly and set up a meeting. |
OK. Perfect. Thank you @nqlong-vlab |
Just to be clear on this at some point those land use will have to be updated in the corresponding GIS file that we already agreed together here |
This issue is now the main bottleneck towards having working CityScope model. We usually only have ~10 types for a CityScope table because any more than that makes the user experience too complicated. Many of the types in the list above are very similar and can be consolidated into one type. Also some of the types are referring to future plans (eg. Expected School) and this is a problem. These areas should simply be coded as what exists there in the scenario (this can be None if the area has no current function). |
I agree, so I will add the column as CityScope type. |
@markus and I are working on this. Tonight we will have have a very simplified version with the 14 types that ARC team has selected and correlated just with the LBCS |
From @markus: _Hello All - @LAAP Luis and I went through the Land Use and added a consolidated list to the right of the sheet (Columns U-V). Note that Mixed Use is a combination of land uses in one cell... IE if a building includes residential and retail space, that cell would include 1000, and 2000 for the uses. Also note that we had included a very good reference document on the project page under the references. Please see the following link: https://planning-org-uploaded-media.s3.amazonaws.com/legacy_resources/lbcs/background/pdf/rslucm2sic2naicsnotext.pdf_ |
Great, @nqlong-vlab please refer to the link while you create additional "City Scope Type" column for: |
Dear @Hai-Hoang-88 , After talking with Ronan, we need also to add: The Naics code(s) [Luis and Markus] We will do it As soon as possible |
Dear @Hai-Hoang-88 , Please find the update in the types, we have added to the table the The Naics code(s)and the color, as @doorleyr has suggested. The only thing missing is the The density (sqm/person) where applicable: You can find it in the link: https://docs.google.com/spreadsheets/d/19D1czN65F05iamg5kvdG9rJ46cZPvfrojBQ89XqUGrI/edit?usp=sharing Columns: U, V, W, X, and Y, rows: 2 to 16th |
The excel file has been updated, please take a look @doorleyr |
Awesome @Hai-Hoang-88 , Thanks for adding the average sqm. |
A few updates from data team is adding that 14 cityscope landtypes in shapefile for all scenarios. |
Awesome! |
Thanks, @Hai-Hoang-88 for your help in updating the information. Dear @LAAP , @doorleyr and All, after working with the Data team and Hai, I d like to revise the number and explain to you a little bit about the table above. As I mentioned on Whatsapp, the value sqm/person we have provided above is for land area. (Since we don't have a specific sqm/person for floor area ready in our planning documents. When working on urban planning, this value will be considered on a case-by-case basis, based on regulations, standards, planning on different scales, etc.). However, as far as I understand, we need both sqm/person for (1) land use and for (2) the floor area.
For that, I have updated the table with information as follow:
You may find this is in the same link as the chat above, Sheet 2: Hope that it explained. |
@TuCTruong thanks. The figure we're looking for is sqm per person per floor, assuming that the floor occupies the entire area of the grid cell. If the building footprints will occupy less than the full area, this should be factored into the density value. For example, if we have a grid cell of 50m x 50m which is assigned to 10 floors of Residential, using the figure above of 8sqm/person, we would calculate that (50x50x10/8) = 3125 people can live in this grid cell. Can you confirm that your figures are correct for this calculation or revise them if necessary? |
Apart from the density values, here still a few other issues with the CSL types which need to be addressed:
|
Hi @doorleyr , Yes then the figure in Column C will do it. I have updated the reference for the number and assumption. You may find this in the same link: https://docs.google.com/spreadsheets/d/19D1czN65F05iamg5kvdG9rJ46cZPvfrojBQ89XqUGrI/edit#gid=1172435229 |
Dear @doorleyr and @TuCTruong, Please, let me answer @doorleyr questions: 1) The CSL type names: @markus and I have adapten the definitions of our CS types to the ARC definitions, so now "Water" is the correct name for this land use. We encourage @TuCTruong and the ARC team to do the same in the geo-referenced files that are being produced for the 3 Scenarios by the ARC team 2) 'Mix-used': @markus and I have made a mixed use type with 70% of "Residential" and 30% of o "Commercial, service, office". Please, let us know if that works for you 3) Centralize attributes of the types in a CSV file: @markus and I have centralized all the attributes in this CSV file (cs_types_2.0.csv): Please, let us know if anything else is needed Un abrazo Luis |
Dear @TuCTruong, We have take the missing density of office and healthcare (in red) from the following link. It is not the most scientific link, but sometimes helps in order to have an OK place holder and move ahead. Regarding your Excel file, I have some suggestions, now that we have no scenario 1, That it was messing up everything. My recommendation is not to have different densities in each scenario: if we change the density in each scenario, then we have 14 types x by 3 scenarios = 42types. Keeping this in mind. And since we don't have any more scenario 1; I recommend that If we want to play with the densities, we should stick with the 14 types and just change the numbers of floors: |
I have questions here:
Many thanks, |
@TuCTruong Can you please remove the numbers before the names and ensure that the types names are always the exact same in terms of whitespace, punctuation etc. If there are any types which never appear in the scenarios then I think they should be removed. |
Dear @TuCTruong and @dangbuingochan, I have a question about the art of the excel where you show the 3 scenarios. I can see that the "m2" doesn't increase in scenario 2 and 3 (It si always 4178668.5 m2), even when, at this scenarios we are incrementing the density of buildings (Towers and high buildings are planned). So I suppose that you are just sowing the m2 of land, and not the "m2 constructed" (or m2 of floors in buildings. Keeping that in mind, I wonder if you could provide to me the constructed m2 per land use. That will help on the storytelling: Thank you very much in advance Un abrazo Luis |
Hi @LAAP , I and @dangbuingochan have updated this table with values from Data team. You may find the constructed area in columns J, O, R. Made it by (footprint x number of floor). Please check the same link. |
Dear @TuCTruong , |
Dear all, Since it looks like we have solved the types I am closing this issue. Please, feel free to open it again if needed |
After running some analysis of scenarios and taking a closer look at the types, there appear to be a few issues to be solved:
|
Thanks Ronan,
@Hai-Hoang-88 and team Data @nqlong-vlab might want to discuss this. From my viewpoint, since we are working with mostly the current built which might or might not be the same as planning, so most of our data are from site visits to recording the function of the building, Google, statistic report, etc. Then, if we want to give percentage for types, then team Data might need to find ref. If we add new types, team data might need to proceed the shapefile again. |
Dear @TuCTruong , @dangbuingochan, @Hai-Hoang-88, and @nqlong-vlab , I think that matching the CS types with the exact land use it will be challenging (as @TuCTruong is commenting) so we will need to be "creative", so keeping that in mind, Please, let me try to help here:
Please, let me know your thoughts |
Hi Ronan, Would you kindly advise on the steps in order to address the item 2 as raised? using an example of existing data file. From programing perspective, I wonder this assumption on percentage can be done in an automate fashion rather than manually editing the shape file. For example, within commercial or mixed-use land use categories (or types), if we want to include sub-types (food, retail), we might be able to assume randomly percentage in a range [e.g. min =1% to max of 5% for food], and [eg. min =3% to max = 10% for retail]. This is similar to performing sensitivity analysis as no one can know exact % of sub-types within main types.Mathematically, we might use the following simple model to redistribute sub-types Y(i) = SUM[X1(i)+X2(i)+...+Xn(i)] Since value of Y(i) is already given, the subtypes value can be further expressed as The constraint is p1(i)+p2(i)+....+pn(i) = 1 so first we need to know total number of subtype n. and then we randomly generate value of p1, p2, ...., to p[n-1]. we can control the random of p1 to p[n-1] based on min and max value. This is subject to expert opinion. So instead of asking experts on exact value of p, we ask the min and max, the the rest will be automated with your program.Please note that if using this assumption, each row of database will yield different distribution of sub-types. However, for simplifying the process, we can assume that a same percentage might be assigned to rows of the same types. Pls let me know your though on this process as definitely we need you to guide us from your side when it comes to assigning the percentage to sub-type. Best that you can show on the screen in the next call the database structure and what need to be filled in [percentage] so we can further provide inputs for you to properly running the agent base simulations. Cheers, Nam - ISCM |
@namkyodai the data input we need to adapt is just a simple csv which describes each Type. We don't have a concept of sub-types- instead we describe each Type by the typical composition of land uses (LBCS) and economic activity (NAICS). The idea of stochastically assigning percentages based on a range makes sense but would require rewriting of modules and would be incompatible with other Cityscope projects. The modules expect each type to be associated with fixed proportions of LBCS and NAICS. In general the use of these types is a simplification and will not capture the real activities perfectly but it's a necessary abstraction in order to make the model understandable to non experts. |
@doorleyr, my understanding of subtypes are similar to the composition you mentioned. Agree with your point below btw, in order for you to complete that task (running the model on provided dataset), i suggest a quick call with you (assuming @TuCTruong will coordinate on this) so you can just open the excel file and explain clearly which columns and how many items in a composition under each type need to be filled in by VN team. |
Dear @TuCTruong , @dangbuingochan, @Hai-Hoang-88, and @nqlong-vlab , Do we have a first pass of the new update to the 14-18 types? As soon as you share it with me, I will translate it to NAICS and LBCS Thank you very much in advance Luis |
Dear @TuCTruong , @dangbuingochan, @Hai-Hoang-88, and @nqlong-vlab , I have made a 1st pass to the excel that you are sharing to translate it to NAICS and LBCS: |
Thanks @LAAP , @vietlq@ueh.edu.vn and I have put these into the Sheet Updated_Landtype in the same doc. https://docs.google.com/spreadsheets/d/19D1czN65F05iamg5kvdG9rJ46cZPvfrojBQ89XqUGrI/edit#gid=523130602
|
Dear @doorleyr , Since we weren't able to give enough density info. for all functions last time, that might cause you some misleading, hehe, we also added few more functions and revised them all now. So, @nngocquang.arc@gmail.com and I have made a 1st pass of the density for the Updated-Land type. We used the toolbox you provided and VN standard where applicable. Since we are modifying the land type and function, so our Data team will need to work a little bit more on the constructed area. Once we have that information, we will let you know. Meanwhile, please have a look at the link for the updated density, sheet draft_landtype. Thankss! |
Hi @doorleyr, and @TuCTruong , @dangbuingochan, @Hai-Hoang-88, and @nqlong-vlab , I just want to double check if the types and format are ready and being used. The last update from Vietnam team is a bit confusing for me. Can we translate it to a CSV file like this?: https://github.com/CityScope/CSL_HCMC/blob/main/Data/Table/cs_types.csv |
@LAAP the spreadsheet you linked to above is not the right format. The right format is https://github.com/CityScope/CSL_HCMC/blob/main/Data/Table/cs_types_2.0.csv We need the new types in this format before we can proceed. |
The final land type will be as in Sheet Final_landtype_density in this spreadsheet.
I guess the csv. file will be uploaded tomorrow with value of land area and constructed area. |
Dear @TuCTruong , I recommend using for housing types that matches with the existing LBCS types for housing: 1 | Household activities (Residential activities) LBCS = 1100 2 | Transient living (Residential activities) LBCS = 1200 3 | Institutional living (Residential activities) LBCS = 1300 |
Dear @LAAP, According to your previous comments, @TuCTruong and I proposed some changes listed below Residential – lowrise will be divided into 4 LBCS codes which are: In Residential – highrise, there will be 2 LBCS codes which are: And there are some minor changes to the Commerce, Services, and Mixed-Use codes to clarify a bit more and keep things consistent. Is this more suitable with cityscope's workflow than the one proposed earlier? |
@LeViet3910 , @nngocquang.arc@gmail.com and I have updated the land type and area per person. We may work on this value for now. If there is any value that is needed to be changed, we will let you know. Please check this link here Best, |
Please refer density column in #36 |
In order for CS modules to understand the land use changes in each scenario, each of these land uses (eg. Educational, Commercial, Public Facility) must be defined using the Types System. At minimum, each 'Type' should have a defined mix of NAICS codes and LBCS codes. These should be in a json file. For an example, please see the Corktown types definitions.
The text was updated successfully, but these errors were encountered: