trees
7,322 rows where qSpecies_id = 1 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194517 | 265144 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2166 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782839 | 5997501.55835 | 2109896.92898 | 37.773230951126 | -122.452078795234 | (37.773230951126, -122.452078795234) | 15 | 5 | 11 | 29492 | 16 | ||
| 194501 | 265145 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2021 12:00:00 AM | 3 | 3x3 | Permit Number 782838 | 5997529.09133 | 2109900.74605 | 37.7732430089022 | -122.451983830898 | (37.7732430089022, -122.451983830898) | 15 | 5 | 11 | 29492 | 16 | |
| 194480 | 265130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 119X 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2021 12:00:00 AM | 3 | 3x3 | 6009560.38235 | 2111747.77793 | 37.7789963145717 | -122.410496258221 | (37.7789963145717, -122.410496258221) | 14 | 2 | 9 | 28853 | 34 | ||
| 194469 | 28912 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 119X 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2021 12:00:00 AM | 3 | 3x3 | 6009560.38235 | 2111747.77793 | 37.7789963145717 | -122.410496258221 | (37.7789963145717, -122.410496258221) | 14 | 2 | 9 | 28853 | 34 | ||
| 194448 | 265090 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 784731 | 5994883.78198 | 2089306.03852 | 37.7165432206381 | -122.459642300713 | (37.7165432206381, -122.459642300713) | 9 | 8 | 6 | 28861 | 24 | |
| 194436 | 15776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4804 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2017 12:00:00 AM | 3 | 3X3 | Permit Number 773279 | 6001272.7685 | 2090814.9657 | 37.7210517172508 | -122.437666839136 | (37.7210517172508, -122.437666839136) | 9 | 7 | 6 | 28861 | 25 | |
| 194432 | 15774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4800 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773279 | 6001280.0938 | 2090832.0581 | 37.7210990656339 | -122.437642741249 | (37.7210990656339, -122.437642741249) | 9 | 7 | 6 | 28861 | 25 | |
| 194427 | 15775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4808 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2017 12:00:00 AM | 3 | 3X3 | Permit Number 773279 | 6001261.3736 | 2090797.0594 | 37.7210019026793 | -122.437704946106 | (37.7210019026793, -122.437704946106) | 9 | 7 | 6 | 28861 | 25 | |
| 194408 | 254760 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 170 Arch St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781604 | 5992729.03192 | 2088323.37985 | 37.7137209347968 | -122.467018722529 | (37.7137209347968, -122.467018722529) | 9 | 8 | 6 | 64 | 24 |
| 194391 | 109904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | 8 | 2 | 9 | 28853 | 19 | |
| 194361 | 265029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
| 194360 | 265028 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||||
| 194348 | 265030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
| 194347 | 159854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 6001434.62769 | 2091757.97581 | 37.7236502119613 | -122.437174824773 | (37.7236502119613, -122.437174824773) | 9 | 7 | 6 | 28861 | 25 | ||
| 194340 | 265026 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/07/2001 12:00:00 AM | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||
| 194277 | 180017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 785142 | 6000882.12551 | 2090726.03967 | 37.7207853271706 | -122.439010804221 | (37.7207853271706, -122.439010804221) | 9 | 7 | 6 | 28861 | 25 | ||
| 194254 | 84377 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2067 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51008 | 5999701.79957406 | 2111545.8416405 | 37.7778842319528 | -122.444586427675 | (37.7778842319528, -122.444586427675) | 15 | 5 | 11 | 29490 | 16 | ||
| 194184 | 449 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700x 23rd Ave | 9 | Median : Cutout | Tree | DPW 1 | 12 | 8-HOA | 5988819.75093 | 2110337.06115 | 37.7739383014913 | -122.482142223603 | (37.7739383014913, -122.482142223603) | 11 | 6 | 2 | 55 | 26 | |||
| 194158 | 22602 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 871 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005851.84947 | 2112745.07106 | 37.7815260346282 | -122.423396497843 | (37.7815260346282, -122.423396497843) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 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 | |
| 194086 | 218516 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5992481.316 | 2089926.07662 | 37.7181072513199 | -122.467991417592 | (37.7181072513199, -122.467991417592) | 9 | 8 | 6 | 64 | 24 | |||
| 194074 | 95493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.17376 | 2111397.5149 | 37.7766863664514 | -122.491928594282 | (37.7766863664514, -122.491928594282) | 11 | 6 | 2 | 55 | 26 | |||
| 194067 | 198048 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6015066.15454 | 2101809.56795 | 37.7520152799043 | -122.390754712983 | (37.7520152799043, -122.390754712983) | 10 | 3 | 8 | 28856 | 1 | |||
| 194052 | 124008 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 329 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994001.22934 | 2113117.41042 | 37.781872404554 | -122.464420677404 | (37.781872404554, -122.464420677404) | 11 | 6 | 2 | 54 | 11 | |||
| 194020 | 218689 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 135 Montecito Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996405.53965 | 2094224.63143 | 37.7301359013457 | -122.454737537522 | (37.7301359013457, -122.454737537522) | 9 | 7 | 4 | 28861 | 40 | |||
| 194012 | 54087 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2250 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 4 | Permit Number 769106 | 6003261.93256 | 2116473.57284 | 37.7916170422495 | -122.432622771349 | (37.7916170422495, -122.432622771349) | 13 | 9 | 1 | 29490 | 27 | ||
| 194006 | 123922 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993058.96098 | 2113381.71582 | 37.7825437545731 | -122.467699688993 | (37.7825437545731, -122.467699688993) | 11 | 6 | 2 | 54 | 11 | |||
| 193934 | 242201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 82 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003784.71087 | 2107855.01803 | 37.7679822662065 | -122.430198834925 | (37.7679822662065, -122.430198834925) | 7 | 9 | 5 | 28862 | 3 | |||
| 193912 | 242194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 79 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001479.77201 | 2107749.54951 | 37.767561855632 | -122.438163791221 | (37.767561855632, -122.438163791221) | 15 | 5 | 5 | 29492 | 3 | |||
| 193876 | 198178 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 227 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010101.83609 | 2111180.6086 | 37.7774693403746 | -122.408583123215 | (37.7774693403746, -122.408583123215) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 193850 | 137636 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2241 Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999442.8885 | 2111853.7624 | 37.7787149259907 | -122.445504235827 | (37.7787149259907, -122.445504235827) | 15 | 5 | 11 | 54 | 16 | |||
| 193815 | 36311 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Colon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39290 | 5996171.57528841 | 2093770.15553217 | 37.7288745967493 | -122.455513542245 | (37.7288745967493, -122.455513542245) | 9 | 7 | 4 | 28861 | 40 | ||
| 193812 | 28764 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595X Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6005946.1425241 | 2099684.9167719 | 37.745671254309 | -122.422142167151 | (37.745671254309, -122.422142167151) | 2 | 7 | 5 | 28859 | 22 | |||
| 193797 | 216874 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 638 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 03:16:00 PM | 3 | Width 3ft | 5995925.14157 | 2089161.44268 | 37.7162060215686 | -122.456032419169 | (37.7162060215686, -122.456032419169) | 9 | 8 | 6 | 28861 | 24 | ||
| 193794 | 25541 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 6 | 3X3 | 5994538.8814 | 2092329.655 | 37.724825508048 | -122.461053471015 | (37.724825508048, -122.461053471015) | 9 | 8 | 4 | 28861 | 24 | ||
| 193785 | 94733 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 73 Wood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53864 | 5998395.9807 | 2113346.8794 | 37.7827548145961 | -122.449233480921 | (37.7827548145961, -122.449233480921) | 15 | 6 | 1 | 54 | 31 |
| 193733 | 86508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1304 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987730.517605 | 2106398.207322 | 37.7630598861076 | -122.485620887193 | (37.7630598861076, -122.485620887193) | 1 | 8 | 3 | 56 | 35 | ||
| 193703 | 214975 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997001.95686 | 2099159.08314 | 37.7437189044963 | -122.453031713353 | (37.7437189044963, -122.453031713353) | 9 | 7 | 4 | 59 | 40 | |||
| 193690 | 214928 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993702.40558 | 2095884.16694 | 37.734537154666 | -122.464202977601 | (37.734537154666, -122.464202977601) | 9 | 8 | 4 | 59 | 40 | |||
| 193665 | 241441 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1430 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001975.33515 | 2099857.60697 | 37.7459206544133 | -122.435884960425 | (37.7459206544133, -122.435884960425) | 2 | 7 | 5 | 63 | 22 | |||
| 193644 | 182189 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1597 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987107.5308 | 2104409.623 | 37.7575634605839 | -122.487629461955 | (37.7575634605839, -122.487629461955) | 1 | 8 | 3 | 56 | 35 | |||
| 193617 | 44349 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 638 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | 3 | Permit Number 45447 | 6009284.18161 | 2111400.90578 | 37.7780283976166 | -122.411427239096 | (37.7780283976166, -122.411427239096) | 8 | 2 | 9 | 28853 | 34 | |
| 193583 | 86511 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1260 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/2012 12:00:00 AM | 3 | 3x3 | 5987724.7376 | 2106723.0542 | 37.7639514896809 | -122.485664720175 | (37.7639514896809, -122.485664720175) | 1 | 8 | 3 | 56 | 35 | ||
| 193574 | 185179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985165.2317 | 2097818.1461 | 37.7393515872788 | -122.493860877527 | (37.7393515872788, -122.493860877527) | 1 | 8 | 3 | 29491 | 35 | |||
| 193565 | 95523 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2944 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 23x3 | Permit Number 767315 | 5985332.6897 | 2105713.6699 | 37.7610403347331 | -122.493863589694 | (37.7610403347331, -122.493863589694) | 1 | 8 | 3 | 56 | 35 |
| 193563 | 136786 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3099 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005074.92093 | 2120531.12006 | 37.8028606812269 | -122.426638909965 | (37.8028606812269, -122.426638909965) | 13 | 9 | 1 | 57 | 17 | |||
| 193540 | 139577 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 120 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000700.1255 | 2112662.2521 | 37.7810065259362 | -122.441212998664 | (37.7810065259362, -122.441212998664) | 15 | 5 | 1 | 29490 | 41 | |||
| 193534 | 218586 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3666 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990534.77048 | 2091965.72176 | 37.7235950079882 | -122.474868513494 | (37.7235950079882, -122.474868513494) | 9 | 8 | 4 | 64 | 40 | |||
| 193532 | 87966 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 752 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50999 | 6000534.5187 | 2111610.8987 | 37.7781103430965 | -122.441710438554 | (37.7781103430965, -122.441710438554) | 15 | 5 | 11 | 29490 | 41 | |
| 193524 | 255735 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301x Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6004745 | 2093607 | 37.7289148453459 | -122.425862986743 | (37.7289148453459, -122.425862986743) | 9 | 7 | 6 | 28861 | 5 | ||||
| 193454 | 12516 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2008 12:00:00 AM | 3 | 3X3 | 5995350.29499 | 2114889.31351 | 37.7868152466953 | -122.459881960986 | (37.7868152466953, -122.459881960986) | 11 | 6 | 1 | 54 | 11 | ||
| 193420 | 61653 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101X 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/2015 12:00:00 AM | 1 | Permit Number 773687 | 5993009.87039 | 2114787.90553 | 37.7864019320171 | -122.467971834489 | (37.7864019320171, -122.467971834489) | 11 | 6 | 2 | 54 | 11 | |
| 193385 | 112978 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6004821.44439287 | 2097233.75118826 | 37.7388774114731 | -122.425856763586 | (37.7388774114731, -122.425856763586) | 2 | 7 | 5 | 63 | 7 | |||
| 193381 | 4183 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3831 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004970.19243 | 2100452.25336 | 37.7477230891585 | -122.42557146145 | (37.7477230891585, -122.42557146145) | 2 | 4 | 5 | 63 | 22 | |||
| 193329 | 26307 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/06/1998 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 193289 | 180219 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 Wilson St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5994266.23368 | 2086739.00195 | 37.7094592149324 | -122.461590831079 | (37.7094592149324, -122.461590831079) | 9 | 8 | 6 | 28861 | 25 | |||
| 193259 | 151101 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 522 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779866 | 6004281.12717 | 2110156.88846 | 37.7743307469112 | -122.428645891904 | (37.7743307469112, -122.428645891904) | 7 | 9 | 11 | 28852 | 10 | |
| 193220 | 81903 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1328 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52696 | 5985568.5282 | 2106151.3811 | 37.7622559633751 | -122.49308018325 | (37.7622559633751, -122.49308018325) | 1 | 8 | 3 | 56 | 35 | |
| 193190 | 214893 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 939 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991602.79977 | 2105869.68313 | 37.7618335591051 | -122.472189579705 | (37.7618335591051, -122.472189579705) | 1 | 8 | 4 | 56 | 12 | |||
| 193188 | 242175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 712 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004276.76773 | 2104697.85863 | 37.7593413200685 | -122.428271826105 | (37.7593413200685, -122.428271826105) | 2 | 4 | 5 | 28862 | 3 | |||
| 193153 | 8987 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2000 12:00:00 AM | 3 | 6x6 | 5991034.7169 | 2112750.4859 | 37.7806934847588 | -122.474656542364 | (37.7806934847588, -122.474656542364) | 11 | 6 | 2 | 54 | 26 | ||
| 193126 | 22516 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6510 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/1995 12:00:00 AM | 6 | 3X3 | 6012990.86365 | 2089993.14986 | 37.7194544923955 | -122.397102953678 | (37.7194544923955, -122.397102953678) | 10 | 3 | 8 | 58 | 1 | ||
| 193113 | 244094 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1868 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997641.8911 | 2108879.3829 | 37.7704450690439 | -122.451519959006 | (37.7704450690439, -122.451519959006) | 15 | 5 | 11 | 29492 | 9 | |||
| 193064 | 180043 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900x Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 6000932.74205 | 2090913.38517 | 37.7213026154097 | -122.438849257207 | (37.7213026154097, -122.438849257207) | 9 | 7 | 6 | 28861 | 25 | |||
| 193052 | 29080 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2230 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009630 | 2104353 | 37.7586958643533 | -122.409733320805 | (37.7586958643533, -122.409733320805) | 2 | 4 | 7 | 28859 | 19 | ||
| 193036 | 29952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 139 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 2 | 3x3 | 5995468.7175 | 2088041.2261 | 37.7131039615411 | -122.457529027577 | (37.7131039615411, -122.457529027577) | 9 | 8 | 6 | 28861 | 24 | ||
| 192998 | 28599 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1537 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | 3x3 | 5995160.1026 | 2092148.732 | 37.7243644656186 | -122.45889290423 | (37.7243644656186, -122.45889290423) | 9 | 8 | 4 | 28861 | 24 | ||
| 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 | |
| 192878 | 183214 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2227 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982941.6342 | 2099948.9314 | 37.7450717907388 | -122.501706569109 | (37.7450717907388, -122.501706569109) | 1 | 8 | 3 | 29491 | 35 | |||
| 192865 | 218634 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 345 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991785.91693 | 2099751.95011 | 37.7450464558226 | -122.471110542532 | (37.7450464558226, -122.471110542532) | 1 | 8 | 4 | 29491 | 40 | |||
| 192851 | 30669 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006474.54027 | 2109116.5589 | 37.7715981406638 | -122.4209845773 | (37.7715981406638, -122.4209845773) | 8 | 2 | 9 | 28853 | 19 | |
| 192778 | 141834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1131 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 09:37:00 AM | 30 | Width 0ft | 6004558.497 | 2112571.6053 | 37.7809766592124 | -122.427858513843 | (37.7809766592124, -122.427858513843) | 7 | 9 | 11 | 29490 | 41 | ||
| 192761 | 200590 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Las Villas Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016331.7828 | 2095126.3499 | 37.7337346684331 | -122.385912136614 | (37.7337346684331, -122.385912136614) | 10 | 3 | 8 | 58 | 1 | |||
| 192757 | 39427 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
| 192592 | 242859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006473.64318 | 2109116.62874 | 37.7715982818596 | -122.420987685352 | (37.7715982818596, -122.420987685352) | 8 | 2 | 9 | 28853 | 19 | |||
| 192582 | 198113 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 453 Mississippi St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014103.66815 | 2105000.08777 | 37.7607223118011 | -122.394306519737 | (37.7607223118011, -122.394306519737) | 10 | 3 | 8 | 28856 | 29 | |||
| 192456 | 218432 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 451 Hearst Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5998417.78463 | 2094357.34884 | 37.730615528667 | -122.447790528326 | (37.730615528667, -122.447790528326) | 9 | 7 | 4 | 28861 | 40 | |||
| 192431 | 187409 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Leland Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6010493.4269 | 2087269.1415 | 37.711835574702 | -122.405543966202 | (37.711835574702, -122.405543966202) | 9 | 7 | 8 | 309 | 39 | |||
| 192424 | 106899 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 63 BROSNAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x3 | 6005693 | 2108028.3 | 37.7685659568303 | -122.423610587475 | (37.7685659568303, -122.423610587475) | 8 | 4 | 5 | 28853 | 19 | |||
| 192343 | 22416 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5800 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6013664.2375 | 2091773.8949 | 37.7243815248562 | -122.39489998248 | (37.7243815248562, -122.39489998248) | 10 | 3 | 8 | 58 | 1 | ||||
| 192342 | 271 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
| 192268 | 121197 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2112 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990734 | 2100991 | 37.7483876657955 | -122.474838269225 | (37.7483876657955, -122.474838269225) | 1 | 8 | 4 | 29491 | 40 | |||
| 192261 | 24356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 137 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/2014 12:00:00 AM | 3 | 3x3 | 6005804.45675 | 2108449.51119 | 37.7697287927735 | -122.423255012913 | (37.7697287927735, -122.423255012913) | 8 | 4 | 5 | 28853 | 19 | ||
| 192193 | 218643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 142 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992858.6274 | 2098156.9621 | 37.7407290103493 | -122.467285379624 | (37.7407290103493, -122.467285379624) | 1 | 8 | 4 | 59 | 40 | |||
| 192166 | 232740 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1235 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781253 | 6003890.57466 | 2101130.85384 | 37.7495253062673 | -122.429353105273 | (37.7495253062673, -122.429353105273) | 2 | 4 | 5 | 28862 | 22 | |
| 192133 | 112301 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
| 192128 | 52935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 37 Rudden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 1 | 3x3 | Permit Number 48921 | 6000220.73441 | 2091976.70851 | 37.724181723896 | -122.441386719518 | (37.724181723896, -122.441386719518) | 9 | 7 | 6 | 28861 | 25 |
| 192075 | 248313 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1395 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999059.4582 | 2108336.6511 | 37.7690359400967 | -122.446577553957 | (37.7690359400967, -122.446577553957) | 15 | 5 | 11 | 29492 | 9 | |||
| 192065 | 241729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Guerrero St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6005472.26588 | 2108171.65943 | 37.7689471254258 | -122.42438428712 | (37.7689471254258, -122.42438428712) | 8 | 4 | 5 | 28853 | 19 | |||
| 192033 | 180063 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900x Alemany Blvd | 31 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 6000614.24594 | 2090358.94788 | 37.7197621306905 | -122.439910472497 | (37.7197621306905, -122.439910472497) | 9 | 7 | 6 | 28861 | 25 | |||
| 192029 | 87241 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2136 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50270 | 6000400.91897 | 2116010.42823 | 37.7901827036114 | -122.442488554502 | (37.7901827036114, -122.442488554502) | 13 | 6 | 1 | 29490 | 27 | |
| 192012 | 218564 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990836.12868 | 2094496.30946 | 37.7305608273977 | -122.474011326464 | (37.7305608273977, -122.474011326464) | 9 | 8 | 4 | 64 | 40 | |||
| 191930 | 180380 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4208 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6003442.64582 | 2093953.48682 | 37.729792534794 | -122.430390028073 | (37.729792534794, -122.430390028073) | 9 | 7 | 6 | 28861 | 25 | |||
| 191831 | 52604 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 900 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2006 12:00:00 AM | 2 | Permit Number 48695 | 6016071.1186 | 2089161.0324 | 37.7173406522544 | -122.386397562018 | (37.7173406522544, -122.386397562018) | 10 | 3 | 8 | 58 | 1 | ||
| 191811 | 14488 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 303 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5998978.3148 | 2111745.3393 | 37.778390691402 | -122.447103565775 | (37.778390691402, -122.447103565775) | 15 | 5 | 2 | 54 | 16 | |||
| 191805 | 9146 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5927 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1998 12:00:00 AM | 3 | 3X3 | 5988577.5543 | 2112559.2016 | 37.7800255883091 | -122.483142922921 | (37.7800255883091, -122.483142922921) | 11 | 6 | 2 | 55 | 26 | ||
| 191722 | 88705 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51653 | 6004475.4 | 2108255.2 | 37.769120165328 | -122.427838335035 | (37.769120165328, -122.427838335035) | 7 | 9 | 5 | 28862 | 3 | ||
| 191696 | 43840 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2720 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 2 | Permit Number 43462 | 5985577.0454 | 2096833.9127 | 37.7366732306066 | -122.492364569956 | (37.7366732306066, -122.492364569956) | 1 | 8 | 3 | 29491 | 35 |
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) );