trees
2,306 rows where qSpecies_id = 15
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
12400 | 20426 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12406 | 211138 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 368 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 3ft | 5994210.82415 | 2101290.38351 | 37.7494105635678 | -122.462837296827 | (37.7494105635678, -122.462837296827) | 1 | 8 | 4 | 29491 | 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 | ||||
12659 | 122532 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1900X Castro St | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
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 | ||
12856 | 117976 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5984094.3285 | 2112929.06261 | 37.7807792080542 | -122.498679507315 | (37.7807792080542, -122.498679507315) | 11 | 6 | 2 | 55 | 26 | |||
12894 | 20288 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12948 | 258070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Selma Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6x10 | 5992537 | 2103375 | 37.7550378314458 | -122.468777042949 | (37.7550378314458, -122.468777042949) | 1 | 8 | 4 | 56 | 12 | ||||
12954 | 20695 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
13075 | 261490 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
13192 | 20368 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
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 | |||
13420 | 218401 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 245 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 0ft | 5994208.04109 | 2100328.08678 | 37.7467681800257 | -122.462777119594 | (37.7467681800257, -122.462777119594) | 1 | 8 | 4 | 29491 | 40 | |||
13422 | 261500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 7 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
13472 | 259334 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 179X Midcrest Way | 1 | Front Yard : Yard | Tree | DPW 1 | 30x30 | 5998457 | 2101296 | 37.7496696385244 | -122.448154381331 | (37.7496696385244, -122.448154381331) | 1 | 5 | 4 | 63 | 38 | ||||
13538 | 178318 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5988183.85887 | 2090397.25913 | 37.7191518903345 | -122.482880208457 | (37.7191518903345, -122.482880208457) | 1 | 8 | 4 | 64 | 14 | ||||
13588 | 20425 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
13614 | 258670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 152 Kensington Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994743 | 2098651 | 37.7421941161526 | -122.460805774677 | (37.7421941161526, -122.460805774677) | 1 | 8 | 4 | 59 | 40 | |||||
13650 | 113526 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 16x SHELDON TER | 1 | Back Yard : Cutout | Tree | Private 2 | 30 | 3x3 | 5991843 | 2103332 | 37.7548796468533 | -122.471173938858 | (37.7548796468533, -122.471173938858) | 1 | 8 | 4 | 56 | 12 | |||
13664 | 21451 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2701X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
13721 | 261493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
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 | |||
14170 | 20388 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
14228 | 211132 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 39 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 5994073.5471 | 2101557.93366 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | 1 | 8 | 4 | 29491 | 40 | |||
14265 | 20575 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
14280 | 20070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY55 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
14435 | 20307 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
14470 | 261472 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
14499 | 114038 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2x Moffitt St | 3 | Side Yard : Yard | Tree | Private 2 | 35 | 6002767.77413 | 2096661.31369 | 37.7371893582097 | -122.432916509122 | (37.7371893582097, -122.432916509122) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
14690 | 132193 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008345.5033 | 2117049.6207 | 37.7934857075452 | -122.415074404558 | (37.7934857075452, -122.415074404558) | 5 | 1 | 10 | 28858 | 21 | |||
14751 | 261503 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 10 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
14843 | 19968 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY43 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
14911 | 264785 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1738 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10x10 | 5991929 | 2103547 | 37.7554749546691 | -122.470892190435 | (37.7554749546691, -122.470892190435) | 1 | 8 | 4 | 56 | 12 | ||||
15008 | 20387 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
15020 | 20401 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15325 | 261502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 9 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |||
15388 | 20295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
15458 | 233324 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 25 Stoneman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 3ft | 6008213.5814 | 2099395.52315 | 37.745004274037 | -122.414281204321 | (37.745004274037, -122.414281204321) | 2 | 7 | 7 | 28859 | 2 | |||
15529 | 261501 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 8 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
15644 | 187078 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2600 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 0ft | 5985145.5887 | 2096954.5889 | 37.7369793412122 | -122.493865171075 | (37.7369793412122, -122.493865171075) | 1 | 8 | 3 | 29491 | 35 | |||
15991 | 262259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
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 | ||||
16100 | 261494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
16107 | 262406 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2827 Cesar Chavez St | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010428 | 2100696 | 37.7486992403688 | -122.406715738075 | (37.7486992403688, -122.406715738075) | 2 | 4 | 7 | 28859 | 2 | ||||
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 | |||
16184 | 19977 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY45 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
16196 | 251543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard | Tree | Private 2 | ||||||||||||||||
16290 | 20286 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
16411 | 20053 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
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 | ||||
16627 | 261498 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 5 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
16700 | 262531 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 23X Knollview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5997470 | 2101306 | 37.7496406233362 | -122.451568168016 | (37.7496406233362, -122.451568168016) | 1 | 5 | 4 | 63 | 38 | ||||
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 | |||
16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
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 | |||
17040 | 21086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
17047 | 20343 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
17052 | 261499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 6 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
17057 | 20306 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
17132 | 20690 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | ||||
18102 | 222602 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 395 Sussex St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | 6000838.13576 | 2096656.80863 | 37.73706735137 | -122.439587811054 | (37.73706735137, -122.439587811054) | 2 | 7 | 5 | 63 | 7 | ||||
18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
18328 | 20339 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
18358 | 20374 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
18587 | 178281 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 8 | : | Tree | Private 2 | 23 | Width 0ft | 5988022.78245 | 2088756.97622 | 37.7146387127707 | -122.483316805926 | (37.7146387127707, -122.483316805926) | 1 | 8 | 4 | 64 | 14 | |||
18614 | 132205 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | 3 | 1 | 10 | 28860 | 6 | ||||
18633 | 20454 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
18799 | 20738 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
18809 | 218136 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Noriega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5992370.84065 | 2103479.76822 | 37.7553158970187 | -122.469359289996 | (37.7553158970187, -122.469359289996) | 1 | 8 | 4 | 56 | 12 | |||
18878 | 250202 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 203 Union St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | 3 | 1 | 10 | 308 | 23 | |||
18945 | 20432 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
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 | |||
18993 | 186454 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984732.5685 | 2103876.5622 | 37.7559610188182 | -122.495803598204 | (37.7559610188182, -122.495803598204) | 1 | 8 | 3 | 56 | 35 | |||
19001 | 186308 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984992.9477 | 2102764.6568 | 37.7529232789638 | -122.494821157523 | (37.7529232789638, -122.494821157523) | 1 | 8 | 3 | 56 | 35 | |||
19039 | 20396 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
19072 | 20380 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
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 | |||||
19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
19249 | 185216 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5985145.9746 | 2098128.2524 | 37.7402019291808 | -122.49395030702 | (37.7402019291808, -122.49395030702) | 1 | 8 | 3 | 29491 | 35 | |||
19314 | 114270 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 27x ESMERALDA AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6006799 | 2098981 | 37.743786524331 | -122.41914318493 | (37.743786524331, -122.41914318493) | 2 | 7 | 7 | 28859 | 2 | ||||
19407 | 233306 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 174 Carnelian Way | 1 | : Yard | Tree | Private 2 | 26 | 6000631.47853 | 2100513.23992 | 37.7476444344533 | -122.44057883697 | (37.7476444344533, -122.44057883697) | 2 | 4 | 5 | 63 | 22 | ||||
19504 | 21311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2501X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 |
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) );