Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, PlotSize
qLegalStatus ✖
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
65167 | 65167 | 225973 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.31867 | 2105450.2559599997 | 37.761331964925 | -122.432919999069 | (37.761331964925, -122.432919999069) | |||
65253 | 65253 | 225977 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6003712.20285 | 2103924.7270400003 | 37.7571865237503 | -122.43016921035499 | (37.7571865237503, -122.430169210355) | |||
65348 | 65348 | 142345 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1736 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5999542.2107 | 2110186.9275 | 37.7741438933316 | -122.445040782661 | (37.7741438933316, -122.445040782661) | |||
66184 | 66184 | 225934 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | |||
66285 | 66285 | 225948 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6003779.75499 | 2095097.5175400001 | 37.732952875676496 | -122.429306150766 | (37.7329528756765, -122.429306150766) | |||
66898 | 66898 | 225961 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007991.11967 | 2096976.87427 | 37.7383507001153 | -122.414879291246 | (37.7383507001153, -122.414879291246) | |||
66905 | 66905 | 244210 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | |||
67076 | 67076 | 192420 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013708.5618199995 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | |||
69064 | 69064 | 176509 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | |||
69724 | 69724 | 176518 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6007403.12553 | 2087360.3651400001 | 37.7119127723386 | -122.416231391376 | (37.7119127723386, -122.416231391376) |
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");