trees
2,306 rows where qSpecies_id = 15 sorted by Fire Prevention 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
245 | 251484 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 7 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
289 | 211158 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Marietta Dr | 38 | Median : Cutout | Tree | DPW 1 | 21 | Width 5ft | 5999457.51761 | 2097516.55077 | 37.7393493243992 | -122.444422982731 | (37.7393493243992, -122.444422982731) | 9 | 7 | 4 | 59 | 40 | |||
390 | 255918 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 80 Molimo Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998634.42423 | 2096706.77911 | 37.7370788872961 | -122.447210599537 | (37.7370788872961, -122.447210599537) | 9 | 7 | 4 | 59 | 40 | ||||
430 | 121151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Payson St | 1 | Side Yard : Yard | Tree | DPW 1 | 25 | 3x3 | 5992041 | 2087761 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | 9 | 8 | 4 | 64 | 24 | |||
533 | 257925 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 274 Staples Ave | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998272.17919 | 2093819.44967 | 37.7291302611298 | -122.448255187535 | (37.7291302611298, -122.448255187535) | 9 | 7 | 4 | 28861 | 40 | |||||
748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
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 | |||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
1523 | 260685 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
2067 | 211204 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 150 | : | Tree | Private 2 | 8 | Width 0ft | 5991184.95958 | 2091479.43645 | 37.7222974463483 | -122.472585508941 | (37.7222974463483, -122.472585508941) | 9 | 8 | 4 | 64 | 40 | |||
2688 | 253070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 134 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | Width 0ft | Permit Number 780451 | 5995517 | 2087474 | 37.7115492645372 | -122.45732113821 | (37.7115492645372, -122.45732113821) | 9 | 8 | 6 | 28861 | 24 | |||
4148 | 111380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
4898 | 211279 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.443209289192 | (37.7324367835174, -122.443209289192) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||||
5134 | 13416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 442 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999568.3476194 | 2097073.0677048 | 37.7381379481581 | -122.444007926391 | (37.7381379481581, -122.444007926391) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
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 | |||
7631 | 256540 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
8237 | 260684 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
8370 | 264916 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 744 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991301 | 2092678 | 37.7255951208098 | -122.472271716 | (37.7255951208098, -122.472271716) | 9 | 8 | 4 | 64 | 40 | ||||
8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
9033 | 254440 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X Brotherhood Way | 20 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 64 | 24 | ||||
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 | |||||
10407 | 260077 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 167X Burlwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5997137 | 2096182 | 37.7355522955825 | -122.452349987086 | (37.7355522955825, -122.452349987086) | 9 | 7 | 4 | 59 | 40 | ||||
10595 | 262051 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 851X Alemany Blvd | 2 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
11182 | 261019 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3450X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784867 | 5990575 | 2092822 | 37.725948465298 | -122.47479191789 | (37.725948465298, -122.47479191789) | 9 | 8 | 4 | 64 | 14 | |||
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 | ||||
12060 | 101900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100 Ocean Ave | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
12546 | 111544 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 22 | Front Yard : Yard | Tree | DPW 1 | 10 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
12739 | 30076 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
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 | |||
13246 | 216499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Bosworth St | 6 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6001469.53693 | 2095587.89447 | 37.7341682770342 | -122.437328259898 | (37.7341682770342, -122.437328259898) | 9 | 7 | 5 | 63 | 40 | |||
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 | |||
13832 | 259913 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 23 Cresta Vista Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5995254 | 2096176 | 37.7354277647167 | -122.45885975654 | (37.7354277647167, -122.45885975654) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
14673 | 187603 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 748 University St | 7 | Front Yard : Yard | Tree | Private 2 | 19 | 6008732.08795 | 2090689.33982 | 37.7211280830698 | -122.411873196707 | (37.7211280830698, -122.411873196707) | 9 | 7 | 7 | 309 | 18 | ||||
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 | |||
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 | |||
17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
17996 | 211170 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 201 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6000065.75061 | 2094388.32977 | 37.7307946484584 | -122.442095501327 | (37.7307946484584, -122.442095501327) | 9 | 7 | 4 | 63 | 40 | |||
17997 | 122419 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2200 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
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 | |||
20589 | 178347 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99 Bowdoin St | 1 | Side Yard : Yard | Tree | Private 2 | 37 | 6008416.70539 | 2094741.77162 | 37.7322374982533 | -122.413249807854 | (37.7322374982533, -122.413249807854) | 9 | 3 | 7 | 309 | 28 | ||||
20676 | 211283 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 690 Mangels Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5996818.09292 | 2095302.78918 | 37.7331199193461 | -122.453389106624 | (37.7331199193461, -122.453389106624) | 9 | 7 | 4 | 59 | 40 | |||
20906 | 211157 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Marietta Dr | 37 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5999448.78231 | 2097518.60545 | 37.7393544676471 | -122.444453333051 | (37.7393544676471, -122.444453333051) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
21587 | 30086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
21767 | 109635 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2X GENEVA AVE | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
22111 | 178341 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 78 Mansfield St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6005254.35073 | 2091748.15576 | 37.7238396388741 | -122.423969991927 | (37.7238396388741, -122.423969991927) | 9 | 7 | 6 | 28861 | 5 | ||||
22568 | 211184 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 34 | Width 0ft | 5991386.34298 | 2094392.08332 | 37.7303065045205 | -122.472101578341 | (37.7303065045205, -122.472101578341) | 9 | 8 | 4 | 64 | 40 | |||
23064 | 211175 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Ashton Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5994178.62762 | 2090127.07323 | 37.7187570114974 | -122.462139154897 | (37.7187570114974, -122.462139154897) | 9 | 8 | 6 | 28861 | 24 | ||||
23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
23427 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 4 | Back Yard : Yard | Tree | Private 2 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
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 | |||
25280 | 111534 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 12 | Front Yard : Yard | Tree | DPW 1 | 30 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
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 | |||
26419 | 256644 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Miraloma Dr | 3 | Side Yard : Cutout | Tree | DPW 1 | 10x10 | 5994995 | 2097925 | 37.7402151966004 | -122.459881864698 | (37.7402151966004, -122.459881864698) | 9 | 8 | 4 | 59 | 40 | ||||
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 | |||||
27645 | 251483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 8 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
27687 | 211197 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 76 | : | Tree | Private 2 | 5 | Width 0ft | 5991242.1316 | 2092244.3777 | 37.7244010946151 | -122.472443619271 | (37.7244010946151, -122.472443619271) | 9 | 8 | 4 | 64 | 40 | |||
28217 | 258038 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 55 Mercedes Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5991909 | 2093425 | 37.7276813664439 | -122.470224302167 | (37.7276813664439, -122.470224302167) | 9 | 8 | 4 | 59 | 40 | ||||
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 | |||
28834 | 251489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 31 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
28927 | 105423 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/28/2014 12:00:00 AM | 28 | 3x20 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||
29182 | 30079 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 14 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
29960 | 211180 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 582 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 10ft | 5993025.94839 | 2091087.79272 | 37.7213284790141 | -122.466193251017 | (37.7213284790141, -122.466193251017) | 9 | 8 | 6 | 64 | 24 | |||
29992 | 253818 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | 9 | 7 | 6 | 28861 | 5 | ||||
31393 | 211194 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 61 | : | Tree | Private 2 | 6 | Width 0ft | 5991249.68051 | 2092388.77229 | 37.7247980032196 | -122.472428045728 | (37.7247980032196, -122.472428045728) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
32398 | 178333 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 149 Milton St | 2 | Front Yard : Yard | Tree | Private 2 | 33 | 6003877.13508 | 2094696.13163 | 37.7318562729499 | -122.428940875834 | (37.7318562729499, -122.428940875834) | 9 | 7 | 5 | 28861 | 25 | ||||
32937 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.7228470175482 | -122.44673211619 | (37.7228470175482, -122.44673211619) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
33354 | 173755 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Emil Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5996276 | 2095955 | 37.7348796446223 | -122.455310374086 | (37.7348796446223, -122.455310374086) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
34054 | 178267 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 350x Winding Way | 7 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6001101.51532 | 2086589.41989 | 37.7094395728456 | -122.437956296952 | (37.7094395728456, -122.437956296952) | 9 | 7 | 6 | 28861 | 5 | |||
34173 | 187600 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 748 University St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6008716.51879 | 2090699.95704 | 37.7211563622493 | -122.411927764864 | (37.7211563622493, -122.411927764864) | 9 | 7 | 7 | 309 | 18 | ||||
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 | |||
35519 | 30055 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
35748 | 30062 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 7 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
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 | |||
37106 | 211195 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 69 | : | Tree | Private 2 | 52 | Width 0ft | 5991251.70893 | 2092296.84954 | 37.7245457235837 | -122.472414335578 | (37.7245457235837, -122.472414335578) | 9 | 8 | 4 | 64 | 40 | |||
37658 | 211153 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 990 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5995337.03671 | 2094563.98966 | 37.7310063497662 | -122.458456020149 | (37.7310063497662, -122.458456020149) | 9 | 7 | 4 | 59 | 40 | ||||
37858 | 107319 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 530X JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | DPW 1 | 27 | 5991365.2 | 2093720 | 37.728459908419 | -122.472125702067 | (37.728459908419, -122.472125702067) | 9 | 8 | 4 | 64 | 40 | ||||
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 | ||
39088 | 255806 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 255X Evelyn Way | 1 | Median : Yard | Tree | PUC 8 | 10x10 | 5998108 | 2098711 | 37.742551901709 | -122.449175024155 | (37.742551901709, -122.449175024155) | 9 | 7 | 4 | 59 | 40 | ||||
39321 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | |||
39717 | 30064 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
39981 | 256672 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 Kenwood Way | 11 | Back Yard : Yard | Tree | Private 2 | 30x30 | 5994751 | 2093714 | 37.7286387886762 | -122.4604204683 | (37.7286387886762, -122.4604204683) | 9 | 8 | 4 | 59 | 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) );