trees
7,322 rows where qSpecies_id = 1 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50607 | 180172 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5775 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5997650.14628 | 2086739.63291 | 37.7096551484353 | -122.449895564236 | (37.7096551484353, -122.449895564236) | 9 | 7 | 6 | 28861 | 5 | |||
136989 | 15932 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5771 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997674.88478 | 2086749.48372 | 37.709683611969 | -122.44981077346 | (37.709683611969, -122.44981077346) | 9 | 7 | 6 | 28861 | 5 | ||
95707 | 180179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5750 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5997506.02305 | 2086750.31915 | 37.7096762429258 | -122.450394446945 | (37.7096762429258, -122.450394446945) | 9 | 7 | 6 | 28861 | 25 | |||
70140 | 180220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Wilson St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5994253.3591 | 2086751.7904 | 37.7094935879269 | -122.461636254036 | (37.7094935879269, -122.461636254036) | 9 | 8 | 6 | 28861 | 25 | |||
93974 | 180009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997247.3865 | 2086752.55268 | 37.7096675698642 | -122.451288497174 | (37.7096675698642, -122.451288497174) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
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 | ||
10319 | 180008 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997232.2014 | 2086767.6701 | 37.7097082093476 | -122.451342068885 | (37.7097082093476, -122.451342068885) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
168252 | 15931 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5767 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1995 12:00:00 AM | 6 | 3x3 | 5997735.60664 | 2086774.39401 | 37.7097554839914 | -122.449602702713 | (37.7097554839914, -122.449602702713) | 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 | |||
121029 | 68739 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1993 12:00:00 AM | 8 | Permit Number 32659 | 5997216.23373 | 2086785.97531 | 37.7097575569365 | -122.451398575111 | (37.7097575569365, -122.451398575111) | 9 | 7 | 6 | 28861 | 25 | ||
39685 | 32268 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 6 | Permit Number 36854 | 5997257.50064 | 2086789.55506 | 37.7097697490512 | -122.451256207916 | (37.7097697490512, -122.451256207916) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||||
90301 | 15925 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 5997636.25268 | 2086801.42761 | 37.709824027618 | -122.449948033398 | (37.709824027618, -122.449948033398) | 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 | |
98503 | 15924 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5732 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1995 12:00:00 AM | 6 | 3X3 | 5997611.35068 | 2086807.77126 | 37.7098400209233 | -122.450034555797 | (37.7098400209233, -122.450034555797) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
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 | |
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 | |||
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 | |
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 | |||
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 | |
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 | |
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 | |||
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 | |||
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 | |||
49099 | 94593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2442 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6010872.81854 | 2086861.10948 | 37.7107364078213 | -122.404203977038 | (37.7107364078213, -122.404203977038) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
3843 | 25432 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2436 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1998 12:00:00 AM | 3 | 3X3 | 6010891.05193 | 2086887.18096 | 37.7108090136865 | -122.404142791654 | (37.7108090136865, -122.404142791654) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | |
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 | ||
119883 | 180210 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008343.95421 | 2086916.8221 | 37.7107477527694 | -122.412948271445 | (37.7107477527694, -122.412948271445) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
136680 | 31208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 112 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34900 | 6011808.20404217 | 2086921.6592176 | 37.7109548878303 | -122.400975304916 | (37.7109548878303, -122.400975304916) | 10 | 3 | 8 | 309 | 1 | |||
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 | ||
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 | |||
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 | |||
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 | |
173015 | 180203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010383.47623 | 2086944.2281 | 37.7109372794928 | -122.405901114647 | (37.7109372794928, -122.405901114647) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
118873 | 180204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010365.23615 | 2086949.58295 | 37.7109509626975 | -122.405964533959 | (37.7109509626975, -122.405964533959) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
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 | ||
37506 | 180205 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010334.9036 | 2086961.82833 | 37.7109828895218 | -122.406070233066 | (37.7109828895218, -122.406070233066) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | |
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 | |||
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 | ||
122753 | 180000 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1207 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008297.27699 | 2087017.51562 | 37.7110216161269 | -122.413116714483 | (37.7110216161269, -122.413116714483) | 9 | 7 | 8 | 309 | 39 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
147697 | 95031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010911.6433 | 2087052.7919 | 37.7112648985932 | -122.404083270279 | (37.7112648985932, -122.404083270279) | 9 | 7 | 8 | 309 | 39 | ||||
66865 | 179997 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1237 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008181.66174 | 2087059.58677 | 37.7111306436338 | -122.413519283384 | (37.7111306436338, -122.413519283384) | 9 | 7 | 8 | 309 | 39 | |||
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 | |
66456 | 95030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010891.1447 | 2087063.4869 | 37.7112931195577 | -122.404154871184 | (37.7112931195577, -122.404154871184) | 9 | 7 | 8 | 309 | 39 | ||||
65145 | 26782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6010979.6007 | 2087065.0465 | 37.711302344066 | -122.403849252944 | (37.711302344066, -122.403849252944) | 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 |
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) );