trees
2,306 rows where qSpecies_id = 15 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11878 | 104919 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 12659 | 122532 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1900X Castro St | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||
| 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 | |||||
| 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 | ||||
| 19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 20737 | 114465 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 404 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||||
| 20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||||
| 22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
| 22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
| 23834 | 107210 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 603 PERALTA AVE | 1 | unknown : Yard | Tree | Private 2 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.408607810015 | (37.7431547125392, -122.408607810015) | 10 | 7 | 7 | 28859 | 2 | ||||
| 24444 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 240 States St | 1 | Back Yard : Yard | Tree | Private 2 | 6001213 | 2106258 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | 15 | 5 | 5 | 28862 | 3 | |||||
| 24524 | 107157 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301X Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 28 | 6007313 | 2098782 | 37.7432690474632 | -122.417351790512 | (37.7432690474632, -122.417351790512) | 2 | 7 | 7 | 28859 | 2 | ||||
| 24614 | 105834 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3031 QUINTARA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5984010.9 | 2100823.5 | 37.747535864547 | -122.498073868906 | (37.747535864547, -122.498073868906) | 1 | 8 | 3 | 29491 | 35 | ||||
| 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 | |||
| 25020 | 54835 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 117 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 15 | Permit Number 10689 | 5998722.2979 | 2110262.8651 | 37.7743055679817 | -122.447882461981 | (37.7743055679817, -122.447882461981) | 15 | 5 | 11 | 29492 | 16 | ||
| 25270 | 124269 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 9 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5994882.44582 | 2114964.8982 | 37.7869958645771 | -122.461506079992 | (37.7869958645771, -122.461506079992) | 11 | 6 | 1 | 54 | 11 | ||||
| 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 | ||||
| 26929 | 178314 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 5989006.41886 | 2090486.32798 | 37.7194442778983 | -122.480043480515 | (37.7194442778983, -122.480043480515) | 1 | 8 | 4 | 64 | 14 | ||||
| 27030 | 106971 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3479X San Bruno Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6011510.60551 | 2091910.03431 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | 10 | 3 | 7 | 309 | 28 | ||||
| 27105 | 211166 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 87 Lippard Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | 6001935.96682 | 2095524.15312 | 37.7340197629844 | -122.435711108008 | (37.7340197629844, -122.435711108008) | 2 | 7 | 5 | 63 | 7 | ||||
| 27544 | 211097 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 500 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 8ft | 5994510.98243 | 2099836.30312 | 37.7454353091989 | -122.461693934723 | (37.7454353091989, -122.461693934723) | 1 | 8 | 4 | 29491 | 40 | |||
| 28400 | 99274 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 16 Joy St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | Permit Number 768828 | 6010347.9 | 2098933.4 | 37.7438550437031 | -122.406868515265 | (37.7438550437031, -122.406868515265) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 28773 | 114213 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 230 SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 60 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
| 28785 | 122558 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1760 Diamond St | 1 | Back Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6001927 | 2098732 | 37.7428272563398 | -122.435971568238 | (37.7428272563398, -122.435971568238) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 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 | ||||
| 29414 | 120559 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 298X Bemis St | 1 | Front Yard : Yard | Tree | Private 2 | 6002876 | 2096191 | 37.7359041225922 | -122.432508740106 | (37.7359041225922, -122.432508740106) | 2 | 7 | 5 | 63 | 7 | |||||
| 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 | |||
| 30069 | 256475 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2901X Sunset Blvd Off Ramp | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5985408 | 2095918 | 37.7341484934627 | -122.49288158081 | (37.7341484934627, -122.49288158081) | 1 | 8 | 3 | 29491 | 35 | ||||
| 30556 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 533 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 30591 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | 2 | 7 | 5 | 63 | 7 | ||||
| 30619 | 114927 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 30706 | 247061 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 626 30th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 6002557.97851 | 2098322.0779 | 37.7417375307638 | -122.43376053242 | (37.7417375307638, -122.43376053242) | 2 | 7 | 5 | 63 | 7 | ||||
| 30806 | 52742 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 432@ NOE 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | Permit Number 48791 | 6003090.32224136 | 2099513.72726182 | 37.7450397163723 | -122.4320049394 | (37.7450397163723, -122.4320049394) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 32407 | 234493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3278 Market St | 1 | : Yard | Tree | Private 2 | 14 | Width 3ft | 5999564.06934 | 2104457.47233 | 37.7584134931171 | -122.444553299888 | (37.7584134931171, -122.444553299888) | 2 | 4 | 5 | 28862 | 3 | |||
| 32419 | 110166 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 131x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
| 32957 | 233326 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 37 Seward St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6000943.20719 | 2104256.18118 | 37.7579393947945 | -122.439769208804 | (37.7579393947945, -122.439769208804) | 2 | 4 | 5 | 28862 | 38 | |||
| 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 | ||||
| 34428 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 22R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999148 | 2100052 | 37.7462933941297 | -122.445675437709 | (37.7462933941297, -122.445675437709) | 2 | 7 | 5 | 63 | 22 | |||||
| 34533 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 7X CASTRO ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002014.1 | 2108690 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | 15 | 5 | 5 | 29492 | 9 | ||||
| 34770 | 251426 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5020 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
| 35152 | 63257 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 465 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/1987 12:00:00 AM | 38 | Permit Number 23810 | 5984679.75149 | 2112668.94882 | 37.7800993277188 | -122.496635074658 | (37.7800993277188, -122.496635074658) | 11 | 6 | 2 | 55 | 26 | ||
| 35278 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999865 | 2112093 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | 15 | 5 | 1 | 29490 | 16 | ||||
| 35487 | 233299 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 130 Ripley St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 5ft | 6008878.43402 | 2099079.16382 | 37.7441729452414 | -122.411959903051 | (37.7441729452414, -122.411959903051) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 36006 | 96113 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.7797554116507 | -122.505713372558 | (37.7797554116507, -122.505713372558) | 11 | 6 | 2 | 55 | 26 |
| 36276 | 4984 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
| 36955 | 246780 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400 Franconia St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6009966.07903 | 2098719.00081 | 37.7432449779722 | -122.4081736511 | (37.7432449779722, -122.4081736511) | 10 | 7 | 7 | 28859 | 2 | |||
| 37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
| 37581 | 114212 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302 SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 64 | 5988825 | 2090618 | 37.7197952736455 | -122.480680205506 | (37.7197952736455, -122.480680205506) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||
| 38536 | 95334 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 466 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2011 12:00:00 AM | 75 | Permit Number 767212 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | ||
| 38797 | 173896 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 326x Dellbrook Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997295 | 2102064 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | 1 | 5 | 4 | 63 | 38 | ||||
| 39032 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 48R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
| 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 | ||||
| 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 | ||||
| 39842 | 108688 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1x MONTEZUMA ST | 1 | Median : Yard | Tree | DPW 1 | 20 | 6007361 | 2099793 | 37.7460477277002 | -122.417257445993 | (37.7460477277002, -122.417257445993) | 2 | 7 | 7 | 28859 | 2 | ||||
| 40061 | 211176 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 792 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 2ft | 5994165.53492 | 2089952.81071 | 37.7182777744803 | -122.462171779599 | (37.7182777744803, -122.462171779599) | 9 | 8 | 6 | 28861 | 24 | |||
| 40133 | 233305 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 170 Carnelian Way | 1 | : Yard | Tree | Private 2 | 17 | 6000606.98418 | 2100509.57943 | 37.7476329887819 | -122.440663274292 | (37.7476329887819, -122.440663274292) | 2 | 4 | 5 | 63 | 22 | ||||
| 40774 | 85020 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 299 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994525 | 2094707 | 37.7313523209144 | -122.461273710807 | (37.7313523209144, -122.461273710807) | 9 | 8 | 4 | 59 | 40 | |||||
| 40802 | 247205 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800 Duboce Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001896.21826 | 2108288.07588 | 37.7690641919786 | -122.436761914549 | (37.7690641919786, -122.436761914549) | 15 | 5 | 5 | 29492 | 9 | |||
| 40949 | 233334 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 91 Stanton St | 1 | : Yard | Tree | Private 2 | 15 | Width 3ft | 6000284.24588 | 2103856.40307 | 37.7568041715962 | -122.442019473547 | (37.7568041715962, -122.442019473547) | 2 | 4 | 5 | 28862 | 38 | |||
| 41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
| 42093 | 233321 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101 Glenbrook Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 23 | Width 10ft | 5997911.86978 | 2104120.74373 | 37.7573945063633 | -122.450243040706 | (37.7573945063633, -122.450243040706) | 15 | 5 | 4 | 28862 | 38 |
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) );