trees
7,322 rows where qSpecies_id = 1 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );