trees
7,322 rows where qSpecies_id = 1 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21667 | 198053 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6015994.50717 | 2105252.59433 | 37.7615205644539 | -122.387784515751 | (37.7615205644539, -122.387784515751) | 10 | 3 | 8 | 28856 | 29 | |||
| 23916 | 198058 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6016003.50284 | 2105138.76714 | 37.7612085176665 | -122.387745460881 | (37.7612085176665, -122.387745460881) | 10 | 3 | 8 | 28856 | 29 | |||
| 49722 | 198059 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6016002.244 | 2105125.97833 | 37.7611733325983 | -122.387748922377 | (37.7611733325983, -122.387748922377) | 10 | 3 | 8 | 28856 | 29 | |||
| 66752 | 198054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015996.1825 | 2105236.6253 | 37.7614768097219 | -122.387777607167 | (37.7614768097219, -122.387777607167) | 10 | 3 | 8 | 28856 | 29 | |||
| 74958 | 198056 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015997.12564 | 2105199.4171 | 37.7613746962157 | -122.387771748977 | (37.7613746962157, -122.387771748977) | 10 | 3 | 8 | 28856 | 29 | |||
| 125124 | 198060 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6016003.71174 | 2105110.97053 | 37.7611322056943 | -122.387742798886 | (37.7611322056943, -122.387742798886) | 10 | 3 | 8 | 28856 | 29 | |||
| 149690 | 198057 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015999.46733 | 2105182.54146 | 37.7613284890375 | -122.387762472475 | (37.7613284890375, -122.387762472475) | 10 | 3 | 8 | 28856 | 29 | |||
| 153163 | 198055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 820 Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015997.74921 | 2105213.0549 | 37.7614121772375 | -122.387770543876 | (37.7614121772375, -122.387770543876) | 10 | 3 | 8 | 28856 | 29 | |||
| 8267 | 119175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | 11 | 6 | 2 | 55 | 26 | |||
| 23159 | 192045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.397865584934 | (37.7746734191738, -122.397865584934) | 14 | 2 | 9 | 28856 | 20 | |
| 32474 | 180256 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003464.1171 | 2094730.21395 | 37.7319264686289 | -122.430371195377 | (37.7319264686289, -122.430371195377) | 9 | 7 | 5 | 28861 | 25 | |||
| 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 | |||
| 41118 | 119176 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.510058979927 | (37.7743417237871, -122.510058979927) | 11 | 6 | 2 | 55 | 26 | |||
| 43064 | 180257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003441.65592 | 2094728.25721 | 37.7319198235266 | -122.430448708839 | (37.7319198235266, -122.430448708839) | 9 | 7 | 5 | 28861 | 25 | |||
| 58188 | 192049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.50597 | 2110186.98089 | 37.7749179610178 | -122.397555323332 | (37.7749179610178, -122.397555323332) | 14 | 2 | 9 | 28856 | 20 | |
| 72175 | 180262 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 76 Rotteck St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003305.93949 | 2094720.0194 | 37.7318895154806 | -122.430917321302 | (37.7318895154806, -122.430917321302) | 9 | 7 | 5 | 28861 | 25 | |||
| 86115 | 180255 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003484.65095 | 2094730.37892 | 37.7319280847153 | -122.4303002173 | (37.7319280847153, -122.4303002173) | 9 | 7 | 5 | 28861 | 25 | |||
| 92448 | 242298 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 297 Addison St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002506.63703 | 2097692.2502 | 37.7400052566372 | -122.433893045753 | (37.7400052566372, -122.433893045753) | 2 | 7 | 5 | 63 | 7 | |||
| 98559 | 180251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003572.96144 | 2094730.3764 | 37.7319330795535 | -122.429994909138 | (37.7319330795535, -122.429994909138) | 9 | 7 | 5 | 28861 | 25 | |||
| 102697 | 192050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.397499389085 | (37.774962173497, -122.397499389085) | 14 | 2 | 9 | 28856 | 20 | |
| 107722 | 180320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 817 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6001210.40568 | 2092189.73212 | 37.7248229683925 | -122.437980831368 | (37.7248229683925, -122.437980831368) | 9 | 7 | 6 | 28861 | 25 | |||
| 113325 | 241422 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6001495.68949 | 2099380.02037 | 37.7445820558098 | -122.437509311417 | (37.7445820558098, -122.437509311417) | 2 | 7 | 5 | 63 | 22 | |||
| 114741 | 180263 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Still St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003281.32559 | 2094718.10689 | 37.7318828694844 | -122.431002280233 | (37.7318828694844, -122.431002280233) | 9 | 7 | 5 | 28861 | 25 | |||
| 131546 | 180261 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 81 Rotteck St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003329.74924 | 2094722.2171 | 37.7318968989209 | -122.430835162816 | (37.7318968989209, -122.430835162816) | 9 | 7 | 5 | 28861 | 25 | |||
| 135240 | 192047 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.39967 | 2110155.04551 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | 14 | 2 | 9 | 28856 | 20 | |
| 137131 | 180001 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Tomaso Ct | 6 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.7090444314296 | -122.410009745679 | (37.7090444314296, -122.410009745679) | 9 | 7 | 8 | 309 | 39 | |||
| 151502 | 180253 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003528.91801 | 2094729.13365 | 37.7319271727957 | -122.430147087941 | (37.7319271727957, -122.430147087941) | 9 | 7 | 5 | 28861 | 25 | |||
| 151529 | 180258 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003421.15336 | 2094728.39885 | 37.7319190510051 | -122.430519600598 | (37.7319190510051, -122.430519600598) | 9 | 7 | 5 | 28861 | 25 | |||
| 157079 | 119174 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 738 La Playa | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 7 | Width 8ft | 5980754.24139 | 2110680.27075 | 37.7744082353086 | -122.510067160899 | (37.7744082353086, -122.510067160899) | 11 | 6 | 2 | 55 | 26 | |||
| 159457 | 180252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003553.26198 | 2094731.05162 | 37.7319338178795 | -122.430063062478 | (37.7319338178795, -122.430063062478) | 9 | 7 | 5 | 28861 | 25 | |||
| 164784 | 180264 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Still St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003250.76202 | 2094715.77972 | 37.7318747477193 | -122.431107778807 | (37.7318747477193, -122.431107778807) | 9 | 7 | 5 | 28861 | 25 | |||
| 167558 | 192048 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.56166 | 37.7748746334969 | -122.397615732604 | (37.7748746334969, -122.397615732604) | 14 | 2 | 9 | 28856 | 20 | |
| 176214 | 180260 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003350.60066 | 2094725.01399 | 37.7319057599362 | -122.430763274623 | (37.7319057599362, -122.430763274623) | 9 | 7 | 5 | 28861 | 25 | |||
| 187133 | 192046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.7747232919731 | -122.39779074965 | (37.7747232919731, -122.39779074965) | 14 | 2 | 9 | 28856 | 20 | |
| 188902 | 180254 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Still St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003505.97344 | 2094729.60695 | 37.7319271728025 | -122.430226445906 | (37.7319271728025, -122.430226445906) | 9 | 7 | 5 | 28861 | 25 | |||
| 60465 | 202209 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1988 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6012983.51399 | 2093557.83656 | 37.7292419905249 | -122.39737821176 | (37.7292419905249, -122.39737821176) | 10 | 3 | 8 | 58 | 1 | |||
| 63854 | 202208 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1978 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6012988.24456 | 2093553.53748 | 37.7292304495144 | -122.397361556292 | (37.7292304495144, -122.397361556292) | 10 | 3 | 8 | 58 | 1 | |||
| 69537 | 198051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015071.52893 | 2101713.75148 | 37.75175248631 | -122.390729432117 | (37.75175248631, -122.390729432117) | 10 | 3 | 8 | 28856 | 1 | |||
| 70856 | 198050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6015069.99067 | 2101754.678 | 37.7518647765405 | -122.39073761146 | (37.7518647765405, -122.39073761146) | 10 | 3 | 8 | 28856 | 1 | |||
| 92412 | 198046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015063.38208 | 2101850.3789 | 37.7521271843206 | -122.390767152403 | (37.7521271843206, -122.390767152403) | 10 | 3 | 8 | 28856 | 1 | |||
| 121011 | 198047 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6015066.24104 | 2101813.84862 | 37.7520270385183 | -122.390754712971 | (37.7520270385183, -122.390754712971) | 10 | 3 | 8 | 28856 | 1 | |||
| 152594 | 198049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015069.63855 | 2101758.53914 | 37.7518753588787 | -122.390739098952 | (37.7518753588787, -122.390739098952) | 10 | 3 | 8 | 28856 | 1 | |||
| 172350 | 198052 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6015072.05685 | 2101707.95994 | 37.7517366132545 | -122.390727201795 | (37.7517366132545, -122.390727201795) | 10 | 3 | 8 | 28856 | 1 | |||
| 178947 | 198045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1410 Indiana St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 7ft | 6015062.9459 | 2101861.12211 | 37.7521566587028 | -122.390769411503 | (37.7521566587028, -122.390769411503) | 10 | 3 | 8 | 28856 | 1 | |||
| 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 | |||
| 2007 | 188784 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015979.83831 | 2106803.95395 | 37.7657794514949 | -122.387943506912 | (37.7657794514949, -122.387943506912) | 14 | 3 | 9 | 310 | 20 | |||
| 9799 | 188783 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015981.68348 | 2106781.73126 | 37.7657185350155 | -122.387935573977 | (37.7657185350155, -122.387935573977) | 14 | 3 | 9 | 310 | 20 | |||
| 10795 | 188785 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015978.05896 | 2106829.43815 | 37.7658493270204 | -122.38795143981 | (37.7658493270204, -122.38795143981) | 14 | 3 | 9 | 310 | 20 | |||
| 13110 | 188782 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015982.12636 | 2106754.96915 | 37.7656450765832 | -122.387932174526 | (37.7656450765832, -122.387932174526) | 14 | 3 | 9 | 310 | 20 | |||
| 17659 | 188786 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015977.25571 | 2106854.57611 | 37.7659183059205 | -122.387955972402 | (37.7659183059205, -122.387955972402) | 14 | 3 | 9 | 310 | 20 | |||
| 36242 | 180400 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002102.27199 | 2086536.91631 | 37.709352269367 | -122.434493768575 | (37.709352269367, -122.434493768575) | 9 | 7 | 6 | 28861 | 5 | |||
| 50643 | 241490 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2115 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 6ft | 6002706.79399 | 2099384.51572 | 37.7446631809535 | -122.433321879096 | (37.7446631809535, -122.433321879096) | 2 | 7 | 5 | 63 | 22 | |||
| 59955 | 120358 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2350 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988092.81378 | 2114686.07827 | 37.7858371684386 | -122.484975921426 | (37.7858371684386, -122.484975921426) | 11 | 6 | 1 | 55 | 33 | |||
| 67665 | 241662 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 176 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6005437.24469 | 2099940.9896 | 37.7463456551373 | -122.423920067868 | (37.7463456551373, -122.423920067868) | 2 | 7 | 5 | 28859 | 22 | |||
| 71374 | 241643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 599 Buchanan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6004545.6184 | 2110424.56888 | 37.7750806969521 | -122.427750043935 | (37.7750806969521, -122.427750043935) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||||
| 82906 | 241663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 176 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6005417.96382 | 2099937.74161 | 37.74633564837 | -122.42398650799 | (37.74633564837, -122.42398650799) | 2 | 7 | 5 | 28859 | 22 | |||
| 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 | |||
| 104818 | 180399 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 349 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002410.48398 | 2086459.29818 | 37.7091566380421 | -122.433422996175 | (37.7091566380421, -122.433422996175) | 9 | 7 | 6 | 28861 | 5 | |||
| 105429 | 118080 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 7230 Geary Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5984526.23316 | 2112508.36467 | 37.77964941454 | -122.497154299102 | (37.77964941454, -122.497154299102) | 11 | 6 | 2 | 55 | 26 | |||
| 172427 | 214904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 556 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 5994175.98636 | 2099523.30765 | 37.744556613096 | -122.462829586019 | (37.744556613096, -122.462829586019) | 1 | 8 | 4 | 29491 | 40 | |||
| 178009 | 214903 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 556 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 5994195.75162 | 2099539.59753 | 37.7446024794116 | -122.462762423749 | (37.7446024794116, -122.462762423749) | 1 | 8 | 4 | 29491 | 40 | |||
| 180190 | 241660 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 82 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6006235.84048 | 2099584.03625 | 37.7454105949184 | -122.421133271198 | (37.7454105949184, -122.421133271198) | 2 | 7 | 5 | 28859 | 2 | |||
| 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 | ||||
| 5864 | 189275 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015964.59668 | 2107087.77889 | 37.7665579289401 | -122.388016032733 | (37.7665579289401, -122.388016032733) | 14 | 3 | 9 | 310 | 20 | |||
| 6033 | 242140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 570 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6002975.94963 | 2104907.04383 | 37.7598420023198 | -122.432785628653 | (37.7598420023198, -122.432785628653) | 2 | 4 | 5 | 28862 | 3 | |||
| 9264 | 188788 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015967.32751 | 2107012.0323 | 37.7663500965054 | -122.388001300914 | (37.7663500965054, -122.388001300914) | 14 | 3 | 9 | 310 | 20 | |||
| 10132 | 136901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2333 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | Width 5ft | 6007536.47447 | 2120305.57509 | 37.8023802472184 | -122.41810464953 | (37.8023802472184, -122.41810464953) | 5 | 1 | 1 | 28858 | 32 | ||
| 13982 | 189273 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015966.51086 | 2107036.5181 | 37.7664172839651 | -122.388005834417 | (37.7664172839651, -122.388005834417) | 14 | 3 | 9 | 310 | 20 | |||
| 14181 | 188787 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015968.04519 | 2106982.6549 | 37.7662694722874 | -122.387996768362 | (37.7662694722874, -122.387996768362) | 14 | 3 | 9 | 310 | 20 | |||
| 17112 | 198009 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 275 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011338.42729 | 2111564.35079 | 37.7785921853276 | -122.404332338179 | (37.7785921853276, -122.404332338179) | 14 | 2 | 9 | 28856 | 34 | |||
| 18169 | 189274 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015965.43281 | 2107064.27168 | 37.7664934295578 | -122.388011500129 | (37.7664934295578, -122.388011500129) | 14 | 3 | 9 | 310 | 20 | |||
| 28256 | 242116 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004100.79809 | 2102964.07193 | 37.7545707934166 | -122.428756816079 | (37.7545707934166, -122.428756816079) | 2 | 4 | 5 | 28862 | 22 | |||
| 35499 | 241644 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 415 Oak St | 1 | : | Tree | Private 2 | 5 | Width 5ft | 6004982.83626 | 2110199.46219 | 37.7744873314449 | -122.426221580476 | (37.7744873314449, -122.426221580476) | 7 | 9 | 11 | 28852 | 10 | |||
| 38731 | 218719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | 1 | 8 | 4 | 29491 | 40 | |||
| 42533 | 241568 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 180 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5997429.42135 | 2107115.98897 | 37.7655910714086 | -122.452127637501 | (37.7655910714086, -122.452127637501) | 15 | 5 | 11 | 29492 | 9 | |||
| 42817 | 241572 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 160 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 5997589.92507 | 2107138.86061 | 37.7656630639196 | -122.451574143434 | (37.7656630639196, -122.451574143434) | 15 | 5 | 11 | 29492 | 9 | |||
| 46441 | 242117 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3862 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6004018.60502 | 2102491.85861 | 37.7532695544679 | -122.429007395984 | (37.7532695544679, -122.429007395984) | 2 | 4 | 5 | 28862 | 22 | |||
| 47207 | 242169 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6001204.17131 | 2103411.5478 | 37.7556350870992 | -122.438806161672 | (37.7556350870992, -122.438806161672) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 57274 | 123745 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5995418.55494 | 2110821.81217 | 37.7756508992149 | -122.459351125835 | (37.7756508992149, -122.459351125835) | 11 | 6 | 2 | 54 | 11 | ||
| 66208 | 241884 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 387x Holly Park Cir | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 6006329.10923 | 2096869.11862 | 37.7379612981598 | -122.420618072992 | (37.7379612981598, -122.420618072992) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 79226 | 242290 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 411 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6003806.71849 | 2098340.54293 | 37.7418590111824 | -122.429444121165 | (37.7418590111824, -122.429444121165) | 2 | 7 | 5 | 63 | 7 | |||
| 81363 | 136773 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3700 Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 5997087.63405 | 2115382.98143 | 37.7882704886466 | -122.453906871501 | (37.7882704886466, -122.453906871501) | 11 | 6 | 1 | 54 | 31 | |||
| 84961 | 241836 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 585 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5999889.42807 | 2107459.27885 | 37.7666742688382 | -122.443643711196 | (37.7666742688382, -122.443643711196) | 15 | 5 | 5 | 29492 | 9 | |||
| 86016 | 242218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 118 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6001045.95716 | 2105660.24259 | 37.7618004523493 | -122.439514506402 | (37.7618004523493, -122.439514506402) | 15 | 5 | 5 | 28862 | 3 | |||
| 86404 | 242136 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4244 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6002010.12095 | 2104720.80627 | 37.7592758143449 | -122.436112624717 | (37.7592758143449, -122.436112624717) | 2 | 4 | 5 | 28862 | 3 | |||
| 88667 | 180141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Russia Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6004021.03877 | 2089333.04789 | 37.717138576267 | -122.428061324472 | (37.717138576267, -122.428061324472) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 98701 | 218721 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.7466566307978 | -122.464476068412 | (37.7466566307978, -122.464476068412) | 1 | 8 | 4 | 29491 | 40 | |||
| 101137 | 241782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 209 Day St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6004251.25881 | 2098661.78122 | 37.7427662166839 | -122.427929930832 | (37.7427662166839, -122.427929930832) | 2 | 7 | 5 | 63 | 22 | |||
| 105353 | 241653 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Albion St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6005919.97571 | 2106387.47862 | 37.7640734600439 | -122.422708877137 | (37.7640734600439, -122.422708877137) | 8 | 4 | 5 | 28859 | 19 | |||
| 109982 | 241567 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 184 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5997406.33388 | 2107112.14294 | 37.7655791886465 | -122.452207213993 | (37.7655791886465, -122.452207213993) | 15 | 5 | 11 | 29492 | 9 | |||
| 112250 | 241570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 172 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5997494.28086 | 2107124.81826 | 37.7656190295163 | -122.451903941019 | (37.7656190295163, -122.451903941019) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 126139 | 241883 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 387x Holly Park Cir | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 6006344.80529 | 2096881.18885 | 37.7379953249194 | -122.420564660452 | (37.7379953249194, -122.420564660452) | 2 | 7 | 7 | 28859 | 2 | |||
| 131893 | 218720 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.7466556145593 | -122.464499198102 | (37.7466556145593, -122.464499198102) | 1 | 8 | 4 | 29491 | 40 | |||
| 132134 | 242135 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 134 Collingwood St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6002035.55784 | 2104758.56511 | 37.7593809360961 | -122.436027353682 | (37.7593809360961, -122.436027353682) | 2 | 4 | 5 | 28862 | 3 |
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) );