trees
256 rows where qSpecies_id = 151 sorted by Supervisor 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
43590 | 66306 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 311 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29421 | 6000730.96676364 | 2094981.50970271 | 37.7324612706981 | -122.439838262312 | (37.7324612706981, -122.439838262312) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||
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 | ||
60513 | 66307 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 312 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29422 | 6000783.0417172 | 2094985.88569991 | 37.7324762502781 | -122.439658540918 | (37.7324762502781, -122.439658540918) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||
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 | ||
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 | |||
87351 | 67921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31632 | 6004231.25027354 | 2095231.88967626 | 37.7333473817874 | -122.427754784883 | (37.7333473817874, -122.427754784883) | 9 | 7 | 5 | 28861 | 25 | ||
91979 | 66308 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 324 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29423 | 6000783.52973512 | 2095017.02999143 | 37.7325617930594 | -122.439659085695 | (37.7325617930594, -122.439659085695) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||
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 | ||
103700 | 66325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29444 | 6000554.87735499 | 2095194.20587313 | 37.7330352599042 | -122.440462292733 | (37.7330352599042, -122.440462292733) | 9 | 7 | 5 | 63 | 40 | ||
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 | |||
111329 | 67925 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31638 | 6003735.12063535 | 2095135.9515003 | 37.7330558796375 | -122.42946320321 | (37.7330558796375, -122.42946320321) | 9 | 7 | 5 | 28861 | 25 | ||
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 | ||
115628 | 66305 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 309 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29420 | 6000730.88542732 | 2094976.31898746 | 37.7324470135678 | -122.439838171481 | (37.7324470135678, -122.439838171481) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||
124678 | 231980 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 48 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002629.60405 | 2105594.78534 | 37.7617107251998 | -122.434032629514 | (37.7617107251998, -122.434032629514) | 15 | 4 | 5 | 28862 | 3 | |||
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 | ||
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 | ||
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 | |||
137787 | 104161 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 ALPINE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770750 | 6001664 | 2107990 | 37.7682325491861 | -122.437543793089 | (37.7682325491861, -122.437543793089) | 15 | 5 | 5 | 29492 | 3 | |
140306 | 57830 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 307 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29419 | 6000730.804091 | 2094971.1282722 | 37.7324327564376 | -122.439838080651 | (37.7324327564376, -122.439838080651) | 9 | 7 | 5 | 63 | 40 | ||
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 | ||
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 | ||
151858 | 231977 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 20 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003286.06563 | 2105669.78053 | 37.7619538776004 | -122.431767549352 | (37.7619538776004, -122.431767549352) | 15 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
188557 | 231955 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004248.08815 | 2095120.37618 | 37.7330421432752 | -122.42768862922 | (37.7330421432752, -122.42768862922) | 9 | 7 | 5 | 28861 | 25 | |||
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 | ||||
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 | |||
21835 | 65598 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 966 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28500 | 6001950.73496364 | 2088338.48153862 | 37.7142903680478 | -122.435146273727 | (37.7142903680478, -122.435146273727) | 9 | 7 | 6 | 28861 | 5 | ||
43235 | 57575 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 30 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 16442 | 5991446.93129096 | 2089419.02625002 | 37.7166552263353 | -122.471529877911 | (37.7166552263353, -122.471529877911) | 9 | 8 | 6 | 64 | 24 | ||
44026 | 45318 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 651 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44155 | 5993484.7456852 | 2090166.18126819 | 37.718824416648 | -122.464540445707 | (37.718824416648, -122.464540445707) | 9 | 8 | 6 | 64 | 24 | ||
49524 | 209294 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 246 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994759.39259 | 2090227.21808 | 37.7190654070329 | -122.460138948468 | (37.7190654070329, -122.460138948468) | 9 | 8 | 6 | 28861 | 24 | |||
51461 | 83403 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 24 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50775 | 6000910.29193694 | 2092966.50207531 | 37.7269387297254 | -122.439073931559 | (37.7269387297254, -122.439073931559) | 9 | 7 | 6 | 28861 | 25 | ||
76546 | 177523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 321 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998908.35184 | 2087935.66658 | 37.7130110981499 | -122.44563295221 | (37.7130110981499, -122.44563295221) | 9 | 7 | 6 | 28861 | 25 | |||
78371 | 33939 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 378 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 37898 | 6003089.72357803 | 2091687.1316724 | 37.72354963405 | -122.431448393386 | (37.72354963405, -122.431448393386) | 9 | 7 | 6 | 28861 | 5 | ||
82559 | 45319 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 671 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44156 | 5993486.1732944 | 2090289.68128716 | 37.7191636002321 | -122.464544473629 | (37.7191636002321, -122.464544473629) | 9 | 8 | 6 | 64 | 24 | ||
84565 | 177524 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 151 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002754.06698 | 2092583.57784 | 37.725992044773 | -122.432672702599 | (37.725992044773, -122.432672702599) | 9 | 7 | 6 | 28861 | 5 | |||
97377 | 77990 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
97669 | 46851 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 440 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 8 | Permit Number 44919 | 6003321.97716 | 2091035.01696 | 37.7217722323726 | -122.430599024221 | (37.7217722323726, -122.430599024221) | 9 | 7 | 6 | 28861 | 5 | |
116585 | 35845 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 478 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 14 | Permit Number 39072 | 6001935.45212 | 2090855.28224 | 37.7212000747131 | -122.435379022551 | (37.7212000747131, -122.435379022551) | 9 | 7 | 6 | 28861 | 5 | |
120920 | 46820 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 470 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 10 | Permit Number 44898 | 6003678.47918 | 2090585.52708 | 37.7205582222597 | -122.429334652987 | (37.7205582222597, -122.429334652987) | 9 | 7 | 6 | 28861 | 5 | |
121517 | 254611 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 49 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:11:00 PM | 3 | 3X3 | 6001570.75814 | 2091771.51604 | 37.7236951277094 | -122.436705214986 | (37.7236951277094, -122.436705214986) | 9 | 7 | 6 | 28861 | 25 | ||
122547 | 67014 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 26 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30369 | 5996236.04729315 | 2090068.29308484 | 37.7187138605807 | -122.455023275935 | (37.7187138605807, -122.455023275935) | 9 | 8 | 6 | 28861 | 24 | ||
127221 | 53339 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 701 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 6231 | 5992196.93740977 | 2089828.37078741 | 37.7178225482589 | -122.468967276491 | (37.7178225482589, -122.468967276491) | 9 | 8 | 6 | 64 | 24 | ||
144783 | 47523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 253 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45394 | 6001752.07719 | 2094109.13644 | 37.7301240051048 | -122.436245638924 | (37.7301240051048, -122.436245638924) | 9 | 7 | 6 | 28861 | 25 | |
153381 | 45327 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
163496 | 77992 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
168262 | 45325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
170769 | 53492 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 255 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 6402 | 5992175.72287884 | 2089558.97106605 | 37.7170816163747 | -122.469021010071 | (37.7170816163747, -122.469021010071) | 9 | 8 | 6 | 64 | 24 | ||
173866 | 45326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
174822 | 75386 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
179940 | 62390 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 259 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1985 12:00:00 AM | Permit Number 22540 | 6000848.37769972 | 2093515.20006186 | 37.7284418053746 | -122.439327280294 | (37.7284418053746, -122.439327280294) | 9 | 7 | 6 | 28861 | 25 | ||
184631 | 47495 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 222 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45388 | 6001706.9707 | 2093841.21109 | 37.7293857804089 | -122.436382409642 | (37.7293857804089, -122.436382409642) | 9 | 7 | 6 | 28861 | 25 | |
192102 | 37860 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 147 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | 13 | 6x8 | Permit Number 40147 | 6003940.89934 | 2092950.10622 | 37.7270656869264 | -122.428596014613 | (37.7270656869264, -122.428596014613) | 9 | 7 | 6 | 28861 | 5 |
10268 | 231965 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6007531.06073 | 2097759.54123 | 37.7404738690811 | -122.416525379751 | (37.7404738690811, -122.416525379751) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | ||
29365 | 231964 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 332 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008801.63861 | 2097226.11377 | 37.7390805674202 | -122.412094512652 | (37.7390805674202, -122.412094512652) | 10 | 7 | 7 | 28859 | 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 | ||
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 | ||
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 | ||
51718 | 43139 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005713.11166 | 2093478.24293 | 37.7286159697368 | -122.422507005398 | (37.7286159697368, -122.422507005398) | 9 | 7 | 7 | 309 | 5 | ||
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 | |||
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 | ||
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 | ||
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 |
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) );