trees
292 rows where Supervisor Districts = 9 and qSpecies_id = 53 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131840 | 100259 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30X Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x3 | 6015074.6 | 2113439.2 | 37.7839481682667 | -122.391538488525 | (37.7839481682667, -122.391538488525) | 6 | 2 | 9 | 28856 | 6 | |||
104676 | 100260 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30X Federal St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x3 | 6015074.6 | 2113439.2 | 37.7839481682667 | -122.391538488525 | (37.7839481682667, -122.391538488525) | 6 | 2 | 9 | 28856 | 6 | |||
135772 | 100261 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 40 Federal St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6014922 | 2113400.9 | 37.7838345339316 | -122.392063753471 | (37.7838345339316, -122.392063753471) | 6 | 2 | 9 | 28856 | 6 | |||
50036 | 100262 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 40 Federal St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6014922 | 2113400.9 | 37.7838345339316 | -122.392063753471 | (37.7838345339316, -122.392063753471) | 6 | 2 | 9 | 28856 | 6 | |||
174749 | 100263 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 40 Federal St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6014922 | 2113400.9 | 37.7838345339316 | -122.392063753471 | (37.7838345339316, -122.392063753471) | 6 | 2 | 9 | 28856 | 6 | |||
167657 | 100264 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 40 Federal St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6014922 | 2113400.9 | 37.7838345339316 | -122.392063753471 | (37.7838345339316, -122.392063753471) | 6 | 2 | 9 | 28856 | 6 | |||
65043 | 100265 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 40 Federal St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3x3 | 6014922 | 2113400.9 | 37.7838345339316 | -122.392063753471 | (37.7838345339316, -122.392063753471) | 6 | 2 | 9 | 28856 | 6 | |||
61686 | 100705 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
132195 | 100706 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
105004 | 100707 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
188290 | 100708 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
182718 | 100710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
54470 | 101758 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
38782 | 101759 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
152130 | 101760 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
108812 | 101761 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
99112 | 101762 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
73524 | 101763 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
47908 | 101764 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
145766 | 101765 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
57879 | 101766 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
148648 | 101767 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
170953 | 101768 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
172014 | 101769 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
100078 | 102598 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
84141 | 102599 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
155305 | 102600 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
98499 | 102601 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
32399 | 102602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
150564 | 102603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
28163 | 10573 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | 14 | 2 | 9 | 28853 | 34 | |||
180877 | 10578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005X HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x7 | 6011386 | 2111037 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | 14 | 2 | 9 | 28853 | 34 | |||
24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
134743 | 107366 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 851 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008079.7 | 2114773.8 | 37.7872219209064 | -122.415832880524 | (37.7872219209064, -122.415832880524) | 13 | 1 | 9 | 28858 | 36 | |||
101116 | 107368 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660 OFARRELL ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008096 | 2114145 | 37.7854963051764 | -122.415731945695 | (37.7854963051764, -122.415731945695) | 13 | 10 | 9 | 28858 | 36 | ||||||
138240 | 108324 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
162113 | 108325 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
93090 | 108326 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
347 | 108327 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
77006 | 108328 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
56045 | 108604 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 625 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008310.7 | 2114660.6 | 37.7869240847944 | -122.415025652231 | (37.7869240847944, -122.415025652231) | 13 | 1 | 9 | 28858 | 36 | |||
36280 | 110558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection | 6007165.9 | 2109609 | 37.7729892139286 | -122.418628045346 | (37.7729892139286, -122.418628045346) | 8 | 2 | 9 | 28853 | 19 | |||
176043 | 111207 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X 09TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
156885 | 111208 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X 09TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
131089 | 111209 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X 09TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
105815 | 111210 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X 09TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
173344 | 111211 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X 09TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010680 | 2108566 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | 14 | 2 | 9 | 28853 | 34 | ||||
107982 | 111590 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | |||
158317 | 111591 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
99255 | 111592 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
144365 | 111593 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
173264 | 111594 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
43639 | 111595 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
150162 | 111596 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
20820 | 111597 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
100811 | 111598 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 398X BRYANT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014483 | 2113360 | 37.7836978486164 | -122.393579678281 | (37.7836978486164, -122.393579678281) | 6 | 2 | 9 | 28856 | 6 | ||||
38468 | 111626 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
36076 | 111627 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
183049 | 111628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
113146 | 111793 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55X Sherman St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6010868.84129 | 2110834.34163 | 37.7765614981606 | -122.405905386452 | (37.7765614981606, -122.405905386452) | 14 | 2 | 9 | 28853 | 34 | |||
152554 | 111794 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
26375 | 111795 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
112427 | 111796 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
32372 | 111797 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
126595 | 111798 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
119106 | 111799 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
182181 | 111804 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
167113 | 111806 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
770 | 111807 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
105308 | 111809 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
134382 | 111810 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
55646 | 111811 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
46738 | 113373 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | |||
186477 | 113509 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 318 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008412 | 2113183 | 37.7828726439691 | -122.414570576408 | (37.7828726439691, -122.414570576408) | 7 | 10 | 9 | 28852 | 36 | ||||
50788 | 113510 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008411 | 2113171 | 37.7828396386737 | -122.414573186563 | (37.7828396386737, -122.414573186563) | 7 | 10 | 9 | 28852 | 36 | ||||
170466 | 114281 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
71167 | 114282 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
57627 | 114283 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
78580 | 114284 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
123162 | 114285 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
109074 | 115054 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
55811 | 115056 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
18772 | 115057 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
9438 | 115058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
38859 | 115059 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
32017 | 116771 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 590X NATOMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009883 | 2111689 | 37.7788530052944 | -122.409376039999 | (37.7788530052944, -122.409376039999) | 14 | 2 | 9 | 28853 | 34 | |||
180679 | 120134 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
59516 | 120135 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
168941 | 120136 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
29615 | 120137 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
135359 | 120138 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
41773 | 120139 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
120635 | 120140 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
182867 | 120141 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
186730 | 120142 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
129533 | 120143 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
38715 | 120144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
179551 | 120145 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
183245 | 120146 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 |
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) );