Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28022 | 28022 | 189675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 10 | : Yard 23 | Tree 1 | Private 1 | 8 | 6017194.50129 | 2102669.93128 | 37.754495514781496 | -122.383454393407 | (37.7544955147815, -122.383454393407) | ||||
| 58003 | 58003 | 189678 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 19 | : Yard 23 | Tree 1 | Private 1 | 15 | 6017295.34569 | 2102596.83049 | 37.7543003681831 | -122.38310055604299 | (37.7543003681831, -122.383100556043) | ||||
| 61562 | 61562 | 189676 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 11 | : Yard 23 | Tree 1 | Private 1 | 11 | 6017209.44087 | 2102637.39107 | 37.754406991811294 | -122.383400462871 | (37.7544069918113, -122.383400462871) | ||||
| 137284 | 137284 | 189677 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 14 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017255.58244 | 2102660.6719 | 37.754473466102795 | -122.38324251223801 | (37.7544734661028, -122.383242512238) | ||||
| 163742 | 163742 | 189680 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 21 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017213.38014 | 2102597.10976 | 37.754296605427704 | -122.38338403586701 | (37.7542966054277, -122.383384035867) | ||||
| 174582 | 174582 | 189679 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 24th St | 20 | : Yard 23 | Tree 1 | Private 1 | 12 | 6017238.946959999 | 2102621.26617 | 37.7543643468473 | -122.383297299846 | (37.7543643468473, -122.383297299846) | ||||
| 23382 | 23382 | 117409 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009993.98375 | 2122279.70822 | 37.8079387382549 | -122.40973984921101 | (37.8079387382549, -122.409739849211) | |||
| 31174 | 31174 | 117415 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010118.81969 | 2122297.52404 | 37.80799465090929 | -122.409309079351 | (37.8079946509093, -122.409309079351) | |||
| 47922 | 47922 | 117414 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010099.515980001 | 2122295.55675 | 37.807988167691 | -122.409375746091 | (37.807988167691, -122.409375746091) | |||
| 57393 | 57393 | 117407 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009960.43045 | 2122276.55632 | 37.8079282035823 | -122.40985574666901 | (37.8079282035823, -122.409855746669) | |||
| 74429 | 74429 | 117416 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010137.827269999 | 2122299.49705 | 37.8080011332052 | -122.409243437841 | (37.8080011332052, -122.409243437841) | |||
| 75046 | 75046 | 117412 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6010061.45891 | 2122289.54556 | 37.8079695301268 | -122.409507028246 | (37.8079695301268, -122.409507028246) | |||
| 137041 | 137041 | 117408 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009980.0242800005 | 2122278.22216 | 37.807933875624 | -122.409788054695 | (37.807933875624, -122.409788054695) | |||
| 158668 | 158668 | 117405 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009914.43975 | 2122269.2474599998 | 37.8079055577548 | -122.410014393348 | (37.8079055577548, -122.410014393348) | |||
| 166608 | 166608 | 117413 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010079.003190001 | 2122292.43405 | 37.8079784442232 | -122.409446515568 | (37.8079784442232, -122.409446515568) | |||
| 172790 | 172790 | 117404 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009897.70698 | 2122267.2121200003 | 37.807899031387294 | -122.410072157724 | (37.8078990313873, -122.410072157724) | |||
| 177294 | 177294 | 117411 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6010025.48749 | 2122284.08208 | 37.807952513162 | -122.409631131072 | (37.807952513162, -122.409631131072) | |||
| 181152 | 181152 | 117406 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009939.615230001 | 2122273.14447 | 37.8079176689433 | -122.40992754223998 | (37.8079176689433, -122.40992754224) | |||
| 188715 | 188715 | 117410 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010007.96728 | 2122282.37389 | 37.8079468411282 | -122.40969164376999 | (37.8079468411282, -122.40969164377) | |||
| 171886 | 171886 | 224898 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007216.8564 | 2097735.11711 | 37.7403891304638 | -122.417610047575 | (37.7403891304638, -122.417610047575) | |||
| 115392 | 115392 | 104839 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 117267 | 117267 | 104840 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 118152 | 118152 | 104836 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 143505 | 143505 | 104838 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770743 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | |||
| 144715 | 144715 | 104837 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Clover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294523999 | (37.7604676378061, -122.44149294524) | ||||
| 55157 | 55157 | 226554 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6005308.93947 | 2105898.30833 | 37.7626958209718 | -122.424787472081 | (37.7626958209718, -122.424787472081) | |||
| 66349 | 66349 | 224335 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6005384.57278 | 2103655.80325 | 37.75654270088761 | -122.424366375327 | (37.7565427008876, -122.424366375327) | |||
| 188992 | 188992 | 224334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005384.8818 | 2103641.26634 | 37.756502803379 | -122.42436427271099 | (37.756502803379, -122.424364272711) | |||
| 13456 | 13456 | 100270 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015164.42669 | 2113486.59389 | 37.7840832865491 | -122.39123103259399 | (37.7840832865491, -122.391231032594) | |||
| 13549 | 13549 | 100271 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1x1 | 6015178.9141 | 2113499.10422 | 37.7841184410568 | -122.391181785729 | (37.7841184410568, -122.391181785729) | |||
| 13875 | 13875 | 100273 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015216.1617 | 2113535.8467 | 37.7842213945326 | -122.391055490318 | (37.7842213945326, -122.391055490318) | |||
| 13921 | 13921 | 100267 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015119.18661 | 2113440.6394599997 | 37.783954595377104 | -122.391384334617 | (37.7839545953771, -122.391384334617) | |||
| 14073 | 14073 | 100266 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 1x1 | Permit Number 779105 | 6015095.83494 | 2113421.2206 | 37.783899979542106 | -122.391463765467 | (37.7838999795421, -122.391463765467) | |
| 14907 | 14907 | 100268 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015133.4862 | 2113455.2111 | 37.7839953994148 | -122.391335881848 | (37.7839953994148, -122.391335881848) | |||
| 15776 | 15776 | 100272 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015193.569569999 | 2113513.1652900004 | 37.7841578628497 | -122.391132065814 | (37.7841578628497, -122.391132065814) | |||
| 16467 | 16467 | 100269 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015149.19988 | 2113471.58342 | 37.78404122616921 | -122.391282662663 | (37.7840412261692, -122.391282662663) | |||
| 16663 | 16663 | 100274 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015236.2818 | 2113554.4161799997 | 37.7842734985691 | -122.390987179627 | (37.7842734985691, -122.390987179627) | |||
| 54178 | 54178 | 128765 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6011541.73993 | 2114932.31126 | 37.7878511752459 | -122.403866057667 | (37.7878511752459, -122.403866057667) | |||
| 168101 | 168101 | 128766 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011589.16862 | 2114937.89036 | 37.7878691437046 | -122.40370235498699 | (37.7878691437046, -122.403702354987) | |||
| 184508 | 184508 | 128764 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6011518.67588 | 2114929.1813 | 37.7878412925773 | -122.4039456351 | (37.7878412925773, -122.4039456351) | |||
| 60281 | 60281 | 202078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Gould St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012742.601 | 2090834.0731400002 | 37.721749674703496 | -122.398020073164 | (37.7217496747035, -122.398020073164) | ||||
| 160042 | 160042 | 128763 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6011215.3339 | 2114610.75087 | 37.7869500059829 | -122.40497271843999 | (37.7869500059829, -122.40497271844) | |||
| 163131 | 163131 | 53585 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1988 12:00:00 AM | 4 | Permit Number 25654 | 6011212.0251400005 | 2114649.83108 | 37.787057126029204 | -122.404986918715 | (37.7870571260292, -122.404986918715) | ||
| 177848 | 177848 | 128762 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6011213.77667 | 2114631.44944 | 37.787006752307796 | -122.404979564051 | (37.7870067523078, -122.404979564051) | |||
| 127276 | 127276 | 189776 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Jack Balestreri Way | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012433.20724 | 2104795.86153 | 37.760068555049 | -122.400069588557 | (37.760068555049, -122.400069588557) | ||||
| 82125 | 82125 | 128247 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012050.078290001 | 2120824.85682 | 37.804059079134895 | -122.402521806838 | (37.8040590791349, -122.402521806838) | |||
| 134656 | 134656 | 128248 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6012077.7495 | 2120826.8863 | 37.8040661963559 | -122.40242619091299 | (37.8040661963559, -122.402426190913) | |||
| 169574 | 169574 | 128246 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6012027.5986 | 2120822.12405 | 37.8040503206142 | -122.40259940753799 | (37.8040503206142, -122.402599407538) | |||
| 181400 | 181400 | 57995 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1977 12:00:00 AM | 9 | Permit Number 16960 | 6012006.11547 | 2120819.17125 | 37.8040410135332 | -122.40267354405199 | (37.8040410135332, -122.402673544052) | ||
| 183368 | 183368 | 226501 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005629.7057300005 | 2108993.07475 | 37.7712114241035 | -122.42389812981199 | (37.7712114241035, -122.423898129812) | |||
| 2209 | 2209 | 189798 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6010293.93626 | 2108038.50565 | 37.7688526102954 | -122.407696978027 | (37.7688526102954, -122.407696978027) | |||
| 45884 | 45884 | 189797 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010301.761080001 | 2107987.1823400003 | 37.7687121262868 | -122.407666293181 | (37.7687121262868, -122.407666293181) | |||
| 23790 | 23790 | 226568 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6006429.16077 | 2099860.9087400003 | 37.7461817204111 | -122.420484448999 | (37.7461817204111, -122.420484448999) | |||
| 47360 | 47360 | 226570 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Tiffany Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6006445.57386 | 2099890.14518 | 37.746262921995296 | -122.420429769337 | (37.7462629219953, -122.420429769337) | |||
| 157769 | 157769 | 226572 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Tiffany Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 6006471.88526 | 2099931.8525799997 | 37.7463789237643 | -122.4203417473 | (37.7463789237643, -122.4203417473) | |||
| 180409 | 180409 | 226571 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Tiffany Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6006456.74675 | 2099908.35121 | 37.746313541251 | -122.42039242678999 | (37.746313541251, -122.42039242679) | |||
| 181627 | 181627 | 226569 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6006436.80872 | 2099876.49874 | 37.7462249580153 | -122.420459109705 | (37.7462249580153, -122.420459109705) | |||
| 3064 | 3064 | 104743 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010761.049240001 | 2116971.9366099997 | 37.7934078523287 | -122.406710911 | (37.7934078523287, -122.406710911) | |||
| 3067 | 3067 | 104742 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010759.24365 | 2116982.20549 | 37.793435947175205 | -122.406717882525 | (37.7934359471752, -122.406717882525) | |||
| 3069 | 3069 | 128380 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010746.0 | 2116993.0 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | |||
| 31156 | 31156 | 127591 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008103.92464 | 2114232.00134 | 37.7857356352375 | -122.415710691104 | (37.7857356352375, -122.415710691104) | |||
| 55858 | 55858 | 127588 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008108.503219999 | 2114196.51357 | 37.785638451808 | -122.415692336847 | (37.785638451808, -122.415692336847) | |||
| 63773 | 63773 | 127590 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008105.8459 | 2114222.18879 | 37.785708800357206 | -122.415703349037 | (37.7857088003572, -122.415703349037) | |||
| 125310 | 125310 | 127589 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008107.8914 | 2114205.50668 | 37.785663110314495 | -122.415695090562 | (37.7856631103145, -122.415695090562) | |||
| 154366 | 154366 | 127587 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008110.44045 | 2114187.49332 | 37.7856137932875 | -122.415684995662 | (37.7856137932875, -122.415684995662) | |||
| 164419 | 164419 | 127592 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008097.225330001 | 2114267.53253 | 37.7858328186666 | -122.41573638563999 | (37.7858328186666, -122.41573638564) | |||
| 177403 | 177403 | 127593 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008096.0506 | 2114287.89465 | 37.78588866207 | -122.415741892192 | (37.78588866207, -122.415741892192) | |||
| 187514 | 187514 | 127586 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Ada Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008112.096419999 | 2114177.6862 | 37.7855869584016 | -122.41567857183 | (37.7855869584016, -122.41567857183) | |||
| 182984 | 182984 | 190325 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012855.748430001 | 2114136.37935 | 37.785739053555496 | -122.39926390751499 | (37.7857390535555, -122.399263907515) | |||
| 57182 | 57182 | 128320 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Icehouse Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012146.841630001 | 2119697.8731299997 | 37.800970057189495 | -122.40210766993 | (37.8009700571895, -122.40210766993) | |||
| 137943 | 137943 | 128321 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Icehouse Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012136.96305 | 2119766.3197 | 37.801157443519394 | -122.402146669057 | (37.8011574435194, -122.402146669057) | |||
| 76190 | 76190 | 36891 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 8 | Permit Number 39545 | 5998941.55957 | 2116543.3234900003 | 37.7915626017771 | -122.447576181201 | (37.7915626017771, -122.447576181201) | |
| 137354 | 137354 | 127206 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998939.3963 | 2116555.38968 | 37.7915956087108 | -122.447584535009 | (37.7915956087108, -122.447584535009) | |||
| 164756 | 164756 | 36892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39545 | 5998941.54083 | 2116530.8219 | 37.7915282746499 | -122.44757534573799 | (37.7915282746499, -122.447575345738) | |
| 53347 | 53347 | 124215 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996301.66072 | 2112194.98742 | 37.7794720113504 | -122.456395579587 | (37.7794720113504, -122.456395579587) | |||
| 40912 | 40912 | 120175 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5987734.5845 | 2115254.5209 | 37.7873770771644 | -122.486257025031 | (37.7873770771644, -122.486257025031) | |||
| 70681 | 70681 | 120176 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987736.19822 | 2115226.27808 | 37.7872996245264 | -122.48624936779301 | (37.7872996245264, -122.486249367793) | |||
| 187079 | 187079 | 64239 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/1988 12:00:00 AM | 6 | Permit Number 25032 | 5987737.4253 | 2115200.68824 | 37.7872294336752 | -122.48624324308099 | (37.7872294336752, -122.486243243081) | ||
| 44127 | 44127 | 128254 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6012679.0974 | 2118890.69446 | 37.7987834320661 | -122.40020910399099 | (37.7987834320661, -122.400209103991) | |||
| 49028 | 49028 | 128256 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6012622.23236 | 2118878.54826 | 37.7987469105978 | -122.40040502308001 | (37.7987469105978, -122.40040502308) | |||
| 160992 | 160992 | 128253 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6012699.0130199995 | 2118889.69458 | 37.79878179709571 | -122.400140118797 | (37.7987817970957, -122.400140118797) | |||
| 178279 | 178279 | 128255 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6012646.6409599995 | 2118882.81714 | 37.7987599930341 | -122.40032086091999 | (37.7987599930341, -122.40032086092) | |||
| 179868 | 179868 | 52836 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 16 | 4x4 | Permit Number 48854 | 6012723.25887 | 2118895.7535200003 | 37.7987997853444 | -122.40005664549999 | (37.7987997853444, -122.4000566455) | |
| 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) | |||
| 7160 | 7160 | 4592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.079390001 | 2118088.92644 | 37.796510626729706 | -122.40457501395299 | (37.7965106267297, -122.404575013953) | ||
| 8446 | 8446 | 11434 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | |||
| 45978 | 45978 | 192082 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6010763.57964 | 2108352.74892 | 37.7697417295295 | -122.406094647871 | (37.7697417295295, -122.406094647871) | |||
| 62786 | 62786 | 192083 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Division St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6010748.49294 | 2108351.6927400003 | 37.7697379856565 | -122.406146758174 | (37.7697379856565, -122.406146758174) | |||
| 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) | |||
| 21578 | 21578 | 5327 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004755.67064 | 2107733.77413 | 37.7677043064343 | -122.426831755188 | (37.7677043064343, -122.426831755188) | |||
| 42599 | 42599 | 190131 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6011654.92131 | 2097288.97497 | 37.7394128516087 | -122.402233521954 | (37.7394128516087, -122.402233521954) | |||
| 51824 | 51824 | 190130 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6011690.7758 | 2097300.73442 | 37.7394471418669 | -122.40211037869301 | (37.7394471418669, -122.402110378693) | |||
| 58659 | 58659 | 190129 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011744.4272 | 2097318.12593 | 37.739497889703 | -122.401926096826 | (37.739497889703, -122.401926096826) | |||
| 61191 | 61191 | 190128 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6011796.42353 | 2097334.30265 | 37.7395452093339 | -122.40174745189199 | (37.7395452093339, -122.401747451892) | |||
| 154576 | 154576 | 190132 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011496.4373 | 2097233.7856099997 | 37.7392524656321 | -122.402777612703 | (37.7392524656321, -122.402777612703) | |||
| 33629 | 33629 | 190203 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6014289.71306 | 2116512.0501099997 | 37.7923419084079 | -122.394469165733 | (37.7923419084079, -122.394469165733) | |||
| 46525 | 46525 | 190200 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6014315.19536 | 2116534.70436 | 37.7924055282487 | -122.39438258260901 | (37.7924055282487, -122.394382582609) | |||
| 55908 | 55908 | 190199 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6014321.03295 | 2116541.14366 | 37.792423533565795 | -122.394362835301 | (37.7924235335658, -122.394362835301) | |||
| 64400 | 64400 | 190198 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6014331.7928 | 2116550.66298 | 37.7924502695099 | -122.394326272441 | (37.7924502695099, -122.394326272441) | |||
| 68827 | 68827 | 190202 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6014298.64009 | 2116519.30136 | 37.792362314907606 | -122.394438785721 | (37.7923623149076, -122.394438785721) |
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");