trees
8,659 rows where qSpecies_id = 11 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
73472 | 103296 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010792 | 2121375 | 37.80549932132 | -122.406914293894 | (37.80549932132, -122.406914293894) | 3 | 1 | 10 | 308 | 23 | ||||
64920 | 129876 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000565.08752 | 2121366.41121 | 37.8048981726751 | -122.442305206121 | (37.8048981726751, -122.442305206121) | 13 | 9 | 1 | 57 | 17 | |||
76422 | 130353 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011274.37795 | 2121365.30311 | 37.8054996761427 | -122.405244266923 | (37.8054996761427, -122.405244266923) | 3 | 1 | 10 | 308 | 23 | |||
714 | 129877 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000546.03686 | 2121364.03146 | 37.8048905527229 | -122.442370961862 | (37.8048905527229, -122.442370961862) | 13 | 9 | 1 | 57 | 17 | |||
193523 | 23584 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3201X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/25/1990 12:00:00 AM | 18 | 3X3 | 6005448.93118 | 2121362.59765 | 37.8051648419518 | -122.425403847517 | (37.8051648419518, -122.425403847517) | 13 | 1 | 1 | 28858 | 17 | ||
124644 | 129878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6000529.49219 | 2121360.33804 | 37.8048794685852 | -122.442427950994 | (37.8048794685852, -122.442427950994) | 13 | 9 | 1 | 57 | 17 | |||
113721 | 129879 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6000515.79629 | 2121359.61322 | 37.8048766977771 | -122.442475294926 | (37.8048766977771, -122.442475294926) | 13 | 9 | 1 | 57 | 17 | |||
191956 | 130352 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011277.60651 | 2121335.96977 | 37.8054193145122 | -122.405231027083 | (37.8054193145122, -122.405231027083) | 3 | 1 | 10 | 308 | 23 | |||
39033 | 130351 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011282.98959 | 2121299.98363 | 37.8053208063785 | -122.40520986247 | (37.8053208063785, -122.40520986247) | 3 | 1 | 10 | 28860 | 23 | |||
151217 | 130379 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1701 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6011240.53282 | 2121290.24231 | 37.8052916854358 | -122.405356103906 | (37.8052916854358, -122.405356103906) | 3 | 1 | 10 | 308 | 23 | |||
32008 | 96370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001150.89126 | 2121288.6307 | 37.8047179782121 | -122.440272392077 | (37.8047179782121, -122.440272392077) | 13 | 9 | 1 | 57 | 17 | |
178026 | 96369 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001162.44444 | 2121276.45677 | 37.8046852096195 | -122.440231537678 | (37.8046852096195, -122.440231537678) | 13 | 9 | 1 | 57 | 17 | |
164237 | 130350 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011284.81865 | 2121274.44835 | 37.8052507950396 | -122.405201733486 | (37.8052507950396, -122.405201733486) | 3 | 1 | 10 | 28860 | 23 | |||
108559 | 4744 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1196 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/23/1992 12:00:00 AM | 50 | 3X3 | 6007989.76102 | 2121254.14035 | 37.8050102707409 | -122.416603285475 | (37.8050102707409, -122.416603285475) | 5 | 1 | 10 | 308 | 23 | ||
171807 | 4745 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1196 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/23/1992 12:00:00 AM | 50 | 3X3 | 6007989.76102 | 2121254.14035 | 37.8050102707409 | -122.416603285475 | (37.8050102707409, -122.416603285475) | 5 | 1 | 10 | 308 | 23 | ||
66566 | 44080 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2000 12:00:00 AM | 15 | Permit Number 43601 | 6011292.32599 | 2121242.99491 | 37.8051648513333 | -122.405173537038 | (37.8051648513333, -122.405173537038) | 3 | 1 | 10 | 28860 | 23 | ||
160423 | 68984 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1921 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32974 | 6000030.07373389 | 2121239.89636567 | 37.8045202897238 | -122.4441475769 | (37.8045202897238, -122.4441475769) | 13 | 9 | 1 | 57 | 17 | ||
161850 | 62151 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/1985 12:00:00 AM | Permit Number 22265 | 5999505.15205923 | 2121219.35857774 | 37.8044339386067 | -122.445962631474 | (37.8044339386067, -122.445962631474) | 13 | 9 | 1 | 57 | 17 | ||
126476 | 103955 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1655 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2013 12:00:00 AM | 3x3 | Permit Number 770409 | 6002301.6 | 2121189.5 | 37.8045112395113 | -122.436283156286 | (37.8045112395113, -122.436283156286) | 13 | 9 | 1 | 57 | 17 | ||
77102 | 4748 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1199X Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6007816.30894 | 2121179.41413 | 37.8047953349468 | -122.417198239329 | (37.8047953349468, -122.417198239329) | 5 | 1 | 1 | 308 | 32 | ||
27354 | 130341 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011699.23635 | 2121176.78483 | 37.8050057945479 | -122.403760704806 | (37.8050057945479, -122.403760704806) | 3 | 1 | 10 | 28860 | 6 | |||
98959 | 130342 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011650.51107 | 2121169.52863 | 37.8049831487211 | -122.403928814182 | (37.8049831487211, -122.403928814182) | 3 | 1 | 10 | 28860 | 6 | |||
110159 | 130343 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011615.22801 | 2121163.80925 | 37.8049654734371 | -122.404050513114 | (37.8049654734371, -122.404050513114) | 3 | 1 | 10 | 28860 | 6 | |||
82019 | 130344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011587.80417 | 2121163.07977 | 37.8049619382034 | -122.404145365534 | (37.8049619382034, -122.404145365534) | 3 | 1 | 10 | 28860 | 6 | |||
168051 | 130345 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011555.35923 | 2121157.04528 | 37.80494355607 | -122.404257220506 | (37.80494355607, -122.404257220506) | 3 | 1 | 10 | 28860 | 23 | |||
43058 | 130346 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011487.67306 | 2121147.35061 | 37.8049131544873 | -122.404490774436 | (37.8049131544873, -122.404490774436) | 3 | 1 | 10 | 28860 | 23 | |||
93615 | 130347 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011459.9593 | 2121145.08219 | 37.8049053771452 | -122.404586521673 | (37.8049053771452, -122.404586521673) | 3 | 1 | 10 | 28860 | 23 | |||
112802 | 62161 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2071 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/1985 12:00:00 AM | Permit Number 22276 | 5999321.04607079 | 2121141.24066237 | 37.8042089334841 | -122.446594120055 | (37.8042089334841, -122.446594120055) | 13 | 9 | 1 | 57 | 17 | ||
138723 | 130348 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011428.04172 | 2121139.55199 | 37.8048884087244 | -122.404696586977 | (37.8048884087244, -122.404696586977) | 3 | 1 | 10 | 28860 | 23 | |||
170030 | 130349 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 30 Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011396.10316 | 2121132.9925 | 37.8048686128506 | -122.404806652325 | (37.8048686128506, -122.404806652325) | 3 | 1 | 10 | 28860 | 23 | |||
182909 | 47785 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6009171.86340947 | 2121127.78288236 | 37.8047297355065 | -122.412503532854 | (37.8047297355065, -122.412503532854) | 3 | 1 | 10 | 308 | 23 | |||
49048 | 26542 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 530 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
176860 | 26545 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 530 Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
163912 | 130340 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 19 Chestnut St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6011641.17093 | 2121120.50702 | 37.8048480255772 | -122.403957685105 | (37.8048480255772, -122.403957685105) | 3 | 1 | 10 | 28860 | 6 | |||
146396 | 130366 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6011802.47859 | 2121110.74803 | 37.8048302405876 | -122.403398772629 | (37.8048302405876, -122.403398772629) | 3 | 1 | 10 | 28860 | 6 | |||
142450 | 130367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011745.39506 | 2121107.34281 | 37.8048177022474 | -122.403596077594 | (37.8048177022474, -122.403596077594) | 3 | 1 | 10 | 28860 | 6 | |||
40048 | 130339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 19 Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011530.16856 | 2121106.58416 | 37.8048035945816 | -122.40434084215 | (37.8048035945816, -122.40434084215) | 3 | 1 | 10 | 28860 | 6 | |||
129815 | 130338 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 19 Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011506.38624 | 2121101.85714 | 37.8047892863497 | -122.404422810866 | (37.8047892863497, -122.404422810866) | 3 | 1 | 10 | 28860 | 6 | |||
176389 | 130365 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6011804.31754 | 2121095.94582 | 37.8047897000529 | -122.403391366725 | (37.8047897000529, -122.403391366725) | 3 | 1 | 10 | 28860 | 6 | |||
139878 | 130337 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 19 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011365.55023 | 2121083.60527 | 37.8047312998756 | -122.404908905246 | (37.8047312998756, -122.404908905246) | 3 | 1 | 10 | 28860 | 6 | |||
192987 | 130364 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011804.63165 | 2121081.32693 | 37.8047495777032 | -122.403389250627 | (37.8047495777032, -122.403389250627) | 3 | 1 | 10 | 28860 | 6 | |||
62936 | 129861 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3718 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000182.92875 | 2121074.01431 | 37.8040735411278 | -122.443606686105 | (37.8040735411278, -122.443606686105) | 13 | 9 | 1 | 57 | 17 | |||
58019 | 130363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6011809.34098 | 2121067.49936 | 37.804711873607 | -122.40337198005 | (37.804711873607, -122.40337198005) | 3 | 1 | 10 | 28860 | 6 | |||
71380 | 129910 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3101 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005467.67917 | 2121063.89893 | 37.8043457515267 | -122.425317698873 | (37.8043457515267, -122.425317698873) | 13 | 1 | 1 | 28858 | 17 | |||
163227 | 130368 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6011751.03956 | 2121061.71613 | 37.8046927378495 | -122.403573331945 | (37.8046927378495, -122.403573331945) | 3 | 1 | 10 | 28860 | 6 | |||
173629 | 130362 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6011810.82515 | 2121055.17232 | 37.8046781094657 | -122.403365976165 | (37.8046781094657, -122.403365976165) | 3 | 1 | 10 | 28860 | 6 | |||
36751 | 121063 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
39975 | 121061 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
62640 | 121059 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
71643 | 121056 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
140072 | 121060 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
143189 | 121058 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
145327 | 121057 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
160138 | 121055 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
188627 | 121062 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
147830 | 130369 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6011752.79775 | 2121042.95799 | 37.8046413307983 | -122.40356592694 | (37.8046413307983, -122.40356592694) | 3 | 1 | 10 | 28860 | 6 | |||
6105 | 130370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011756.98576 | 2121020.06086 | 37.8045786948161 | -122.403549821892 | (37.8045786948161, -122.403549821892) | 3 | 1 | 10 | 28860 | 6 | |||
77063 | 130361 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6011807.64809 | 2121011.70405 | 37.8045585787875 | -122.403373910883 | (37.8045585787875, -122.403373910883) | 3 | 1 | 10 | 28860 | 6 | |||
65116 | 130360 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011811.81302 | 2120998.52887 | 37.8045226355855 | -122.403358570239 | (37.8045226355855, -122.403358570239) | 3 | 1 | 10 | 28860 | 6 | |||
70391 | 130371 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011762.66559 | 2120992.96718 | 37.8045046194597 | -122.403528258831 | (37.8045046194597, -122.403528258831) | 3 | 1 | 10 | 28860 | 6 | |||
61034 | 130359 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6011813.98533 | 2120985.08994 | 37.8044858568979 | -122.403350106723 | (37.8044858568979, -122.403350106723) | 3 | 1 | 10 | 28860 | 6 | |||
73291 | 130372 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6011765.86565 | 2120974.54458 | 37.8044542142522 | -122.403515887751 | (37.8044542142522, -122.403515887751) | 3 | 1 | 10 | 28860 | 6 | |||
152225 | 129875 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 771149 | 6000472.54237 | 2120960.44245 | 37.8037782163629 | -122.442596301384 | (37.8037782163629, -122.442596301384) | 13 | 9 | 1 | 57 | 17 | |
15593 | 130235 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005988.60064 | 2120959.86285 | 37.8040895112914 | -122.42350760369 | (37.8040895112914, -122.42350760369) | 5 | 9 | 1 | 28858 | 32 | |||
79359 | 129874 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000447.05135 | 2120957.13591 | 37.8037676843965 | -122.442684276679 | (37.8037676843965, -122.442684276679) | 13 | 9 | 1 | 57 | 17 | |||
75968 | 130358 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011816.89594 | 2120955.34883 | 37.8044043576451 | -122.40333794071 | (37.8044043576451, -122.40333794071) | 3 | 1 | 10 | 28860 | 6 | |||
151005 | 62158 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2138 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/1985 12:00:00 AM | Permit Number 22273 | 6000102.67953271 | 2120955.10057309 | 37.8037424588261 | -122.443875844523 | (37.8037424588261, -122.443875844523) | 13 | 9 | 1 | 57 | 17 | ||
140342 | 130373 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011766.44051 | 2120951.16775 | 37.8043900593062 | -122.4035122527 | (37.8043900593062, -122.4035122527) | 3 | 1 | 10 | 28860 | 6 | |||
114310 | 129873 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2015 12:00:00 AM | 3 | Width 4ft | 6000375.37955 | 2120946.54159 | 37.8037345092919 | -122.442931538963 | (37.8037345092919, -122.442931538963) | 13 | 9 | 1 | 57 | 17 | ||
193628 | 129872 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 7 | Width 4ft | Permit Number 771149 | 6000353.54628 | 2120943.15919 | 37.803723977331 | -122.443006850904 | (37.803723977331, -122.443006850904) | 13 | 9 | 1 | 57 | 17 | ||
49608 | 130357 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011818.27586 | 2120942.36786 | 37.8043687921458 | -122.403332251602 | (37.8043687921458, -122.403332251602) | 3 | 1 | 10 | 28860 | 6 | |||
37508 | 130236 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005991.87522 | 2120936.11489 | 37.8040244903099 | -122.423494582406 | (37.8040244903099, -122.423494582406) | 5 | 9 | 1 | 28858 | 32 | |||
23387 | 129871 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000279.3397 | 2120931.08359 | 37.8036865898136 | -122.443262778155 | (37.8036865898136, -122.443262778155) | 13 | 9 | 1 | 57 | 17 | |||
154293 | 129870 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000256.36316 | 2120928.30017 | 37.8036776370849 | -122.443342089382 | (37.8036776370849, -122.443342089382) | 13 | 9 | 1 | 57 | 17 | |||
159602 | 130374 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011770.51271 | 2120927.54554 | 37.8043254259528 | -122.403496497481 | (37.8043254259528, -122.403496497481) | 3 | 1 | 10 | 28860 | 6 | |||
181775 | 129869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000232.80518 | 2120925.33723 | 37.8036681582313 | -122.443423399785 | (37.8036681582313, -122.443423399785) | 13 | 9 | 1 | 57 | 17 | |||
99365 | 130237 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005992.72456 | 2120918.86165 | 37.8039771652762 | -122.423490415868 | (37.8039771652762, -122.423490415868) | 5 | 9 | 1 | 28858 | 32 | |||
145531 | 130375 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6011771.873 | 2120908.33728 | 37.8042727607489 | -122.40349043785 | (37.8042727607489, -122.40349043785) | 3 | 1 | 10 | 28860 | 6 | |||
37315 | 129880 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 74 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001684.60494 | 2120906.53368 | 37.8036992136187 | -122.438398034063 | (37.8036992136187, -122.438398034063) | 13 | 9 | 1 | 57 | 17 | |||
27058 | 129862 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6000214.38483 | 2120902.15861 | 37.8036034654848 | -122.443485478179 | (37.8036034654848, -122.443485478179) | 13 | 9 | 1 | 57 | 17 | |||
158254 | 130238 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005994.72198 | 2120898.88692 | 37.8039224325281 | -122.42348208273 | (37.8039224325281, -122.42348208273) | 5 | 9 | 1 | 28858 | 32 | |||
96958 | 130239 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005995.75895 | 2120883.42831 | 37.8038800456771 | -122.423477394563 | (37.8038800456771, -122.423477394563) | 5 | 9 | 1 | 28858 | 32 | |||
111945 | 130376 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6011775.7134 | 2120881.92953 | 37.8042004660323 | -122.403475288748 | (37.8042004660323, -122.403475288748) | 3 | 1 | 10 | 28860 | 6 | |||
32580 | 49659 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 8 | 6000216.68095 | 2120880.45401 | 37.8035440014225 | -122.443475972348 | (37.8035440014225, -122.443475972348) | 13 | 9 | 1 | 57 | 17 | |||
99904 | 130356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011831.18103 | 2120868.60069 | 37.8041669662863 | -122.40328239948 | (37.8041669662863, -122.40328239948) | 3 | 1 | 10 | 28860 | 6 | |||
38957 | 130240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006000.03403 | 2120857.11191 | 37.8038080288815 | -122.423460728342 | (37.8038080288815, -122.423460728342) | 5 | 9 | 1 | 28858 | 32 | |||
76248 | 130377 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011780.61796 | 2120856.19779 | 37.8041300869091 | -122.40345650464 | (37.8041300869091, -122.40345650464) | 3 | 1 | 10 | 28860 | 6 | |||
10777 | 35244 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
59551 | 35247 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
102172 | 97726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 4x4 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | ||
127806 | 35243 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
129918 | 35242 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
132669 | 35246 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
132921 | 35240 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
146963 | 35245 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
165970 | 35241 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
90149 | 49660 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 9 | Permit Number 46510 | 6000221.59082 | 2120852.31212 | 37.803467011345 | -122.443456958892 | (37.803467011345, -122.443456958892) | 13 | 9 | 1 | 57 | 17 | ||
172949 | 48874 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 46081 | 6011761.98196 | 2120845.27049 | 37.8040990422933 | -122.403520226981 | (37.8040990422933, -122.403520226981) | 3 | 1 | 10 | 28860 | 6 | ||
25219 | 129908 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001694.14605 | 2120844.10453 | 37.8035283424228 | -122.438360541313 | (37.8035283424228, -122.438360541313) | 13 | 9 | 1 | 57 | 17 | |||
164259 | 130331 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6011736.68392 | 2120841.79777 | 37.8040880939644 | -122.403607528667 | (37.8040880939644, -122.403607528667) | 3 | 1 | 10 | 28860 | 6 |
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) );