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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161173 | 161173 | 225924 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 2ft | 6005469.65475 | 2108205.8081400003 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 152426 | 152426 | 176517 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 49 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006489.3282699995 | 2087380.0454 | 37.7119153848503 | -122.419391133293 | (37.7119153848503, -122.419391133293) | |||
| 152999 | 152999 | 176497 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Brookdale Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005989.52225 | 2087517.96508 | 37.7122659199214 | -122.421128393261 | (37.7122659199214, -122.421128393261) | |||
| 153095 | 153095 | 219000 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) | |||
| 158771 | 158771 | 176498 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.42179737647498 | (37.7121905153633, -122.421797376475) | |||
| 161897 | 161897 | 176501 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.42220159024599 | (37.7116934016018, -122.422201590246) | |||
| 164012 | 164012 | 128873 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | |||
| 169474 | 169474 | 176504 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005618.83947 | 2087124.32667 | 37.711164168567 | -122.422381633625 | (37.711164168567, -122.422381633625) | |||
| 171695 | 171695 | 176519 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | |||
| 177304 | 177304 | 176507 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | |||
| 179065 | 179065 | 176512 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006244.01324 | 2087410.04073 | 37.711983925792 | -122.42024114011801 | (37.711983925792, -122.420241140118) | |||
| 181038 | 181038 | 176508 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 6ft | 6005731.293880001 | 2087351.0784200002 | 37.71179312382829 | -122.422009060692 | (37.7117931238283, -122.422009060692) | |||
| 186907 | 186907 | 176505 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005616.04698 | 2087112.6870400002 | 37.7111320510829 | -122.42239045867599 | (37.7111320510829, -122.422390458676) | |||
| 187028 | 187028 | 176511 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006104.31545 | 2087436.5206900002 | 37.712048761508605 | -122.42072585491199 | (37.7120487615086, -122.420725854912) | |||
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
| 154338 | 154338 | 192414 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.76041492892529 | -122.40224581930799 | (37.7604149289253, -122.402245819308) | |||
| 156793 | 156793 | 192413 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | |||
| 168685 | 168685 | 192421 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 53 Pomona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6014148.288919999 | 2094395.14028 | 37.731605838737295 | -122.39341002514799 | (37.7316058387373, -122.393410025148) | |||
| 173461 | 173461 | 192419 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013725.780809999 | 2104155.14731 | 37.7583812766799 | -122.39555427333299 | (37.7583812766799, -122.395554273333) | |||
| 184565 | 184565 | 192415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1400 20th St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013731.20085 | 2104795.9240599996 | 37.760141011629706 | -122.39558042201 | (37.7601410116297, -122.39558042201) | |||
| 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) | ||||
| 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) | ||||
| 182998 | 182998 | 128875 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007636.05536 | 2118136.6748900004 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | ||||
| 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) | |||
| 181455 | 181455 | 142338 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | |||
| 184026 | 184026 | 225978 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 737 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6003705.65415 | 2103955.3434599997 | 37.757270218256394 | -122.430194042444 | (37.7572702182564, -122.430194042444) | |||
| 185415 | 185415 | 246444 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6003499.43256 | 2099785.6606799997 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | |||
| 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) | |||
| 509 | 509 | 38234 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 1016 | 1016 | 225959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.41836543223101 | (37.7377988968125, -122.418365432231) | |
| 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) | |||
| 2992 | 2992 | 43017 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3164 | 3164 | 10171 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1032 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 2x3 | Permit Number 779560 | 6005695.79144 | 2102951.17521 | 37.7546255252659 | -122.423239982539 | (37.7546255252659, -122.423239982539) | |
| 3545 | 3545 | 43015 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3668 | 3668 | 43018 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 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) | |||
| 4435 | 4435 | 34068 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 5326 | 5326 | 38231 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 5586 | 5586 | 43016 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 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) | ||
| 6607 | 6607 | 34069 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 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) | ||
| 7043 | 7043 | 34072 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 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) | |||
| 7991 | 7991 | 38232 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 9590 | 9590 | 34067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9825 | 9825 | 46928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | ||
| 9953 | 9953 | 107188 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1500 PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773122 | 5999274.2 | 2109122.8 | 37.771206769657205 | -122.445891326497 | (37.7712067696572, -122.445891326497) | |
| 10500 | 10500 | 34071 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 10511 | 10511 | 38233 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 10930 | 10930 | 109686 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) |
| 11919 | 11919 | 108571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 223 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772573 | 6009406.56 | 2094751.33642 | 37.732319284403204 | -122.409828317318 | (37.7323192844032, -122.409828317318) |
| 12244 | 12244 | 45154 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1683 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2001 12:00:00 AM | Permit Number 44007 | ||||||||
| 12798 | 12798 | 34070 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 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) | ||||
| 13345 | 13345 | 69222 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2001 12:00:00 AM | 3x3 | Permit Number 33274 | 6008665.27491562 | 2101259.70225891 | 37.750148257591896 | -122.412851097008 | (37.7501482575919, -122.412851097008) | |
| 13521 | 13521 | 49830 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 5 | 3x3 | Permit Number 46613 | 6013486.20588 | 2106002.24827 | 37.7634396826096 | -122.396512309398 | (37.7634396826096, -122.396512309398) | |
| 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) | ||
| 14322 | 14322 | 115881 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.0960099997 | 37.737410632491 | -122.39045976502199 | (37.737410632491, -122.390459765022) | ||
| 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) |
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");