trees
5,599 rows where qSpecies_id = 38 sorted by qAddress
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25086 | 189675 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 10 | : Yard | Tree | Private 2 | 8 | 6017194.50129 | 2102669.93128 | 37.7544955147815 | -122.383454393407 | (37.7544955147815, -122.383454393407) | 10 | 3 | 8 | 28856 | 29 | ||||
| 86101 | 189677 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 14 | : Yard | Tree | Private 2 | 9 | 6017255.58244 | 2102660.6719 | 37.7544734661028 | -122.383242512238 | (37.7544734661028, -122.383242512238) | 10 | 3 | 8 | 28856 | 29 | ||||
| 117845 | 189679 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 20 | : Yard | Tree | Private 2 | 12 | 6017238.94696 | 2102621.26617 | 37.7543643468473 | -122.383297299846 | (37.7543643468473, -122.383297299846) | 10 | 3 | 8 | 28856 | 29 | ||||
| 129212 | 189680 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 21 | : Yard | Tree | Private 2 | 9 | 6017213.38014 | 2102597.10976 | 37.7542966054277 | -122.383384035867 | (37.7542966054277, -122.383384035867) | 10 | 3 | 8 | 28856 | 29 | ||||
| 186362 | 189676 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 11 | : Yard | Tree | Private 2 | 11 | 6017209.44087 | 2102637.39107 | 37.7544069918113 | -122.383400462871 | (37.7544069918113, -122.383400462871) | 10 | 3 | 8 | 28856 | 29 | ||||
| 186451 | 189678 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 19 | : Yard | Tree | Private 2 | 15 | 6017295.34569 | 2102596.83049 | 37.7543003681831 | -122.383100556043 | (37.7543003681831, -122.383100556043) | 10 | 3 | 8 | 28856 | 29 | ||||
| 43333 | 117409 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009993.98375 | 2122279.70822 | 37.8079387382549 | -122.409739849211 | (37.8079387382549, -122.409739849211) | 3 | 1 | 10 | 308 | 23 | |||
| 54399 | 117407 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009960.43045 | 2122276.55632 | 37.8079282035823 | -122.409855746669 | (37.8079282035823, -122.409855746669) | 3 | 1 | 10 | 308 | 23 | |||
| 70492 | 117408 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009980.02428 | 2122278.22216 | 37.807933875624 | -122.409788054695 | (37.807933875624, -122.409788054695) | 3 | 1 | 10 | 308 | 23 | |||
| 81605 | 117415 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6010118.81969 | 2122297.52404 | 37.8079946509093 | -122.409309079351 | (37.8079946509093, -122.409309079351) | 3 | 1 | 10 | 308 | 23 | |||
| 85426 | 117414 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010099.51598 | 2122295.55675 | 37.807988167691 | -122.409375746091 | (37.807988167691, -122.409375746091) | 3 | 1 | 10 | 308 | 23 | |||
| 130874 | 117404 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009897.70698 | 2122267.21212 | 37.8078990313873 | -122.410072157724 | (37.8078990313873, -122.410072157724) | 3 | 1 | 10 | 308 | 23 | |||
| 138128 | 117406 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009939.61523 | 2122273.14447 | 37.8079176689433 | -122.40992754224 | (37.8079176689433, -122.40992754224) | 3 | 1 | 10 | 308 | 23 | |||
| 148646 | 117411 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6010025.48749 | 2122284.08208 | 37.807952513162 | -122.409631131072 | (37.807952513162, -122.409631131072) | 3 | 1 | 10 | 308 | 23 | |||
| 158840 | 117410 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6010007.96728 | 2122282.37389 | 37.8079468411282 | -122.40969164377 | (37.8079468411282, -122.40969164377) | 3 | 1 | 10 | 308 | 23 | |||
| 159976 | 117413 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010079.00319 | 2122292.43405 | 37.8079784442232 | -122.409446515568 | (37.8079784442232, -122.409446515568) | 3 | 1 | 10 | 308 | 23 | |||
| 178721 | 117405 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009914.43975 | 2122269.24746 | 37.8079055577548 | -122.410014393348 | (37.8079055577548, -122.410014393348) | 3 | 1 | 10 | 308 | 23 | |||
| 178782 | 117412 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6010061.45891 | 2122289.54556 | 37.8079695301268 | -122.409507028246 | (37.8079695301268, -122.409507028246) | 3 | 1 | 10 | 308 | 23 | |||
| 188879 | 117416 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Beach St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6010137.82727 | 2122299.49705 | 37.8080011332052 | -122.409243437841 | (37.8080011332052, -122.409243437841) | 3 | 1 | 10 | 308 | 23 | |||
| 141780 | 104839 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Clover St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294524 | (37.7604676378061, -122.44149294524) | 2 | 4 | 5 | 28862 | 3 | ||||
| 163961 | 104836 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Clover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294524 | (37.7604676378061, -122.44149294524) | 2 | 4 | 5 | 28862 | 3 | ||||
| 168047 | 104840 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Clover St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294524 | (37.7604676378061, -122.44149294524) | 2 | 4 | 5 | 28862 | 3 | ||||
| 175917 | 104838 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Clover St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770743 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294524 | (37.7604676378061, -122.44149294524) | 2 | 4 | 5 | 28862 | 3 | |||
| 185988 | 104837 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Clover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000464.1 | 2105186.9 | 37.7604676378061 | -122.44149294524 | (37.7604676378061, -122.44149294524) | 2 | 4 | 5 | 28862 | 3 | ||||
| 187075 | 226554 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6005308.93947 | 2105898.30833 | 37.7626958209718 | -122.424787472081 | (37.7626958209718, -122.424787472081) | 8 | 4 | 5 | 28859 | 19 | |||
| 90337 | 224334 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005384.8818 | 2103641.26634 | 37.756502803379 | -122.424364272711 | (37.756502803379, -122.424364272711) | 2 | 4 | 5 | 28859 | 19 | |||
| 168683 | 224335 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005384.57278 | 2103655.80325 | 37.7565427008876 | -122.424366375327 | (37.7565427008876, -122.424366375327) | 2 | 4 | 5 | 28859 | 19 | |||
| 2982 | 100269 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015149.19988 | 2113471.58342 | 37.7840412261692 | -122.391282662663 | (37.7840412261692, -122.391282662663) | 6 | 2 | 9 | 28856 | 6 | |||
| 27303 | 100273 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015216.1617 | 2113535.8467 | 37.7842213945326 | -122.391055490318 | (37.7842213945326, -122.391055490318) | 6 | 2 | 9 | 28856 | 6 | |||
| 47017 | 100268 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015133.4862 | 2113455.2111 | 37.7839953994148 | -122.391335881848 | (37.7839953994148, -122.391335881848) | 6 | 2 | 9 | 28856 | 6 | |||
| 65975 | 100272 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015193.56957 | 2113513.16529 | 37.7841578628497 | -122.391132065814 | (37.7841578628497, -122.391132065814) | 6 | 2 | 9 | 28856 | 6 | |||
| 75484 | 100271 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 1x1 | 6015178.9141 | 2113499.10422 | 37.7841184410568 | -122.391181785729 | (37.7841184410568, -122.391181785729) | 6 | 2 | 9 | 28856 | 6 | |||
| 90814 | 100266 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 12:00:00 AM | 3 | 1x1 | Permit Number 779105 | 6015095.83494 | 2113421.2206 | 37.7838999795421 | -122.391463765467 | (37.7838999795421, -122.391463765467) | 6 | 2 | 9 | 28856 | 6 | |
| 90950 | 100267 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015119.18661 | 2113440.63946 | 37.7839545953771 | -122.391384334617 | (37.7839545953771, -122.391384334617) | 6 | 2 | 9 | 28856 | 6 | |||
| 160742 | 100270 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015164.42669 | 2113486.59389 | 37.7840832865491 | -122.391231032594 | (37.7840832865491, -122.391231032594) | 6 | 2 | 9 | 28856 | 6 | |||
| 185295 | 100274 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015236.2818 | 2113554.41618 | 37.7842734985691 | -122.390987179627 | (37.7842734985691, -122.390987179627) | 6 | 2 | 9 | 28856 | 6 | |||
| 99583 | 128766 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011589.16862 | 2114937.89036 | 37.7878691437046 | -122.403702354987 | (37.7878691437046, -122.403702354987) | 5 | 1 | 10 | 28857 | 6 | |||
| 157547 | 128764 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011518.67588 | 2114929.1813 | 37.7878412925773 | -122.4039456351 | (37.7878412925773, -122.4039456351) | 5 | 1 | 10 | 28857 | 6 | |||
| 187017 | 128765 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011541.73993 | 2114932.31126 | 37.7878511752459 | -122.403866057667 | (37.7878511752459, -122.403866057667) | 5 | 1 | 10 | 28857 | 6 | |||
| 119595 | 202078 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Gould St | 7 | Front Yard : Yard | Tree | Private 2 | 15 | 6012742.601 | 2090834.07314 | 37.7217496747035 | -122.398020073164 | (37.7217496747035, -122.398020073164) | 10 | 3 | 8 | 58 | 1 | ||||
| 27398 | 53585 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1988 12:00:00 AM | 4 | Permit Number 25654 | 6011212.02514 | 2114649.83108 | 37.7870571260292 | -122.404986918715 | (37.7870571260292, -122.404986918715) | 5 | 10 | 10 | 28857 | 6 | ||
| 133542 | 128763 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Grant Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6011215.3339 | 2114610.75087 | 37.7869500059829 | -122.40497271844 | (37.7869500059829, -122.40497271844) | 5 | 10 | 10 | 28857 | 6 | |||
| 163924 | 128762 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Grant Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6011213.77667 | 2114631.44944 | 37.7870067523078 | -122.404979564051 | (37.7870067523078, -122.404979564051) | 5 | 10 | 10 | 28857 | 6 | |||
| 160046 | 189776 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Jack Balestreri Way | 42 | Front Yard : Yard | Tree | Private 2 | 5 | 6012433.20724 | 2104795.86153 | 37.760068555049 | -122.400069588557 | (37.760068555049, -122.400069588557) | 10 | 3 | 8 | 28856 | 29 | ||||
| 43161 | 128247 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012050.07829 | 2120824.85682 | 37.8040590791349 | -122.402521806838 | (37.8040590791349, -122.402521806838) | 3 | 1 | 10 | 28860 | 6 | |||
| 106910 | 57995 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1977 12:00:00 AM | 9 | Permit Number 16960 | 6012006.11547 | 2120819.17125 | 37.8040410135332 | -122.402673544052 | (37.8040410135332, -122.402673544052) | 3 | 1 | 10 | 28860 | 6 | ||
| 152785 | 128246 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012027.5986 | 2120822.12405 | 37.8040503206142 | -122.402599407538 | (37.8040503206142, -122.402599407538) | 3 | 1 | 10 | 28860 | 6 | |||
| 158660 | 128248 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012077.7495 | 2120826.8863 | 37.8040661963559 | -122.402426190913 | (37.8040661963559, -122.402426190913) | 3 | 1 | 10 | 28860 | 6 | |||
| 114748 | 226501 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Pearl St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6005629.70573 | 2108993.07475 | 37.7712114241035 | -122.423898129812 | (37.7712114241035, -122.423898129812) | 8 | 2 | 5 | 28853 | 19 | |||
| 49917 | 189797 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010301.76108 | 2107987.18234 | 37.7687121262868 | -122.407666293181 | (37.7687121262868, -122.407666293181) | 8 | 4 | 8 | 28853 | 19 | |||
| 96809 | 189798 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 3ft | 6010293.93626 | 2108038.50565 | 37.7688526102954 | -122.407696978027 | (37.7688526102954, -122.407696978027) | 8 | 4 | 8 | 28853 | 19 | |||
| 24650 | 226570 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Tiffany Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6006445.57386 | 2099890.14518 | 37.7462629219953 | -122.420429769337 | (37.7462629219953, -122.420429769337) | 2 | 7 | 7 | 28859 | 2 | |||
| 38751 | 226569 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6006436.80872 | 2099876.49874 | 37.7462249580153 | -122.420459109705 | (37.7462249580153, -122.420459109705) | 2 | 7 | 7 | 28859 | 2 | |||
| 53837 | 226572 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Tiffany Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 6006471.88526 | 2099931.85258 | 37.7463789237643 | -122.4203417473 | (37.7463789237643, -122.4203417473) | 2 | 7 | 7 | 28859 | 2 | |||
| 82360 | 226571 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Tiffany Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6006456.74675 | 2099908.35121 | 37.746313541251 | -122.42039242679 | (37.746313541251, -122.42039242679) | 2 | 7 | 7 | 28859 | 2 | |||
| 149610 | 226568 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6006429.16077 | 2099860.90874 | 37.7461817204111 | -122.420484448999 | (37.7461817204111, -122.420484448999) | 2 | 7 | 7 | 28859 | 2 | |||
| 90821 | 104743 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Waverly Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010761.04924 | 2116971.93661 | 37.7934078523287 | -122.406710911 | (37.7934078523287, -122.406710911) | 3 | 1 | 10 | 28857 | 4 | |||
| 158274 | 104742 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Waverly Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010759.24365 | 2116982.20549 | 37.7934359471752 | -122.406717882525 | (37.7934359471752, -122.406717882525) | 3 | 1 | 10 | 28857 | 4 | |||
| 38183 | 127590 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008105.8459 | 2114222.18879 | 37.7857088003572 | -122.415703349037 | (37.7857088003572, -122.415703349037) | 13 | 10 | 9 | 28858 | 36 | |||
| 49754 | 127588 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008108.50322 | 2114196.51357 | 37.785638451808 | -122.415692336847 | (37.785638451808, -122.415692336847) | 13 | 10 | 9 | 28858 | 36 | |||
| 51360 | 127593 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008096.0506 | 2114287.89465 | 37.78588866207 | -122.415741892192 | (37.78588866207, -122.415741892192) | 13 | 10 | 9 | 28858 | 36 | |||
| 125944 | 127586 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008112.09642 | 2114177.6862 | 37.7855869584016 | -122.41567857183 | (37.7855869584016, -122.41567857183) | 13 | 10 | 9 | 28858 | 36 | |||
| 130457 | 127587 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008110.44045 | 2114187.49332 | 37.7856137932875 | -122.415684995662 | (37.7856137932875, -122.415684995662) | 13 | 10 | 9 | 28858 | 36 | |||
| 131931 | 127592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008097.22533 | 2114267.53253 | 37.7858328186666 | -122.41573638564 | (37.7858328186666, -122.41573638564) | 13 | 10 | 9 | 28858 | 36 | |||
| 145917 | 127591 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008103.92464 | 2114232.00134 | 37.7857356352375 | -122.415710691104 | (37.7857356352375, -122.415710691104) | 13 | 10 | 9 | 28858 | 36 | |||
| 182453 | 127589 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008107.8914 | 2114205.50668 | 37.7856631103145 | -122.415695090562 | (37.7856631103145, -122.415695090562) | 13 | 10 | 9 | 28858 | 36 | |||
| 92054 | 190325 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012855.74843 | 2114136.37935 | 37.7857390535555 | -122.399263907515 | (37.7857390535555, -122.399263907515) | 6 | 2 | 9 | 28853 | 6 | |||
| 58216 | 128320 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Icehouse Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012146.84163 | 2119697.87313 | 37.8009700571895 | -122.40210766993 | (37.8009700571895, -122.40210766993) | 3 | 1 | 10 | 28860 | 6 | |||
| 159212 | 128321 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Icehouse Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012136.96305 | 2119766.3197 | 37.8011574435194 | -122.402146669057 | (37.8011574435194, -122.402146669057) | 3 | 1 | 10 | 28860 | 6 | |||
| 21971 | 36892 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39545 | 5998941.54083 | 2116530.8219 | 37.7915282746499 | -122.447575345738 | (37.7915282746499, -122.447575345738) | 13 | 6 | 1 | 29490 | 31 | |
| 82761 | 36891 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 8 | Permit Number 39545 | 5998941.55957 | 2116543.32349 | 37.7915626017771 | -122.447576181201 | (37.7915626017771, -122.447576181201) | 13 | 6 | 1 | 29490 | 31 | |
| 139837 | 127206 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998939.3963 | 2116555.38968 | 37.7915956087108 | -122.447584535009 | (37.7915956087108, -122.447584535009) | 13 | 6 | 1 | 29490 | 31 | |||
| 50158 | 124215 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5996301.66072 | 2112194.98742 | 37.7794720113504 | -122.456395579587 | (37.7794720113504, -122.456395579587) | 11 | 6 | 2 | 54 | 16 | |||
| 58396 | 120175 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5987734.5845 | 2115254.5209 | 37.7873770771644 | -122.486257025031 | (37.7873770771644, -122.486257025031) | 11 | 6 | 1 | 55 | 33 | |||
| 60533 | 120176 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987736.19822 | 2115226.27808 | 37.7872996245264 | -122.486249367793 | (37.7872996245264, -122.486249367793) | 11 | 6 | 1 | 55 | 33 | |||
| 113357 | 64239 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/1988 12:00:00 AM | 6 | Permit Number 25032 | 5987737.4253 | 2115200.68824 | 37.7872294336752 | -122.486243243081 | (37.7872294336752, -122.486243243081) | 11 | 6 | 1 | 55 | 33 | ||
| 50679 | 128256 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6012622.23236 | 2118878.54826 | 37.7987469105978 | -122.40040502308 | (37.7987469105978, -122.40040502308) | 3 | 1 | 10 | 28860 | 6 | |||
| 112613 | 128254 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6012679.0974 | 2118890.69446 | 37.7987834320661 | -122.400209103991 | (37.7987834320661, -122.400209103991) | 3 | 1 | 10 | 28860 | 6 | |||
| 125222 | 52836 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2006 12:00:00 AM | 16 | 4x4 | Permit Number 48854 | 6012723.25887 | 2118895.75352 | 37.7987997853444 | -122.4000566455 | (37.7987997853444, -122.4000566455) | 3 | 1 | 10 | 28860 | 6 | |
| 186164 | 128253 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6012699.01302 | 2118889.69458 | 37.7987817970957 | -122.400140118797 | (37.7987817970957, -122.400140118797) | 3 | 1 | 10 | 28860 | 6 | |||
| 187483 | 128255 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6012646.64096 | 2118882.81714 | 37.7987599930341 | -122.40032086092 | (37.7987599930341, -122.40032086092) | 3 | 1 | 10 | 28860 | 6 | |||
| 163635 | 224841 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5997991.47518 | 2107190.00433 | 37.7658264788437 | -122.450188962655 | (37.7658264788437, -122.450188962655) | 15 | 5 | 11 | 29492 | 9 | |||
| 117005 | 4592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.07939 | 2118088.92644 | 37.7965106267297 | -122.404575013953 | (37.7965106267297, -122.404575013953) | 3 | 1 | 10 | 308 | 4 | ||
| 149967 | 11434 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | 3 | 1 | 10 | 308 | 4 | |||
| 100656 | 128513 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013405.74871 | 2117047.94352 | 37.7937641655299 | -122.397565326504 | (37.7937641655299, -122.397565326504) | 4 | 1 | 10 | 28860 | 6 | |||
| 117681 | 128515 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013386.38334 | 2117177.12164 | 37.7941177798634 | -122.397641397444 | (37.7941177798634, -122.397641397444) | 4 | 1 | 10 | 28860 | 6 | |||
| 146535 | 128514 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013403.88227 | 2117064.60421 | 37.7938098079303 | -122.397572953653 | (37.7938098079303, -122.397572953653) | 4 | 1 | 10 | 28860 | 6 | |||
| 170111 | 128512 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013407.82551 | 2117029.53119 | 37.7937137252513 | -122.397556848585 | (37.7937137252513, -122.397556848585) | 4 | 1 | 10 | 28860 | 6 | |||
| 173141 | 128516 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013382.889 | 2117199.90316 | 37.7941801379622 | -122.397655086937 | (37.7941801379622, -122.397655086937) | 4 | 1 | 10 | 28860 | 6 | |||
| 178460 | 128517 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Davis St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013378.41738 | 2117243.32943 | 37.7942991272495 | -122.39767360667 | (37.7942991272495, -122.39767360667) | 4 | 1 | 10 | 28860 | 6 | |||
| 48207 | 192083 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Division St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6010748.49294 | 2108351.69274 | 37.7697379856565 | -122.406146758174 | (37.7697379856565, -122.406146758174) | 14 | 4 | 9 | 28853 | 34 | |||
| 169954 | 192081 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6010776.89946 | 2108351.11409 | 37.769737985659 | -122.406048459576 | (37.769737985659, -122.406048459576) | 14 | 4 | 9 | 28853 | 34 | |||
| 184233 | 192082 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Division St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010763.57964 | 2108352.74892 | 37.7697417295295 | -122.406094647871 | (37.7697417295295, -122.406094647871) | 14 | 4 | 9 | 28853 | 34 | |||
| 166830 | 5327 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004755.67064 | 2107733.77413 | 37.7677043064343 | -122.426831755188 | (37.7677043064343, -122.426831755188) | 8 | 4 | 5 | 28862 | 3 | |||
| 33471 | 190128 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Industrial St | 4 | : | Tree | Private 2 | 8 | Width 4ft | 6011796.42353 | 2097334.30265 | 37.7395452093339 | -122.401747451892 | (37.7395452093339, -122.401747451892) | 10 | 3 | 8 | 58 | 1 | |||
| 47647 | 190129 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Industrial St | 5 | : | Tree | Private 2 | 4 | Width 4ft | 6011744.4272 | 2097318.12593 | 37.739497889703 | -122.401926096826 | (37.739497889703, -122.401926096826) | 10 | 3 | 8 | 58 | 1 | |||
| 72290 | 190130 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Industrial St | 6 | : | Tree | Private 2 | 6 | Width 4ft | 6011690.7758 | 2097300.73442 | 37.7394471418669 | -122.402110378693 | (37.7394471418669, -122.402110378693) | 10 | 3 | 8 | 58 | 1 | |||
| 182422 | 190131 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Industrial St | 7 | : | Tree | Private 2 | 5 | Width 4ft | 6011654.92131 | 2097288.97497 | 37.7394128516087 | -122.402233521954 | (37.7394128516087, -122.402233521954) | 10 | 3 | 8 | 58 | 1 | |||
| 186547 | 190132 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Industrial St | 10 | : | Tree | Private 2 | 4 | Width 4ft | 6011496.4373 | 2097233.78561 | 37.7392524656321 | -122.402777612703 | (37.7392524656321, -122.402777612703) | 10 | 3 | 8 | 58 | 1 | |||
| 35194 | 190199 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014321.03295 | 2116541.14366 | 37.7924235335658 | -122.394362835301 | (37.7924235335658, -122.394362835301) | 12 | 2 | 9 | 28855 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );