trees
7,322 rows where qSpecies_id = 1 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
99885 | 99952 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778491 | 5993609 | 2105311 | 37.760415458577 | -122.465210403501 | (37.760415458577, -122.465210403501) | 1 | 8 | 11 | 56 | 12 | |
30291 | 9995 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 GUERRERO ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 12:59:00 PM | 3 | 2X2 | 6005457 | 2108414 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | 8 | 4 | 5 | 28853 | 19 | ||
127988 | 9992 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 67 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/02/2014 12:00:00 AM | 3 | 2x2 | 6005450.48952 | 2108526.98568 | 37.7699215363694 | -122.424484887989 | (37.7699215363694, -122.424484887989) | 8 | 2 | 5 | 28853 | 19 | ||
189259 | 99893 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997893.2 | 2108079.1 | 37.7682620848422 | -122.450592979377 | (37.7682620848422, -122.450592979377) | 15 | 5 | 11 | 29492 | 9 | |||||
171788 | 99880 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 768615 | 5999995.5 | 2091667 | 37.7233185016187 | -122.442143097817 | (37.7233185016187, -122.442143097817) | 9 | 7 | 6 | 28861 | 25 | ||
59229 | 99839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
26866 | 99838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
134457 | 99837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
50351 | 99836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
122538 | 99835 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
162365 | 99806 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4141 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002241 | 2102354 | 37.7527902465656 | -122.435144849965 | (37.7527902465656, -122.435144849965) | 2 | 4 | 5 | 28862 | 22 | |||
176522 | 99782 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4238-4240 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001648 | 2101771 | 37.7511557768566 | -122.437153809999 | (37.7511557768566, -122.437153809999) | 2 | 4 | 5 | 28862 | 22 | ||||
99688 | 99627 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2389 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | 4 | 6x10 | Permit Number 768863 | 6003328.26592 | 2116532.46568 | 37.7917825084999 | -122.432397466871 | (37.7917825084999, -122.432397466871) | 13 | 9 | 1 | 29490 | 27 | |
165485 | 99626 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2389 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | 4 | 6x10 | Permit Number 768863 | 6003304.80228 | 2116527.31144 | 37.7917670257707 | -122.432478282647 | (37.7917670257707, -122.432478282647) | 13 | 9 | 1 | 29490 | 27 | |
70290 | 99625 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2389@Webster Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6003285.62004 | 2116523.83125 | 37.7917563822899 | -122.432544404399 | (37.7917563822899, -122.432544404399) | 13 | 9 | 1 | 29490 | 27 | ||||
97231 | 99575 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
28026 | 99572 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
36173 | 99571 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
41703 | 99570 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
139161 | 99569 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
65669 | 99568 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
181618 | 99566 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
80187 | 99562 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
186095 | 995 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1682 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6001498.32617 | 2092340.42161 | 37.7252530968672 | -122.436996309494 | (37.7252530968672, -122.436996309494) | 9 | 7 | 6 | 28861 | 25 | ||
101890 | 9940 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X Green St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:48:00 AM | 3 | 6X6 | 6010123.5350709 | 2119222.6779084 | 37.799552149361 | -122.409075654051 | (37.799552149361, -122.409075654051) | 3 | 1 | 10 | 308 | 23 | ||
163665 | 99284 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5300 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999716.45637 | 2088484.78923 | 37.7145649689999 | -122.442879291365 | (37.7145649689999, -122.442879291365) | 9 | 7 | 6 | 28861 | 25 | ||||
65130 | 98810 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290 Napoleon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768677 | 6011851.72371 | 2099735.54003 | 37.7461415800639 | -122.401724983247 | (37.7461415800639, -122.401724983247) | 10 | 3 | 8 | 58 | 1 | |
188788 | 98709 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 900X Kirkham St | 1 | Median : Cutout | Tree | DPW 1 | 09/25/2015 02:24:00 PM | 3 | 4x5 | 5992115.8 | 2105255.5 | 37.7601768490492 | -122.4703706017 | (37.7601768490492, -122.4703706017) | 1 | 8 | 4 | 56 | 12 | ||
44061 | 98652 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801@Jones Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49829 | 6008750 | 2115238 | 37.7885341615981 | -122.413546621934 | (37.7885341615981, -122.413546621934) | 5 | 1 | 10 | 28858 | 21 | |||
46091 | 98406 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778181 | 5994692.2 | 2088928.8 | 37.7154963945459 | -122.460277182084 | (37.7154963945459, -122.460277182084) | 9 | 8 | 6 | 28861 | 24 | |
135599 | 98336 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1608 NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768070 | 5989032 | 2103102 | 37.7540851341578 | -122.480878211589 | (37.7540851341578, -122.480878211589) | 1 | 8 | 3 | 56 | 35 | |||
11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
96602 | 98126 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298X Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010839.8 | 2102289.6 | 37.7530979479228 | -122.40540394341 | (37.7530979479228, -122.40540394341) | 10 | 4 | 8 | 28859 | 19 | |||
11104 | 98125 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298X Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010839.8 | 2102289.6 | 37.7530979479228 | -122.40540394341 | (37.7530979479228, -122.40540394341) | 10 | 4 | 8 | 28859 | 19 | |||
155467 | 98124 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298X Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010839.8 | 2102289.6 | 37.7530979479228 | -122.40540394341 | (37.7530979479228, -122.40540394341) | 10 | 4 | 8 | 28859 | 19 | |||
13084 | 98064 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | ||
81525 | 98063 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | ||
152551 | 98062 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | ||
172936 | 98057 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
177327 | 98056 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
143316 | 98055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
73844 | 98054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
126348 | 98053 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
104243 | 98051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
170774 | 98050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
20360 | 98049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
41973 | 98046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
75773 | 98045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
96492 | 98011 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1515 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2016 01:11:00 PM | 3 | 3x3 | 5988539 | 2098972 | 37.7427165815391 | -122.48228053628 | (37.7427165815391, -122.48228053628) | 1 | 8 | 3 | 29491 | 35 | ||
174238 | 97957 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2270 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 3x3 | Permit Number 768057 | 6011896.3 | 2098543.4 | 37.7428707065024 | -122.401487073764 | (37.7428707065024, -122.401487073764) | 10 | 3 | 8 | 58 | 1 | ||
75597 | 97943 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3003 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768278 | 5999754.41157 | 2116356.69568 | 37.791096591089 | -122.444750312601 | (37.791096591089, -122.444750312601) | 13 | 6 | 1 | 29490 | 27 | |
190543 | 97795 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
72999 | 97794 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
50906 | 97793 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
137486 | 97768 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | 2x2 | Permit Number 768293 | 5997581.484 | 2113820.4161 | 37.7840084005471 | -122.452085457513 | (37.7840084005471, -122.452085457513) | 15 | 6 | 1 | 54 | 31 | |
46139 | 97767 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | 2x2 | Permit Number 768293 | 5997562.8708 | 2113817.3703 | 37.783998971375 | -122.452149632238 | (37.783998971375, -122.452149632238) | 15 | 6 | 1 | 54 | 31 | |
151130 | 97735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.979 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) | 5 | 9 | 1 | 28858 | 32 |
114590 | 97692 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 70x Benton Ave | 1 | Median : Yard | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 6004768.61645 | 2094959.04842 | 37.7326286038687 | -122.425877544976 | (37.7326286038687, -122.425877544976) | 2 | 7 | 7 | 28861 | 2 | ||||
96709 | 97691 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290X Granada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 5 | 3x3 | 5995678.43703 | 2091959.07351 | 37.7238734898354 | -122.457087393383 | (37.7238734898354, -122.457087393383) | 9 | 8 | 4 | 28861 | 24 | ||
104834 | 97688 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290X Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 5 | 3x3 | 5995677.47528 | 2091905.34979 | 37.7237259220846 | -122.457086833708 | (37.7237259220846, -122.457086833708) | 9 | 8 | 4 | 28861 | 24 | ||
59091 | 97326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 1 | 3x3 | 5989724.8526 | 2098996.695 | 37.7428532946662 | -122.47818204792 | (37.7428532946662, -122.47818204792) | 1 | 8 | 3 | 29491 | 35 | ||
86362 | 97315 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1007 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990088.3176 | 2099007.1861 | 37.7429031920496 | -122.476926067611 | (37.7429031920496, -122.476926067611) | 1 | 8 | 3 | 29491 | 35 | ||
77962 | 97291 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778496 | 6005288 | 2108881 | 37.7708843970709 | -122.425072128908 | (37.7708843970709, -122.425072128908) | 7 | 9 | 5 | 28852 | 10 | ||
162331 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
112259 | 97168 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 519 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011311.19047 | 2109913.80768 | 37.7740586534059 | -122.404310357843 | (37.7740586534059, -122.404310357843) | 14 | 2 | 9 | 28853 | 34 | |||
147354 | 97167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 262 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6010129.00149 | 2111054.10104 | 37.7771235015924 | -122.40848022278 | (37.7771235015924, -122.40848022278) | 8 | 2 | 9 | 28853 | 34 | ||||
40737 | 97165 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 262 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 6010119.55903 | 2111062.91718 | 37.7771471798471 | -122.408513509413 | (37.7771471798471, -122.408513509413) | 8 | 2 | 9 | 28853 | 34 | ||||
81806 | 97117 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 943 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005742 | 2103481 | 37.7560829087408 | -122.423117838299 | (37.7560829087408, -122.423117838299) | 2 | 4 | 5 | 28859 | 19 | |||||
111270 | 97116 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 943 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005742 | 2103481 | 37.7560829087408 | -122.423117838299 | (37.7560829087408, -122.423117838299) | 2 | 4 | 5 | 28859 | 19 | |||||
135836 | 97115 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 766 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2014 12:00:00 AM | 3 | 3x3 | 6005595 | 2104505 | 37.7588862768919 | -122.42369901889 | (37.7588862768919, -122.42369901889) | 2 | 4 | 5 | 28859 | 19 | ||
154587 | 97095 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2829 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2011 12:00:00 AM | 3x3 | Permit Number 768004 | 6001223.6 | 2115887.2 | 37.7898912091521 | -122.439633309933 | (37.7898912091521, -122.439633309933) | 13 | 6 | 1 | 29490 | 27 | ||
117024 | 96891 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | 3x3 | 6000536.2 | 2102231.9 | 37.7523580354324 | -122.441031584455 | (37.7523580354324, -122.441031584455) | 2 | 4 | 5 | 28862 | 22 | ||
65137 | 96867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 620 Palmetto Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991882.45781 | 2087240.6995 | 37.7106992550313 | -122.469865986023 | (37.7106992550313, -122.469865986023) | 9 | 8 | 4 | 64 | 24 | |||
173179 | 96865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 620 Palmetto Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5991908.43849 | 2087239.0013 | 37.7106960939316 | -122.469776068222 | (37.7106960939316, -122.469776068222) | 9 | 8 | 4 | 64 | 24 | |||
68910 | 96805 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 3x3 | Permit Number 771933 | 6011260.5 | 2118966.4 | 37.7989120989831 | -122.405123270049 | (37.7989120989831, -122.405123270049) | 3 | 1 | 10 | 308 | 23 | ||
169850 | 96586 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6323 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013217.1012 | 2090358.8553 | 37.7204712381328 | -122.396346547024 | (37.7204712381328, -122.396346547024) | 10 | 3 | 8 | 58 | 1 | |||
194100 | 96553 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 6 | 2.5x1.5 | Permit Number 770753 | 6009478 | 2092445 | 37.7259905771817 | -122.409418624248 | (37.7259905771817, -122.409418624248) | 10 | 3 | 7 | 309 | 28 | |
137882 | 96358 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 261 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767870 | 6009536 | 2097078 | 37.7387150557005 | -122.409544964001 | (37.7387150557005, -122.409544964001) | 10 | 7 | 7 | 28859 | 2 | |
163919 | 96253 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
11066 | 96252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
171369 | 96251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
135931 | 96250 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
164669 | 96249 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
45292 | 96248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
74520 | 96247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
158957 | 96131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 636 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767210 | 5999233.5422 | 2114450.3343 | 37.7858324854514 | -122.446415291884 | (37.7858324854514, -122.446415291884) | 15 | 6 | 1 | 29490 | 31 | |
70914 | 95896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1559 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767602 | 5988989.056 | 2104728.1345 | 37.7585475669755 | -122.481145784933 | (37.7585475669755, -122.481145784933) | 1 | 8 | 3 | 56 | 35 |
75893 | 95836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767566 | 6009695.5 | 2111491.7 | 37.778300758866 | -122.410010747212 | (37.778300758866, -122.410010747212) | 8 | 2 | 9 | 28853 | 34 | |
93893 | 95835 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767566 | 6009695.5 | 2111491.7 | 37.778300758866 | -122.410010747212 | (37.778300758866, -122.410010747212) | 8 | 2 | 9 | 28853 | 34 | |
75429 | 95834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767566 | 6009695.5 | 2111491.7 | 37.778300758866 | -122.410010747212 | (37.778300758866, -122.410010747212) | 8 | 2 | 9 | 28853 | 34 | |
44294 | 95824 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 521 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767559 | 6011277 | 2109901 | 37.7740215758453 | -122.404427727506 | (37.7740215758453, -122.404427727506) | 14 | 2 | 9 | 28853 | 34 |
64912 | 95803 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 894 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767547 | 6012123.74767 | 2104210.17826 | 37.7584431392632 | -122.401098713353 | (37.7584431392632, -122.401098713353) | 10 | 3 | 8 | 28856 | 29 |
189117 | 95800 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2132 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767544 | 6011808 | 2103749 | 37.7571592263593 | -122.4021582929 | (37.7571592263593, -122.4021582929) | 10 | 3 | 8 | 28856 | 29 | |
40273 | 95790 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 149 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767533 | 6005988.9 | 2106409.4 | 37.7641375394288 | -122.422472045587 | (37.7641375394288, -122.422472045587) | 8 | 4 | 5 | 28859 | 19 | |
138361 | 95773 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 126 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767508 | 6004644.83085 | 2092643.20464 | 37.7262628153707 | -122.426140692752 | (37.7262628153707, -122.426140692752) | 9 | 7 | 6 | 28861 | 5 |
145989 | 95759 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 726 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767496 | 6001862.99487 | 2089729.239 | 37.7181040965161 | -122.435548971002 | (37.7181040965161, -122.435548971002) | 9 | 7 | 6 | 28861 | 5 |
31251 | 95749 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 159 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767494 | 6003897.83061 | 2092880.65607 | 37.7268725548057 | -122.4287399538 | (37.7268725548057, -122.4287399538) | 9 | 7 | 6 | 28861 | 5 |
21046 | 95730 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 207 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767476 | 6004003.2 | 2092421.6 | 37.7256180518537 | -122.428342990208 | (37.7256180518537, -122.428342990208) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );