trees
6,714 rows where qSpecies_id = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
114568 | 196093 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 01st St | 25 | : Yard | Tree | Private 2 | 8 | 6014406.11466 | 2105887.9731 | 37.763177058994 | -122.393322619136 | (37.763177058994, -122.393322619136) | 14 | 3 | 8 | 28856 | 29 | ||||
143352 | 196094 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 01st St | 26 | : Yard | Tree | Private 2 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | 14 | 3 | 8 | 28856 | 29 | ||||
174831 | 196092 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 01st St | 24 | : Yard | Tree | Private 2 | 10 | 6014425.82588 | 2105887.05023 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | 14 | 3 | 8 | 28856 | 29 | ||||
99210 | 123933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5993312.90228 | 2114946.82765 | 37.7868557832667 | -122.466934987319 | (37.7868557832667, -122.466934987319) | 11 | 6 | 1 | 54 | 11 | ||||
158898 | 123932 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993304.79465 | 2114951.86159 | 37.7868691371328 | -122.466963403708 | (37.7868691371328, -122.466963403708) | 11 | 6 | 1 | 54 | 11 | ||||
259 | 196282 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 13 | : Yard | Tree | Private 2 | 12 | 6015015.25562 | 2102205.64875 | 37.7531000097757 | -122.390958410295 | (37.7531000097757, -122.390958410295) | 10 | 3 | 8 | 28856 | 29 | ||||
18883 | 196073 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 5 | : Yard | Tree | Private 2 | 9 | 6014983.58057 | 2102134.91171 | 37.7529040232186 | -122.391063005979 | (37.7529040232186, -122.391063005979) | 10 | 3 | 8 | 28856 | 29 | ||||
20145 | 196076 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 18 | : Yard | Tree | Private 2 | 6 | 6014971.87416 | 2102223.03647 | 37.7531453455068 | -122.391109648404 | (37.7531453455068, -122.391109648404) | 10 | 3 | 8 | 28856 | 29 | ||||
26654 | 196279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 6 | : Yard | Tree | Private 2 | 5 | 6014984.46572 | 2102135.07494 | 37.7529045205317 | -122.391059956347 | (37.7529045205317, -122.391059956347) | 10 | 3 | 8 | 28856 | 29 | ||||
53577 | 196075 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 17 | : Yard | Tree | Private 2 | 6 | 6014963.46919 | 2102214.24517 | 37.7531207400437 | -122.391138100256 | (37.7531207400437, -122.391138100256) | 10 | 3 | 8 | 28856 | 29 | ||||
66115 | 196280 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 11 | : Yard | Tree | Private 2 | 12 | 6015022.69172 | 2102195.1938 | 37.7530717153135 | -122.390931963945 | (37.7530717153135, -122.390931963945) | 10 | 3 | 8 | 28856 | 29 | ||||
96248 | 196074 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 7 | : Yard | Tree | Private 2 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | 10 | 3 | 8 | 28856 | 29 | ||||
143668 | 196281 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 12 | : Yard | Tree | Private 2 | 12 | 6015018.37236 | 2102200.19302 | 37.7530852024401 | -122.390947250631 | (37.7530852024401, -122.390947250631) | 10 | 3 | 8 | 28856 | 29 | ||||
151424 | 196072 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 4 | : Yard | Tree | Private 2 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | 10 | 3 | 8 | 28856 | 29 | ||||
157955 | 196077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 19 | : Yard | Tree | Private 2 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | 10 | 3 | 8 | 28856 | 29 | ||||
59065 | 84122 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.7159994174075 | -122.402038569068 | (37.7159994174075, -122.402038569068) | 10 | 7 | 8 | 309 | 39 | ||
139564 | 84281 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.7159994174075 | -122.402038569068 | (37.7159994174075, -122.402038569068) | 10 | 7 | 8 | 309 | 39 | ||
169214 | 84282 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.7159994174075 | -122.402038569068 | (37.7159994174075, -122.402038569068) | 10 | 7 | 8 | 309 | 39 | ||
42582 | 236881 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Ashbury Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999527.40106 | 2106977.39106 | 37.7653304712372 | -122.444861252951 | (37.7653304712372, -122.444861252951) | 15 | 5 | 5 | 29492 | 9 | |||
19160 | 71284 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | 15 | 6 | 2 | 29492 | 16 | |||
43074 | 35936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Bache St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.417391936393 | (37.7348864958229, -122.417391936393) | 2 | 7 | 7 | 28859 | 2 | |||
107124 | 35935 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Bache St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.417391936393 | (37.7348864958229, -122.417391936393) | 2 | 7 | 7 | 28859 | 2 | |||
169621 | 35934 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.417391936393 | (37.7348864958229, -122.417391936393) | 2 | 7 | 7 | 28859 | 2 | |||
54996 | 217866 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Belmont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5996652.66876 | 2106194.79883 | 37.7630171937018 | -122.454747676471 | (37.7630171937018, -122.454747676471) | 15 | 5 | 11 | 29492 | 12 | |||
67434 | 217867 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Belmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5996638.61304 | 2106204.01086 | 37.763041681342 | -122.454796955733 | (37.763041681342, -122.454796955733) | 15 | 5 | 11 | 29492 | 12 | |||
155715 | 217865 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Belmont Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996682.74655 | 2106173.09082 | 37.7629593142538 | -122.454642079894 | (37.7629593142538, -122.454642079894) | 15 | 5 | 11 | 29492 | 12 | |||
185209 | 217864 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Belmont Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5996697.2006 | 2106163.46533 | 37.7629337141391 | -122.454591393188 | (37.7629337141391, -122.454591393188) | 15 | 5 | 11 | 29492 | 12 | |||
48600 | 202291 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Issleib Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012719.32075 | 2093257.8431 | 37.7284035570619 | -122.398270517286 | (37.7284035570619, -122.398270517286) | 10 | 3 | 8 | 58 | 1 | |||
55341 | 202294 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Issleib Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012769.01912 | 2093237.37262 | 37.7283501175462 | -122.398097270977 | (37.7283501175462, -122.398097270977) | 10 | 3 | 8 | 58 | 1 | |||
109555 | 202293 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Issleib Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012754.8343 | 2093244.37958 | 37.7283685671459 | -122.398146800255 | (37.7283685671459, -122.398146800255) | 10 | 3 | 8 | 58 | 1 | |||
122827 | 202295 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Issleib Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012780.58541 | 2093228.85419 | 37.7283273718953 | -122.398056688169 | (37.7283273718953, -122.398056688169) | 10 | 3 | 8 | 58 | 1 | |||
19697 | 196294 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 29 | Front Yard : Yard | Tree | Private 2 | 3 | 6012397.7351 | 2104775.91149 | 37.7600117988112 | -122.400190869313 | (37.7600117988112, -122.400190869313) | 10 | 3 | 8 | 28856 | 29 | ||||
32348 | 196295 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 30 | Front Yard : Yard | Tree | Private 2 | 5 | 6012406.53513 | 2104796.69988 | 37.7600693698184 | -122.400161894071 | (37.7600693698184, -122.400161894071) | 10 | 3 | 8 | 28856 | 29 | ||||
63317 | 196288 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 19 | Front Yard : Yard | Tree | Private 2 | 5 | 6012383.75589 | 2104753.48944 | 37.7599494533344 | -122.400237642158 | (37.7599494533344, -122.400237642158) | 10 | 3 | 8 | 28856 | 29 | ||||
79384 | 196286 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 10 | Front Yard : Yard | Tree | Private 2 | 27 | 6012387.37414 | 2104738.06992 | 37.7599073164914 | -122.400224045323 | (37.7599073164914, -122.400224045323) | 10 | 3 | 8 | 28856 | 29 | ||||
97096 | 196291 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 24 | Front Yard : Yard | Tree | Private 2 | 2 | 6012380.38083 | 2104793.15065 | 37.7600581660633 | -122.400252100554 | (37.7600581660633, -122.400252100554) | 10 | 3 | 8 | 28856 | 29 | ||||
144624 | 196292 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 25 | Front Yard : Yard | Tree | Private 2 | 3 | 6012388.17486 | 2104794.04276 | 37.7600610501996 | -122.400225207229 | (37.7600610501996, -122.400225207229) | 10 | 3 | 8 | 28856 | 29 | ||||
148200 | 196287 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 16 | Front Yard : Yard | Tree | Private 2 | 3 | 6012398.96991 | 2104759.28758 | 37.7599662220764 | -122.400185431124 | (37.7599662220764, -122.400185431124) | 10 | 3 | 8 | 28856 | 29 | ||||
172935 | 196293 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 26 | Front Yard : Yard | Tree | Private 2 | 3 | 6012394.75537 | 2104793.13157 | 37.7600589152009 | -122.400202384259 | (37.7600589152009, -122.400202384259) | 10 | 3 | 8 | 28856 | 29 | ||||
183864 | 196289 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 20 | Front Yard : Yard | Tree | Private 2 | 12 | 6012382.84954 | 2104763.06022 | 37.7599756820445 | -122.400241449008 | (37.7599756820445, -122.400241449008) | 10 | 3 | 8 | 28856 | 29 | ||||
189571 | 196290 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Jack Balestreri Way | 23 | Front Yard : Yard | Tree | Private 2 | 2 | 6012385.57921 | 2104781.3261 | 37.7600259883253 | -122.400233291241 | (37.7600259883253, -122.400233291241) | 10 | 3 | 8 | 28856 | 29 | ||||
22599 | 237802 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Loma Vista Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000002.6635 | 2106881.06554 | 37.7650930969837 | -122.443210517669 | (37.7650930969837, -122.443210517669) | 15 | 5 | 5 | 29492 | 3 | |||
41718 | 237803 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Loma Vista Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000002.45309 | 2106902.83574 | 37.765152860531 | -122.443212809136 | (37.765152860531, -122.443212809136) | 15 | 5 | 5 | 29492 | 3 | |||
45118 | 237804 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Loma Vista Ter | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000006.51649 | 2106939.02785 | 37.7652524667463 | -122.443201354463 | (37.7652524667463, -122.443201354463) | 15 | 5 | 5 | 28862 | 3 | |||
19106 | 236747 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001077.0051 | 2103698.81701 | 37.7564166231328 | -122.439266530936 | (37.7564166231328, -122.439266530936) | 2 | 4 | 5 | 28862 | 38 | |||
188910 | 236748 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 Romain St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001094.60828 | 2103699.72105 | 37.7564201071117 | -122.439205717892 | (37.7564201071117, -122.439205717892) | 2 | 4 | 5 | 28862 | 38 | |||
18032 | 212401 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5991904.4182 | 2095887.60674 | 37.7344428040878 | -122.470419411726 | (37.7344428040878, -122.470419411726) | 9 | 8 | 4 | 59 | 40 | |||
98648 | 212403 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 San Rafael Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5991902.57817 | 2095944.28438 | 37.7345983202373 | -122.470429899615 | (37.7345983202373, -122.470429899615) | 9 | 8 | 4 | 59 | 40 | |||
136321 | 212402 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 San Rafael Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5991904.19278 | 2095912.91043 | 37.7345122686213 | -122.470422033273 | (37.7345122686213, -122.470422033273) | 9 | 8 | 4 | 59 | 40 | |||
150150 | 84097 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1-3 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50459 | 6001154.30534256 | 2103349.66248879 | 37.7554623279051 | -122.43897417865 | (37.7554623279051, -122.43897417865) | 2 | 4 | 5 | 28862 | 38 | ||
177084 | 84096 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1-3 Romain St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50459 | 6001154.30534256 | 2103349.66248879 | 37.7554623279051 | -122.43897417865 | (37.7554623279051, -122.43897417865) | 2 | 4 | 5 | 28862 | 38 | ||
150638 | 121889 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 17th Ave | 0 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5990520.54715 | 2115002.72082 | 37.7868476878607 | -122.476599871638 | (37.7868476878607, -122.476599871638) | 11 | 6 | 1 | 61 | 30 | |||
89823 | 236981 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008054 | 2099984 | 37.7466111348871 | -122.414874651383 | (37.7466111348871, -122.414874651383) | 2 | 7 | 7 | 28859 | 2 | |||
115903 | 256774 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Bessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6008054 | 2099984 | 37.7466111348871 | -122.414874651383 | (37.7466111348871, -122.414874651383) | 2 | 7 | 7 | 28859 | 2 | ||||
100947 | 237609 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001055.55276 | 2104949.38722 | 37.7598491636392 | -122.439430361332 | (37.7598491636392, -122.439430361332) | 2 | 4 | 5 | 28862 | 3 | |||
116640 | 237611 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001014.58495 | 2104947.25452 | 37.7598409761864 | -122.439571895724 | (37.7598409761864, -122.439571895724) | 2 | 4 | 5 | 28862 | 3 | |||
130553 | 237612 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Caselli Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001004.26147 | 2104946.80592 | 37.7598391568788 | -122.439607567343 | (37.7598391568788, -122.439607567343) | 2 | 4 | 5 | 28862 | 3 | |||
146416 | 237610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Caselli Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001029.52294 | 2104945.6197 | 37.759837337548 | -122.439520115455 | (37.759837337548, -122.439520115455) | 2 | 4 | 5 | 28862 | 3 | |||
119531 | 196271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Cashmere St | 1 | : | Tree | Private 2 | 31 | 6017110.31038 | 2095865.54024 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | 10 | 3 | 8 | 58 | 1 | ||||
176240 | 68912 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.87073 | 2118345.67653 | 37.7970528621676 | -122.41464241973 | (37.7970528621676, -122.41464241973) | 5 | 1 | 10 | 308 | 21 | |
53796 | 196198 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013719.80665 | 2111866.72594 | 37.7795552234296 | -122.39611537115 | (37.7795552234296, -122.39611537115) | 6 | 2 | 9 | 28856 | 34 | |||
56369 | 196204 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013601.37493 | 2111753.26044 | 37.7792370828557 | -122.396517124359 | (37.7792370828557, -122.396517124359) | 6 | 2 | 9 | 28856 | 34 | |||
60401 | 196201 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Width 2ft | 6013661.85599 | 2111812.39055 | 37.7794028063227 | -122.396312039369 | (37.7794028063227, -122.396312039369) | 6 | 2 | 9 | 28856 | 34 | ||
63200 | 196202 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013641.30182 | 2111791.44038 | 37.7793441381689 | -122.396381676574 | (37.7793441381689, -122.396381676574) | 6 | 2 | 9 | 28856 | 34 | |||
82792 | 196207 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013520.85267 | 2111676.69387 | 37.7790223670258 | -122.396790316822 | (37.7790223670258, -122.396790316822) | 6 | 2 | 9 | 28856 | 34 | |||
92560 | 196208 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013488.1481 | 2111645.63657 | 37.7789352703972 | -122.396901277881 | (37.7789352703972, -122.396901277881) | 6 | 2 | 9 | 28856 | 34 | |||
125804 | 196206 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013551.06217 | 2111704.71777 | 37.7791009956579 | -122.39668777432 | (37.7791009956579, -122.39668777432) | 6 | 2 | 9 | 28856 | 34 | |||
139185 | 196199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013692.0119 | 2111837.7722 | 37.7794741765351 | -122.396209495994 | (37.7794741765351, -122.396209495994) | 6 | 2 | 9 | 28856 | 34 | |||
152059 | 196205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6013581.78975 | 2111736.47585 | 37.7791899062397 | -122.396583701171 | (37.7791899062397, -122.396583701171) | 6 | 2 | 9 | 28856 | 34 | |||
161239 | 196203 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013624.81706 | 2111774.81301 | 37.7792975658558 | -122.396437538871 | (37.7792975658558, -122.396437538871) | 6 | 2 | 9 | 28856 | 34 | |||
172527 | 196200 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Width 2ft | 6013682.55541 | 2111829.59348 | 37.7794511934496 | -122.396241636866 | (37.7794511934496, -122.396241636866) | 6 | 2 | 9 | 28856 | 34 | ||
156333 | 212608 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995646.24598 | 2089933.06973 | 37.7183087156567 | -122.457052192827 | (37.7183087156567, -122.457052192827) | 9 | 8 | 6 | 28861 | 24 | |||
75118 | 236654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006198.97088 | 2103487.79706 | 37.7561273490041 | -122.421537959813 | (37.7561273490041, -122.421537959813) | 2 | 4 | 5 | 28859 | 19 | |||
78453 | 212315 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996111.7334 | 2106830.07991 | 37.764730469656 | -122.456664521149 | (37.764730469656, -122.456664521149) | 15 | 5 | 11 | 29492 | 12 | |||
20197 | 247958 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | 2 | 7 | 7 | 28859 | 2 | ||||
20295 | 202167 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013164.54762 | 2093230.83795 | 37.7283541968866 | -122.396729443526 | (37.7283541968866, -122.396729443526) | 10 | 3 | 8 | 58 | 1 | |||
61296 | 202166 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6013167.38298 | 2093268.67632 | 37.7284582511357 | -122.396722293022 | (37.7284582511357, -122.396722293022) | 10 | 3 | 8 | 58 | 1 | |||
79330 | 202168 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.7283592870497 | -122.396753038148 | (37.7283592870497, -122.396753038148) | 10 | 3 | 8 | 58 | 1 | |||
193195 | 202165 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013169.46886 | 2093279.75554 | 37.7284887885067 | -122.396715858357 | (37.7284887885067, -122.396715858357) | 10 | 3 | 8 | 58 | 1 | |||
95833 | 237707 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Levant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000247.19963 | 2106827.67898 | 37.764960451486 | -122.44236089665 | (37.764960451486, -122.44236089665) | 15 | 5 | 5 | 28862 | 3 | |||
121536 | 237708 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Levant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000245.79944 | 2106807.6241 | 37.7649053059642 | -122.442364299668 | (37.7649053059642, -122.442364299668) | 15 | 5 | 5 | 28862 | 3 | |||
63177 | 237789 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Loma Vista Ter | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999974.87074 | 2106875.72619 | 37.7650768516417 | -122.443306262176 | (37.7650768516417, -122.443306262176) | 15 | 5 | 5 | 29492 | 3 | |||
117165 | 237788 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Loma Vista Ter | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999974.05757 | 2106889.15487 | 37.7651136770803 | -122.443310039327 | (37.7651136770803, -122.443310039327) | 15 | 5 | 5 | 29492 | 3 | |||
154197 | 237790 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Loma Vista Ter | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999973.59103 | 2106866.6906 | 37.7650519691887 | -122.443310039322 | (37.7650519691887, -122.443310039322) | 15 | 5 | 5 | 29492 | 3 | |||
161153 | 237787 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Loma Vista Ter | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999975.78391 | 2106902.16823 | 37.7651495069668 | -122.443305003127 | (37.7651495069668, -122.443305003127) | 15 | 5 | 5 | 29492 | 3 | |||
144604 | 69496 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 6 | Permit Number 33619 | 6000930.02783 | 2092989.43743 | 37.7270028279165 | -122.439007348127 | (37.7270028279165, -122.439007348127) | 9 | 7 | 6 | 28861 | 25 | |
121186 | 135698 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Walnut St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998453.12178 | 2116461.20644 | 37.7913092042995 | -122.449260243563 | (37.7913092042995, -122.449260243563) | 13 | 6 | 1 | 54 | 31 | |||
190751 | 135697 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Walnut St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998449.317 | 2116481.46771 | 37.7913646187353 | -122.449274868335 | (37.7913646187353, -122.449274868335) | 13 | 6 | 1 | 54 | 31 | |||
167304 | 236824 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997056.16867 | 2106590.50267 | 37.7641268320976 | -122.453380686287 | (37.7641268320976, -122.453380686287) | 15 | 5 | 11 | 29492 | 12 | |||
190876 | 46089 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | 3 | Permit Number 44465 | 5989928.03736 | 2114622.78599 | 37.7857701098965 | -122.478621999998 | (37.7857701098965, -122.478621999998) | 11 | 6 | 2 | 55 | 26 | ||
190144 | 33499 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37589 | 6006683.58482984 | 2099106.89574168 | 37.7441257054073 | -122.419551194294 | (37.7441257054073, -122.419551194294) | 2 | 7 | 7 | 28859 | 2 | |||
190765 | 57413 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1976 12:00:00 AM | 5 | Permit Number 16255 | 5996562.3267 | 2113747.4862 | 37.7837497228996 | -122.455606076565 | (37.7837497228996, -122.455606076565) | 11 | 6 | 1 | 54 | 31 | ||
117225 | 102628 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | 6 | 2 | 9 | 28856 | 34 | |
102816 | 178818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Ina Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6004783.72135 | 2091297.0719 | 37.722574479812 | -122.425564792981 | (37.722574479812, -122.425564792981) | 9 | 7 | 6 | 28861 | 5 |
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) );