trees
246 rows where qSpecies_id = 20 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22680 | 46900 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1357 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44956 | 5991106.29954004 | 2106174.99705817 | 37.7626431240146 | -122.473929035532 | (37.7626431240146, -122.473929035532) | 1 | 8 | 11 | 56 | 12 | ||
30898 | 254205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | ||||
40861 | 85261 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2998 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989779.1 | 2095328.3 | 37.7327839760928 | -122.477726384657 | (37.7327839760928, -122.477726384657) | 1 | 8 | 4 | 64 | 35 | |||
48235 | 38441 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2591 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1998 12:00:00 AM | Permit Number 40466 | 5992043.6333811 | 2097820.82323466 | 37.7397589768558 | -122.470078824326 | (37.7397589768558, -122.470078824326) | 1 | 8 | 4 | 59 | 40 | |||
77081 | 44219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 43665 | 5987260.984 | 2100720.2895 | 37.7474424963194 | -122.486827848138 | (37.7474424963194, -122.486827848138) | 1 | 8 | 3 | 29491 | 35 | |||
80382 | 37200 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 0 | Permit Number 39767 | 5986185.22517174 | 2104866.53832379 | 37.7587641880882 | -122.490852744095 | (37.7587641880882, -122.490852744095) | 1 | 8 | 3 | 56 | 35 | |
92543 | 183390 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2673 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989554.4883 | 2097163.7436 | 37.7378105948151 | -122.478637096313 | (37.7378105948151, -122.478637096313) | 1 | 8 | 3 | 29491 | 35 | |||
100896 | 45081 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | 1 | 8 | 3 | 29491 | 35 | ||
115190 | 97119 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
124243 | 37205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1579 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39772 | 5986201.0748 | 2104494.9459 | 37.7577448234718 | -122.490770587951 | (37.7577448234718, -122.490770587951) | 1 | 8 | 3 | 56 | 35 | |
149031 | 177298 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988403.4281 | 2091243.72009 | 37.721488831717 | -122.482183231171 | (37.721488831717, -122.482183231171) | 1 | 8 | 4 | 64 | 14 | ||||
157092 | 97121 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
184259 | 97120 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
185492 | 44220 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2001 12:00:00 AM | 2 | Permit Number 43665 | 5987262.4786 | 2100698.6187 | 37.74738308124 | -122.486821088856 | (37.74738308124, -122.486821088856) | 1 | 8 | 3 | 29491 | 35 | ||
186826 | 254204 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781022 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | |
193435 | 45082 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | 1 | 8 | 3 | 29491 | 35 | ||
17535 | 49781 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 308@ BLANKEN Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 6 | Permit Number 46566 | 6012565.76433 | 2086991.30055 | 37.7111883387537 | -122.398361863208 | (37.7111883387537, -122.398361863208) | 10 | 3 | 8 | 309 | 1 | |
19925 | 229241 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009182.18967 | 2098038.44408 | 37.7413323942725 | -122.410836091326 | (37.7413323942725, -122.410836091326) | 10 | 7 | 7 | 28859 | 2 | |||
23138 | 55180 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 91 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1987 12:00:00 AM | 4 | Permit Number 24627 | 6013135.97557 | 2086935.85146 | 37.7110678340902 | -122.396387174153 | (37.7110678340902, -122.396387174153) | 10 | 3 | 8 | 309 | 1 | ||
33431 | 39987 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1430 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41245 | 6017109.13931221 | 2093820.25947236 | 37.7301913909688 | -122.383133682915 | (37.7301913909688, -122.383133682915) | 10 | 3 | 8 | 58 | 1 | |
48134 | 88833 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.7413024486906 | -122.41106600773 | (37.7413024486906, -122.41106600773) | 10 | 7 | 7 | 28859 | 2 | ||
83083 | 40054 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1294 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41290 | 6016570.04020415 | 2092976.75616645 | 37.7278454926494 | -122.384938693931 | (37.7278454926494, -122.384938693931) | 10 | 3 | 8 | 58 | 1 | ||
84940 | 68270 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 425 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773761 | 6009804.05619 | 2092417.85671 | 37.7259343110037 | -122.408289550324 | (37.7259343110037, -122.408289550324) | 10 | 3 | 7 | 309 | 28 | |
87868 | 40029 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1637 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014869.44662 | 2095922.83463 | 37.7358406185575 | -122.391023557209 | (37.7358406185575, -122.391023557209) | 10 | 3 | 8 | 58 | 1 | |
90447 | 88832 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.7413024486906 | -122.41106600773 | (37.7413024486906, -122.41106600773) | 10 | 7 | 7 | 28859 | 2 | ||
134610 | 229240 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009167.29555 | 2098038.41743 | 37.7413314859486 | -122.410887588289 | (37.7413314859486, -122.410887588289) | 10 | 7 | 7 | 28859 | 2 | |||
142205 | 200499 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1082 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6013591.41 | 2089958.2062 | 37.7193919575312 | -122.395024624648 | (37.7193919575312, -122.395024624648) | 10 | 3 | 8 | 58 | 1 | |||
150998 | 229239 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009149.94921 | 2098041.78953 | 37.7413397723193 | -122.410947804196 | (37.7413397723193, -122.410947804196) | 10 | 7 | 7 | 28859 | 2 | |||
162731 | 27135 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1921 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1999 12:00:00 AM | 7 | 2X3 | 6011851.93655 | 2095690.98382 | 37.7350361003237 | -122.401440051024 | (37.7350361003237, -122.401440051024) | 10 | 3 | 8 | 58 | 1 | ||
184881 | 177297 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 Nueva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012935.72172 | 2087140.54754 | 37.7116187434797 | -122.397093648265 | (37.7116187434797, -122.397093648265) | 10 | 3 | 8 | 309 | 1 | |||
188919 | 88831 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.7413024486906 | -122.41106600773 | (37.7413024486906, -122.41106600773) | 10 | 7 | 7 | 28859 | 2 | ||
4560 | 47095 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 356 Willard North St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45077 | 5996301.73927169 | 2110554.62831554 | 37.7749680212207 | -122.456276668944 | (37.7749680212207, -122.456276668944) | 11 | 6 | 2 | 54 | 16 | ||
25917 | 123969 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993630.62281 | 2114735.81846 | 37.7862947425232 | -122.46582041968 | (37.7862947425232, -122.46582041968) | 11 | 6 | 2 | 54 | 11 | |||
30320 | 110153 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 267 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775195 | 5988018.8 | 2114202.3 | 37.7845045397665 | -122.485196475776 | (37.7845045397665, -122.485196475776) | 11 | 6 | 2 | 55 | 26 | |
49263 | 123604 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 288 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994649.79815 | 2113605.55206 | 37.7832500744158 | -122.462212359722 | (37.7832500744158, -122.462212359722) | 11 | 6 | 2 | 54 | 11 | |||
49315 | 141042 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996531.5303 | 2113164.047 | 37.7821459864366 | -122.45567043332 | (37.7821459864366, -122.45567043332) | 11 | 6 | 1 | 54 | 31 | |||
52550 | 38836 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
70046 | 40802 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 121 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | 4 | Permit Number 41751 | 5996513.2556 | 2113630.7306 | 37.7834263270019 | -122.455767400466 | (37.7834263270019, -122.455767400466) | 11 | 6 | 1 | 54 | 31 | ||
76771 | 2767 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 238 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2016 12:00:00 AM | 3 | 3X3 | 5994814.49115 | 2110801.12928 | 37.775559360496 | -122.461439216572 | (37.775559360496, -122.461439216572) | 11 | 6 | 2 | 54 | 11 | ||
81612 | 117729 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5983475.64973 | 2112834.36493 | 37.7804828918797 | -122.500812777933 | (37.7804828918797, -122.500812777933) | 11 | 6 | 2 | 55 | 26 | |||
102327 | 36962 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 146 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39591 | 5994303.22649 | 2114557.05479 | 37.785842681857 | -122.463480424277 | (37.785842681857, -122.463480424277) | 11 | 6 | 1 | 54 | 11 | |
109450 | 68582 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32479 | 5996530.1767 | 2113176.907 | 37.7821812189094 | -122.455676045985 | (37.7821812189094, -122.455676045985) | 11 | 6 | 1 | 54 | 31 | ||
115382 | 41122 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2344 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | 11 | 5 | 2 | 54 | 16 | ||
121565 | 123605 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 288 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994650.61525 | 2113597.37697 | 37.78322767487 | -122.462208939817 | (37.78322767487, -122.462208939817) | 11 | 6 | 2 | 54 | 11 | |||
149416 | 38837 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
155231 | 41120 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2344 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | 11 | 5 | 2 | 54 | 16 | ||
157847 | 124522 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 51 Parsons St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996562.78722 | 2110517.36103 | 37.7748806768667 | -122.455370959381 | (37.7748806768667, -122.455370959381) | 11 | 6 | 2 | 54 | 16 | |||
159123 | 1680 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 12 | 3X3 | 5994348.50119 | 2111464.79497 | 37.7773547778944 | -122.463099340943 | (37.7773547778944, -122.463099340943) | 11 | 6 | 2 | 54 | 11 | ||
159254 | 38335 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 47950 | 5983475.92441 | 2112817.71297 | 37.7804371865901 | -122.500810595919 | (37.7804371865901, -122.500810595919) | 11 | 6 | 2 | 55 | 26 | ||
160681 | 38834 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
161225 | 41119 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2344 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | 11 | 5 | 2 | 54 | 16 | ||
177265 | 21847 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 202X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 3 | 3X3 | 5994968.90714 | 2110807.33222 | 37.7755852784786 | -122.460905507707 | (37.7755852784786, -122.460905507707) | 11 | 6 | 2 | 54 | 11 | ||
190510 | 41121 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2344 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | 11 | 5 | 2 | 54 | 16 | ||
190537 | 123699 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 302 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994616.48583 | 2111473.74211 | 37.777394777876 | -122.462172950615 | (37.777394777876, -122.462172950615) | 11 | 6 | 2 | 54 | 11 | |||
5802 | 62147 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2057 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 3 | Permit Number 22261 | 5999361.52655 | 2121151.92571 | 37.8042405839018 | -122.446454803956 | (37.8042405839018, -122.446454803956) | 13 | 9 | 1 | 57 | 17 | |
8722 | 130434 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2701 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001177.09215 | 2116887.43491 | 37.7926349471062 | -122.439865967752 | (37.7926349471062, -122.439865967752) | 13 | 6 | 1 | 29490 | 27 | |||
20359 | 111160 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.432653690929 | (37.8007635719416, -122.432653690929) | 13 | 9 | 1 | 57 | 17 | |||
35594 | 111164 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003392.25539 | 2119813.00098 | 37.8007936407819 | -122.432410472862 | (37.8007936407819, -122.432410472862) | 13 | 9 | 1 | 57 | 17 | |||
52323 | 130435 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2127 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6003305.56754 | 2117513.80582 | 37.7944757298119 | -122.432546129322 | (37.7944757298119, -122.432546129322) | 13 | 9 | 1 | 29490 | 27 | |||
53984 | 45168 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
58828 | 110905 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2891 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999766.16076 | 2117386.55705 | 37.7939249895015 | -122.444783719687 | (37.7939249895015, -122.444783719687) | 13 | 9 | 1 | 57 | 27 | |
64224 | 130432 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2824 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999398.65268 | 2118424.75751 | 37.7967546325742 | -122.446130041675 | (37.7967546325742, -122.446130041675) | 13 | 9 | 1 | 57 | 17 | |||
64634 | 45170 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
85882 | 18881 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2323 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003542.78856 | 2115901.08421 | 37.7900610577291 | -122.431610123004 | (37.7900610577291, -122.431610123004) | 13 | 9 | 1 | 29490 | 27 | ||
107681 | 111163 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003374.28365 | 2119810.99129 | 37.8007871036097 | -122.432472518919 | (37.8007871036097, -122.432472518919) | 13 | 9 | 1 | 57 | 17 | |||
117311 | 111161 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003338.31122 | 2119805.54449 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | 13 | 9 | 1 | 57 | 17 | |||
126173 | 111165 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.8008027913768 | -122.432345118256 | (37.8008027913768, -122.432345118256) | 13 | 9 | 1 | 57 | 17 | |||
137511 | 111162 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003355.09781 | 2119808.05454 | 37.8007779520905 | -122.4325387 | (37.8007779520905, -122.4325387) | 13 | 9 | 1 | 57 | 17 | |||
140173 | 45167 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
151888 | 45169 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
12536 | 43291 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 123 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 7 | Permit Number 43059 | 6013181.78147 | 2106427.07637 | 37.7645892203513 | -122.397595020318 | (37.7645892203513, -122.397595020318) | 14 | 3 | 8 | 28856 | 29 | |
30930 | 192814 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013571.38168 | 2106139.70119 | 37.7638218378314 | -122.396227345714 | (37.7638218378314, -122.396227345714) | 14 | 3 | 8 | 28856 | 29 | |||
105157 | 117202 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 298 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013997.81154 | 2105821.62372 | 37.7629721853348 | -122.394730166958 | (37.7629721853348, -122.394730166958) | 14 | 3 | 8 | 28856 | 29 | |||
160329 | 117201 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 298 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013997.02726 | 2105851.29667 | 37.7630536171528 | -122.394734957662 | (37.7630536171528, -122.394734957662) | 14 | 3 | 8 | 28856 | 29 | |||
178625 | 192813 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013542.5057 | 2106139.39713 | 37.7638193961669 | -122.396327198343 | (37.7638193961669, -122.396327198343) | 14 | 3 | 8 | 28856 | 29 | |||
179310 | 42243 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 547 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.7792163405696 | -122.408779938797 | (37.7792163405696, -122.408779938797) | 14 | 2 | 9 | 28853 | 34 | ||
189499 | 42244 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 547 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.7792163405696 | -122.408779938797 | (37.7792163405696, -122.408779938797) | 14 | 2 | 9 | 28853 | 34 | ||
35 | 16620 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1999 12:00:00 AM | 6 | 3X3 | 6002913 | 2107540 | 37.7670678918229 | -122.433191472284 | (37.7670678918229, -122.433191472284) | 15 | 5 | 5 | 28862 | 3 | ||
12464 | 229252 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001736.09856 | 2107829.47275 | 37.7677958798953 | -122.43728291608 | (37.7677958798953, -122.43728291608) | 15 | 5 | 5 | 29492 | 3 | |||
25342 | 7018 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1055 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 2 | 3X3 | 6002378.8301 | 2110180.8206 | 37.7742886166676 | -122.435227992558 | (37.7742886166676, -122.435227992558) | 15 | 5 | 11 | 29492 | 10 | ||
31440 | 229253 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 245 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000709.62827 | 2106546.14051 | 37.7642137623885 | -122.440741279694 | (37.7642137623885, -122.440741279694) | 15 | 5 | 5 | 28862 | 3 | |||
48201 | 42814 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3944 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42759 | 6003333.22216153 | 2105381.87042866 | 37.7611660186553 | -122.431583898012 | (37.7611660186553, -122.431583898012) | 15 | 4 | 5 | 28862 | 3 | ||
59467 | 41687 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 124 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42140 | 5999927.88161805 | 2106008.33179804 | 37.7626925227356 | -122.443406475957 | (37.7626925227356, -122.443406475957) | 15 | 5 | 5 | 28862 | 3 | ||
60221 | 50521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47159 | 5996798.3759 | 2112040.3174 | 37.7790758310411 | -122.454666063431 | (37.7790758310411, -122.454666063431) | 15 | 6 | 2 | 54 | 16 | |
68787 | 70836 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 239 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1994 12:00:00 AM | 3 | 5997827.1396 | 2109714.2746 | 37.7727480736245 | -122.450939398271 | (37.7727480736245, -122.450939398271) | 15 | 5 | 11 | 29492 | 16 | ||
79567 | 137580 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1150 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002381.2868 | 2112341.0686 | 37.7802202566686 | -122.435374054285 | (37.7802202566686, -122.435374054285) | 15 | 5 | 11 | 29490 | 41 | |||
98438 | 96573 | Undocumented 4 | Magnolia doltsopa :: Himalayan Magnolia 20 | 44 Levant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 5x6 | 6000274 | 2106572 | 37.7642599479849 | -122.442249845362 | (37.7642599479849, -122.442249845362) | 15 | 5 | 5 | 28862 | 3 | |||
104254 | 7016 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1055 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6002352.4572 | 2110178.4231 | 37.7742805360567 | -122.43531904959 | (37.7742805360567, -122.43531904959) | 15 | 5 | 11 | 29492 | 10 | |||
108785 | 141622 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1801 GROVE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998881.826 | 2110394.3314 | 37.7746756578154 | -122.447340091401 | (37.7746756578154, -122.447340091401) | 15 | 5 | 11 | 29492 | 16 | |||
120165 | 48972 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 135 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46159 | 6003310.63727526 | 2108787.86549198 | 37.7705167748166 | -122.431905219461 | (37.7705167748166, -122.431905219461) | 15 | 9 | 5 | 29492 | 9 | ||
136825 | 141620 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1801 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998848.2105 | 2110389.4859 | 37.7746604323894 | -122.447456024852 | (37.7746604323894, -122.447456024852) | 15 | 5 | 11 | 29492 | 16 | |||
160538 | 17695 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1100X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2004 12:00:00 AM | 3 | 3X3 | 6002388.932052 | 2112303.174651 | 37.7801166436013 | -122.435344894499 | (37.7801166436013, -122.435344894499) | 15 | 5 | 11 | 29490 | 41 | ||
187508 | 229254 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 157 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001282.99504 | 2106223.75237 | 37.7633611996826 | -122.438735069383 | (37.7633611996826, -122.438735069383) | 15 | 5 | 5 | 28862 | 3 | |||
5938 | 229255 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 260 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003887.38012 | 2097809.34417 | 37.7404050277631 | -122.429127352938 | (37.7404050277631, -122.429127352938) | 2 | 7 | 5 | 63 | 7 | |||
7571 | 237826 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785232 | 6002395.63458 | 2097149.51403 | 37.7385087290057 | -122.434238055364 | (37.7385087290057, -122.434238055364) | 2 | 7 | 5 | 63 | 7 | |
19877 | 246803 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6010372.78366 | 2099322.13571 | 37.7449238197814 | -122.406809864293 | (37.7449238197814, -122.406809864293) | 2 | 7 | 7 | 28859 | 2 | |||
22730 | 4491 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1608 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 3 | 3X3 | 6004562.86857 | 2099453.04475 | 37.7449564687567 | -122.426908813616 | (37.7449564687567, -122.426908813616) | 2 | 7 | 5 | 63 | 22 | ||
24435 | 46337 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3703 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51341 | 6005824.5079347 | 2100789.51596522 | 37.7486973702763 | -122.422641242993 | (37.7486973702763, -122.422641242993) | 2 | 4 | 5 | 28859 | 19 | |
30277 | 25186 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3644 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 3 | 3X3 | 6000415.91154 | 2103347.84626 | 37.7554153008829 | -122.441527633417 | (37.7554153008829, -122.441527633417) | 2 | 4 | 5 | 63 | 38 | ||
30911 | 39141 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1088 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40819 | 6007414.12012463 | 2100977.25645313 | 37.7493024177021 | -122.417157664156 | (37.7493024177021, -122.417157664156) | 2 | 4 | 7 | 28859 | 19 |
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) );