trees
7,322 rows where qSpecies_id = 1 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81799 | 202306 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 160 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6012951.54895 | 2092971.80336 | 37.7276310834963 | -122.397447635807 | (37.7276310834963, -122.397447635807) | 10 | 3 | 8 | 58 | 1 | |||
| 82791 | 218562 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Rossmoor Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5990887.70773 | 2094513.01623 | 37.7306096875755 | -122.473834230193 | (37.7306096875755, -122.473834230193) | 9 | 8 | 4 | 64 | 40 | |||
| 83188 | 241233 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 121 Duboce Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005881.34596 | 2108456.5771 | 37.7697525330713 | -122.422989557315 | (37.7697525330713, -122.422989557315) | 8 | 4 | 5 | 28853 | 19 | |||
| 83926 | 247656 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 181 Divisadero St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6001861.58357 | 2108639.17546 | 37.7700262561313 | -122.436906851995 | (37.7700262561313, -122.436906851995) | 15 | 5 | 5 | 29492 | 9 | |||
| 85673 | 241243 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6006251.40928 | 2109061.26398 | 37.771433733823 | -122.421752473299 | (37.771433733823, -122.421752473299) | 8 | 2 | 9 | 28853 | 19 | |||
| 89767 | 218545 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Elmhurst Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991243.29595 | 2094455.32359 | 37.7304718673622 | -122.472600715558 | (37.7304718673622, -122.472600715558) | 9 | 8 | 4 | 64 | 40 | |||
| 90139 | 247669 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 154 Divisadero St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6001934.24111 | 2108541.81832 | 37.7697630668318 | -122.436648561282 | (37.7697630668318, -122.436648561282) | 15 | 5 | 5 | 29492 | 9 | |||
| 90630 | 202307 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 172 Orsi Cir | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6012991.60594 | 2092941.53695 | 37.7275502083622 | -122.397307035804 | (37.7275502083622, -122.397307035804) | 10 | 3 | 8 | 58 | 1 | |||
| 91903 | 246448 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 Duncan St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6003657.43192 | 2099795.32001 | 37.7458450394138 | -122.430064059802 | (37.7458450394138, -122.430064059802) | 2 | 7 | 5 | 63 | 22 | |||
| 91927 | 198023 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 336 07th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6010479.15286 | 2110685.94265 | 37.7761322274527 | -122.407242974182 | (37.7761322274527, -122.407242974182) | 8 | 2 | 9 | 28853 | 34 | |||
| 92663 | 218524 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Bright St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993735.17777 | 2088595.3117 | 37.7145256185467 | -122.463560865244 | (37.7145256185467, -122.463560865244) | 9 | 8 | 6 | 64 | 24 | |||
| 92729 | 218534 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 171 Eucalyptus Dr | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991093.98994 | 2094659.29915 | 37.731023289396 | -122.47313175264 | (37.731023289396, -122.47313175264) | 9 | 8 | 4 | 64 | 40 | |||
| 93086 | 218553 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991104.11114 | 2094544.62455 | 37.7307090078018 | -122.473088402633 | (37.7307090078018, -122.473088402633) | 9 | 8 | 4 | 64 | 40 | |||
| 93859 | 218574 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Rossmoor Dr | 3 | : | Tree | Private 2 | 7 | Width 3ft | 5990724.62929 | 2094434.60047 | 37.730384930811 | -122.474392290997 | (37.730384930811, -122.474392290997) | 9 | 8 | 4 | 64 | 40 | |||
| 94384 | 247796 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 410 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6003801.70372 | 2098385.09969 | 37.7419810698755 | -122.429464637397 | (37.7419810698755, -122.429464637397) | 2 | 7 | 5 | 63 | 22 | |||
| 94576 | 247760 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 67 Alpine Ter | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6001664.39466 | 2108401.08395 | 37.769361306418 | -122.437571870939 | (37.769361306418, -122.437571870939) | 15 | 5 | 5 | 29492 | 9 | |||
| 95269 | 241242 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006249.62904 | 2109085.1733 | 37.7714992827056 | -122.421760329799 | (37.7714992827056, -122.421760329799) | 8 | 2 | 9 | 28853 | 19 | |||
| 95807 | 241232 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 127 Duboce Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005861.10215 | 2108452.80959 | 37.7697410460526 | -122.423059312352 | (37.7697410460526, -122.423059312352) | 8 | 4 | 5 | 28853 | 19 | |||
| 96244 | 198025 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 07th St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6010596.75849 | 2110567.34624 | 37.7758131704772 | -122.406827782384 | (37.7758131704772, -122.406827782384) | 8 | 2 | 9 | 28853 | 34 | |||
| 96284 | 198123 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6013790.53973 | 2093615.86346 | 37.7294462202468 | -122.394592294619 | (37.7294462202468, -122.394592294619) | 10 | 3 | 8 | 58 | 1 | |||
| 97906 | 246466 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6004915.09696 | 2099911.47997 | 37.7462351365464 | -122.425723494564 | (37.7462351365464, -122.425723494564) | 2 | 7 | 5 | 63 | 22 | |||
| 100779 | 241235 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Duboce Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6006333.55405 | 2108477.41029 | 37.7698352428425 | -122.421426859387 | (37.7698352428425, -122.421426859387) | 8 | 4 | 7 | 28853 | 19 | |||
| 100872 | 246777 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999 Esmeralda Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6009797.21776 | 2098767.51115 | 37.7433687202062 | -122.408760953364 | (37.7433687202062, -122.408760953364) | 2 | 7 | 7 | 28859 | 2 | |||
| 101708 | 218550 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991159.53615 | 2094513.62652 | 37.7306271038561 | -122.472894532173 | (37.7306271038561, -122.472894532173) | 9 | 8 | 4 | 64 | 40 | |||
| 102206 | 241229 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 291 Duboce Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6004995.48902 | 2108399.8809 | 37.769546832063 | -122.426049676848 | (37.769546832063, -122.426049676848) | 8 | 4 | 5 | 28853 | 19 | |||
| 102915 | 241249 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1358 Stevenson St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6006262.04942 | 2108777.18476 | 37.7706543201802 | -122.42169548777 | (37.7706543201802, -122.42169548777) | 8 | 2 | 9 | 28853 | 19 | |||
| 104298 | 218515 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Vernon St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5992482.76796 | 2089904.38544 | 37.7180477764537 | -122.467984821937 | (37.7180477764537, -122.467984821937) | 9 | 8 | 6 | 64 | 24 | |||
| 104627 | 198041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 966 Natoma St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6007944.08688 | 2109820.93616 | 37.7736149216237 | -122.415951204886 | (37.7736149216237, -122.415951204886) | 8 | 2 | 9 | 28853 | 34 | |||
| 106588 | 218542 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Rossmoor Dr | 3 | : | Tree | Private 2 | 5 | Width 2ft | 5991269.73751 | 2094338.22324 | 37.7301518696951 | -122.472500770291 | (37.7301518696951, -122.472500770291) | 9 | 8 | 4 | 64 | 40 | |||
| 107046 | 218539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 167 Eucalyptus Dr | 2 | : | Tree | Private 2 | 4 | Width 2ft | 5991186.57078 | 2094655.95963 | 37.7310194798608 | -122.472811444694 | (37.7310194798608, -122.472811444694) | 9 | 8 | 4 | 64 | 40 | |||
| 108036 | 246600 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6005541.07514 | 2109239.29711 | 37.771882487431 | -122.424222221193 | (37.771882487431, -122.424222221193) | 7 | 9 | 5 | 28852 | 10 | |||
| 108455 | 218529 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Eucalyptus Dr | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5990845.10794 | 2094666.97645 | 37.7310299560481 | -122.473992731197 | (37.7310299560481, -122.473992731197) | 9 | 8 | 4 | 64 | 40 | |||
| 110372 | 198134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 131 Bridgeview Dr | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6013337.13307 | 2095632.71653 | 37.7349588665628 | -122.396301078452 | (37.7349588665628, -122.396301078452) | 10 | 3 | 8 | 58 | 1 | |||
| 113038 | 241556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3750 Market St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6000189.8094 | 2102874.5763 | 37.754102932814 | -122.442275587868 | (37.754102932814, -122.442275587868) | 2 | 4 | 5 | 63 | 38 | |||
| 113287 | 241641 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Laussat St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004373.36831 | 2109264.69738 | 37.7718862277038 | -122.428263213293 | (37.7718862277038, -122.428263213293) | 7 | 9 | 11 | 28852 | 10 | |||
| 114593 | 218530 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 179 Eucalyptus Dr | 2 | : | Tree | Private 2 | 3 | Width 2ft | 5990903.39265 | 2094666.82321 | 37.7310329112435 | -122.473791221893 | (37.7310329112435, -122.473791221893) | 9 | 8 | 4 | 64 | 40 | |||
| 115071 | 218548 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5991200.16843 | 2094507.91417 | 37.7306137713995 | -122.47275364526 | (37.7306137713995, -122.47275364526) | 9 | 8 | 4 | 64 | 40 | |||
| 115082 | 218527 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Eucalyptus Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5990817.95884 | 2094667.89607 | 37.7310309084509 | -122.474086656376 | (37.7310309084509, -122.474086656376) | 9 | 8 | 4 | 64 | 40 | |||
| 115737 | 241557 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3750 Market St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6000178.6391 | 2102857.41231 | 37.7540551680289 | -122.442312985266 | (37.7540551680289, -122.442312985266) | 2 | 4 | 5 | 63 | 38 | |||
| 116136 | 198138 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 134 Bridgeview Dr | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6013340.15564 | 2095686.70251 | 37.7351072690864 | -122.396294410852 | (37.7351072690864, -122.396294410852) | 10 | 3 | 8 | 58 | 1 | |||
| 117241 | 249541 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1031 Franklin St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6006016.72642 | 2113765.14809 | 37.7843362199808 | -122.422898622377 | (37.7843362199808, -122.422898622377) | 7 | 9 | 11 | 28858 | 41 | |||
| 117267 | 218540 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Rossmoor Dr | 1 | : | Tree | Private 2 | 7 | Width 2ft | 5991304.84344 | 2094334.70837 | 37.7301442506463 | -122.472379149601 | (37.7301442506463, -122.472379149601) | 9 | 8 | 4 | 64 | 40 | |||
| 117435 | 198144 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1790 Newcomb Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014242.32519 | 2096462.18043 | 37.7372867320059 | -122.393229508759 | (37.7372867320059, -122.393229508759) | 10 | 3 | 8 | 58 | 1 | |||
| 118422 | 198131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 171 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6013157.52169 | 2095742.10645 | 37.7352492324546 | -122.396929729716 | (37.7352492324546, -122.396929729716) | 10 | 3 | 8 | 58 | 1 | |||
| 118490 | 198107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2137 24th St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6012025.37785 | 2102315.32766 | 37.7532348073506 | -122.401305765163 | (37.7532348073506, -122.401305765163) | 10 | 3 | 8 | 28856 | 29 | |||
| 118506 | 247781 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 266 30th St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6004850.70069 | 2098447.83797 | 37.7422126713879 | -122.425842004521 | (37.7422126713879, -122.425842004521) | 2 | 7 | 5 | 63 | 22 | |||
| 119854 | 198116 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Toland St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6012565.75039 | 2098841.96583 | 37.7437278356634 | -122.399193239673 | (37.7437278356634, -122.399193239673) | 10 | 3 | 8 | 58 | 1 | |||
| 121044 | 201654 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 744 Innes Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6020169.84192 | 2093795.17741 | 37.73029117649 | -122.372550568669 | (37.73029117649, -122.372550568669) | 10 | 3 | 8 | 58 | 1 | |||
| 123276 | 198021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 217 Clara St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011882.31824 | 2111817.0211 | 37.7793163374183 | -122.402468571477 | (37.7793163374183, -122.402468571477) | 14 | 2 | 9 | 28856 | 34 | |||
| 125999 | 218528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 183 Eucalyptus Dr | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5990831.87058 | 2094666.90886 | 37.7310290036836 | -122.474038489609 | (37.7310290036836, -122.474038489609) | 9 | 8 | 4 | 64 | 40 | |||
| 126394 | 198126 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 6 | : | Tree | Private 2 | 13 | Width 3ft | 6013842.55163 | 2093605.35504 | 37.7294202577333 | -122.394411747628 | (37.7294202577333, -122.394411747628) | 10 | 3 | 8 | 58 | 1 | |||
| 126464 | 218544 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Elmhurst Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991241.31591 | 2094410.9683 | 37.7303499642599 | -122.472604328142 | (37.7303499642599, -122.472604328142) | 9 | 8 | 4 | 64 | 40 | |||
| 127162 | 198117 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Toland St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6012558.18705 | 2098832.22604 | 37.7437006707628 | -122.399218708504 | (37.7437006707628, -122.399218708504) | 10 | 3 | 8 | 58 | 1 | |||
| 127200 | 198034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Dore St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6009821.34392 | 2108859.50792 | 37.7710804261486 | -122.409389596552 | (37.7710804261486, -122.409389596552) | 8 | 2 | 9 | 28853 | 34 | |||
| 128682 | 218571 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5990740.27734 | 2094470.45315 | 37.7304842798098 | -122.474340809303 | (37.7304842798098, -122.474340809303) | 9 | 8 | 4 | 64 | 40 | |||
| 130172 | 201486 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 934 Innes Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6019032.21192 | 2094642.96183 | 37.7325564518085 | -122.376542332772 | (37.7325564518085, -122.376542332772) | 10 | 3 | 8 | 58 | 1 | |||
| 130883 | 198022 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Oak Grove St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6012061.64119 | 2111076.36205 | 37.7772926676625 | -122.401796138478 | (37.7772926676625, -122.401796138478) | 14 | 2 | 9 | 28856 | 34 | |||
| 132296 | 218557 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 56 Rossmoor Dr | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5990972.9543 | 2094544.43485 | 37.7307008923158 | -122.473541813811 | (37.7307008923158, -122.473541813811) | 9 | 8 | 4 | 64 | 40 | |||
| 132453 | 247666 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 136 Divisadero St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6001948.31125 | 2108443.5233 | 37.7694939725921 | -122.436592856397 | (37.7694939725921, -122.436592856397) | 15 | 5 | 5 | 29492 | 9 | |||
| 133062 | 180225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2901 Ocean Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5989891.99303 | 2095239.26614 | 37.7325460628359 | -122.477329584708 | (37.7325460628359, -122.477329584708) | 1 | 8 | 4 | 64 | 35 | |||
| 135180 | 198005 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 238 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011481.12872 | 2111736.55218 | 37.7790729835718 | -122.403850797089 | (37.7790729835718, -122.403850797089) | 14 | 2 | 9 | 28856 | 34 | |||
| 135511 | 241245 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006256.03019 | 2109015.93605 | 37.7713095347467 | -122.421733269202 | (37.7713095347467, -122.421733269202) | 8 | 2 | 9 | 28853 | 19 | |||
| 135620 | 201482 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801 Arelious Walker Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6019833.06925 | 2094138.86397 | 37.7312163630497 | -122.373738644125 | (37.7312163630497, -122.373738644125) | 10 | 3 | 8 | 58 | 1 | |||
| 136486 | 241649 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Scott St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6002442.34767 | 2108446.81048 | 37.7695310606306 | -122.43488424161 | (37.7695310606306, -122.43488424161) | 15 | 5 | 5 | 29492 | 9 | |||
| 137114 | 198035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 10th St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6009567.84778 | 2108801.86645 | 37.7709079496765 | -122.410262381426 | (37.7709079496765, -122.410262381426) | 8 | 2 | 9 | 28853 | 34 | |||
| 137566 | 218532 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 175 Eucalyptus Dr | 2 | : | Tree | Private 2 | 2 | Width 2ft | 5991015.99501 | 2094660.59708 | 37.7310223370113 | -122.473401486299 | (37.7310223370113, -122.473401486299) | 9 | 8 | 4 | 64 | 40 | |||
| 139285 | 198133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Bridgeview Dr | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6013277.82741 | 2095722.37145 | 37.7352017401562 | -122.396512402938 | (37.7352017401562, -122.396512402938) | 10 | 3 | 8 | 58 | 1 | |||
| 139432 | 180234 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3353 19th Ave | 8 | : | Tree | Private 2 | 1 | Width 3ft | 5990557.66801 | 2094210.25193 | 37.7297592517825 | -122.474953123507 | (37.7297592517825, -122.474953123507) | 1 | 8 | 4 | 64 | 14 | |||
| 141551 | 198128 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2115 Quesada Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6012499.36052 | 2096642.9645 | 37.7376861424924 | -122.399268467073 | (37.7376861424924, -122.399268467073) | 10 | 3 | 8 | 58 | 1 | |||
| 143644 | 218543 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Elmhurst Dr | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991239.17772 | 2094375.63397 | 37.7302528212926 | -122.472609144905 | (37.7302528212926, -122.472609144905) | 9 | 8 | 4 | 64 | 40 | |||
| 144275 | 218520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 286 Ramsell St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992992.28014 | 2089088.20524 | 37.7158361528844 | -122.466164394478 | (37.7158361528844, -122.466164394478) | 9 | 8 | 6 | 64 | 24 | |||
| 145414 | 201484 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801 Arelious Walker Dr | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6019815.12004 | 2094115.72508 | 37.731151841174 | -122.37379909656 | (37.731151841174, -122.37379909656) | 10 | 3 | 8 | 58 | 1 | |||
| 146024 | 246601 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 3 | : | Tree | Private 2 | 2 | Width 4ft | 6005553.21097 | 2109241.87873 | 37.7718902611687 | -122.424180426085 | (37.7718902611687, -122.424180426085) | 7 | 9 | 5 | 28852 | 10 | |||
| 146231 | 246603 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 5 | : | Tree | Private 2 | 2 | Width 4ft | 6005584.08918 | 2109245.72637 | 37.7719025692852 | -122.424073889709 | (37.7719025692852, -122.424073889709) | 7 | 9 | 5 | 28852 | 10 | |||
| 146262 | 218568 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 83 Rossmoor Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5990778.04492 | 2094453.64092 | 37.7304403056549 | -122.47420901636 | (37.7304403056549, -122.47420901636) | 9 | 8 | 4 | 64 | 40 | |||
| 146716 | 241638 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Guerrero St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6005425.11854 | 2107744.64124 | 37.767771973225 | -122.424516988391 | (37.767771973225, -122.424516988391) | 8 | 4 | 5 | 28853 | 19 | |||
| 151291 | 241253 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 398 Guerrero St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6005480.91961 | 2106731.68653 | 37.764993792043 | -122.424251927594 | (37.764993792043, -122.424251927594) | 8 | 4 | 5 | 28853 | 19 | |||
| 152649 | 247798 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 436 30th St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6003746.33333 | 2098382.81749 | 37.7419716683528 | -122.429655927686 | (37.7419716683528, -122.429655927686) | 2 | 7 | 5 | 63 | 22 | |||
| 153214 | 202321 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6012949.57372 | 2093020.25943 | 37.7277640239878 | -122.397457861103 | (37.7277640239878, -122.397457861103) | 10 | 3 | 8 | 58 | 1 | |||
| 153697 | 217808 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 199 Lee Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5996522.50518 | 2091865.39912 | 37.7236647198324 | -122.454162841049 | (37.7236647198324, -122.454162841049) | 9 | 7 | 4 | 28861 | 40 | |||
| 154250 | 218508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 82 Margaret Ave | 2 | : | Tree | Private 2 | 10 | Width 3ft | 5996984.38941 | 2089699.59442 | 37.717744402756 | -122.452409980531 | (37.717744402756, -122.452409980531) | 9 | 8 | 6 | 28861 | 24 | |||
| 154804 | 85219 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 603 22nd Ave | 2 | : | Tree | Private 2 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.79608 | 2111176.31145 | 37.7762575972787 | -122.481314542866 | (37.7762575972787, -122.481314542866) | 11 | 6 | 2 | 55 | 26 | ||
| 155157 | 198024 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 07th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6010586.99761 | 2110579.16527 | 37.7758450766249 | -122.406862381093 | (37.7758450766249, -122.406862381093) | 8 | 2 | 9 | 28853 | 34 | |||
| 155291 | 247763 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Alpine Ter | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6001651.1462 | 2108480.69017 | 37.7695791321082 | -122.437623398511 | (37.7695791321082, -122.437623398511) | 15 | 5 | 5 | 29492 | 9 | |||
| 156650 | 218554 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Rossmoor Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991096.97089 | 2094386.86315 | 37.7302754212525 | -122.473101586686 | (37.7302754212525, -122.473101586686) | 9 | 8 | 4 | 64 | 40 | |||
| 156887 | 241236 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Duboce Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6006331.40879 | 2108550.25006 | 37.7700351225408 | -122.421439453463 | (37.7700351225408, -122.421439453463) | 8 | 2 | 7 | 28853 | 19 | |||
| 158486 | 218563 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990853.66269 | 2094536.86772 | 37.7306732058057 | -122.473953667332 | (37.7306732058057, -122.473953667332) | 9 | 8 | 4 | 64 | 40 | |||
| 159263 | 115188 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 5 | : | Tree | DPW 1 | 3 | 5999393.52095 | 2089220.32873 | 37.7165661770546 | -122.444048302203 | (37.7165661770546, -122.444048302203) | 9 | 7 | 6 | 28861 | 25 | ||||
| 160560 | 241640 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 64 Laussat St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6004387.18256 | 2109287.3052 | 37.7719490849137 | -122.428217040306 | (37.7719490849137, -122.428217040306) | 7 | 9 | 11 | 28852 | 10 | |||
| 160572 | 180224 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3599 Alemany Blvd | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5993480.96313 | 2087505.0727 | 37.7115174312511 | -122.464360418308 | (37.7115174312511, -122.464360418308) | 9 | 8 | 4 | 64 | 24 | |||
| 161246 | 218569 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95 Rossmoor Dr | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5990765.45397 | 2094449.75445 | 37.7304289049727 | -122.474252261144 | (37.7304289049727, -122.474252261144) | 9 | 8 | 4 | 64 | 40 | |||
| 161653 | 247795 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 408 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6003836.77293 | 2098388.1114 | 37.7419913248315 | -122.429343594042 | (37.7419913248315, -122.429343594042) | 2 | 7 | 5 | 63 | 22 | |||
| 162440 | 198127 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Lucy St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6014137.80276 | 2093994.81434 | 37.7305060425038 | -122.393418272834 | (37.7305060425038, -122.393418272834) | 10 | 3 | 8 | 58 | 1 | |||
| 162501 | 218561 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Rossmoor Dr | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5990869.78333 | 2094510.42853 | 37.7306015442042 | -122.473896008201 | (37.7306015442042, -122.473896008201) | 9 | 8 | 4 | 64 | 40 | |||
| 163234 | 218526 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 424 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992849.69775 | 2090512.21172 | 37.7197379029691 | -122.466760675572 | (37.7197379029691, -122.466760675572) | 9 | 8 | 6 | 64 | 24 | |||
| 166005 | 198111 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Arkansas St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6012942.0959 | 2104655.9995 | 37.7597128848667 | -122.398299761423 | (37.7597128848667, -122.398299761423) | 10 | 3 | 8 | 28856 | 29 | |||
| 166219 | 218533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 175 Eucalyptus Dr | 3 | : | Tree | Private 2 | 3 | Width 2ft | 5991030.95126 | 2094659.58794 | 37.7310204322329 | -122.473349706944 | (37.7310204322329, -122.473349706944) | 9 | 8 | 4 | 64 | 40 | |||
| 166565 | 198042 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 966 Natoma St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6007955.48118 | 2109829.77546 | 37.7736398328458 | -122.415912416224 | (37.7736398328458, -122.415912416224) | 8 | 2 | 9 | 28853 | 34 | |||
| 166694 | 198135 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 111 Bridgeview Dr | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6013464.34426 | 2095584.81756 | 37.7348344237609 | -122.395857906032 | (37.7348344237609, -122.395857906032) | 10 | 3 | 8 | 58 | 1 | |||
| 167282 | 241642 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 Laussat St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004646.58441 | 2109298.02282 | 37.7719931867726 | -122.427320513349 | (37.7719931867726, -122.427320513349) | 7 | 9 | 11 | 28852 | 10 |
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) );