Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
188288 | 188288 | 206675 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995199.651459999 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | |||
188155 | 188155 | 206686 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996075.5527099995 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | |||
186978 | 186978 | 190925 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 651 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011562.1933699995 | 2105343.91486 | 37.761524784975 | -122.40312057635 | (37.761524784975, -122.40312057635) | |||
186945 | 186945 | 206566 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991741.264830001 | 2097200.972 | 37.738039538296206 | -122.471079130991 | (37.7380395382962, -122.471079130991) | |||
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) | ||
185933 | 185933 | 47492 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.43644523806499 | (37.7277113821718, -122.436445238065) | |
185534 | 185534 | 176074 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | |||
185359 | 185359 | 206567 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991381.7608900005 | 2098233.80223 | 37.74085462674589 | -122.472397375252 | (37.7408546267459, -122.472397375252) | |||
185239 | 185239 | 206500 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993474.546519999 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | |||
184245 | 184245 | 50918 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | |
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) | |||
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) | |||
180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
179932 | 179932 | 206676 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | |||
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) | |
177940 | 177940 | 206677 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.46005157662901 | (37.7347770452256, -122.460051576629) | |||
177415 | 177415 | 223049 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002666.83309 | 2105626.92623 | 37.7618010890622 | -122.433906166852 | (37.7618010890622, -122.433906166852) | |||
176558 | 176558 | 38592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1618 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40547 | 6015152.7308 | 2094735.8699 | 37.7325971695789 | -122.389961235194 | (37.7325971695789, -122.389961235194) | |
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) | |||
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) | |||
175013 | 175013 | 206619 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994070.38957 | 2104649.5630900003 | 37.758625920162295 | -122.463566678468 | (37.7586259201623, -122.463566678468) | |||
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) | |||
174269 | 174269 | 223032 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006256.18709 | 2096109.4549 | 37.735871320489395 | -122.42081628443898 | (37.7358713204894, -122.420816284439) | |||
174016 | 174016 | 65967 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | |
173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
173302 | 173302 | 183679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.49699886391899 | (37.7626128114068, -122.496998863919) | |||
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) | |||
171923 | 171923 | 206534 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.45831259717501 | (37.7288535085691, -122.458312597175) | |||
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) | |||
171063 | 171063 | 206569 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2435 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992009.07535 | 2098867.5883299997 | 37.7426311295378 | -122.47027451837099 | (37.7426311295378, -122.470274518371) | |||
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) | |||
170640 | 170640 | 137632 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2175 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999619.2063 | 2111878.8056 | 37.7787937523144 | -122.44489608677401 | (37.7787937523144, -122.444896086774) | |||
168083 | 168083 | 32398 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.5920900002 | 37.7358062077876 | -122.42180021560199 | (37.7358062077876, -122.421800215602) | |
168058 | 168058 | 223039 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007708.387180001 | 2096815.6091900002 | 37.7378920108046 | -122.41584542843201 | (37.7378920108046, -122.415845428432) | |||
167831 | 167831 | 206678 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995925.9256 | 2096013.7330599998 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | |||
166442 | 166442 | 206532 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993345.963169999 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | |||
165826 | 165826 | 206688 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996101.05251 | 2095948.39142 | 37.7348514596286 | -122.455914747394 | (37.7348514596286, -122.455914747394) | |||
165652 | 165652 | 206674 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995208.64941 | 2095407.77696 | 37.7333158051714 | -122.458960944512 | (37.7333158051714, -122.458960944512) | |||
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) | ||
164832 | 164832 | 71420 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 637 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 6009832.0273 | 2120182.0847 | 37.8021701092209 | -122.410152151595 | (37.8021701092209, -122.410152151595) | ||
163888 | 163888 | 38590 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1614 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40545 | 6015168.4288 | 2094722.1342 | 37.732560324707705 | -122.38990600380698 | (37.7325603247077, -122.389906003807) | |
162977 | 162977 | 223033 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006248.27078 | 2096110.4955099998 | 37.735873731571395 | -122.420843728155 | (37.7358737315714, -122.420843728155) | |||
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) | |||
161600 | 161600 | 206530 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Garcia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994631.6545 | 2099433.40276 | 37.744335991408896 | -122.46124747260099 | (37.7443359914089, -122.461247472601) | |||
161050 | 161050 | 199671 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1905 Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015210.0019 | 2093419.3228 | 37.728985371993396 | -122.389671313679 | (37.7289853719934, -122.389671313679) | |||
160564 | 160564 | 31753 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | |
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) | |||
160214 | 160214 | 206681 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995960.60425 | 2096012.63655 | 37.735019799206 | -122.45640496693399 | (37.735019799206, -122.456404966934) | |||
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) | |||
158004 | 158004 | 223037 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002071.560219999 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | |||
157581 | 157581 | 206499 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993488.07663 | 2104571.6485200003 | 37.7583784177465 | -122.46557490416001 | (37.7583784177465, -122.46557490416) | |||
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) | |||
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) | |||
155591 | 155591 | 206679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | |||
155564 | 155564 | 223055 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | |||
153437 | 153437 | 206522 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.47370838535801 | (37.7465686447317, -122.473708385358) | |||
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) | |||
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) | |||
151724 | 151724 | 206687 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996087.4467400005 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | |||
151039 | 151039 | 206692 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996416.06092 | 2095880.8714400001 | 37.7346841407625 | -122.45482078325199 | (37.7346841407625, -122.454820783252) | |||
151022 | 151022 | 95110 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) |
149027 | 149027 | 206693 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.740610086694396 | -122.45017375511999 | (37.7406100866944, -122.45017375512) | |||
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) | |||
146174 | 146174 | 40167 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 216 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | Permit Number 41360 | 5994849.72626239 | 2095987.73496493 | 37.7348875889443 | -122.46024383672199 | (37.7348875889443, -122.460243836722) | ||
146091 | 146091 | 116195 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3751 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996888.0 | 2115293.0 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | ||||
146007 | 146007 | 87775 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 333 Sussex St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129.0 | 2096659.0 | 37.737089918679 | -122.43858232139401 | (37.737089918679, -122.438582321394) | |||
145633 | 145633 | 47755 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 364St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2002 12:00:00 AM | Permit Number 45535 | 5994004.07072151 | 2099729.00956261 | 37.7451115153754 | -122.463438956035 | (37.7451115153754, -122.463438956035) | |||
145220 | 145220 | 64244 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 554 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33284 | 6005149.627474099 | 2111313.35504132 | 37.7775552357395 | -122.425723916077 | (37.7775552357395, -122.425723916077) | ||
143621 | 143621 | 45117 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
143418 | 143418 | 68621 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.47423624838899 | (37.7516236388925, -122.474236248389) | ||
142674 | 142674 | 94074 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 628 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53464 | 5996021.0 | 2096021.0 | 37.7350462302618 | -122.456196763121 | (37.7350462302618, -122.456196763121) | ||
142150 | 142150 | 115536 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
141700 | 141700 | 37459 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 30 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39931 | 6010620.6907028 | 2100238.51379536 | 37.7474538625831 | -122.40601718747 | (37.7474538625831, -122.40601718747) | ||
141520 | 141520 | 35070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | ||
140639 | 140639 | 68598 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.47300685208599 | (37.7520016305294, -122.473006852086) | ||
139837 | 139837 | 65683 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 234 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28607 | 5994926.44798675 | 2095898.35261594 | 37.7346465797712 | -122.459972111851 | (37.7346465797712, -122.459972111851) | ||
139629 | 139629 | 68592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | ||
139248 | 139248 | 35403 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 550 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38858 | 6003059.40190018 | 2098358.03858994 | 37.7418647106265 | -122.432029345324 | (37.7418647106265, -122.432029345324) | ||
139071 | 139071 | 122405 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5994085.0 | 2099826.0 | 37.74538248907739 | -122.46316615516001 | (37.7453824890774, -122.46316615516) | ||||
138325 | 138325 | 72340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51610 | 6000779.3756349 | 2094751.92568258 | 37.7318336416051 | -122.43965444861999 | (37.7318336416051, -122.43965444862) | ||
138305 | 138305 | 39661 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | ||
137986 | 137986 | 223050 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001422.84544 | 2108013.2139 | 37.7682825750187 | -122.43837958446301 | (37.7682825750187, -122.438379584463) | |||
137767 | 137767 | 206593 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 187 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5995062.081040001 | 2100706.4698799998 | 37.74785627694121 | -122.45985135785101 | (37.7478562769412, -122.459851357851) | |||
137011 | 137011 | 137657 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2167 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999659.4785 | 2111881.8514 | 37.778804413574704 | -122.444756988886 | (37.7788044135747, -122.444756988886) | |||
136007 | 136007 | 143086 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | |||
135645 | 135645 | 223028 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 42 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998401.231319999 | 2106021.8866 | 37.7626425622232 | -122.448687567871 | (37.7626425622232, -122.448687567871) | |||
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) | |||
132461 | 132461 | 206523 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | |||
132401 | 132401 | 206621 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993175.256709999 | 2102431.1044799997 | 37.7524829903015 | -122.46650118519301 | (37.7524829903015, -122.466501185193) | |||
132280 | 132280 | 223046 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 77 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005471.50149 | 2099604.5609999998 | 37.7454238329391 | -122.423777694396 | (37.7454238329391, -122.423777694396) | |||
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) | |||
131438 | 131438 | 126378 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | |||
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) | ||
130622 | 130622 | 223035 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | |||
130438 | 130438 | 244873 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000342.3248 | 2109115.5777 | 37.7712478709156 | -122.442196132801 | (37.7712478709156, -122.442196132801) | |||
129639 | 129639 | 223056 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004346.640459999 | 2097517.13802 | 37.739628683514496 | -122.427518598925 | (37.7396286835145, -122.427518598925) | |||
129441 | 129441 | 94071 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098.0 | 2095984.0 | 37.734949056945204 | -122.455927874303 | (37.7349490569452, -122.455927874303) | ||
128961 | 128961 | 54717 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 24726 | 6004298.03079874 | 2103629.31683929 | 37.756408560199 | -122.428122138519 | (37.756408560199, -122.428122138519) | ||
128328 | 128328 | 67340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.75196069589111 | -122.403505842523 | (37.7519606958911, -122.403505842523) |
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");