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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186735 | 186735 | 87761 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2261 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53828 | 6003365.60618 | 2116866.8385400004 | 37.7927027281015 | -122.43229216075198 | (37.7927027281015, -122.432292160752) | |
| 186714 | 186714 | 53519 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1940 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1993 12:00:00 AM | 19 | Permit Number 31573 | 6004284.8537099995 | 2118065.54564 | 37.7960461511668 | -122.429197038711 | (37.7960461511668, -122.429197038711) | ||
| 186694 | 186694 | 127312 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2640 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6002172.20396 | 2117328.94343 | 37.7939038095568 | -122.436454463304 | (37.7939038095568, -122.436454463304) | |||
| 186636 | 186636 | 122118 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 135 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990818.11008 | 2114491.3562 | 37.7854608777817 | -122.47553303148399 | (37.7854608777817, -122.475533031484) | |||
| 186632 | 186632 | 127605 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007017.09322 | 2114140.64244 | 37.78542363072629 | -122.41946434350001 | (37.7854236307263, -122.4194643435) | |||
| 186619 | 186619 | 189721 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 628 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012367.5253 | 2104983.36933 | 37.7605797476748 | -122.400309922481 | (37.7605797476748, -122.400309922481) | |||
| 186612 | 186612 | 224810 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1505 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6003977.57419 | 2099500.06976 | 37.7450524767939 | -122.42893600690701 | (37.7450524767939, -122.428936006907) | |||
| 186577 | 186577 | 249392 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 318 Turk St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6008424.06306 | 2113156.66711 | 37.7828010178889 | -122.414526979149 | (37.7828010178889, -122.414526979149) | |||
| 186563 | 186563 | 128386 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 132 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012025.27877 | 2115950.7420200002 | 37.7906745473472 | -122.402264725734 | (37.7906745473472, -122.402264725734) | |||
| 186518 | 186518 | 128444 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Leidesdorff St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012134.73383 | 2116669.40171 | 37.7926539254842 | -122.401936555937 | (37.7926539254842, -122.401936555937) | |||
| 186495 | 186495 | 218950 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994983.41019 | 2096409.8604700002 | 37.7360543307295 | -122.45981221488701 | (37.7360543307295, -122.459812214887) | |||
| 186471 | 186471 | 92946 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3516 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5998005.77937 | 2115183.1429 | 37.7877743839273 | -122.450715842186 | (37.7877743839273, -122.450715842186) | ||||
| 186430 | 186430 | 128282 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Francisco St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6011187.65635 | 2121403.39656 | 37.805599422647205 | -122.40554706506201 | (37.8055994226472, -122.405547065062) | |||
| 186410 | 186410 | 127343 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2106 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6004015.4156 | 2117002.21692 | 37.7931112658174 | -122.43005345591601 | (37.7931112658174, -122.430053455916) | |||
| 186392 | 186392 | 57098 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2295 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 17 | Permit Number 14367 | 6003755.18269 | 2116589.55385 | 37.7919634565954 | -122.430924412446 | (37.7919634565954, -122.430924412446) | ||
| 186327 | 186327 | 192139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 609 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009509.06455 | 2111582.5010599997 | 37.778539626232295 | -122.41066211296699 | (37.7785396262323, -122.410662112967) | |||
| 186320 | 186320 | 127965 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 12 Castle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6011285.9641 | 2119410.80305 | 37.8001337452242 | -122.405066463761 | (37.8001337452242, -122.405066463761) | |||
| 186291 | 186291 | 249333 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 840 Post St | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6008047.50765 | 2114838.3401 | 37.7873973224712 | -122.415948831592 | (37.7873973224712, -122.415948831592) | |||
| 186245 | 186245 | 189737 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1746 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012527.43371 | 2105659.49925 | 37.762445166446 | -122.39980434610001 | (37.762445166446, -122.3998043461) | |||
| 186243 | 186243 | 121955 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 108 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990858.4057599995 | 2114664.86399 | 37.7859396176051 | -122.475406294483 | (37.7859396176051, -122.475406294483) | |||
| 186228 | 186228 | 190340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014805.5019 | 2116039.63688 | 37.791073430855796 | -122.392651447929 | (37.7910734308558, -122.392651447929) | |||
| 186224 | 186224 | 224963 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 421 Vicksburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004177.32841 | 2101544.7554900004 | 37.7506780140845 | -122.42839099886001 | (37.7506780140845, -122.42839099886) | |||
| 186218 | 186218 | 190267 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6014731.82819 | 2116284.5770799997 | 37.7917418879363 | -122.39292350272801 | (37.7917418879363, -122.392923502728) | |||
| 186188 | 186188 | 128363 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1051 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012280.79036 | 2119717.8377099996 | 37.801032350529795 | -122.40164555151699 | (37.8010323505298, -122.401645551517) | |||
| 186174 | 186174 | 118875 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 722 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5981376.4784699995 | 2110796.96576 | 37.7747653270952 | -122.507923425807 | (37.7747653270952, -122.507923425807) | |||
| 186110 | 186110 | 127039 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2170 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6000427.34776 | 2120305.09631 | 37.80197623486279 | -122.44270561489901 | (37.8019762348628, -122.442705614899) | |||
| 186107 | 186107 | 51475 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 123 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 47787 | 5988643.83675 | 2114504.1910900003 | 37.7853698375455 | -122.48305622256399 | (37.7853698375455, -122.483056222564) | |||
| 186104 | 186104 | 192055 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6011871.79785 | 2109231.5202200003 | 37.772216558574904 | -122.40232312683001 | (37.7722165585749, -122.40232312683) | |||
| 186089 | 186089 | 224910 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 14 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003951.88648 | 2095603.60095 | 37.7343522099779 | -122.428747112408 | (37.7343522099779, -122.428747112408) | |||
| 186081 | 186081 | 61722 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1984 12:00:00 AM | 16 | Permit Number 21724 | 6001552.32219 | 2120677.39647 | 37.8030625385713 | -122.43883937455799 | (37.8030625385713, -122.438839374558) | ||
| 186057 | 186057 | 114244 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1080 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6007723.75253 | 2119592.21806 | 37.8004320872364 | -122.417405989593 | (37.8004320872364, -122.417405989593) | |||
| 186038 | 186038 | 127421 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1991 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6005237.06158 | 2116469.50374 | 37.791717681775395 | -122.42578854972601 | (37.7917176817754, -122.425788549726) | |||
| 186032 | 186032 | 218856 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993096.9768900005 | 2106661.31699 | 37.7640935347181 | -122.467079415098 | (37.7640935347181, -122.467079415098) | |||
| 185999 | 185999 | 118643 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 486 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5981936.1877 | 2112495.85857 | 37.7794629495605 | -122.506113304335 | (37.7794629495605, -122.506113304335) | |||
| 185972 | 185972 | 224922 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 404 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6001770.66247 | 2103473.78799 | 37.755838196281 | -122.43685151578998 | (37.755838196281, -122.43685151579) | |||
| 185901 | 185901 | 58126 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1304 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1978 12:00:00 AM | 18 | Permit Number 17108 | 6011494.53836 | 2119797.94031 | 37.8012083874247 | -122.404371976684 | (37.8012083874247, -122.404371976684) | ||
| 185890 | 185890 | 128724 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 143 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011335.660019999 | 2118065.80523 | 37.7964434851335 | -122.40479975182899 | (37.7964434851335, -122.404799751829) | |||
| 185887 | 185887 | 126773 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2828 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999344.168819999 | 2118765.0942 | 37.797685994766795 | -122.446343063178 | (37.7976859947668, -122.446343063178) | |||
| 185886 | 185886 | 225328 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1893 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6004620.6476 | 2097622.71658 | 37.7399340725935 | -122.42657871563401 | (37.7399340725935, -122.426578715634) | |||
| 185825 | 185825 | 126658 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2925 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003432.53737 | 2118407.10129 | 37.796935688580206 | -122.43217062279301 | (37.7969356885802, -122.432170622793) | |||
| 185819 | 185819 | 226536 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Division St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009285.41361 | 2108074.3489 | 37.7688945195891 | -122.411187933104 | (37.7688945195891, -122.411187933104) | |||
| 185818 | 185818 | 128047 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 455 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008429.74137 | 2121720.44496 | 37.806315360333 | -122.41511370583599 | (37.806315360333, -122.415113705836) | |||
| 185792 | 185792 | 62085 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 509 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 15 | Permit Number 31131 | 6013285.17961 | 2104603.40467 | 37.75958757601121 | -122.39710950871401 | (37.7595875760112, -122.397109508714) | |
| 185758 | 185758 | 192152 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 63 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6007721.24176 | 2110723.77126 | 37.7760813609 | -122.41678603654199 | (37.7760813609, -122.416786036542) | |||
| 185756 | 185756 | 224792 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 556 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6002979.47891 | 2098926.74579 | 37.743421717234504 | -122.432346300841 | (37.7434217172345, -122.432346300841) | |||
| 185715 | 185715 | 127800 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 881 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6008163.71528 | 2120299.45914 | 37.8023987381833 | -122.415933648333 | (37.8023987381833, -122.415933648333) | |||
| 185692 | 185692 | 190114 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Utah St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010606.0053900005 | 2107358.47005 | 37.7670028523175 | -122.406569620302 | (37.7670028523175, -122.406569620302) | |||
| 185678 | 185678 | 126771 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2726 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5999846.65621 | 2118834.86491 | 37.7979062522333 | -122.444609342957 | (37.7979062522333, -122.444609342957) | |||
| 185656 | 185656 | 225326 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 130 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.98377 | 2097574.34607 | 37.7398065343366 | -122.426252554911 | (37.7398065343366, -122.426252554911) | |||
| 185655 | 185655 | 128333 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012113.76515 | 2120537.2102799998 | 37.803272827040004 | -122.402281176129 | (37.80327282704, -122.402281176129) | |||
| 185653 | 185653 | 123468 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 734 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995378.26432 | 2110548.77188 | 37.7748988860835 | -122.459470721231 | (37.7748988860835, -122.459470721231) | |||
| 185644 | 185644 | 61820 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 12 | 3x3 | Permit Number 21851 | 6010428.22131 | 2116162.36194 | 37.791166328100296 | -122.407805412888 | (37.7911663281003, -122.407805412888) | |
| 185622 | 185622 | 120322 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 23rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5988821.62524 | 2110892.0885 | 37.775462361456206 | -122.482176410805 | (37.7754623614562, -122.482176410805) | |||
| 185621 | 185621 | 126656 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3230 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002367.15387 | 2119385.8975299997 | 37.7995627458862 | -122.435927169217 | (37.7995627458862, -122.435927169217) | |||
| 185617 | 185617 | 128440 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 465 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012079.88655 | 2116745.39114 | 37.792859513197996 | -122.402131675541 | (37.792859513198, -122.402131675541) | |||
| 185572 | 185572 | 126994 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2934 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6000027.86912 | 2118666.87845 | 37.797455344738296 | -122.44397022084999 | (37.7974553447383, -122.44397022085) | |||
| 185564 | 185564 | 128457 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012262.10233 | 2116770.3895400004 | 37.7929383216875 | -122.4015029541 | (37.7929383216875, -122.4015029541) | |||
| 185486 | 185486 | 189727 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 637 Carolina St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012420.20208 | 2104978.75508 | 37.7605700152183 | -122.40012741226101 | (37.7605700152183, -122.400127412261) | ||||
| 185477 | 185477 | 128741 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 463 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011858.96703 | 2118049.98327 | 37.7964292776469 | -122.40298787331498 | (37.7964292776469, -122.402987873315) | |||
| 185447 | 185447 | 126866 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 33 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998419.31879 | 2116385.9335 | 37.791100591267096 | -122.44937177480101 | (37.7911005912671, -122.449371774801) | |||
| 185427 | 185427 | 225041 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 120 Corwin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000708.42096 | 2104160.0120900003 | 37.7576619710296 | -122.440574298962 | (37.7576619710296, -122.440574298962) | |||
| 185413 | 185413 | 59675 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 370 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1981 12:00:00 AM | 28 | 6x6 | Permit Number 19101 | 6006098.88187 | 2111098.2635 | 37.777018241338396 | -122.42242483525801 | (37.7770182413384, -122.422424835258) | |
| 185407 | 185407 | 124248 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1146 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5991941.716569999 | 2113466.13724 | 37.7827109799958 | -122.471570988584 | (37.7827109799958, -122.471570988584) | |||
| 185404 | 185404 | 126861 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1583 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004302.65226 | 2120099.4245 | 37.8016316668154 | -122.42928055515699 | (37.8016316668154, -122.429280555157) | |||
| 185388 | 185388 | 176449 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 817 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001220.52796 | 2092231.19277 | 37.7249373855418 | -122.43794880828501 | (37.7249373855418, -122.437948808285) | |||
| 185357 | 185357 | 127126 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2032 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001930.023580001 | 2115594.51369 | 37.7891277494023 | -122.437168187758 | (37.7891277494023, -122.437168187758) | |||
| 185343 | 185343 | 128367 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 843 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010390.86501 | 2116505.29195 | 37.7921058399542 | -122.40795885883301 | (37.7921058399542, -122.407958858833) | |||
| 185341 | 185341 | 110844 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2060 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6003722.19445 | 2117989.73437 | 37.7958061248031 | -122.431138535615 | (37.7958061248031, -122.431138535615) | |||
| 185317 | 185317 | 225366 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 50 Otis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6006790.86302 | 2109340.1569999997 | 37.772229913511204 | -122.419906265868 | (37.7722299135112, -122.419906265868) | |||
| 185272 | 185272 | 123970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993629.5161 | 2114758.79061 | 37.7863577539277 | -122.465825918302 | (37.7863577539277, -122.465825918302) | |||
| 185232 | 185232 | 120385 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 259 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5987758.22769 | 2115294.71339 | 37.7874888122176 | -122.486178177201 | (37.7874888122176, -122.486178177201) | |||
| 185227 | 185227 | 61905 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1021 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1985 12:00:00 AM | 13 | Permit Number 21949 | 6008612.80588 | 2116079.42944 | 37.7908368174273 | -122.414080845253 | (37.7908368174273, -122.414080845253) | ||
| 185157 | 185157 | 126943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3494 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998182.71744 | 2115206.81568 | 37.7878495096856 | -122.450105379659 | (37.7878495096856, -122.450105379659) | |||
| 185106 | 185106 | 127782 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1461 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6006531.733440001 | 2117968.33241 | 37.795906167194296 | -122.421415473046 | (37.7959061671943, -122.421415473046) | |||
| 185101 | 185101 | 127704 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1521 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008823.44098 | 2118088.7337 | 37.7963657027575 | -122.413494221982 | (37.7963657027575, -122.413494221982) | |||
| 185097 | 185097 | 224386 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 267 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005003.872330001 | 2108196.5989900003 | 37.768989142672204 | -122.426006206319 | (37.7689891426722, -122.426006206319) | |||
| 185072 | 185072 | 127565 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Cyril Magnin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010151.67997 | 2113856.21128 | 37.7848187053498 | -122.408599488199 | (37.7848187053498, -122.408599488199) | |||
| 185045 | 185045 | 225407 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3910 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004247.383219999 | 2104258.79234 | 37.758134085428 | -122.428342158486 | (37.758134085428, -122.428342158486) | |||
| 185023 | 185023 | 192084 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6010725.2061 | 2108351.4852 | 37.7697361132508 | -122.406227292459 | (37.7697361132508, -122.406227292459) | |||
| 184981 | 184981 | 225395 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 23 Clover Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000458.64697 | 2105108.8704 | 37.760253077041796 | -122.441506205257 | (37.7602530770418, -122.441506205257) | |||
| 184963 | 184963 | 249342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 825 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008177.754369999 | 2114809.68521 | 37.787325964877795 | -122.415496174003 | (37.7873259648778, -122.415496174003) | |||
| 184951 | 184951 | 246679 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 65 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005202.46496 | 2097607.42576 | 37.739924962478796 | -122.42456594386101 | (37.7399249624788, -122.424565943861) | |||
| 184950 | 184950 | 64950 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2515 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 12 | Permit Number 25981 | 6001413.376630001 | 2117259.87518 | 37.7936710182651 | -122.439075121022 | (37.7936710182651, -122.439075121022) | ||
| 184924 | 184924 | 126681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2961 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999971.48713 | 2118755.27158 | 37.7976948324145 | -122.44417167168001 | (37.7976948324145, -122.44417167168) | |||
| 184894 | 184894 | 127513 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 335 Powell St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6010233.96645 | 2114918.19092 | 37.7877392564025 | -122.408389735705 | (37.7877392564025, -122.408389735705) | |||
| 184873 | 184873 | 192081 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6010776.89946 | 2108351.1140900003 | 37.769737985659 | -122.406048459576 | (37.769737985659, -122.406048459576) | |||
| 184830 | 184830 | 127870 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1863 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007272.90865 | 2118759.36484 | 37.798119905069 | -122.418906991373 | (37.798119905069, -122.418906991373) | |||
| 184815 | 184815 | 189770 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 752 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 6010962.700209999 | 2104799.54607 | 37.7599965733071 | -122.405155654013 | (37.7599965733071, -122.405155654013) | |||
| 184808 | 184808 | 119939 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2818 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5986800.01885 | 2111190.97243 | 37.7761652193503 | -122.48919151296002 | (37.7761652193503, -122.48919151296) | |||
| 184781 | 184781 | 192143 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 654 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 2ft | 6009336.10614 | 2111189.43583 | 37.7774506632664 | -122.411232670746 | (37.7774506632664, -122.411232670746) | |||
| 184759 | 184759 | 224841 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997991.47518 | 2107190.00433 | 37.76582647884371 | -122.45018896265499 | (37.7658264788437, -122.450188962655) | |||
| 184757 | 184757 | 127833 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1287 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006863.91148 | 2118732.42114 | 37.7980228861946 | -122.420320330819 | (37.7980228861946, -122.420320330819) | |||
| 184711 | 184711 | 127988 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6009595.331619999 | 2121584.26837 | 37.8060068865837 | -122.411070335937 | (37.8060068865837, -122.411070335937) | |||
| 184690 | 184690 | 114631 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2253 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6000293.14232 | 2116421.08895 | 37.791304126726104 | -122.44289095438101 | (37.7913041267261, -122.442890954381) | |||
| 184670 | 184670 | 128192 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 151 Beach St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009607.3754900005 | 2122232.45277 | 37.807787313994396 | -122.411074469233 | (37.8077873139944, -122.411074469233) | |||
| 184663 | 184663 | 224923 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 860 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003073.91294 | 2103202.22547 | 37.7551665340181 | -122.43232506244699 | (37.7551665340181, -122.432325062447) | |||
| 184656 | 184656 | 190138 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 411 Barneveld Ave | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011253.6233 | 2097979.03397 | 37.7412851978498 | -122.403669581886 | (37.7412851978498, -122.403669581886) | |||
| 184641 | 184641 | 60299 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2937 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1982 12:00:00 AM | 10 | Permit Number 19865 | 5999980.0938 | 2118678.6203799997 | 37.797484859585 | -122.4441363796 | (37.797484859585, -122.4441363796) | ||
| 184633 | 184633 | 113951 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1416 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009766.25124 | 2118614.3917400003 | 37.7978619237571 | -122.410269018397 | (37.7978619237571, -122.410269018397) | |||
| 184586 | 184586 | 189583 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 25 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6014132.81504 | 2113093.12947 | 37.782945618993296 | -122.394772498951 | (37.7829456189933, -122.394772498951) |
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");