trees
8,659 rows where qSpecies_id = 11 sorted by qSiteInfo 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1679 | 262328 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
5711 | 253201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:09:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
8266 | 253200 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:07:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
14780 | 262330 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
17225 | 253199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:04:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
18601 | 262329 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
18797 | 86726 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 550X 02ND ST | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686 | 2112756 | 37.7820506796147 | -122.392835099414 | (37.7820506796147, -122.392835099414) | 6 | 2 | 9 | 28856 | 6 | |||
21799 | 108293 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
34437 | 108285 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
41059 | 108279 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
49880 | 108289 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
49990 | 121312 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
62167 | 121518 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
66346 | 108281 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
76348 | 258086 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 381 Lexington St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x1 | 6006575 | 2103913 | 37.7573160533564 | -122.420267699006 | (37.7573160533564, -122.420267699006) | 2 | 4 | 7 | 28859 | 19 | ||||
80342 | 121514 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
80950 | 255115 | Property Tree 8 | Lophostemon confertus :: Brisbane Box 11 | 301X Chester Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
101009 | 121510 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
102091 | 121512 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
106371 | 121516 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
112039 | 121311 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
136160 | 116645 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 20 HAWTHORNE ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/25/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778170 | 6012906 | 2114090 | 37.7856145071238 | -122.399086793588 | (37.7856145071238, -122.399086793588) | 6 | 2 | 9 | 28853 | 6 | |
140120 | 108280 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
143841 | 108276 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
152518 | 121313 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
153201 | 108292 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
153803 | 108278 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
168087 | 108290 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
168756 | 108291 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
172818 | 121310 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x4 | Permit Number 778623 | 6015082 | 2115536 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | 6 | 2 | 9 | 28855 | 6 | |||
177100 | 108283 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
182493 | 108277 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
183412 | 121520 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
192142 | 108288 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
144623 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
54 | 216739 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 11 Brighton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 3ft | 5996185.57101 | 2089978.26988 | 37.7184637821573 | -122.4551912491 | (37.7184637821573, -122.4551912491) | 9 | 8 | 6 | 28861 | 24 | ||
986 | 208414 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 37 San Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993601.90689 | 2097555.83156 | 37.7391213363856 | -122.464671780704 | (37.7391213363856, -122.464671780704) | 1 | 8 | 4 | 59 | 40 | |||
1865 | 250727 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986989.77084 | 2114474.42914 | 37.7851917306499 | -122.488776528028 | (37.7851917306499, -122.488776528028) | 11 | 6 | 1 | 55 | 33 | |||
2919 | 208356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4998 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990631.22914 | 2093445.14336 | 37.7276627189546 | -122.474642998593 | (37.7276627189546, -122.474642998593) | 9 | 8 | 4 | 64 | 40 | |||
5124 | 208248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993720.3367 | 2097534.6228 | 37.739069929337 | -122.464260768027 | (37.739069929337, -122.464260768027) | 1 | 8 | 4 | 59 | 40 | |||
8861 | 208247 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993716.65368 | 2097514.87622 | 37.7390154978753 | -122.464272068903 | (37.7390154978753, -122.464272068903) | 1 | 8 | 4 | 59 | 40 | |||
10280 | 228713 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 811 Duboce Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6001884.18486 | 2108235.8291 | 37.7689200513416 | -122.436799796678 | (37.7689200513416, -122.436799796678) | 15 | 5 | 5 | 29492 | 3 | |||
10513 | 208259 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 7 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | Permit Number 784463 | 5993794.93642 | 2097790.46819 | 37.7397767164315 | -122.464021405387 | (37.7397767164315, -122.464021405387) | 1 | 8 | 4 | 59 | 40 | ||
11356 | 208342 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990572.11827 | 2092496.71048 | 37.7250551346827 | -122.474778147818 | (37.7250551346827, -122.474778147818) | 9 | 8 | 4 | 64 | 40 | |||
14254 | 215913 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 45 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 8ft | 5992854.98914 | 2096471.13815 | 37.7360999515525 | -122.467175416836 | (37.7360999515525, -122.467175416836) | 1 | 8 | 4 | 59 | 40 | |||
16985 | 202583 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6012034.01872 | 2108546.23297 | 37.7703439695143 | -122.40171381097 | (37.7703439695143, -122.40171381097) | 14 | 2 | 8 | 28856 | 20 | |||
17325 | 208354 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990627.1725 | 2093396.83669 | 37.7275298459097 | -122.474653498173 | (37.7275298459097, -122.474653498173) | 9 | 8 | 4 | 64 | 40 | |||
17328 | 202594 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6012239.58378 | 2108742.5879 | 37.7708945848526 | -122.401016555771 | (37.7708945848526, -122.401016555771) | 14 | 2 | 8 | 28856 | 20 | |||
17916 | 208394 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 485 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994764.25311 | 2099994.70676 | 37.7458848218275 | -122.460829649368 | (37.7458848218275, -122.460829649368) | 1 | 8 | 4 | 59 | 40 | |||
18240 | 208338 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3660 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5990543.735 | 2092084.7933 | 37.7239224682242 | -122.474846212085 | (37.7239224682242, -122.474846212085) | 9 | 8 | 4 | 64 | 40 | |||
20464 | 208353 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990626.63647 | 2093347.44726 | 37.727394203873 | -122.474651748098 | (37.727394203873, -122.474651748098) | 9 | 8 | 4 | 64 | 40 | |||
21834 | 191596 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 450 Amador St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6018234.42058 | 2099614.56318 | 37.74616351723 | -122.379645788832 | (37.74616351723, -122.379645788832) | 10 | 3 | 8 | 58 | 1 | |||
26552 | 228109 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 2ft | 5998303.37296 | 2104669.01402 | 37.7589223169244 | -122.448928566402 | (37.7589223169244, -122.448928566402) | 15 | 5 | 4 | 28862 | 38 | |||
27629 | 208201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 109 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992876.13857 | 2095935.50628 | 37.7346304611167 | -122.467063364902 | (37.7346304611167, -122.467063364902) | 9 | 8 | 4 | 59 | 40 | |||
27827 | 122218 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 14th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991592.57062 | 2111160.51738 | 37.7763601747586 | -122.472610720253 | (37.7763601747586, -122.472610720253) | 11 | 6 | 2 | 54 | 26 | |||
28677 | 178295 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 3x6 | 5990056.81744 | 2088683.04681 | 37.7145538887276 | -122.47628102917 | (37.7145538887276, -122.47628102917) | 1 | 8 | 4 | 64 | 14 | |||
30212 | 202588 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6012111.3899 | 2108620.40414 | 37.7705519440392 | -122.401451395961 | (37.7705519440392, -122.401451395961) | 14 | 2 | 8 | 28856 | 20 | |||
32463 | 246708 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Bonview St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6007726.70462 | 2099154.93537 | 37.7443163124548 | -122.41594770744 | (37.7443163124548, -122.41594770744) | 2 | 7 | 7 | 28859 | 2 | ||||
33369 | 191609 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2400 Mendell St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6013373.34204 | 2093012.51066 | 37.7277663334322 | -122.395992333084 | (37.7277663334322, -122.395992333084) | 10 | 3 | 8 | 58 | 1 | |||
33744 | 208389 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 151 Elmwood Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995022.21815 | 2092735.53955 | 37.7259677711682 | -122.459412025554 | (37.7259677711682, -122.459412025554) | 9 | 7 | 4 | 28861 | 40 | |||
34884 | 208417 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 41 San Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993639.38726 | 2097577.38103 | 37.7391826665578 | -122.464543755917 | (37.7391826665578, -122.464543755917) | 1 | 8 | 4 | 59 | 40 | |||
35548 | 208246 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 75 San Lorenzo Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993711.81296 | 2097482.43127 | 37.7389261331305 | -122.464286450858 | (37.7389261331305, -122.464286450858) | 1 | 8 | 4 | 59 | 40 | |||
35723 | 208440 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 90 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993884.95998 | 2097216.61564 | 37.7382062483222 | -122.463668506013 | (37.7382062483222, -122.463668506013) | 1 | 8 | 4 | 59 | 40 | |||
37776 | 229095 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Santa Marina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 6006508.76919 | 2097364.11009 | 37.7393305582512 | -122.420032016272 | (37.7393305582512, -122.420032016272) | 2 | 7 | 7 | 28859 | 2 | |||
37969 | 208256 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993762.65186 | 2097710.37243 | 37.7395549328226 | -122.464127217798 | (37.7395549328226, -122.464127217798) | 1 | 8 | 4 | 59 | 40 | |||
39740 | 208429 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 8 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993757.20606 | 2097779.47914 | 37.7397443686968 | -122.464151062426 | (37.7397443686968, -122.464151062426) | 1 | 8 | 4 | 59 | 40 | |||
40202 | 191608 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2400 Mendell St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6013378.72885 | 2093051.33758 | 37.7278732439559 | -122.395976430366 | (37.7278732439559, -122.395976430366) | 10 | 3 | 8 | 58 | 1 | |||
40730 | 228984 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2689 Bryant St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6009821.74177 | 2101696.3293 | 37.7514119840826 | -122.408882750359 | (37.7514119840826, -122.408882750359) | 2 | 4 | 7 | 28859 | 19 | |||
41352 | 208331 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990506.75522 | 2091505.28187 | 37.7223291312546 | -122.474931762787 | (37.7223291312546, -122.474931762787) | 9 | 8 | 4 | 64 | 40 | |||
41509 | 201579 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6020614.66874 | 2092891.85925 | 37.7278352682694 | -122.370950280826 | (37.7278352682694, -122.370950280826) | 10 | 3 | 8 | 58 | 1 | |||
45190 | 208431 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 87 Santa Monica Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993882.65702 | 2097259.56447 | 37.7383240424088 | -122.463679584738 | (37.7383240424088, -122.463679584738) | 1 | 8 | 4 | 59 | 40 | |||
47388 | 122977 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 310 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5993420.3282 | 2113338.3848 | 37.7824456379372 | -122.466446374773 | (37.7824456379372, -122.466446374773) | 11 | 6 | 2 | 54 | 11 | |||
49961 | 177169 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Morse St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001283.26601 | 2088090.37173 | 37.7135711887396 | -122.437435547228 | (37.7135711887396, -122.437435547228) | 9 | 7 | 6 | 28861 | 5 | |||
50514 | 208252 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993745.99761 | 2097653.0262 | 37.739396514526 | -122.464180638441 | (37.739396514526, -122.464180638441) | 1 | 8 | 4 | 59 | 40 | |||
51811 | 208418 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 45 San Monica Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993667.21444 | 2097597.00588 | 37.7392381556149 | -122.464448967357 | (37.7392381556149, -122.464448967357) | 1 | 8 | 4 | 59 | 40 | |||
52819 | 208404 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 11 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993399.35677 | 2097455.84862 | 37.7388351289428 | -122.465364840534 | (37.7388351289428, -122.465364840534) | 1 | 8 | 4 | 59 | 40 | |||
53283 | 208424 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 55 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993717.10972 | 2097667.2216 | 37.7394338264982 | -122.464281549568 | (37.7394338264982, -122.464281549568) | 1 | 8 | 4 | 59 | 40 | |||
57152 | 208427 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 8 San Lorenzo Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993743.30191 | 2097744.67133 | 37.7396479937681 | -122.464196610382 | (37.7396479937681, -122.464196610382) | 1 | 8 | 4 | 59 | 40 | |||
57185 | 208390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 151 Elmwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994957.66786 | 2092685.59829 | 37.7258269328487 | -122.459631554564 | (37.7258269328487, -122.459631554564) | 9 | 7 | 4 | 28861 | 40 | |||
60518 | 208348 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3586 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990586.58923 | 2092794.78382 | 37.725874408051 | -122.474749869538 | (37.725874408051, -122.474749869538) | 9 | 8 | 4 | 64 | 40 | |||
61959 | 254462 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 56 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
61982 | 122216 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 14th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991590.85189 | 2111187.58624 | 37.776434398981 | -122.472618639786 | (37.776434398981, -122.472618639786) | 11 | 6 | 2 | 54 | 26 | |||
63022 | 208433 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993827.7201 | 2097305.39054 | 37.7384467036399 | -122.463872853562 | (37.7384467036399, -122.463872853562) | 1 | 8 | 4 | 59 | 40 | |||
63060 | 202592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6012191.38172 | 2108696.49958 | 37.7707653477827 | -122.401180049822 | (37.7707653477827, -122.401180049822) | 14 | 2 | 8 | 28856 | 20 | |||
63279 | 228114 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 5998381.85659 | 2104680.5063 | 37.7589583599523 | -122.448657962201 | (37.7589583599523, -122.448657962201) | 15 | 5 | 4 | 28862 | 38 | |||
64125 | 208351 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990621.38884 | 2093295.18261 | 37.7272503941904 | -122.474666076081 | (37.7272503941904, -122.474666076081) | 9 | 8 | 4 | 64 | 40 | |||
64674 | 208335 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3684 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990511.32014 | 2091590.21454 | 37.7225625997689 | -122.474922179615 | (37.7225625997689, -122.474922179615) | 9 | 8 | 4 | 64 | 40 | |||
65637 | 202589 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6012146.02673 | 2108653.71558 | 37.7706453422429 | -122.401333927439 | (37.7706453422429, -122.401333927439) | 14 | 2 | 8 | 28856 | 20 | |||
67594 | 208334 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3686 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990510.95904 | 2091573.10598 | 37.7225156029966 | -122.474922179633 | (37.7225156029966, -122.474922179633) | 9 | 8 | 4 | 64 | 40 | |||
68472 | 250933 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 258 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5987147.60505 | 2114230.18053 | 37.7845303035608 | -122.488212522694 | (37.7845303035608, -122.488212522694) | 11 | 6 | 1 | 55 | 33 | |||
68778 | 192626 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 251 Executive Park Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6014541.1313 | 2086989.76137 | 37.7112939542297 | -122.391534343345 | (37.7112939542297, -122.391534343345) | 10 | 3 | 8 | 58 | 1 | |||
69118 | 208347 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3592 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990579.24588 | 2092689.5726 | 37.7255850988498 | -122.474767578954 | (37.7255850988498, -122.474767578954) | 9 | 8 | 4 | 64 | 40 | |||
70474 | 208230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 18 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993408.84143 | 2097416.32422 | 37.7387271518268 | -122.465329177018 | (37.7387271518268, -122.465329177018) | 1 | 8 | 4 | 59 | 40 | |||
71181 | 122217 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 625 14th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991591.55802 | 2111174.54353 | 37.7763986281292 | -122.472615245954 | (37.7763986281292, -122.472615245954) | 11 | 6 | 2 | 54 | 26 | |||
72105 | 208420 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 45 San Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993680.01977 | 2097613.40058 | 37.7392839095123 | -122.464405882644 | (37.7392839095123, -122.464405882644) | 1 | 8 | 4 | 59 | 40 | |||
72259 | 208409 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 33 San Monica Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993525.64107 | 2097518.43304 | 37.7390142522997 | -122.464932755856 | (37.7390142522997, -122.464932755856) | 1 | 8 | 4 | 59 | 40 | |||
72301 | 208432 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 87 Santa Monica Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993844.55704 | 2097293.33707 | 37.7384145780766 | -122.463813765401 | (37.7384145780766, -122.463813765401) | 1 | 8 | 4 | 59 | 40 | |||
72721 | 208344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3596 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990576.13534 | 2092600.13412 | 37.7253393429133 | -122.474771806674 | (37.7253393429133, -122.474771806674) | 9 | 8 | 4 | 64 | 40 |
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) );