Street_Tree_List

Data source: data.sfgov.org

357 rows where qSpecies = 31 sorted by YCoord

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
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)
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)
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)
189124 179961 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 299 Lathrop Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6012198.832140001 2086842.9214 37.7107604718955 -122.399619668515 (37.7107604718955, -122.399619668515)
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)
70744 179963 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255)
187402 179964 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002952.82685 2087126.8782400002 37.7110204227269 -122.431596206017 (37.7110204227269, -122.431596206017)
166430 179960 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6011897.9450900005 2087458.38855 37.7124336452757 -122.400702818282 (37.7124336452757, -122.400702818282)
156645 179959 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6011901.82986 2087473.4551099997 37.7124752317148 -122.400690449024 (37.7124752317148, -122.400690449024)
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)
61689 42736 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
101582 42735 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
109593 42738 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
112114 42733 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
117817 42739 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
120632 42737 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 2155 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
174371 179957 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 162 Tunnel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6011927.1671400005 2087557.3453099998 37.7127069906044 -122.40060876447599 (37.7127069906044, -122.400608764476)
119574 47386 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 400 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/2002 12:00:00 AM     Permit Number 45302 5998534.7421818 2087640.83447452 37.712180218724896 -122.446903063491 (37.7121802187249, -122.446903063491)
136987 51838 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 135 Morse St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2005 12:00:00 AM 8   Permit Number 48065 6000803.77084 2087905.29553 37.713035738688504 -122.43907959427 (37.7130357386885, -122.43907959427)
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)
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)
64095 179955 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   5998862.1125 2088471.1679599998 37.7144788232093 -122.445831259031 (37.7144788232093, -122.445831259031)
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)
188473 215418 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 286 Orizaba Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10     5994025.68496 2088506.9373700002 37.7142996980529 -122.462550356439 (37.7142996980529, -122.462550356439)
162886 197999 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 828 Jamestown Ave 1 : 4 Tree 1 Private 1     10 Width 5ft   6014890.34253 2088931.57147 37.7166451650195 -122.39046296391399 (37.7166451650195, -122.390462963914)
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)
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)
80153 82685 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 35 Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52459 6012802.99497586 2089176.16957459 37.7172007679129 -122.397695078281 (37.7172007679129, -122.397695078281)
182005 197998 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014511.88744 2089238.1825599999 37.717466057201705 -122.391792531525 (37.7174660572017, -122.391792531525)
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)
170469 197997 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6014474.56871 2089262.00767 37.717529404523795 -122.391923191299 (37.7175294045238, -122.391923191299)
178207 198003 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 920x Jamestown Ave 1 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   6014527.01214 2089285.60779 37.7175971171782 -122.391743566112 (37.7175971171782, -122.391743566112)
182308 197996 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6014434.42252 2089286.69966 37.7175949749992 -122.392063685205 (37.7175949749992, -122.392063685205)
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)
178543 197994 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6014370.9162 2089321.9827 37.717688329142604 -122.392285665748 (37.7176883291426, -122.392285665748)
184240 197993 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6014330.76175 2089346.27019 37.7177527880479 -122.392426160549 (37.7177527880479, -122.392426160549)
178127 197992 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014311.92 2089359.19845 37.717787240171795 -122.392492192366 (37.7177872401718, -122.392492192366)
132906 198004 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 920x Jamestown Ave 12 Median : Cutout 11 Tree 1 DPW 2     10 Width 5ft   6014389.315880001 2089371.37328 37.7178249676301 -122.39222551819401 (37.7178249676301, -122.392225518194)
127065 84127 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 88 Mill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50980 6010360.09243836 2089687.02520781 37.7184671339256 -122.406175049692 (37.7184671339256, -122.406175049692)
160717 197991 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3419 Jennings St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013294.96544 2089742.68292 37.7187836844998 -122.396034235213 (37.7187836844998, -122.396034235213)
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)
69093 114917 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 86 Carr St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/04/2016 12:00:00 AM 8   Permit 774770 6012955.87899 2090602.59506 37.721125958889104 -122.397266597771 (37.7211259588891, -122.397266597771)
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)
166782 36797 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015213.5435 2090847.5562 37.721924008003604 -122.389479539312 (37.7219240080036, -122.389479539312)
174472 36791 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015186.7443 2090870.701 37.7219860731406 -122.389573793771 (37.7219860731406, -122.389573793771)
179138 36792 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015166.6448 2090882.8824 37.7220184063671 -122.38964412365499 (37.7220184063671, -122.389644123655)
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)
130541 199802 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6015069.8022 2090954.144 37.7222087062567 -122.389983862743 (37.7222087062567, -122.389983862743)
121741 99249 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 435 Paul Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/2012 12:00:00 AM   3x3 Permit Number 769233 6012286.9 2091380.6 37.7232249352354 -122.399633675727 (37.7232249352354, -122.399633675727)
71330 179970 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 307 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
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)
66988 179969 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 623 Goettingen St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6010613.39722 2091824.0219599998 37.7243490517445 -122.40544989510599 (37.7243490517445, -122.405449895106)
146364 179967 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 716 Peru Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6005275.29843 2092450.03888 37.7257680389529 -122.423947466603 (37.7257680389529, -122.423947466603)
185205 179966 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 716 Peru Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   6005255.40982 2092462.4838400001 37.725801087223 -122.424017104714 (37.725801087223, -122.424017104714)
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)
89857 49072 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 6 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)
93667 49070 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 2 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)
95324 49073 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 5 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)
99383 49074 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 4 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)
111888 49075 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 1 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)
120865 49076 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1970 Ocean Ave 3 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)
181948 215424 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993760.13704 2092800.2871 37.7260729055276 -122.463779620842 (37.7260729055276, -122.463779620842)
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)
164853 215422 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993781.00975 2092831.61045 37.7261601145848 -122.46370973814 (37.7261601145848, -122.46370973814)
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)
182516 215434 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993586.39661 2092891.1654599998 37.7263124219742 -122.464386821508 (37.7263124219742, -122.464386821508)
128240 215433 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993594.89235 2092910.6701200001 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875)
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)
135321 215425 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 15 Fairfield Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993828.92178 2092931.25645 37.7264364789445 -122.463551338741 (37.7264364789445, -122.463551338741)
167445 215432 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993607.07382 2092934.5708400002 37.7264327944236 -122.464318491921 (37.7264327944236, -122.464318491921)
168300 215431 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993618.37614 2092959.3845099998 37.726501578172396 -122.464281221309 (37.7265015781724, -122.464281221309)
188005 215430 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5993628.724219999 2092981.5344200002 37.72656299287289 -122.464247056069 (37.7265629928729, -122.464247056069)
135775 179965 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 86 Arago St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     5999606.18552 2093002.3803299998 37.726962952855104 -122.443584762453 (37.7269629528551, -122.443584762453)
136653 215429 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993645.021930001 2093008.9273599999 37.726639146565 -122.46419270373801 (37.726639146565, -122.464192703738)
76250 215428 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 20 Lakewood Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5993651.19736 2093024.90181 37.7266833644367 -122.464172514845 (37.7266833644367, -122.464172514845)
83463 49161 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 804 Faxon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.45978949774499 (37.7277062535492, -122.459789497745)
123498 49162 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 804 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.45978949774499 (37.7277062535492, -122.459789497745)
185349 179968 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 675 Silver Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 2ft   6005852.39602 2093589.2328700002 37.7289285803821 -122.422033372066 (37.7289285803821, -122.422033372066)
94918 42310 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 249 Edna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
105310 42309 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 249 Edna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
127349 42308 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 249 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
140792 94868 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 31 51 Princeton St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
163040 82715 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1379 Quesada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2009 12:00:00 AM 11 3x3 Permit Number 52465 6016442.9825 2093699.9014 37.7298240779238 -122.385428311894 (37.7298240779238, -122.385428311894)
137872 82840 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1379 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2009 12:00:00 AM 13 3x3 Permit Number 52465 6016423.5899 2093711.7525 37.729855545757 -122.38549618052299 (37.729855545757, -122.385496180523)
164545 82366 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 31 51 Princeton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
116426 65602 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 114 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1990 12:00:00 AM 13   Permit Number 28504 6004165.03379 2093741.9135900002 37.729252495484 -122.427877581308 (37.729252495484, -122.427877581308)
147184 215439 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   5998709.4181699995 2093777.72882 37.729040692553 -122.44674062198 (37.729040692553, -122.44674062198)
178324 215437 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   5998668.44451 2093778.0926299999 37.729039350777 -122.44688229669701 (37.729039350777, -122.446882296697)
157728 215438 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5998696.43814 2093778.97623 37.7290433761531 -122.44678558449101 (37.7290433761531, -122.446785584491)
87190 106452 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 56 Lucy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2014 12:00:00 AM 3   Permit Number 772906 6014092.7 2093830.3 37.7300518134974 -122.393562691323 (37.7300518134974, -122.393562691323)
117278 50801 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 466 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/11/2004 12:00:00 AM     Permit Number 47598 5997189.59146779 2093842.28323419 37.7291310061031 -122.451999409113 (37.7291310061031, -122.451999409113)
166118 215413 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5997941.5079 2094069.28168 37.7297973308762 -122.44941633348999 (37.7297973308762, -122.44941633349)
64723 215414 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5997954.5929 2094069.3346400002 37.7297982247933 -122.449371101191 (37.7297982247933, -122.449371101191)
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)
90667 94951 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)
107188 94950 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)
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)
78838 16202 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 500X Monterey Blvd 2 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)
139874 16201 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 500X Monterey Blvd 1 Median : Cutout 11 Tree 1 DPW 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)

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 117.791ms · Data source: data.sfgov.org