Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 3620 | 3620 | 139511 | Undocumented 2 | :: 54 | 1400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001017.0 | 2111110.0 | 37.776762480662704 | -122.440005440059 | (37.7767624806627, -122.440005440059) | |||
| 3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 6373 | 6373 | 138089 | Undocumented 2 | :: 54 | 1600 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004809.7961 | 2114741.3813 | 37.7869485378128 | -122.427143741054 | (37.7869485378128, -122.427143741054) | ||||
| 7654 | 7654 | 139157 | Undocumented 2 | :: 54 | 1699 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6003069.5459 | 2114034.3612 | 37.7849086753549 | -122.433114070807 | (37.7849086753549, -122.433114070807) | ||||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 19242 | 19242 | 36516 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 24890 | 24890 | 183769 | Undocumented 2 | :: 54 | 2295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987606.9921 | 2099681.9039 | 37.7446115325485 | -122.48555519813499 | (37.7446115325485, -122.485555198135) | |||
| 25969 | 25969 | 183335 | Undocumented 2 | :: 54 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106839.0545 | 37.7639763455704 | -122.503028028557 | (37.7639763455704, -122.503028028557) | |||
| 27534 | 27534 | 142574 | Undocumented 2 | :: 54 | 2251 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008922.4097 | 2120888.3705 | 37.804058366605894 | -122.413349854276 | (37.8040583666059, -122.413349854276) | |||
| 29665 | 29665 | 138192 | Undocumented 2 | :: 54 | 747 LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000012.96 | 2111513.4792 | 37.7778131233274 | -122.44350769286301 | (37.7778131233274, -122.443507692863) | |||
| 32792 | 32792 | 181569 | Undocumented 2 | :: 54 | 1349 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984599.7352 | 2105972.9827 | 37.7617094244752 | -122.496417657892 | (37.7617094244752, -122.496417657892) | |||
| 33727 | 33727 | 140005 | Undocumented 2 | :: 54 | 580 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005138.6408 | 2111659.5949 | 37.7785053047816 | -122.425786573599 | (37.7785053047816, -122.425786573599) | |||
| 36620 | 36620 | 184152 | Undocumented 2 | :: 54 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | |||
| 36898 | 36898 | 182668 | Undocumented 2 | :: 54 | 2860 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985110.0164 | 2102301.626 | 37.751658775563506 | -122.49438218913001 | (37.7516587755635, -122.49438218913) | |||
| 36994 | 36994 | 139027 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000525.7297 | 2114092.4384 | 37.784923514385 | -122.441918999732 | (37.784923514385, -122.441918999732) | |||
| 38604 | 38604 | 139030 | Undocumented 2 | :: 54 | 1535 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000620.3764 | 2114029.1087 | 37.784755020167395 | -122.441587007239 | (37.7847550201674, -122.441587007239) | |||
| 40717 | 40717 | 184162 | Undocumented 2 | :: 54 | 3542 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983197.136 | 2104275.0936 | 37.7569652328272 | -122.501143019632 | (37.7569652328272, -122.501143019632) | |||
| 45872 | 45872 | 141030 | Undocumented 2 | :: 54 | 88 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998905.3901 | 2112810.7346 | 37.781311824276294 | -122.44743254381099 | (37.7813118242763, -122.447432543811) | |||
| 46390 | 46390 | 183950 | Undocumented 2 | :: 54 | 2142 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989476.9277 | 2100771.7916 | 37.7477128505139 | -122.47916911508301 | (37.7477128505139, -122.479169115083) | |||
| 49707 | 49707 | 142339 | Undocumented 2 | :: 54 | 516 Central Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999737.6235 | 2110265.9409 | 37.7743719952599 | -122.44437049708598 | (37.7743719952599, -122.444370497086) | |||
| 51323 | 51323 | 33210 | Permitted Site 1 | :: 54 | 80 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 51812 | 51812 | 140046 | Undocumented 2 | :: 54 | 666 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005395.2334 | 2111605.7927 | 37.7783720737797 | -122.424895092854 | (37.7783720737797, -122.424895092854) | |||
| 52820 | 52820 | 141107 | Undocumented 2 | :: 54 | 200 Parker Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997010.9048 | 2112879.9419 | 37.7813934068271 | -122.45399149831002 | (37.7813934068271, -122.45399149831) | |||
| 52847 | 52847 | 185853 | Undocumented 2 | :: 54 | 2000 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984975.6848 | 2101206.0949 | 37.7486428848898 | -122.49476595568501 | (37.7486428848898, -122.494765955685) | |||
| 52878 | 52878 | 183794 | Undocumented 2 | :: 54 | 2022 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986600.5294 | 2099630.0551 | 37.744410477862 | -122.489031488827 | (37.744410477862, -122.489031488827) | |||
| 53717 | 53717 | 139776 | Undocumented 2 | :: 54 | 1275 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004800.935 | 2113296.4778 | 37.7829806915655 | -122.427071445409 | (37.7829806915655, -122.427071445409) | |||
| 54538 | 54538 | 139014 | Undocumented 2 | :: 54 | 2569 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000244.5734 | 2114049.2907 | 37.7847890167684 | -122.442888607586 | (37.7847890167684, -122.442888607586) | |||
| 55163 | 55163 | 139442 | Undocumented 2 | :: 54 | 501 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005371.2943 | 2111301.0083 | 37.777533858076204 | -122.424956216884 | (37.7775338580762, -122.424956216884) | |||
| 55821 | 55821 | 183882 | Undocumented 2 | :: 54 | 2130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988852.1343 | 2100932.014 | 37.748116473268105 | -122.48134132315599 | (37.7481164732681, -122.481341323156) | |||
| 57408 | 57408 | 184691 | Undocumented 2 | :: 54 | 3545 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983203.0915 | 2104221.1981 | 37.7568176006429 | -122.501118437486 | (37.7568176006429, -122.501118437486) | |||
| 57445 | 57445 | 185837 | Undocumented 2 | :: 54 | 2000 35th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985432.3475 | 2101089.5094 | 37.7483494925676 | -122.493178256173 | (37.7483494925676, -122.493178256173) | |||
| 61493 | 61493 | 105361 | Permitted Site 1 | :: 54 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 62615 | 62615 | 142063 | Undocumented 2 | :: 54 | 1100 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004132.6367 | 2112218.0001 | 37.779981646673896 | -122.42930655266399 | (37.7799816466739, -122.429306552664) | |||
| 68730 | 68730 | 182481 | Undocumented 2 | :: 54 | 1556 36th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985002.9582 | 2104611.8375 | 37.7579957124827 | -122.494922727233 | (37.7579957124827, -122.494922727233) | |||
| 68734 | 68734 | 139765 | Undocumented 2 | :: 54 | 1306 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004663.7345 | 2113397.522 | 37.7832503745299 | -122.427553303818 | (37.7832503745299, -122.427553303818) | |||
| 70117 | 70117 | 141532 | Undocumented 2 | :: 54 | 2901 TURK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996732.6359 | 2111474.3954 | 37.7775181869896 | -122.45485258320299 | (37.7775181869896, -122.454852583203) | |||
| 70919 | 70919 | 183783 | Undocumented 2 | :: 54 | 2295 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986368.597 | 2099653.7391 | 37.7444619681186 | -122.48983519347799 | (37.7444619681186, -122.489835193478) | |||
| 71471 | 71471 | 142991 | Undocumented 2 | :: 54 | 1847 GRANT AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010381.3657 | 2120852.2682 | 37.8040410433015 | -122.40829846422399 | (37.8040410433015, -122.408298464224) | |||
| 72928 | 72928 | 138462 | Undocumented 2 | :: 54 | 2583 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001603.2252 | 2114934.9525 | 37.787298182297604 | -122.43825159732701 | (37.7872981822976, -122.438251597327) | |||
| 73506 | 73506 | 140761 | Undocumented 2 | :: 54 | 18 Beideman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001559.8015 | 2112962.3476 | 37.7818794437174 | -122.43826046410801 | (37.7818794437174, -122.438260464108) | |||
| 73891 | 73891 | 246215 | Undocumented 2 | :: 54 | 725 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999843.1798 | 2107896.3377 | 37.767871685104105 | -122.443835079351 | (37.7678716851041, -122.443835079351) | |||
| 74336 | 74336 | 137805 | Undocumented 2 | :: 54 | 2050 BUCHANAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003886.2253 | 2115511.1067 | 37.789009738509 | -122.430394024555 | (37.789009738509, -122.430394024555) | |||
| 75195 | 75195 | 246178 | Undocumented 2 | :: 54 | 1588 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997994.7111 | 2108230.9638 | 37.76868487385529 | -122.45025281211201 | (37.7686848738553, -122.450252812112) | |||
| 77134 | 77134 | 186639 | Undocumented 2 | :: 54 | 1401 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984754.4469 | 2105410.0332 | 37.7601727847523 | -122.495841051742 | (37.7601727847523, -122.495841051742) | |||
| 81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81999 | 81999 | 108810 | Undocumented 2 | :: 54 | 301-399 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 82559 | 82559 | 116276 | Undocumented 2 | :: 54 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 83909 | 83909 | 109520 | Undocumented 2 | :: 54 | 4801X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999644.57626 | 2104777.09851 | 37.759295701171105 | -122.44429784106501 | (37.7592957011711, -122.444297841065) | |||||
| 85063 | 85063 | 108731 | Undocumented 2 | :: 54 | 1822-1898X 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013006.0 | 2102886.0 | 37.7548564119513 | -122.39795458116001 | (37.7548564119513, -122.39795458116) | ||||
| 86957 | 86957 | 109262 | Permitted Site 1 | :: 54 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
| 87303 | 87303 | 33408 | Permitted Site 1 | :: 54 | 100 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 88984 | 88984 | 109756 | Permitted Site 1 | :: 54 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 94106 | 94106 | 116320 | Undocumented 2 | :: 54 | 1451 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 97368 | 97368 | 121128 | Undocumented 2 | :: 54 | 201 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 102413 | 102413 | 108826 | Undocumented 2 | :: 54 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | ||||
| 109418 | 109418 | 119124 | Undocumented 2 | :: 54 | 601 46th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.50718822030198 | (37.7768923962204, -122.507188220302) | ||||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 115253 | 115253 | 106460 | Undocumented 2 | :: 54 | 701 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 115565 | 115565 | 114618 | Undocumented 2 | :: 54 | 2400X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 116325 | 116325 | 114670 | Undocumented 2 | :: 54 | 176X Peralta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | |||||
| 118997 | 118997 | 105083 | Significant Tree 6 | :: 54 | 344 Fulton St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 125361 | 125361 | 116323 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 126759 | 126759 | 31148 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
| 127461 | 127461 | 108990 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 130291 | 130291 | 181840 | Undocumented 2 | :: 54 | 2301 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989488.6342 | 2099164.2138 | 37.74329954287639 | -122.47901106638399 | (37.7432995428764, -122.479011066384) | |||
| 130561 | 130561 | 185848 | Undocumented 2 | :: 54 | 2021 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985688.7443 | 2101387.812 | 37.749183543113396 | -122.492313617761 | (37.7491835431134, -122.492313617761) | |||
| 131708 | 131708 | 142308 | Undocumented 2 | :: 54 | 1601 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000101.1371 | 2110566.6959 | 37.7752185258028 | -122.443134644018 | (37.7752185258028, -122.443134644018) | |||
| 132600 | 132600 | 184219 | Undocumented 2 | :: 54 | 3439 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984114.8945 | 2104934.4274 | 37.7588294281219 | -122.498017803137 | (37.7588294281219, -122.498017803137) | |||
| 135388 | 135388 | 183142 | Undocumented 2 | :: 54 | 3341 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982435.8047 | 2099431.6296 | 37.743621698860295 | -122.503417311271 | (37.7436216988603, -122.503417311271) | |||
| 135474 | 135474 | 140554 | Undocumented 2 | :: 54 | 830 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003715.6997 | 2111462.8271 | 37.7778845161396 | -122.43069501997101 | (37.7778845161396, -122.430695019971) | |||
| 136508 | 136508 | 185779 | Undocumented 2 | :: 54 | 2401 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986556.3071 | 2102295.5818 | 37.7517267146203 | -122.489380351661 | (37.7517267146203, -122.489380351661) | |||
| 137256 | 137256 | 184633 | Undocumented 2 | :: 54 | 1817 48th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981297.1345 | 2102687.6924 | 37.7524949268988 | -122.50759603982 | (37.7524949268988, -122.50759603982) | |||
| 140829 | 140829 | 105041 | Permitted Site 1 | :: 54 | 2660 Harrison St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x2 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 141620 | 141620 | 121614 | Undocumented 2 | :: 54 | 800X Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001168.0 | 2102650.0 | 37.7535420028484 | -122.43887668159701 | (37.7535420028484, -122.438876681597) | ||||
| 143390 | 143390 | 36528 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
| 144086 | 144086 | 115893 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 146146 | 146146 | 31190 | Permitted Site 1 | :: 54 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 146223 | 146223 | 115063 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 147303 | 147303 | 187451 | Undocumented 2 | :: 54 | 5098 Mission St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6000310.9137 | 2089292.2181 | 37.7168158602419 | -122.440882499178 | (37.7168158602419, -122.440882499178) | |||
| 147569 | 147569 | 184894 | Undocumented 2 | :: 54 | 1784 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981950.5709 | 2102944.1962 | 37.753237686600706 | -122.505355395478 | (37.7532376866007, -122.505355395478) | |||
| 147699 | 147699 | 181797 | Undocumented 2 | :: 54 | 1819 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987249.4663 | 2099598.2398 | 37.7443609759 | -122.48678529298999 | (37.7443609759, -122.48678529299) | |||
| 148856 | 148856 | 139245 | Undocumented 2 | :: 54 | 1223 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003686.6496 | 2113074.8565 | 37.7823091017787 | -122.430910590356 | (37.7823091017787, -122.430910590356) | |||
| 149018 | 149018 | 185807 | Undocumented 2 | :: 54 | 1655 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989756.0195 | 2101676.6632 | 37.7502135946 | -122.47827019350201 | (37.7502135946, -122.478270193502) | |||
| 150714 | 150714 | 183861 | Undocumented 2 | :: 54 | 2245 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987599.0974 | 2099987.662 | 37.7454506030407 | -122.485604930989 | (37.7454506030407, -122.485604930989) | |||
| 153937 | 153937 | 247379 | Undocumented 2 | :: 54 | 1015 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002146.8166 | 2109803.9081 | 37.7732405306973 | -122.436003592649 | (37.7732405306973, -122.436003592649) | |||
| 154962 | 154962 | 141900 | Undocumented 2 | :: 54 | 901 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004811.6243 | 2111979.8877 | 37.7793662649292 | -122.42694066580098 | (37.7793662649292, -122.426940665801) | |||
| 156071 | 156071 | 140635 | Undocumented 2 | :: 54 | 488 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5996872.4643 | 2109897.1866 | 37.7731956030309 | -122.45425492216002 | (37.7731956030309, -122.45425492216) | |||
| 159456 | 159456 | 246199 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999875.5825 | 2108001.7222 | 37.7681628926873 | -122.443730574399 | (37.7681628926873, -122.443730574399) | |||
| 162558 | 162558 | 183254 | Undocumented 2 | :: 54 | 1300 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.6607 | 2106131.1023 | 37.76192682906861 | -122.50918473520399 | (37.7619268290686, -122.509184735204) | |||
| 164453 | 164453 | 138698 | Undocumented 2 | :: 54 | 1600 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000125.4805 | 2114462.3047 | 37.7859162558141 | -122.443330304354 | (37.7859162558141, -122.443330304354) | |||
| 167807 | 167807 | 183887 | Undocumented 2 | :: 54 | 1390 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988922.6098 | 2101013.894 | 37.748345391297 | -122.481103618778 | (37.748345391297, -122.481103618778) | |||
| 172648 | 172648 | 182855 | Undocumented 2 | :: 54 | 2810 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985275.1952 | 2103001.4889 | 37.7535900723204 | -122.493862558345 | (37.7535900723204, -122.493862558345) | |||
| 172823 | 172823 | 140400 | Undocumented 2 | :: 54 | 650 WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004364.2248 | 2113098.7472 | 37.782413067955495 | -122.428568183869 | (37.7824130679555, -122.428568183869) | |||
| 173497 | 173497 | 200570 | Undocumented 2 | :: 54 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.38588947759399 | (37.7342110910182, -122.385889477594) | |||
| 174563 | 174563 | 182322 | Undocumented 2 | :: 54 | 2935 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985680.9561 | 2104986.6523 | 37.759064515977705 | -122.49260555988998 | (37.7590645159777, -122.49260555989) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");