trees
1,408 rows where qSpecies_id = 113
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
501 | 108350 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
1554 | 129221 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2711 Vallejo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000567.88231 | 2117494.00338 | 37.7942657282202 | -122.442017408682 | (37.7942657282202, -122.442017408682) | 13 | 9 | 1 | 57 | 27 | |||
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 | |
1938 | 219404 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 471 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998306.28146 | 2095220.78528 | 37.7329799470492 | -122.448238160486 | (37.7329799470492, -122.448238160486) | 9 | 7 | 4 | 59 | 40 | |||
2123 | 176806 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 102 Bowdoin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008418.41029 | 2094548.16492 | 37.7317059917167 | -122.413230227789 | (37.7317059917167, -122.413230227789) | 9 | 3 | 7 | 309 | 28 | |||
2317 | 129136 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5999820.13203 | 2119534.7646 | 37.7998264765557 | -122.444751458338 | (37.7998264765557, -122.444751458338) | 13 | 9 | 1 | 57 | 17 | |||
2355 | 176777 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 107 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6008230.80526 | 2093471.1524 | 37.7287382127949 | -122.413802663375 | (37.7287382127949, -122.413802663375) | 9 | 3 | 7 | 309 | 28 | |||
2389 | 226983 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 115 Farnum St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6002427.40541 | 2097410.1517 | 37.7392261829547 | -122.434146834405 | (37.7392261829547, -122.434146834405) | 2 | 7 | 5 | 63 | 7 | |||
2412 | 219263 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1851 08th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993725.67794 | 2102905.85054 | 37.7538182676993 | -122.464632221316 | (37.7538182676993, -122.464632221316) | 1 | 8 | 4 | 56 | 12 | |||
2435 | 129307 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2363 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006689.73885 | 2119362.09742 | 37.7997420023389 | -122.420967750079 | (37.7997420023389, -122.420967750079) | 13 | 9 | 1 | 28858 | 32 | |||
2700 | 176810 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 79 Colby St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6008186.25222 | 2093616.43153 | 37.7291346159515 | -122.413966959633 | (37.7291346159515, -122.413966959633) | 9 | 3 | 7 | 309 | 28 | |||
3385 | 223764 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.409618578359 | (37.7408634922583, -122.409618578359) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |
3576 | 129155 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3140 Pacific Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5999111.81461 | 2116653.58178 | 37.7918750703267 | -122.4469950411 | (37.7918750703267, -122.4469950411) | 11 | 6 | 1 | 29490 | 30 | |||
3813 | 176671 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 500x San Juan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6000440.43474 | 2092860.77254 | 37.7266216745319 | -122.440690633469 | (37.7266216745319, -122.440690633469) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
3905 | 19979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
3998 | 176849 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Gambier St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6005708.05423 | 2093517.46622 | 37.7287233829612 | -122.422527275231 | (37.7287233829612, -122.422527275231) | 9 | 7 | 7 | 309 | 5 | |||
4224 | 129241 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2792 Fillmore St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002607.77018 | 2117744.6226 | 37.7950698975185 | -122.434977106511 | (37.7950698975185, -122.434977106511) | 13 | 9 | 1 | 29490 | 27 | |||
4813 | 223765 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009530.59471 | 2097856.4038 | 37.7408520807582 | -122.409618578357 | (37.7408520807582, -122.409618578357) | 10 | 7 | 7 | 28859 | 2 | |||
4817 | 219315 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1200 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 5995096.96866 | 2091948.28525 | 37.7238104576833 | -122.459096640518 | (37.7238104576833, -122.459096640518) | 9 | 8 | 4 | 28861 | 24 | |||
4999 | 118705 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) | 11 | 6 | 2 | 55 | 26 | |||
5147 | 19819 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
5471 | 226856 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1706 Dolores St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6005261.02948 | 2098379.01551 | 37.7420468804511 | -122.424418319247 | (37.7420468804511, -122.424418319247) | 2 | 7 | 5 | 63 | 7 | |||
5623 | 226838 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 14 Liberty St | 2 | : | Tree | Private 2 | 7 | Width 1ft | 6006187.25946 | 2104078.53237 | 37.7577487106567 | -122.42162041686 | (37.7577487106567, -122.42162041686) | 2 | 4 | 5 | 28859 | 19 | |||
5627 | 19964 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
5788 | 219297 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 381 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998167.92855 | 2094066.72164 | 37.7298032511049 | -122.448633390929 | (37.7298032511049, -122.448633390929) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||||
6362 | 176782 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Dartmouth St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008503.6919 | 2093600.78461 | 37.7291094763057 | -122.412868435047 | (37.7291094763057, -122.412868435047) | 9 | 3 | 7 | 309 | 28 | |||
6643 | 176656 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 83 Badger St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6002434.052 | 2094281.82238 | 37.7306368857794 | -122.433900305949 | (37.7306368857794, -122.433900305949) | 9 | 7 | 5 | 28861 | 25 | |||
6699 | 123104 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 446 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5992530.91894 | 2112401.00432 | 37.7798204855095 | -122.469455059019 | (37.7798204855095, -122.469455059019) | 11 | 6 | 2 | 54 | 11 | |||
7280 | 176726 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1835 Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005342.6627 | 2092636.32324 | 37.7262833378802 | -122.4237278324 | (37.7262833378802, -122.4237278324) | 9 | 7 | 7 | 309 | 5 | |||
7378 | 219397 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 407 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6000069.67412 | 2095030.49113 | 37.7325580975702 | -122.442128015408 | (37.7325580975702, -122.442128015408) | 9 | 7 | 4 | 63 | 40 | |||
7528 | 226882 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2810 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009447.14609 | 2105030.4857 | 37.7605458378345 | -122.410413552952 | (37.7605458378345, -122.410413552952) | 2 | 4 | 7 | 28859 | 19 | |||
7930 | 223763 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.7408787078943 | -122.409618578334 | (37.7408787078943, -122.409618578334) | 10 | 7 | 7 | 28859 | 2 | |||
8403 | 249624 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2450 Golden Gate Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 7ft | 5997651.05189 | 2111322.51448 | 37.7771538015333 | -122.451664533393 | (37.7771538015333, -122.451664533393) | 15 | 6 | 2 | 54 | 16 | |||
8564 | 206953 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 200 Judson Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5998675.41123 | 2093529.72408 | 37.7283577869787 | -122.446840347823 | (37.7283577869787, -122.446840347823) | 9 | 7 | 4 | 28861 | 40 | |||
8677 | 249743 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Broderick St | 27 | : | Tree | Private 2 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.7936121486327 | -122.443168120916 | (37.7936121486327, -122.443168120916) | 13 | 9 | 1 | 57 | 27 | |||
8754 | 219312 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 322 Havelock St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5998687.37843 | 2092940.65981 | 37.7267410379466 | -122.446756609236 | (37.7267410379466, -122.446756609236) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||||
9556 | 19963 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
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 | ||||
9994 | 176783 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 799X Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008526 | 2093580 | 37.7290536583746 | -122.412789845037 | (37.7290536583746, -122.412789845037) | 9 | 3 | 7 | 309 | 28 | |||
10469 | 259580 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 398 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994369 | 2098919 | 37.7429084509163 | -122.462118372119 | (37.7429084509163, -122.462118372119) | 1 | 8 | 4 | 59 | 40 | ||||
10643 | 129149 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1800 Jefferson St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000512.40261 | 2121367.00013 | 37.8048967868113 | -122.442487569762 | (37.8048967868113, -122.442487569762) | 13 | 9 | 1 | 57 | 17 | |||
10675 | 247554 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 815 Buena Vista Ave West | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 2ft | 6000050.05446 | 2108365.18828 | 37.769170829105 | -122.443153202975 | (37.769170829105, -122.443153202975) | 15 | 5 | 11 | 29492 | 9 | |||
10906 | 190798 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2098 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 7ft | 6011929.82719 | 2104699.62352 | 37.7597762277144 | -122.401803784534 | (37.7597762277144, -122.401803784534) | 10 | 3 | 8 | 28856 | 29 | |||
11113 | 107054 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6003385 | 2094496 | 37.7312788881427 | -122.43062801307 | (37.7312788881427, -122.43062801307) | 9 | 7 | 5 | 28861 | 25 | |||
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 | |||
11541 | 219252 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 493 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998807.21011 | 2094945.46348 | 37.7322526032772 | -122.446486525737 | (37.7322526032772, -122.446486525737) | 9 | 7 | 4 | 59 | 40 | |||
11839 | 19962 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
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 | |||
12687 | 219408 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 826 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5999474.92133 | 2095660.53825 | 37.7342541461187 | -122.444229471118 | (37.7342541461187, -122.444229471118) | 9 | 7 | 4 | 63 | 40 | |||
12750 | 201353 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.397583402851 | (37.7265081621175, -122.397583402851) | 10 | 3 | 8 | 58 | 1 | |||
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 | |
13113 | 129304 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005981.05441 | 2120675.33174 | 37.8033078358583 | -122.423513477178 | (37.8033078358583, -122.423513477178) | 5 | 9 | 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 | ||||
13280 | 226873 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2001 Bryant St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6009581.91025 | 2105420.85963 | 37.7616252698063 | -122.409975021942 | (37.7616252698063, -122.409975021942) | 2 | 4 | 8 | 28859 | 19 | |||
13459 | 226896 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1243 Valencia St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6006432.37393 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | 2 | 4 | 7 | 28859 | 19 | |||
13545 | 129348 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 33 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | 3 | 1 | 10 | 308 | 23 | |||
13953 | 116804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 131 LAKESHORE DR | 1 | Median : Yard | Landscaping | DPW 1 | 10x100 | 5984782 | 2094243 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | 1 | 8 | 4 | 64 | 35 | ||||
14000 | 176632 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 110 Newton St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.7130122879616 | -122.438573512475 | (37.7130122879616, -122.438573512475) | 9 | 7 | 6 | 28861 | 5 | |||
14065 | 129131 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3542 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6000280.24975 | 2120491.13146 | 37.8024786510429 | -122.443228011273 | (37.8024786510429, -122.443228011273) | 13 | 9 | 1 | 57 | 17 | |||
14149 | 176803 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6008471.38448 | 2094562.18285 | 37.731747455866 | -122.413048075521 | (37.731747455866, -122.413048075521) | 9 | 3 | 7 | 309 | 28 | |||
14336 | 226984 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2323 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6001664.11704 | 2096982.04185 | 37.7380073425508 | -122.436755300925 | (37.7380073425508, -122.436755300925) | 2 | 7 | 5 | 63 | 7 | |||
14493 | 258979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 799X Silliman St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 5ft | 6008526 | 2093580 | 37.7290536583746 | -122.412789845037 | (37.7290536583746, -122.412789845037) | 9 | 3 | 7 | 309 | 28 | ||||
14613 | 129359 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2431 Jones St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007962.68527 | 2120698.03177 | 37.8034818141966 | -122.416657564817 | (37.8034818141966, -122.416657564817) | 5 | 1 | 1 | 308 | 32 | |||
14667 | 190808 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2115 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 2ft | 6011806.38674 | 2103701.05515 | 37.7570274903299 | -122.402160501522 | (37.7570274903299, -122.402160501522) | 10 | 3 | 8 | 28856 | 29 | |||
14926 | 176715 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 705 Peru Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005335.89523 | 2092477.4819 | 37.7258468123661 | -122.423739938161 | (37.7258468123661, -122.423739938161) | 9 | 7 | 7 | 309 | 5 | |||
15110 | 249752 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Broderick St | 36 | : | Tree | Private 2 | 8 | Width 1ft | 6000236.97181 | 2117227.13869 | 37.7935141252181 | -122.443143217783 | (37.7935141252181, -122.443143217783) | 13 | 9 | 1 | 57 | 27 | |||
15241 | 176856 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 699 Prague St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6002702.07598 | 2087433.5886 | 37.7118483664744 | -122.432484753275 | (37.7118483664744, -122.432484753275) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||||||||||||||
15915 | 129324 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1830 Jones St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6008276.93118 | 2118915.06501 | 37.7986039022051 | -122.415443797487 | (37.7986039022051, -122.415443797487) | 5 | 1 | 10 | 308 | 21 | |||
16529 | 219360 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 313 Bright St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5993732.0948 | 2089263.88202 | 37.7163611752992 | -122.463620014549 | (37.7163611752992, -122.463620014549) | 9 | 8 | 6 | 64 | 24 | |||
16801 | 129273 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1762 Washington St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 1ft | 6006209.28705 | 2116988.44099 | 37.7931974460669 | -122.422461539272 | (37.7931974460669, -122.422461539272) | 13 | 9 | 10 | 28858 | 32 | |||
17035 | 866 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6007241.9784 | 2095034.86963 | 37.7329762592527 | -122.417331878084 | (37.7329762592527, -122.417331878084) | 2 | 7 | 7 | 28859 | 2 | |||
17115 | 129350 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 38 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | 3 | 1 | 10 | 308 | 23 | |||
17196 | 109360 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.8031789225402 | -122.418428928878 | (37.8031789225402, -122.418428928878) | 5 | 1 | 1 | 28858 | 32 | |||
17200 | 176807 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 106 Gaven St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6009983.09592 | 2095237.75517 | 37.7336871802039 | -122.407869378985 | (37.7336871802039, -122.407869378985) | 10 | 3 | 7 | 309 | 28 | |||
17612 | 262236 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 3540 Rivera St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 5982153 | 2100195 | 37.7457010726591 | -122.504451707081 | (37.7457010726591, -122.504451707081) | 1 | 8 | 3 | 29491 | 35 | ||||
17673 | 129191 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2601 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999373.36007 | 2119407.89967 | 37.7994526337909 | -122.446288318756 | (37.7994526337909, -122.446288318756) | 13 | 9 | 1 | 57 | 17 | |||
17751 | 129169 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2601 Francisco St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5999095.44123 | 2119716.26222 | 37.8002834382757 | -122.447272218433 | (37.8002834382757, -122.447272218433) | 13 | 9 | 1 | 57 | 17 | |||
17819 | 227010 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 5527 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6001848.80076 | 2097475.72956 | 37.7393733884669 | -122.436152077973 | (37.7393733884669, -122.436152077973) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
17941 | 258800 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 566 29th Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
18027 | 190795 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2051 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012296.97439 | 2102792.20367 | 37.7545593540486 | -122.400400016553 | (37.7545593540486, -122.400400016553) | 10 | 3 | 8 | 28856 | 29 | |||
18075 | 249603 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2240 Golden Gate Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998819.01703 | 2111486.76835 | 37.7776716194901 | -122.447636015808 | (37.7776716194901, -122.447636015808) | 15 | 6 | 2 | 54 | 16 | |||
18222 | 129252 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1230 Clay St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6008758.83473 | 2117005.78057 | 37.7933885519791 | -122.413641138835 | (37.7933885519791, -122.413641138835) | 5 | 1 | 10 | 28857 | 21 | |||
18549 | 129166 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 75 Emerson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5998684.61281 | 2113379.65213 | 37.7828613048569 | -122.448237300713 | (37.7828613048569, -122.448237300713) | 15 | 6 | 1 | 54 | 31 | |||
18572 | 226858 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 99 Elk St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6000811.86786 | 2096313.45404 | 37.7361230848195 | -122.43965402273 | (37.7361230848195, -122.43965402273) | 2 | 7 | 5 | 63 | 7 | |||
18645 | 190779 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1250 20th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014174.76629 | 2104825.83566 | 37.760247805222 | -122.394048422422 | (37.760247805222, -122.394048422422) | 10 | 3 | 8 | 28856 | 29 | |||
18669 | 129358 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2431 Jones St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007962.78521 | 2120702.91061 | 37.8034952158822 | -122.416657564798 | (37.8034952158822, -122.416657564798) | 5 | 1 | 1 | 308 | 32 | |||
18955 | 226904 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1334 Douglass St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 2ft | 6001345.2019 | 2099797.64766 | 37.7457202045352 | -122.438059576001 | (37.7457202045352, -122.438059576001) | 2 | 4 | 5 | 63 | 22 | |||
19564 | 264882 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2801 Lawton St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5985570 | 2104278 | 37.7571122644181 | -122.49293709397 | (37.7571122644181, -122.49293709397) | 1 | 8 | 3 | 56 | 35 | ||||
19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
19628 | 129197 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 75 Cervantes Blvd | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6001606.61449 | 2120894.2374 | 37.8036610149183 | -122.438667041975 | (37.8036610149183, -122.438667041975) | 13 | 9 | 1 | 57 | 17 | |||
19792 | 219306 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 148 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5998127.52225 | 2094054.8497 | 37.7297683430175 | -122.44877222468 | (37.7297683430175, -122.44877222468) | 9 | 7 | 4 | 28861 | 40 |
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) );