trees
7,322 rows where qSpecies_id = 1 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5139 | 19520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 127 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6000564 | 2112525 | 37.7806219117946 | -122.44167407009 | (37.7806219117946, -122.44167407009) | 15 | 5 | 1 | 29490 | 16 | |||
| 5190 | 19521 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 130X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000722.7955642 | 2112514.8377136 | 37.7806030550121 | -122.441123992492 | (37.7806030550121, -122.441123992492) | 15 | 5 | 1 | 29490 | 41 | |||
| 5291 | 95249 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.4815747855 | (37.778566675209, -122.4815747855) | 11 | 6 | 2 | 55 | 26 | ||||
| 5314 | 71429 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2029 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009865.7372 | 2121062.537 | 37.8045895022466 | -122.410097693334 | (37.8045895022466, -122.410097693334) | 3 | 1 | 10 | 308 | 23 | |||
| 5395 | 214900 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 69 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992595.17834 | 2098673.73573 | 37.7421327279347 | -122.468233863115 | (37.7421327279347, -122.468233863115) | 1 | 8 | 4 | 59 | 40 | |||
| 5465 | 198179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 227 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010077.86899 | 2111204.28564 | 37.7775330096684 | -122.408667704448 | (37.7775330096684, -122.408667704448) | 14 | 2 | 9 | 28853 | 34 | |||
| 5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 5497 | 200583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016440.4137 | 2094932.3213 | 37.7332079157453 | -122.385523046608 | (37.7332079157453, -122.385523046608) | 10 | 3 | 8 | 58 | 1 | |||
| 5559 | 232424 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004483.72015 | 2103686.16481 | 37.7565751556437 | -122.427484009182 | (37.7565751556437, -122.427484009182) | 2 | 4 | 5 | 28862 | 3 | |||
| 5609 | 83165 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1903 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015168.2313 | 2093359.9647 | 37.7288200702379 | -122.389811574581 | (37.7288200702379, -122.389811574581) | 10 | 3 | 8 | 58 | 1 | |||
| 5613 | 73412 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009997.41366 | 2093830.92817 | 37.7298251334141 | -122.407720715656 | (37.7298251334141, -122.407720715656) | 10 | 3 | 7 | 309 | 28 | |||
| 5634 | 243287 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007091.10109 | 2107897.19538 | 37.7682847927477 | -122.418765362556 | (37.7682847927477, -122.418765362556) | 8 | 4 | 7 | 28853 | 19 | |||
| 5649 | 136764 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003765.13271 | 2119380.44822 | 37.7996270995734 | -122.43108927166 | (37.7996270995734, -122.43108927166) | 13 | 9 | 1 | 57 | 17 | |||
| 5718 | 76201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009589.6321 | 2110267.6834 | 37.7749339625844 | -122.410290540065 | (37.7749339625844, -122.410290540065) | 8 | 2 | 9 | 28853 | 34 | |||
| 5741 | 242313 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1513 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005931.42593 | 2100183.60799 | 37.7470397168238 | -122.42222847906 | (37.7470397168238, -122.42222847906) | 2 | 7 | 5 | 28859 | 22 | |||
| 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 | |||
| 5775 | 182783 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1790 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5989709.7208 | 2103167.237 | 37.7543036278795 | -122.478539284935 | (37.7543036278795, -122.478539284935) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 5898 | 172286 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 930 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001778.14315 | 2086833.9607 | 37.7101494832819 | -122.435635245683 | (37.7101494832819, -122.435635245683) | 9 | 7 | 6 | 28861 | 5 | |||
| 5918 | 103690 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 775299 | 6001175.90706 | 2121214.18027 | 37.804514981434 | -122.440180480455 | (37.804514981434, -122.440180480455) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | |||
| 5951 | 180245 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202 Theresa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002009.45925 | 2093875.90967 | 37.729498237948 | -122.435339160997 | (37.729498237948, -122.435339160997) | 9 | 7 | 6 | 28861 | 25 | |||
| 5984 | 262524 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 27 Ledyard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011604 | 2095169 | 37.7335890054418 | -122.402260572751 | (37.7335890054418, -122.402260572751) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 6071 | 258212 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987967 | 2106401 | 37.7630813299835 | -122.484803190012 | (37.7630813299835, -122.484803190012) | 1 | 8 | 3 | 56 | 35 | ||||
| 6144 | 241936 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 759X San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005744.44871 | 2098796.80152 | 37.7432213132203 | -122.422776490869 | (37.7432213132203, -122.422776490869) | 2 | 7 | 7 | 28859 | 2 | |||
| 6157 | 180362 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 207 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003956.84775 | 2092462.08081 | 37.725726580201 | -122.428506110284 | (37.725726580201, -122.428506110284) | 9 | 7 | 6 | 28861 | 5 | |||
| 6182 | 141450 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 331 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998994.1872 | 2111647.2194 | 37.7781221863192 | -122.447041594506 | (37.7781221863192, -122.447041594506) | 15 | 5 | 2 | 54 | 16 | |||
| 6185 | 242286 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2335 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001701.03662 | 2097009.50428 | 37.7380848461481 | -122.436629617076 | (37.7380848461481, -122.436629617076) | 2 | 7 | 5 | 63 | 7 | |||
| 6219 | 198125 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6013825.74476 | 2093610.04486 | 37.72943220072 | -122.394470179266 | (37.72943220072, -122.394470179266) | 10 | 3 | 8 | 58 | 1 | |||
| 6260 | 215528 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994077.87758 | 2097807.84952 | 37.7398407436586 | -122.463044382805 | (37.7398407436586, -122.463044382805) | 1 | 8 | 4 | 59 | 40 | |||
| 6268 | 242036 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 738 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005687.40975 | 2098898.81838 | 37.7434982099803 | -122.422980966116 | (37.7434982099803, -122.422980966116) | 2 | 7 | 5 | 28859 | 22 | |||
| 6355 | 100391 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6002817 | 2092256 | 37.7250961583897 | -122.432431760897 | (37.7250961583897, -122.432431760897) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | ||||
| 6374 | 70234 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983192.21244 | 2110893.91815 | 37.7751383456194 | -122.501649705941 | (37.7751383456194, -122.501649705941) | 11 | 6 | 2 | 55 | 26 | |||
| 6517 | 241598 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007808.70571 | 2095960.84327 | 37.735550650134 | -122.415438080511 | (37.735550650134, -122.415438080511) | 2 | 7 | 7 | 28859 | 2 | |||
| 6627 | 218493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994696.5338 | 2089004.6688 | 37.7157049615873 | -122.460267696305 | (37.7157049615873, -122.460267696305) | 9 | 8 | 6 | 28861 | 24 | |||
| 6634 | 241972 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 302 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006732 | 2096266 | 37.736327966203 | -122.419182308653 | (37.736327966203, -122.419182308653) | 2 | 7 | 7 | 28859 | 2 | |||
| 6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6675 | 264798 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 698 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009708 | 2091117 | 37.7223570514359 | -122.408529889307 | (37.7223570514359, -122.408529889307) | 10 | 3 | 7 | 309 | 28 | ||||
| 6680 | 84384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012605.75567 | 2099001.93015 | 37.7441692930905 | -122.399066135804 | (37.7441692930905, -122.399066135804) | 10 | 3 | 8 | 58 | 1 | |||
| 6710 | 71626 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | 3 | 1 | 10 | 308 | 23 | |||
| 6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 6815 | 26065 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 252 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5994463.9745 | 2088114.2994 | 37.7132468380661 | -122.461007025599 | (37.7132468380661, -122.461007025599) | 9 | 8 | 6 | 28861 | 24 | |||
| 6819 | 198078 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501 25th St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014189.20223 | 2101966.89329 | 37.752398567346 | -122.393798376688 | (37.752398567346, -122.393798376688) | 10 | 3 | 8 | 28856 | 1 | ||||
| 6874 | 258105 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5998652.17813 | 2087511.67596 | 37.7118322871785 | -122.446487885746 | (37.7118322871785, -122.446487885746) | 9 | 7 | 6 | 28861 | 25 | |||||
| 6888 | 218618 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993537.76675 | 2105312.92426 | 37.7604166340443 | -122.465456904135 | (37.7604166340443, -122.465456904135) | 1 | 8 | 11 | 56 | 12 | |||
| 6917 | 198033 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009852.55619 | 2108823.88524 | 37.770984363256 | -122.409279117555 | (37.770984363256, -122.409279117555) | 8 | 2 | 9 | 28853 | 34 | |||
| 7004 | 73618 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 623 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5984097.49569 | 2111586.76051 | 37.7770938216215 | -122.498569368455 | (37.7770938216215, -122.498569368455) | 11 | 6 | 2 | 55 | 26 | |||
| 7008 | 84391 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012539.7904 | 2099051.16113 | 37.744300794662 | -122.39929768604 | (37.744300794662, -122.39929768604) | 10 | 3 | 8 | 58 | 1 | |||
| 7040 | 76155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009557.4611 | 2110236.6613 | 37.7748469797507 | -122.410399635935 | (37.7748469797507, -122.410399635935) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 7057 | 246148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.7688970087309 | -122.448642496615 | (37.7688970087309, -122.448642496615) | 15 | 5 | 11 | 29492 | 9 | |||
| 7148 | 172130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | Width 2ft | 6010555.51143 | 2093279.58738 | 37.7283424940077 | -122.405752478307 | (37.7283424940077, -122.405752478307) | 10 | 3 | 7 | 309 | 28 | ||
| 7216 | 216077 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1273 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993901.44113 | 2106829.63078 | 37.7646020824424 | -122.464309250467 | (37.7646020824424, -122.464309250467) | 11 | 5 | 11 | 56 | 12 | |||
| 7361 | 101278 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2323 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5988461 | 2106418 | 37.7631567663104 | -122.483095878101 | (37.7631567663104, -122.483095878101) | 1 | 8 | 3 | 56 | 35 | |||
| 7410 | 181709 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3345 Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5985298.0363 | 2107014.13 | 37.7646090072485 | -122.4940792882 | (37.7646090072485, -122.4940792882) | 1 | 8 | 3 | 56 | 35 | |||
| 7480 | 180280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1204x Alemany Blvd | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.7300565721367 | -122.432867327564 | (37.7300565721367, -122.432867327564) | 9 | 7 | 6 | 28861 | 25 | |||
| 7504 | 73605 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 129 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994880.25496 | 2086485.81008 | 37.7087993338054 | -122.459450360941 | (37.7087993338054, -122.459450360941) | 9 | 8 | 6 | 28861 | 25 | |||
| 7732 | 198246 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Navy Rd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018108.95866 | 2093601.24715 | 37.7296452240452 | -122.379661929856 | (37.7296452240452, -122.379661929856) | 10 | 3 | 8 | 58 | 1 | |||
| 7891 | 218461 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 444 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996522.09527 | 2089877.4414 | 37.7182062325102 | -122.454020752669 | (37.7182062325102, -122.454020752669) | 9 | 8 | 6 | 28861 | 24 | |||
| 7925 | 241938 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 759X San Jose Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005755.81711 | 2098834.03435 | 37.7433241875597 | -122.422739827292 | (37.7433241875597, -122.422739827292) | 2 | 7 | 7 | 28859 | 2 | |||
| 8026 | 71384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1607 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015481.5732 | 2096159.9134 | 37.7365255368588 | -122.388923722935 | (37.7365255368588, -122.388923722935) | 10 | 3 | 8 | 58 | 1 | |||
| 8053 | 201871 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011880.2203 | 2112367.6476 | 37.7808281130031 | -122.40251455884 | (37.7808281130031, -122.40251455884) | 6 | 2 | 9 | 28856 | 34 | |||
| 8072 | 218709 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 505 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993385.55576 | 2101846.28179 | 37.7508893502708 | -122.465731455467 | (37.7508893502708, -122.465731455467) | 1 | 8 | 4 | 29491 | 40 | |||
| 8139 | 72882 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2610 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988659.6012 | 2097522.8498 | 37.7387446083711 | -122.481757414628 | (37.7387446083711, -122.481757414628) | 1 | 8 | 3 | 29491 | 35 | |||
| 8153 | 198101 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1272 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011939.76005 | 2102498.21472 | 37.7537321980948 | -122.401614703879 | (37.7537321980948, -122.401614703879) | 10 | 3 | 8 | 28856 | 29 | |||
| 8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 8231 | 258103 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4001 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5994656.53411 | 2112804.2386 | 37.7810502710743 | -122.462130924837 | (37.7810502710743, -122.462130924837) | 11 | 6 | 2 | 54 | 11 | |||||
| 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 | |||
| 8354 | 261712 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 31 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001602.2183 | 2091588.36368 | 37.7231940205575 | -122.436583359467 | (37.7231940205575, -122.436583359467) | 9 | 7 | 6 | 28861 | 25 | ||||
| 8359 | 241752 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1787 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004678.45402 | 2098526.06498 | 37.7424177294096 | -122.426443149152 | (37.7424177294096, -122.426443149152) | 2 | 7 | 5 | 63 | 22 | |||
| 8440 | 241789 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 28th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005121.67425 | 2099630.5033 | 37.7454753101483 | -122.424989187318 | (37.7454753101483, -122.424989187318) | 2 | 7 | 5 | 63 | 22 | |||
| 8488 | 255224 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011054.35236 | 2091069.46331 | 37.7223018348516 | -122.403872494592 | (37.7223018348516, -122.403872494592) | 10 | 3 | 7 | 309 | 28 | ||
| 8501 | 180126 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 810 Vienna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002202.71232 | 2088746.89227 | 37.7154260791221 | -122.434304523347 | (37.7154260791221, -122.434304523347) | 9 | 7 | 6 | 28861 | 5 | |||
| 8506 | 258378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x5 | 6007594.19766 | 2093376.79647 | 37.7284433601031 | -122.415996783146 | (37.7284433601031, -122.415996783146) | 9 | 3 | 7 | 309 | 5 | |||
| 8507 | 241890 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1499X Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008767.73316 | 2097659.36681 | 37.7402682831543 | -122.412242355811 | (37.7402682831543, -122.412242355811) | 10 | 7 | 7 | 28859 | 2 | |||
| 8581 | 84551 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 711 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987529.79137 | 2111085.31496 | 37.7759176835965 | -122.486659304996 | (37.7759176835965, -122.486659304996) | 11 | 6 | 2 | 55 | 26 | |||
| 8591 | 214937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993802.32185 | 2095722.84394 | 37.7340999600407 | -122.463845830728 | (37.7340999600407, -122.463845830728) | 9 | 8 | 4 | 59 | 40 | |||
| 8646 | 84388 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012568.10677 | 2099031.13024 | 37.7442473722189 | -122.399198367617 | (37.7442473722189, -122.399198367617) | 10 | 3 | 8 | 58 | 1 | |||
| 8648 | 241859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 172 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008276.29707 | 2097788.11072 | 37.7405941974677 | -122.413950655794 | (37.7405941974677, -122.413950655794) | 2 | 7 | 7 | 28859 | 2 | |||
| 8848 | 180194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 162 Tioga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6010134.95637 | 2089163.33615 | 37.7170165958166 | -122.406916365593 | (37.7170165958166, -122.406916365593) | 9 | 7 | 8 | 309 | 39 | ||||
| 8851 | 218714 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 80 Linares Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994120.79386 | 2102087.9404 | 37.7515952659274 | -122.463206485604 | (37.7515952659274, -122.463206485604) | 1 | 8 | 4 | 29491 | 40 | |||
| 8862 | 84382 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012627.48932 | 2098986.68874 | 37.7441286545312 | -122.398989915558 | (37.7441286545312, -122.398989915558) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 8903 | 241761 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 221 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005011.31625 | 2098990.66633 | 37.7437122297419 | -122.425325264849 | (37.7437122297419, -122.425325264849) | 2 | 7 | 5 | 63 | 22 | |||
| 8953 | 122019 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991358.36276 | 2110621.54717 | 37.7748667499589 | -122.473381582563 | (37.7748667499589, -122.473381582563) | 11 | 6 | 2 | 54 | 26 | |||
| 8991 | 241980 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007982.82344 | 2096512.87756 | 37.7370762006917 | -122.414875145383 | (37.7370762006917, -122.414875145383) | 2 | 7 | 7 | 28859 | 2 | |||
| 9054 | 73399 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010326.19468 | 2093255.95612 | 37.7282647808735 | -122.406543575948 | (37.7282647808735, -122.406543575948) | 10 | 3 | 7 | 309 | 28 | |||
| 9124 | 241979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4.5x9 | 6007964.49076 | 2096517.14345 | 37.7370868837581 | -122.414938831762 | (37.7370868837581, -122.414938831762) | 2 | 7 | 7 | 28859 | 2 | |||
| 9244 | 26780 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1752 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004614.5411634 | 2098679.9368788 | 37.7428366133046 | -122.426675095663 | (37.7428366133046, -122.426675095663) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 9304 | 245408 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1409 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6002586.1548 | 2101421.0875 | 37.7502482834875 | -122.433884566349 | (37.7502482834875, -122.433884566349) | 2 | 4 | 5 | 28862 | 22 | |||
| 9383 | 245841 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 340 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6005374.8248 | 2110307.1287 | 37.7748051060186 | -122.424873276976 | (37.7748051060186, -122.424873276976) | 7 | 9 | 11 | 28852 | 10 | |||
| 9543 | 241895 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008401.78654 | 2097688.83643 | 37.740328659141 | -122.413509740687 | (37.740328659141, -122.413509740687) | 2 | 7 | 7 | 28859 | 2 | |||
| 9563 | 236677 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000987.30849 | 2100905.52921 | 37.7487418231914 | -122.439376515339 | (37.7487418231914, -122.439376515339) | 2 | 4 | 5 | 28862 | 22 | |||
| 9572 | 242265 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 140 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004664.60969 | 2097568.35601 | 37.7397872960498 | -122.426422843352 | (37.7397872960498, -122.426422843352) | 2 | 7 | 5 | 63 | 7 | |||
| 9636 | 84385 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012596.88679 | 2099009.26073 | 37.7441889270701 | -122.399097317095 | (37.7441889270701, -122.399097317095) | 10 | 3 | 8 | 58 | 1 | |||
| 9650 | 71158 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 728 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009232.04509 | 2115488.13377 | 37.7892480238112 | -122.411896496347 | (37.7892480238112, -122.411896496347) | 5 | 1 | 10 | 28857 | 21 |
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) );