Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 256 | 256 | 221894 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008618.9330400005 | 2101573.97925 | 37.75100859049479 | -122.41303356944799 | (37.7510085904948, -122.413033569448) | |||
| 260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
| 1698 | 1698 | 225957 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007027.0 | 2096768.0 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | |||
| 4219 | 4219 | 244047 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997955.5586 | 2109119.1735 | 37.771121429752895 | -122.450452276113 | (37.7711214297529, -122.450452276113) | |||
| 5795 | 5795 | 10694 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001838.4236 | 2110502.6134 | 37.7751414763631 | -122.43712039839399 | (37.7751414763631, -122.437120398394) | |||
| 6485 | 6485 | 29768 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1991 12:00:00 AM | 6 | 6x6 | 6008286.5569 | 2121053.0319999997 | 37.8044747652934 | -122.415561939011 | (37.8044747652934, -122.415561939011) | ||
| 6875 | 6875 | 26546 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/1997 12:00:00 AM | 6 | 4X4 | 6008578.3106 | 2121094.8201 | 37.804605899968 | -122.41455525494301 | (37.804605899968, -122.414555254943) | ||
| 7187 | 7187 | 22760 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1620 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6002287.3238 | 2112301.156 | 37.7801053300032 | -122.43569625863701 | (37.7801053300032, -122.435696258637) | |||
| 7921 | 7921 | 29760 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 500 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008840.5335 | 2121127.883 | 37.804711410621294 | -122.41365014448401 | (37.8047114106213, -122.413650144484) | |||
| 13344 | 13344 | 187697 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.41284238591601 | (37.7500562758063, -122.412842385916) | ||||
| 13795 | 13795 | 78433 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | 6011558.925919999 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | ||
| 17382 | 17382 | 10079 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | |||
| 17464 | 17464 | 10037 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x2 | 6005536.7714599995 | 2106975.8845599997 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | |||
| 17889 | 17889 | 10131 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005716.194490001 | 2103799.35315 | 37.7569555760466 | -122.42322971137699 | (37.7569555760466, -122.423229711377) | ||
| 18217 | 18217 | 10091 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 708 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1992 12:00:00 AM | 50 | 3X3 | 6005589.43333 | 2104821.82229 | 37.759755882347704 | -122.42374079792299 | (37.7597558823477, -122.423740797923) | ||
| 18333 | 18333 | 27660 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6005798.597080001 | 2101052.0301599996 | 37.7494167122272 | -122.42274949589199 | (37.7494167122272, -122.422749495892) | |||
| 18959 | 18959 | 10130 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005717.32362 | 2103778.4665900003 | 37.7568982901448 | -122.423224321766 | (37.7568982901448, -122.423224321766) | ||
| 19073 | 19073 | 10152 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005742.33218 | 2103287.1896599997 | 37.7555507693625 | -122.42310291418801 | (37.7555507693625, -122.423102914188) | |||
| 19086 | 19086 | 10155 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | |||
| 19478 | 19478 | 10071 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 563 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x3 | 6005607.25335 | 2105721.20389 | 37.7622263784702 | -122.423743116346 | (37.7622263784702, -122.423743116346) | |||
| 19491 | 19491 | 10032 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 315 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6005527.20527 | 2107119.43239 | 37.7660610633959 | -122.424119414293 | (37.7660610633959, -122.424119414293) | |||
| 19662 | 19662 | 10000 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X2 | 6005403.547780001 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | |||
| 19723 | 19723 | 26529 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6008970.13177 | 2102467.22828 | 37.75348096079001 | -122.41188219893101 | (37.75348096079, -122.411882198931) | |||
| 20077 | 20077 | 115127 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 20120 | 20120 | 10020 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.42444122050101 | (37.767158847823, -122.424441220501) | |||
| 20175 | 20175 | 10089 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 700 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005586.51976 | 2104851.24563 | 37.7598365074586 | -122.423752966647 | (37.7598365074586, -122.423752966647) | |||
| 20284 | 20284 | 10112 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 821 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005694.086069999 | 2104163.28117 | 37.7579535897166 | -122.423332040744 | (37.7579535897166, -122.423332040744) | |||
| 20351 | 20351 | 10165 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1019 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6005763.39401 | 2102897.6669099997 | 37.7544824188306 | -122.423002391551 | (37.7544824188306, -122.423002391551) | |||
| 20893 | 20893 | 10068 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 549 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x3 | 6005603.73706 | 2105778.3330099997 | 37.762383043055 | -122.423759340124 | (37.762383043055, -122.423759340124) | |||
| 21251 | 21251 | 10061 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 490 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X2 | 6005517.65207 | 2106131.14555 | 37.7633469229371 | -122.424082167969 | (37.7633469229371, -122.424082167969) | |||
| 21466 | 21466 | 10087 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005642.33302 | 2105078.4944700003 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | |||
| 21505 | 21505 | 10026 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 290 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 2x3 | 6005455.03663 | 2107324.1386599997 | 37.7666190630424 | -122.424383592842 | (37.7666190630424, -122.424383592842) | |||
| 21573 | 21573 | 10054 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X2 | 6005501.955709999 | 2106458.62904 | 37.764245228771 | -122.42415974799201 | (37.764245228771, -122.424159747992) | |||
| 21621 | 21621 | 10076 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 600 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2x2 | 6005555.84644 | 2105437.30746 | 37.7614439637781 | -122.423900725242 | (37.7614439637781, -122.423900725242) | |||
| 21713 | 21713 | 10001 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.768723653813204 | -122.42437155270201 | (37.7687236538132, -122.424371552702) | |||
| 21782 | 21782 | 10227 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005821.31625 | 2100751.5734599996 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) | |||
| 21827 | 21827 | 26513 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6008948.96043 | 2101783.0813599997 | 37.7516012590109 | -122.41190707235701 | (37.7516012590109, -122.411907072357) | |||
| 22152 | 22152 | 10132 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005714.0796 | 2103814.39751 | 37.756996764997 | -122.42323809485599 | (37.756996764997, -122.423238094856) | ||
| 24547 | 24547 | 83274 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 5 | 6008741.72565 | 2118600.6509700003 | 37.7977667125146 | -122.41381320433001 | (37.7977667125146, -122.41381320433) | ||
| 24867 | 24867 | 128872 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008617.8933 | 2116985.80522 | 37.7933257892186 | -122.414127394165 | (37.7933257892186, -122.414127394165) | |||
| 25421 | 25421 | 192408 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 799 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011594.92882 | 2104699.3900200003 | 37.759756891395796 | -122.40296202319999 | (37.7597568913958, -122.4029620232) | |||
| 25801 | 25801 | 225955 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003637.7380800005 | 2095933.74555 | 37.735240927214704 | -122.42985676608299 | (37.7352409272147, -122.429856766083) | |||
| 26692 | 26692 | 219004 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1655 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5993378.4627 | 2104217.9895 | 37.7574010390349 | -122.46592829725 | (37.7574010390349, -122.46592829725) | |||
| 27086 | 27086 | 225956 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004690.92985 | 2097272.0847099996 | 37.738975290087104 | -122.426310750952 | (37.7389752900871, -122.426310750952) | |||
| 27127 | 27127 | 225952 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001178.257669999 | 2102625.59939 | 37.753475588250396 | -122.438839459988 | (37.7534755882504, -122.438839459988) | |||
| 27884 | 27884 | 225899 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009375.43724 | 2107898.5512099997 | 37.7684168680618 | -122.41086412858 | (37.7684168680618, -122.41086412858) | |||
| 28449 | 28449 | 113387 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 28869 | 28869 | 83275 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1639X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 5 | 6008740.14676 | 2118614.90766 | 37.797805769189296 | -122.413819676732 | (37.7978057691893, -122.413819676732) | ||
| 29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
| 29070 | 29070 | 225918 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009320.793740001 | 2100001.018 | 37.746728962386705 | -122.41049539576001 | (37.7467289623867, -122.41049539576) | |||
| 29808 | 29808 | 225970 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009214.745180001 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | |||
| 29911 | 29911 | 245456 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007901.4813 | 2106811.8898 | 37.765350391343496 | -122.415885464882 | (37.7653503913435, -122.415885464882) | |||
| 30003 | 30003 | 219010 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995318.0566300005 | 2090927.8253099998 | 37.7210212256375 | -122.458258556898 | (37.7210212256375, -122.458258556898) | |||
| 31018 | 31018 | 244415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003443.0612 | 2109684.1199 | 37.7729851758016 | -122.43151115772899 | (37.7729851758016, -122.431511157729) | |||
| 31199 | 31199 | 176506 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6005608.52394 | 2087094.5334400001 | 37.7110817807597 | -122.42241517113001 | (37.7110817807597, -122.42241517113) | |||
| 31526 | 31526 | 95134 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 450@ Wayland Somerset St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6010117.366119999 | 2092259.39432 | 37.7255167458877 | -122.40719528853501 | (37.7255167458877, -122.407195288535) | |||
| 31692 | 31692 | 219005 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992852.04405 | 2102933.06242 | 37.7538425808737 | -122.467655401194 | (37.7538425808737, -122.467655401194) | |||
| 32129 | 32129 | 225911 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 886 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005643.7507 | 2103817.72642 | 37.75700193611971 | -122.42348155572999 | (37.7570019361197, -122.42348155573) | |||
| 33404 | 33404 | 225968 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005865.3441 | 2101966.56287 | 37.751931574603894 | -122.422583660903 | (37.7519315746039, -122.422583660903) | |||
| 35324 | 35324 | 245162 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1308 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000247.8581 | 2109240.6853 | 37.7715860006418 | -122.44253187989901 | (37.7715860006418, -122.442531879899) | |||
| 35780 | 35780 | 128877 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.0884300005 | 2118146.70213 | 37.796458073045 | -122.417610293998 | (37.796458073045, -122.417610293998) | ||||
| 35910 | 35910 | 219003 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993948.08517 | 2105555.3752599997 | 37.7611059976579 | -122.464055414128 | (37.7611059976579, -122.464055414128) | |||
| 36558 | 36558 | 225906 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.750260956187404 | -122.423660939909 | (37.7502609561874, -122.423660939909) | |||
| 36653 | 36653 | 225927 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 172 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004830.8864400005 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | |||
| 37482 | 37482 | 225944 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3386 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005759.148709999 | 2103755.79247 | 37.7568383926032 | -122.42307806320801 | (37.7568383926032, -122.423078063208) | |||
| 37497 | 37497 | 102247 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.761948225348505 | -122.394424198727 | (37.7619482253485, -122.394424198727) | |||
| 38420 | 38420 | 244549 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.44591479977801 | (37.7711525285338, -122.445914799778) | |||
| 39091 | 39091 | 219012 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 139 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995316.47386 | 2090822.54609 | 37.720732063003396 | -122.45825641200399 | (37.7207320630034, -122.458256412004) | |||
| 39266 | 39266 | 225908 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005343.316000001 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | |||
| 39534 | 39534 | 244202 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | |||
| 39742 | 39742 | 192410 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011779.1081300005 | 2105360.6424 | 37.761582826304604 | -122.402371529224 | (37.7615828263046, -122.402371529224) | |||
| 40705 | 40705 | 192411 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.40236942660499 | (37.7615462436837, -122.402369426605) | |||
| 40965 | 40965 | 225919 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009340.70254 | 2099660.4482299997 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | |||
| 41412 | 41412 | 192412 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.761503842456605 | -122.402363116082 | (37.7615038424566, -122.402363116082) | |||
| 43000 | 43000 | 176515 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006304.71292 | 2087396.6514 | 37.7119505816242 | -122.420030394781 | (37.7119505816242, -122.420030394781) | |||
| 43253 | 43253 | 219013 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995360.7073099995 | 2090920.7561700002 | 37.721004266213 | -122.458110615707 | (37.721004266213, -122.458110615707) | |||
| 43658 | 43658 | 123212 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | |||
| 43767 | 43767 | 176500 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005731.33862 | 2087429.69303 | 37.712008985404 | -122.422014487205 | (37.712008985404, -122.422014487205) | |||
| 43922 | 43922 | 176514 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | |||
| 44140 | 44140 | 225904 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50 Camp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005635.69766 | 2106380.47503 | 37.7640381868445 | -122.42369161489701 | (37.7640381868445, -122.423691614897) | |||
| 44495 | 44495 | 225965 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.74185999325589 | -122.409770124916 | (37.7418599932559, -122.409770124916) | |||
| 44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
| 45304 | 45304 | 225930 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.41937757332899 | (37.7412874920181, -122.419377573329) | |||
| 47738 | 47738 | 219007 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 207 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995325.396369999 | 2091321.08064 | 37.7221014328296 | -122.45826163439501 | (37.7221014328296, -122.458261634395) | |||
| 49296 | 49296 | 225964 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007927.65948 | 2096983.8877299998 | 37.7383663914855 | -122.415099202478 | (37.7383663914855, -122.415099202478) | |||
| 49449 | 49449 | 219009 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 161 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995318.799459999 | 2090948.50153 | 37.7210780403007 | -122.458257484914 | (37.7210780403007, -122.458257484914) | |||
| 51594 | 51594 | 225963 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007947.91694 | 2096980.6157799999 | 37.7383585458117 | -122.41502893034401 | (37.7383585458117, -122.415028930344) | |||
| 53261 | 53261 | 225947 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003497.57041 | 2095097.9657299998 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | |||
| 53402 | 53402 | 128867 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | |||
| 56399 | 56399 | 219016 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | |||
| 58127 | 58127 | 176510 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006143.81597 | 2087479.5619400002 | 37.7121691699409 | -122.420592382928 | (37.7121691699409, -122.420592382928) | |||
| 58473 | 58473 | 225900 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009378.42208 | 2107868.1744 | 37.768333627729504 | -122.410851658572 | (37.7683336277295, -122.410851658572) | |||
| 59507 | 59507 | 176502 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678002 | (37.7116417355373, -122.42221747678) | |||
| 59772 | 59772 | 225960 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.41477346894699 | (37.7383428544349, -122.414773468947) | |||
| 59849 | 59849 | 128863 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.42777232553499 | (37.7759621899439, -122.427772325535) | |||
| 60881 | 60881 | 192409 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | |||
| 61102 | 61102 | 225917 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005793.09116 | 2104012.0395299997 | 37.757543902632605 | -122.42297888958099 | (37.7575439026326, -122.422978889581) | |||
| 62266 | 62266 | 78621 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 8 | 6011632.9456400005 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | ||
| 64117 | 64117 | 245459 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007813.0325 | 2106805.2324 | 37.765327138725 | -122.416190917981 | (37.765327138725, -122.416190917981) | |||
| 64675 | 64675 | 225922 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009935.78986 | 2099989.5983599997 | 37.7467320650326 | -122.40836798561199 | (37.7467320650326, -122.408367985612) |
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");