trees
7,322 rows where qSpecies_id = 1 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118685 | 15922 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5718 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1995 12:00:00 AM | 3 | 3X3 | 5997668.40751 | 2086814.83413 | 37.7098626786949 | -122.449837866439 | (37.7098626786949, -122.449837866439) | 9 | 7 | 6 | 28861 | 25 | ||
190109 | 30548 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.12319 | 2086532.40482 | 37.709881047334 | -122.401259311572 | (37.709881047334, -122.401259311572) | 10 | 3 | 8 | 309 | 1 | ||
67781 | 31020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 7 | Permit Number 43764 | 6002665.06815 | 2086718.08858 | 37.7098816606848 | -122.432561587743 | (37.7098816606848, -122.432561587743) | 9 | 7 | 6 | 28861 | 5 | |
46366 | 15921 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5718 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1999 12:00:00 AM | 3 | 3X3 | 5997690.80196 | 2086825.40786 | 37.7098929930475 | -122.449761228905 | (37.7098929930475, -122.449761228905) | 9 | 7 | 6 | 28861 | 25 | ||
164366 | 102734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5735 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770005 | 5997875.71647 | 2086830.45832 | 37.7099174384228 | -122.449122496232 | (37.7099174384228, -122.449122496232) | 9 | 7 | 6 | 28861 | 5 | |
38798 | 31007 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 106 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34781 | 6001462.17793128 | 2086756.21041895 | 37.7099180463866 | -122.436721720566 | (37.7099180463866, -122.436721720566) | 9 | 7 | 6 | 28861 | 5 | ||
132641 | 180216 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008232.1427 | 2086617.22115 | 37.7099188332604 | -122.413313545478 | (37.7099188332604, -122.413313545478) | 9 | 7 | 8 | 309 | 39 | |||
90552 | 255307 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 106 Drake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 03/13/1995 12:00:00 AM | 3x3 | Permit Number 34781 | 6001467.59688 | 2086758.78717 | 37.709925429543 | -122.436703176018 | (37.709925429543, -122.436703176018) | 9 | 7 | 6 | 28861 | 5 | ||
101486 | 102735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5735 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770005 | 5997893.47207 | 2086837.6698 | 37.7099382550256 | -122.449061648972 | (37.7099382550256, -122.449061648972) | 9 | 7 | 6 | 28861 | 5 | |
153111 | 30547 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011718.16033 | 2086553.89012 | 37.7099400437706 | -122.401260692024 | (37.7099400437706, -122.401260692024) | 10 | 3 | 8 | 309 | 1 | ||
93843 | 44737 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.47858 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | 9 | 8 | 4 | 64 | 24 | |
166139 | 179981 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Whittier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5998169.97204 | 2086845.49283 | 37.7099755454025 | -122.448106579751 | (37.7099755454025, -122.448106579751) | 9 | 7 | 6 | 28861 | 5 | |||
35820 | 253670 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001095 | 2086792 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | 9 | 7 | 6 | 28861 | 5 | ||||
187424 | 253671 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001095 | 2086792 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | 9 | 7 | 6 | 28861 | 5 | ||||
101217 | 30546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 8 | Permit Number 34540 | 6011718.58864 | 2086574.96985 | 37.7099979484159 | -122.401260692029 | (37.7099979484159, -122.401260692029) | 10 | 3 | 8 | 309 | 1 | ||
45584 | 15919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2016 12:00:00 AM | 3 | 3x3 | 5997805.8876413 | 2086862.4796366 | 37.710001367541 | -122.449366142312 | (37.710001367541, -122.449366142312) | 9 | 7 | 6 | 28861 | 25 | ||
67807 | 51974 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997805.51500265 | 2086863.40763228 | 37.7100038942899 | -122.449367497034 | (37.7100038942899, -122.449367497034) | 9 | 7 | 6 | 28861 | 25 | |||
152350 | 36234 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5698 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39264 | 5997821.10019036 | 2086869.6666529 | 37.7100219716333 | -122.449314082525 | (37.7100219716333, -122.449314082525) | 9 | 7 | 6 | 28861 | 25 | |
44999 | 180215 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 67 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008244.87242 | 2086654.93829 | 37.7100231114573 | -122.413272214455 | (37.7100231114573, -122.413272214455) | 9 | 7 | 8 | 309 | 39 | |||
188755 | 179982 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Whittier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5998163.83128 | 2086864.49654 | 37.7100273742347 | -122.448129170739 | (37.7100273742347, -122.448129170739) | 9 | 7 | 6 | 28861 | 5 | |||
179566 | 30545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011719.78338 | 2086594.44223 | 37.7100514823568 | -122.401257930211 | (37.7100514823568, -122.401257930211) | 10 | 3 | 8 | 309 | 1 | ||
189325 | 15914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1995 12:00:00 AM | 8 | 3x3 | 5997854.28803 | 2086889.62487 | 37.71007867067 | -122.449200816374 | (37.71007867067, -122.449200816374) | 9 | 7 | 6 | 28861 | 25 | ||
75356 | 179983 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Whittier St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5998155.09065 | 2086884.20518 | 37.7100809900133 | -122.448160798105 | (37.7100809900133, -122.448160798105) | 9 | 7 | 6 | 28861 | 5 | |||
189240 | 180185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010852.50351 | 2086625.63078 | 37.7100886954045 | -122.404257627902 | (37.7100886954045, -122.404257627902) | 10 | 3 | 8 | 309 | 1 | |||
86921 | 30544 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 10 | Permit Number 34540 | 6011720.93771 | 2086611.92604 | 37.7100995538248 | -122.401255168406 | (37.7100995538248, -122.401255168406) | 10 | 3 | 8 | 309 | 1 | ||
190158 | 15913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997872.74609 | 2086897.52065 | 37.7101014064224 | -122.44913759044 | (37.7101014064224, -122.44913759044) | 9 | 7 | 6 | 28861 | 25 | ||
140326 | 180214 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 61 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008256.77817 | 2086683.98233 | 37.7101035288322 | -122.41323311822 | (37.7101035288322, -122.41323311822) | 9 | 7 | 8 | 309 | 39 | |||
85999 | 51973 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1x FARRAGUT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997704 | 2086907 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | 9 | 7 | 6 | 28861 | 25 | |||
148481 | 51975 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1x FARRAGUT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997704 | 2086907 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | 9 | 7 | 6 | 28861 | 25 | |||
150100 | 252872 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:41:00 PM | 3 | 3x3 | 5997704 | 2086907 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | 9 | 7 | 6 | 28861 | 25 | ||
14152 | 180841 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Farragut Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:40:00 PM | 3 | Width 2ft | 5997726.08242 | 2086911.31353 | 37.7101308889069 | -122.449645479868 | (37.7101308889069, -122.449645479868) | 9 | 7 | 6 | 28861 | 25 | ||
16681 | 15918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5688X Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 5997918.76709 | 2086907.8121 | 37.7101322964969 | -122.448979274378 | (37.7101322964969, -122.448979274378) | 9 | 7 | 6 | 28861 | 25 | |||
41595 | 15917 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5688X Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5997918.76709 | 2086907.8121 | 37.7101322964969 | -122.448979274378 | (37.7101322964969, -122.448979274378) | 9 | 7 | 6 | 28861 | 25 | ||
141370 | 15916 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5688X Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5997918.76709 | 2086907.8121 | 37.7101322964969 | -122.448979274378 | (37.7101322964969, -122.448979274378) | 9 | 7 | 6 | 28861 | 25 | ||
161504 | 15912 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997904.34067 | 2086910.663 | 37.7101392993469 | -122.449029339958 | (37.7101392993469, -122.449029339958) | 9 | 7 | 6 | 28861 | 25 | ||
89287 | 179984 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Whittier St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5998143.81112 | 2086907.54659 | 37.7101444354003 | -122.448201461832 | (37.7101444354003, -122.448201461832) | 9 | 7 | 6 | 28861 | 5 | |||
5898 | 172286 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 930 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001778.14315 | 2086833.9607 | 37.7101494832819 | -122.435635245683 | (37.7101494832819, -122.435635245683) | 9 | 7 | 6 | 28861 | 5 | |||
174697 | 180213 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 57 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008263.9243 | 2086701.53775 | 37.7101521335973 | -122.413209660291 | (37.7101521335973, -122.413209660291) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
124977 | 179985 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 23 Whittier St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5998139.51533 | 2086920.97958 | 37.7101810737559 | -122.448217275509 | (37.7101810737559, -122.448217275509) | 9 | 7 | 6 | 28861 | 5 | |||
30345 | 180007 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Farragut Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997703.61722 | 2086934.20431 | 37.7101924564952 | -122.449724772183 | (37.7101924564952, -122.449724772183) | 9 | 7 | 6 | 28861 | 25 | |||
184673 | 180840 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Farragut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:40:00 PM | 3 | Width 2ft | 5997679.45955 | 2086959.01236 | 37.7102591915804 | -122.449810052203 | (37.7102591915804, -122.449810052203) | 9 | 7 | 6 | 28861 | 25 | ||
184868 | 15911 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997980.63633 | 2086954.06373 | 37.7102628311224 | -122.448768772168 | (37.7102628311224, -122.448768772168) | 9 | 7 | 6 | 28861 | 25 | ||
62283 | 65735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 381 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 9 | Permit Number 28671 | 6000320.287 | 2086910.79586 | 37.7102775422354 | -122.440679381145 | (37.7102775422354, -122.440679381145) | 9 | 7 | 6 | 28861 | 5 | |
87250 | 15910 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5694X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997998.29527 | 2086965.89776 | 37.7102963344846 | -122.448708591324 | (37.7102963344846, -122.448708591324) | 9 | 7 | 6 | 28861 | 25 | ||
47484 | 39205 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2188 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996320.5 | 2087005.2 | 37.7103081651051 | -122.454510201448 | (37.7103081651051, -122.454510201448) | 9 | 7 | 6 | 28861 | 25 | |
78341 | 39209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2188 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996320.5 | 2087005.2 | 37.7103081651051 | -122.454510201448 | (37.7103081651051, -122.454510201448) | 9 | 7 | 6 | 28861 | 25 | |
11078 | 172294 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1060 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6001118.32587 | 2086905.48332 | 37.7103083692161 | -122.437920820502 | (37.7103083692161, -122.437920820502) | 9 | 7 | 6 | 28861 | 5 | |||
190221 | 251737 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872 | 2086877 | 37.7103297297312 | -122.431857732336 | (37.7103297297312, -122.431857732336) | 9 | 7 | 6 | 28861 | 5 | ||
147404 | 36237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5680 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | 5 | Permit Number 39265 | 5998017.05297 | 2086978.62829 | 37.7103323622296 | -122.448644677426 | (37.7103323622296, -122.448644677426) | 9 | 7 | 6 | 28861 | 25 | ||
16580 | 39202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2188 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996345.10254 | 2087018.18263 | 37.7103452234142 | -122.454426107682 | (37.7103452234142, -122.454426107682) | 9 | 7 | 6 | 28861 | 25 | |
108272 | 65734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 366 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 7 | Permit Number 28670 | 6000278.09754 | 2086937.20541 | 37.7103476543028 | -122.440827089403 | (37.7103476543028, -122.440827089403) | 9 | 7 | 6 | 28861 | 5 | |
147328 | 180167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 388 Pope St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000605.77227 | 2086933.02981 | 37.7103548452706 | -122.439694280861 | (37.7103548452706, -122.439694280861) | 9 | 7 | 6 | 28861 | 5 | |||
194102 | 180212 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 51 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008290.64939 | 2086775.65834 | 37.7103571538246 | -122.413122530382 | (37.7103571538246, -122.413122530382) | 9 | 7 | 8 | 309 | 39 | |||
184800 | 39204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200X Sickles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996296.13951 | 2087023.89986 | 37.7103581134137 | -122.454595745896 | (37.7103581134137, -122.454595745896) | 9 | 7 | 6 | 28861 | 25 | |
126163 | 36238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5680 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | 3 | Permit Number 39265 | 5998035.86448 | 2086989.70728 | 37.7103638582632 | -122.448580458621 | (37.7103638582632, -122.448580458621) | 9 | 7 | 6 | 28861 | 25 | ||
33864 | 180166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 388 Pope St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000602.0664 | 2086944.56458 | 37.710386306254 | -122.439707915508 | (37.710386306254, -122.439707915508) | 9 | 7 | 6 | 28861 | 5 | |||
193875 | 36239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5680 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | 5 | Permit Number 39265 | 5998053.6023 | 2087000.49619 | 37.7103944963771 | -122.448519929767 | (37.7103944963771, -122.448519929767) | 9 | 7 | 6 | 28861 | 25 | ||
72124 | 251752 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
91191 | 180655 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | |||
185565 | 251753 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
84745 | 180012 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2168 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996377.63541 | 2087048.98271 | 37.7104316590536 | -122.454315891261 | (37.7104316590536, -122.454315891261) | 9 | 7 | 6 | 28861 | 25 | |||
118230 | 15909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5672 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5998073.09723 | 2087015.06883 | 37.7104356241859 | -122.448453600256 | (37.7104356241859, -122.448453600256) | 9 | 7 | 6 | 28861 | 25 | ||
28675 | 159331 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 562 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:06:00 AM | 3 | Width 0ft | 5997894.14042 | 2087019.0117 | 37.7104362168201 | -122.449072394069 | (37.7104362168201, -122.449072394069) | 9 | 7 | 6 | 28861 | 25 | ||
190288 | 179987 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 765 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998296.14725 | 2087014.5042 | 37.7104468243386 | -122.447682654627 | (37.7104468243386, -122.447682654627) | 9 | 7 | 6 | 28861 | 5 | |||
98449 | 39206 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3073X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996317.12895 | 2087059.63516 | 37.7104574381327 | -122.454525782264 | (37.7104574381327, -122.454525782264) | 9 | 7 | 6 | 28861 | 25 | |
162111 | 39208 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3073X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996328.55685 | 2087062.43397 | 37.7104657784446 | -122.45448648728 | (37.7104657784446, -122.45448648728) | 9 | 7 | 6 | 28861 | 25 | |
178591 | 179988 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 765 Morse St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 5ft | 5998318.04377 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | 9 | 7 | 6 | 28861 | 5 | |||
176987 | 39207 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3073X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996341.69967 | 2087067.68226 | 37.7104809428024 | -122.454441442017 | (37.7104809428024, -122.454441442017) | 9 | 7 | 6 | 28861 | 25 | |
4928 | 251750 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144 | 2086928 | 37.71048518025 | -122.430921281744 | (37.71048518025, -122.430921281744) | 9 | 7 | 6 | 28861 | 5 | ||
70374 | 251751 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:38:00 AM | 3 | 3x3 | 6003144 | 2086928 | 37.71048518025 | -122.430921281744 | (37.71048518025, -122.430921281744) | 9 | 7 | 6 | 28861 | 5 | ||
116043 | 180211 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 39 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008309.72741 | 2086823.54448 | 37.7104897103039 | -122.413059976251 | (37.7104897103039, -122.413059976251) | 9 | 7 | 8 | 309 | 39 | |||
192992 | 39203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3073X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996355.3852 | 2087072.36701 | 37.7104945909167 | -122.454394480343 | (37.7104945909167, -122.454394480343) | 9 | 7 | 6 | 28861 | 25 | |
144891 | 179989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 765 Morse St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5998350.14588 | 2087034.76993 | 37.7105055554714 | -122.447497482426 | (37.7105055554714, -122.447497482426) | 9 | 7 | 6 | 28861 | 5 | |||
42205 | 15902 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5600 Mission St | 2 | Median : Cutout | Tree | DPW 1 | 03/23/1995 12:00:00 AM | 6 | TR20 | 5998238.99709 | 2087038.74537 | 37.7105101186185 | -122.447881921009 | (37.7105101186185, -122.447881921009) | 9 | 7 | 6 | 28861 | 5 | ||
120010 | 180013 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2168 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996393.76853 | 2087077.91648 | 37.7105120296854 | -122.454262220628 | (37.7105120296854, -122.454262220628) | 9 | 7 | 6 | 28861 | 25 | |||
96444 | 84118 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 543 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50708 | 6010641.36534 | 2086802.21262 | 37.7105617531952 | -122.404999791608 | (37.7105617531952, -122.404999791608) | 9 | 7 | 8 | 309 | 39 | |
89796 | 15904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5600 Mission St | 4 | Median : Cutout | Tree | DPW 1 | 03/10/1995 12:00:00 AM | 6 | TR20 | 5998273.75241 | 2087065.59399 | 37.7105858253457 | -122.44776373121 | (37.7105858253457, -122.44776373121) | 9 | 7 | 6 | 28861 | 5 | ||
155885 | 52009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 359 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2006 12:00:00 AM | 6 | Permit Number 48990 | 6012536.41751 | 2086772.91034 | 37.7105870475244 | -122.398447979611 | (37.7105870475244, -122.398447979611) | 10 | 3 | 8 | 309 | 1 | ||
89242 | 15905 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5600 Mission St | 5 | Median : Cutout | Tree | DPW 1 | 07/13/1994 12:00:00 AM | 12 | TR20 | 5998282.51878 | 2087066.12192 | 37.7105877759628 | -122.44773347082 | (37.7105877759628, -122.44773347082) | 9 | 7 | 6 | 28861 | 5 | ||
36782 | 15906 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5600 Mission St | 6 | Median : Cutout | Tree | DPW 1 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998281.91295 | 2087072.66875 | 37.7106057174457 | -122.447736035688 | (37.7106057174457, -122.447736035688) | 9 | 7 | 6 | 28861 | 5 | ||
150433 | 15907 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5600 Mission St | 7 | Median : Cutout | Tree | DPW 1 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998292.86326 | 2087073.32384 | 37.7106081420281 | -122.447698236291 | (37.7106081420281, -122.447698236291) | 9 | 7 | 6 | 28861 | 5 | ||
14307 | 175031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/30/2019 12:00:00 AM | 3 | Width 3ft | 6010533.91342 | 2086822.61219 | 37.7106117590847 | -122.405372606475 | (37.7106117590847, -122.405372606475) | 9 | 7 | 8 | 309 | 39 | |
38871 | 15908 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5600 Mission St | 8 | Median : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 3 | TR20 | 5998294.21047 | 2087081.24298 | 37.7106299631863 | -122.447694149767 | (37.7106299631863, -122.447694149767) | 9 | 7 | 6 | 28861 | 5 | ||
78563 | 253155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 546 Ellington Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941 | 2087090 | 37.7106338144896 | -122.44891554829 | (37.7106338144896, -122.44891554829) | 9 | 7 | 6 | 28861 | 25 | |||
12385 | 122862 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:57:00 PM | 3 | 3x3 | 5996396.11182 | 2087134.53614 | 37.7106676285689 | -122.454258208753 | (37.7106676285689, -122.454258208753) | 9 | 7 | 6 | 28861 | 25 | ||
117599 | 84082 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 530-532 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50707 | 6010649.96914 | 2086842.45751 | 37.7106727385194 | -122.404972886602 | (37.7106727385194, -122.404972886602) | 9 | 7 | 8 | 309 | 39 | |
46434 | 180206 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 530 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010632.30731 | 2086848.90777 | 37.7106894623249 | -122.405034384026 | (37.7106894623249, -122.405034384026) | 9 | 7 | 8 | 309 | 39 | |||
139331 | 94594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2446 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6010864.44098 | 2086844.85353 | 37.710691304128 | -122.404231788559 | (37.710691304128, -122.404231788559) | 9 | 7 | 8 | 309 | 39 | |||
35891 | 180620 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002386.35916 | 2087019.94096 | 37.7106946720927 | -122.433546414645 | (37.7106946720927, -122.433546414645) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
70770 | 1194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3051 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 6 | 3X3 | 5996527.0746 | 2087144.89036 | 37.7107035681781 | -122.453806321904 | (37.7107035681781, -122.453806321904) | 9 | 7 | 6 | 28861 | 25 |
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) );