trees
163,064 rows where qCaretaker_id = 2 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3801 | 183067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2642 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | SFUSD | 8 | Width 0ft | 5983405.3697 | 2096822.8928 | 37.736515769554 | -122.499872058038 | (37.736515769554, -122.499872058038) | 1 | 8 | 3 | 29491 | 35 | ||
25159 | 116139 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 11 | 6009237.30915 | 2116708.08381 | 37.7925980056535 | -122.411964529145 | (37.7925980056535, -122.411964529145) | 5 | 1 | 10 | 28857 | 21 | |||
26078 | 103365 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009208.54849 | 2116702.78378 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | 5 | 1 | 10 | 28857 | 21 | ||
26865 | 103362 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009111.87446 | 2116690.26678 | 37.7925420462198 | -122.412397279316 | (37.7925420462198, -122.412397279316) | 5 | 1 | 10 | 28857 | 21 | ||
50482 | 103357 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
51920 | 103361 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
70238 | 103355 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
74442 | 103359 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
87854 | 103360 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
122696 | 103363 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.7925553112212 | -122.412292370693 | (37.7925553112212, -122.412292370693) | 5 | 1 | 10 | 28857 | 21 | ||
153064 | 103364 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.7925702336697 | -122.412185363057 | (37.7925702336697, -122.412185363057) | 5 | 1 | 10 | 28857 | 21 | ||
168063 | 103358 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
174866 | 103356 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
177428 | 103354 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
182306 | 103352 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
190388 | 103353 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
14929 | 256105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1935 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 09/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778629 | 5985666.45669 | 2102048.38182 | 37.7509959848908 | -122.492439326416 | (37.7509959848908, -122.492439326416) | 1 | 8 | 3 | 29491 | 35 |
56573 | 108255 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1798X Washington St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 2x2 | 6006327.67988 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | 13 | 9 | 10 | 28858 | 32 | |||
88030 | 108259 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1798X Washington St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 2x2 | 6006327.67988 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | 13 | 9 | 10 | 28858 | 32 | |||
104693 | 108256 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1798X Washington St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 2x2 | 6006327.67988 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | 13 | 9 | 10 | 28858 | 32 | |||
127049 | 107717 | DPW Maintained 1 | Tree(s) :: 17 | 2400X 25th Ave | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Port | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789 | 2098909 | 37.7423832554664 | -122.491784477839 | (37.7423832554664, -122.491784477839) | 1 | 8 | 3 | 29491 | 35 |
130441 | 108258 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1798X Washington St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 2x2 | 6006327.67988 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | 13 | 9 | 10 | 28858 | 32 | |||
144404 | 108257 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1798X Washington St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 2x2 | 6006327.67988 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | 13 | 9 | 10 | 28858 | 32 | |||
156358 | 106963 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 14 | 5999920.02374 | 2118149.14648 | 37.7960276377095 | -122.444306168018 | (37.7960276377095, -122.444306168018) | 13 | 9 | 1 | 57 | 17 | |||
160693 | 108107 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1990X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 6004838 | 2115780 | 37.7898019192352 | -122.427120168027 | (37.7898019192352, -122.427120168027) | 13 | 9 | 1 | 28858 | 27 | ||||
166621 | 108254 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1798X Washington St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 2x2 | 6006327.67988 | 2116970.1583 | 37.7931539244622 | -122.422050592495 | (37.7931539244622, -122.422050592495) | 13 | 9 | 10 | 28858 | 32 | |||
171678 | 107716 | DPW Maintained 1 | Tree(s) :: 17 | 2400X 25th Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Port | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789 | 2098909 | 37.7423832554664 | -122.491784477839 | (37.7423832554664, -122.491784477839) | 1 | 8 | 3 | 29491 | 35 |
183181 | 108106 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1990X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 6004838 | 2115780 | 37.7898019192352 | -122.427120168027 | (37.7898019192352, -122.427120168027) | 13 | 9 | 1 | 28858 | 27 | ||||
7871 | 104619 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 7 | 4x4 | Permit Number 770959 | 6012190.226 | 2112753.6665 | 37.7819053332353 | -122.401469228728 | (37.7819053332353, -122.401469228728) | 6 | 2 | 9 | 28853 | 34 | |
38913 | 104620 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 10 | 4x4 | Permit Number 770959 | 6012183.3573 | 2112747.2558 | 37.7818873476901 | -122.401492540712 | (37.7818873476901, -122.401492540712) | 6 | 2 | 9 | 28853 | 34 | |
58757 | 104623 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 250 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.401967135301 | (37.7824643544146, -122.401967135301) | 6 | 2 | 9 | 28853 | 34 | ||
89067 | 104621 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 266-286X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 4x4 | Permit Number 770959 | 6012142 | 2112916 | 37.7823483723512 | -122.401647482717 | (37.7823483723512, -122.401647482717) | 6 | 2 | 9 | 28853 | 34 | ||
138581 | 104624 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 250 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.401967135301 | (37.7824643544146, -122.401967135301) | 6 | 2 | 9 | 28853 | 34 | ||
182081 | 104622 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 266-286X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 4x4 | Permit Number 770959 | 6012142 | 2112916 | 37.7823483723512 | -122.401647482717 | (37.7823483723512, -122.401647482717) | 6 | 2 | 9 | 28853 | 34 | ||
189727 | 104625 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 250 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 3x3 | Permit Number 770961 | 6012050.5 | 2112960.1 | 37.7824643544146 | -122.401967135301 | (37.7824643544146, -122.401967135301) | 6 | 2 | 9 | 28853 | 34 | ||
190530 | 104618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 8 | 4x4 | Permit Number 770959 | 6012200.3 | 2112763.2826 | 37.7819322989016 | -122.401435053146 | (37.7819322989016, -122.401435053146) | 6 | 2 | 9 | 28853 | 34 | |
168011 | 108643 | Undocumented 4 | Tree(s) :: 17 | 315X PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Housing Authority | 3x3 | 6012408.6 | 2118423 | 37.7974841688946 | -122.401112237555 | (37.7974841688946, -122.401112237555) | 3 | 1 | 10 | 28860 | 4 | |||
96879 | 251304 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1 Cashmere St | 3 | Back Yard : Yard | Tree | Private 2 | Health Dept | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | |||
8380 | 118286 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 199X JULES AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 3x3 | 5994418 | 2091201 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | 9 | 8 | 6 | 28861 | 24 | |||
45479 | 108934 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591 | (37.7386556931549, -122.42007742591) | 2 | 7 | 7 | 28859 | 2 |
133833 | 108521 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773668 | 5990944.21476 | 2102008.8699 | 37.7511946505392 | -122.474185618824 | (37.7511946505392, -122.474185618824) | 1 | 8 | 4 | 29491 | 12 |
143882 | 118285 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 199X JULES AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 3x3 | 5994418 | 2091201 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | 9 | 8 | 6 | 28861 | 24 | |||
158582 | 108904 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.412828714971 | (37.7361673058735, -122.412828714971) | 10 | 7 | 7 | 28859 | 2 |
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
18 | 50210 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 830 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 8 | Permit Number 46918 | 5987602.00308 | 2110288.94488 | 37.7737352840678 | -122.486351029235 | (37.7737352840678, -122.486351029235) | 11 | 6 | 2 | 55 | 26 | |
23 | 50211 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 834 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 9 | Permit Number 46919 | 5987605.33986 | 2110266.54313 | 37.7736739696217 | -122.486337841964 | (37.7736739696217, -122.486337841964) | 11 | 6 | 2 | 55 | 26 | |
25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
105 | 70839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 939 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010931.16123 | 2112337.60471 | 37.780692593337 | -122.405795716794 | (37.780692593337, -122.405795716794) | 14 | 2 | 9 | 28853 | 34 | |||
283 | 78989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | 1 | 8 | 3 | 29491 | 35 | |||
287 | 39813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | Permit Number 41144 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 |
290 | 72670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5994586.71732 | 2114106.61682 | 37.7846222306097 | -122.462466948558 | (37.7846222306097, -122.462466948558) | 11 | 6 | 2 | 54 | 11 | |||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
420 | 35740 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 9 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | 12 | Permit Number 39014 | 6007525.01662 | 2093953.73286 | 37.7300236128799 | -122.416276791867 | (37.7300236128799, -122.416276791867) | 9 | 3 | 7 | 309 | 28 | |
421 | 65202 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 415 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 29 | Permit Number 27188 | 6004121.81538 | 2090701.65991 | 37.7209021868562 | -122.4278104505 | (37.7209021868562, -122.4278104505) | 9 | 7 | 6 | 28861 | 5 | |
422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
504 | 78734 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997023.15719 | 2086886.03529 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | 9 | 7 | 6 | 28861 | 25 | |||
505 | 71223 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2245 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987597.8172 | 2100005.1583 | 37.7454985686348 | -122.485610641464 | (37.7454985686348, -122.485610641464) | 1 | 8 | 3 | 29491 | 35 | |||
506 | 264804 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
522 | 74913 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1600 Cabrillo St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5990592.63982 | 2110647.77936 | 37.7748944063775 | -122.476032267507 | (37.7748944063775, -122.476032267507) | 11 | 6 | 2 | 55 | 26 | |||
523 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | 1 | 8 | 3 | 29491 | 35 | ||
527 | 32100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 10 | Permit Number 35473 | 6002658.19542 | 2104999.95129 | 37.7600790771166 | -122.433891224619 | (37.7600790771166, -122.433891224619) | 2 | 4 | 5 | 28862 | 3 | |
540 | 35140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 911 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38670 | 6001882.60594 | 2088665.49745 | 37.7151844124098 | -122.435405132561 | (37.7151844124098, -122.435405132561) | 9 | 7 | 6 | 28861 | 5 | |
549 | 63156 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.4693765688 | (37.7605085633711, -122.4693765688) | 1 | 8 | 4 | 56 | 12 | ||
552 | 78931 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2701 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986423.7343 | 2105012.1654 | 37.7591779705862 | -122.490038592243 | (37.7591779705862, -122.490038592243) | 1 | 8 | 3 | 56 | 35 | |||
554 | 63105 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23825 | 6006733.57538349 | 2099199.19959074 | 37.7443819667232 | -122.41938488452 | (37.7443819667232, -122.41938488452) | 2 | 7 | 7 | 28859 | 2 | ||
559 | 65188 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 259 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | 3x3 | Permit Number 27172 | 6002967.27009 | 2091905.51259 | 37.7241423183013 | -122.431887278791 | (37.7241423183013, -122.431887278791) | 9 | 7 | 6 | 28861 | 5 |
564 | 67334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1992 12:00:00 AM | 12 | Permit Number 30818 | 6008868.73151 | 2090340.18885 | 37.7201770527016 | -122.411376204361 | (37.7201770527016, -122.411376204361) | 9 | 3 | 7 | 309 | 28 | |
568 | 78813 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 110 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998921.12979 | 2088066.27223 | 37.713370441156 | -122.445598173631 | (37.713370441156, -122.445598173631) | 9 | 7 | 6 | 28861 | 25 | |||
579 | 41331 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 1099 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | 8 | Permit Number 41989 | 6015098.10078 | 2102956.66001 | 37.7551667237886 | -122.390724391438 | (37.7551667237886, -122.390724391438) | 10 | 3 | 8 | 28856 | 29 | |
580 | 65382 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.7863274878262 | -122.441898393886 | (37.7863274878262, -122.441898393886) | 13 | 6 | 1 | 29490 | 27 | |
587 | 37078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.7619519432804 | -122.50380580728 | (37.7619519432804, -122.50380580728) | 1 | 8 | 3 | 56 | 35 | |
589 | 108776 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 500X Lathrop Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
590 | 75888 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6011802.87578 | 2118766.0417 | 37.7983922692391 | -122.403232358505 | (37.7983922692391, -122.403232358505) | 3 | 1 | 10 | 308 | 23 | |||
599 | 78256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | 9 | 7 | 6 | 28861 | 5 | |||
600 | 35359 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.7581511177091 | -122.40184581615 | (37.7581511177091, -122.40184581615) | 10 | 3 | 8 | 28856 | 29 |
601 | 83308 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1773-1775 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014316.33002 | 2095278.14651 | 37.7340397288572 | -122.392890824075 | (37.7340397288572, -122.392890824075) | 10 | 3 | 8 | 58 | 1 | |||
605 | 52150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1646 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | Permit Number 48341 | 6014994.17904 | 2096246.44188 | 37.7367360986871 | -122.390614910664 | (37.7367360986871, -122.390614910664) | 10 | 3 | 8 | 58 | 1 | |
607 | 34245 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 778 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1997 12:00:00 AM | 8 | Permit Number 38055 | 6011531.92576 | 2104772.40188 | 37.7599538473986 | -122.403185056849 | (37.7599538473986, -122.403185056849) | 10 | 3 | 8 | 28856 | 29 | |
614 | 82138 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 360 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5993114.28903 | 2113170.01374 | 37.7819656727858 | -122.467492879752 | (37.7819656727858, -122.467492879752) | 11 | 6 | 2 | 54 | 11 | |||
620 | 74869 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 751 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991293.21229 | 2110325.51656 | 37.7740501576748 | -122.473585351012 | (37.7740501576748, -122.473585351012) | 11 | 6 | 2 | 54 | 26 | |||
626 | 75627 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1345 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988723.2495 | 2097607.46 | 37.7389806270439 | -122.481543546445 | (37.7389806270439, -122.481543546445) | 1 | 8 | 3 | 29491 | 35 | |||
631 | 62744 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1440 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1986 12:00:00 AM | 3x3 | Permit Number 23091 | 6009114.80137277 | 2108930.88306921 | 37.7712367935343 | -122.411838604602 | (37.7712367935343, -122.411838604602) | 8 | 2 | 9 | 28853 | 34 | |
634 | 79736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 705 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008945.3206 | 2110776.64932 | 37.7762953249107 | -122.412555345054 | (37.7762953249107, -122.412555345054) | 8 | 2 | 9 | 28853 | 34 | |||
636 | 67551 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.7613646282886 | -122.403117586111 | (37.7613646282886, -122.403117586111) | 10 | 3 | 8 | 28856 | 29 | |
645 | 38285 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 27 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1998 12:00:00 AM | 12 | 3x12 | Permit Number 40369 | 6007338.83954453 | 2106937.08827094 | 37.7656625095236 | -122.417840391728 | (37.7656625095236, -122.417840391728) | 8 | 4 | 7 | 28853 | 19 |
651 | 59344 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 532 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1980 12:00:00 AM | 8 | Permit Number 18692 | 6000155.0247 | 2110781.0357 | 37.7758101209138 | -122.44296363094 | (37.7758101209138, -122.44296363094) | 15 | 5 | 11 | 29492 | 16 | |
655 | 73536 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | 1 | 8 | 3 | 29491 | 35 | |||
656 | 37103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
664 | 262379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 925 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2020 12:00:00 AM | 3 | 3x3 | 5998032 | 2106999 | 37.7653043483693 | -122.450035028723 | (37.7653043483693, -122.450035028723) | 15 | 5 | 11 | 29492 | 9 | |
666 | 49628 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1591 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 3 | Permit Number 46483 | 6007746.40275 | 2109230.16933 | 37.7719816997133 | -122.416593168865 | (37.7719816997133, -122.416593168865) | 8 | 2 | 9 | 28853 | 19 | |
680 | 47114 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45098 | 6008176.0434029 | 2098254.72889507 | 37.7418697970416 | -122.414330302805 | (37.7418697970416, -122.414330302805) | 2 | 7 | 7 | 28859 | 2 | ||
681 | 71797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.449903100064 | (37.7733879494567, -122.449903100064) | 15 | 5 | 11 | 29492 | 16 |
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) );