trees
11,761 rows where qSpecies_id = 17 sorted by qLegalStatus_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11433 | 44087 | DPW Maintained 1 | Tree(s) :: 17 | 500 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013716.56338 | 2112456.73733 | 37.7811750796017 | -122.396167952707 | (37.7811750796017, -122.396167952707) | 6 | 2 | 9 | 28856 | 34 | |
11474 | 208962 | DPW Maintained 1 | Tree(s) :: 17 | 90 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 6ft | Permit Number 784904 | 5993970.2453 | 2096804.3744 | 37.7370792503013 | -122.463343727552 | (37.7370792503013, -122.463343727552) | 1 | 8 | 4 | 59 | 40 | |
11689 | 260606 | DPW Maintained 1 | Tree(s) :: 17 | 1038 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013981.83254 | 2090017.73229 | 37.7195771072229 | -122.393679232644 | (37.7195771072229, -122.393679232644) | 10 | 3 | 8 | 58 | 1 | |||
11728 | 248542 | DPW Maintained 1 | Tree(s) :: 17 | 258 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998812.5011 | 2107653.6201 | 37.7671464005807 | -122.44738259118 | (37.7671464005807, -122.44738259118) | 15 | 5 | 11 | 29492 | 9 | |||
11804 | 261806 | DPW Maintained 1 | Tree(s) :: 17 | 2206 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986107 | 2100189 | 37.7459163725485 | -122.490779106515 | (37.7459163725485, -122.490779106515) | 1 | 8 | 3 | 29491 | 35 | |
11853 | 205139 | DPW Maintained 1 | Tree(s) :: 17 | 50 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/11/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784876 | 5994130.58491 | 2101814.28164 | 37.7508444327374 | -122.463152772706 | (37.7508444327374, -122.463152772706) | 1 | 8 | 4 | 29491 | 40 | |
11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
12037 | 260602 | DPW Maintained 1 | Tree(s) :: 17 | 1152 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013444.93607 | 2090417.98033 | 37.7206462592683 | -122.395563129546 | (37.7206462592683, -122.395563129546) | 10 | 3 | 8 | 58 | 1 | |||
12243 | 251221 | DPW Maintained 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | |||||||||||
12252 | 209088 | DPW Maintained 1 | Tree(s) :: 17 | 45 San Benito Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 8ft | Permit Number 784469 | 5992854.12284 | 2096493.93591 | 37.736162498488 | -122.467180069029 | (37.736162498488, -122.467180069029) | 1 | 8 | 4 | 59 | 40 | |
12348 | 232397 | DPW Maintained 1 | Tree(s) :: 17 | 141 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784757 | 6001376.80931 | 2106198.41743 | 37.7632969727984 | -122.438408781833 | (37.7632969727984, -122.438408781833) | 15 | 5 | 5 | 28862 | 3 | |
12539 | 208984 | DPW Maintained 1 | Tree(s) :: 17 | 354 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/11/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782906 | 5993085 | 2095640 | 37.7338311279924 | -122.466319797261 | (37.7338311279924, -122.466319797261) | 9 | 8 | 4 | 59 | 40 | |
12594 | 212505 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
12596 | 208983 | DPW Maintained 1 | Tree(s) :: 17 | 330 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/08/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 783251 | 5993097.51511 | 2095800.07009 | 37.73427136274 | -122.466288158284 | (37.73427136274, -122.466288158284) | 9 | 8 | 4 | 59 | 40 | |
12610 | 262055 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 6 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
12824 | 71999 | DPW Maintained 1 | Tree(s) :: 17 | 1919 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987523.8589 | 2102195.0257 | 37.7515070489426 | -122.486027091209 | (37.7515070489426, -122.486027091209) | 1 | 8 | 3 | 29491 | 35 | |||
12879 | 261642 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||||
13024 | 110488 | DPW Maintained 1 | Tree(s) :: 17 | 400 ANZA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776124 | 5997831 | 2112614 | 37.7807101879762 | -122.451135197253 | (37.7807101879762, -122.451135197253) | 15 | 6 | 2 | 54 | 16 | |
13070 | 181793 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13111 | 57916 | DPW Maintained 1 | Tree(s) :: 17 | 2226 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1977 12:00:00 AM | 7 | Permit Number 16874 | 5981746.2224 | 2099923.5924 | 37.7449319286698 | -122.505838142048 | (37.7449319286698, -122.505838142048) | 1 | 8 | 3 | 29491 | 35 | |
13206 | 181790 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13285 | 261800 | DPW Maintained 1 | Tree(s) :: 17 | 2275 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986345 | 2099772 | 37.7447853029759 | -122.489925482159 | (37.7447853029759, -122.489925482159) | 1 | 8 | 3 | 29491 | 35 | ||
13334 | 106393 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
13354 | 69175 | DPW Maintained 1 | Tree(s) :: 17 | 1362 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776236 | 5982474.0085 | 2105826.7525 | 37.7611831586406 | -122.503758737129 | (37.7611831586406, -122.503758737129) | 1 | 8 | 3 | 56 | 35 | |
13376 | 29902 | DPW Maintained 1 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6001149.68281092 | 2114264.52722613 | 37.7854315611698 | -122.439772670022 | (37.7854315611698, -122.439772670022) | 15 | 6 | 1 | 29490 | 27 | ||||||
13519 | 205140 | DPW Maintained 1 | Tree(s) :: 17 | 50 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/11/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784876 | 5994116.78098 | 2101826.82852 | 37.750878088069 | -122.463201417912 | (37.750878088069, -122.463201417912) | 1 | 8 | 4 | 29491 | 40 | |
13868 | 212497 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | ||
13877 | 262059 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 10 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
13931 | 70381 | DPW Maintained 1 | Tree(s) :: 17 | 1454 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982184.823 | 2105192.1683 | 37.7594237635385 | -122.504711868385 | (37.7594237635385, -122.504711868385) | 1 | 8 | 3 | 56 | 35 | |||
14156 | 117277 | DPW Maintained 1 | Tree(s) :: 17 | 1745 Pacheco St | 1 | Side Yard : Yard | Tree | Private 2 | 06/01/2016 12:00:00 AM | 3 | Permit Number 778164 | 5989481.8 | 2101691.1 | 37.7502373119693 | -122.479219506966 | (37.7502373119693, -122.479219506966) | 1 | 8 | 3 | 29491 | 35 | ||
14240 | 174970 | DPW Maintained 1 | Tree(s) :: 17 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5999272.73496 | 2090903.68447 | 37.7211813957975 | -122.444586716009 | (37.7211813957975, -122.444586716009) | 9 | 7 | 6 | 28861 | 25 | |||
14292 | 235418 | DPW Maintained 1 | Tree(s) :: 17 | 3466 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784779 | 6005281.81133 | 2103732.05889 | 37.7567462777212 | -122.424727186009 | (37.7567462777212, -122.424727186009) | 2 | 4 | 5 | 28859 | 19 | |
14319 | 107554 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |||
14401 | 208998 | DPW Maintained 1 | Tree(s) :: 17 | 10 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5993381.76992 | 2097221.25805 | 37.7381899876824 | -122.465408610532 | (37.7381899876824, -122.465408610532) | 1 | 8 | 4 | 59 | 40 | |
14442 | 260627 | DPW Maintained 1 | Tree(s) :: 17 | 1557 Hudson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015914.7542 | 2097249.1447 | 37.7395403460526 | -122.387501983912 | (37.7395403460526, -122.387501983912) | 10 | 3 | 8 | 58 | 1 | |||
14469 | 173738 | DPW Maintained 1 | Tree(s) :: 17 | 2500X Lyon St | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | ||||
14550 | 261641 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||
14657 | 208982 | DPW Maintained 1 | Tree(s) :: 17 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/11/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782907 | 5993096.56578 | 2095876.31596 | 37.7344806601409 | -122.466296979745 | (37.7344806601409, -122.466296979745) | 9 | 8 | 4 | 59 | 40 | |
14665 | 256768 | DPW Maintained 1 | Tree(s) :: 17 | 900 Brotherhood Way | 7 | Front Yard : Yard | Tree | DPW 1 | 09/25/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782397 | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |
14776 | 209001 | DPW Maintained 1 | Tree(s) :: 17 | 125 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5994148.93284 | 2096709.76404 | 37.7368297666801 | -122.462719067425 | (37.7368297666801, -122.462719067425) | 9 | 8 | 4 | 59 | 40 | |
14794 | 243191 | DPW Maintained 1 | Tree(s) :: 17 | 195 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6005498.9458 | 2108425.39088 | 37.7696453177193 | -122.424310051667 | (37.7696453177193, -122.424310051667) | 8 | 4 | 5 | 28853 | 19 | |||
14935 | 212498 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
15172 | 260605 | DPW Maintained 1 | Tree(s) :: 17 | 1042 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013961.37936 | 2090032.97981 | 37.719617837314 | -122.393750999085 | (37.719617837314, -122.393750999085) | 10 | 3 | 8 | 58 | 1 | |||
15302 | 153219 | DPW Maintained 1 | Tree(s) :: 17 | 1132 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6010246.61428 | 2102612.21341 | 37.7539505885697 | -122.407478048871 | (37.7539505885697, -122.407478048871) | 2 | 4 | 7 | 28859 | 19 | |||
15318 | 244196 | DPW Maintained 1 | Tree(s) :: 17 | 508 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998471.7891 | 2108892.6681 | 37.7705290359785 | -122.448650307908 | (37.7705290359785, -122.448650307908) | 15 | 5 | 11 | 29492 | 9 | |||
15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
15713 | 261808 | DPW Maintained 1 | Tree(s) :: 17 | 2355 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 5985742 | 2099196 | 37.743168533237 | -122.491968112718 | (37.743168533237, -122.491968112718) | 1 | 8 | 3 | 29491 | 35 | ||
15716 | 222847 | DPW Maintained 1 | Tree(s) :: 17 | 2070 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | Permit Number 782345 | 6008053.38749 | 2106472.7188 | 37.7644276454548 | -122.415336042541 | (37.7644276454548, -122.415336042541) | 8 | 4 | 7 | 28859 | 19 | ||
15964 | 71808 | DPW Maintained 1 | Tree(s) :: 17 | 2487 21st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 4x6 | Permit Number 783161 | 5989823.9383 | 2098417.3202 | 37.7412682330564 | -122.477797097779 | (37.7412682330564, -122.477797097779) | 1 | 8 | 3 | 29491 | 35 | |
15967 | 206142 | DPW Maintained 1 | Tree(s) :: 17 | 1377 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993310.45546 | 2106106.93767 | 37.7625836746174 | -122.466300768565 | (37.7625836746174, -122.466300768565) | 1 | 8 | 11 | 56 | 12 | |||
15968 | 261219 | DPW Maintained 1 | Tree(s) :: 17 | 1901 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5983159 | 2102154 | 37.7511390637365 | -122.501118029821 | (37.7511390637365, -122.501118029821) | 1 | 8 | 3 | 29491 | 35 | |
16024 | 239122 | DPW Maintained 1 | Tree(s) :: 17 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | Width 2ft | Permit Number 784437 | 6007432.27899 | 2096764.65731 | 37.7377365818786 | -122.416796463312 | (37.7377365818786, -122.416796463312) | 2 | 7 | 7 | 28859 | 2 | |
16125 | 260551 | DPW Maintained 1 | Tree(s) :: 17 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011850 | 2111438 | 37.7782738288903 | -122.402553714468 | (37.7782738288903, -122.402553714468) | 14 | 2 | 9 | 28856 | 34 | ||||
16232 | 262057 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 8 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
16275 | 260607 | DPW Maintained 1 | Tree(s) :: 17 | 1026 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014043.19207 | 2089971.98975 | 37.71945491674 | -122.393463933828 | (37.71945491674, -122.393463933828) | 10 | 3 | 8 | 58 | 1 | |||
16279 | 212501 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
16678 | 261979 | DPW Maintained 1 | Tree(s) :: 17 | 3471 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005237 | 2103664 | 37.7565568729323 | -122.424877318266 | (37.7565568729323, -122.424877318266) | 2 | 4 | 5 | 28859 | 19 | ||||
16744 | 261651 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||
16756 | 208992 | DPW Maintained 1 | Tree(s) :: 17 | 45 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/20/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782929 | 5993607.99739 | 2097104.18034 | 37.7378815660919 | -122.46461793558 | (37.7378815660919, -122.46461793558) | 1 | 8 | 4 | 59 | 40 | |
16870 | 110525 | DPW Maintained 1 | Tree(s) :: 17 | 1606 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | 3x3 | 5988987.9 | 2103139.4 | 37.7541852610858 | -122.481033456555 | (37.7541852610858, -122.481033456555) | 1 | 8 | 3 | 56 | 35 | ||
16897 | 208993 | DPW Maintained 1 | Tree(s) :: 17 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.464872800749 | (37.7380053101076, -122.464872800749) | 1 | 8 | 4 | 59 | 40 | |
17077 | 70380 | DPW Maintained 1 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | 1 | 8 | 3 | 56 | 35 | |||
17235 | 206375 | DPW Maintained 1 | Tree(s) :: 17 | 2 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/20/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 783010 | 5994061.2608 | 2097779.4801 | 37.7397618911113 | -122.463099778336 | (37.7397618911113, -122.463099778336) | 1 | 8 | 4 | 59 | 40 | |
17248 | 260604 | DPW Maintained 1 | Tree(s) :: 17 | 1058 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013879.56666 | 2090093.96987 | 37.7197807571849 | -122.394038065566 | (37.7197807571849, -122.394038065566) | 10 | 3 | 8 | 58 | 1 | |||
17296 | 262054 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 5 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
17341 | 260857 | DPW Maintained 1 | Tree(s) :: 17 | 726 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985712.15541 | 2110932.69313 | 37.7753924991275 | -122.492935643751 | (37.7753924991275, -122.492935643751) | 11 | 6 | 2 | 55 | 26 | |||
17395 | 208939 | DPW Maintained 1 | Tree(s) :: 17 | 100 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784719 | 5992155.70572 | 2095974.23732 | 37.7346951961161 | -122.469556940308 | (37.7346951961161, -122.469556940308) | 9 | 8 | 4 | 59 | 40 | |
17589 | 251643 | DPW Maintained 1 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007328 | 2121670 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | 5 | 1 | 1 | 28858 | 32 | |||
17730 | 25297 | DPW Maintained 1 | Tree(s) :: 17 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:24:00 PM | 3 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510353 | -122.440332418218 | (37.723490510353, -122.440332418218) | 9 | 7 | 6 | 28861 | 25 | ||
17888 | 129632 | DPW Maintained 1 | Tree(s) :: 17 | 1224 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2020 11:48:00 PM | 3 | Width 2ft | 6007668.52522 | 2118543.16915 | 37.7975485540748 | -122.417522708125 | (37.7975485540748, -122.417522708125) | 5 | 1 | 10 | 28858 | 32 | ||
17903 | 67300 | DPW Maintained 1 | Tree(s) :: 17 | 1630 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | 0 | Permit Number 30780 | 5983782.35684212 | 2104051.06719694 | 37.7563844663909 | -122.499102585081 | (37.7563844663909, -122.499102585081) | 1 | 8 | 3 | 56 | 35 | ||
18116 | 206569 | DPW Maintained 1 | Tree(s) :: 17 | 2435 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782959 | 5992009.07535 | 2098867.58833 | 37.7426311295378 | -122.470274518371 | (37.7426311295378, -122.470274518371) | 1 | 8 | 4 | 29491 | 40 | |
18378 | 208989 | DPW Maintained 1 | Tree(s) :: 17 | 55 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | Permit Number 782930 | 5993734.99989 | 2097013.08627 | 37.7376387653037 | -122.464172218067 | (37.7376387653037, -122.464172218067) | 1 | 8 | 4 | 59 | 40 | ||
18448 | 260600 | DPW Maintained 1 | Tree(s) :: 17 | 1122 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014231.13861 | 2090181.46138 | 37.7200405252834 | -122.392828913667 | (37.7200405252834, -122.392828913667) | 10 | 3 | 8 | 58 | 1 | |||
18583 | 261810 | DPW Maintained 1 | Tree(s) :: 17 | 2363 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985744 | 2099145 | 37.7430286178538 | -122.491957443342 | (37.7430286178538, -122.491957443342) | 1 | 8 | 3 | 29491 | 35 | ||
18729 | 99529 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
18757 | 261980 | DPW Maintained 1 | Tree(s) :: 17 | 718 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004261 | 2104680 | 37.7592913923108 | -122.428325085778 | (37.7592913923108, -122.428325085778) | 2 | 4 | 5 | 28862 | 3 | ||||
18785 | 112889 | DPW Maintained 1 | Tree(s) :: 17 | 107 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992983.7 | 2114758.1 | 37.7863185829105 | -122.468060207768 | (37.7863185829105, -122.468060207768) | 11 | 6 | 2 | 54 | 11 | |||||
18970 | 97073 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
19014 | 260601 | DPW Maintained 1 | Tree(s) :: 17 | 1142 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014128.86091 | 2090257.70792 | 37.7202442017659 | -122.393187787982 | (37.7202442017659, -122.393187787982) | 10 | 3 | 8 | 58 | 1 | |||
19015 | 261649 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||||
19059 | 244214 | DPW Maintained 1 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.435598216745 | (37.7730099442883, -122.435598216745) | 15 | 5 | 11 | 29492 | 9 | |
19304 | 181896 | DPW Maintained 1 | Tree(s) :: 17 | 2343 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986379.7223 | 2099305.8434 | 37.7435073893325 | -122.489771144773 | (37.7435073893325, -122.489771144773) | 1 | 8 | 3 | 29491 | 35 | |||
19310 | 261482 | DPW Maintained 1 | Tree(s) :: 17 | 1000 Portola Dr | 11 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
19499 | 261504 | DPW Maintained 1 | Tree(s) :: 17 | 1200X Portola Dr | 11 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
19534 | 162670 | DPW Maintained 1 | Tree(s) :: 17 | 30 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 5996650.10566 | 2090561.91182 | 37.7200929670042 | -122.453627674296 | (37.7200929670042, -122.453627674296) | 9 | 8 | 6 | 28861 | 24 | ||
19976 | 196623 | DPW Maintained 1 | Tree(s) :: 17 | 147 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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) | 12 | 2 | 9 | 28855 | 6 | |
20195 | 90386 | DPW Maintained 1 | Tree(s) :: 17 | 20 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2013 03:31:00 PM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
20302 | 55897 | DPW Maintained 1 | Tree(s) :: 17 | 3312 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2019 12:00:00 AM | 3 | Permit Number 11954 | 5999849.06827 | 2119940.56013 | 37.8009423337905 | -122.444680511705 | (37.8009423337905, -122.444680511705) | 13 | 9 | 1 | 57 | 17 | ||
20440 | 57565 | DPW Maintained 1 | Tree(s) :: 17 | 1719 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 0 | Permit Number 16432 | 5989021.61237767 | 2103630.83877072 | 37.7555365801748 | -122.480952851483 | (37.7555365801748, -122.480952851483) | 1 | 8 | 3 | 56 | 35 | ||
20492 | 108957 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
20760 | 184403 | DPW Maintained 1 | Tree(s) :: 17 | 2082 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981400.5223 | 2100912.6701 | 37.7476273056723 | -122.507106847904 | (37.7476273056723, -122.507106847904) | 1 | 8 | 3 | 29491 | 35 | |||
20761 | 237535 | DPW Maintained 1 | Tree(s) :: 17 | 95 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780607 | 6004123.30299 | 2102536.91331 | 37.7533991899358 | -122.428648540392 | (37.7533991899358, -122.428648540392) | 2 | 4 | 5 | 28862 | 22 | |
21296 | 108232 | DPW Maintained 1 | Tree(s) :: 17 | 1512 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2014 12:00:00 AM | 3 | Permit Number 773861 | 6000697.29517 | 2113843.62846 | 37.784250121203 | -122.441307581198 | (37.784250121203, -122.441307581198) | 15 | 6 | 11 | 29490 | 13 | ||
21367 | 33681 | DPW Maintained 1 | Tree(s) :: 17 | 417 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37761 | 6005353.591048 | 2111118.12961634 | 37.7770307178387 | -122.425004443456 | (37.7770307178387, -122.425004443456) | 7 | 9 | 11 | 28852 | 10 | ||
21751 | 187628 | DPW Maintained 1 | Tree(s) :: 17 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780841 | 6003236 | 2095183 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | 9 | 7 | 5 | 28861 | 25 | |
22080 | 102230 | DPW Maintained 1 | Tree(s) :: 17 | 4017-4019 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2013 12:00:00 AM | 16 | 3x3 | Permit Number 769509 | 6003067 | 2101815 | 37.7513571495319 | -122.432249902873 | (37.7513571495319, -122.432249902873) | 2 | 4 | 5 | 28862 | 22 | |
22208 | 182566 | DPW Maintained 1 | Tree(s) :: 17 | 2483 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988890.9813 | 2098452.8512 | 37.7413116024246 | -122.481025496381 | (37.7413116024246, -122.481025496381) | 1 | 8 | 3 | 29491 | 35 | |||
22639 | 54521 | DPW Maintained 1 | Tree(s) :: 17 | 3500 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1972 12:00:00 AM | Permit Number 10315 | 6006490.84096056 | 2100597.22904115 | 37.7482069647181 | -122.420323418546 | (37.7482069647181, -122.420323418546) | 2 | 4 | 5 | 28859 | 19 | |||
23096 | 27581 | DPW Maintained 1 | Tree(s) :: 17 | 1299X Illinois St | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2001 12:00:00 AM | 3 | 3X3 | 6016181.7533979 | 2103053.0321119 | 37.7554914042844 | -122.38698349009 | (37.7554914042844, -122.38698349009) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );