Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125370 | 125370 | 3826 | DPW Maintained 3 | :: 54 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | ||
| 92851 | 92851 | 7876 | DPW Maintained 3 | :: 54 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.784504100894395 | -122.42291717866101 | (37.7845041008944, -122.422917178661) | ||
| 108481 | 108481 | 28868 | DPW Maintained 3 | :: 54 | 75 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6013233.2298598 | 2115774.102568 | 37.790256890180295 | -122.39807285434601 | (37.7902568901803, -122.398072854346) | ||
| 89497 | 89497 | 30705 | Permitted Site 1 | :: 54 | 371 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34615 | 6005225.74804899 | 2110232.43831944 | 37.7745916029272 | -122.425383648395 | (37.7745916029272, -122.425383648395) | ||
| 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) | ||
| 101816 | 101816 | 31149 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 4 | 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) | ||
| 140174 | 140174 | 31188 | Permitted Site 1 | :: 54 | 744 Shields St | 1 | 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) | ||
| 20493 | 20493 | 31189 | Permitted Site 1 | :: 54 | 744 Shields St | 2 | 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) | ||
| 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) | ||
| 142035 | 142035 | 31191 | Permitted Site 1 | :: 54 | 744 Shields St | 4 | 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) | ||
| 18795 | 18795 | 31192 | Permitted Site 1 | :: 54 | 744 Shields St | 5 | 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) | ||
| 82222 | 82222 | 32457 | Permitted Site 1 | :: 54 | 210 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36972 | 6003808.4224833 | 2109079.21792679 | 37.771344964126705 | -122.430204165931 | (37.7713449641267, -122.430204165931) | ||
| 141810 | 141810 | 33041 | Permitted Site 1 | :: 54 | 322 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39744 | 6005441.34293998 | 2101824.8118286 | 37.751518429358605 | -122.424039839357 | (37.7515184293586, -122.424039839357) | ||
| 102292 | 102292 | 33205 | Permitted Site 1 | :: 54 | 80 Ulloa St | 4 | 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) | |||
| 110733 | 110733 | 33206 | Permitted Site 1 | :: 54 | 80 Ulloa St | 5 | 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) | |||
| 114951 | 114951 | 33208 | Permitted Site 1 | :: 54 | 80 Ulloa St | 2 | 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) | |||
| 83937 | 83937 | 33209 | Permitted Site 1 | :: 54 | 80 Ulloa St | 1 | 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) | |||
| 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) | |||
| 140197 | 140197 | 33406 | Permitted Site 1 | :: 54 | 100 Ulloa St | 1 | 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) | ||
| 77581 | 77581 | 33407 | Permitted Site 1 | :: 54 | 100 Ulloa St | 2 | 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) | ||
| 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) | ||
| 79062 | 79062 | 33409 | Permitted Site 1 | :: 54 | 100 Ulloa St | 4 | 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) | ||
| 99156 | 99156 | 33410 | Permitted Site 1 | :: 54 | 100 Ulloa St | 5 | 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) | ||
| 91200 | 91200 | 33411 | Permitted Site 1 | :: 54 | 100 Ulloa St | 6 | 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) | ||
| 100825 | 100825 | 33462 | Permitted Site 1 | :: 54 | 20 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | ||
| 86204 | 86204 | 33463 | Permitted Site 1 | :: 54 | 20 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | ||
| 145190 | 145190 | 33509 | Permitted Site 1 | :: 54 | 24 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37605 | 6006962.93911675 | 2099621.40648906 | 37.745554167617 | -122.418621725138 | (37.745554167617, -122.418621725138) | |||
| 87372 | 87372 | 33510 | Permitted Site 1 | :: 54 | 24 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37605 | 6006962.93911675 | 2099621.40648906 | 37.745554167617 | -122.418621725138 | (37.745554167617, -122.418621725138) | |||
| 88172 | 88172 | 33514 | Permitted Site 1 | :: 54 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37614 | 6006108.24130768 | 2097930.15080676 | 37.7408622046731 | -122.421457054715 | (37.7408622046731, -122.421457054715) | ||
| 107393 | 107393 | 33714 | Permitted Site 1 | :: 54 | 171 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37781 | 6003460.14310315 | 2108772.24359779 | 37.770482355194105 | -122.431386962618 | (37.7704823551941, -122.431386962618) | ||
| 84755 | 84755 | 34736 | Permitted Site 1 | :: 54 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38386 | 6007298.90712997 | 2104006.62448648 | 37.7576138889301 | -122.417770773708 | (37.7576138889301, -122.417770773708) | ||
| 81521 | 81521 | 34737 | Permitted Site 1 | :: 54 | 575 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38387 | 6007300.76294173 | 2103973.10640079 | 37.757521960416604 | -122.41776197976499 | (37.7575219604166, -122.417761979765) | ||
| 145300 | 145300 | 34738 | Permitted Site 1 | :: 54 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38388 | 6007301.38154642 | 2103961.93369164 | 37.7574913175401 | -122.417759048452 | (37.7574913175401, -122.417759048452) | ||
| 80004 | 80004 | 35095 | Permitted Site 1 | :: 54 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.718911055862606 | -122.43365900206499 | (37.7189110558626, -122.433659002065) | ||
| 139436 | 139436 | 35137 | Permitted Site 1 | :: 54 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | ||
| 104076 | 104076 | 35147 | Permitted Site 1 | :: 54 | 218 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38679 | 6003802.50848229 | 2109121.89341149 | 37.7714618056141 | -122.430227667803 | (37.7714618056141, -122.430227667803) | ||
| 127351 | 127351 | 35482 | Permitted Site 1 | :: 54 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | ||
| 78656 | 78656 | 35996 | Permitted Site 1 | :: 54 | 36 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39146 | 6007490.93822931 | 2099869.27557104 | 37.7462644727809 | -122.416813538412 | (37.7462644727809, -122.416813538412) | ||
| 19176 | 19176 | 36500 | Permitted Site 1 | :: 54 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.741839715130894 | -122.41513812883001 | (37.7418397151309, -122.41513812883) | ||
| 127642 | 127642 | 36507 | Permitted Site 1 | :: 54 | 584 Anderson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) | ||
| 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) | ||
| 30528 | 30528 | 36517 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 2 | 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) | ||
| 89025 | 89025 | 36518 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 4 | 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) | ||
| 118134 | 118134 | 36519 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 1 | 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) | ||
| 123158 | 123158 | 36526 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 2 | 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) | ||
| 54627 | 54627 | 36527 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 1 | 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) | ||
| 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) | ||
| 81123 | 81123 | 36532 | Permitted Site 1 | :: 54 | 3734St. Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39405 | 6008419.88910724 | 2097501.78967285 | 37.7398160862313 | -122.413433924041 | (37.7398160862313, -122.413433924041) | ||
| 109892 | 109892 | 36905 | Permitted Site 1 | :: 54 | 4416 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39553 | 6000517.15649148 | 2102301.36938584 | 37.7525476968755 | -122.441102423403 | (37.7525476968755, -122.441102423403) | ||
| 118121 | 118121 | 36924 | Permitted Site 1 | :: 54 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39568 | 6001154.35821609 | 2103257.26025902 | 37.755208616744795 | -122.438967374074 | (37.7552086167448, -122.438967374074) | ||
| 118536 | 118536 | 36929 | Permitted Site 1 | :: 54 | 901 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39571 | 6000612.32634681 | 2101962.60570598 | 37.751622953989205 | -122.440749012812 | (37.7516229539892, -122.440749012812) | ||
| 80342 | 80342 | 36993 | Permitted Site 1 | :: 54 | 2974 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39613 | 6008419.31343349 | 2103324.4841573997 | 37.7558038738313 | -122.413847688409 | (37.7558038738313, -122.413847688409) | ||
| 124217 | 124217 | 37151 | Permitted Site 1 | :: 54 | 124 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2015 12:00:00 AM | 3 | 4.5x10 | Permit Number 775446 | 6005712.42544702 | 2100249.055732 | 37.7472070660376 | -122.42299041598 | (37.7472070660376, -122.42299041598) |
| 117766 | 117766 | 37180 | Permitted Site 1 | :: 54 | 41 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39753 | 6005613.02354759 | 2099315.01435949 | 37.7446367918581 | -122.42326775451299 | (37.7446367918581, -122.423267754513) | ||
| 110326 | 110326 | 37315 | Permitted Site 1 | :: 54 | 561 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39830 | 6002709.44183784 | 2103247.60813838 | 37.7552704710237 | -122.43358875215 | (37.7552704710237, -122.43358875215) | ||
| 143116 | 143116 | 37316 | Permitted Site 1 | :: 54 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39831 | 6002632.74186614 | 2103295.45378084 | 37.755397491549 | -122.433857422868 | (37.755397491549, -122.433857422868) | ||
| 77582 | 77582 | 37456 | Permitted Site 1 | :: 54 | 442 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.743020676259704 | -122.40723276795299 | (37.7430206762597, -122.407232767953) | ||
| 120864 | 120864 | 37457 | Permitted Site 1 | :: 54 | 442 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.743020676259704 | -122.40723276795299 | (37.7430206762597, -122.407232767953) | ||
| 110521 | 110521 | 37485 | Permitted Site 1 | :: 54 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341002 | (37.7640707487715, -122.47510458341) | ||
| 128256 | 128256 | 37520 | Permitted Site 1 | :: 54 | 649 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39973 | 6008796.59183246 | 2114756.17350418 | 37.787213798801396 | -122.41335133309099 | (37.7872137988014, -122.413351333091) | ||
| 81995 | 81995 | 37632 | Permitted Site 1 | :: 54 | 791 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40050 | 5990357.50342651 | 2110002.09732806 | 37.773107903504794 | -122.476798459473 | (37.7731079035048, -122.476798459473) | ||
| 78333 | 78333 | 38003 | Permitted Site 1 | :: 54 | 2478 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2002 12:00:00 AM | Permit Number 40215 | 5992069.67302471 | 2098579.11634993 | 37.74184256230679 | -122.47004399101499 | (37.7418425623068, -122.470043991015) | ||
| 110497 | 110497 | 38040 | Permitted Site 1 | :: 54 | 271 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40242 | 5992319.7729488 | 2097504.33557698 | 37.7389059415194 | -122.46910103166401 | (37.7389059415194, -122.469101031664) | ||
| 81482 | 81482 | 38110 | Permitted Site 1 | :: 54 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 103251 | 103251 | 38126 | Permitted Site 1 | :: 54 | 2822 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40290 | 5987014.20991985 | 2106446.11642248 | 37.7631496691658 | -122.488101839973 | (37.7631496691658, -122.488101839973) | ||
| 123854 | 123854 | 38201 | Permitted Site 1 | :: 54 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.723436846683704 | -122.405053190481 | (37.7234368466837, -122.405053190481) | ||
| 122041 | 122041 | 38338 | Permitted Site 1 | :: 54 | 73 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1998 12:00:00 AM | Permit Number 40405 | 5998234.47777194 | 2107177.32360217 | 37.7658055638462 | -122.44934755802 | (37.7658055638462, -122.44934755802) | |||
| 138290 | 138290 | 39089 | Permitted Site 1 | :: 54 | 3140102 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.757184385901496 | -122.41761479761601 | (37.7571843859015, -122.417614797616) | ||
| 141077 | 141077 | 39090 | Permitted Site 1 | :: 54 | 3140102 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.757184385901496 | -122.41761479761601 | (37.7571843859015, -122.417614797616) | ||
| 85350 | 85350 | 40070 | Permitted Site 1 | :: 54 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | ||
| 127606 | 127606 | 40513 | Permitted Site 1 | :: 54 | 1620 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41577 | 5999999.85509787 | 2110944.48687978 | 37.7762500681911 | -122.443512144169 | (37.7762500681911, -122.443512144169) | ||
| 86244 | 86244 | 41853 | Permitted Site 1 | :: 54 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42240 | 5992008.2421953 | 2105257.75589238 | 37.7601768237518 | -122.470742754033 | (37.7601768237518, -122.470742754033) | ||
| 129236 | 129236 | 41854 | Permitted Site 1 | :: 54 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42241 | 5991990.35837611 | 2105257.12694546 | 37.7601740626082 | -122.47080455929701 | (37.7601740626082, -122.470804559297) | ||
| 94877 | 94877 | 42090 | Permitted Site 1 | :: 54 | 25 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | ||
| 122633 | 122633 | 42091 | Permitted Site 1 | :: 54 | 25 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | ||
| 111037 | 111037 | 43020 | Permitted Site 1 | :: 54 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | ||
| 92236 | 92236 | 43021 | Permitted Site 1 | :: 54 | 537 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | |||
| 109627 | 109627 | 43024 | Permitted Site 1 | :: 54 | 430 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051004 | -122.429193705112 | (37.774709297051, -122.429193705112) | ||
| 78529 | 78529 | 43025 | Permitted Site 1 | :: 54 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051004 | -122.429193705112 | (37.774709297051, -122.429193705112) | ||
| 116859 | 116859 | 45263 | Permitted Site 1 | :: 54 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | ||
| 121409 | 121409 | 45784 | Permitted Site 1 | :: 54 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | ||
| 81650 | 81650 | 45785 | Permitted Site 1 | :: 54 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2001 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | |||
| 85267 | 85267 | 46322 | Permitted Site 1 | :: 54 | 3080 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | Permit Number 44576 | 5988871.55058969 | 2094853.71729449 | 37.731428183192705 | -122.480829241755 | (37.7314281831927, -122.480829241755) | |||
| 113475 | 113475 | 46634 | Permitted Site 1 | :: 54 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.185840401 | 2093576.72961431 | 37.729391461068204 | -122.391309972305 | (37.7293914610682, -122.391309972305) | ||
| 93908 | 93908 | 51029 | Permitted Site 1 | :: 54 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3x3 | Permit Number 767941 | 6007256.96585115 | 2097027.84886938 | 37.7384493854458 | -122.417421253654 | (37.7384493854458, -122.417421253654) | ||
| 110336 | 110336 | 52107 | Permitted Site 1 | :: 54 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | ||
| 85490 | 85490 | 52296 | Permitted Site 1 | :: 54 | 677DIAMOND ST Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48457 | 6002165.96993722 | 2099704.44459938 | 37.7455109340163 | -122.435214819168 | (37.7455109340163, -122.435214819168) | ||
| 2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
| 104342 | 104342 | 95908 | Permitted Site 1 | :: 54 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767609 | 5987396.4 | 2105326.0 | 37.760096425656705 | -122.486697735896 | (37.7600964256567, -122.486697735896) | |
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 96301 | 96301 | 101476 | Significant Tree 6 | :: 54 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089.0 | 2095440.1 | 37.7336838892166 | -122.44209059296301 | (37.7336838892166, -122.442090592963) | ||
| 79668 | 79668 | 103672 | Undocumented 2 | :: 54 | 2416 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008103.2 | 2104332.6 | 37.7585541718373 | -122.41501226542499 | (37.7585541718373, -122.415012265425) | |||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 141475 | 141475 | 104153 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 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) | |||
| 92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) |
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");