Street_Tree_List

Data source: data.sfgov.org

357 rows where qSpecies = 31

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
76 241180 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 3 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767)
82 241178 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 1 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.3896699995 2108410.1055900003 37.769563595403106 -122.42674254153299 (37.7695635954031, -122.426742541533)
90 241179 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 2 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481)
91 241181 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 4 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.3052900005 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397)
3525 253489 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3532 253483 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3533 253491 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3538 253485 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3546 253495 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3553 253492 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3554 253490 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3555 253487 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3562 253488 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3563 253493 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3573 253496 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3581 253486 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3582 253484 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3587 253494 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
6292 87392 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3322 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
6671 87391 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3322 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.43605331890801 (37.800247665053, -122.436053318908)
7036 16366 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 1306X Montgomery St 9 Median : Cutout 11 Tree 1 DPW 2     8 8   6011454.042780001 2119896.37482 37.8014764015683 -122.40451904281299 (37.8014764015683, -122.404519042813)
13285 187639 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1671 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/22/2017 12:00:00 AM 3 3x6   5985585.0 2103854.0 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295)
15504 49998 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1101X 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014225.48172 2105233.1729900003 37.7613690835438 -122.39390153433901 (37.7613690835438, -122.393901534339)
17013 16027 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 160 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2005 12:00:00 AM 3 3X3   6001078.56062 2094701.12537 37.7317111799206 -122.43861646769899 (37.7317111799206, -122.438616467699)
18197 34055 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 375 Alabama St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
18492 63236 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3634 20th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1 FUF 1 01/13/1987 12:00:00 AM 12   Permit Number 23784 6006063.67565171 2104362.69748074 37.7585219924343 -122.422068008351 (37.7585219924343, -122.422068008351)
18713 34080 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 240 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
19051 582 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 3013 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/23/1992 12:00:00 AM 12 3x3   6008818.92095 2102127.6459 37.7525400594852 -122.41238111940099 (37.7525400594852, -122.412381119401)
19758 4166 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 3771 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/18/1999 12:00:00 AM 3 3X3   6005390.77926 2100476.4482400003 37.747813278574 -122.424118813557 (37.747813278574, -122.424118813557)
21324 621 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 3151 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/23/1992 12:00:00 AM 18 3X3   6007979.07595 2102079.2423799997 37.7523599891254 -122.41528202924101 (37.7523599891254, -122.415282029241)
23598 179958 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6011915.65824 2087516.33041 37.7125937299935 -122.40064566366999 (37.7125937299935, -122.40064566367)
24481 117708 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4001 Clement St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5983029.04687 2113077.7485700003 37.7811249212832 -122.50237578006501 (37.7811249212832, -122.502375780065)
24952 34654 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2000 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505)
25124 241190 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2858 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010222.306919999 2101664.86224 37.7513480117 -122.407495323966 (37.7513480117, -122.407495323966)
26649 49071 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
26722 136742 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000053.33945 2118542.13589 37.79711428765071 -122.443873120143 (37.7971142876507, -122.443873120143)
27219 215426 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
27397 241185 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3781 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
27769 215436 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 670 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5996989.65534 2095298.72051 37.7331185802561 -122.452795679095 (37.7331185802561, -122.452795679095)
27899 136747 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2859 Filbert St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5999233.55999 2118349.36625 37.796538199022606 -122.446695870812 (37.7965381990226, -122.446695870812)
28207 179962 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 299 Lathrop Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6012155.6977 2086855.9290099998 37.710793783685006 -122.39976966465599 (37.710793783685, -122.399769664656)
28350 215435 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 271 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5999640.40097 2095213.2119999998 37.7330353327146 -122.443625232838 (37.7330353327146, -122.443625232838)
28815 182351 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1501 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5985257.4301 2104935.3862 37.758898980602005 -122.49406651392 (37.758898980602, -122.49406651392)
29244 215411 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1939 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5991245.12391 2102202.13663 37.7517427376545 -122.473159145982 (37.7517427376545, -122.473159145982)
29943 83166 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1089 Gilman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52361 6015096.6014 2089812.1317 37.719074451264 -122.389811494874 (37.719074451264, -122.389811494874)
29979 241228 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 128 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003596.19295 2097670.1680900003 37.740006394279796 -122.43012423703699 (37.7400063942798, -122.430124237037)
30518 179954 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 40 Tomaso Ct 1 : 4 Tree 1 Private 1     23 Width 2ft   6009197.20014 2086405.9588 37.709392885454 -122.409963207553 (37.709392885454, -122.409963207553)
31101 66988 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1445 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/1992 12:00:00 AM 12   Permit Number 30339 6006117.71616 2118619.27503 37.7976701397196 -122.422894339811 (37.7976701397196, -122.422894339811)
31251 241193 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010149.76354 2105082.07302 37.7607268479899 -122.40798714698299 (37.7607268479899, -122.407987146983)
32139 215423 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993769.4086 2092813.96021 37.72611098282629 -122.46374856183998 (37.7261109828263, -122.46374856184)
33234 215420 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2085 09th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
34328 241212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009052.89196 2106353.81264 37.7641572813666 -122.411870616529 (37.7641572813666, -122.411870616529)
34372 241223 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009004.56515 2106399.07167 37.7642788409211 -122.41204096432699 (37.7642788409211, -122.412040964327)
34503 215417 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12     5994025.97554 2088461.57938 37.7141751725286 -122.46254606394699 (37.7141751725286, -122.462546063947)
34945 113776 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1710 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6000070.198 2114878.1306 37.7870548531015 -122.443551447546 (37.7870548531015, -122.443551447546)
35031 241196 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010370.46966 2100029.8165599997 37.7468668275408 -122.406867732983 (37.7468668275408, -122.406867732983)
35762 241219 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6003095.93223 2100399.3712299997 37.7474718059861 -122.432048772745 (37.7474718059861, -122.432048772745)
35806 136746 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000043.09421 2118605.60705 37.7972879782152 -122.44391313370501 (37.7972879782152, -122.443913133705)
37345 197979 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012714.266419999 2104668.82572 37.759735409279706 -122.39908861614599 (37.7597354092797, -122.399088616146)
37469 241216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 6 Fountain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6000321.631 2101619.05614 37.7506630907493 -122.44172961845301 (37.7506630907493, -122.441729618453)
37691 136745 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000044.84961 2118592.59728 37.797252356970205 -122.44390612438801 (37.7972523569702, -122.443906124388)
39377 241220 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009102.18096 2106403.8524599997 37.7642974442959 -122.41170367540899 (37.7642974442959, -122.411703675409)
39697 241201 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 26 Carl St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998490.815219999 2107264.4937400003 37.7660595705173 -122.44846722318898 (37.7660595705173, -122.448467223189)
40655 197995 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014417.48937 2089293.51791 37.717612756412 -122.392122692435 (37.717612756412, -122.392122692435)
41547 215416 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12     5994027.68196 2088444.22736 37.7141276262766 -122.462538908049 (37.7141276262766, -122.462538908049)
41866 181367 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4019 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982046.1498 2105540.3564 37.76037163028771 -122.505217265817 (37.7603716302877, -122.505217265817)
42049 197980 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6012727.8948800005 2104659.33214 37.759710101458204 -122.399040815374 (37.7597101014582, -122.399040815374)
42196 183595 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2639 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5989548.2713 2097387.6993 37.7384251583472 -122.478674965089 (37.7384251583472, -122.478674965089)
42264 246217 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 725 Buena Vista Ave West 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5999828.0384 2107849.3991 37.7677419398126 -122.443884078726 (37.7677419398126, -122.443884078726)
42490 241188 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 419 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6007442.12211 2107229.45736 37.7664710984984 -122.417503881697 (37.7664710984984, -122.417503881697)
44646 119965 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 518 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5987217.06494 2112373.1551 37.7794354929176 -122.48783573328801 (37.7794354929176, -122.487835733288)
44751 197981 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6012726.35291 2104657.30852 37.759704459115795 -122.39904600628 (37.7597044591158, -122.39904600628)
44829 94949 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 31 50 Pomona St   : Cutout 24 Tree 1 SFUSD 4 FUF 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
46627 182665 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 0ft   5985884.1902 2102331.3321 37.7517856167847 -122.491707219971 (37.7517856167847, -122.491707219971)
47070 83362 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 3325 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2008 12:00:00 AM 5 3x3 Permit Number 51120 5982822.4546 2100126.935 37.745553538391206 -122.50213183404101 (37.7455535383912, -122.502131834041)
47759 241195 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 699 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010149.3192300005 2105113.8429400004 37.7608140561404 -122.407990924146 (37.7608140561404, -122.407990924146)
48125 36793 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015250.697000001 2090820.757 37.721852482589796 -122.38934923747601 (37.7218524825898, -122.389349237476)
48830 215419 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 1x Minerva St 36 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   5996348.606369999 2088999.95907 37.7157869222005 -122.454557070559 (37.7157869222005, -122.454557070559)
48849 198000 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 828x Jamestown Ave 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   6014844.30096 2089001.4675099999 37.7168345316683 -122.390626989449 (37.7168345316683, -122.390626989449)
49851 197983 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1809 19th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012297.3164 2105130.82765 37.760980720296295 -122.400563103211 (37.7609807202963, -122.400563103211)
50744 197985 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 669 Mississippi St 2 : 4 Tree 1 Private 1     9 Width 3ft   6014155.897999999 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116)
50962 179971 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 160 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
51116 179953 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 240 Peabody St 1 : 4 Tree 1 Private 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
51602 197989 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 28 15th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6012209.71616 2107476.11774 37.7674154774686 -122.401030868501 (37.7674154774686, -122.401030868501)
51881 197988 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 82 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6012221.12319 2107462.35445 37.7673783228879 -122.40099044576 (37.7673783228879, -122.40099044576)
53611 109316 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1516 BROADWAY 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
54785 66435 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 154 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/29/2016 12:00:00 AM 3   Permit Number 776442 6005832.64379623 2096619.46427693 37.7372478105316 -122.422316867971 (37.7372478105316, -122.422316867971)
54816 57900 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1324 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/1977 12:00:00 AM 5   Permit Number 16856 6001502.5818 2110462.7186 37.77501283944979 -122.438279288937 (37.7750128394498, -122.438279288937)
55123 198002 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 860x Jamestown Ave 13 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   6014610.54339 2089241.6149400002 37.717480958049 -122.39145176041 (37.717480958049, -122.39145176041)
55615 182655 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5985877.3992 2102330.3619999997 37.7517825562574 -122.49173063243201 (37.7517825562574, -122.491730632432)
55655 198001 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 860x Jamestown Ave 1 Median : Cutout 11 Tree 1 DPW 2     9 Width 5ft   6014795.93259 2089063.22643 37.7170014260431 -122.390798490171 (37.7170014260431, -122.390798490171)
56645 247209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6001860.515269999 2108286.6653 37.7690582897368 -122.436885307832 (37.7690582897368, -122.436885307832)
56686 241210 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6009103.79641 2106355.71742 37.764165367153204 -122.41169468665899 (37.7641653671532, -122.411694686659)
57252 199656 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1395 Donner Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6015030.8215 2090912.727 37.7220928214053 -122.39011571883199 (37.7220928214053, -122.390115718832)
58250 215427 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993797.5326 2092869.7349099999 37.726265747145604 -122.463655385788 (37.7262657471456, -122.463655385788)
59497 215415 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 484 Faxon Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5994798.18805 2091784.9127099998 37.7233446951982 -122.460117638125 (37.7233446951982, -122.460117638125)
59569 115612 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1400 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
59765 241209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6009128.3617 2106356.68814 37.76416941052621 -122.411609790669 (37.7641694105262, -122.411609790669)
59883 179956 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   5998852.5351599995 2088480.84158 37.7145048379104 -122.44586505733999 (37.7145048379104, -122.44586505734)
60020 241221 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2800 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009078.922 2106403.19833 37.764294343422996 -122.411784075669 (37.764294343423, -122.411784075669)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 93.988ms · Data source: data.sfgov.org