trees
1,732 rows where qLegalStatus_id = 6 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181784 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.46484 | 37.7328958169551 | -122.491498163849 | (37.7328958169551, -122.491498163849) | 1 | 8 | 4 | 64 | 35 | |||
181750 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
181560 | 256493 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 400 Rolph St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002004 | 2087744 | 37.7126610773499 | -122.434919679914 | (37.7126610773499, -122.434919679914) | 9 | 7 | 6 | 28861 | 5 | ||||
181535 | 173677 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 464 | 299x Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
181383 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 755 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990427 | 2090598 | 37.7198333383806 | -122.475141254145 | (37.7198333383806, -122.475141254145) | 1 | 8 | 4 | 64 | 40 | |||||
181284 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
180810 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | |||
180754 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
180735 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
180538 | 116957 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 10x Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||||
180522 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
180439 | 108197 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 930 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | 2 | 4 | 7 | 28859 | 19 | |||||
180419 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 2040 Jackson St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | 13 | 9 | 1 | 28858 | 27 | ||
180298 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
180131 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 21X BELMONT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 48 | 5996611 | 2106266 | 37.7632103037359 | -122.454896938495 | (37.7632103037359, -122.454896938495) | 15 | 5 | 11 | 29492 | 12 | ||||
179978 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600X OAKDALE AVE | 1 | Front Yard : Yard | Tree | Arts Commission 19 | 13 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
179763 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 568 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
179756 | 112920 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
179476 | 115460 | Significant Tree 6 | Tree(s) :: 17 | 80 Crestline Dr | 2 | Back Yard : Yard | Tree | Private 2 | 02/02/2016 12:00:00 AM | 3 | Permit Number 776150 | 5999012.8 | 2102131.7 | 37.7519960240451 | -122.446292521132 | (37.7519960240451, -122.446292521132) | 2 | 5 | 5 | 63 | 38 | ||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
179316 | 112056 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 762 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5991999 | 2110277 | 37.7739577928787 | -122.47114039751 | (37.7739577928787, -122.47114039751) | 11 | 6 | 2 | 54 | 11 | |||
179237 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
178948 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 25 MIDCREST WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 5997992 | 2100464 | 37.7473585772285 | -122.44970241305 | (37.7473585772285, -122.44970241305) | 1 | 5 | 4 | 63 | 38 | ||||
178584 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 140x TOPAZ WAY | 2 | Front Yard : Yard | Tree | Private 2 | 30 | Permit Number 775551 | 6001767 | 2098265 | 37.7415358930081 | -122.436491384585 | (37.7415358930081, -122.436491384585) | 2 | 7 | 5 | 63 | 7 | |||
178545 | 105871 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
178454 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard | Tree | Private 2 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051412 | (37.7332919614683, -122.45317051412) | 9 | 7 | 4 | 59 | 40 | |||
178439 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 198X JENNINGS ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6018784 | 2097136 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | 10 | 3 | 8 | 58 | 1 | |||||
178383 | 254277 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 105 Gladeview Way | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | Permit Number 781296 | 5997754 | 2101950 | 37.7514251480437 | -122.450632514859 | (37.7514251480437, -122.450632514859) | 1 | 5 | 4 | 63 | 38 | |||
178381 | 254173 | Significant Tree 6 | Geijera parviflora :: Australian Willow 25 | 1850 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x6 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | ||||
178107 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
178096 | 117248 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x GRAYSTONE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999641 | 2104067 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | 2 | 5 | 5 | 28862 | 3 | ||||
178069 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 520X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||
178015 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
177784 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 470 | 50x CHUMASERO DR | 1 | Front Yard : Yard | Tree | Private 2 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |||||
177763 | 255250 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 209x Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
177640 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 30X Zircon Pl | 1 | Back Yard : Yard | Tree | Private 2 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.434652757436 | (37.7430068656447, -122.434652757436) | 2 | 7 | 5 | 63 | 7 | |||||
177584 | 234000 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 749 27th St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 10ft | 6001659.60779 | 2099970.43439 | 37.7462125114091 | -122.436984776447 | (37.7462125114091, -122.436984776447) | 2 | 7 | 5 | 63 | 22 | |||
177581 | 251609 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
177345 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout | Tree | Private 2 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497 | 2117826 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | 13 | 9 | 1 | 29490 | 27 | |
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
177168 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
177119 | 114191 | Significant Tree 6 | Tree(s) :: 17 | 201 Delano Ave | 7 | Back Yard : Yard | Tree | Private 2 | 20 | Permit Number 776814 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | 9 | 7 | 6 | 28861 | 25 | |||
177101 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 615 Rhode Island St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.402118605761 | (37.7619062576766, -122.402118605761) | 10 | 3 | 8 | 28856 | 29 | ||||
177074 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
176886 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 3 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
176820 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | 13 | 9 | 1 | 57 | 17 | ||
176793 | 98949 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 9 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
176722 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 701 Noe St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.7577272573137 | -122.432146391441 | (37.7577272573137, -122.432146391441) | 2 | 4 | 5 | 28862 | 3 | ||||
176646 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.7221229357531 | -122.471434223035 | (37.7221229357531, -122.471434223035) | 9 | 8 | 4 | 59 | 40 | ||||
176521 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard | Tree | MTA 3 | 7 | Width 5ft | 5998933.17773 | 2091518.16383 | 37.7228492325857 | -122.445804632792 | (37.7228492325857, -122.445804632792) | 9 | 7 | 6 | 28861 | 25 | |||
176305 | 112927 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
175794 | 114405 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 500X ARBALLO DR | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
175722 | 107138 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 700X Stevenson St | 3 | Front Yard : Yard | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.34042 | 2111440.428 | 37.7780897748997 | -122.414335356247 | (37.7780897748997, -122.414335356247) | 8 | 2 | 9 | 28853 | 34 | |||
175631 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 2 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
175545 | 92054 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1001 Potrero Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
175413 | 96996 | Significant Tree 6 | Malus :: Crab Apple 82 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
175269 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
175229 | 107058 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 600X Front St | 2 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 14 | Permit Number 771755 | 6012887.2102 | 2118277.80134 | 37.797112176041 | -122.399445910496 | (37.797112176041, -122.399445910496) | 3 | 1 | 10 | 28860 | 6 | ||
174752 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
174679 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 286 | 55X Perine Pl | 1 | Back Yard : Cutout | Tree | Private 2 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | 13 | 6 | 1 | 29490 | 27 | ||||
174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
174218 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
174212 | 104782 | Significant Tree 6 | Tree(s) :: 17 | 246-290X Eddy St | 2 | Front Yard : Yard | Tree | Private 2 | 6009232.7 | 2113643.9 | 37.7841842385635 | -122.411763863717 | (37.7841842385635, -122.411763863717) | 14 | 10 | 9 | 28852 | 36 | |||||
173974 | 251394 | Significant Tree 6 | Araucaria araucana :: Monkey puzzle 287 | 203 Corbett Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779803 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |
173894 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 400x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5988116 | 2090625 | 37.7197732605649 | -122.48313145165 | (37.7197732605649, -122.48313145165) | 1 | 8 | 4 | 64 | 14 | |||
173820 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 606 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
173819 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
173815 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998921.08183 | 2091519.29315 | 37.7228516427808 | -122.445846526795 | (37.7228516427808, -122.445846526795) | 9 | 7 | 6 | 28861 | 25 | |||
173631 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 68 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
173581 | 251197 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779570 | 6002798.55883 | 2107703.57748 | 37.7675105430125 | -122.433598998019 | (37.7675105430125, -122.433598998019) | 15 | 5 | 5 | 28862 | 3 | ||
173544 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
173520 | 258387 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2770 Lombard St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999223 | 2119112 | 37.7986315842223 | -122.446787313103 | (37.7986315842223, -122.446787313103) | 13 | 9 | 1 | 57 | 17 | |||||
173273 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6007547 | 2093670 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | 9 | 3 | 7 | 309 | 28 | |||||
173122 | 112354 | Significant Tree 6 | Tree(s) :: 17 | 300 Moncada Way | 1 | Front Yard : Yard | Tree | Private 2 | 01/04/2016 12:00:00 AM | 10x10 | Permit Number 775546 | 5992209.2 | 2093928.1 | 37.729080105492 | -122.469223117768 | (37.729080105492, -122.469223117768) | 9 | 8 | 4 | 59 | 40 | ||
173080 | 105857 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1500X Valencia St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006259.2 | 2100711.5 | 37.7485076710609 | -122.421132539956 | (37.7485076710609, -122.421132539956) | 2 | 4 | 5 | 28859 | 19 | ||||
172960 | 173598 | Significant Tree 6 | Casuarina cunninghamiana :: Horsetail pine 112 | 1771 11th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992768 | 2103420 | 37.7551747322674 | -122.467981458634 | (37.7551747322674, -122.467981458634) | 1 | 8 | 4 | 56 | 12 | |||
172848 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 524 45th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 773704 | 5981973.19232 | 2112153.30127 | 37.7785245664452 | -122.505959887315 | (37.7785245664452, -122.505959887315) | 11 | 6 | 2 | 55 | 26 | ||||
172767 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard | Tree | Private 2 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.7543910951738 | -122.455633951336 | (37.7543910951738, -122.455633951336) | 1 | 5 | 4 | 63 | 12 | |||
172650 | 255483 | Significant Tree 6 | Persea americana :: Avocado 34 | 1295 Hampshire St | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6010340.83328 | 2101731.71507 | 37.7515382084299 | -122.407090155993 | (37.7515382084299, -122.407090155993) | 10 | 4 | 7 | 28859 | 19 | ||||
172566 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
172555 | 120560 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 76 | 17X Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002113 | 2108564 | 37.7698341292575 | -122.436031827668 | (37.7698341292575, -122.436031827668) | 15 | 5 | 5 | 29492 | 9 | ||||
172353 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1337 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.464832777968 | (37.7396363671104, -122.464832777968) | 1 | 8 | 4 | 59 | 40 | |||||
172328 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.7959478507639 | -122.422745597666 | (37.7959478507639, -122.422745597666) | 13 | 9 | 10 | 28858 | 32 | |||
172310 | 113770 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 6001403.30227 | 2117311.89486 | 37.7938132775122 | -122.439113709125 | (37.7938132775122, -122.439113709125) | 13 | 9 | 1 | 57 | 27 | ||||
172262 | 103613 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
171763 | 106405 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4849X 19th St | Front Yard : Yard | Tree | Private 2 | Permit Number 772769 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
171749 | 253384 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 55 Cerritos Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5992588 | 2092941 | 37.7263916542788 | -122.46784182224 | (37.7263916542788, -122.46784182224) | 9 | 8 | 4 | 59 | 40 | ||||
171699 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.52821 | 37.8031223210123 | -122.418746939923 | (37.8031223210123, -122.418746939923) | 5 | 1 | 1 | 28858 | 32 | |
171448 | 121196 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 255x Red Rock Way | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
171446 | 257980 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 782825 | 5999909.76407 | 2117098.92712 | 37.7931434275556 | -122.444266160734 | (37.7931434275556, -122.444266160734) | 13 | 9 | 1 | 57 | 27 | ||||
171136 | 84937 | Significant Tree 6 | Tree(s) :: 17 | 145 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770120 | 6005480 | 2108218 | 37.7690748022624 | -122.42436083172 | (37.7690748022624, -122.42436083172) | 8 | 4 | 5 | 28853 | 19 | ||||
171061 | 100551 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 3 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
171046 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
170978 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 455X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | 7 | 9 | 11 | 28852 | 10 | |||||
170957 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : | Tree | Rec/Park 5 | Permit Number 771218 | 6006277 | 2104934 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | 2 | 4 | 7 | 28859 | 19 | ||||
170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
170900 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 4 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
170834 | 107493 | Significant Tree 6 | Tree(s) :: 17 | 180 BARTLETT ST | 1 | Back Yard : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 774017 | 6006657.2 | 2102756.7 | 37.7541457516772 | -122.419901368465 | (37.7541457516772, -122.419901368465) | 2 | 4 | 7 | 28859 | 19 |
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) );