trees
713 rows where qSpecies_id = 102 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 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 | ||
| 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 |
| 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 | |
| 8633 | 264870 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1674 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985361 | 2103822 | 37.755847989753 | -122.493626286002 | (37.755847989753, -122.493626286002) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 12137 | 48604 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 45 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45912 | 5994629.49748523 | 2098086.8895364 | 37.7406386779703 | -122.461157347766 | (37.7406386779703, -122.461157347766) | 1 | 8 | 4 | 59 | 40 | ||
| 12195 | 206712 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993729.968 | 2103029.70657 | 37.7541585918487 | -122.464626378423 | (37.7541585918487, -122.464626378423) | 1 | 8 | 4 | 56 | 12 | |||
| 12296 | 206714 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993663.54553 | 2103899.42942 | 37.7565427971281 | -122.464919240823 | (37.7565427971281, -122.464919240823) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 16997 | 38011 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2537 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40222 | 5991707.38932153 | 2098162.62971781 | 37.7406780464622 | -122.471266299952 | (37.7406780464622, -122.471266299952) | 1 | 8 | 4 | 29491 | 40 | ||
| 17766 | 94165 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53528 | 5993721 | 2103904 | 37.7565586593184 | -122.46472087623 | (37.7565586593184, -122.46472087623) | 1 | 8 | 4 | 56 | 12 | ||
| 22064 | 113315 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2493x 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984243.3692 | 2098259.1068 | 37.7405083669922 | -122.497080760951 | (37.7405083669922, -122.497080760951) | 1 | 8 | 3 | 29491 | 35 | |||
| 23893 | 206710 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5991484.15293 | 2106105.9073 | 37.7624753009047 | -122.472617151554 | (37.7624753009047, -122.472617151554) | 1 | 8 | 11 | 56 | 12 | |||
| 24421 | 206756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991004.48671 | 2100128.5419 | 37.7460352505192 | -122.473840030798 | (37.7460352505192, -122.473840030798) | 1 | 8 | 4 | 29491 | 40 | |||
| 25089 | 206711 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1366 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991481.24454 | 2106127.13421 | 37.7625334160042 | -122.472628758222 | (37.7625334160042, -122.472628758222) | 1 | 8 | 11 | 56 | 12 | |||
| 26030 | 206732 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2430 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991403.39763 | 2098862.37414 | 37.7425817765239 | -122.472368375716 | (37.7425817765239, -122.472368375716) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 36656 | 50121 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 251 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46844 | 5992306.20915001 | 2097823.24522432 | 37.7397808029858 | -122.469171133031 | (37.7397808029858, -122.469171133031) | 1 | 8 | 4 | 59 | 40 | ||
| 36830 | 206713 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1835 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993730.54086 | 2103003.335 | 37.7540862153215 | -122.464622482542 | (37.7540862153215, -122.464622482542) | 1 | 8 | 4 | 56 | 12 | |||
| 37595 | 206755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991006.69103 | 2100092.27446 | 37.7459357971944 | -122.473829763244 | (37.7459357971944, -122.473829763244) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 39701 | 206703 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1917 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5990930.40398 | 2102318.91188 | 37.75204514457 | -122.474255998729 | (37.75204514457, -122.474255998729) | 1 | 8 | 4 | 29491 | 12 | |||
| 41560 | 206719 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5992799.45091 | 2104376.41203 | 37.757802607033 | -122.467942255237 | (37.757802607033, -122.467942255237) | 1 | 8 | 4 | 56 | 12 | |||
| 44807 | 121103 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.472603569045 | (37.7623789807661, -122.472603569045) | 1 | 8 | 11 | 56 | 12 | |||
| 48363 | 206721 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1750 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993757.43392 | 2103566.80164 | 37.7556349000417 | -122.464570392019 | (37.7556349000417, -122.464570392019) | 1 | 8 | 4 | 56 | 12 | |||
| 48742 | 206724 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1758 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993757.36857 | 2103534.87932 | 37.7555472458103 | -122.464568300197 | (37.7555472458103, -122.464568300197) | 1 | 8 | 4 | 56 | 12 | |||
| 51473 | 206731 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2272 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991055.69121 | 2099958.73625 | 37.745571973779 | -122.473650589497 | (37.745571973779, -122.473650589497) | 1 | 8 | 4 | 29491 | 40 | |||
| 54230 | 206707 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991123.15013 | 2104471.83436 | 37.7579676676953 | -122.473746503093 | (37.7579676676953, -122.473746503093) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 80583 | 206720 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1734 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993752.64886 | 2103670.20251 | 37.7559185363224 | -122.464594447978 | (37.7559185363224, -122.464594447978) | 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 | |||
| 90628 | 206715 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993624.37216 | 2103900.25206 | 37.7565427971383 | -122.465054774977 | (37.7565427971383, -122.465054774977) | 1 | 8 | 4 | 56 | 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 | |||
| 95147 | 50072 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46803 | 5991378.06178128 | 2098242.3918878 | 37.7408779976528 | -122.47241079131 | (37.7408779976528, -122.47241079131) | 1 | 8 | 4 | 29491 | 40 | ||
| 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 | |||
| 99071 | 206730 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 115 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993913.80681 | 2104584.90061 | 37.7584393504094 | -122.46410351439 | (37.7584393504094, -122.46410351439) | 1 | 8 | 4 | 56 | 12 | |||
| 99187 | 48603 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 45 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45912 | 5994629.49748523 | 2098086.8895364 | 37.7406386779703 | -122.461157347766 | (37.7406386779703, -122.461157347766) | 1 | 8 | 4 | 59 | 40 | ||
| 105472 | 41834 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42219 | 5991486.44352722 | 2106096.79372587 | 37.7624504100425 | -122.472608564807 | (37.7624504100425, -122.472608564807) | 1 | 8 | 11 | 56 | 12 | ||
| 106431 | 94167 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53528 | 5993721 | 2103904 | 37.7565586593184 | -122.46472087623 | (37.7565586593184, -122.46472087623) | 1 | 8 | 4 | 56 | 12 | ||
| 107244 | 206733 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 455 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993506.7952 | 2099451.53822 | 37.7443209862166 | -122.46513828423 | (37.7443209862166, -122.46513828423) | 1 | 8 | 4 | 29491 | 40 | |||
| 107812 | 206734 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992377.97144 | 2098072.2993 | 37.7404687888048 | -122.468941131337 | (37.7404687888048, -122.468941131337) | 1 | 8 | 4 | 59 | 40 | |||
| 109399 | 88090 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1875 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51093 | 5984391.2 | 2102428.5 | 37.7519650432303 | -122.49687727463 | (37.7519650432303, -122.49687727463) | 1 | 8 | 3 | 56 | 35 | |||
| 114238 | 206716 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1418 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991169.70618 | 2105739.42575 | 37.7614508337096 | -122.473677961264 | (37.7614508337096, -122.473677961264) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 119225 | 113317 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2497x 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984244.6688 | 2098225.7519 | 37.7404168596308 | -122.497073806106 | (37.7404168596308, -122.497073806106) | 1 | 8 | 3 | 29491 | 35 | |||
| 122510 | 95097 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | Permit Number 54031 | 5993663.8 | 2099799.9 | 37.7452865520346 | -122.464620689927 | (37.7452865520346, -122.464620689927) | 1 | 8 | 4 | 29491 | 40 | |||
| 124761 | 206728 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 121 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993876.34057 | 2104584.05137 | 37.7584348592037 | -122.464233026658 | (37.7584348592037, -122.464233026658) | 1 | 8 | 4 | 56 | 12 | |||
| 131760 | 54775 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | Permit Number 10624 | 5994314.61016028 | 2105461.58404027 | 37.7608695883517 | -122.462780967251 | (37.7608695883517, -122.462780967251) | 1 | 5 | 11 | 56 | 12 | |||
| 137567 | 206729 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 121 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993888.8383 | 2104584.77031 | 37.7584375535646 | -122.464189856478 | (37.7584375535646, -122.464189856478) | 1 | 8 | 4 | 56 | 12 | |||
| 148278 | 98833 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
| 154602 | 206735 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 251 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992283.73753 | 2097815.15281 | 37.7397572847581 | -122.469248240839 | (37.7397572847581, -122.469248240839) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 163598 | 206725 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1758 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993757.65716 | 2103519.81492 | 37.7555058994863 | -122.464566208375 | (37.7555058994863, -122.464566208375) | 1 | 8 | 4 | 56 | 12 | |||
| 170589 | 48015 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45737 | 5991376.23311352 | 2098294.58385123 | 37.741021197596 | -122.472420918053 | (37.741021197596, -122.472420918053) | 1 | 8 | 4 | 29491 | 40 | ||
| 176727 | 95098 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | Permit Number 54031 | 5993663.8 | 2099799.9 | 37.7452865520346 | -122.464620689927 | (37.7452865520346, -122.464620689927) | 1 | 8 | 4 | 29491 | 40 | |||
| 182091 | 32300 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2367 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 1 | Permit Number 36876 | 5986385.4755 | 2099136.6325 | 37.7430431173924 | -122.489738810464 | (37.7430431173924, -122.489738810464) | 1 | 8 | 3 | 29491 | 35 | ||
| 185783 | 206726 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 127 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993852.03575 | 2104584.23438 | 37.7584339607877 | -122.464317096167 | (37.7584339607877, -122.464317096167) | 1 | 8 | 4 | 56 | 12 | |||
| 186629 | 206709 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1374 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991483.07743 | 2106081.42222 | 37.7624080091318 | -122.472619086012 | (37.7624080091318, -122.472619086012) | 1 | 8 | 11 | 56 | 12 | |||
| 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 | |||
| 193348 | 113316 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2495x 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984244.2356 | 2098243.5123 | 37.7404655994923 | -122.497076614535 | (37.7404655994923, -122.497076614535) | 1 | 8 | 3 | 29491 | 35 | |||
| 193388 | 206704 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5990936.99476 | 2102144.66077 | 37.7515670784743 | -122.474220493479 | (37.7515670784743, -122.474220493479) | 1 | 8 | 4 | 29491 | 12 | |||
| 193674 | 206727 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 127 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993862.54978 | 2104584.34087 | 37.7584348592109 | -122.46428074199 | (37.7584348592109, -122.46428074199) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | |
| 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 | |||
| 7023 | 261112 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 2 | 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 | |
| 7113 | 51366 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.99112 | 2094669.44393 | 37.7323598375173 | -122.393378385216 | (37.7323598375173, -122.393378385216) | 10 | 3 | 8 | 58 | 1 |
| 7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
| 8049 | 51364 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.7321976609735 | -122.393416939157 | (37.7321976609735, -122.393416939157) | 10 | 3 | 8 | 58 | 1 |
| 8494 | 261111 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 1 | 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 | |
| 9100 | 84393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6012494.05335 | 2099085.01558 | 37.7443912025977 | -122.399458212338 | (37.7443912025977, -122.399458212338) | 10 | 3 | 8 | 58 | 1 | |||
| 11533 | 259758 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1547 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015798.86195 | 2096987.35115 | 37.7388150947049 | -122.387884430038 | (37.7388150947049, -122.387884430038) | 10 | 3 | 8 | 58 | 1 | |||
| 13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
| 13398 | 51356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.02379 | 37.7325213440762 | -122.393341524701 | (37.7325213440762, -122.393341524701) | 10 | 3 | 8 | 58 | 1 |
| 13909 | 261115 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 5 | 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 | |
| 14040 | 190944 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6014004.94796 | 2095137.53702 | 37.7336363433234 | -122.393957536921 | (37.7336363433234, -122.393957536921) | 10 | 3 | 8 | 58 | 1 | |||
| 15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
| 15179 | 261113 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 3 | 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 | |
| 16303 | 261116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 6 | 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 | |
| 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 | |||
| 17734 | 47651 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 363 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 4 | Permit Number 45455 | 6012960.30928 | 2105372.99833 | 37.761682620471 | -122.3982870765 | (37.761682620471, -122.3982870765) | 10 | 3 | 8 | 28856 | 29 | |
| 18209 | 78205 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014348.06009 | 2094265.06475 | 37.7312597751042 | -122.392710275271 | (37.7312597751042, -122.392710275271) | 10 | 3 | 8 | 58 | 1 | |||
| 18431 | 51369 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889599 | (37.7324395857978, -122.39335889599) | 10 | 3 | 8 | 58 | 1 |
| 24718 | 190936 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012268.87212 | 2103730.35281 | 37.7571337389375 | -122.400563099634 | (37.7571337389375, -122.400563099634) | 10 | 3 | 8 | 28856 | 29 | |||
| 35923 | 40727 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2002 12:00:00 AM | Permit Number 41706 | 6008971.38235478 | 2097242.21876487 | 37.7391343108464 | -122.411508751405 | (37.7391343108464, -122.411508751405) | 10 | 7 | 7 | 28859 | 2 |
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) );