trees
7,322 rows where qSpecies_id = 1 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 764 | 163220 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 0ft | 5996567.29942 | 2088361.68289 | 37.714046904924 | -122.453755106407 | (37.714046904924, -122.453755106407) | 9 | 8 | 6 | 28861 | 24 | ||
| 5940 | 84389 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012558.72681 | 2099037.97239 | 37.7442656365553 | -122.399231281913 | (37.7442656365553, -122.399231281913) | 10 | 3 | 8 | 58 | 1 | |||
| 6371 | 179976 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998720.79345 | 2086710.36043 | 37.7096359749025 | -122.446193129116 | (37.7096359749025, -122.446193129116) | 9 | 7 | 6 | 28861 | 5 | ||||
| 7051 | 241512 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000983.23947 | 2099435.66569 | 37.7447056964121 | -122.439285244933 | (37.7447056964121, -122.439285244933) | 2 | 7 | 5 | 63 | 22 | |||
| 7177 | 74026 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015970.5058 | 2106958.46215 | 37.7662031805546 | -122.387986569137 | (37.7662031805546, -122.387986569137) | 14 | 3 | 9 | 310 | 20 | ||
| 8892 | 241941 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 759X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005773.46627 | 2098893.95843 | 37.7434897212753 | -122.422683058491 | (37.7434897212753, -122.422683058491) | 2 | 7 | 7 | 28859 | 2 | |||
| 10518 | 121773 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6016274.96779 | 2101507.19442 | 37.75125201898 | -122.386553339378 | (37.75125201898, -122.386553339378) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 12582 | 32159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 19722 | 28629 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | 3X3 | 5996025.31382 | 2091881.53932 | 37.7236805140054 | -122.455882701682 | (37.7236805140054, -122.455882701682) | 9 | 8 | 4 | 28861 | 24 | ||
| 24611 | 217610 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | Width 0ft | 5996168.7329 | 2091856.7846 | 37.7236207736962 | -122.455385141266 | (37.7236207736962, -122.455385141266) | 9 | 8 | 4 | 28861 | 24 | ||
| 34830 | 198209 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1189 La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017589.5812 | 2094149.71082 | 37.7311225367566 | -122.381495616943 | (37.7311225367566, -122.381495616943) | 10 | 3 | 8 | 58 | 1 | |||
| 34933 | 180259 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003405.48601 | 2094728.18397 | 37.7319175734374 | -122.430573750589 | (37.7319175734374, -122.430573750589) | 9 | 7 | 5 | 28861 | 25 | |||
| 39338 | 180295 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6001915.65954 | 2093123.81591 | 37.7274278322296 | -122.435609650978 | (37.7274278322296, -122.435609650978) | 9 | 7 | 6 | 28861 | 25 | |||
| 47945 | 16888 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 49202 | 26306 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 51863 | 4546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 66 Cleary Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 10:30:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | ||
| 55984 | 198088 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Kansas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011707.73841 | 2102632.7961 | 37.7540887792974 | -122.402426554246 | (37.7540887792974, -122.402426554246) | 10 | 3 | 8 | 28856 | 29 | |||
| 56371 | 112316 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 08/06/2015 09:14:00 AM | 3 | 3x3 | 5998526.38122 | 2088580.63045 | 37.7147602066992 | -122.446999548499 | (37.7147602066992, -122.446999548499) | 9 | 7 | 6 | 28861 | 25 | ||
| 61698 | 183918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2290 24th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988881.7033 | 2100006.3735 | 37.7455766278484 | -122.481171305679 | (37.7455766278484, -122.481171305679) | 1 | 8 | 3 | 29491 | 35 | |||
| 64333 | 180307 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1604x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001671.0226 | 2092590.95164 | 37.7259508099585 | -122.43641723856 | (37.7259508099585, -122.43641723856) | 9 | 7 | 6 | 28861 | 25 | |||
| 65272 | 39411 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 70727 | 137738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000674.4901 | 2112530.5214 | 37.7806433668155 | -122.441292229339 | (37.7806433668155, -122.441292229339) | 15 | 5 | 1 | 29490 | 16 | |||
| 70847 | 198248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Navy Rd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6018004.07949 | 2093668.21342 | 37.7298233149865 | -122.380029163529 | (37.7298233149865, -122.380029163529) | 10 | 3 | 8 | 58 | 1 | |||
| 73782 | 15717 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4357X Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/1995 12:00:00 AM | 6 | 3x3 | 6002851.16985 | 2093165.53011 | 37.7275954613369 | -122.432378570152 | (37.7275954613369, -122.432378570152) | 9 | 7 | 6 | 28861 | 5 | ||
| 75117 | 124094 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Funston Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5991885.08534 | 2111292.19604 | 37.7767386560308 | -122.47160843755 | (37.7767386560308, -122.47160843755) | 11 | 6 | 2 | 54 | 11 | ||||
| 76650 | 182976 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 19th Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5990449.7521 | 2097869.7504 | 37.7398010474315 | -122.475593304226 | (37.7398010474315, -122.475593304226) | 1 | 8 | 3 | 29491 | 35 | |||
| 78101 | 112244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:23:00 AM | 3 | 5999075.35632 | 2088897.5178 | 37.7156616565467 | -122.445124838863 | (37.7156616565467, -122.445124838863) | 9 | 7 | 6 | 28861 | 25 | |||
| 78148 | 136829 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2333 Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6003763.28449 | 2116038.9116 | 37.7904519921279 | -122.430857065799 | (37.7904519921279, -122.430857065799) | 13 | 9 | 1 | 29490 | 27 | |||
| 79237 | 180097 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2200x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5999740.68334 | 2089520.98061 | 37.7174114971307 | -122.442869917415 | (37.7174114971307, -122.442869917415) | 9 | 7 | 6 | 28861 | 25 | |||
| 80766 | 116719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6011931.9643 | 2112416.1862 | 37.7809642773111 | -122.402338963905 | (37.7809642773111, -122.402338963905) | 6 | 2 | 9 | 28856 | 34 | |||
| 80920 | 180135 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 Naples St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002044.33965 | 2088921.8075 | 37.7158973670425 | -122.434864430444 | (37.7158973670425, -122.434864430444) | 9 | 7 | 6 | 28861 | 5 | |||
| 85287 | 36221 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 85294 | 241940 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 765X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005690 | 2098663 | 37.7428508523003 | -122.422955252696 | (37.7428508523003, -122.422955252696) | 2 | 7 | 7 | 28859 | 2 | |||
| 87082 | 180086 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2100x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 6000064.86596 | 2089828.32738 | 37.718273878607 | -122.441771417144 | (37.718273878607, -122.441771417144) | 9 | 7 | 6 | 28861 | 25 | |||
| 93519 | 187474 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4399 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003037.9622 | 2093364.6467 | 37.7281527807753 | -122.431747038132 | (37.7281527807753, -122.431747038132) | 9 | 7 | 6 | 28861 | 5 | |||
| 97123 | 214843 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1301 Funston Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992069.75724 | 2106218.08462 | 37.7628171898818 | -122.470599950643 | (37.7628171898818, -122.470599950643) | 1 | 8 | 11 | 56 | 12 | |||
| 100918 | 25250 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 10 | 3X3 | 5996310.4755 | 2091889.5584 | 37.7237188947882 | -122.454897531597 | (37.7237188947882, -122.454897531597) | 9 | 8 | 4 | 28861 | 40 | ||
| 103053 | 11982 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.7316151284675 | -122.381940767084 | (37.7316151284675, -122.381940767084) | 10 | 3 | 8 | 58 | 1 | ||
| 105950 | 116993 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300x BRODERICK ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
| 107789 | 137954 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1615 SUTTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004801.2336 | 2114685.8103 | 37.7867954695312 | -122.427169405594 | (37.7867954695312, -122.427169405594) | 13 | 9 | 11 | 28858 | 13 | ||||
| 110867 | 241813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 Chattanooga St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004749.1124 | 2102907.11902 | 37.7544510855669 | -122.426510717001 | (37.7544510855669, -122.426510717001) | 2 | 4 | 5 | 28862 | 22 | |||
| 117433 | 180045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 6000902.37915 | 2090855.22342 | 37.7211411889036 | -122.43895004691 | (37.7211411889036, -122.43895004691) | 9 | 7 | 6 | 28861 | 25 | |||
| 119532 | 30555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 3 | Permit Number 34540 | 6011713.20166 | 2086290.18715 | 37.7092156911269 | -122.401259311564 | (37.7092156911269, -122.401259311564) | 10 | 3 | 8 | 309 | 1 | ||
| 126348 | 98053 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
| 128729 | 198236 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1197 La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016883.97507 | 2094695.25955 | 37.7325815231026 | -122.383973018064 | (37.7325815231026, -122.383973018064) | 10 | 3 | 8 | 58 | 1 | |||
| 130000 | 102029 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 130335 | 253866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 66 Cleary Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 10:30:00 AM | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | |||
| 135712 | 180235 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990554.42532 | 2094179.36297 | 37.7296742505655 | -122.474962079861 | (37.7296742505655, -122.474962079861) | 1 | 8 | 4 | 64 | 14 | |||
| 139514 | 32553 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Valencia St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37041 | 6006055.96272335 | 2109107.09574597 | 37.7715485533825 | -122.4224317908 | (37.7715485533825, -122.4224317908) | 8 | 2 | 9 | 28853 | 19 | |||
| 142878 | 116205 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
| 145651 | 241474 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 916 Elizabeth St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000511.19388 | 2102003.65588 | 37.751729907924 | -122.441101685705 | (37.751729907924, -122.441101685705) | 2 | 4 | 5 | 28862 | 22 | |||
| 147130 | 112328 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 08/05/2015 02:14:00 PM | 3 | 3x3 | 5998191.63034 | 2088400.91043 | 37.7142476057053 | -122.448143648024 | (37.7142476057053, -122.448143648024) | 9 | 7 | 6 | 28861 | 25 | ||
| 147760 | 1228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3600X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1998 12:00:00 AM | 12 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 149004 | 180382 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 501 Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009428.5427 | 2093894.45513 | 37.7299677029451 | -122.409691857806 | (37.7299677029451, -122.409691857806) | 9 | 3 | 7 | 309 | 28 | |||
| 149045 | 388 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
| 151593 | 88711 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 9 | 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 | ||
| 156953 | 115192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 5999381.87795 | 2089181.76313 | 37.7164596204897 | -122.444085776535 | (37.7164596204897, -122.444085776535) | 9 | 7 | 6 | 28861 | 25 | ||||
| 160893 | 180272 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1204x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6002975.86968 | 2094159.71089 | 37.730332327675 | -122.432018444894 | (37.730332327675, -122.432018444894) | 9 | 7 | 6 | 28861 | 25 | |||
| 161754 | 140247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.7744803767388 | -122.447755234881 | (37.7744803767388, -122.447755234881) | 15 | 5 | 11 | 29492 | 16 | |||
| 162011 | 180319 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1718x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001374.32809 | 2091874.13996 | 37.7239657445122 | -122.437391583874 | (37.7239657445122, -122.437391583874) | 9 | 7 | 6 | 28861 | 25 | |||
| 173021 | 107926 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | |
| 175669 | 241784 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Day St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004530.62214 | 2098674.504 | 37.7428169510315 | -122.426964877345 | (37.7428169510315, -122.426964877345) | 2 | 7 | 5 | 63 | 22 | |||
| 186787 | 26290 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999866.2929 | 2092502.9246 | 37.7256063938947 | -122.442649732798 | (37.7256063938947, -122.442649732798) | 9 | 7 | 6 | 28861 | 25 | ||
| 188040 | 12027 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/1996 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 2284 | 122861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996437.5077 | 2087153.60444 | 37.7107223595138 | -122.454116512475 | (37.7107223595138, -122.454116512475) | 9 | 7 | 6 | 28861 | 25 | ||
| 4454 | 128029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | Width 4ft | 6007868.73718 | 2121431.95 | 37.8054916838703 | -122.417034709883 | (37.8054916838703, -122.417034709883) | 5 | 1 | 10 | 308 | 23 | ||
| 5551 | 74240 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015971.85212 | 2106927.76687 | 37.7661189725478 | -122.387979770277 | (37.7661189725478, -122.387979770277) | 14 | 3 | 9 | 310 | 20 | ||
| 5743 | 30556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011713.13245 | 2086267.11073 | 37.7091523239944 | -122.40125793023 | (37.7091523239944, -122.40125793023) | 10 | 3 | 8 | 309 | 1 | ||
| 5773 | 180020 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 2ft | 6001294.85354 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | 9 | 7 | 6 | 28861 | 25 | |||
| 15623 | 180096 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2200x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5999764.69095 | 2089543.44622 | 37.7174745512817 | -122.442788546764 | (37.7174745512817, -122.442788546764) | 9 | 7 | 6 | 28861 | 25 | |||
| 15689 | 84390 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012549.35386 | 2099045.14684 | 37.7442848136983 | -122.399264195308 | (37.7442848136983, -122.399264195308) | 10 | 3 | 8 | 58 | 1 | |||
| 19712 | 138355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2499 Bush St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001788.5584 | 2114613.8194 | 37.7864269723095 | -122.437587378273 | (37.7864269723095, -122.437587378273) | 13 | 6 | 1 | 29490 | 27 | |||
| 19907 | 102028 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 27797 | 26289 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900X San Jose Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999881.61737 | 2092526.205 | 37.7256711900688 | -122.442598428299 | (37.7256711900688, -122.442598428299) | 9 | 7 | 6 | 28861 | 25 | ||
| 30518 | 180306 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1604x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001696.41333 | 2092647.43732 | 37.7261073495475 | -122.436333505406 | (37.7261073495475, -122.436333505406) | 9 | 7 | 6 | 28861 | 25 | |||
| 35605 | 116992 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300x BRODERICK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
| 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 | ||
| 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 | ||
| 42354 | 38538 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4517 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1998 12:00:00 AM | Permit Number 40515 | 6015241.886192 | 2096337.56497418 | 37.7370000434098 | -122.389764834673 | (37.7370000434098, -122.389764834673) | 10 | 3 | 8 | 58 | 1 | |||
| 43154 | 136814 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2509 Pierce St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001670.66437 | 2117042.7739 | 37.7930895508067 | -122.438169325648 | (37.7930895508067, -122.438169325648) | 13 | 6 | 1 | 29490 | 27 | |||
| 47078 | 187473 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4399 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003020.4022 | 2093347.0867 | 37.7281035695586 | -122.43180649037 | (37.7281035695586, -122.43180649037) | 9 | 7 | 6 | 28861 | 5 | |||
| 47777 | 138203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 MASONIC AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998926.8799 | 2112606.4971 | 37.780752269091 | -122.447343495542 | (37.780752269091, -122.447343495542) | 15 | 5 | 1 | 54 | 16 | |||
| 48625 | 18290 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/1992 12:00:00 AM | 6 | 4X4 | 6002339.9537 | 2114048.2121 | 37.7849052933918 | -122.435639212231 | (37.7849052933918, -122.435639212231) | 13 | 6 | 11 | 29490 | 13 | ||
| 48896 | 241783 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Day St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004329.75023 | 2098662.66645 | 37.7427730875169 | -122.427658592787 | (37.7427730875169, -122.427658592787) | 2 | 7 | 5 | 63 | 22 | |||
| 50394 | 116204 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
| 51127 | 138198 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Masonic Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998949.2157 | 2112408.8587 | 37.7802108815423 | -122.447251997008 | (37.7802108815423, -122.447251997008) | 15 | 5 | 1 | 54 | 16 | |||
| 52568 | 115191 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | 9 | 7 | 6 | 28861 | 25 | ||||
| 59378 | 112315 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2500X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 08/06/2015 01:16:00 PM | 3 | 3x3 | 5998550.09979 | 2088594.30489 | 37.7147991086711 | -122.446918551062 | (37.7147991086711, -122.446918551062) | 9 | 7 | 6 | 28861 | 25 | ||
| 60214 | 35865 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Vienna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1998 12:00:00 AM | Permit Number 39077 | 6002288.79188076 | 2088794.75109809 | 37.7155623744331 | -122.434010413526 | (37.7155623744331, -122.434010413526) | 9 | 7 | 6 | 28861 | 5 | |||
| 60951 | 36226 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1485 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39263 | 6015221.12155905 | 2092170.90026948 | 37.7255580692538 | -122.389545718534 | (37.7255580692538, -122.389545718534) | 10 | 3 | 8 | 58 | 1 | |||
| 61435 | 88710 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2020 Market St | 8 | 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 | ||
| 63196 | 241901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2618 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008249.22256 | 2102947.66853 | 37.7547596699338 | -122.414409257888 | (37.7547596699338, -122.414409257888) | 2 | 4 | 7 | 28859 | 19 | |||
| 67634 | 12007 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1230X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | 10 | 3 | 8 | 58 | 1 | ||
| 68363 | 16887 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 71664 | 201873 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011917.3111 | 2112403.3647 | 37.7809282544685 | -122.402388755065 | (37.7809282544685, -122.402388755065) | 6 | 2 | 9 | 28856 | 34 | |||
| 79368 | 198247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Navy Rd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6018027.1823 | 2093649.37702 | 37.7297728684077 | -122.379947985316 | (37.7297728684077, -122.379947985316) | 10 | 3 | 8 | 58 | 1 |
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) );