search

UMKC-Law / Parcel-Assessment-Tool

http://umkc-law.github.io/Parcel-Assessment-Tool
MIT License
4 stars 5 forks source link

Finalize calculations functionality given zoning code data #51

Open zmon opened 8 years ago

zmon commented 8 years ago

The zoning spreadsheet Zoning_code_v17.xls has two tabs of intrest, Lot_Requiremetns and Carlson_Use_Table

A proposed single pull down only using the Lot_Requirements tab of the spread sheet

@JRDeLisle @QuestofIranon

zmon commented 8 years ago

Pull down will bold zoning codes that apply to the parcel selected. When initially shown it will select the first zoning code in the list for the parcel. This allow user to apply a zoning code that is not assigned to the parcel.

See Formulas.js

zmon commented 8 years ago

@QuestofIranon some questions about where the data for ZoneTable should come from, but do not know if you will be able to answer them.

JS Variable Description came from the comments a the top of js/Formulas.js. Zoning Code Spread Sheet is in data/Zoning_Codes/Zoneing_code_v17.xls tab Lot_Requirements

ZoneTable JS Variable Description Zoning Code Spread Sheet Variable
height
LC Lot Coverage Ratio (N2)
far FAR maximum (N4) FAR, Row 9 of Lot_Requirements tab
maxheight Max_Height, Row 21 of Lot_Requirements tab
St # of Stories (N6)
PI Parking Index (N9)
PF Parking floors (N11)
SA Parking Stall Area (N10)

Questions:

1) It looks like "height", "St # of Stories (N6)", "PF Parking floors (N11)", and "SA Parking Stall Area (N10)" should be input by the user, or in the case of height and St default to max based off of maxheight.

2) I can not find "PI Parking Index (N9) in the Zoning Code Spread Sheet. What is the source of this? User or default.

The following is coming out of the spreadsheet:

NOTE: the only category where we have both FAR and Max_Height is in Manufacturing, M1, M2-2, ... all other zones only have FAR or Max_Height

Array
(
    [Res Conventional] => Array
        (
            [R80] => Array
                (
                    [Open_Space_Percent] => 
                    [Min_Lot_SF] => 80,000
                    [Min_Lot_Per_Unit] => 80,000
                    [Lot_Min_Res_Mixed_AboveGnd] => 
                    [Min_Lot_Width] => 150
                    [FAR] => 
                    [Front_SB_Percent_Depth] => 25
                    [FSB_Abut_Res] => 
                    [Min_Grg_Percent_Depth] => 25
                    [FSB_NonAbut_Res] => 
                    [Max_Req_FT] => 40
                    [RSB_Abut_Res_Perc] => 
                    [Min_RSB_Perc_Depth] => 25
                    [RSB_Max_Req_SF] => 50
                    [SS_Min_Perc_Width] => 10
                    [SS_Max_Req_FT] => 8
                    [SS_Abut_Min_FT] => 15
                    [Max_Height] => 35
                    [RSB_Abut_Res_Max_SF] => 
                    [RSB_NonAbut_Res_] => 
                    [SSB_Abut_Res] => 
                    [SSB_NonAbut_Res] => 
                    [Height_Max_Grnd_FL_Common] => 
                )

            [R10] => Array
                (
                    [Open_Space_Percent] => 
                    [Min_Lot_SF] => 10,000
                    [Min_Lot_Per_Unit] => 10,000
                    [Lot_Min_Res_Mixed_AboveGnd] =>