Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 434 | 434 | 136390 | Undocumented 2 | Tree(s) :: 17 | 3395 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779746 | 5998765.27001 | 2115243.09553 | 37.787982442971604 | -122.448092477507 | (37.7879824429716, -122.448092477507) | |
| 1215 | 1215 | 218931 | Permitted Site 1 | Tree(s) :: 17 | 1353 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779656 | 5994855.14791 | 2106335.8141799998 | 37.7633011159875 | -122.460974863827 | (37.7633011159875, -122.460974863827) | |
| 2165 | 2165 | 126954 | Undocumented 2 | Tree(s) :: 17 | 419 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780142 | 5998133.78034 | 2114953.67276 | 37.7871516456883 | -122.450256437883 | (37.7871516456883, -122.450256437883) | |
| 2564 | 2564 | 126730 | Undocumented 2 | Tree(s) :: 17 | 2839 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780358 | 5999405.85549 | 2118032.7905200003 | 37.7956788068866 | -122.44607691062001 | (37.7956788068866, -122.44607691062) | |
| 22894 | 22894 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288001 | (37.712360795684, -122.45981072288) | |
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 75944 | 75944 | 242822 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 46 | Width 5ft | 6002178.85689 | 2096424.55585 | 37.7365058551638 | -122.434935735002 | (37.7365058551638, -122.434935735002) | |||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 439 | 439 | 136984 | Undocumented 2 | Tree(s) :: 17 | 454 Walnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779785 | 5998641.89853 | 2115102.68231 | 37.7875898520492 | -122.448509202661 | (37.7875898520492, -122.448509202661) | |
| 1321 | 1321 | 131728 | Undocumented 2 | Tree(s) :: 17 | 2951 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779933 | 6003422.05081 | 2118487.47605 | 37.7971557823578 | -122.432212651716 | (37.7971557823578, -122.432212651716) | |
| 1360 | 1360 | 125405 | Undocumented 2 | Tree(s) :: 17 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779167 | 6001716.65019 | 2117116.43684 | 37.7932944253528 | -122.438015491236 | (37.7932944253528, -122.438015491236) | |
| 1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
| 1877 | 1877 | 125609 | Undocumented 2 | Tree(s) :: 17 | 3620 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779927 | 5997454.92356 | 2115432.53824 | 37.7884276100946 | -122.45263969527599 | (37.7884276100946, -122.452639695276) | |
| 2045 | 2045 | 124757 | Undocumented 2 | Tree(s) :: 17 | 2040 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779873 | 6003680.83051 | 2117635.7933099996 | 37.7948319494745 | -122.431256385468 | (37.7948319494745, -122.431256385468) | |
| 2046 | 2046 | 131756 | Undocumented 2 | Tree(s) :: 17 | 1818 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004733.3748 | 2117781.6991 | 37.795292161346104 | -122.427624834041 | (37.7952921613461, -122.427624834041) | |||
| 2053 | 2053 | 124756 | Undocumented 2 | Tree(s) :: 17 | 2040 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779873 | 6003696.79526 | 2117638.17776 | 37.794839401275894 | -122.431201315505 | (37.7948394012759, -122.431201315505) | |
| 3627 | 3627 | 124885 | Undocumented 2 | Tree(s) :: 17 | 3443 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779060 | 5998224.02667 | 2115497.28494 | 37.788649425187295 | -122.449983401009 | (37.7886494251873, -122.449983401009) | |
| 10121 | 10121 | 127434 | Undocumented 2 | Tree(s) :: 17 | 1725 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779294 | 6005908.31862 | 2117540.05529 | 37.7946950573888 | -122.423542145749 | (37.7946950573888, -122.423542145749) | |
| 933 | 933 | 203966 | Undocumented 2 | Tree(s) :: 17 | 200 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | Permit Number 779992 | 5992562.812059999 | 2097843.65033 | 37.739851654243296 | -122.46828540055901 | (37.7398516542433, -122.468285400559) | ||
| 944 | 944 | 211703 | Undocumented 2 | Tree(s) :: 17 | 248 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779802 | 5994526.77657 | 2088729.78807 | 37.7149404380179 | -122.460834540792 | (37.7149404380179, -122.460834540792) | |
| 1032 | 1032 | 164022 | Permitted Site 1 | Tree(s) :: 17 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779959 | 5998844.0 | 2107514.0 | 37.7667648389525 | -122.447263591802 | (37.7667648389525, -122.447263591802) | |
| 1334 | 1334 | 250499 | Undocumented 2 | Tree(s) :: 17 | 540 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779924 | 5986884.24135 | 2115388.89729 | 37.7876964378791 | -122.489208879795 | (37.7876964378791, -122.489208879795) | |
| 2111 | 2111 | 196623 | Undocumented 2 | Tree(s) :: 17 | 147 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780162 | 6012460.77279 | 2114398.06463 | 37.7864355596035 | -122.40064880949 | (37.7864355596035, -122.40064880949) | |
| 2228 | 2228 | 167815 | Undocumented 2 | Tree(s) :: 17 | 282 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | Permit Number 780344 | 6004374.21371 | 2109126.69451 | 37.771507353225395 | -122.42825045191799 | (37.7715073532254, -122.428250451918) | ||
| 2476 | 2476 | 212596 | Undocumented 2 | Tree(s) :: 17 | 310 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 780017 | 5994766.80041 | 2090657.2902900001 | 37.7202467087903 | -122.46014448379299 | (37.7202467087903, -122.460144483793) | ||
| 2482 | 2482 | 245639 | Undocumented 2 | Tree(s) :: 17 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007964.74692 | 2102552.0898 | 37.7536575156842 | -122.415365052856 | (37.7536575156842, -122.415365052856) | |||
| 2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
| 2887 | 2887 | 209188 | Undocumented 2 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.818630001 | 2098534.27999 | 37.7418782818471 | -122.46051787510599 | (37.7418782818471, -122.460517875106) | |
| 4870 | 4870 | 253696 | Undocumented 2 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | ||||
| 5172 | 5172 | 188749 | Undocumented 2 | Tree(s) :: 17 | 150 Executive Park Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014108.91993 | 2086973.0281900002 | 37.7112240085512 | -122.393027016493 | (37.7112240085512, -122.393027016493) | |
| 5184 | 5184 | 188751 | Undocumented 2 | Tree(s) :: 17 | 150 Executive Park Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014156.58166 | 2086969.04913 | 37.7112157302901 | -122.39286200619301 | (37.7112157302901, -122.392862006193) | |
| 5185 | 5185 | 188731 | Undocumented 2 | Tree(s) :: 17 | 250 Executive Park Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014568.15603 | 2086931.8817200002 | 37.711136527893 | -122.391436894596 | (37.711136527893, -122.391436894596) | |
| 48435 | 48435 | 180595 | Undocumented 2 | Tree(s) :: 17 | 438 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009775.03095 | 2092351.37985 | 37.725750154132704 | -122.408385202211 | (37.7257501541327, -122.408385202211) | |||
| 102884 | 102884 | 117678 | Undocumented 2 | Tree(s) :: 17 | 7800 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | Width 3ft | 5982735.28291 | 2112441.21655 | 37.7793599262476 | -122.503344894252 | (37.7793599262476, -122.503344894252) | ||
| 158746 | 158746 | 251040 | Undocumented 2 | Tree(s) :: 17 | 5455 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990029.1728 | 2112611.0353 | 37.780252275913206 | -122.478124966747 | (37.7802522759132, -122.478124966747) | |||
| 161387 | 161387 | 225019 | Undocumented 2 | Tree(s) :: 17 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779083 | 6001573.01872 | 2104694.86149 | 37.7591797334691 | -122.437622474895 | (37.7591797334691, -122.437622474895) | |
| 136 | 136 | 213016 | Undocumented 2 | Tree(s) :: 17 | 120 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779661 | 5993626.83548 | 2102594.2327400004 | 37.7529569465285 | -122.4649514087 | (37.7529569465285, -122.4649514087) | |
| 1327 | 1327 | 132224 | Undocumented 2 | Tree(s) :: 17 | 3720 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779917 | 5997037.00688 | 2115048.93067 | 37.7873503715741 | -122.454057896478 | (37.7873503715741, -122.454057896478) | |
| 50449 | 50449 | 242820 | Undocumented 2 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 2ft | 6002456.61791 | 2096763.3951400002 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | |||
| 61257 | 61257 | 134809 | Undocumented 2 | Tree(s) :: 17 | 2430 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | Permit Number 778843 | 6007053.11654 | 2120656.70313 | 37.8033171384475 | -122.41980223860399 | (37.8033171384475, -122.419802238604) | ||
| 179312 | 179312 | 242819 | Undocumented 2 | Tree(s) :: 17 | 173 Addison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002620.3556 | 2097408.25534 | 37.7392319251012 | -122.43347956444299 | (37.7392319251012, -122.433479564443) | |||
| 27 | 27 | 244214 | Private 5 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.43559821674499 | (37.7730099442883, -122.435598216745) | |
| 50 | 50 | 138938 | Private 5 | Tree(s) :: 17 | 632 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779650 | 6004797.9634 | 2110922.1515 | 37.7764612085261 | -122.426912572117 | (37.7764612085261, -122.426912572117) | |
| 252 | 252 | 182864 | DPW Maintained 3 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | ||
| 318 | 318 | 142205 | Permitted Site 1 | Tree(s) :: 17 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.44403063203698 | (37.774143230926, -122.444030632037) | ||
| 862 | 862 | 141567 | Permitted Site 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.44145768074499 | (37.7756308363396, -122.441457680745) | |
| 1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
| 1734 | 1734 | 247340 | Permitted Site 1 | Tree(s) :: 17 | 307 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779988 | 6003225.5695 | 2109437.2242 | 37.7722949315945 | -122.43224585173401 | (37.7722949315945, -122.432245851734) | |
| 1819 | 1819 | 137922 | Undocumented 2 | Tree(s) :: 17 | 1901 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780002 | 6003374.5786 | 2115313.2333 | 37.7884374328961 | -122.432150117212 | (37.7884374328961, -122.432150117212) | |
| 1967 | 1967 | 138282 | DPW Maintained 3 | Tree(s) :: 17 | 1202 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6003789.8642 | 2112168.8213 | 37.7798272025121 | -122.430488845982 | (37.7798272025121, -122.430488845982) | |||
| 2494 | 2494 | 183346 | Undocumented 2 | Tree(s) :: 17 | 1218 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780189 | 5983062.3107 | 2106821.3399 | 37.7639485863173 | -122.50179767328699 | (37.7639485863173, -122.501797673287) | |
| 2823 | 2823 | 184564 | Undocumented 2 | Tree(s) :: 17 | 4045 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780224 | 5981651.1237 | 2103482.1376 | 37.7546970960302 | -122.50643081650401 | (37.7546970960302, -122.506430816504) | |
| 3702 | 3702 | 143025 | Permitted Site 1 | Tree(s) :: 17 | 2147 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51763 | 6008956.6469 | 2120652.8991 | 37.803413743220794 | -122.413214712493 | (37.8034137432208, -122.413214712493) | |
| 23938 | 23938 | 248425 | Undocumented 2 | Tree(s) :: 17 | 731 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998544.0431 | 2108064.7106 | 37.7682598065536 | -122.448340749888 | (37.7682598065536, -122.448340749888) | |||
| 24012 | 24012 | 184369 | Undocumented 2 | Tree(s) :: 17 | 2246 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981440.3419 | 2099772.3553 | 37.7444986652432 | -122.50688458626699 | (37.7444986652432, -122.506884586267) | |||
| 25334 | 25334 | 248306 | Undocumented 2 | Tree(s) :: 17 | 2445 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009304.6458 | 2106837.3362 | 37.7654990466844 | -122.411034024362 | (37.7654990466844, -122.411034024362) | |||
| 25896 | 25896 | 248494 | Undocumented 2 | Tree(s) :: 17 | 757 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5997598.3079 | 2107875.2909999997 | 37.7676855940341 | -122.45159827426501 | (37.7676855940341, -122.451598274265) | |||
| 27147 | 27147 | 181826 | Undocumented 2 | Tree(s) :: 17 | 2306 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986108.4772 | 2099513.8036 | 37.744062551154705 | -122.490724327749 | (37.7440625511547, -122.490724327749) | |||
| 29187 | 29187 | 184866 | Undocumented 2 | Tree(s) :: 17 | 1201 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984637.6691 | 2106828.2325 | 37.7640599223867 | -122.496349569481 | (37.7640599223867, -122.496349569481) | |||
| 29729 | 29729 | 181810 | Undocumented 2 | Tree(s) :: 17 | 2311 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5987920.8952 | 2099549.8455 | 37.744267219356395 | -122.484460112778 | (37.7442672193564, -122.484460112778) | |||
| 30765 | 30765 | 181792 | Undocumented 2 | Tree(s) :: 17 | 1337 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986228.617000001 | 2098198.358 | 37.740457706632 | -122.490212173345 | (37.740457706632, -122.490212173345) | |||
| 31711 | 31711 | 182932 | Undocumented 2 | Tree(s) :: 17 | 2647 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982109.6852 | 2097079.7047 | 37.737144783675 | -122.504370733656 | (37.737144783675, -122.504370733656) | |||
| 32175 | 32175 | 183211 | Undocumented 2 | Tree(s) :: 17 | 2201 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982626.7574 | 2100094.3318 | 37.7454525198404 | -122.50280610050699 | (37.7454525198404, -122.502806100507) | |||
| 33644 | 33644 | 246232 | Undocumented 2 | Tree(s) :: 17 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999396.2041 | 2107735.5354 | 37.767404657023505 | -122.445369547591 | (37.7674046570235, -122.445369547591) | |||
| 34918 | 34918 | 138791 | Undocumented 2 | Tree(s) :: 17 | 2520 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000487.1483 | 2114138.3099 | 37.785047267117704 | -122.442055772364 | (37.7850472671177, -122.442055772364) | |||
| 35896 | 35896 | 142112 | Undocumented 2 | Tree(s) :: 17 | 33 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998605.4598 | 2110962.5015 | 37.776219910665105 | -122.44833701705 | (37.7762199106651, -122.44833701705) | |||
| 37496 | 37496 | 183179 | Undocumented 2 | Tree(s) :: 17 | 2400 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984268.9269 | 2098791.9181 | 37.7419728200296 | -122.49703171133999 | (37.7419728200296, -122.49703171134) | |||
| 37693 | 37693 | 248557 | Undocumented 2 | Tree(s) :: 17 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997345.4456 | 2107752.4938 | 37.7673339403594 | -122.452464026369 | (37.7673339403594, -122.452464026369) | |||
| 38125 | 38125 | 181361 | Undocumented 2 | Tree(s) :: 17 | 2125 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986542.2796 | 2100252.4532 | 37.746116016151795 | -122.489278654419 | (37.7461160161518, -122.489278654419) | |||
| 38895 | 38895 | 181647 | Undocumented 2 | Tree(s) :: 17 | 1810 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5990056.3621 | 2106554.5578 | 37.763624424605 | -122.47758809713899 | (37.763624424605, -122.477588097139) | |||
| 39230 | 39230 | 182566 | Undocumented 2 | Tree(s) :: 17 | 2483 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988890.9813 | 2098452.8512 | 37.7413116024246 | -122.481025496381 | (37.7413116024246, -122.481025496381) | |||
| 42252 | 42252 | 184463 | Undocumented 2 | Tree(s) :: 17 | 2149 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981371.9257 | 2100438.3719 | 37.746323331453205 | -122.507170550739 | (37.7463233314532, -122.507170550739) | |||
| 44271 | 44271 | 183442 | Undocumented 2 | Tree(s) :: 17 | 2444 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.5958 | 2098742.2388 | 37.742144449418795 | -122.47876942417601 | (37.7421444494188, -122.478769424176) | |||
| 46487 | 46487 | 182999 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988850.1732 | 2098290.3442 | 37.7408630283555 | -122.481154698143 | (37.7408630283555, -122.481154698143) | |||
| 46488 | 46488 | 245431 | Undocumented 2 | Tree(s) :: 17 | 2400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009345.194 | 2106891.7791 | 37.765650808121 | -122.410897622285 | (37.765650808121, -122.410897622285) | |||
| 46710 | 46710 | 246411 | Undocumented 2 | Tree(s) :: 17 | 22 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998217.2905 | 2108458.9941 | 37.769323722170796 | -122.449499363561 | (37.7693237221708, -122.449499363561) | |||
| 48053 | 48053 | 183443 | Undocumented 2 | Tree(s) :: 17 | 2444 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989551.5745 | 2098710.5787 | 37.7420576339149 | -122.47876026756201 | (37.7420576339149, -122.478760267562) | |||
| 48159 | 48159 | 183155 | Undocumented 2 | Tree(s) :: 17 | 2322 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981458.7309 | 2099250.8498 | 37.7430678392852 | -122.50678232868299 | (37.7430678392852, -122.506782328683) | |||
| 48260 | 48260 | 244096 | Undocumented 2 | Tree(s) :: 17 | 416 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997487.1651 | 2108993.3495 | 37.7707491304172 | -122.452063378018 | (37.7707491304172, -122.452063378018) | |||
| 48952 | 48952 | 187233 | Undocumented 2 | Tree(s) :: 17 | 2401 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984955.1932 | 2098637.2484 | 37.7415883305025 | -122.494647457647 | (37.7415883305025, -122.494647457647) | |||
| 49727 | 49727 | 244223 | Undocumented 2 | Tree(s) :: 17 | 1830 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997801.2012 | 2108901.6698 | 37.7705153847611 | -122.45097051473302 | (37.7705153847611, -122.450970514733) | |||
| 50343 | 50343 | 184817 | Undocumented 2 | Tree(s) :: 17 | 1201 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984676.4005 | 2106956.7675 | 37.764415112141 | -122.496225095071 | (37.764415112141, -122.496225095071) | |||
| 51269 | 51269 | 141554 | Undocumented 2 | Tree(s) :: 17 | 54 Chabot Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997753.8599 | 2111369.0927 | 37.7772875804111 | -122.45131224982201 | (37.7772875804111, -122.451312249822) | |||
| 51723 | 51723 | 138054 | Undocumented 2 | Tree(s) :: 17 | 1801 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003424.569 | 2114942.6734 | 37.787422803486294 | -122.431950687727 | (37.7874228034863, -122.431950687727) | |||
| 51947 | 51947 | 137784 | Undocumented 2 | Tree(s) :: 17 | 2160 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999172.8862 | 2111524.455 | 37.777795314951604 | -122.44641457841601 | (37.7777953149516, -122.446414578416) | |||
| 53653 | 53653 | 247275 | Undocumented 2 | Tree(s) :: 17 | 1665 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999077.5213 | 2109368.3030000003 | 37.771869626177896 | -122.44658930936701 | (37.7718696261779, -122.446589309367) | |||
| 53920 | 53920 | 183680 | Undocumented 2 | Tree(s) :: 17 | 1315 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982728.5996 | 2106143.6537 | 37.7620682453033 | -122.502901690129 | (37.7620682453033, -122.502901690129) | |||
| 54374 | 54374 | 183137 | Undocumented 2 | Tree(s) :: 17 | 3515 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981958.3374 | 2099418.2679 | 37.7435569304689 | -122.505067258282 | (37.7435569304689, -122.505067258282) | |||
| 55125 | 55125 | 244874 | Undocumented 2 | Tree(s) :: 17 | 1303 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000283.9747 | 2109200.4937 | 37.7714777032527 | -122.442404064945 | (37.7714777032527, -122.442404064945) | |||
| 59267 | 59267 | 245110 | Undocumented 2 | Tree(s) :: 17 | 135 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6000770.1938 | 2109453.5749 | 37.772200302029205 | -122.44074036886002 | (37.7722003020292, -122.44074036886) | |||
| 60990 | 60990 | 182927 | Undocumented 2 | Tree(s) :: 17 | 2639 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5982723.7516 | 2097156.0189 | 37.737390419431705 | -122.502253307981 | (37.7373904194317, -122.502253307981) | |||
| 63264 | 63264 | 182997 | Undocumented 2 | Tree(s) :: 17 | 2309 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988820.76 | 2098288.7961 | 37.7408570677039 | -122.481256283501 | (37.7408570677039, -122.481256283501) | |||
| 63475 | 63475 | 244957 | Undocumented 2 | Tree(s) :: 17 | 291 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005191.7976 | 2109882.6208 | 37.7736291707374 | -122.425476189168 | (37.7736291707374, -122.425476189168) | |||
| 64519 | 64519 | 244206 | Undocumented 2 | Tree(s) :: 17 | 6146 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003482.0997 | 2109688.9395 | 37.77300062178271 | -122.43137646296199 | (37.7730006217827, -122.431376462962) | |||
| 65383 | 65383 | 138375 | Undocumented 2 | Tree(s) :: 17 | 1751 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004245.4413 | 2114603.0947 | 37.786536907305106 | -122.42908641677401 | (37.7865369073051, -122.429086416774) | |||
| 65385 | 65385 | 187257 | Undocumented 2 | Tree(s) :: 17 | 2401 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984951.1083 | 2098437.5001 | 37.7410396364594 | -122.49464685904499 | (37.7410396364594, -122.494646859045) | |||
| 65508 | 65508 | 200840 | Undocumented 2 | Tree(s) :: 17 | 1499 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6012156.0588 | 2106988.3119 | 37.7660730788441 | -122.40118218158199 | (37.7660730788441, -122.401182181582) | |||
| 67702 | 67702 | 245047 | Undocumented 2 | Tree(s) :: 17 | 1034 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001580.3709 | 2109426.6521 | 37.7721724839727 | -122.43793597352101 | (37.7721724839727, -122.437935973521) | |||
| 68535 | 68535 | 183345 | Undocumented 2 | Tree(s) :: 17 | 4335 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982242.7748 | 2106909.309 | 37.764141950481 | -122.50463867354601 | (37.764141950481, -122.504638673546) | |||
| 69415 | 69415 | 185128 | DPW Maintained 3 | Tree(s) :: 17 | 1200x Sloat Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5987683.0779 | 2095922.3154 | 37.7342931239465 | -122.48501633511002 | (37.7342931239465, -122.48501633511) |
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");