trees
2,306 rows where qSpecies_id = 15 sorted by Supervisor Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159 | 117627 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
161 | 194506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016624.93937 | 2096021.78221 | 37.7362095654157 | -122.384960961105 | (37.7362095654157, -122.384960961105) | 10 | 3 | 8 | 58 | 1 | ||||
170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
176 | 194490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 19 | Front Yard : Yard | Tree | Private 2 | 29 | 6013346.63868 | 2103825.44695 | 37.7574548949481 | -122.396842409144 | (37.7574548949481, -122.396842409144) | 10 | 3 | 8 | 28856 | 29 | ||||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
1428 | 194473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 851 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 8ft | 6014996.92919 | 2104399.34696 | 37.7591224196901 | -122.391175112734 | (37.7591224196901, -122.391175112734) | 10 | 3 | 8 | 28856 | 29 | |||
2030 | 112443 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
2907 | 194508 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 28 | Median : Yard | Tree | DPW 1 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | 10 | 3 | 8 | 58 | 1 | ||||
3166 | 194483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 930 Kansas St | 2 | Front Yard : Yard | Tree | Private 2 | 31 | 6011593.09908 | 2103991.17748 | 37.7578121947052 | -122.402918540071 | (37.7578121947052, -122.402918540071) | 10 | 3 | 8 | 28856 | 29 | ||||
3197 | 261564 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
3269 | 178256 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 500x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6010359.75763 | 2090312.49843 | 37.7201845359677 | -122.40622025079 | (37.7201845359677, -122.40622025079) | 10 | 3 | 8 | 309 | 28 | |||
4778 | 201565 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Jerrold Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | 6019673.98228 | 2093813.82501 | 37.7303151200443 | -122.374266134286 | (37.7303151200443, -122.374266134286) | 10 | 3 | 8 | 58 | 1 | ||||
5017 | 262484 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 2 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
5888 | 261561 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
5963 | 178185 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1540 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 6ft | 6007177.62531 | 2087487.59558 | 37.7122494380257 | -122.417019794631 | (37.7122494380257, -122.417019794631) | 9 | 7 | 8 | 309 | 39 | |||
5980 | 113539 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X CASHMERE ST | 2 | Median : Yard | Tree | DPW 1 | 20 | 6017054 | 2095889 | 37.7358686950692 | -122.383468266853 | (37.7358686950692, -122.383468266853) | 10 | 3 | 8 | 58 | 1 | ||||
6472 | 178231 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1569 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 42 | Width 10ft | 6007162.15174 | 2087448.53527 | 37.7121413161324 | -122.417070510095 | (37.7121413161324, -122.417070510095) | 9 | 7 | 8 | 309 | 39 | |||
6606 | 178232 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 52 | Width 10ft | 6007195.0497 | 2087434.83618 | 37.712105551909 | -122.41695583486 | (37.712105551909, -122.41695583486) | 9 | 7 | 8 | 309 | 39 | |||
6919 | 178219 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 49 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | Width 6ft | 6006726.5178 | 2087416.33462 | 37.7120283837799 | -122.418573909455 | (37.7120283837799, -122.418573909455) | 9 | 7 | 8 | 309 | 39 | |||
7194 | 117622 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
8513 | 112444 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
9066 | 260960 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1001 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
11046 | 262155 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013141 | 2101984 | 37.752387232625 | -122.397424456513 | (37.752387232625, -122.397424456513) | 10 | 3 | 8 | 28856 | 29 | ||||
11825 | 264757 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 176 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
12343 | 194488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6012030.15727 | 2101805.35505 | 37.751834800344 | -122.401253403036 | (37.751834800344, -122.401253403036) | 10 | 3 | 8 | 28856 | 29 | ||||
12957 | 178189 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 6ft | 6006392.34206 | 2087435.22976 | 37.7120614464552 | -122.419730258665 | (37.7120614464552, -122.419730258665) | 9 | 7 | 8 | 309 | 39 | |||
13370 | 178233 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 47 | Width 10ft | 6007279.31595 | 2087405.78896 | 37.7120305340486 | -122.41666252905 | (37.7120305340486, -122.41666252905) | 9 | 7 | 8 | 309 | 39 | |||
14064 | 178235 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | Width 10ft | 6007325.54279 | 2087388.64 | 37.7119860464048 | -122.416501541435 | (37.7119860464048, -122.416501541435) | 9 | 7 | 8 | 309 | 39 | |||
15386 | 178183 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1540 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 6ft | 6007182.72348 | 2087480.17188 | 37.7122293408858 | -122.417001648133 | (37.7122293408858, -122.417001648133) | 9 | 7 | 8 | 309 | 39 | |||
15996 | 258691 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 100x Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
16156 | 178234 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 53 | Width 10ft | 6007305.28319 | 2087396.36176 | 37.712006109363 | -122.416572111209 | (37.712006109363, -122.416572111209) | 9 | 7 | 8 | 309 | 39 | |||
16522 | 262483 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 1 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
16766 | 178230 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1569 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 10ft | 6007131.69415 | 2087456.78381 | 37.7121622514644 | -122.4171763648 | (37.7121622514644, -122.4171763648) | 9 | 7 | 8 | 309 | 39 | |||
16931 | 194485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 998 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 10ft | 6011603.18064 | 2103745.73679 | 37.7571388318007 | -122.402866411773 | (37.7571388318007, -122.402866411773) | 10 | 3 | 8 | 28856 | 29 | |||
19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
20014 | 178243 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 3 | Front Yard : Yard | Tree | Private 2 | 26 | Width 8ft | 6009152.06447 | 2086268.0035 | 37.7090115585089 | -122.410109471469 | (37.7090115585089, -122.410109471469) | 9 | 7 | 8 | 309 | 39 | |||
21288 | 178260 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 74 | Width 0ft | 6009513.56677 | 2090039.51327 | 37.7193876062417 | -122.409126009759 | (37.7193876062417, -122.409126009759) | 9 | 3 | 8 | 309 | 18 | |||
22742 | 112442 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 36 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
24815 | 178246 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 334 Schwerin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 59 | Width 8ft | 6008498.73338 | 2086169.51029 | 37.7087044750874 | -122.412360530312 | (37.7087044750874, -122.412360530312) | 9 | 7 | 8 | 309 | 39 | |||
25286 | 201566 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 799 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6019697.16467 | 2093717.76615 | 37.7300526357971 | -122.374179337111 | (37.7300526357971, -122.374179337111) | 10 | 3 | 8 | 58 | 1 | ||||
25553 | 178194 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 162 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | Width 6ft | 6005696.94597 | 2087371.40714 | 37.7118470049107 | -122.422129220003 | (37.7118470049107, -122.422129220003) | 9 | 7 | 8 | 309 | 18 | |||
25771 | 194495 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Tulare St | 13 | Front Yard : Yard | Tree | Private 2 | 6 | 6016190.05979 | 2100302.20421 | 37.7479386656413 | -122.38676294076 | (37.7479386656413, -122.38676294076) | 3 | 8 | 58 | 1 | |||||
27633 | 113114 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
28201 | 178257 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 38 | Width 0ft | 6010033.34166 | 2090220.70583 | 37.7199142285308 | -122.407342099256 | (37.7199142285308, -122.407342099256) | 10 | 3 | 8 | 309 | 18 | |||
28407 | 194476 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Carolina St | 43 | Median : Yard | Tree | DPW 1 | 22 | 6012491.75598 | 2103075.93483 | 37.755349278054 | -122.399746327228 | (37.755349278054, -122.399746327228) | 10 | 3 | 8 | 28856 | 29 | ||||
28460 | 178202 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 121 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 6ft | 6006601.88887 | 2086790.1113 | 37.7103018886998 | -122.418960276213 | (37.7103018886998, -122.418960276213) | 9 | 7 | 8 | 309 | 39 | |||
28518 | 178187 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | Width 6ft | 6006632.31277 | 2087409.67594 | 37.712004796352 | -122.418899037766 | (37.712004796352, -122.418899037766) | 9 | 7 | 8 | 309 | 39 | |||
29301 | 121490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 24 | 6011163.12299 | 2106299.7163 | 37.7641269067524 | -122.404568089162 | (37.7641269067524, -122.404568089162) | 8 | 3 | 8 | 28856 | 29 | ||||
31671 | 194519 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1108 Griffith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 6018142.03115 | 2092982.0233 | 37.7279467796967 | -122.379504594361 | (37.7279467796967, -122.379504594361) | 10 | 3 | 8 | 58 | 1 | |||
31915 | 178198 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 121 Blythdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 6ft | 6006547.0126 | 2086935.92271 | 37.7106991660077 | -122.419160276437 | (37.7106991660077, -122.419160276437) | 9 | 7 | 8 | 309 | 39 | |||
33077 | 178244 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 4 | Front Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6009170.0421 | 2086265.24197 | 37.7090049835504 | -122.410047143074 | (37.7090049835504, -122.410047143074) | 9 | 7 | 8 | 309 | 39 | |||
33285 | 178240 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 230 Hahn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | Width 10ft | 6007365.51864 | 2087166.49263 | 37.7113783241319 | -122.416347648527 | (37.7113783241319, -122.416347648527) | 9 | 7 | 8 | 309 | 39 | |||
33673 | 178210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 21 Santos St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 6ft | 6006691.01182 | 2087336.77973 | 37.7118079437471 | -122.41869099041 | (37.7118079437471, -122.41869099041) | 9 | 7 | 8 | 309 | 39 | |||
33806 | 194491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 21 | Front Yard : Yard | Tree | Private 2 | 24 | 6013319.82421 | 2103789.39675 | 37.7573544163899 | -122.396932617442 | (37.7573544163899, -122.396932617442) | 10 | 3 | 8 | 28856 | 29 | ||||
34412 | 178245 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 8 | Front Yard : Yard | Tree | Private 2 | 39 | Width 8ft | 6009206.68729 | 2086340.63676 | 37.7092140561483 | -122.409925810128 | (37.7092140561483, -122.409925810128) | 9 | 7 | 8 | 309 | 39 | |||
36819 | 201729 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1411 Phelps St | 4 | Side Yard : Yard | Tree | Private 2 | 3 | 6013763.5505 | 2095932.04649 | 37.735804483793 | -122.394847748824 | (37.735804483793, -122.394847748824) | 10 | 3 | 8 | 58 | 1 | ||||
36918 | 178207 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 21 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 6ft | 6006695.6684 | 2087233.46262 | 37.7115245188238 | -122.418667573848 | (37.7115245188238, -122.418667573848) | 9 | 7 | 8 | 309 | 39 | |||
37949 | 201567 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 799 Jerrold Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 9ft | 6019712.53243 | 2093705.44833 | 37.7300196585793 | -122.374125355309 | (37.7300196585793, -122.374125355309) | 10 | 3 | 8 | 58 | 1 | |||
38301 | 79685 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 50355 | 6007801.88811391 | 2088315.49386025 | 37.7145577712837 | -122.414920709681 | (37.7145577712837, -122.414920709681) | 9 | 7 | 8 | 309 | 39 | ||
39431 | 178236 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | Width 10ft | 6007352.75953 | 2087377.91644 | 37.7119581323275 | -122.416406713298 | (37.7119581323275, -122.416406713298) | 9 | 7 | 8 | 309 | 39 | |||
39580 | 255145 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1601x 19th St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6012900 | 2105148 | 37.7610614650441 | -122.398479874828 | (37.7610614650441, -122.398479874828) | 10 | 3 | 8 | 28856 | 29 | ||||
40173 | 201730 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1411 Phelps St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | 6013762.45417 | 2095926.0507 | 37.7357879596321 | -122.39485111951 | (37.7357879596321, -122.39485111951) | 10 | 3 | 8 | 58 | 1 | ||||
42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
43756 | 194494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3305 03rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 6016095.96516 | 2099918.62991 | 37.7468802400244 | -122.387061569634 | (37.7468802400244, -122.387061569634) | 3 | 8 | 58 | 1 | ||||
45780 | 194507 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 27 | Median : Yard | Tree | DPW 1 | 21 | 6016618.68245 | 2096023.02512 | 37.7362126321093 | -122.384982680622 | (37.7362126321093, -122.384982680622) | 10 | 3 | 8 | 58 | 1 | ||||
46456 | 178203 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 6ft | 6006694.43634 | 2087041.21118 | 37.7109965673199 | -122.418658207409 | (37.7109965673199, -122.418658207409) | 9 | 7 | 8 | 309 | 39 | |||
46911 | 113122 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
50397 | 178228 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1701 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | Width 10ft | 6006676.94798 | 2087600.40492 | 37.7125310112787 | -122.418758283074 | (37.7125310112787, -122.418758283074) | 9 | 7 | 8 | 309 | 39 | |||
51114 | 178227 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1701 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 10ft | 6006634.76355 | 2087621.1473 | 37.7125855902332 | -122.41890555606 | (37.7125855902332, -122.41890555606) | 9 | 7 | 8 | 309 | 39 | |||
51342 | 194514 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 26 | Median : Yard | Tree | DPW 1 | 22 | 6016024.76116 | 2095911.21448 | 37.7358727531167 | -122.387028333393 | (37.7358727531167, -122.387028333393) | 10 | 3 | 8 | 58 | 1 | ||||
53862 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1101 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
57418 | 178261 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700x Mansell St | 15 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009448.68787 | 2090050.79486 | 37.7194149483077 | -122.4093510687 | (37.7194149483077, -122.4093510687) | 9 | 3 | 8 | 309 | 18 | |||
57762 | 178220 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 49 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 6ft | 6006744.56776 | 2087437.55352 | 37.7120876626009 | -122.418513027154 | (37.7120876626009, -122.418513027154) | 9 | 7 | 8 | 309 | 39 | |||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
59885 | 113113 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
61677 | 194518 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 15x Reuel Ct | 2 | Median : Yard | Tree | DPW 1 | 16 | 6017388.67134 | 2096078.81136 | 37.7364083704432 | -122.382324365581 | (37.7364083704432, -122.382324365581) | 10 | 3 | 8 | 58 | 1 | ||||
62554 | 178272 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 35 Tomaso Ct | 10 | Side Yard : Yard | Tree | Private 2 | 22 | Width 3ft | 6009218.69223 | 2086367.8804 | 37.7092895344499 | -122.409886240875 | (37.7092895344499, -122.409886240875) | 9 | 7 | 8 | 309 | 39 | |||
62616 | 178223 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1700 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 10ft | 6006618.16278 | 2087672.71077 | 37.7127262378868 | -122.418966588549 | (37.7127262378868, -122.418966588549) | 9 | 7 | 8 | 309 | 39 | |||
62956 | 194517 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 15 Reuel Ct | 1 | : | Tree | Private 2 | 31 | 6017370.39077 | 2096095.66056 | 37.7364536252419 | -122.382388741749 | (37.7364536252419, -122.382388741749) | 10 | 3 | 8 | 58 | 1 | ||||
64408 | 201553 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Jerrold Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 6019956.36355 | 2093604.98051 | 37.72975719952 | -122.373275437534 | (37.72975719952, -122.373275437534) | 10 | 3 | 8 | 58 | 1 | ||||
64982 | 178206 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 21 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 6ft | 6006695.7649 | 2087205.12492 | 37.7114467148783 | -122.41866523203 | (37.7114467148783, -122.41866523203) | 9 | 7 | 8 | 309 | 39 | |||
66472 | 194511 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 21 | Median : Yard | Tree | DPW 1 | 29 | 6016041.40389 | 2096043.15017 | 37.7362359434412 | -122.386979991251 | (37.7362359434412, -122.386979991251) | 10 | 3 | 8 | 58 | 1 | ||||
66713 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 612 WISCONSIN ST | 1 | Back Yard : Yard | Tree | Private 2 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.399296223309 | (37.7594155491308, -122.399296223309) | 10 | 3 | 8 | 28856 | 29 | |||||
66798 | 113536 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X CASHMERE ST | 3 | Median : Yard | Tree | DPW 1 | 6017054 | 2095889 | 37.7358686950692 | -122.383468266853 | (37.7358686950692, -122.383468266853) | 10 | 3 | 8 | 58 | 1 | |||||
67245 | 117626 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
68496 | 178208 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 21 Santos St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 6ft | 6006691.70234 | 2087271.32425 | 37.7116282556175 | -122.418683964897 | (37.7116282556175, -122.418683964897) | 9 | 7 | 8 | 309 | 39 | |||
70043 | 178216 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 150 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 47 | Width 6ft | 6005697.33159 | 2087247.87962 | 37.7115078462758 | -122.422119117025 | (37.7115078462758, -122.422119117025) | 9 | 7 | 8 | 309 | 39 | |||
70322 | 194501 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1121 Jamestown Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 56 | 6013422.70006 | 2090021.7257 | 37.7195569863524 | -122.395612244507 | (37.7195569863524, -122.395612244507) | 10 | 3 | 8 | 58 | 1 | ||||
71480 | 112615 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1798x 22ND ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 6012787 | 2103832 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | 10 | 3 | 8 | 28856 | 29 | |||
72101 | 194513 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 301x Cashmere St | 25 | Median : Yard | Tree | DPW 1 | 21 | 6016035.53821 | 2096012.28902 | 37.7361508801593 | -122.386998119763 | (37.7361508801593, -122.386998119763) | 10 | 3 | 8 | 58 | 1 | ||||
72343 | 194496 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Tulare St | 10 | Front Yard : Yard | Tree | Private 2 | 9 | 6016213.72406 | 2100305.90107 | 37.7479501266034 | -122.386681367746 | (37.7479501266034, -122.386681367746) | 3 | 8 | 58 | 1 | |||||
73606 | 178271 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 35 Tomaso Ct | 2 | Side Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6009176.17094 | 2086260.29043 | 37.7089917311415 | -122.410025611499 | (37.7089917311415, -122.410025611499) | 9 | 7 | 8 | 309 | 39 | |||
75494 | 122677 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011198.01208 | 2089669.48894 | 37.7184658164103 | -122.403277459492 | (37.7184658164103, -122.403277459492) | 10 | 7 | 8 | 309 | 28 | |||
75570 | 194474 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 601 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6016019.39456 | 2106196.24921 | 37.7641130167339 | -122.387764283717 | (37.7641130167339, -122.387764283717) | 14 | 3 | 8 | 310 | 29 | ||||
75639 | 194492 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 651 Missouri St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6013622.03607 | 2103861.64748 | 37.7575696187662 | -122.39589250475 | (37.7575696187662, -122.39589250475) | 10 | 3 | 8 | 28856 | 29 | ||||
77642 | 113535 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X CASHMERE ST | 1 | Median : Yard | Tree | DPW 1 | 12/05/2015 12:49:00 PM | 3 | 6017054 | 2095889 | 37.7358686950692 | -122.383468266853 | (37.7358686950692, -122.383468266853) | 10 | 3 | 8 | 58 | 1 | |||
80477 | 3755 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1050 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012450.5971046 | 2103074.0676918 | 37.7553418567665 | -122.399888536822 | (37.7553418567665, -122.399888536822) | 10 | 3 | 8 | 28856 | 29 |
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) );