Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");