Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 114637 | 114637 | 106120 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 6x9 | 5992954.7 | 2110649.6 | 37.775036084258794 | -122.46786160539301 | (37.7750360842588, -122.467861605393) | |||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 54631 | 54631 | 25675 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 80770 | 80770 | 27817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 80801 | 80801 | 27819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 81888 | 81888 | 27821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 82200 | 82200 | 25676 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 82580 | 82580 | 28021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.796464038519396 | -122.39529961933201 | (37.7964640385194, -122.395299619332) | ||
| 86704 | 86704 | 27813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 89465 | 89465 | 114506 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 LOMBARD ST | 1 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 90715 | 90715 | 27823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 92114 | 92114 | 27805 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 350X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 11/15/2012 12:00:00 AM | 12 | 4x4 | Permit Number 769363 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | |
| 92971 | 92971 | 28023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | ||
| 95176 | 95176 | 121470 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 120X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 8 | 4x4 | 6015452.0 | 2116243.0 | 37.7916677028969 | -122.39042878384599 | (37.7916677028969, -122.390428783846) | |||
| 101771 | 101771 | 27820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 102002 | 102002 | 27810 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 103466 | 103466 | 27818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 108010 | 108010 | 27815 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 108569 | 108569 | 27811 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 109917 | 109917 | 27824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 111309 | 111309 | 27812 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 111973 | 111973 | 27825 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 117459 | 117459 | 27809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 118471 | 118471 | 27816 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 118721 | 118721 | 27822 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 122275 | 122275 | 27806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 123623 | 123623 | 27814 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 125405 | 125405 | 114508 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 LOMBARD ST | 3 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 126269 | 126269 | 27807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 128727 | 128727 | 25674 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 144540 | 144540 | 27808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 1899 | 1899 | 25838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013225.308119999 | 2119220.74162 | 37.7997201038678 | -122.39834219506099 | (37.7997201038678, -122.398342195061) | ||
| 2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
| 2090 | 2090 | 25842 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013279.137069999 | 2119139.97441 | 37.799501334781795 | -122.398150256355 | (37.7995013347818, -122.398150256355) | ||
| 3114 | 3114 | 25811 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012315.257619999 | 2120560.3270799997 | 37.8033475454092 | -122.401585526252 | (37.8033475454092, -122.401585526252) | ||
| 3657 | 3657 | 25806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012234.78854 | 2120695.21971 | 37.8037134372885 | -122.401873481994 | (37.8037134372885, -122.401873481994) | ||
| 4198 | 4198 | 25837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013209.63865 | 2119244.79078 | 37.7997852642353 | -122.39839810591299 | (37.7997852642353, -122.398398105913) | ||
| 4885 | 4885 | 25808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012265.91209 | 2120646.37252 | 37.803581051681704 | -122.401762341075 | (37.8035810516817, -122.401762341075) | ||
| 4943 | 4943 | 25845 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013327.75405 | 2119068.43707 | 37.799307618121 | -122.397977001961 | (37.799307618121, -122.397977001961) | ||
| 5467 | 5467 | 27939 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013788.66429 | 2118525.16075 | 37.7978415693921 | -122.396343981507 | (37.7978415693921, -122.396343981507) | |||
| 5672 | 5672 | 25807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012251.480269999 | 2120666.53325 | 37.8036356027669 | -122.40181370136801 | (37.8036356027669, -122.401813701368) | ||
| 5709 | 5709 | 25839 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013239.738969999 | 2119198.12663 | 37.799658812366204 | -122.398290671092 | (37.7996588123662, -122.398290671092) | ||
| 5784 | 5784 | 25812 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012332.091990001 | 2120538.6639799997 | 37.803289003136 | -122.401525746517 | (37.803289003136, -122.401525746517) | ||
| 5815 | 5815 | 25809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012278.63673 | 2120626.00413 | 37.8035258351232 | -122.40171687406 | (37.8035258351232, -122.40171687406) | ||
| 6610 | 6610 | 25631 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.621619999 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | ||
| 6770 | 6770 | 25843 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013291.71436 | 2119122.7738 | 37.7994548065492 | -122.39810552676902 | (37.7994548065492, -122.398105526769) | ||
| 7009 | 7009 | 27938 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013758.52527 | 2118508.2804400004 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | |||
| 7283 | 7283 | 25805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012220.3272400005 | 2120713.92747 | 37.803763997176794 | -122.401924842279 | (37.8037639971768, -122.401924842279) | ||
| 7619 | 7619 | 25841 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013268.0055599995 | 2119155.84179 | 37.799544282796205 | -122.398189889456 | (37.7995442827962, -122.398189889456) | ||
| 7632 | 7632 | 25840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013252.78025 | 2119179.61334 | 37.7996087057277 | -122.39824424358999 | (37.7996087057277, -122.39824424359) | ||
| 8064 | 8064 | 25629 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014059.75449 | 2117949.14567 | 37.79627504929729 | -122.39536555327801 | (37.7962750492973, -122.395365553278) | ||
| 8292 | 8292 | 25844 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013309.3136 | 2119095.04373 | 37.7993796466195 | -122.398042680326 | (37.7993796466195, -122.398042680326) | ||
| 8337 | 8337 | 25810 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012292.79565 | 2120604.39505 | 37.803467291949204 | -122.401666356441 | (37.8034672919492, -122.401666356441) | ||
| 8404 | 8404 | 25630 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014084.49775 | 2117912.38554 | 37.7961754907607 | -122.395277359473 | (37.7961754907607, -122.395277359473) | ||
| 8734 | 8734 | 25813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012345.50187 | 2120516.10099 | 37.8032277988787 | -122.401477754221 | (37.8032277988787, -122.401477754221) | ||
| 8788 | 8788 | 27937 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013847.17816 | 2118440.8928400003 | 37.797613445554205 | -122.396135596873 | (37.7976134455542, -122.396135596873) | |||
| 20295 | 20295 | 25849 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415002 | 37.8022785256437 | -122.40010024450399 | (37.8022785256437, -122.400100244504) | ||
| 76348 | 76348 | 27944 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | |||
| 77301 | 77301 | 27984 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 77648 | 77648 | 25821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 77877 | 77877 | 28025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.796072794607895 | -122.39497787369301 | (37.7960727946079, -122.394977873693) | ||
| 78636 | 78636 | 28030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.8700099997 | 37.795577730351205 | -122.39443938464899 | (37.7955777303512, -122.394439384649) | ||
| 78967 | 78967 | 25865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012565.65701 | 2120204.63501 | 37.8023848701418 | -122.400694001959 | (37.8023848701418, -122.400694001959) | ||
| 79049 | 79049 | 27992 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 79277 | 79277 | 15089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 80608 | 80608 | 25651 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 80951 | 80951 | 25637 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 81058 | 81058 | 25655 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 81297 | 81297 | 28024 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.300009999 | 2117911.2250099997 | 37.7961756855245 | -122.39506688844999 | (37.7961756855245, -122.39506688845) | ||
| 82042 | 82042 | 27988 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 83033 | 83033 | 27803 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4X4 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 83420 | 83420 | 27948 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 83494 | 83494 | 27972 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 83992 | 83992 | 25626 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015143.78201 | 2116618.69801 | 37.7926821803134 | -122.391521501856 | (37.7926821803134, -122.391521501856) | ||
| 84193 | 84193 | 25858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012435.4480099995 | 2120409.0630099997 | 37.802938916816295 | -122.40115896506201 | (37.8029389168163, -122.401158965062) | ||
| 84408 | 84408 | 25895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 84990 | 84990 | 27964 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 85025 | 85025 | 25615 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014865.13601 | 2116922.0830099997 | 37.793499734993894 | -122.39250686670401 | (37.7934997349939, -122.392506866704) | ||
| 85161 | 85161 | 27995 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 85287 | 85287 | 25623 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015040.91701 | 2116748.90601 | 37.793033991285796 | -122.391886530718 | (37.7930339912858, -122.391886530718) | ||
| 85455 | 85455 | 25653 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 86119 | 86119 | 25861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012509.66701 | 2120295.78101 | 37.802632012073204 | -122.400894163602 | (37.8026320120732, -122.400894163602) | ||
| 86353 | 86353 | 25848 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012397.68801 | 2120467.65601 | 37.803097692384604 | -122.401293754953 | (37.8030976923846, -122.401293754953) | ||
| 86476 | 86476 | 27965 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 86722 | 86722 | 25901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 86828 | 86828 | 25818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 87440 | 87440 | 25866 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012586.49001 | 2120179.89601 | 37.8023181047385 | -122.400620170198 | (37.8023181047385, -122.400620170198) | ||
| 87777 | 87777 | 25847 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012388.5730099995 | 2120483.28101 | 37.803140086302705 | -122.401326396519 | (37.8031400863027, -122.401326396519) | ||
| 88104 | 88104 | 25650 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 89908 | 89908 | 27997 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 90157 | 90157 | 25660 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90272 | 90272 | 25652 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90808 | 90808 | 25618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014901.59401 | 2116884.32301 | 37.7933980793798 | -122.392378075877 | (37.7933980793798, -122.392378075877) | ||
| 90852 | 90852 | 25860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012500.55201 | 2120312.7080099997 | 37.8026779810822 | -122.400926896266 | (37.8026779810822, -122.400926896266) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");