trees
8,659 rows where qSpecies_id = 11 sorted by TreeID
This data as json, CSV (advanced)
rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105062 | 101999 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 501X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014257 | 2114662 | 37.7872602812755 | -122.394452755334 | (37.7872602812755, -122.394452755334) | 6 | 2 | 9 | 28855 | 6 | ||||
51858 | 102000 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2325 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2013 12:00:00 AM | 3x3 | 6015827.9 | 2104765.4 | 37.7601736025257 | -122.388326742167 | (37.7601736025257, -122.388326742167) | 10 | 3 | 8 | 28856 | 29 | |||
30759 | 102132 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015215.09044 | 2114654.1345 | 37.787291898548 | -122.391137388906 | (37.787291898548, -122.391137388906) | 6 | 2 | 9 | 28855 | 6 | |||
73161 | 102135 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6015297.50373 | 2114564.35367 | 37.7870499539329 | -122.39084597706 | (37.7870499539329, -122.39084597706) | 6 | 2 | 9 | 28855 | 6 | |||
64672 | 102136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015307.23206 | 2114554.02594 | 37.7870221361131 | -122.390811596889 | (37.7870221361131, -122.390811596889) | 6 | 2 | 9 | 28855 | 6 | |||
69693 | 102137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015326.05055 | 2114536.91775 | 37.78697620503 | -122.390745292556 | (37.78697620503, -122.390745292556) | 6 | 2 | 9 | 28855 | 6 | |||
132357 | 102138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015344.3581 | 2114517.9353 | 37.7869250992721 | -122.390680625031 | (37.7869250992721, -122.390680625031) | 6 | 2 | 9 | 28855 | 6 | |||
193763 | 102139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769373 | 6015359.41153 | 2114501.84584 | 37.7868817564363 | -122.390627418428 | (37.7868817564363, -122.390627418428) | 6 | 2 | 9 | 28855 | 6 | |
76516 | 102140 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 199X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6006713 | 2098441.9 | 37.7423014331972 | -122.419402316019 | (37.7423014331972, -122.419402316019) | 2 | 7 | 7 | 28859 | 2 | |||
194212 | 102173 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
159714 | 102174 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
97441 | 102183 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1840X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | |||
7995 | 10225 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1399 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005877.37579 | 2100867.12021 | 37.7489134363237 | -122.422463939564 | (37.7489134363237, -122.422463939564) | 2 | 4 | 5 | 28859 | 19 | |||
181747 | 10235 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 33 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6005916.28554 | 2109635.54908 | 37.7729916788522 | -122.422952507954 | (37.7729916788522, -122.422952507954) | 7 | 9 | 11 | 28852 | 10 | |||
31739 | 102357 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3551 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769877 | 6000702.42644 | 2120580.06982 | 37.8027469161033 | -122.441773461287 | (37.8027469161033, -122.441773461287) | 13 | 9 | 1 | 57 | 17 |
161216 | 102453 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 901 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 24139 | 6007621.8 | 2104377.7 | 37.7586509425173 | -122.41668036295 | (37.7586509425173, -122.41668036295) | 2 | 4 | 7 | 28859 | 19 | ||
52889 | 102473 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777498 | 6006146.9 | 2108444.4 | 37.7697340787486 | -122.42207014677 | (37.7697340787486, -122.42207014677) | 8 | 4 | 7 | 28853 | 19 | |
43148 | 10248 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 115 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 8 | 3X3 | 6005531.03023 | 2109580.5948 | 37.7728190414027 | -122.424281245485 | (37.7728190414027, -122.424281245485) | 7 | 9 | 11 | 28852 | 10 | ||
14102 | 10249 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 115 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 20 | 3X3 | 6005554.00593 | 2109582.93221 | 37.7728267566811 | -122.424201936088 | (37.7728267566811, -122.424201936088) | 7 | 9 | 11 | 28852 | 10 | ||
72769 | 10250 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 119 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2014 11:00:00 PM | 3 | 3X4 | 6005488.98085 | 2109573.43799 | 37.7727970160887 | -122.424426190113 | (37.7727970160887, -122.424426190113) | 7 | 9 | 11 | 28852 | 10 | ||
174231 | 102515 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ellis St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
117864 | 10253 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 129X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/07/2007 12:00:00 AM | 6 | 3X3 | 6005512.4115 | 2109578.81866 | 37.7728131132119 | -122.424345523521 | (37.7728131132119, -122.424345523521) | 7 | 9 | 11 | 28852 | 10 | ||
37081 | 10254 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 129X Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2014 11:00:00 PM | 2 | 4X4 | 6005512.4115 | 2109578.81866 | 37.7728131132119 | -122.424345523521 | (37.7728131132119, -122.424345523521) | 7 | 9 | 11 | 28852 | 10 | ||
106531 | 102594 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 290 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995407.1 | 2092042.4 | 37.7240866981498 | -122.458031382697 | (37.7240866981498, -122.458031382697) | 9 | 8 | 4 | 28861 | 24 | |||||
89251 | 102646 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 3x3 | Permit Number 28309 | 6008830.0317 | 2114874.50645 | 37.7875405898706 | -122.413244009 | (37.7875405898706, -122.413244009) | 5 | 1 | 10 | 28852 | 36 | |
129833 | 102722 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 375 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988056.70632 | 2113482.94478 | 37.7825316026095 | -122.485012539451 | (37.7825316026095, -122.485012539451) | 11 | 6 | 2 | 55 | 26 | |||
179529 | 102730 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6017119 | 2092706 | 37.7271323979238 | -122.383022072855 | (37.7271323979238, -122.383022072855) | 10 | 3 | 8 | 58 | 1 | ||||
169273 | 102740 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 797 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6006351 | 2105013 | 37.7603237728001 | -122.421120484988 | (37.7603237728001, -122.421120484988) | 2 | 4 | 7 | 28859 | 19 | |||
81289 | 102741 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 789 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6006273 | 2104998 | 37.7602781888868 | -122.421389185749 | (37.7602781888868, -122.421389185749) | 2 | 4 | 7 | 28859 | 19 | |||
109996 | 102742 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 291 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001237 | 2109672 | 37.7728266156527 | -122.439141307468 | (37.7728266156527, -122.439141307468) | 15 | 5 | 11 | 29492 | 9 | ||||
164428 | 102743 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 291 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001237 | 2109672 | 37.7728266156527 | -122.439141307468 | (37.7728266156527, -122.439141307468) | 15 | 5 | 11 | 29492 | 9 | ||||
93074 | 102744 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 291 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001237 | 2109672 | 37.7728266156527 | -122.439141307468 | (37.7728266156527, -122.439141307468) | 15 | 5 | 11 | 29492 | 9 | ||||
125344 | 102759 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100X Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 | |||
143277 | 102760 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100X Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 | |||
25929 | 102776 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 62X Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008658 | 2112778 | 37.7817744284412 | -122.413690860804 | (37.7817744284412, -122.413690860804) | 7 | 10 | 9 | 28852 | 36 | |||
168207 | 102777 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 62X Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008664.5 | 2112552.3 | 37.7811550752382 | -122.413652405154 | (37.7811550752382, -122.413652405154) | 7 | 10 | 9 | 28852 | 36 | |||
55305 | 102778 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 62X Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008664.5 | 2112552.3 | 37.7811550752382 | -122.413652405154 | (37.7811550752382, -122.413652405154) | 7 | 10 | 9 | 28852 | 36 | |||
43634 | 102815 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
25456 | 102816 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
84396 | 102817 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
190023 | 10293 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 509 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6003637.74102 | 2109321.06429 | 37.7719993462366 | -122.430811822711 | (37.7719993462366, -122.430811822711) | 15 | 9 | 11 | 29492 | 10 | |||
146820 | 10294 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 509 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2014 12:00:00 AM | 30 | 3X3 | Permit Number 773112 | 6003591.41607 | 2109322.99037 | 37.7720020100193 | -122.430972201674 | (37.7720020100193, -122.430972201674) | 15 | 9 | 11 | 29492 | 10 | |
145981 | 103003 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
128047 | 103004 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
120525 | 103005 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
35740 | 103007 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 41X Beulah St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997709.4 | 2107777.7 | 37.7674239953752 | -122.451206983541 | (37.7674239953752, -122.451206983541) | 15 | 5 | 11 | 29492 | 9 | |||
112394 | 10303 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 601 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1992 12:00:00 AM | 20 | 3X3 | 6003210.45234 | 2109260.49432 | 37.7718088176468 | -122.432285519287 | (37.7718088176468, -122.432285519287) | 15 | 5 | 11 | 29492 | 9 | ||
127063 | 10313 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 681 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/1990 12:00:00 AM | 25 | 3X3 | 6002898.77719 | 2109214.94611 | 37.7716660763669 | -122.433360368309 | (37.7716660763669, -122.433360368309) | 15 | 5 | 11 | 29492 | 9 | ||
74514 | 103133 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 345X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005937 | 2110878 | 37.7764043178826 | -122.422969176765 | (37.7764043178826, -122.422969176765) | 7 | 9 | 11 | 28852 | 10 | |||
124909 | 103134 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 345X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005937 | 2110878 | 37.7764043178826 | -122.422969176765 | (37.7764043178826, -122.422969176765) | 7 | 9 | 11 | 28852 | 10 | |||
165035 | 103135 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 345X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005937 | 2110878 | 37.7764043178826 | -122.422969176765 | (37.7764043178826, -122.422969176765) | 7 | 9 | 11 | 28852 | 10 | |||
119155 | 103148 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2013 12:00:00 AM | 11 | 3x3 | Permit Number 770156 | 6009048.0907 | 2110053.72052 | 37.7743160996399 | -122.412148729189 | (37.7743160996399, -122.412148729189) | 8 | 2 | 9 | 28853 | 34 | |
194077 | 103149 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2013 12:00:00 AM | 11 | Permit Number 770156 | 6009026.54065 | 2110070.43459 | 37.7743607833574 | -122.412224456604 | (37.7743607833574, -122.412224456604) | 8 | 2 | 9 | 28853 | 34 | ||
107550 | 10316 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 723 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1992 12:00:00 AM | 25 | 3X3 | 6002672.60229 | 2109187.97638 | 37.7715791901489 | -122.434140791871 | (37.7715791901489, -122.434140791871) | 15 | 5 | 11 | 29492 | 9 | ||
60898 | 10322 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 769 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1996 12:00:00 AM | 20 | 3X3 | 6002487.68212 | 2109158.34718 | 37.7714873387903 | -122.434778321286 | (37.7714873387903, -122.434778321286) | 15 | 5 | 11 | 29492 | 9 | ||
33761 | 10324 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 777 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1996 12:00:00 AM | 25 | 3X3 | 6002422.34232 | 2109148.84912 | 37.7714575496603 | -122.435003655388 | (37.7714575496603, -122.435003655388) | 15 | 5 | 11 | 29492 | 9 | ||
54165 | 103294 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010967.25176 | 2121426.28761 | 37.8056499492485 | -122.406311424057 | (37.8056499492485, -122.406311424057) | 3 | 1 | 10 | 308 | 23 | |||
32841 | 103295 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2013 12:00:00 AM | 3x3 | Permit Number 769976 | 6011114.9 | 2121460 | 37.805750773231 | -122.405802839637 | (37.805750773231, -122.405802839637) | 3 | 1 | 10 | 308 | 23 | ||
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 | ||||
119534 | 103297 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011114.9 | 2121460 | 37.805750773231 | -122.405802839637 | (37.805750773231, -122.405802839637) | 3 | 1 | 10 | 308 | 23 | ||||
59241 | 10336 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 875 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3x3 | 6002010.71574 | 2109090.04543 | 37.7712727083875 | -122.436423281121 | (37.7712727083875, -122.436423281121) | 15 | 5 | 11 | 29492 | 9 | |||
55282 | 10339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 909 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6001759.52079 | 2109063.5631 | 37.7711857178722 | -122.437290277033 | (37.7711857178722, -122.437290277033) | 15 | 5 | 11 | 29492 | 9 | |||
142092 | 103395 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011804.04588 | 2113336.48375 | 37.7834840583752 | -122.402846243553 | (37.7834840583752, -122.402846243553) | 12 | 2 | 9 | 28853 | 6 | |||
53309 | 103396 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011787.04234 | 2113349.22231 | 37.7835180860448 | -122.402905965761 | (37.7835180860448, -122.402905965761) | 12 | 2 | 9 | 28853 | 6 | |||
24374 | 103397 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011771.95062 | 2113367.11891 | 37.7835663832121 | -122.402959436735 | (37.7835663832121, -122.402959436735) | 12 | 2 | 9 | 28853 | 6 | |||
100960 | 103398 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011762.04295 | 2113383.3111 | 37.7836102899282 | -122.402994852925 | (37.7836102899282, -122.402994852925) | 12 | 2 | 9 | 28853 | 6 | |||
132044 | 103399 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011743.25822 | 2113397.28532 | 37.7836476108882 | -122.40306082452 | (37.7836476108882, -122.40306082452) | 12 | 2 | 9 | 28853 | 6 | |||
185213 | 103400 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011724.21862 | 2113418.46026 | 37.7837046890697 | -122.403128184612 | (37.7837046890697, -122.403128184612) | 12 | 2 | 9 | 28853 | 6 | |||
40873 | 103401 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011708.45991 | 2113433.17246 | 37.7837442052684 | -122.403183739337 | (37.7837442052684, -122.403183739337) | 12 | 2 | 9 | 28853 | 6 | |||
167317 | 103402 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011637.61738 | 2113512.76778 | 37.7839587987936 | -122.403434430759 | (37.7839587987936, -122.403434430759) | 12 | 2 | 9 | 28853 | 6 | |||
49775 | 103403 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011624.64349 | 2113526.22397 | 37.7839950216848 | -122.403480262927 | (37.7839950216848, -122.403480262927) | 12 | 2 | 9 | 28853 | 6 | |||
96835 | 103404 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011601.89477 | 2113542.67711 | 37.784038927485 | -122.403560123617 | (37.784038927485, -122.403560123617) | 12 | 2 | 9 | 28853 | 6 | |||
117282 | 103405 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011582.42981 | 2113562.66172 | 37.7840927132497 | -122.403628872269 | (37.7840927132497, -122.403628872269) | 12 | 2 | 9 | 28853 | 6 | |||
18099 | 103406 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011568.485 | 2113577.7367 | 37.7841333266454 | -122.403678177607 | (37.7841333266454, -122.403678177607) | 12 | 2 | 9 | 28853 | 6 | |||
47230 | 103407 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 135X 04th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x | 6011577.4 | 2113547.3 | 37.7840502526039 | -122.40364519248 | (37.7840502526039, -122.40364519248) | 12 | 2 | 9 | 28853 | 6 | |||
28651 | 10347 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 962 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001436.23476 | 2109145.46871 | 37.7713922269598 | -122.438414402641 | (37.7713922269598, -122.438414402641) | 15 | 5 | 11 | 29492 | 9 | |||
68679 | 10351 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1996 12:00:00 AM | 20 | 3X3 | 6001254.26782 | 2108983.9584 | 37.7709384079004 | -122.439032256649 | (37.7709384079004, -122.439032256649) | 15 | 5 | 11 | 29492 | 9 | ||
60484 | 10353 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1001 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1996 12:00:00 AM | 20 | 3X3 | 6001294.95679 | 2108989.91876 | 37.770957088625 | -122.438891939912 | (37.770957088625, -122.438891939912) | 15 | 5 | 11 | 29492 | 9 | ||
181815 | 103537 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1591 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 4 | 3x3 | Permit Number 768802 | 6006581.82266 | 2117639.93619 | 37.7950072974951 | -122.421218823704 | (37.7950072974951, -122.421218823704) | 13 | 9 | 10 | 28858 | 32 | |
149421 | 103538 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1591 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 4 | 3x3 | Permit Number 768802 | 6006598.35786 | 2117641.48558 | 37.7950124839021 | -122.421161719436 | (37.7950124839021, -122.421161719436) | 13 | 9 | 10 | 28858 | 32 | |
125255 | 103539 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1591 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 4 | 3x3 | Permit Number 768802 | 6006627.09414 | 2117645.99593 | 37.7950264881324 | -122.421062607876 | (37.7950264881324, -122.421062607876) | 13 | 9 | 10 | 28858 | 32 | |
82568 | 103540 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1591 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 4 | 3x3 | Permit Number 768802 | 6006641.55504 | 2117648.15456 | 37.7950332303568 | -122.42101272426 | (37.7950332303568, -122.42101272426) | 13 | 9 | 10 | 28858 | 32 | |
186676 | 103541 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1980X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 3x3 | Permit Number 768802 | 6006505.8 | 2117586.8 | 37.7948571127085 | -122.421478098294 | (37.7948571127085, -122.421478098294) | 13 | 9 | 10 | 28858 | 32 | ||
89205 | 103542 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1980X Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 3x3 | Permit Number 768802 | 6006505.8 | 2117586.8 | 37.7948571127085 | -122.421478098294 | (37.7948571127085, -122.421478098294) | 13 | 9 | 10 | 28858 | 32 | ||
76833 | 103543 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1980X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2013 12:00:00 AM | 3x3 | Permit Number 768802 | 6006505.8 | 2117586.8 | 37.7948571127085 | -122.421478098294 | (37.7948571127085, -122.421478098294) | 13 | 9 | 10 | 28858 | 32 | ||
154423 | 10355 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1035 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2010 12:00:00 AM | 3 | 3X3 | 6001185.9741 | 2108962.09932 | 37.7708745022666 | -122.439266918906 | (37.7708745022666, -122.439266918906) | 15 | 5 | 11 | 29492 | 9 | ||
95768 | 10356 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1042 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:24:00 AM | 3 | 3X4 | 6001128.7744 | 2109024.6598 | 37.771043022581 | -122.439469258885 | (37.771043022581, -122.439469258885) | 15 | 5 | 11 | 29492 | 9 | ||
134378 | 10357 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1048 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:20:00 AM | 3 | 3X4 | 6001073.8613 | 2109016.4111 | 37.7710172483753 | -122.439658613152 | (37.7710172483753, -122.439658613152) | 15 | 5 | 11 | 29492 | 9 | ||
138200 | 10358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1061 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1992 12:00:00 AM | 30 | 3X3 | 6001062.65732 | 2108960.15475 | 37.7708621447883 | -122.439693334178 | (37.7708621447883, -122.439693334178) | 15 | 5 | 11 | 29492 | 9 | ||
125208 | 10361 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1120 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1992 12:00:00 AM | 25 | 3x3 | 6000761.6429 | 2108968.77698 | 37.7708686815329 | -122.440735166012 | (37.7708686815329, -122.440735166012) | 15 | 5 | 11 | 29492 | 9 | ||
135960 | 103695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.7560363783091 | -122.422127839194 | (37.7560363783091, -122.422127839194) | 2 | 4 | 5 | 28859 | 19 | |
38179 | 10378 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1310 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1990 12:00:00 AM | 30 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635 | (37.7705521343685, -122.44395792635) | 15 | 5 | 11 | 29492 | 9 | ||
79792 | 103898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2121 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2013 12:00:00 AM | 9 | 4x4 | Permit Number 769266 | 6015775.39274 | 2105694.80239 | 37.7627226324605 | -122.388573217603 | (37.7627226324605, -122.388573217603) | 10 | 3 | 8 | 28856 | 29 | |
140230 | 103899 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2121 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2013 12:00:00 AM | 3 | 4x4 | Permit Number 769266 | 6015775.77867 | 2105713.92356 | 37.7627751564662 | -122.388573217579 | (37.7627751564662, -122.388573217579) | 10 | 3 | 8 | 28856 | 29 | |
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 | ||
108595 | 10405 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1378 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 08:06:00 AM | 3 | 3x3 | 5999558.6304 | 2108799.6331 | 37.7703356719078 | -122.444884239596 | (37.7703356719078, -122.444884239596) | 15 | 5 | 11 | 29492 | 9 | ||
32275 | 104232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 298X Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2015 12:00:00 AM | 3 | 6x6 | Permit Number 771309 | 5997366.55609 | 2109687.30332 | 37.7726476392362 | -122.452530652813 | (37.7726476392362, -122.452530652813) | 15 | 5 | 11 | 29492 | 16 | |
145148 | 10430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1430 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2003 12:00:00 AM | 12 | 3X3 | 5999234.911 | 2108753.3373 | 37.7701900752827 | -122.446000650118 | (37.7701900752827, -122.446000650118) | 15 | 5 | 11 | 29492 | 9 | ||
172399 | 104344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6014997.70938 | 2104304.04046 | 37.7588607718232 | -122.391165752619 | (37.7588607718232, -122.391165752619) | 10 | 3 | 8 | 28856 | 29 | ||||
117698 | 104345 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014995.86461 | 2104338.49081 | 37.7589552627061 | -122.391174540789 | (37.7589552627061, -122.391174540789) | 10 | 3 | 8 | 28856 | 29 |
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) );