trees
713 rows where qSpecies_id = 102 sorted by qSiteInfo descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18307 | 206786 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6000024.48409 | 2094930.02996 | 37.732279679167 | -122.442277038462 | (37.732279679167, -122.442277038462) | 9 | 7 | 4 | 63 | 40 | |||
33441 | 206753 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 355 Parnassus Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5996046.6732 | 2106441.49184 | 37.7636597709952 | -122.456861438509 | (37.7636597709952, -122.456861438509) | 15 | 5 | 4 | 29492 | 12 | |||
44955 | 206781 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 551 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998423.83611 | 2094960.16244 | 37.7322710582486 | -122.447812988871 | (37.7322710582486, -122.447812988871) | 9 | 7 | 4 | 59 | 40 | |||
69555 | 126401 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 95 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008076.48902 | 2119089.50826 | 37.7990716117224 | -122.416149753634 | (37.7990716117224, -122.416149753634) | 5 | 1 | 10 | 308 | 32 | ||||
117294 | 206752 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 10 Beachmont Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5990858.79883 | 2095874.41908 | 37.7343460811043 | -122.474033463291 | (37.7343460811043, -122.474033463291) | 1 | 8 | 4 | 64 | 40 | |||
159432 | 206745 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998694.48733 | 2093469.34751 | 37.7281930968236 | -122.446770058609 | (37.7281930968236, -122.446770058609) | 9 | 7 | 4 | 28861 | 40 | |||
174878 | 206746 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998707.58431 | 2093469.07503 | 37.7281930968274 | -122.446724762433 | (37.7281930968274, -122.446724762433) | 9 | 7 | 4 | 28861 | 40 | |||
181593 | 206779 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000353.87806 | 2095252.78651 | 37.7331846615462 | -122.441161399793 | (37.7331846615462, -122.441161399793) | 9 | 7 | 5 | 63 | 40 | |||
181713 | 124088 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 601 Funston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5991897.07787 | 2111001.16091 | 37.7759402465292 | -122.471545739628 | (37.7759402465292, -122.471545739628) | 11 | 6 | 2 | 54 | 11 | ||||
192024 | 206769 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 485 Warren Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994381.7364 | 2104518.5556 | 37.7582841418063 | -122.462480405347 | (37.7582841418063, -122.462480405347) | 1 | 5 | 4 | 63 | 12 | |||
20685 | 103447 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
27906 | 103441 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
55677 | 103442 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
73475 | 103443 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
81028 | 103428 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
83968 | 103448 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 25 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
92337 | 103429 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
100236 | 166794 | Planning Code 138.1 required 2 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 477 Elizabeth St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/30/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774858 | 6003342.48296 | 2102120.18359 | 37.7522107277484 | -122.431319034046 | (37.7522107277484, -122.431319034046) | 2 | 4 | 5 | 28862 | 22 | |
111529 | 103439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
122814 | 103435 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
159372 | 103433 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
160032 | 103444 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 21 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
165939 | 103440 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
415 | 190934 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.7526102335912 | -122.390415424833 | (37.7526102335912, -122.390415424833) | 10 | 3 | 8 | 28856 | 1 | |||
4597 | 190929 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | 10 | 3 | 8 | 28856 | 1 | |||
11985 | 206738 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2110 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993654.98108 | 2101316.80215 | 37.7494510717083 | -122.46476131899 | (37.7494510717083, -122.46476131899) | 1 | 8 | 4 | 29491 | 40 | |||
12526 | 206776 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 339 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995718.3884 | 2098491.52687 | 37.7418123157002 | -122.457421671194 | (37.7418123157002, -122.457421671194) | 1 | 8 | 4 | 59 | 40 | |||
17578 | 223163 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 220 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008988.9604 | 2097329.9937 | 37.7393763076577 | -122.411454173775 | (37.7393763076577, -122.411454173775) | 10 | 7 | 7 | 28859 | 2 | |||
19525 | 118867 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 686 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981365.93161 | 2111081.95893 | 37.7755472130957 | -122.507981064387 | (37.7755472130957, -122.507981064387) | 11 | 6 | 2 | 55 | 26 | ||
27356 | 250731 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2745 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986887.59373 | 2114422.31311 | 37.785042671624 | -122.489126191619 | (37.785042671624, -122.489126191619) | 11 | 6 | 1 | 55 | 33 | |||
28323 | 206708 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1926 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991286.95111 | 2102293.22218 | 37.7519952564944 | -122.473021145018 | (37.7519952564944, -122.473021145018) | 1 | 8 | 4 | 29491 | 12 | |||
30310 | 206768 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 24 Merced Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995217.94161 | 2100123.23071 | 37.7462638105263 | -122.459270173693 | (37.7462638105263, -122.459270173693) | 1 | 8 | 4 | 59 | 40 | |||
35038 | 206706 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1479 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991135.60294 | 2105348.51695 | 37.7603755269382 | -122.473767390769 | (37.7603755269382, -122.473767390769) | 1 | 8 | 4 | 56 | 12 | |||
38263 | 206777 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 339 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995709.16123 | 2098486.51672 | 37.7417980290669 | -122.457453213121 | (37.7417980290669, -122.457453213121) | 1 | 8 | 4 | 59 | 40 | |||
46128 | 250798 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 286 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986227.55169 | 2114017.5724 | 37.7838928227399 | -122.491379896287 | (37.7838928227399, -122.491379896287) | 11 | 6 | 1 | 55 | 33 | |||
54697 | 126396 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2667 Vallejo St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000871.5003 | 2117543.41786 | 37.7944187047121 | -122.440970405375 | (37.7944187047121, -122.440970405375) | 13 | 9 | 1 | 57 | 27 | |||
60460 | 206705 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1479 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991135.43811 | 2105372.76647 | 37.7604421001312 | -122.473769729905 | (37.7604421001312, -122.473769729905) | 1 | 8 | 4 | 56 | 12 | |||
74106 | 206774 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995753.2455 | 2098512.7905 | 37.7418727024551 | -122.45730268547 | (37.7418727024551, -122.45730268547) | 1 | 8 | 4 | 59 | 40 | |||
78622 | 206718 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1657 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993687.28793 | 2104194.62736 | 37.7573547032735 | -122.464858568992 | (37.7573547032735, -122.464858568992) | 1 | 8 | 4 | 56 | 12 | |||
85469 | 206717 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1657 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5993684.72511 | 2104231.15464 | 37.7574548499695 | -122.464870084812 | (37.7574548499695, -122.464870084812) | 1 | 8 | 4 | 56 | 12 | |||
89824 | 206754 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1995 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991572.63095 | 2101920.9351 | 37.7509895886981 | -122.472006100028 | (37.7509895886981, -122.472006100028) | 1 | 8 | 4 | 29491 | 12 | |||
92544 | 206775 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5995746.65197 | 2098507.81238 | 37.7418586550653 | -122.457325123553 | (37.7418586550653, -122.457325123553) | 1 | 8 | 4 | 59 | 40 | |||
93536 | 206739 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 496 Pacheco St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993527.20185 | 2101910.60143 | 37.7510741249729 | -122.465246305396 | (37.7510741249729, -122.465246305396) | 1 | 8 | 4 | 29491 | 12 | |||
95607 | 223148 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4280 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6000646.81629 | 2102890.73647 | 37.7541733407507 | -122.440696310003 | (37.7541733407507, -122.440696310003) | 2 | 4 | 5 | 28862 | 22 | |||
108831 | 190930 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.7526299458258 | -122.390038764478 | (37.7526299458258, -122.390038764478) | 10 | 3 | 8 | 28856 | 1 | |||
113904 | 223234 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 593 Sanchez St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003680.49002 | 2104846.13137 | 37.7597146843921 | -122.430344623114 | (37.7597146843921, -122.430344623114) | 2 | 4 | 5 | 28862 | 3 | |||
114294 | 218319 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 401 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993296 | 2099913 | 37.7455758855388 | -122.465900686894 | (37.7455758855388, -122.465900686894) | 1 | 8 | 4 | 29491 | 40 | |||
114299 | 190932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015229.59957 | 2102026.97334 | 37.7526212961411 | -122.390204678629 | (37.7526212961411, -122.390204678629) | 10 | 3 | 8 | 28856 | 1 | |||
117306 | 223239 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 737 Sanchez St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003701.21419 | 2104014.89304 | 37.7574334757786 | -122.430213645836 | (37.7574334757786, -122.430213645836) | 2 | 4 | 5 | 28862 | 3 | |||
122332 | 250812 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Sea View Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986123.54872 | 2114165.24712 | 37.78429221705 | -122.491750577926 | (37.78429221705, -122.491750577926) | 11 | 6 | 1 | 55 | 33 | |||
125211 | 250793 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 291 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986186.21669 | 2113991.39004 | 37.7838185180519 | -122.491520970243 | (37.7838185180519, -122.491520970243) | 11 | 6 | 1 | 55 | 33 | |||
130562 | 250799 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 287 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986184.86396 | 2114012.63209 | 37.7838767635505 | -122.49152721422 | (37.7838767635505, -122.49152721422) | 11 | 6 | 1 | 55 | 33 | |||
135093 | 250730 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2745 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986865.50029 | 2114420.34296 | 37.7850359725789 | -122.489202482009 | (37.7850359725789, -122.489202482009) | 11 | 6 | 1 | 55 | 33 | |||
138721 | 250797 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 286 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986226.59241 | 2114006.99175 | 37.7838637152673 | -122.491382435973 | (37.7838637152673, -122.491382435973) | 11 | 6 | 1 | 55 | 33 | |||
152687 | 223145 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4428 23rd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000417.49081 | 2102293.12791 | 37.7525193903635 | -122.441446492087 | (37.7525193903635, -122.441446492087) | 2 | 4 | 5 | 28862 | 22 | |||
155745 | 206757 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 125 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993771.47174 | 2099572.51825 | 37.7446684258232 | -122.464231877296 | (37.7446684258232, -122.464231877296) | 1 | 8 | 4 | 29491 | 40 | |||
156772 | 206736 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 778 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5994913.66935 | 2093209.24182 | 37.7272622013836 | -122.459821566928 | (37.7272622013836, -122.459821566928) | 9 | 7 | 4 | 28861 | 40 | |||
162960 | 250813 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Sea View Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986113.64494 | 2114167.67929 | 37.7842983162539 | -122.491785020157 | (37.7842983162539, -122.491785020157) | 11 | 6 | 1 | 55 | 33 | |||
163032 | 206737 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2110 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993674.35078 | 2101279.72748 | 37.7493503908303 | -122.46469164671 | (37.7493503908303, -122.46469164671) | 1 | 8 | 4 | 29491 | 40 | |||
166053 | 176079 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1183 Munich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001144.67239 | 2087111.03395 | 37.7108742640178 | -122.437844474361 | (37.7108742640178, -122.437844474361) | 9 | 7 | 6 | 28861 | 5 | |||
166719 | 190933 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) | 10 | 3 | 8 | 28856 | 1 | |||
169045 | 250635 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 194 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5987172.85547 | 2114685.13825 | 37.7857809601798 | -122.488158609233 | (37.7857809601798, -122.488158609233) | 11 | 6 | 1 | 55 | 33 | |||
170928 | 250890 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 236 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986835.39418 | 2114381.01597 | 37.7849262346079 | -122.489303745667 | (37.7849262346079, -122.489303745667) | 11 | 6 | 1 | 55 | 33 | |||
180455 | 190931 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | 10 | 3 | 8 | 28856 | 1 | |||
186431 | 250925 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 275 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5987109.38515 | 2114117.08948 | 37.7842175580435 | -122.488336434905 | (37.7842175580435, -122.488336434905) | 11 | 6 | 1 | 55 | 33 | |||
192481 | 223233 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 593 Sanchez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003682.6043 | 2104832.57907 | 37.7596775927725 | -122.430336343952 | (37.7596775927725, -122.430336343952) | 2 | 4 | 5 | 28862 | 3 | |||
22791 | 126391 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Clay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5997748.40757 | 2115473.64195 | 37.7885572815394 | -122.451627258297 | (37.7885572815394, -122.451627258297) | 11 | 6 | 1 | 54 | 31 | |||
97957 | 206722 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1754 08th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 5993756.80333 | 2103555.38299 | 37.7556035110194 | -122.464571743692 | (37.7556035110194, -122.464571743692) | 1 | 8 | 4 | 56 | 12 | |||
120140 | 126392 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Clay St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5997736.75757 | 2115472.45394 | 37.7885533524009 | -122.451667479589 | (37.7885533524009, -122.451667479589) | 11 | 6 | 1 | 54 | 31 | |||
163209 | 206723 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1754 08th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 2ft | 5993756.65127 | 2103543.92939 | 37.7555720536195 | -122.464571437933 | (37.7555720536195, -122.464571437933) | 1 | 8 | 4 | 56 | 12 | |||
646 | 223229 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3856 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6004052.87626 | 2102494.4926 | 37.7532787266382 | -122.428889066793 | (37.7532787266382, -122.428889066793) | 2 | 4 | 5 | 28862 | 22 | |||
1016 | 84387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012577.97369 | 2099023.613 | 37.7442272813575 | -122.399163722146 | (37.7442272813575, -122.399163722146) | 10 | 3 | 8 | 58 | 1 | |||
1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
1593 | 259756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1523 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015921.70632 | 2096895.74231 | 37.7385703600528 | -122.387453298811 | (37.7385703600528, -122.387453298811) | 10 | 3 | 8 | 58 | 1 | |||
1780 | 223125 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1105 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009223.64941 | 2102625.89478 | 37.7539308430518 | -122.411016683293 | (37.7539308430518, -122.411016683293) | 2 | 4 | 7 | 28859 | 19 | |||
1820 | 223236 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4537 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787681 | 6001259.34989 | 2104046.86599 | 37.7573826560002 | -122.438660858237 | (37.7573826560002, -122.438660858237) | 2 | 4 | 5 | 28862 | 3 | |
1861 | 65043 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 744 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 26096 | 5982313.7707 | 2110666.72217 | 37.7744628966917 | -122.504671542451 | (37.7744628966917, -122.504671542451) | 11 | 6 | 2 | 55 | 26 | ||
2625 | 161272 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 562 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:33:00 PM | 3 | Width 0ft | 6002894.24566 | 2090355.62698 | 37.719882537321 | -122.432029089275 | (37.719882537321, -122.432029089275) | 9 | 7 | 6 | 28861 | 5 | |
3123 | 261802 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2319 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986356 | 2099450 | 37.7439018196285 | -122.489863769411 | (37.7439018196285, -122.489863769411) | 1 | 8 | 3 | 29491 | 35 | ||
3357 | 223122 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 148 Ellert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007428.54288 | 2096958.74229 | 37.7382692862941 | -122.416823127285 | (37.7382692862941, -122.416823127285) | 2 | 7 | 7 | 28859 | 2 | |||
3902 | 223217 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1191 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003256 | 2101366 | 37.75013501563 | -122.431564267794 | (37.75013501563, -122.431564267794) | 2 | 4 | 5 | 28862 | 22 | |||
4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
4149 | 169685 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2585 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002269.97794 | 2096798.3861 | 37.7375374800648 | -122.43464741415 | (37.7375374800648, -122.43464741415) | 2 | 7 | 5 | 63 | 7 | |||
4325 | 261136 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4200 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | 3x3 | 6003439 | 2093988 | 37.729887093701 | -122.43040509359 | (37.729887093701, -122.43040509359) | 9 | 7 | 6 | 28861 | 25 | ||
4450 | 95446 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.492093817749 | (37.7458386996409, -122.492093817749) | 1 | 8 | 3 | 29491 | 35 |
4742 | 243755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 51 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002062.89469 | 2096349.46794 | 37.7362930962328 | -122.43533129551 | (37.7362930962328, -122.43533129551) | 2 | 7 | 5 | 63 | 7 | |||
4875 | 261114 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
4932 | 37209 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1915 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39775 | 5986283.2112 | 2102182.1445 | 37.7513993005965 | -122.490316396609 | (37.7513993005965, -122.490316396609) | 1 | 8 | 3 | 29491 | 35 | |
5030 | 171365 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002871.58236 | 2093130.52409 | 37.7275005001327 | -122.432305504906 | (37.7275005001327, -122.432305504906) | 9 | 7 | 6 | 28861 | 5 | ||
5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
5755 | 261117 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
5995 | 258380 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
6222 | 180532 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 401 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 15 | Width 4ft | 6002770.13876 | 2090966.12434 | 37.7215517905727 | -122.432501665928 | (37.7215517905727, -122.432501665928) | 9 | 7 | 6 | 28861 | 5 | ||
6277 | 223139 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 512 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001868.53101 | 2100910.74029 | 37.7488062416211 | -122.43632963112 | (37.7488062416211, -122.43632963112) | 2 | 4 | 5 | 28862 | 22 | |||
6305 | 223216 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1199 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6003236.71936 | 2101328.34532 | 37.7500305318879 | -122.431628253337 | (37.7500305318879, -122.431628253337) | 2 | 4 | 5 | 28862 | 22 | |||
6349 | 78274 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1715 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013961.91267 | 2093099.05364 | 37.7280366912377 | -122.393963673903 | (37.7280366912377, -122.393963673903) | 10 | 3 | 8 | 58 | 1 | |||
6404 | 73766 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3834 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996504.18251 | 2114976.06965 | 37.7871197485358 | -122.45589607746 | (37.7871197485358, -122.45589607746) | 11 | 6 | 1 | 54 | 31 | |||
6544 | 223185 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
6879 | 223230 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3856 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780428 | 6004041.47078 | 2102494.505 | 37.7532781151154 | -122.428928510165 | (37.7532781151154, -122.428928510165) | 2 | 4 | 5 | 28862 | 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );