1,732 rows where qLegalStatus_id = 6 sorted by qSpecies_id 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)
194330 265002 Significant Tree 6 :: Tree 573 1445 San Bruno Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x5   6011217 2101257 37.7502837374969 -122.404026841996 (37.7502837374969, -122.404026841996) 10 4 8 28859 19
187309 106198 Significant Tree 6 Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 2101 42ND AVE 1 Front Yard : Yard Tree Private 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
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
128499 255151 Significant Tree 6 Araucaria bidwillii :: Bunya Bunya 551 201 Vicente St 4 Front Yard : Yard Tree Private 2       Width 3ft   5992494.60347 2097875.96956 37.7399364549038 -122.468523586018 (37.7399364549038, -122.468523586018) 1 8 4 59 40
128000 104003 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 2109 Steiner St 1 Sidewalk: Property side : Cutout Tree Private 2   07/17/2013 12:00:00 AM     Permit Number 767176 6002333.5 2115633.4 37.7892574480846 -122.435774995524 (37.7892574480846, -122.435774995524) 13 6 1 29490 27
157806 95777 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 30 Onondaga Ave   Front Yard : Yard Tree Private 2   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.7218615356817 -122.437972107548 (37.7218615356817, -122.437972107548) 9 7 6 28861 25
95583 102077 Significant Tree 6 Ulmus glabra :: Scotch Elm 531 273 Magellan Ave 7 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
92509 87216 Significant Tree 6 Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 500 Cortland Ave 2 Back Yard : Yard Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709) 2 7 7 28859 2
110002 62912 Significant Tree 6 Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 500 Cortland Ave 1 Back Yard : Yard Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007523.90359428 2097218.90762974 37.7389890062486 -122.416511839888 (37.7389890062486, -122.416511839888) 2 7 7 28859 2
68149 94937 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 504 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
138259 94938 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 504 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
182637 94936 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 504 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
101112 110321 Significant Tree 6 Ilex opaca :: American Holly 473 1x SAN PABLO AVE   Sidewalk: Curb side : Cutout Tree Private 2   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773 2097898 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756) 9 8 4 59 40
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
45878 173675 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
62378 173676 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
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
45754 94935 Significant Tree 6 Ficus carica 'Brown Turkey' :: Brown Turkey Fig 463 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
92359 120121 Significant Tree 6 Juglans hindsii :: Walnut: Black (n.calif) 457 444 Page St 1 Front Yard : Yard Tree Private 2           6004415 2109849 37.7734929358756 -122.428160854421 (37.7734929358756, -122.428160854421) 7 9 11 28852 10
40036 104493 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 1 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
69183 104494 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 2 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
35440 97955 Significant Tree 6 Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
33161 254729 Significant Tree 6 Cryptomeria japonica :: Japanese Cryptomeria 420 1940 Mission St 6 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
28942 110737 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
67675 110738 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
115682 111766 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1860 HAYES ST 4 Front Yard : Yard Tree SFUSD 4           5998973 2110255 37.7742982989317 -122.447014674672 (37.7742982989317, -122.447014674672) 15 5 11 29492 16
124026 110739 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
21762 100124 Significant Tree 6 Radermachera sinica :: China Doll Tree 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree Private 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
22895 256572 Significant Tree 6 Ilex aquifolium :: European Holly 390 175 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994536 2100823 37.748145970457 -122.461678955671 (37.748145970457, -122.461678955671) 1 8 4 29491 40
183573 104808 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 08th Ave   Front Yard : Yard Tree Private 2     40     5993673.5 2104163.7 37.7572689897716 -122.464904006701 (37.7572689897716, -122.464904006701) 1 8 4 56 12
183605 104761 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
186272 104762 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
102526 100433 Significant Tree 6 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 200X Stonecrest Dr 3 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
59354 102987 Significant Tree 6 Quercus palustris :: Pin Oak 379 161 Edgewood Ave 1 Front Yard : Yard Tree Private 2         Permit Number 769930 5996558.2 2106100.3 37.7627523048829 -122.455067580852 (37.7627523048829, -122.455067580852) 15 5 11 29492 12
96515 253513 Significant Tree 6 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1545 05th Ave 1 Front Yard : Yard Tree Private 2   08/14/2012 12:00:00 AM   3x3 Permit Number 768941 5994803.92058 2105050.88998 37.7597700982665 -122.461058902115 (37.7597700982665, -122.461058902115) 1 5 4 56 12
112975 107342 Significant Tree 6 Prunus laurocerasus :: English laurel 371 110 JULIAN AVE 1 Back Yard : Yard Tree Private 2     100     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
16142 94943 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
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
13844 260966 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
14462 261432 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
16010 260965 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
32199 253765 Significant Tree 6 Cornus SPP :: Dogwood 355 1366 Guerrero St 2 Front Yard : Yard Tree Private 2   02/14/2018 12:00:00 AM 3 3x3 Permit Number 780977 6005800.08489 2101007.66776 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761) 2 4 5 28859 19
182270 107121 Significant Tree 6 Cercis canadensis :: Eastern Redbud 346 1054 GUERRERO ST 1 Front Yard : Yard Tree Private 2     6     6005686.8 2102852.5 37.7543540785936 -122.423264063467 (37.7543540785936, -122.423264063467) 2 4 5 28859 19
60074 98947 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 401 Grove St 7 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
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
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
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
188246 115749 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
44345 253366 Significant Tree 6 Ficus carica :: Edible Fig 341 20 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004582 2109434 37.7723628942784 -122.427553605007 (37.7723628942784, -122.427553605007) 7 9 11 28852 10
90493 108096 Significant Tree 6 Ficus rubiginosa :: Port Jackson Fig 339 3370 Washington St 1 Front Yard : Cutout Tree Private 2     17   Permit Number 773610 5998674.83986 2115933.37372 37.7898725948813 -122.448455078738 (37.7898725948813, -122.448455078738) 13 6 1 54 31
12431 262225 Significant Tree 6 Cupressus spp :: Cypress species 337 2450 Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5997659.54255 2111324.05825 37.7771585265736 -122.451635273045 (37.7771585265736, -122.451635273045) 15 6 2 54 16
10123 257894 Significant Tree 6 Metrosideros robusta :: Northern Rata Tree 335 1776 Vallejo St 1 Front Yard : Yard Tree Private 2   01/27/2020 12:00:00 AM 3     6005064 2118169 37.7963742870274 -122.426508408066 (37.7963742870274, -122.426508408066) 13 9 1 28858 17
36736 101527 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 151-153 Lower Ter 1 Front Yard : Yard Tree Private 2     18   Permit Number 769490 6000139.7 2106146.6 37.7630842500585 -122.4426838025 (37.7630842500585, -122.4426838025) 15 5 5 28862 3
107229 255805 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 2 Sola Ave 1 Front Yard : Yard Tree Private 2       10x10   5994994 2100719 37.7478867659483 -122.460087684856 (37.7478867659483, -122.460087684856) 1 8 4 29491 40
113215 108560 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 3790 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003155.9 2103640.4 37.7563743055091 -122.432072816055 (37.7563743055091, -122.432072816055) 2 4 5 28862 3
139989 100474 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 2 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
189375 100473 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 1 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
112541 255922 Significant Tree 6 Alnus rhombifolia :: White Alder 327 554 Clipper St 1 Front Yard : Yard Tree Private 2       3x3   6001599 2100911 37.7487916364102 -122.437261685392 (37.7487916364102, -122.437261685392) 2 4 5 28862 22
8743 261207 Significant Tree 6 Umbellularia californica :: California Bay 326 2301 Leavenworth St 3 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
61598 99299 Significant Tree 6 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 1457 Willard St 1 Front Yard : Tree Private 2   05/02/2012 12:00:00 AM     Permit Number 768720 5996809.7 2106270.3 37.763233506694 -122.454210015753 (37.763233506694, -122.454210015753) 15 5 11 29492 12
43399 117435 Significant Tree 6 Salix babylonica :: Weeping Willow 308 98X CLIPPER ST 1 Back Yard : Yard Tree Private 2           6004559 2101087 37.7494427139243 -122.427038546128 (37.7494427139243, -122.427038546128) 2 4 5 28862 22
89812 107834 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
134585 24480 Significant Tree 6 Salix babylonica :: Weeping Willow 308 108X Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780363 6002195.08262 2096706.93645 37.737282128351 -122.434899824187 (37.737282128351, -122.434899824187) 2 7 5 63 7
170160 107835 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
105349 114158 Significant Tree 6 Prunus armeniaca :: Apricot 296 1200X JUNIPERO SERRA BLVD 6 Front Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 63 38
11981 261158 Significant Tree 6 Juniperus californica :: California juniper 295 1100X Moraga St 2 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
15591 262378 Significant Tree 6 Yucca spp :: Yucca 289 2172 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002662 2118213 37.796359019498 -122.434822974351 (37.796359019498, -122.434822974351) 13 9 1 57 17
194287 264983 Significant Tree 6 Yucca spp :: Yucca 289 2957 22nd St   Front Yard : Cutout Tree Private 2       3x3   6008491 2103259 37.7556280948319 -122.41359514096 (37.7556280948319, -122.41359514096) 2 4 7 28859 19
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
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
187289 115806 Significant Tree 6 Robinia pseudoacacia :: Black Locust 286 362 MISSOURI ST 1 Front Yard : Cutout Tree Private 2     12 3x3   6013446 2105415 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099) 10 3 8 28856 29
24927 107413 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 276 Yerba Buena Ave 1 Front Yard : Yard Tree Private 2     28     5995080.66446 2095640.15746 37.7339465073544 -122.459420244296 (37.7339465073544, -122.459420244296) 9 8 4 59 40
156060 253715 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 2959 21st Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x15 Permit Number 780322 5989962 2095532 37.7333538971055 -122.477108940264 (37.7333538971055, -122.477108940264) 1 8 4 64 35
166922 103307 Significant Tree 6 Pyrus spp :: Pear Tree 281 1467 Willard St 1 Front Yard : Yard Tree Private 2   04/02/2013 12:00:00 AM 5 6x6 Permit Number 768689 5996817.5 2106175 37.7629722844649 -122.454176154627 (37.7629722844649, -122.454176154627) 15 5 11 29492 12
37050 252828 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 3852 17th St 7 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
158642 94066 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 548 Page St   Front Yard : Tree Private 2   06/02/2010 12:00:00 AM     Permit Number 53460 6003937 2109751 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526) 7 9 11 29492 10
189693 252829 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 3852 17th St 8 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
3842 109772 Significant Tree 6 Yucca elephantipes :: Giant Yucca 268 2200x SAN JOSE AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
3726 94934 Significant Tree 6 Ficus carica 'Black Mission' :: Black Mission Fig 265 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
27222 258201 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
33311 258200 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
139544 104085 Significant Tree 6 Populus spp :: Poplar Spp 262 1329 Stanyan St 1 Front Yard : Yard Tree Private 2   08/07/2013 12:00:00 AM     Permit Number 770194 5997530.4 2104741.3 37.7590765601241 -122.451607069148 (37.7590765601241, -122.451607069148) 15 5 4 28862 12
163996 258199 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
18868 260249 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 10 Crestline Dr 1 Median : Yard Tree Private 2       3x3   5999247 2101231 37.7495362941779 -122.445417868856 (37.7495362941779, -122.445417868856) 2 5 5 63 38
51737 116458 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 1 Sidewalk: Curb side : Yard Tree Private 2     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327) 1 8 4 64 14
63542 116459 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 2 Sidewalk: Curb side : Yard Tree Private 2     20 10x20 Permit Number 777772 5989848.42836 2088633.83291 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287) 1 8 4 64 14
8183 261995 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 2 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
13981 261996 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 1 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
15717 221238 Significant Tree 6 Betula pendula :: European White Birch 253 55 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 3ft   6009363.02974 2097125.97708 37.7388370966643 -122.41014640214 (37.7388370966643, -122.41014640214) 10 7 7 28859 2
76411 104900 Significant Tree 6 Betula pendula :: European White Birch 253 317 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
91742 114074 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     5     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
127778 114100 Significant Tree 6 Betula pendula :: European White Birch 253 21x ACEVEDO AVE 1 Front Yard : Yard Tree Private 2     10     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
156777 114101 Significant Tree 6 Betula pendula :: European White Birch 253 21x ACEVEDO AVE 2 Front Yard : Yard Tree Private 2     7     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
161250 114073 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
22915 92852 Significant Tree 6 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 3794 16th St 1 Front Yard : Yard Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901 2106436 37.7639791186972 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3
79851 94940 Significant Tree 6 Morus alba :: White Mulberry 246 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
133191 94939 Significant Tree 6 Morus alba :: White Mulberry 246 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
144050 94941 Significant Tree 6 Morus alba :: White Mulberry 246 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

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