1,732 rows where qLegalStatus_id = 6 sorted by rowid descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);