Street_Tree_List

Data source: data.sfgov.org

490 rows where qSpecies = 66 sorted by qAddress

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
79272 41698 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1 Mizpah St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618)
117825 41697 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1 Mizpah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618)
120499 41696 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1 Mizpah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618)
63545 223038 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 10 Lippard Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002089.19721 2096067.16423 37.7355194490575 -122.435220170783 (37.7355194490575, -122.435220170783)
135298 176075 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 100 Capistrano Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001444.800340001 2093622.381 37.7287700227166 -122.43727309280001 (37.7287700227166, -122.4372730928)
45428 206576 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 100 Montalvo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993684.51151 2099645.64672 37.744864205510204 -122.46453787523501 (37.7448642055102, -122.464537875235)
160368 126382 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1001 Vallejo St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 4ft   6008670.39988 2118624.74661 37.7978288673746 -122.414061717575 (37.7978288673746, -122.414061717575)
30002 206592 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Montalvo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993721.8716 2099672.6551599996 37.744940517497 -122.464410652624 (37.744940517497, -122.464410652624)
165477 206591 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Montalvo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993709.625030001 2099698.37793 37.745010439781296 -122.464454865994 (37.7450104397813, -122.464454865994)
22356 223022 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 6ft   6006257.519669999 2099541.04409 37.745293770294104 -122.42105525588998 (37.7452937702941, -122.42105525589)
69960 68121 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1993 12:00:00 AM     Permit Number 31868 6006245.31002458 2099503.96919514 37.745191282743896 -122.421094842871 (37.7451912827439, -122.421094842871)
126746 206518 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5991072.98938 2104484.60902 37.7579998382313 -122.473920910448 (37.7579998382313, -122.473920910448)
171652 206516 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5991047.261080001 2104483.88717 37.7579963659448 -122.474009836278 (37.7579963659448, -122.474009836278)
176247 206515 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5991033.61709 2104484.17502 37.7579963659675 -122.47405704351601 (37.7579963659675, -122.474057043516)
181904 206517 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5991060.290580001 2104484.56084 37.7579989703891 -122.473964824336 (37.7579989703891, -122.473964824336)
148524 126381 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1022 Vallejo St 1 Front Yard : Yard 7 Tree 1 Private 1     5     6008596.5256900005 2118672.84077 37.7979567725457 -122.414320748412 (37.7979567725457, -122.414320748412)
36423 206512 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5990980.22345 2104481.19226 37.7579850830548 -122.47424148188401 (37.7579850830548, -122.474241481884)
50270 206508 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990927.20691 2104481.04629 37.7579816107755 -122.474424823051 (37.7579816107755, -122.474424823051)
55765 206510 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5990951.63934 2104480.53076 37.757981610781606 -122.474340288587 (37.7579816107816, -122.474340288587)
119103 206513 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5990992.34085 2104483.78156 37.757992894562 -122.47419976413 (37.757992894562, -122.47419976413)
153105 206509 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990938.9472 2104480.79856 37.75798161076639 -122.47438420248501 (37.7579816107664, -122.474384202485)
160435 206511 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5990966.24876 2104480.85465 37.757983346478795 -122.474289787164 (37.7579833464788, -122.474289787164)
171944 206514 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5991006.3222 2104484.4348 37.7579954981234 -122.47415145883801 (37.7579954981234, -122.474151458838)
61905 190927 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1050 Wisconsin St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6012767.00645 2102579.68997 37.7540020378723 -122.39875959738 (37.7540020378723, -122.39875959738)
61636 223021 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 109 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006234.71683 2099501.18451 37.7451830394575 -122.421131274692 (37.7451830394575, -122.421131274692)
98472 68122 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 109 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1993 12:00:00 AM     Permit Number 31870 6006226.82006776 2099469.59440232 37.7450958550009 -122.42115633768 (37.7450958550009, -122.42115633768)
58785 206665 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 11 Santa Rita Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993870.76921 2100887.71242 37.748285339014295 -122.463983980089 (37.7482853390143, -122.463983980089)
76330 126383 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1116 Greenwich St 3 Front Yard : Yard 7 Tree 1 Private 1     4     6007504.98606 2119897.57415 37.801258207159 -122.418184672095 (37.801258207159, -122.418184672095)
156749 126384 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1120 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     4     6007500.24433 2119896.2377400002 37.8012542708165 -122.418200985801 (37.8012542708165, -122.418200985801)
165172 50986 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1120REVISED Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/06/2004 12:00:00 AM 6   Permit Number 47576 6007503.31376 2119893.93908 37.801248132044 -122.418190201138 (37.801248132044, -122.418190201138)
78398 62968 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1136 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/21/1986 12:00:00 AM     Permit Number 23354 6007556.73602589 2118875.23289672 37.7984540273893 -122.41793308103901 (37.7984540273893, -122.417933081039)
70261 126380 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1136 Havens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6007510.81799 2119357.46903 37.799775542566294 -122.41812617837401 (37.7997755425663, -122.418126178374)
175387 126379 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1136 Havens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6007507.74968 2119357.27743 37.7997748437807 -122.418136782297 (37.7997748437807, -122.418136782297)
46262 223026 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 114 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004706.47094 2102901.67728 37.7544337331488 -122.42665779482799 (37.7544337331488, -122.426657794828)
119254 65260 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1153 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/2002 12:00:00 AM     Permit Number 28059 6009500.12226017 2102463.02471256 37.7534991381214 -122.410049073844 (37.7534991381214, -122.410049073844)
35553 223027 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 116 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6004711.2067599995 2102860.50548 37.754320952762 -122.426638485476 (37.754320952762, -122.426638485476)
91932 62709 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1171 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1986 12:00:00 AM     Permit Number 23049 6007422.95308964 2118804.22805474 37.798251535762205 -122.418390975112 (37.7982515357622, -122.418390975112)
76722 206547 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 120 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993889.308780001 2099967.60077 37.7457600139093 -122.463853094571 (37.7457600139093, -122.463853094571)
47868 206574 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 120 Montalvo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993698.095930001 2099619.5133 37.744793232835605 -122.464489006068 (37.7447932328356, -122.464489006068)
153258 206575 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 120 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993692.18131 2099632.63233 37.744828913423 -122.464510409921 (37.744828913423, -122.464510409921)
17882 52665 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1200 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM 3 3x3 Permit Number 774794 6000815.0 2109317.0 37.77182785317 -122.440575583218 (37.77182785317, -122.440575583218)
57958 183317 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1209 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983329.0993 2106834.4338 37.7640002060456 -122.50087591440399 (37.7640002060456, -122.500875914404)
68623 63086 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1209 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1986 12:00:00 AM 3   Permit Number 23570 5983326.3714 2106866.623 37.7640884282736 -122.500887729919 (37.7640884282736, -122.500887729919)
101331 54097 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 121 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/16/1995 12:00:00 AM     Permit Number 9824 6000463.76381209 2104868.98714017 37.759594708041796 -122.441471294748 (37.7595947080418, -122.441471294748)
25180 126376 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 122 Cervantes Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001336.2876 2121154.5777 37.8043604581295 -122.43962119477399 (37.8043604581295, -122.439621194774)
174299 126377 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 122 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6001345.97363 2121147.25207 37.8043408951819 -122.439587150049 (37.8043408951819, -122.439587150049)
131108 63003 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1239 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/1986 12:00:00 AM 3   Permit Number 23411 5983024.3565 2106665.5091 37.763518489811 -122.501917412441 (37.763518489811, -122.501917412441)
76521 223030 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 125 Belgrave Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   5997950.67072 2104889.0935 37.759506423000204 -122.450164233094 (37.7595064230002, -122.450164233094)
157023 206694 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 125 Chilton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001630.15209 2095380.35715 37.733607556928 -122.43675811218999 (37.733607556928, -122.43675811219)
34642 223020 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6006199.74889 2099432.38497 37.7449921601655 -122.421247303447 (37.7449921601655, -122.421247303447)
83530 68124 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1993 12:00:00 AM     Permit Number 31872 6006189.84017158 2099400.84484915 37.7449049995041 -122.421279326768 (37.7449049995041, -122.421279326768)
186544 63000 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1251 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/1986 12:00:00 AM 2   Permit Number 23408 5983028.2339 2106580.2336 37.763284575331795 -122.50189769196899 (37.7632845753318, -122.501897691969)
115026 34301 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1257 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38089 6010337.06875453 2101902.38195398 37.7520066112995 -122.407115203053 (37.7520066112995, -122.407115203053)
99952 34302 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1261 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38090 6010338.30191232 2101880.05024725 37.7519453623814 -122.407109364623 (37.7519453623814, -122.407109364623)
7079 108929 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 12x MacOndray Ln 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6008556.45633 2119171.5746400002 37.79932392101129 -122.41449470968399 (37.7993239210113, -122.414494709684)
50360 206528 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 13 Madrone Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992986.65204 2099006.05822 37.7430678034305 -122.466904434898 (37.7430678034305, -122.466904434898)
132226 206527 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 13 Madrone Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992983.90563 2098997.49136 37.7430441224891 -122.46691330850099 (37.7430441224891, -122.466913308501)
148248 206529 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 13 Madrone Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992989.732419999 2099015.25675 37.7430932380525 -122.466894452432 (37.7430932380525, -122.466894452432)
152052 223044 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 13 Stoneman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008324.57166 2099444.87133 37.7451460071793 -122.413900908902 (37.7451460071793, -122.413900908902)
158851 223045 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 13 Stoneman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008341.10325 2099446.02772 37.745150110794896 -122.413843827126 (37.7451501107949, -122.413843827126)
122539 190926 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1303 Rhode Island St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6012003.88758 2102215.75937 37.7529602155494 -122.40137308660401 (37.7529602155494, -122.401373086604)
29378 95906 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1323 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2011 12:00:00 AM 2 3x3 Permit Number 767607 5987385.7768 2106255.5896 37.7626482044987 -122.486802739667 (37.7626482044987, -122.486802739667)
121588 34344 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1325 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38101 6010099.44079349 2101484.52277039 37.7508459613928 -122.40790749535499 (37.7508459613928, -122.407907495355)
78925 69199 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1342 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1994 12:00:00 AM     Permit Number 33247 6009509.54623645 2101351.16759285 37.7504467544428 -122.409938000531 (37.7504467544428, -122.409938000531)
48597 47077 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 135 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2002 12:00:00 AM 3   Permit Number 45064 5996788.5617 2112098.8644 37.779236022786606 -122.454704245524 (37.7792360227866, -122.454704245524)
54118 206596 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 Magellan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5995085.45283 2100859.88169 37.7482788513041 -122.459781650511 (37.7482788513041, -122.459781650511)
57368 206595 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995084.10326 2100870.93077 37.7483091116899 -122.45978711747601 (37.7483091116899, -122.459787117476)
155632 206594 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995087.43611 2100841.3404599996 37.7482280558 -122.459773449604 (37.7482280558, -122.459773449604)
136744 206664 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 San Marcos Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   5993646.4962 2100328.84926 37.7467379151376 -122.464718926731 (37.7467379151376, -122.464718926731)
78195 47741 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1384 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/2002 12:00:00 AM     Permit Number 45524 6010066.05430582 2101146.00958918 37.7499146097647 -122.40799907978399 (37.7499146097647, -122.407999079784)
183187 206695 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 140 Hamerton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001321.914580001 2095363.51303 37.7335437842173 -122.437822570471 (37.7335437842173, -122.437822570471)
94076 48468 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1409 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/06/2002 12:00:00 AM     Permit Number 45831 6003303.13281599 2100036.19716336 37.746486359598705 -122.431306366847 (37.7464863595987, -122.431306366847)
17396 28296 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1432 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/26/2003 12:00:00 AM 6 2X3   6005818.9272 2100626.68333 37.7482499542668 -122.42264897149599 (37.7482499542668, -122.422648971496)
55162 206635 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 145 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994551.94388 2100907.9053700003 37.7483800169362 -122.461629977657 (37.7483800169362, -122.461629977657)
164232 206634 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 145 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994552.462069999 2100915.6770099998 37.748401385725 -122.461628749166 (37.748401385725, -122.461628749166)
177772 206633 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 145 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994552.3071099995 2100925.23177 37.7484276117632 -122.461629977659 (37.7484276117632, -122.461629977659)
102428 206562 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1478 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5994313.38923 2105462.92602 37.76087320276021 -122.462785287235 (37.7608732027602, -122.462785287235)
96011 53145 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1498@ KEITH Underwood Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792)
39798 206669 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994007.62455 2100906.4247 37.74834460433671 -122.463512099503 (37.7483446043367, -122.463512099503)
49358 206666 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993976.53914 2100938.08553 37.74842974584271 -122.46362188875901 (37.7484297458427, -122.463621888759)
56263 206670 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994011.71818 2100897.82655 37.7483212318599 -122.463497320046 (37.7483212318599, -122.463497320046)
61321 206667 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993986.73582 2100929.3593 37.74840637335971 -122.46358599590499 (37.7484063733597, -122.463585995905)
64527 206668 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993998.36893 2100916.3469700003 37.7483713150869 -122.46354482495501 (37.7483713150869, -122.463544824955)
51395 206653 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994496.6283 2101014.48441 37.748669471824 -122.46182898323 (37.748669471824, -122.46182898323)
58539 206598 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5995052.00135 2100847.98673 37.74824426696271 -122.45989646247601 (37.7482442669627, -122.459896462476)
77085 206600 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5995054.437030001 2100813.29817 37.748149160974705 -122.459885527604 (37.7481491609747, -122.459885527604)
162481 206599 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5995053.984619999 2100829.4455 37.748193471465704 -122.459888261529 (37.7481934714657, -122.459888261529)
170727 206597 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5995049.66416 2100868.50319 37.7483004655893 -122.459906030335 (37.7483004655893, -122.459906030335)
36442 200076 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6014887.9102 2093187.7857 37.728331752097795 -122.390768643797 (37.7283317520978, -122.390768643797)
42780 200073 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955)
116485 200075 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014900.2728 2093175.985 37.7283000356482 -122.390725081061 (37.7283000356482, -122.390725081061)
175342 200074 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014921.0644 2093162.4986 37.728264158228896 -122.39065226097 (37.7282641582289, -122.39065226097)
91434 51948 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1506 Willard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 48172 5996897.19536074 2106034.05471344 37.7625898542367 -122.453890338129 (37.7625898542367, -122.453890338129)
18475 26484 DPW Maintained 3 Crataegus laevigata :: English Hawthorn 66 154 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6000987.64369 2098692.2557200002 37.7426647191989 -122.439216742684 (37.7426647191989, -122.439216742684)
179097 30759 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1563 Thomas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/31/2005 12:00:00 AM 5   Permit Number 48354 6014932.9973 2093776.0212 37.7299494300904 -122.39065386327499 (37.7299494300904, -122.390653863275)
82231 48500 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1584(REVISED) Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/10/2003 12:00:00 AM     Permit Number 46340 5998006.8549345005 2108237.90665559 37.7687046321234 -122.45021130824301 (37.7687046321234, -122.450211308243)
74247 206636 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 159 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994544.936980001 2100878.69027 37.7482993963164 -122.461652089281 (37.7482993963164, -122.461652089281)
130265 206637 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 159 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994549.87925 2100894.15199 37.7483421347836 -122.461636120028 (37.7483421347836, -122.461636120028)
29674 206651 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994510.63767 2100971.03236 37.7485509699531 -122.461777389118 (37.7485509699531, -122.461777389118)
53756 206652 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994516.45103 2100943.3174900003 37.74847520657389 -122.4617552775 (37.7484752065739, -122.4617552775)

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