trees
194,517 rows sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4886 | 141434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 511 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005350.2266 | 2110949.2548 | 37.7765668387099 | -122.425004063889 | (37.7765668387099, -122.425004063889) | 7 | 9 | 11 | 28852 | 10 | |||
4920 | 12041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
4928 | 251750 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144 | 2086928 | 37.71048518025 | -122.430921281744 | (37.71048518025, -122.430921281744) | 9 | 7 | 6 | 28861 | 5 | ||
4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
4962 | 71085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 336 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000237.45691 | 2087069.9768 | 37.7107099003031 | -122.440977070243 | (37.7107099003031, -122.440977070243) | 9 | 7 | 6 | 28861 | 5 | |||
4987 | 84397 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012443.22283 | 2099122.96445 | 37.7444925687938 | -122.399636638738 | (37.7444925687938, -122.399636638738) | 10 | 3 | 8 | 58 | 1 | |||
4994 | 260596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 4x6 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 10 | 3 | 8 | 58 | 1 | |
4998 | 62129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 7 | Permit Number 22236 | 6001798.50341 | 2093490.78314 | 37.7284287857379 | -122.436040907355 | (37.7284287857379, -122.436040907355) | 9 | 7 | 6 | 28861 | 25 | |
5003 | 246147 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998476.2094 | 2108299.706 | 37.7689011658077 | -122.448592305739 | (37.7689011658077, -122.448592305739) | 15 | 5 | 11 | 29492 | 9 | |||
5020 | 183923 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2290 24th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988873.2152 | 2100272.077 | 37.7463056861858 | -122.481220108991 | (37.7463056861858, -122.481220108991) | 1 | 8 | 3 | 29491 | 35 | |||
5055 | 89478 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4120 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985848.51867 | 2111837.86338 | 37.7778858121287 | -122.492530613758 | (37.7778858121287, -122.492530613758) | 11 | 6 | 2 | 55 | 26 | ||
5072 | 26211 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005561.1813783 | 2098469.3096841 | 37.7423117528593 | -122.423386905565 | (37.7423117528593, -122.423386905565) | 2 | 7 | 5 | 28859 | 22 | |||
5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
5090 | 72166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2164 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5999887.26115 | 2120921.40259 | 37.8036376433293 | -122.444618885675 | (37.8036376433293, -122.444618885675) | 13 | 9 | 1 | 57 | 17 | |||
5092 | 31222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 566 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 7 | Permit Number 34909 | 6010818.5641 | 2118972.1322 | 37.7989031225504 | -122.406652925798 | (37.7989031225504, -122.406652925798) | 3 | 1 | 10 | 308 | 23 | |
5119 | 254683 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:28:00 PM | 3 | 3x3 | 5999858 | 2092352 | 37.7251915169836 | -122.442667568748 | (37.7251915169836, -122.442667568748) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
5200 | 163651 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 260 Sagamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2019 05:56:00 AM | 3 | 4x6 | 5994434.35916 | 2087472.87678 | 37.7114839386972 | -122.461062922717 | (37.7114839386972, -122.461062922717) | 9 | 8 | 6 | 28861 | 24 | ||
5201 | 261538 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 667 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981910 | 2111209 | 37.7759280729172 | -122.506108454702 | (37.7759280729172, -122.506108454702) | 11 | 6 | 2 | 55 | 26 | ||
5210 | 240637 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6005372.47745 | 2108674.6931 | 37.7703226996495 | -122.424765239935 | (37.7703226996495, -122.424765239935) | 8 | 2 | 5 | 28853 | 19 | ||
5247 | 17055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1285 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1991 12:00:00 AM | 12 | 3X3 | 6000835.008 | 2109621.9255 | 37.772666241387 | -122.440528248313 | (37.772666241387, -122.440528248313) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||||
5298 | 16892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 311 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2011 12:00:00 AM | 6 | 3X3 | 6005385.8444 | 2110257.3545 | 37.7746690605587 | -122.424831616025 | (37.7746690605587, -122.424831616025) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
5335 | 26050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 142 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 5995479.9938 | 2088097.6075 | 37.7132594193894 | -122.457494129816 | (37.7132594193894, -122.457494129816) | 9 | 8 | 6 | 28861 | 24 | ||
5339 | 146869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 751 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:08:00 PM | 3 | Width 3ft | 5983200.60356 | 2110688.67997 | 37.774575313945 | -122.501605492811 | (37.774575313945, -122.501605492811) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
5402 | 259405 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6013491.54198 | 2090383.23631 | 37.7205534514179 | -122.395399593578 | (37.7205534514179, -122.395399593578) | 10 | 3 | 8 | 58 | 1 | ||
5422 | 122567 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 777809 | 5994026.14526 | 2086558.74537 | 37.7089504501359 | -122.46240754496 | (37.7089504501359, -122.46240754496) | 9 | 8 | 6 | 28861 | 25 | |
5441 | 147494 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 503 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2019 12:00:00 AM | 3 | 4x6 | 5989673.74283 | 2111853.74948 | 37.7781523421991 | -122.479299133273 | (37.7781523421991, -122.479299133273) | 11 | 6 | 2 | 55 | 26 | |
5461 | 91099 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2009 12:00:00 AM | 5 | 3x3 | Permit Number 51989 | 6007027 | 2091471 | 37.7231785479974 | -122.417822583514 | (37.7231785479974, -122.417822583514) | 9 | 7 | 7 | 309 | 28 | |
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 | |||
5481 | 112239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:41:00 AM | 3 | 5999153.8915 | 2088963.97845 | 37.7158486246797 | -122.444858161098 | (37.7158486246797, -122.444858161098) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
5520 | 66956 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2253 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1992 12:00:00 AM | 18 | 4x4 | Permit Number 30287 | 6003206.54821 | 2116495.06774 | 37.7916729207242 | -122.432815936723 | (37.7916729207242, -122.432815936723) | 13 | 9 | 1 | 29490 | 27 | |
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 | ||
5558 | 38535 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4517 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
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 | |||
5598 | 62124 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/1985 12:00:00 AM | 12 | Permit Number 22230 | 6001290.71631 | 2092388.94515 | 37.7253745288844 | -122.437717468513 | (37.7253745288844, -122.437717468513) | 9 | 7 | 6 | 28861 | 25 | |
5603 | 36757 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39522 | 5993099.35503511 | 2104739.07158377 | 37.7588156897013 | -122.466931435386 | (37.7588156897013, -122.466931435386) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
5705 | 172247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002298.97974 | 2092038.38188 | 37.7244692398512 | -122.434206949586 | (37.7244692398512, -122.434206949586) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
5739 | 52729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2015 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/2006 12:00:00 AM | 5 | Permit Number 48785 | 6003207.48866 | 2119256.92944 | 37.7992563342625 | -122.433010091366 | (37.7992563342625, -122.433010091366) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
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 | ||
5765 | 112237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 10/27/2015 08:35:00 AM | 3 | 5999175.75859 | 2088985.62206 | 37.71590930104 | -122.444784133402 | (37.71590930104, -122.444784133402) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
5881 | 101267 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2230 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 06:01:00 PM | 3 | 3x3 | 5988779 | 2106526 | 37.7634718046826 | -122.482003947791 | (37.7634718046826, -122.482003947791) | 1 | 8 | 3 | 56 | 35 | ||
5890 | 65218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 345 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | Permit Number 28005 | 6002441.48783 | 2091581.27418 | 37.723222212016 | -122.433681664588 | (37.723222212016, -122.433681664588) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
5901 | 260465 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2019 12:00:00 AM | 3 | 3x4 | Permit Number 782033 | 6005003.24747 | 2095750.87761 | 37.7348160467336 | -122.425122689163 | (37.7348160467336, -122.425122689163) | 2 | 7 | 7 | 28861 | 2 | |
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 | |||
5973 | 89587 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4645 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984204.99021 | 2111721.97383 | 37.7774713817851 | -122.498207505516 | (37.7774713817851, -122.498207505516) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||||
5997 | 14446 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2012 12:00:00 AM | 3 | 3x3 | 5998938.7246 | 2112487.711 | 37.7804267900707 | -122.447293967252 | (37.7804267900707, -122.447293967252) | 15 | 5 | 1 | 54 | 16 | ||
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 | ||||
6095 | 261222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1890 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2020 12:00:00 AM | 3 | 5x5 | 5982931 | 2102276 | 37.751460650826 | -122.501915490969 | (37.751460650826, -122.501915490969) | 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 | |||
6240 | 113583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 466 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6001747.70462 | 2091066.77423 | 37.7217701198725 | -122.436043136802 | (37.7217701198725, -122.436043136802) | 9 | 7 | 6 | 28861 | 5 | ||
6254 | 60033 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 166 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 6 | Permit Number 19521 | 6014106.41368 | 2112395.33258 | 37.7810281600483 | -122.394814952371 | (37.7810281600483, -122.394814952371) | 6 | 2 | 9 | 28856 | 6 | |
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 | |||
6264 | 45045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2310 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2001 12:00:00 AM | 5 | 6x7.5 | Permit Number 43931 | 5988588.7333 | 2099576.402 | 37.7443790032439 | -122.482152844384 | (37.7443790032439, -122.482152844384) | 1 | 8 | 3 | 29491 | 35 |
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 | |||
6525 | 160467 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 674 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001006.228 | 2089897.25165 | 37.7185167225441 | -122.438522469629 | (37.7185167225441, -122.438522469629) | 9 | 7 | 6 | 28861 | 5 | ||
6539 | 160484 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001599.32466 | 2090089.5379 | 37.7190784175245 | -122.436486137419 | (37.7190784175245, -122.436486137419) | 9 | 7 | 6 | 28861 | 5 | ||
6566 | 160486 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001618.87365 | 2090077.82014 | 37.719047354019 | -122.436417726014 | (37.719047354019, -122.436417726014) | 9 | 7 | 6 | 28861 | 5 | ||
6573 | 262162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | ||
6616 | 116997 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 ROSEMONT PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778206 | 6005158 | 2108058 | 37.7686172926755 | -122.425463223206 | (37.7686172926755, -122.425463223206) | 8 | 4 | 5 | 28853 | 19 | |
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 | ||||||||||||||
6672 | 39412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 1 | 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 | |||
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 | |||
6707 | 15866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5425 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999452.41338 | 2088067.62767 | 37.7134044805159 | -122.443761975638 | (37.7134044805159, -122.443761975638) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
6711 | 62157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2158 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22272 | 5999899.60106 | 2120922.78087 | 37.8036421318499 | -122.444576282063 | (37.8036421318499, -122.444576282063) | 13 | 9 | 1 | 57 | 17 | |
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 | ||||
6757 | 121102 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 266 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | 3x3 | 6004508.59639 | 2090893.04337 | 37.7214495565251 | -122.426487084614 | (37.7214495565251, -122.426487084614) | 9 | 7 | 6 | 28861 | 5 | ||
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 |
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) );