7,322 rows where qSpecies_id = 1 sorted by qCareAssistant

View and edit SQL

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)
3459 84116 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1325 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 4 3x3 Permit Number 50709 6008644.30779 2087548.3519 37.712498659051 -122.411954776917 (37.712498659051, -122.411954776917) 9 7 8 309 39
3521 1361 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 14 Amethyst Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/29/2016 12:00:00 AM 3 3X3   5999192.9019 2100038.70061 37.7462594407353 -122.445519216737 (37.7462594407353, -122.445519216737) 2 7 5 63 22
3540 198190 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3308 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6013400.76782 2089956.39224 37.7193763737002 -122.395683481624 (37.7193763737002, -122.395683481624) 10 3 8 58 1
3555 89502 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4524 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2008 12:00:00 AM 3 3x3   5984585.23275 2111791.9106 37.7776856960653 -122.49689730367 (37.7776856960653, -122.49689730367) 11 6 2 55 26
3579 119169 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 720 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 3ft   5980759.87673 2110793.19365 37.7747186206505 -122.510056058609 (37.7747186206505, -122.510056058609) 11 6 2 55 26
3593 89474 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4100 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2008 12:00:00 AM 3 3x3   5985926.00184 2111839.74307 37.7778955032139 -122.492262714551 (37.7778955032139, -122.492262714551) 11 6 2 55 26
3618 122859 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3000X Alemany Blvd 6 Median : Cutout Tree DPW 1   12/08/2016 01:46:00 PM 3 3x3   5996503.07173 2087192.19332 37.7108320750073 -122.453892694613 (37.7108320750073, -122.453892694613) 9 7 6 28861 25
3641 180394 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 226 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010059.9605 2093475.56512 37.7288528826511 -122.407479439226 (37.7288528826511, -122.407479439226) 10 3 7 309 28
3718 85909 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2234 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/20/2006 12:00:00 AM 3 3x3   5988258.4084 2100094.7734 37.745783095491 -122.483333016616 (37.745783095491, -122.483333016616) 1 8 3 29491 35
3728 264799 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 698 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009708 2091117 37.7223570514359 -122.408529889307 (37.7223570514359, -122.408529889307) 10 3 7 309 28
3818 241714 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 203 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009414.51061 2099152.92422 37.7444055368928 -122.410111466171 (37.7444055368928, -122.410111466171) 2 7 7 28859 2
3824 252901 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 598 Mount Vernon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
3843 25432 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2436 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/1998 12:00:00 AM 3 3X3   6010891.05193 2086887.18096 37.7108090136865 -122.404142791654 (37.7108090136865, -122.404142791654) 9 7 8 309 39
3957 101709 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 95X Milton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003767.7 2095277.7 37.7334469335284 -122.429360672359 (37.7334469335284, -122.429360672359) 2 7 5 28861 25
3960 28454 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2160X Ocean Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/2003 12:00:00 AM 3 3X3   5993123.43173 2093088.843 37.7268284984876 -122.466001612774 (37.7268284984876, -122.466001612774) 9 8 4 59 40
4009 54330 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1257 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2012 12:00:00 AM     Permit Number 769330 5994831.50805386 2106979.48216267 37.7650671008227 -122.461103283683 (37.7650671008227, -122.461103283683) 15 5 11 56 12
4039 101850 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1001X Rhode Island St 4 Sidewalk: Property side : Cutout Tree Private 2   12/31/2015 12:00:00 AM 2 3x3 Permit Number 774983 6011937.4679 2103668.00433 37.7569440557359 -122.401704847401 (37.7569440557359, -122.401704847401) 10 3 8 28856 29
4077 102546 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015961.34604 2107137.76144 37.7666949900978 -122.388030764508 (37.7666949900978, -122.388030764508) 14 3 9 310 20
4098 242321 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 99x San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2019 12:00:00 AM 3 4x4 Permit Number 776221 6006210.72103 2102654.46682 37.7538398793324 -122.421438144967 (37.7538398793324, -122.421438144967) 2 4 5 28859 19
4130 92248 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1475 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2009 12:00:00 AM 2 3x3 Permit Number 52695 5985867.8936 2105206.8448 37.759680032266 -122.491975261997 (37.759680032266, -122.491975261997) 1 8 3 56 35
4232 264908 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
4287 85892 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2450 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/20/2006 12:00:00 AM 3 3x3   5988312.1108 2098619.8624 37.7417365040241 -122.483039240723 (37.7417365040241, -122.483039240723) 1 8 3 29491 35
4314 261587 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2700x San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5997075 2088509 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306) 9 8 6 28861 24
4334 136909 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2210 Stockton St 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 Width 3ft   6009830.0684 2121639.18274 37.8061708284786 -122.410261867902 (37.8061708284786, -122.410261867902) 3 1 10 308 23
4368 262109 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 340 Oak St 10 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6005374.8248 2110307.1287 37.7748051060186 -122.424873276976 (37.7748051060186, -122.424873276976) 7 9 11 28852 10
4386 24695 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 7001 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2016 12:40:00 PM 3 3X3   5985279 2112414 37.7794344025529 -122.494543232684 (37.7794344025529, -122.494543232684) 11 6 2 55 26
4422 183782 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2295 32nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2020 12:00:00 AM 3 5x5   5986367.7435 2099662.7006 37.7444865241588 -122.489838803613 (37.7444865241588, -122.489838803613) 1 8 3 29491 35
4454 128029 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2601 Jones St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 Width 4ft   6007868.73718 2121431.95 37.8054916838703 -122.417034709883 (37.8054916838703, -122.417034709883) 5 1 10 308 23
4458 37157 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 88 29th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1998 12:00:00 AM     Permit Number 39737 6005841.01788139 2099087.47125623 37.7440248746354 -122.422463228878 (37.7440248746354, -122.422463228878) 2 7 5 28859 2
4461 241779 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 437 Day St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6003106.73216 2098596.88668 37.7425232153888 -122.431882743495 (37.7425232153888, -122.431882743495) 2 7 5 63 22
4464 241896 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1201X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008351.5522 2097694.26148 37.7403407343459 -122.413683815267 (37.7403407343459, -122.413683815267) 2 7 7 28859 2
4529 160228 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 960 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001238.61931 2088721.92434 37.7153027532862 -122.437635063623 (37.7153027532862, -122.437635063623) 9 7 6 28861 5
4534 17065 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1345 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/1991 12:00:00 AM 6 3X3   6000565.7799 2109579.8794 37.7725354591824 -122.441456517022 (37.7725354591824, -122.441456517022) 15 5 11 29492 9
4605 85901 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2282 26th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/20/2006 12:00:00 AM 3 3x3   5988268.6501 2099782.4008 37.7449259990071 -122.483274709024 (37.7449259990071, -122.483274709024) 1 8 3 29491 35
4620 115387 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 34 Madrone Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x8   5992895.1 2098893.2 37.7427526388588 -122.467212790357 (37.7427526388588, -122.467212790357) 1 8 4 59 40
4695 241522 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4281 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000663.46972 2102849.2053 37.7540602545824 -122.440635739769 (37.7540602545824, -122.440635739769) 2 4 5 28862 22
4712 39418 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401Bldg #8 Page St 2 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
4714 138839 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 680 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004061.0808 2111069.2221 37.7768233350725 -122.429472148942 (37.7768233350725, -122.429472148942) 7 9 11 28852 10
4837 115185 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2300X Alemany Blvd 2 Median : Cutout Tree DPW 1     3     5999482.43288 2089277.31598 37.716727722789 -122.443745071105 (37.716727722789, -122.443745071105) 9 7 6 28861 25
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);