trees
2,306 rows where qSpecies_id = 15 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9667 | 20951 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
| 9819 | 261478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 7 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 10032 | 254212 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 81X Elsie St | 10 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 10141 | 211242 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50x Santa Rita Ave | 16 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5993561.81952 | 2100384.28411 | 37.7468852429767 | -122.465015753384 | (37.7468852429767, -122.465015753384) | 1 | 8 | 4 | 29491 | 40 | |||
| 10142 | 20420 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 10322 | 181388 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | Width 0ft | 5984923.155 | 2104529.1337 | 37.757763958937 | -122.495192617725 | (37.757763958937, -122.495192617725) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 10428 | 4975 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5200X Diamond Heights Blvd | 11 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000932.35718 | 2099423.5316 | 37.744669483426 | -122.439460315968 | (37.744669483426, -122.439460315968) | 2 | 7 | 5 | 63 | 7 | |||
| 10560 | 178279 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 6 | Front Yard : Yard | Tree | DPW 1 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |||
| 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 | ||||
| 10790 | 261495 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 10821 | 4986 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||||
| 11212 | 20461 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
| 11223 | 211225 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2270x 09th Ave | 2 | Median : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5993181.98406 | 2100575.01172 | 37.7473870233022 | -122.466343037597 | (37.7473870233022, -122.466343037597) | 1 | 8 | 4 | 29491 | 40 | |||
| 11277 | 186143 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1700 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984952.2085 | 2103240.0556 | 37.7542262082521 | -122.494997090381 | (37.7542262082521, -122.494997090381) | 1 | 8 | 3 | 56 | 35 | |||
| 11436 | 20292 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
| 11490 | 20283 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
| 11544 | 20435 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 11693 | 261491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 11775 | 173632 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3300X Market St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
| 11791 | 20943 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 19 | Median : Cutout | Tree | DPW 1 | 6 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||||
| 11834 | 261266 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 11955 | 20344 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40 | |||||||||||||
| 11962 | 19853 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY29 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 11983 | 247089 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2301 Castro St | 7 | Front Yard : Yard | Tree | Private 2 | 1 | 6002763.93739 | 2098596.7389 | 37.7425033709224 | -122.433068014888 | (37.7425033709224, -122.433068014888) | 2 | 7 | 5 | 63 | 22 | ||||
| 11998 | 20308 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
| 12112 | 20431 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 30 | |||||||||||||
| 12163 | 21077 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
| 12253 | 261479 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 8 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | |||
| 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 | |||||||||||||
| 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 | ||||
| 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 | ||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 | ||||
| 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 | |||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 |
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) );