Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1506 | 1506 | 3068 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2848 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000738.310819999 | 2115229.75603 | 37.788058406004296 | -122.441265170758 | (37.7880584060043, -122.441265170758) | |||
1575 | 1575 | 246375 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003217.3444 | 2106843.7794 | 37.765173499092995 | -122.43208906900499 | (37.765173499093, -122.432089069005) | |||
1576 | 1576 | 246374 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6003241.3918 | 2106872.8368 | 37.765254647007296 | -122.432007970015 | (37.7652546470073, -122.432007970015) | |||
1584 | 1584 | 3173 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3506 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 6 | 3X3 | 5997608.68374 | 2114790.70836 | 37.786674124564 | -122.45206138623301 | (37.786674124564, -122.452061386233) | ||
1586 | 1586 | 98725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006216.75471 | 2111460.37935 | 37.7780191723707 | -122.42204280683501 | (37.7780191723707, -122.422042806835) | |||
1588 | 1588 | 246373 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6003269.4472 | 2106896.8842 | 37.7653222658326 | -122.431912650355 | (37.7653222658326, -122.431912650355) | |||
1596 | 1596 | 14066 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007645.4688 | 2111067.7331 | 37.7770215357502 | -122.41707253353701 | (37.7770215357502, -122.417072533537) | |||
1612 | 1612 | 13833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 970 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6009828.1026 | 2113177.7906 | 37.782937796191504 | -122.40967106357901 | (37.7829377961915, -122.409671063579) | |||
1655 | 1655 | 13618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 554 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x4 | 6012397.92719 | 2115620.9372799997 | 37.7897897754213 | -122.400952192186 | (37.7897897754213, -122.400952192186) | |||
1664 | 1664 | 26404 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996581.1026099995 | 2115987.02812 | 37.7898999837554 | -122.455703055979 | (37.7898999837554, -122.455703055979) | |||
1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
1671 | 1671 | 13627 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 570 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6012289.31562 | 2115520.12346 | 37.789506905374395 | -122.401320892642 | (37.7895069053744, -122.401320892642) | |||
1676 | 1676 | 23357 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2017 12:00:00 AM | 3 | 3X3 | 6006405.911169999 | 2115051.67043 | 37.78789064557179 | -122.4216435834 | (37.7878906455718, -122.4216435834) | ||
1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
1692 | 1692 | 2957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2045 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004590.8896 | 2115694.3359 | 37.7895527302687 | -122.427969040021 | (37.7895527302687, -122.427969040021) | |||
1721 | 1721 | 23308 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | 5 | 3X3 | 6006538.20918 | 2114040.94612 | 37.785122904641796 | -122.42111406077 | (37.7851229046418, -122.42111406077) | ||
1732 | 1732 | 134349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1733 | 1733 | 200858 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
1738 | 1738 | 13966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
1740 | 1740 | 200859 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
1741 | 1741 | 28362 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 6 | 4x4 | 6005809.8912 | 2098114.7936 | 37.7413523657119 | -122.422501756572 | (37.7413523657119, -122.422501756572) | ||
1743 | 1743 | 200855 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008978.4093 | 2112218.7143 | 37.7802567505844 | -122.412542843301 | (37.7802567505844, -122.412542843301) | |||
1753 | 1753 | 134350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1754 | 1754 | 245399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3467 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6005818.4513 | 2098127.8856 | 37.7413887962973 | -122.42247308874201 | (37.7413887962973, -122.422473088742) | |||
1755 | 1755 | 13965 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1127 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008823.0 | 2112045.0 | 37.7797710494845 | -122.413068191044 | (37.7797710494845, -122.413068191044) | |||
1756 | 1756 | 13756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1761 | 1761 | 200862 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6008817.7245 | 2112082.7382 | 37.7798743734467 | -122.41308911055201 | (37.7798743734467, -122.413089110552) | |||
1762 | 1762 | 200860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008794.0112 | 2112059.0249 | 37.779807931141 | -122.413169468366 | (37.779807931141, -122.413169468366) | |||
1763 | 1763 | 200861 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6008800.2278 | 2112051.2202 | 37.7797868502892 | -122.41314741030199 | (37.7797868502892, -122.413147410302) | |||
1774 | 1774 | 3070 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2860 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000658.3248 | 2115217.6526099998 | 37.788020616507104 | -122.44154103868799 | (37.7880206165071, -122.441541038688) | |||
1831 | 1831 | 28370 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 2X3 | 6001320.7065 | 2112568.2554 | 37.780783765197604 | -122.43905936736999 | (37.7807837651976, -122.43905936737) | ||
1847 | 1847 | 23549 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2835 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6005591.52339 | 2120155.8854900002 | 37.8018595757201 | -122.424824487257 | (37.8018595757201, -122.424824487257) | ||
1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
1890 | 1890 | 245384 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3243 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2005 12:00:00 AM | 5 | Width 0ft | 6006512.1787 | 2099413.785 | 37.7449586977694 | -122.420165655704 | (37.7449586977694, -122.420165655704) | ||
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) | ||
1901 | 1901 | 23857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003664.511 | 2113605.5032 | 37.7837648703142 | -122.431025065183 | (37.7837648703142, -122.431025065183) | |||
1914 | 1914 | 99186 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1961 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:44:00 AM | 3 | 3x3 | 6005002.72434 | 2115722.82694 | 37.7896542499749 | -122.426546164276 | (37.7896542499749, -122.426546164276) | ||
1925 | 1925 | 2958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004523.0139999995 | 2115687.6045 | 37.7895304073237 | -122.428203402517 | (37.7895304073237, -122.428203402517) | |||
1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
1964 | 1964 | 238618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 14 | Width 4ft | 6001078.53558 | 2101746.02342 | 37.751054810249 | -122.439121284114 | (37.751054810249, -122.439121284114) | |||
1974 | 1974 | 238616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.43874669133301 | (37.7510729252903, -122.438746691333) | |||
1975 | 1975 | 238619 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001066.93276 | 2101745.60422 | 37.7510529990026 | -122.43916137771099 | (37.7510529990026, -122.439161377711) | |||
1989 | 1989 | 133618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999272.2292 | 2119684.41545 | 37.8002060956892 | -122.446658172159 | (37.8002060956892, -122.446658172159) | |||
2024 | 2024 | 139198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | Width 0ft | 6001803.3539 | 2113704.6103 | 37.783931357581395 | -122.437471057097 | (37.7839313575814, -122.437471057097) | |||
2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
2041 | 2041 | 13773 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 870 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 6010487.82969 | 2113786.8175 | 37.7846469870112 | -122.407431620471 | (37.7846469870112, -122.407431620471) | |||
2048 | 2048 | 143400 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | 6008592.8234 | 2111992.2193 | 37.779613202213994 | -122.41386074083401 | (37.779613202214, -122.413860740834) | |||
2051 | 2051 | 3179 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3560 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X2 | 5997388.758280001 | 2114760.01365 | 37.7865772450958 | -122.45282005522101 | (37.7865772450958, -122.452820055221) | |||
2064 | 2064 | 23285 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 850 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006625.13758 | 2113482.84587 | 37.783595398064996 | -122.42077367996401 | (37.783595398065, -122.420773679964) | |||
2070 | 2070 | 109552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006854.31545 | 2111807.2543900004 | 37.7790075453087 | -122.419861872643 | (37.7790075453087, -122.419861872643) | |||
2087 | 2087 | 252878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | |||
2088 | 2088 | 3013 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002627.84431 | 2115492.11411 | 37.7888862283618 | -122.43474649336599 | (37.7888862283618, -122.434746493366) | |||
2089 | 2089 | 195741 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 4ft | 6014483.0 | 2111149.0 | 37.7776269440566 | -122.39342489592899 | (37.7776269440566, -122.393424895929) | |||
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) | ||
2096 | 2096 | 200850 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6007584.0 | 2110630.0 | 37.77581616716321 | -122.417254147161 | (37.7758161671632, -122.417254147161) | |||
2101 | 2101 | 143399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008612.8747 | 2111976.4646 | 37.779571069624 | -122.413790259796 | (37.779571069624, -122.413790259796) | |||
2104 | 2104 | 140318 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1170 MARKET ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6008545.5594 | 2111947.8198 | 37.779488637316206 | -122.414021106074 | (37.7794886373162, -122.414021106074) | |||
2108 | 2108 | 98580 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 370 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2017 12:00:00 AM | 3 | 3x3 | 6013585.68076 | 2118314.1263900003 | 37.7972508218322 | -122.397031561762 | (37.7972508218322, -122.397031561762) | ||
2112 | 2112 | 13981 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008866.9651 | 2112266.4261 | 37.7803815007944 | -122.412931755866 | (37.7803815007944, -122.412931755866) | |||
2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
2131 | 2131 | 2996 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6003308.145280001 | 2115585.18188 | 37.7891803678189 | -122.43239939681801 | (37.7891803678189, -122.432399396818) | |||
2167 | 2167 | 3158 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3410 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998012.98689 | 2114846.6357400003 | 37.7868508368504 | -122.45066663485201 | (37.7868508368504, -122.450666634852) | |||
2203 | 2203 | 8461 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1877 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002698.7987 | 2113699.0733 | 37.7839670221208 | -122.43437275514 | (37.7839670221208, -122.43437275514) | |||
2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
2251 | 2251 | 13985 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
2254 | 2254 | 13986 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | |||
2285 | 2285 | 2664 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2018 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003759.2529 | 2114943.4782 | 37.78744398103571 | -122.430792808025 | (37.7874439810357, -122.430792808025) | |||
2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
2306 | 2306 | 195019 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013637.791730001 | 2113971.74755 | 37.785330566207705 | -122.396546695873 | (37.7853305662077, -122.396546695873) | |||
2315 | 2315 | 195022 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013709.75083 | 2113894.09551 | 37.785121356022394 | -122.39629229296001 | (37.7851213560224, -122.39629229296) | |||
2320 | 2320 | 1739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | |||
2330 | 2330 | 6147 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 939 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6006318.99495 | 2113507.73043 | 37.7836464651567 | -122.42183458592 | (37.7836464651567, -122.42183458592) | |||
2335 | 2335 | 195021 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6013679.6407 | 2113928.34961 | 37.7852137343684 | -122.396398867136 | (37.7852137343684, -122.396398867136) | |||
2336 | 2336 | 195020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013662.142659999 | 2113947.50545 | 37.785265358143896 | -122.39646074858601 | (37.7852653581439, -122.396460748586) | |||
2340 | 2340 | 13486 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013525.0360199995 | 2116684.5106599997 | 37.7927729057886 | -122.39712708324801 | (37.7927729057886, -122.397127083248) | |||
2342 | 2342 | 3126 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998843.08615 | 2114964.7899700003 | 37.787222737075 | -122.447803205161 | (37.787222737075, -122.447803205161) | |||
2343 | 2343 | 195028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013774.91802 | 2113824.49769 | 37.7849338824287 | -122.396061954106 | (37.7849338824287, -122.396061954106) | |||
2347 | 2347 | 195023 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013717.57682 | 2113887.99977 | 37.785105053996396 | -122.396264789902 | (37.7851050539964, -122.396264789902) | |||
2352 | 2352 | 195026 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013748.5801800005 | 2113848.78027 | 37.7849990913834 | -122.39615477762301 | (37.7849990913834, -122.396154777623) | |||
2355 | 2355 | 195025 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013739.901380001 | 2113861.81988 | 37.7850344122501 | -122.396185717917 | (37.7850344122501, -122.396185717917) | |||
2358 | 2358 | 195024 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013723.336209999 | 2113877.98804 | 37.785077884566604 | -122.39624416214 | (37.7850778845666, -122.39624416214) | |||
2359 | 2359 | 195027 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013762.26581 | 2113837.6181400004 | 37.784969204212295 | -122.396106646824 | (37.7849692042123, -122.396106646824) | |||
2363 | 2363 | 3048 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2698 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001512.20185 | 2115337.69882 | 37.788398842590496 | -122.438595386662 | (37.7883988425905, -122.438595386662) | |||
2388 | 2388 | 12913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | |||
2468 | 2468 | 2848 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1275 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008247.47804 | 2116208.39434 | 37.7911703975462 | -122.415354000191 | (37.7911703975462, -122.415354000191) | |||
2556 | 2556 | 10689 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1230 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001934.2005 | 2110513.7359 | 37.775177459697396 | -122.436789881705 | (37.7751774596974, -122.436789881705) | |||
2622 | 2622 | 238126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2017 02:38:00 PM | 3 | Width 3ft | 6006363.87344 | 2106134.73006 | 37.7634045065344 | -122.421155613935 | (37.7634045065344, -122.421155613935) | ||
2635 | 2635 | 13840 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 974 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6009780.9039 | 2113133.8849 | 37.78281459658329 | -122.40983125198 | (37.7828145965833, -122.40983125198) | |||
2655 | 2655 | 5870 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010X Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005526.7803 | 2113108.4242 | 37.782505360766294 | -122.42454693631599 | (37.7825053607663, -122.424546936316) | |||
2686 | 2686 | 234760 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 252 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004468.902369999 | 2109137.1444099997 | 37.77154140335671 | -122.427923663451 | (37.7715414033567, -122.427923663451) | |||
2690 | 2690 | 126183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003793.92894 | 2120715.46368 | 37.803294337014606 | -122.431084963893 | (37.8032943370146, -122.431084963893) | |||
2730 | 2730 | 7762 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006322.26322 | 2111614.07343 | 37.7784471291735 | -122.421688733864 | (37.7784471291735, -122.421688733864) | |||
2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2810 | 2810 | 23452 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2209 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005880.951090001 | 2118079.82441 | 37.796175582497504 | -122.423675237326 | (37.7961755824975, -122.423675237326) |
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");