trees
256 rows where qSpecies_id = 151 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14127 | 45367 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 546 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44192 | 6007805.03016333 | 2096352.99475391 | 37.7366272057089 | -122.415478542826 | (37.7366272057089, -122.415478542826) | 2 | 7 | 7 | 28859 | 2 | ||
16063 | 231976 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3670 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003921.45543 | 2103072.93083 | 37.7548595423439 | -122.42938479289 | (37.7548595423439, -122.42938479289) | 2 | 4 | 5 | 28862 | 22 | |||
22314 | 231968 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 177 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004880.9264 | 2095958.67753 | 37.735379707894 | -122.425560380023 | (37.735379707894, -122.425560380023) | 2 | 7 | 5 | 28861 | 2 | |||
25935 | 66407 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29534 | 6008039.98859373 | 2096389.06187115 | 37.7367394418447 | -122.414668739511 | (37.7367394418447, -122.414668739511) | 2 | 7 | 7 | 28859 | 2 | ||
30587 | 47753 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 70 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/2003 12:00:00 AM | Permit Number 45532 | 6000951.94406001 | 2101308.28424915 | 37.7498456794841 | -122.439527672975 | (37.7498456794841, -122.439527672975) | 2 | 4 | 5 | 28862 | 22 | ||
32169 | 231956 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 162 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004841.81484 | 2095922.14472 | 37.7352771869788 | -122.425693003951 | (37.7352771869788, -122.425693003951) | 2 | 7 | 5 | 28861 | 2 | |||
32738 | 66930 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30252 | 6007535.74955777 | 2097703.77171349 | 37.7403210020284 | -122.41650521811 | (37.7403210020284, -122.41650521811) | 2 | 7 | 7 | 28859 | 2 | ||
34596 | 66400 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 531 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29526 | 6007491.7583768 | 2096409.40123315 | 37.7367644721833 | -122.416565655603 | (37.7367644721833, -122.416565655603) | 2 | 7 | 7 | 28859 | 2 | ||
42735 | 63835 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 480 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24525 | 6007455.04270761 | 2096578.56376841 | 37.737226890345 | -122.416704578376 | (37.737226890345, -122.416704578376) | 2 | 7 | 7 | 28859 | 2 | ||
45505 | 231972 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003745.92075 | 2101014.04618 | 37.7491963890986 | -122.429844992161 | (37.7491963890986, -122.429844992161) | 2 | 4 | 5 | 28862 | 22 | |||
45973 | 231978 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3813 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004168.45878 | 2105381.57202 | 37.7612125052624 | -122.428695150486 | (37.7612125052624, -122.428695150486) | 2 | 4 | 5 | 28862 | 3 | |||
51034 | 64836 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 420 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1989 12:00:00 AM | Permit Number 25845 | 6003164.08916748 | 2099517.74214557 | 37.745054922078 | -122.431750153289 | (37.745054922078, -122.431750153289) | 2 | 7 | 5 | 63 | 22 | ||
51644 | 64810 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 718 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25813 | 6001878.33374757 | 2099742.03375236 | 37.7455978068181 | -122.436212108036 | (37.7455978068181, -122.436212108036) | 2 | 7 | 5 | 63 | 22 | ||
53579 | 66397 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 508 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29523 | 6007446.33784222 | 2096483.57459282 | 37.7369655813708 | -122.416727947771 | (37.7369655813708, -122.416727947771) | 2 | 7 | 7 | 28859 | 2 | ||
58332 | 231961 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007544.54493 | 2097042.23546 | 37.7385050642556 | -122.416427960701 | (37.7385050642556, -122.416427960701) | 2 | 7 | 7 | 28859 | 2 | |||
63053 | 63989 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 445 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24735 | 6002297.0656458 | 2100886.57142057 | 37.7487642194423 | -122.434846033464 | (37.7487642194423, -122.434846033464) | 2 | 4 | 5 | 28862 | 22 | ||
64919 | 65535 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3811 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1996 12:00:00 AM | Permit Number 28426 | 6004188.15426377 | 2105377.14964975 | 37.7612014771427 | -122.428626716937 | (37.7612014771427, -122.428626716937) | 2 | 4 | 5 | 28862 | 3 | ||
66509 | 67173 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 308 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30617 | 6006778.80431339 | 2096277.81486238 | 37.7363630429498 | -122.419021324056 | (37.7363630429498, -122.419021324056) | 2 | 7 | 7 | 28859 | 2 | ||
67640 | 66893 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30211 | 6007590.04442076 | 2097728.05974103 | 37.7403907448612 | -122.416319207408 | (37.7403907448612, -122.416319207408) | 2 | 7 | 7 | 28859 | 2 | ||
68621 | 64828 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 268 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25837 | 6004831.1974382 | 2099031.73640655 | 37.7438148210139 | -122.425950995798 | (37.7438148210139, -122.425950995798) | 2 | 7 | 5 | 63 | 22 | ||
70776 | 49472 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3330@ VALENCIA 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/2003 12:00:00 AM | Permit Number 46397 | 6006124.66921915 | 2103195.53921104 | 37.7553206868527 | -122.421774162179 | (37.7553206868527, -122.421774162179) | 2 | 4 | 5 | 28859 | 19 | ||
71484 | 66923 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 196 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30244 | 6007541.39171999 | 2097769.00500385 | 37.740500435503 | -122.416490329324 | (37.740500435503, -122.416490329324) | 2 | 7 | 7 | 28859 | 2 | ||
74527 | 231974 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004099.54085 | 2102284.63466 | 37.7527051471301 | -122.428712732201 | (37.7527051471301, -122.428712732201) | 2 | 4 | 5 | 28862 | 22 | |||
77589 | 63838 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 310 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24529 | 6007512.21907746 | 2097215.58579661 | 37.7389792281053 | -122.416552004438 | (37.7389792281053, -122.416552004438) | 2 | 7 | 7 | 28859 | 2 | ||
79837 | 65256 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1059 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28055 | 6009469.52961682 | 2103013.30669194 | 37.7550083744364 | -122.410193718367 | (37.7550083744364, -122.410193718367) | 2 | 4 | 7 | 28859 | 19 | ||
91294 | 231963 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007553.14308 | 2097114.00894 | 37.7387026219233 | -122.416403314785 | (37.7387026219233, -122.416403314785) | 2 | 7 | 7 | 28859 | 2 | |||
96084 | 64067 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 666 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1987 12:00:00 AM | Permit Number 24827 | 6002225.57771541 | 2098886.88816265 | 37.7432695004337 | -122.434950246577 | (37.7432695004337, -122.434950246577) | 2 | 7 | 5 | 63 | 22 | ||
98619 | 67938 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 86 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31651 | 6004312.01802966 | 2095698.91217619 | 37.7346342889879 | -122.427508808325 | (37.7346342889879, -122.427508808325) | 2 | 7 | 5 | 28861 | 2 | ||
98723 | 231959 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007536.6214 | 2096940.11899 | 37.7382242293514 | -122.416448125283 | (37.7382242293514, -122.416448125283) | 2 | 7 | 7 | 28859 | 2 | |||
99696 | 66392 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 736 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29518 | 6007726.21493711 | 2095490.25955401 | 37.7342538931553 | -122.41568997407 | (37.7342538931553, -122.41568997407) | 2 | 7 | 7 | 28859 | 2 | ||
99971 | 231960 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007542.74737 | 2097017.75117 | 37.7384377347063 | -122.416432442006 | (37.7384377347063, -122.416432442006) | 2 | 7 | 7 | 28859 | 2 | |||
100849 | 67916 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 28 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31626 | 6003939.73244877 | 2095599.86834432 | 37.7343412731947 | -122.428788866832 | (37.7343412731947, -122.428788866832) | 2 | 7 | 5 | 28861 | 25 | ||
105022 | 231981 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 91 Clover Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6000469.66557 | 2104934.36895 | 37.7597745666642 | -122.441455575241 | (37.7597745666642, -122.441455575241) | 2 | 4 | 5 | 28862 | 3 | |||
106210 | 231953 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006489.5205 | 2105029.86683 | 37.7603778930513 | -122.420642603769 | (37.7603778930513, -122.420642603769) | 2 | 4 | 7 | 28859 | 19 | |||
106979 | 231966 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007085.27173 | 2097974.9068 | 37.7410401344022 | -122.418082011786 | (37.7410401344022, -122.418082011786) | 2 | 7 | 7 | 28859 | 2 | |||
113343 | 113820 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
118692 | 63718 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 239 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24383 | 6007990.36372433 | 2100292.13143731 | 37.7474536189761 | -122.415116506714 | (37.7474536189761, -122.415116506714) | 2 | 7 | 7 | 28859 | 2 | ||
123360 | 63780 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 220 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/11/1995 12:00:00 AM | Permit Number 24461 | 6003691.42811687 | 2101600.49522177 | 37.7508035549005 | -122.430075258307 | (37.7508035549005, -122.430075258307) | 2 | 4 | 5 | 28862 | 22 | ||
123369 | 45291 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 678 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2005 12:00:00 AM | Permit Number 47958 | 6007614.60724398 | 2096238.5150245 | 37.7363021643783 | -122.416128813466 | (37.7363021643783, -122.416128813466) | 2 | 7 | 7 | 28859 | 2 | ||
124362 | 231967 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 36 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005715.33692 | 2097471.12412 | 37.7395796596638 | -122.422782959663 | (37.7395796596638, -122.422782959663) | 2 | 7 | 7 | 28859 | 2 | |||
125461 | 64589 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3350 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25490 | 6006008.81445181 | 2103189.70066891 | 37.7552981215573 | -122.422174408546 | (37.7552981215573, -122.422174408546) | 2 | 4 | 5 | 28859 | 19 | ||
127670 | 45284 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 541 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44126 | 6008215.69383326 | 2096339.71567531 | 37.7366138182396 | -122.414057758062 | (37.7366138182396, -122.414057758062) | 2 | 7 | 7 | 28859 | 2 | ||
128399 | 66439 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29583 | 6006068.54082746 | 2096076.77967326 | 37.7357710232065 | -122.421462732945 | (37.7357710232065, -122.421462732945) | 2 | 7 | 7 | 28859 | 2 | ||
129396 | 64627 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 120 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25536 | 6005377.18111658 | 2103001.16489201 | 37.7547447992353 | -122.424345378751 | (37.7547447992353, -122.424345378751) | 2 | 4 | 5 | 28859 | 19 | ||
131393 | 64147 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1620 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24926 | 6003320.75004876 | 2098798.13825464 | 37.7430879358174 | -122.431157094729 | (37.7430879358174, -122.431157094729) | 2 | 7 | 5 | 63 | 22 | ||
131792 | 67823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31479 | 6004089.22123214 | 2102351.15512092 | 37.7528872126598 | -122.428753160983 | (37.7528872126598, -122.428753160983) | 2 | 4 | 5 | 28862 | 22 | ||
135798 | 231954 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 215 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6006180.99637 | 2101867.22963 | 37.751676631191 | -122.421485034734 | (37.751676631191, -122.421485034734) | 2 | 4 | 5 | 28859 | 19 | |||
136826 | 60207 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3338 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | 7 | Permit Number 19754 | 6007475 | 2101539 | 37.7508482631719 | -122.416986935836 | (37.7508482631719, -122.416986935836) | 2 | 4 | 7 | 28859 | 19 | |
137851 | 66928 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 160 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30250 | 6007554.42782644 | 2097919.72536023 | 37.7409150133245 | -122.416455928807 | (37.7409150133245, -122.416455928807) | 2 | 7 | 7 | 28859 | 2 | ||
144291 | 66433 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 29576 | 6005529.27345058 | 2096644.50573799 | 37.7372994514328 | -122.423367539465 | (37.7372994514328, -122.423367539465) | 2 | 7 | 7 | 28859 | 2 | ||
146596 | 231950 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 703 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007343.45792 | 2103120.91973 | 37.7551844539259 | -122.417553926284 | (37.7551844539259, -122.417553926284) | 2 | 4 | 7 | 28859 | 19 | |||
148871 | 63880 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 883 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24586 | 6003774.19132667 | 2103145.47595377 | 37.7550503955524 | -122.429899247451 | (37.7550503955524, -122.429899247451) | 2 | 4 | 5 | 28862 | 22 | ||
152389 | 231973 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 120 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 3ft | 6004325.56331 | 2101629.44898 | 37.7509189496627 | -122.427884424232 | (37.7509189496627, -122.427884424232) | 2 | 4 | 5 | 28862 | 22 | |||
152979 | 59014 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3758 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38904 | 6005263.8024452 | 2104318.31785235 | 37.7583549902775 | -122.424831174315 | (37.7583549902775, -122.424831174315) | 2 | 4 | 5 | 28859 | 19 | ||
158729 | 55509 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50811 | 6001116.15615012 | 2104674.38897878 | 37.7590975343523 | -122.439201053877 | (37.7590975343523, -122.439201053877) | 2 | 4 | 5 | 28862 | 3 | ||
159201 | 231947 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.7371279405099 | -122.425105073942 | (37.7371279405099, -122.425105073942) | 2 | 7 | 5 | 28859 | 2 | |||
159388 | 66895 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 168 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30213 | 6007551.53091374 | 2097886.23194596 | 37.7408228849183 | -122.4164635734 | (37.7408228849183, -122.4164635734) | 2 | 7 | 7 | 28859 | 2 | ||
161821 | 231948 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 365 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6007200.80171 | 2096289.89745 | 37.7364199734891 | -122.417563155128 | (37.7364199734891, -122.417563155128) | 2 | 7 | 7 | 28859 | 2 | |||
162661 | 231970 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 541 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001866.38418 | 2102721.13376 | 37.7537770283888 | -122.436466612253 | (37.7537770283888, -122.436466612253) | 2 | 4 | 5 | 28862 | 22 | |||
163588 | 63364 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 103 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30639 | 6006732.73114879 | 2096957.82345997 | 37.7382276012884 | -122.419228840922 | (37.7382276012884, -122.419228840922) | 2 | 7 | 7 | 28859 | 2 | ||
164763 | 66919 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 256 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | 3x3 | Permit Number 30240 | 6007515.01387925 | 2097464.03098478 | 37.7396615608777 | -122.416559935715 | (37.7396615608777, -122.416559935715) | 2 | 7 | 7 | 28859 | 2 | |
166161 | 63980 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3666 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24720 | 6003941.47141404 | 2103077.78156468 | 37.7548739945164 | -122.429315917927 | (37.7548739945164, -122.429315917927) | 2 | 4 | 5 | 28862 | 22 | ||
166925 | 62359 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 183 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31493 | 6004713.1576588 | 2099557.75082014 | 37.7452524642677 | -122.426396594795 | (37.7452524642677, -122.426396594795) | 2 | 7 | 5 | 63 | 22 | ||
167461 | 63972 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1987 12:00:00 AM | 6002987.03604686 | 2100924.44853758 | 37.7489073707234 | -122.432462826172 | (37.7489073707234, -122.432462826172) | 2 | 4 | 5 | 28862 | 22 | |||
167755 | 231969 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 78 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004355.63348 | 2095669.80517 | 37.7345568345381 | -122.427355942145 | (37.7345568345381, -122.427355942145) | 2 | 7 | 5 | 28861 | 2 | |||
168760 | 62861 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 112 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31839 | 6008289.1101765 | 2098063.77851113 | 37.7413518401577 | -122.413925848755 | (37.7413518401577, -122.413925848755) | 2 | 7 | 7 | 28859 | 2 | ||
170715 | 66902 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 280 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30220 | 6007505.06075356 | 2097348.955435 | 37.7393450290906 | -122.416586199821 | (37.7393450290906, -122.416586199821) | 2 | 7 | 7 | 28859 | 2 | ||
171959 | 83375 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 248 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50822 | 5999884.09113954 | 2104832.45906966 | 37.7594613698021 | -122.44347346176 | (37.7594613698021, -122.44347346176) | 2 | 4 | 5 | 28862 | 3 | ||
172297 | 63837 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 443 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24528 | 6007534.27332128 | 2096872.17856811 | 37.7380375478753 | -122.416451432701 | (37.7380375478753, -122.416451432701) | 2 | 7 | 7 | 28859 | 2 | ||
175004 | 231962 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007543.01124 | 2097062.2707 | 37.7385599903583 | -122.416434682233 | (37.7385599903583, -122.416434682233) | 2 | 7 | 7 | 28859 | 2 | |||
177080 | 66906 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 219 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | 20 | 2x5 | Permit Number 30224 | 6007582.57957611 | 2097641.75307421 | 37.7401533460797 | -122.416338906472 | (37.7401533460797, -122.416338906472) | 2 | 7 | 7 | 28859 | 2 |
177128 | 231952 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006488.33791 | 2105047.80636 | 37.7604270841668 | -122.420647967328 | (37.7604270841668, -122.420647967328) | 2 | 4 | 7 | 28859 | 19 | |||
177910 | 59774 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 460 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1991 12:00:00 AM | Permit Number 29632 | 6007462.52860048 | 2096660.25076168 | 37.7374516058806 | -122.416684481311 | (37.7374516058806, -122.416684481311) | 2 | 7 | 7 | 28859 | 2 | ||
178401 | 64628 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 170 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1988 12:00:00 AM | Permit Number 25537 | 6005392.70908858 | 2102720.91068508 | 37.7539761631805 | -122.424271747549 | (37.7539761631805, -122.424271747549) | 2 | 4 | 5 | 28859 | 19 | ||
178945 | 231951 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 171 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006481.13342 | 2105135.05865 | 37.7606662525548 | -122.42067907849 | (37.7606662525548, -122.42067907849) | 2 | 4 | 7 | 28859 | 19 | |||
180622 | 67834 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 614 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31496 | 6001920.673977 | 2099454.66622044 | 37.7448111687463 | -122.43604514265 | (37.7448111687463, -122.43604514265) | 2 | 7 | 5 | 63 | 22 | ||
181556 | 231957 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 643 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001733.38367 | 2099398.81913 | 37.7446471838211 | -122.436688759187 | (37.7446471838211, -122.436688759187) | 2 | 7 | 5 | 63 | 22 | |||
184194 | 63836 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 449 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24527 | 6007531.71339338 | 2096844.47873768 | 37.7379613462812 | -122.416458322142 | (37.7379613462812, -122.416458322142) | 2 | 7 | 7 | 28859 | 2 | ||
186935 | 62942 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 375 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30478 | 6006773.07754365 | 2097002.00015366 | 37.7383511728239 | -122.419092475387 | (37.7383511728239, -122.419092475387) | 2 | 7 | 7 | 28859 | 2 | ||
191295 | 66903 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 228 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30221 | 6007526.62585922 | 2097598.28579286 | 37.7400308479341 | -122.416529293976 | (37.7400308479341, -122.416529293976) | 2 | 7 | 7 | 28859 | 2 | ||
82588 | 66076 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1830 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | Permit Number 29120 | 6008716.78878742 | 2119192.91553026 | 37.7993915237126 | -122.413941412032 | (37.7993915237126, -122.413941412032) | 3 | 1 | 10 | 308 | 32 | ||
156905 | 66086 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 895 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | Permit Number 29130 | 6008704.72380049 | 2119330.26525123 | 37.7997679743153 | -122.413992883013 | (37.7997679743153, -122.413992883013) | 3 | 1 | 10 | 308 | 32 | ||
22799 | 101714 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1240 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006918 | 2119116 | 37.7990791449181 | -122.420160405591 | (37.7990791449181, -122.420160405591) | 5 | 1 | 1 | 28858 | 32 | |||||
119139 | 65406 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 555 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28257 | 6008843.98828556 | 2114419.97110382 | 37.786293329177 | -122.413163568484 | (37.786293329177, -122.413163568484) | 5 | 10 | 9 | 28852 | 36 | ||
80939 | 30723 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 450 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34623 | 6004402.09076898 | 2109822.75168299 | 37.7734201339954 | -122.428203638325 | (37.7734201339954, -122.428203638325) | 7 | 9 | 11 | 28852 | 10 | ||
173277 | 231946 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 301 Webster St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6004139.43859 | 2109828.95399 | 37.7734222994207 | -122.429112631967 | (37.7734222994207, -122.429112631967) | 7 | 9 | 11 | 29492 | 10 | |||
35390 | 60180 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 39 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19713 | 6005845.55661292 | 2105868.08575362 | 37.7626431308333 | -122.422929354207 | (37.7626431308333, -122.422929354207) | 8 | 4 | 5 | 28859 | 19 | ||
42223 | 37689 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | Permit Number 43282 | 6007841.95638313 | 2105703.00432184 | 37.7623023025462 | -122.416012813552 | (37.7623023025462, -122.416012813552) | 8 | 4 | 7 | 28859 | 19 | ||
43366 | 60181 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 45 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19714 | 6005847.32276765 | 2105836.20953391 | 37.7625557059029 | -122.422920980075 | (37.7625557059029, -122.422920980075) | 8 | 4 | 5 | 28859 | 19 | ||
52065 | 60182 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 64 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19715 | 6005801.28958409 | 2105727.07873438 | 37.7622534608678 | -122.423072435179 | (37.7622534608678, -122.423072435179) | 8 | 4 | 5 | 28859 | 19 | ||
125091 | 60178 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 31 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19711 | 6005843.20173996 | 2105910.5873799 | 37.7627596974043 | -122.422940519748 | (37.7627596974043, -122.422940519748) | 8 | 4 | 5 | 28859 | 19 | ||
141071 | 60176 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 19 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19708 | 6005839.66943051 | 2105974.33981931 | 37.7629345472543 | -122.422957268124 | (37.7629345472543, -122.422957268124) | 8 | 4 | 5 | 28859 | 19 | ||
168878 | 60177 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19709 | 6005786.70456433 | 2105990.31461515 | 37.7629754214805 | -122.423141591085 | (37.7629754214805, -122.423141591085) | 8 | 4 | 5 | 28859 | 19 | ||
192447 | 231949 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007831.76681 | 2105714.97927 | 37.7623346100862 | -122.416048903649 | (37.7623346100862, -122.416048903649) | 8 | 4 | 7 | 28859 | 19 | |||
1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
1945 | 44489 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 8 | Permit Number 43794 | 6005364.27294 | 2093438.07689 | 37.7284859970226 | -122.423710107629 | (37.7284859970226, -122.423710107629) | 9 | 7 | 6 | 28861 | 5 | |
9740 | 75309 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | 9 | 7 | 6 | 28861 | 5 | ||
16040 | 78382 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 606 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001696.66297 | 2089972.42102 | 37.7187623714737 | -122.436141300492 | (37.7187623714737, -122.436141300492) | 9 | 7 | 6 | 28861 | 5 | ||||
16439 | 67516 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 327 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31052 | 5997915.17390153 | 2093778.82856929 | 37.7289983088646 | -122.449486452558 | (37.7289983088646, -122.449486452558) | 9 | 7 | 4 | 28861 | 40 | ||
18805 | 78255 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 512 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001977.46264 | 2090420.81734 | 37.7200095171006 | -122.435202744616 | (37.7200095171006, -122.435202744616) | 9 | 7 | 6 | 28861 | 5 |
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) );