trees
1,408 rows where qSpecies_id = 113 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1587 | 35594 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/1998 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.67536 | 37.7529551460873 | -122.401332479509 | (37.7529551460873, -122.401332479509) | 10 | 3 | 8 | 28856 | 29 | |
| 3474 | 38364 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825 | (37.7566067521127, -122.50598509825) | 1 | 8 | 3 | 56 | 35 | |
| 3844 | 54791 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.7117197939932 | -122.398158948299 | (37.7117197939932, -122.398158948299) | 10 | 3 | 8 | 309 | 1 | ||
| 6098 | 129331 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Greenwich St | 9 | Front Yard : Yard | Tree | Private 2 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.417986250159 | (37.8011675015458, -122.417986250159) | 5 | 1 | 1 | 28858 | 32 | ||||
| 6243 | 226941 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Fairmount St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6004051.37428 | 2097144.63452 | 37.7385891688512 | -122.428512957704 | (37.7385891688512, -122.428512957704) | 2 | 7 | 5 | 63 | 7 | ||||
| 9051 | 176690 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004472.37947 | 2091855.23398 | 37.7240894732252 | -122.426680760821 | (37.7240894732252, -122.426680760821) | 9 | 7 | 6 | 28861 | 5 | ||||
| 9609 | 129180 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3298 Lyon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998992.55112 | 2120173.79871 | 37.8015338304744 | -122.447661212108 | (37.8015338304744, -122.447661212108) | 13 | 9 | 1 | 57 | 17 | ||||
| 9623 | 118669 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | 11 | 6 | 2 | 55 | 26 | ||||
| 11114 | 71583 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993925.4185 | 2086705.15736 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | 9 | 8 | 6 | 28861 | 25 | |||
| 11982 | 70512 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004917.4216 | 2092965.01921 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | 9 | 7 | 6 | 28861 | 5 | |||
| 12897 | 61250 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2033 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 7 | Permit Number 24211 | 6007651.97178 | 2119454.00624 | 37.8000485533513 | -122.41764457883 | (37.8000485533513, -122.41764457883) | 5 | 1 | 1 | 28858 | 32 | |
| 13233 | 219254 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 449 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5997174.97013 | 2095514.34446 | 37.7337212492173 | -122.452170552242 | (37.7337212492173, -122.452170552242) | 9 | 7 | 4 | 59 | 40 | ||||
| 15832 | 71937 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | 3 | 1 | 10 | 308 | 23 | |||
| 15840 | 258303 | Private 9 | Juniperus chinensis :: Juniper 113 | 1x Dawnview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
| 17868 | 219400 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 434 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998549.53071 | 2095273.11102 | 37.7331375244767 | -122.447400952815 | (37.7331375244767, -122.447400952815) | 9 | 7 | 4 | 59 | 40 | ||||
| 19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
| 23154 | 176687 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6004483.13419 | 2091864.5004 | 37.7241155248047 | -122.426644242931 | (37.7241155248047, -122.426644242931) | 9 | 7 | 6 | 28861 | 5 | ||||
| 23166 | 201343 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012739.9825 | 2092614.25301 | 37.7266375412648 | -122.398153954334 | (37.7266375412648, -122.398153954334) | 10 | 3 | 8 | 58 | 1 | ||||
| 24087 | 129112 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6007339.93679 | 2119283.26863 | 37.7995621873977 | -122.418712226998 | (37.7995621873977, -122.418712226998) | 5 | 1 | 1 | 28858 | 32 | ||||
| 25844 | 53948 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 106 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2012 12:00:00 AM | 10 | Permit Number 769123 | 6009998.5111 | 2095243.6282 | 37.733704169294 | -122.407816497929 | (37.733704169294, -122.407816497929) | 10 | 3 | 7 | 309 | 28 | ||
| 26970 | 219401 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 434 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998548.8783 | 2095279.67226 | 37.7331555028062 | -122.447403680457 | (37.7331555028062, -122.447403680457) | 9 | 7 | 4 | 59 | 40 | ||||
| 28183 | 129327 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 2 | 6007552.17158 | 2119860.88653 | 37.8011601279913 | -122.418018786759 | (37.8011601279913, -122.418018786759) | 5 | 1 | 1 | 28858 | 32 | ||||
| 31670 | 104539 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
| 32329 | 219239 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 579 Hearst Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5997578.77584 | 2094371.85633 | 37.7306073727237 | -122.450692139651 | (37.7306073727237, -122.450692139651) | 9 | 7 | 4 | 28861 | 40 | ||||
| 34658 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
| 36148 | 96832 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 2908 Baker St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999535.9 | 2118868.1 | 37.79797976966 | -122.445687034796 | (37.79797976966, -122.445687034796) | 13 | 9 | 1 | 57 | 17 | |||||
| 36682 | 176686 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6004486.61146 | 2091862.36635 | 37.7241098617621 | -122.426632070637 | (37.7241098617621, -122.426632070637) | 9 | 7 | 6 | 28861 | 5 | ||||
| 37022 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 577 Sanchez St | 1 | Front Yard : | Tree | Private 2 | 6003673 | 2104901 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | 2 | 4 | 5 | 28862 | 3 | |||||
| 38960 | 103564 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
| 40055 | 176719 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 83 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005086.02152 | 2092756.70841 | 37.7265993983363 | -122.424623588602 | (37.7265993983363, -122.424623588602) | 9 | 7 | 6 | 28861 | 5 | ||||
| 44689 | 35257 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2363 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 2 | Permit Number 43818 | 6006687.16748 | 2119377.40243 | 37.7997838810836 | -122.420977735243 | (37.7997838810836, -122.420977735243) | 13 | 9 | 1 | 28858 | 32 | |
| 49750 | 104540 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
| 50703 | 31117 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 450 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 3 | Permit Number 34839 | 5998792.33216 | 2094320.7757 | 37.7305365079364 | -122.446493035949 | (37.7305365079364, -122.446493035949) | 9 | 7 | 4 | 28861 | 40 | |
| 50909 | 103563 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
| 52200 | 129310 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 12 Hastings Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6007284.92251 | 2119276.14262 | 37.7995395235904 | -122.418902090975 | (37.7995395235904, -122.418902090975) | 5 | 1 | 1 | 28858 | 32 | ||||
| 52825 | 104544 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
| 53763 | 176688 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004477.99193 | 2091866.25637 | 37.7241200555896 | -122.426662143938 | (37.7241200555896, -122.426662143938) | 9 | 7 | 6 | 28861 | 5 | ||||
| 55181 | 219402 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 434 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998549.21745 | 2095283.33159 | 37.7331655698403 | -122.447402771226 | (37.7331655698403, -122.447402771226) | 9 | 7 | 4 | 59 | 40 | ||||
| 55338 | 129114 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 12 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6007312.73022 | 2119281.87279 | 37.7995568229462 | -122.418806272699 | (37.7995568229462, -122.418806272699) | 5 | 1 | 1 | 28858 | 32 | ||||
| 57437 | 108624 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 101 GENEBERN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.424923866144 | (37.733409902631, -122.424923866144) | 2 | 7 | 7 | 28861 | 2 | |||||
| 59374 | 97299 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
| 59711 | 226917 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1334 Diamond St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001952.27802 | 2100070.91902 | 37.7465050491722 | -122.435979949537 | (37.7465050491722, -122.435979949537) | 2 | 7 | 5 | 63 | 22 | ||||
| 59898 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 524 45th Ave | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773704 | 5981973.19232 | 2112153.30127 | 37.7785245664452 | -122.505959887315 | (37.7785245664452, -122.505959887315) | 11 | 6 | 2 | 55 | 26 | ||||
| 62300 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2398 Broadway | 2 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 62442 | 31118 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 450 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 7 | Permit Number 34839 | 5998792.48559 | 2094316.2837 | 37.730524182724 | -122.446492182475 | (37.730524182724, -122.446492182475) | 9 | 7 | 4 | 28861 | 40 | |
| 62635 | 129332 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Greenwich St | 10 | Front Yard : Yard | Tree | Private 2 | 1 | 6007563.68428 | 2119863.77685 | 37.8011687120311 | -122.417979152724 | (37.8011687120311, -122.417979152724) | 5 | 1 | 1 | 28858 | 32 | ||||
| 63098 | 176721 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 83 Athens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6005098.35657 | 2092750.06265 | 37.7265818471717 | -122.424580474208 | (37.7265818471717, -122.424580474208) | 9 | 7 | 6 | 28861 | 5 | ||||
| 63394 | 106833 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 174 STILLINGS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | 9 | 7 | 4 | 63 | 40 | |||||
| 68253 | 129113 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | 5 | 1 | 1 | 28858 | 32 | ||||
| 68299 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 86 Nordhoff St | 1 | Front Yard : Yard | Tree | Private 2 | 6000395 | 2095652 | 37.7342831509698 | -122.441047861045 | (37.7342831509698, -122.441047861045) | 9 | 7 | 5 | 63 | 40 | |||||
| 68558 | 190811 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1400 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6012250.38187 | 2101814.62177 | 37.7518725286982 | -122.400492482145 | (37.7518725286982, -122.400492482145) | 10 | 3 | 8 | 28856 | 29 | ||||
| 69116 | 42981 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 387 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 9 | Permit Number 42865 | 6007925.78486 | 2092082.56007 | 37.7249083014575 | -122.414758909799 | (37.7249083014575, -122.414758909799) | 9 | 3 | 7 | 309 | 28 | |
| 69651 | 247136 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 500 27th St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | 6003181.95614 | 2100090.46758 | 37.7466285054035 | -122.431729256215 | (37.7466285054035, -122.431729256215) | 2 | 7 | 5 | 63 | 22 | ||||
| 70208 | 34709 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 727 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 25 | Permit Number 38365 | 5981632.43118 | 2110780.81019 | 37.7747360459971 | -122.507036849685 | (37.7747360459971, -122.507036849685) | 11 | 6 | 2 | 55 | 26 | |
| 70408 | 102912 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004823 | 2092922 | 37.7270383945734 | -122.425544603716 | (37.7270383945734, -122.425544603716) | 9 | 7 | 6 | 28861 | 5 | |||||
| 73210 | 60417 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1409 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 8 | Permit Number 19998 | 6016082.74679 | 2094573.46449 | 37.7322027709252 | -122.386734593253 | (37.7322027709252, -122.386734593253) | 10 | 3 | 8 | 58 | 1 | ||
| 74446 | 247945 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 15 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6010344.08085 | 2098894.91993 | 37.7437491720868 | -122.406879009554 | (37.7437491720868, -122.406879009554) | 2 | 7 | 7 | 28859 | 2 | ||||
| 78350 | 107828 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2601 Van Ness Ave | 2 | Front Yard : Yard | Tree | Private 2 | 35 | Permit Number 774138 | 6005744.5 | 2119283.2 | 37.7994720432373 | -122.424233014169 | (37.7994720432373, -122.424233014169) | 13 | 9 | 1 | 28858 | 17 | |||
| 78716 | 226841 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 601 Grand View Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6000050.59716 | 2101613.91714 | 37.7506335336184 | -122.442666504253 | (37.7506335336184, -122.442666504253) | 2 | 4 | 5 | 28862 | 22 | ||||
| 80283 | 176718 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 139 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6004890.82087 | 2092414.16221 | 37.7256478157716 | -122.425274025998 | (37.7256478157716, -122.425274025998) | 9 | 7 | 6 | 28861 | 5 | ||||
| 80679 | 226916 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1334 Diamond St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001951.53708 | 2100078.27366 | 37.7465252011857 | -122.435983037796 | (37.7465252011857, -122.435983037796) | 2 | 7 | 5 | 63 | 22 | ||||
| 80685 | 119672 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2090x 20th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6011896 | 2104722 | 37.7598357807336 | -122.401922349815 | (37.7598357807336, -122.401922349815) | 10 | 3 | 8 | 28856 | 29 | |||||
| 81841 | 107491 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 20 | Median : Cutout | Tree | DPW 1 | 8 | 6011446.04828 | 2119975.74616 | 37.8016938891322 | -122.40455229795 | (37.8016938891322, -122.40455229795) | 3 | 1 | 10 | 308 | 23 | ||||
| 82430 | 226865 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1100 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 1 | 6004824.42349 | 2096711.05527 | 37.7374423749661 | -122.425809268297 | (37.7374423749661, -122.425809268297) | 2 | 7 | 5 | 63 | 7 | ||||
| 83478 | 129179 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3298 Lyon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5998993.68481 | 2120160.70419 | 37.8014979412479 | -122.447656345876 | (37.8014979412479, -122.447656345876) | 13 | 9 | 1 | 57 | 17 | ||||
| 83489 | 129178 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3298 Lyon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998998.34734 | 2120131.24528 | 37.8014173214978 | -122.447638089651 | (37.8014173214978, -122.447638089651) | 13 | 9 | 1 | 57 | 17 | ||||
| 83906 | 96831 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 2908 Baker St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999535.9 | 2118868.1 | 37.79797976966 | -122.445687034796 | (37.79797976966, -122.445687034796) | 13 | 9 | 1 | 57 | 17 | |||||
| 86207 | 104538 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
| 86395 | 129333 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Greenwich St | 12 | Front Yard : Yard | Tree | Private 2 | 1 | 6007566.18304 | 2119864.34532 | 37.8011704135381 | -122.417970546228 | (37.8011704135381, -122.417970546228) | 5 | 1 | 1 | 28858 | 32 | ||||
| 86711 | 68547 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 526 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | 9 | Permit Number 32434 | 5982567.23967 | 2112157.10709 | 37.7785699651083 | -122.503905168116 | (37.7785699651083, -122.503905168116) | 11 | 6 | 2 | 55 | 26 | ||
| 86928 | 31115 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 450 Edna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.06252 | 2094332.58617 | 37.7305689213091 | -122.446494817492 | (37.7305689213091, -122.446494817492) | 9 | 7 | 4 | 28861 | 40 | |
| 87223 | 103565 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 878 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | Permit Number 770193 | 6002986 | 2107714 | 37.7675497941952 | -122.432951409123 | (37.7675497941952, -122.432951409123) | 15 | 5 | 5 | 28862 | 3 | |||
| 91603 | 84689 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6002195.05393 | 2120739.39081 | 37.8032693043887 | -122.436619630107 | (37.8032693043887, -122.436619630107) | 13 | 9 | 1 | 57 | 17 | |||
| 94077 | 103591 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 3 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
| 95915 | 176692 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6004473.28311 | 2091848.82103 | 37.7240719157653 | -122.426677180615 | (37.7240719157653, -122.426677180615) | 9 | 7 | 6 | 28861 | 5 | ||||
| 96389 | 226942 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 301 Fairmount St | 2 | Side Yard : Yard | Tree | Private 2 | 61 | 6004034.48943 | 2097139.14136 | 37.7385731303523 | -122.428570945989 | (37.7385731303523, -122.428570945989) | 2 | 7 | 5 | 63 | 7 | ||||
| 97703 | 30806 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 138 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 15 | Permit Number 34671 | 6001325.75026 | 2095385.67748 | 37.7336048607826 | -122.437810896383 | (37.7336048607826, -122.437810896383) | 9 | 7 | 5 | 63 | 40 | |
| 98654 | 206958 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 546 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998473.20462 | 2095007.84782 | 37.7324048126327 | -122.447645742852 | (37.7324048126327, -122.447645742852) | 9 | 7 | 4 | 59 | 40 | ||||
| 99355 | 68976 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2550 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 7 | Permit Number 32966 | 5999654.77227 | 2119511.53893 | 37.7997532672523 | -122.445321991823 | (37.7997532672523, -122.445321991823) | 13 | 9 | 1 | 57 | 17 | |
| 99497 | 104543 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
| 100269 | 110570 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
| 100702 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 654 Precita Ave | Front Yard : Yard | Tree | Private 2 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | 2 | 7 | 7 | 28859 | 2 | |||||
| 101786 | 104542 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
| 103648 | 99918 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 103792 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
| 105511 | 49714 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1181@ POLK Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/2003 12:00:00 AM | 5 | Permit Number 46526 | 6006207.33741 | 2120358.03247 | 37.8024493825888 | -122.422707853704 | (37.8024493825888, -122.422707853704) | 5 | 9 | 1 | 28858 | 32 | |
| 107028 | 129117 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 12 Hastings Ter | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6007264.16981 | 2119273.41538 | 37.7995308667162 | -122.418973709394 | (37.7995308667162, -122.418973709394) | 5 | 1 | 1 | 28858 | 32 | ||||
| 108162 | 129325 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6007543.52239 | 2119858.96336 | 37.801154360655 | -122.418048580374 | (37.801154360655, -122.418048580374) | 5 | 1 | 1 | 28858 | 32 | ||||
| 108462 | 226843 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 601 Grand View Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6000048.9204 | 2101630.772 | 37.7506797174008 | -122.442673512691 | (37.7506797174008, -122.442673512691) | 2 | 4 | 5 | 28862 | 22 | ||||
| 109516 | 226842 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 601 Grand View Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000049.35116 | 2101618.98896 | 37.75064738858 | -122.442671177137 | (37.75064738858, -122.442671177137) | 2 | 4 | 5 | 28862 | 22 | ||||
| 111341 | 129116 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 12 Hastings Ter | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007272.57871 | 2119275.54876 | 37.7995371979413 | -122.418944762911 | (37.7995371979413, -122.418944762911) | 5 | 1 | 1 | 28858 | 32 | ||||
| 112385 | 247137 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 500 27th St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6003179.07843 | 2100075.39017 | 37.7465869432333 | -122.431738130709 | (37.7465869432333, -122.431738130709) | 2 | 7 | 5 | 63 | 22 | ||||
| 113420 | 176698 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 283 Moscow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6004617.24023 | 2091470.03605 | 37.7230399931941 | -122.42615258897 | (37.7230399931941, -122.42615258897) | 9 | 7 | 6 | 28861 | 5 | ||||
| 113470 | 68011 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2550 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 4 | Permit Number 31741 | 6007478.84194 | 2121154.66744 | 37.8047083959278 | -122.418364326075 | (37.8047083959278, -122.418364326075) | 5 | 1 | 1 | 308 | 32 | ||
| 114220 | 61931 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1407 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1985 12:00:00 AM | 11 | Permit Number 21986 | 6011381.98525 | 2120211.6051 | 37.8023379197065 | -122.404790601229 | (37.8023379197065, -122.404790601229) | 3 | 1 | 10 | 308 | 23 | ||
| 114624 | 99917 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 117054 | 206960 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 546 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998473.38947 | 2095013.27934 | 37.7324197368658 | -122.447645494639 | (37.7324197368658, -122.447645494639) | 9 | 7 | 4 | 59 | 40 | ||||
| 118511 | 99916 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 118843 | 110571 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 46 COOK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
| 120275 | 176720 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 83 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6005093.44028 | 2092751.8073 | 37.7265863599479 | -122.424597593708 | (37.7265863599479, -122.424597593708) | 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) );