trees
27,746 rows where qCaretaker_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 264841 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
| 21 | 264839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
| 32 | 264850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 172 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007951 | 2093149 | 37.7278379340298 | -122.414747181337 | (37.7278379340298, -122.414747181337) | 9 | 3 | 7 | 309 | 5 | |||
| 49 | 261834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20x Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||
| 55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
| 133 | 211075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | 9 | 7 | 4 | 28861 | 40 | ||||
| 173 | 27068 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4 | 6006971.0744 | 2093616.11167 | 37.7290654140285 | -122.418167915919 | (37.7290654140285, -122.418167915919) | 9 | 3 | 7 | 309 | 28 | |||
| 184 | 204541 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 4 | Median : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5999538.51913 | 2097033.8732 | 37.7380286277303 | -122.444108242518 | (37.7380286277303, -122.444108242518) | 9 | 7 | 4 | 59 | 40 | |||
| 210 | 1023 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1925 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000937.4135 | 2090832.4174 | 37.7210805620079 | -122.438827310136 | (37.7210805620079, -122.438827310136) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||||
| 263 | 17585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 383 | 94356 | DPW Maintained 1 | Tree(s) :: 17 | 455 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999581.42646 | 2091332.3229 | 37.7223759483442 | -122.443550437353 | (37.7223759483442, -122.443550437353) | 9 | 7 | 6 | 28861 | 25 | ||||
| 384 | 415 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X6 | 5990878.96388 | 2090116.60552 | 37.7185377326944 | -122.473543893183 | (37.7185377326944, -122.473543893183) | 9 | 8 | 4 | 64 | 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 | |||
| 444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 471 | 205972 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 400x Marietta Dr | 49 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5998976.04571 | 2096922.6715 | 37.7376911903888 | -122.446044988292 | (37.7376911903888, -122.446044988292) | 9 | 7 | 4 | 59 | 40 | |||
| 485 | 251655 | DPW Maintained 1 | Shrub :: Shrub 66 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5991691 | 2087193 | 37.7105572148468 | -122.470524229297 | (37.7105572148468, -122.470524229297) | 9 | 8 | 4 | 64 | 24 | ||||
| 519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
| 639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
| 840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
| 1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
| 1200 | 216506 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 900x Bosworth St | 13 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001233.37936 | 2095653.14321 | 37.7343340068125 | -122.438149402085 | (37.7343340068125, -122.438149402085) | 9 | 7 | 5 | 63 | 40 | |||
| 1211 | 261654 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1150 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000820 | 2086851 | 37.7101418008042 | -122.43894799201 | (37.7101418008042, -122.43894799201) | 9 | 7 | 6 | 28861 | 5 | ||||
| 1231 | 15974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.84227 | 37.7084254991124 | -122.453517403906 | (37.7084254991124, -122.453517403906) | 9 | 7 | 6 | 28861 | 5 | ||
| 1291 | 122854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996671.62099 | 2087298.1542 | 37.7111326815096 | -122.453317797602 | (37.7111326815096, -122.453317797602) | 9 | 7 | 6 | 28861 | 25 | ||
| 1412 | 259415 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
| 1424 | 264758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
| 1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
| 1569 | 262185 | DPW Maintained 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 210 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010173.92032 | 2088318.83679 | 37.7146999535571 | -122.406722203929 | (37.7146999535571, -122.406722203929) | 9 | 7 | 8 | 309 | 39 | ||
| 1570 | 172003 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6009403.11273 | 2093936.36515 | 37.7300813538655 | -122.409782729785 | (37.7300813538655, -122.409782729785) | 9 | 3 | 7 | 309 | 28 | ||
| 1604 | 15896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5635 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998509.62683 | 2087220.10589 | 37.7110235586697 | -122.446959612304 | (37.7110235586697, -122.446959612304) | 9 | 7 | 6 | 28861 | 5 | ||
| 1612 | 11759 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
| 2092 | 262061 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
| 2237 | 2013 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 500X Bosworth St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6002577.18847 | 2095292.92439 | 37.7334212632741 | -122.433477690263 | (37.7334212632741, -122.433477690263) | 9 | 7 | 5 | 63 | 40 | |||
| 2284 | 122861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996437.5077 | 2087153.60444 | 37.7107223595138 | -122.454116512475 | (37.7107223595138, -122.454116512475) | 9 | 7 | 6 | 28861 | 25 | ||
| 2379 | 27111 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 497 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x4 | 6004667.95957 | 2093529.09628 | 37.7286965849625 | -122.426123777405 | (37.7286965849625, -122.426123777405) | 9 | 7 | 6 | 28861 | 5 | |||
| 2387 | 204545 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 73 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999723.14356 | 2097244.03838 | 37.7386162222515 | -122.44348499884 | (37.7386162222515, -122.44348499884) | 9 | 7 | 4 | 59 | 40 | |||
| 2393 | 261835 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 20x Ruth St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||||
| 2477 | 26317 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2045 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 3 | 3X3 | 5999556.95115 | 2091956.24005 | 37.7240876853785 | -122.443679842351 | (37.7240876853785, -122.443679842351) | 9 | 7 | 6 | 28861 | 25 | ||
| 2496 | 331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 2523 | 162706 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 700 Grafton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5994645.44681 | 2090598.07212 | 37.7200771290263 | -122.460559671092 | (37.7200771290263, -122.460559671092) | 9 | 8 | 6 | 28861 | 24 | |||
| 2550 | 1015 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1854X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6001128.27711 | 2091386.71553 | 37.7226133962853 | -122.438207240029 | (37.7226133962853, -122.438207240029) | 9 | 7 | 6 | 28861 | 25 | |||
| 2600 | 258371 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
| 2626 | 259634 | DPW Maintained 1 | :: 45 | 83 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010826.96041 | 2087682.93228 | 37.7129904051639 | -122.404420283412 | (37.7129904051639, -122.404420283412) | 9 | 7 | 8 | 309 | 39 | ||
| 2760 | 111440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 12 | 5999883.47669 | 2091070.55057 | 37.7216744032298 | -122.442487538293 | (37.7216744032298, -122.442487538293) | 9 | 7 | 6 | 28861 | 25 | |||
| 2764 | 262058 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 9 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 2781 | 256736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1266 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6000975.18369 | 2087214.83327 | 37.7111496346342 | -122.438437697477 | (37.7111496346342, -122.438437697477) | 9 | 7 | 6 | 28861 | 5 | ||||
| 2820 | 899 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418 | (37.7307693064514, -122.43007470418) | 9 | 7 | 6 | 28861 | 25 | |||
| 2829 | 264759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 2903 | 251423 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/2020 12:00:00 AM | 3 | 3x3 | 5999946 | 2089791 | 37.7181646124566 | -122.4421796072 | (37.7181646124566, -122.4421796072) | 9 | 7 | 6 | 28861 | 25 | ||
| 2966 | 259413 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
| 3007 | 27222 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 371 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | 6003827.51824 | 2093508.67438 | 37.7285929731823 | -122.429027779127 | (37.7285929731823, -122.429027779127) | 9 | 7 | 6 | 28861 | 5 | |||
| 3008 | 251503 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 800X Bosworth St | 15 | Side Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 3046 | 258383 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3064 | 111546 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 24 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 3119 | 264752 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 3153 | 16204 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 504 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 5998737.42681 | 2094729.30283 | 37.7316550910092 | -122.446712233977 | (37.7316550910092, -122.446712233977) | 9 | 7 | 4 | 59 | 40 | |||
| 3194 | 259639 | DPW Maintained 1 | :: 45 | 122 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010584.82353 | 2087852.62198 | 37.7134428042481 | -122.405269135112 | (37.7134428042481, -122.405269135112) | 9 | 7 | 8 | 309 | 39 | ||
| 3244 | 208266 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | 9 | 7 | 4 | 59 | 40 | |||
| 3256 | 256623 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 162 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/10/2019 02:37:00 PM | 3 | 3x3 | 5994333.67195 | 2093080.20894 | 37.7268745363156 | -122.461817248026 | (37.7268745363156, -122.461817248026) | 9 | 8 | 4 | 28861 | 40 | ||
| 3286 | 264753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 176 Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 3342 | 258384 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3354 | 258363 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 526 Silliman St | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009244.29167 | 2093882.64592 | 37.7299249505577 | -122.410328004922 | (37.7299249505577, -122.410328004922) | 9 | 3 | 7 | 309 | 28 | ||||
| 3376 | 25308 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 279X Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6000039.97311 | 2091577.86047 | 37.7230762793257 | -122.441982968035 | (37.7230762793257, -122.441982968035) | 9 | 7 | 6 | 28861 | 25 | ||
| 3520 | 259641 | DPW Maintained 1 | :: 45 | 234 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009944.29036 | 2088126.34972 | 37.7141585726669 | -122.407502340313 | (37.7141585726669, -122.407502340313) | 9 | 7 | 8 | 309 | 39 | ||
| 3541 | 258357 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 446 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009476.28698 | 2093953.76582 | 37.7301332328809 | -122.409530983744 | (37.7301332328809, -122.409530983744) | 9 | 3 | 7 | 309 | 28 | |||
| 3567 | 261836 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 20x Ruth St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||||
| 3607 | 262063 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 3618 | 122859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996503.07173 | 2087192.19332 | 37.7108320750073 | -122.453892694613 | (37.7108320750073, -122.453892694613) | 9 | 7 | 6 | 28861 | 25 | ||
| 3621 | 259642 | DPW Maintained 1 | :: 45 | 238 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009920.83207 | 2088134.90851 | 37.7141807602716 | -122.407584024659 | (37.7141807602716, -122.407584024659) | 9 | 7 | 8 | 309 | 39 | ||
| 3648 | 262535 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6001472.85598 | 2090996.66296 | 37.7215619917613 | -122.43698819828 | (37.7215619917613, -122.43698819828) | 9 | 7 | 6 | 28861 | 5 | ||
| 3653 | 16338 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 862X Monterey Blvd | 8 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996505.10477 | 2094713.35848 | 37.7314835390346 | -122.454428620411 | (37.7314835390346, -122.454428620411) | 9 | 7 | 4 | 59 | 40 | ||
| 3696 | 262180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 263 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009676.04228 | 2087903.41357 | 37.713531417046 | -122.408413797613 | (37.713531417046, -122.408413797613) | 9 | 7 | 8 | 309 | 39 | ||
| 3698 | 181258 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400x Bay Shore Blvd | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | 9 | 7 | 8 | 309 | 1 | |||
| 3712 | 171727 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007391.28997 | 2093272.37114 | 37.7281452205055 | -122.416690852302 | (37.7281452205055, -122.416690852302) | 9 | 3 | 7 | 309 | 5 | ||
| 3714 | 19086 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994700.7848896 | 2087405.1340273 | 37.7113132610353 | -122.460137187577 | (37.7113132610353, -122.460137187577) | 9 | 8 | 6 | 28861 | 24 | |||
| 3773 | 258127 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1000 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009416.09812 | 2091494.49671 | 37.7233772263446 | -122.409565560368 | (37.7233772263446, -122.409565560368) | 9 | 3 | 7 | 309 | 28 | |||
| 3785 | 258385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | ||||
| 3830 | 91437 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 02/22/2012 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | 9 | 7 | 4 | 59 | 40 | |||
| 3881 | 11625 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 300X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | |||
| 3926 | 15058 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 10X Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996572.9500165 | 2089038.2134875 | 37.7159048245128 | -122.45378440062 | (37.7159048245128, -122.45378440062) | 9 | 8 | 6 | 28861 | 24 | |||
| 3933 | 258362 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 520 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009260.75409 | 2093887.69259 | 37.7299397304564 | -122.410271448334 | (37.7299397304564, -122.410271448334) | 9 | 3 | 7 | 309 | 28 | ||||
| 3960 | 28454 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993123.43173 | 2093088.843 | 37.7268284984876 | -122.466001612774 | (37.7268284984876, -122.466001612774) | 9 | 8 | 4 | 59 | 40 | ||
| 3974 | 2063 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Bosworth St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001908.8431877 | 2095495.9697002 | 37.7339408370986 | -122.435802866841 | (37.7339408370986, -122.435802866841) | 9 | 7 | 5 | 63 | 7 | |||
| 4048 | 255910 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 85 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6007891 | 2093604 | 37.7290838947974 | -122.414986794268 | (37.7290838947974, -122.414986794268) | 9 | 3 | 7 | 309 | 28 | ||
| 4125 | 217527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5996233.42463 | 2089002.36528 | 37.7157869222112 | -122.454955363219 | (37.7157869222112, -122.454955363219) | 9 | 8 | 6 | 28861 | 24 | |||
| 4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
| 4183 | 204530 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 28 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5999185.819 | 2097019.37186 | 37.7379686834 | -122.445326654823 | (37.7379686834, -122.445326654823) | 9 | 7 | 4 | 59 | 40 | |||
| 4184 | 162705 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 700 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5994663.02021 | 2090597.39113 | 37.7200762701851 | -122.460498876921 | (37.7200762701851, -122.460498876921) | 9 | 8 | 6 | 28861 | 24 | |||
| 4234 | 259615 | DPW Maintained 1 | :: 45 | 935 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009702.19768 | 2087158.08788 | 37.7114863694621 | -122.408270858441 | (37.7114863694621, -122.408270858441) | 9 | 7 | 8 | 309 | 39 | ||
| 4322 | 176167 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 240 Hahn St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 9 | Width 10ft | 6007417.45559 | 2087310.83088 | 37.7117775673588 | -122.416178356572 | (37.7117775673588, -122.416178356572) | 9 | 7 | 8 | 309 | 39 | |||
| 4326 | 259417 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
| 4402 | 27703 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995069.03366 | 2092243.1445 | 37.7246184644438 | -122.459214548241 | (37.7246184644438, -122.459214548241) | 9 | 8 | 4 | 28861 | 40 | ||
| 4483 | 262070 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 800X Alemany Blvd | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 4595 | 162708 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 814 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5994351.29027 | 2090603.92426 | 37.7200762701772 | -122.461576887074 | (37.7200762701772, -122.461576887074) | 9 | 8 | 6 | 28861 | 24 |
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) );