trees

963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 963 ✖
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)
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
6288 254356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
9010 253870 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW       Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection                    
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
17892 254355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
18422 112268 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
63265 6801 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1385 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6016634.4993322 2097405.4643513 37.7400094064471 -122.385024282227 (37.7400094064471, -122.385024282227) 10 3 8 58 1
20107 41196 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
54273 41195 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1996 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
78771 41194 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
79179 41198 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
82003 41199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
156118 41200 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
165827 41193 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
176242 41192 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
101295 29407 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2801X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3X3   6014804.18454 2090650.03815 37.7213589569903 -122.390880803843 (37.7213589569903, -122.390880803843) 10 3 8 58 1
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
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
26933 120656 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
27040 120661 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
91220 120660 Undocumented 4 Ficus nitida :: Laurel Fig 53 126 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
114816 120655 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
128659 120663 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
165688 120662 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 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
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
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
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
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
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
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
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
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
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
19076 99594 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
122922 99595 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
40156 49286 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 14 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
45439 49260 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
60857 49274 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 20 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
69985 49269 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
81758 49264 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
91238 49276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95381 49285 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 13 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95982 49266 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
103493 49277 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 15 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
117139 49290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
118155 49258 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 8 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
129463 49287 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
136842 49263 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 17 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
144032 49294 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
147296 49297 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
151649 49289 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
172671 49251 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
174050 49256 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
177069 49259 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
175879 15105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014344.93761 2116565.97781 37.7924930511311 -122.394281863407 (37.7924930511311, -122.394281863407) 12 2 9 28855 6
124192 15106 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014335.21568 2116559.29701 37.7924741668095 -122.394315033873 (37.7924741668095, -122.394315033873) 12 2 9 28855 6
163880 15107 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014322.84653 2116550.95179 37.7924505652168 -122.394357247259 (37.7924505652168, -122.394357247259) 12 2 9 28855 6
115493 15108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014309.51773 2116539.1619 37.7924174520023 -122.394402539761 (37.7924174520023, -122.394402539761) 12 2 9 28855 6
111958 15109 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014295.34515 2116528.26215 37.7923867359811 -122.3944508141 (37.7923867359811, -122.3944508141) 12 2 9 28855 6
85954 15110 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014281.21891 2116519.09631 37.7923607834286 -122.394499049528 (37.7923607834286, -122.394499049528) 12 2 9 28855 6
97368 64484 Permitted Site 7 Ficus nitida :: Laurel Fig 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM     Permit Number 778749 6014198.52964849 2112913.46772182 37.782455962378 -122.39453256733 (37.782455962378, -122.39453256733) 6 2 9 28856 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
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
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
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
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
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
94460 101975 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1230 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769454 6013882 2105282.2 37.7614846061652 -122.395092936828 (37.7614846061652, -122.395092936828) 10 3 8 28856 29
40462 48697 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
53416 48709 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
70254 48702 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 14 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
84798 48704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
95808 48700 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
100582 48699 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
132203 48698 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
145539 48701 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
168885 48703 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
43665 94218 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 3 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
170512 94219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 4 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
187881 94217 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 2 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
63978 119667 Undocumented 4 Ficus nitida :: Laurel Fig 53 699x Missouri St 8 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
59324 94216 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 1 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
129369 94220 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 5 Sidewalk: Property side : Pot Tree Private 2         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);