Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
70033 | 70033 | 128871 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6001562.056059999 | 2116003.40074 | 37.790229524119795 | -122.438470613846 | (37.7902295241198, -122.438470613846) | |||
70499 | 70499 | 192417 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | |||
70638 | 70638 | 225898 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009373.69267 | 2107922.6668599998 | 37.7684829862389 | -122.41087186634701 | (37.7684829862389, -122.410871866347) | |||
71189 | 71189 | 107181 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | |||
72097 | 72097 | 176499 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6005745.58119 | 2087451.7768599999 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | |||
72606 | 72606 | 219001 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.46220122250799 | (37.7655709877426, -122.462201222508) | |||
73222 | 73222 | 225974 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.609680001 | 2105430.29379 | 37.761277170124394 | -122.43291756641001 | (37.7612771701244, -122.43291756641) | |||
73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
73386 | 73386 | 176503 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005661.68615 | 2087270.92863 | 37.711569123398796 | -122.422243953714 | (37.7115691233988, -122.422243953714) | |||
74298 | 74298 | 219014 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995361.04968 | 2090937.1170400002 | 37.721049208941004 | -122.45811061571999 | (37.721049208941, -122.45811061572) | |||
75133 | 75133 | 128874 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.41425481461799 | (37.7933104368651, -122.414254814618) | |||
75594 | 75594 | 142692 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2410 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008497.9336 | 2121083.9891 | 37.8045716448485 | -122.414832641069 | (37.8045716448485, -122.414832641069) | |||
75984 | 75984 | 225936 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008666.40255 | 2101335.6889400003 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | |||
76670 | 76670 | 225926 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002953.29528 | 2099219.1530400002 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | |||
78037 | 78037 | 102652 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | |||||
79560 | 79560 | 7700 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.804443723648895 | -122.415905321467 | (37.8044437236489, -122.415905321467) | |||
80611 | 80611 | 117516 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010054.0 | 2102576.0 | 37.753840371529705 | -122.40814160377899 | (37.7538403715297, -122.408141603779) | |||
81265 | 81265 | 10174 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2x2 | 6005692.3267338 | 2102916.9952861997 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | |||
81301 | 81301 | 21413 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | ||||
83902 | 83902 | 113388 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
84403 | 84403 | 6257 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | |||
85572 | 85572 | 115126 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
87311 | 87311 | 29766 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
89572 | 89572 | 105311 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 455 17TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x3 | 5990571.2 | 2112282.7 | 37.77938220530879 | -122.476225875432 | (37.7793822053088, -122.476225875432) | |||
90002 | 90002 | 10124 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 877 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005714.7162163 | 2103867.2939474997 | 37.7571420422058 | -122.42323965318998 | (37.7571420422058, -122.42323965319) | |||
90319 | 90319 | 421 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 685X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
92009 | 92009 | 98256 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
92381 | 92381 | 108167 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009908.0 | 2100009.0 | 37.7467837814289 | -122.40846544893999 | (37.7467837814289, -122.40846544894) | ||||
94395 | 94395 | 105962 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 6013706.37383 | 2104134.52437 | 37.758323571072204 | -122.39561994684401 | (37.7583235710722, -122.395619946844) | ||||
95528 | 95528 | 113389 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
97628 | 97628 | 102653 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | ||||
98596 | 98596 | 115128 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
101465 | 101465 | 96194 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.39039765239299 | (37.7395111076977, -122.390397652393) | |||
104521 | 104521 | 115129 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
105535 | 105535 | 10695 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.43705980731701 | (37.7751961745675, -122.437059807317) | |||
107364 | 107364 | 26544 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 530 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/1997 12:00:00 AM | 3 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | ||
107909 | 107909 | 98179 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50-60 Camp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005725.0 | 2106380.0 | 37.7640419231114 | -122.423382710222 | (37.7640419231114, -122.423382710222) | ||||
110418 | 110418 | 29761 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 500 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008886.831703201 | 2121139.4877643995 | 37.804745874094294 | -122.4134907456 | (37.8047458740943, -122.4134907456) | |||
110666 | 110666 | 98258 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
111305 | 111305 | 98257 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
111886 | 111886 | 98260 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
116317 | 116317 | 114483 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x2 | 6009096.0 | 2110140.0 | 37.7745556909018 | -122.41198909995701 | (37.7745556909018, -122.411989099957) | |||
118833 | 118833 | 98259 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008057.0 | 2106814.0 | 37.7653649274264 | -122.415347709739 | (37.7653649274264, -122.415347709739) | |||
121526 | 121526 | 105214 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
121812 | 121812 | 29765 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
123059 | 123059 | 98178 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 44- 46 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005746.0 | 2106381.0 | 37.7640458540826 | -122.42331014839701 | (37.7640458540826, -122.423310148397) | ||||
123727 | 123727 | 142340 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.774524444251206 | -122.444402018718 | (37.7745244442512, -122.444402018718) | |||
124791 | 124791 | 105310 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | |||
126187 | 126187 | 29763 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 530 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | |||
128944 | 128944 | 105213 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
129299 | 129299 | 108168 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009949.0 | 2099997.0 | 37.74675312806 | -122.40832282803001 | (37.74675312806, -122.40832282803) | ||||
129311 | 129311 | 94960 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998206.0 | 2108519.0 | 37.7694878371786 | -122.44954274107599 | (37.7694878371786, -122.449542741076) | ||||
129939 | 129939 | 225921 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900491998 | (37.7456982412969, -122.40909900492) | |||
129969 | 129969 | 225951 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000607.24532 | 2101675.7007299997 | 37.750834892731596 | -122.440746005644 | (37.7508348927316, -122.440746005644) | |||
130263 | 130263 | 192406 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 718 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6012081.21103 | 2105020.2958 | 37.7606651697825 | -122.401302754214 | (37.7606651697825, -122.401302754214) | ||||
130418 | 130418 | 225976 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 348 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001460.81775 | 2103733.76138 | 37.7565344055496 | -122.437941677576 | (37.7565344055496, -122.437941677576) | |||
130450 | 130450 | 225902 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 44 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005679.36245 | 2106382.2556 | 37.7640455405875 | -122.423540717652 | (37.7640455405875, -122.423540717652) | |||
130809 | 130809 | 142235 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004665.6696 | 2110849.8982 | 37.7762553374912 | -122.42736506585 | (37.7762553374912, -122.42736506585) | |||
131204 | 131204 | 140348 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1314 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004545.774 | 2113311.1445 | 37.7830065306397 | -122.427955242977 | (37.7830065306397, -122.427955242977) | |||
131583 | 131583 | 219011 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995317.533340001 | 2090902.82075 | 37.7209525389978 | -122.458258556883 | (37.7209525389978, -122.458258556883) | |||
131668 | 131668 | 176513 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006276.40846 | 2087403.9786200002 | 37.7119691058641 | -122.42012874286199 | (37.7119691058641, -122.420128742862) | |||
131682 | 131682 | 225928 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1106 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998173.76607 | 2106499.88804 | 37.763942024132206 | -122.44950872894199 | (37.7639420241322, -122.449508728942) | |||
132274 | 132274 | 225962 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007966.252640001 | 2096976.9069400001 | 37.738349392503 | -122.414965271836 | (37.738349392503, -122.414965271836) | |||
133659 | 133659 | 142688 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | |||
134421 | 134421 | 225909 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005410.68329 | 2103188.80406 | 37.755261904439394 | -122.424242863321 | (37.7552619044394, -122.424242863321) | |||
134760 | 134760 | 225975 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4337 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001561.548219999 | 2104657.76141 | 37.7590772134726 | -122.437659488305 | (37.7590772134726, -122.437659488305) | |||
134868 | 134868 | 225912 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1048 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6005698.159659999 | 2102902.03106 | 37.7544907204839 | -122.423228299447 | (37.7544907204839, -122.423228299447) | |||
135744 | 135744 | 192407 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 862 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011557.46585 | 2104307.68727 | 37.758679270636 | -122.403064037781 | (37.758679270636, -122.403064037781) | |||
136191 | 136191 | 192416 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1400 20th St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013651.01145 | 2104790.61421 | 37.760121971170896 | -122.395857388933 | (37.7601219711709, -122.395857388933) | |||
136428 | 136428 | 245455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007994.6854 | 2106818.5473 | 37.7653739107422 | -122.41556356407 | (37.7653739107422, -122.41556356407) | |||
136709 | 136709 | 225933 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008673.75291 | 2101213.6434299997 | 37.7500222662216 | -122.41281852357001 | (37.7500222662216, -122.41281852357) | |||
136892 | 136892 | 142690 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 560 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008610.8035 | 2121097.1003 | 37.804613986225704 | -122.41444297124599 | (37.8046139862257, -122.414442971246) | |||
136896 | 136896 | 219008 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 171 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5995319.46522 | 2091024.7689 | 37.7212874905944 | -122.458260700882 | (37.7212874905944, -122.458260700882) | |||
137432 | 137432 | 225937 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008665.07635 | 2101351.07554 | 37.7503991370286 | -122.412858243028 | (37.7503991370286, -122.412858243028) | |||
139464 | 139464 | 115130 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
139606 | 139606 | 26547 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1999 12:00:00 AM | 6 | 4X4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | ||
140451 | 140451 | 75710 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1190 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1993 12:00:00 AM | 12 | 18x3 | 6008645.48606603 | 2101619.0486747 | 37.7511338315754 | -122.412944932355 | (37.7511338315754, -122.412944932355) | ||
140768 | 140768 | 115822 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004593.0 | 2095924.0 | 37.7352682180932 | -122.42655338079099 | (37.7352682180932, -122.426553380791) | |||
144515 | 144515 | 10133 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005711.897824 | 2103735.5027185003 | 37.756780015162896 | -122.42324003225401 | (37.7567800151629, -122.423240032254) | ||
144912 | 144912 | 93025 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005372.0 | 2101391.0 | 37.7503233669919 | -122.424248785816 | (37.7503233669919, -122.424248785816) | |||||
146207 | 146207 | 119913 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013509.0 | 2106013.0 | 37.7634704729857 | -122.396434224989 | (37.7634704729857, -122.396434224989) | ||||
146753 | 146753 | 192418 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 5ft | 6013740.02795 | 2104156.2297400003 | 37.7583850412574 | -122.39550507589199 | (37.7583850412574, -122.395505075892) | |||
147884 | 147884 | 142233 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | |||
148398 | 148398 | 225925 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 357 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.743549752810296 | -122.428110007472 | (37.7435497528103, -122.428110007472) | |||
149617 | 149617 | 225954 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003654.86904 | 2095911.56632 | 37.735180998192206 | -122.429795956641 | (37.7351809981922, -122.429795956641) | |||
150699 | 150699 | 225931 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 337 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007076.3964 | 2096610.27498 | 37.737292658529 | -122.418015982652 | (37.737292658529, -122.418015982652) | |||
151104 | 151104 | 225972 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003502.63381 | 2105046.7258599997 | 37.760255392804496 | -122.430974055914 | (37.7602553928045, -122.430974055914) | |||
151401 | 151401 | 176516 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 49 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006459.4617 | 2087377.28485 | 37.7119061227438 | -122.419494165041 | (37.7119061227438, -122.419494165041) | |||
151682 | 151682 | 128876 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | ||||
151968 | 151968 | 225958 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 22 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006997.298830001 | 2096792.90464 | 37.7377896670691 | -122.41830240503599 | (37.7377896670691, -122.418302405036) |
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");