trees
194,517 rows sorted by qSpecies_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194322 | 236900 | DPW Maintained 1 | :: Tree 573 | 240 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997562.78425 | 2106158.57847 | 37.7629699037624 | -122.451597300975 | (37.7629699037624, -122.451597300975) | 15 | 5 | 11 | 29492 | 9 | |||
194323 | 264998 | DPW Maintained 1 | :: Tree 573 | 712 Francisco St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007843 | 2120971 | 37.8042245839852 | -122.417091095202 | (37.8042245839852, -122.417091095202) | 5 | 1 | 1 | 308 | 32 | |||||
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 | ||||
194479 | 265136 | Undocumented 4 | :: Tree 573 | 100 Winston Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | ||||
188263 | 197368 | DPW Maintained 1 | Rhopalostylis sapida :: Nikau palm 572 | 601 Wisconsin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012729.08438 | 2104643.98882 | 37.7596680383615 | -122.399035624504 | (37.7596680383615, -122.399035624504) | 10 | 3 | 8 | 28856 | 29 | |||
187445 | 228853 | DPW Maintained 1 | Livistona chinensis :: Chinese fan palm 571 | 450 Florida St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009178.83927 | 2106284.10805 | 37.7639729536174 | -122.41143007465 | (37.7639729536174, -122.41143007465) | 8 | 4 | 7 | 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 | ||||
182219 | 205975 | DPW Maintained 1 | Cedrus libani :: Lebanon cedar 569 | 5 Sequoia Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998211.61791 | 2097832.09967 | 37.7401445796092 | -122.448753454923 | (37.7401445796092, -122.448753454923) | 9 | 7 | 4 | 59 | 40 | |||
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 | ||||
175075 | 94587 | Permitted Site 7 | Persea americana 'Stewart' :: Stewart Avocado 567 | 4072 24th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2010 12:00:00 AM | 3x3 | Permit Number 53764 | 6002706 | 2101836 | 37.7513943353159 | -122.433499781921 | (37.7513943353159, -122.433499781921) | 2 | 4 | 5 | 28862 | 22 | |||
171848 | 245129 | DPW Maintained 1 | Catalpa speciosa :: Northern Catalpa 566 | 1262 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000511.2695 | 2109276.7485 | 37.771700032393 | -122.441623315797 | (37.771700032393, -122.441623315797) | 15 | 5 | 11 | 29492 | 9 | |||
166943 | 234869 | DPW Maintained 1 | Populus deltoides :: Eastern cottonwood 565 | 483 Valley St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 6002812.52473 | 2099166.42238 | 37.7440703451703 | -122.432940705074 | (37.7440703451703, -122.432940705074) | 2 | 7 | 5 | 63 | 22 | ||||
166294 | 34624 | DPW Maintained 1 | Pinus torreyana :: Torrey Pine 564 | 1440 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 12 | Permit Number 38306 | 5988698.57904624 | 2105516.51025916 | 37.7606953425859 | -122.482208131756 | (37.7606953425859, -122.482208131756) | 1 | 8 | 3 | 56 | 35 | |
165553 | 123889 | DPW Maintained 1 | Acer platanoides 'Crimson King' :: Norway maple 563 | 283 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992122.19798 | 2113578.66539 | 37.7830303911399 | -122.470954805393 | (37.7830303911399, -122.470954805393) | 11 | 6 | 2 | 54 | 11 | |||
155365 | 193472 | DPW Maintained 1 | Prunus persica nectarina :: Flowering Nectarine Tree 562 | 1059 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013665.43892 | 2089838.84889 | 37.7190683424156 | -122.394760377916 | (37.7190683424156, -122.394760377916) | 10 | 3 | 8 | 58 | 1 | ||||
150460 | 211286 | DPW Maintained 1 | Pinus strobus :: Eastern white pine 561 | 1701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990251.11897 | 2106500.34871 | 37.7634868808292 | -122.476910540201 | (37.7634868808292, -122.476910540201) | 1 | 8 | 3 | 56 | 12 | |||
150327 | 82083 | Permitted Site 7 | Ulmus parvifolia 'True Green' :: True Green Chinese Elm 560 | 1442 Sanchez St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.7460730342646 | -122.42921725762 | (37.7460730342646, -122.42921725762) | 2 | 7 | 5 | 63 | 22 | |
149813 | 123094 | DPW Maintained 1 | Brahea brandegeei :: San Jose hesper palm 559 | 619 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992507.54047 | 2111226.40302 | 37.7765939982766 | -122.469450409335 | (37.7765939982766, -122.469450409335) | 11 | 6 | 2 | 54 | 11 | |||
147591 | 56139 | DPW Maintained 1 | Myrica californica :: Pacific Wax Myrtle Tree 558 | 785 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12244 | 6012457.97701 | 2104293.46187 | 37.7586904573121 | -122.399948640521 | (37.7586904573121, -122.399948640521) | 10 | 3 | 8 | 28856 | 29 | ||
147441 | 191713 | DPW Maintained 1 | Erythrina caffra :: Coral tree 557 | 601 Wisconsin St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6012726.33226 | 2104665.52893 | 37.7597270294027 | -122.399046654695 | (37.7597270294027, -122.399046654695) | 10 | 3 | 8 | 28856 | 29 | |||
171425 | 233900 | DPW Maintained 1 | Erythrina caffra :: Coral tree 557 | 424 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Width 3ft | 6003655.41854 | 2109025.6301 | 37.7711891577883 | -122.430729588693 | (37.7711891577883, -122.430729588693) | 15 | 9 | 11 | 29492 | 10 | |||
144412 | 53140 | Permitted Site 7 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 556 | 1498@ KEITH Underwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
165890 | 227077 | DPW Maintained 1 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 556 | 644 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007449.25049 | 2105879.48876 | 37.7627648007686 | -122.417383547038 | (37.7627648007686, -122.417383547038) | 8 | 4 | 7 | 28859 | 19 | |||
141569 | 107467 | DPW Maintained 1 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' 555 | 1643 35th Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773410 | 5985268.14341 | 2104019.02784 | 37.7563835411873 | -122.493961929435 | (37.7563835411873, -122.493961929435) | 1 | 8 | 3 | 56 | 35 | |||
140466 | 122695 | Undocumented 4 | Acer saccharum :: Sugar Maple 554 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | ||||
138109 | 248402 | DPW Maintained 1 | Arbutus menziesii :: Pacific Madrone 553 | 701 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997566.8136 | 2108099.9902 | 37.7683007569323 | -122.45172341955 | (37.7683007569323, -122.45172341955) | 15 | 5 | 11 | 29492 | 9 | |||
137681 | 101255 | DPW Maintained 1 | x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree 552 | 3700X Cesar Chavez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6005840.6 | 2100555.6 | 37.7480559984104 | -122.422568977073 | (37.7480559984104, -122.422568977073) | 2 | 4 | 5 | 28859 | 19 | |||||
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 | ||||
126696 | 99791 | Undocumented 4 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 | 4120-4124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
170610 | 99793 | Undocumented 4 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 | 4120-4124 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002399 | 2101817 | 37.7513247429435 | -122.434560064215 | (37.7513247429435, -122.434560064215) | 2 | 4 | 5 | 28862 | 22 | ||||
120013 | 51021 | Permitted Site 7 | Prunus sargentii :: Sargent Cherry 548 | 4275 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50421 | 6001430.71351981 | 2101713.7407115 | 37.750986202789 | -122.437901107422 | (37.750986202789, -122.437901107422) | 2 | 4 | 5 | 28862 | 22 | ||
118226 | 53220 | Permitted Site 7 | Citrus x hystrix :: Kaffir lime 547 | 311 San Benito Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/04/2012 12:00:00 AM | 3x7 | Permit Number 769253 | 5992906.41199583 | 2094772.69381636 | 37.7314394147179 | -122.466874195473 | (37.7314394147179, -122.466874195473) | 9 | 8 | 4 | 59 | 40 | ||
117171 | 187858 | DPW Maintained 1 | Acer platanoides :: Norway Maple 546 | 550 Missouri St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6013512.81245 | 2104486.93396 | 37.7592804422575 | -122.396314071841 | (37.7592804422575, -122.396314071841) | 10 | 3 | 8 | 28856 | 29 | ||||
116720 | 113783 | Undocumented 4 | Chorisia speciosa :: Silk Floss Tree 545 | 1188 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6008033 | 2101004 | 37.7494106463882 | -122.41501945132 | (37.7494106463882, -122.41501945132) | 2 | 4 | 7 | 28859 | 19 | |||
118030 | 112152 | Undocumented 4 | Chorisia speciosa :: Silk Floss Tree 545 | 299x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6007772 | 2106483 | 37.7644400562771 | -122.416310015149 | (37.7644400562771, -122.416310015149) | 8 | 4 | 7 | 28859 | 19 | ||||
182353 | 107632 | Undocumented 4 | Chorisia speciosa :: Silk Floss Tree 545 | 814 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010397.84183 | 2104391.4418 | 37.758844416174 | -122.407080469655 | (37.758844416174, -122.407080469655) | 10 | 4 | 7 | 28859 | 19 | |||
116211 | 7938 | Permitted Site 7 | Crinodendron patagua :: Lily-of-the-Valley Tree 544 | 1410X Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6005829.8939946 | 2114877.7740744 | 37.7873806719016 | -122.423624130982 | (37.7873806719016, -122.423624130982) | 13 | 9 | 1 | 28858 | 41 | |||
114404 | 243956 | DPW Maintained 1 | Wodyetia bifurcata :: Foxtail palm 543 | 1374 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6010321.89598 | 2101296.94026 | 37.7503433529628 | -122.407125000243 | (37.7503433529628, -122.407125000243) | 2 | 4 | 7 | 28859 | 19 | |||
113536 | 192175 | DPW Maintained 1 | Fortunella margarita :: Kumquat 542 | 1508 Quint St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6013162.63986 | 2096311.86981 | 37.7368139691889 | -122.396951969064 | (37.7368139691889, -122.396951969064) | 10 | 3 | 8 | 58 | 1 | |||
123742 | 192174 | DPW Maintained 1 | Fortunella margarita :: Kumquat 542 | 170 Venus St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6012806.8459 | 2094069.78604 | 37.7306378606291 | -122.398024872851 | (37.7306378606291, -122.398024872851) | 10 | 3 | 8 | 58 | 1 | |||
132315 | 176478 | DPW Maintained 1 | Fortunella margarita :: Kumquat 542 | 44 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002686.43907 | 2087042.39829 | 37.7107733564667 | -122.432510875004 | (37.7107733564667, -122.432510875004) | 9 | 7 | 6 | 28861 | 5 | |||
112793 | 218986 | DPW Maintained 1 | Fraxinus velutina :: Modesto Ash 541 | 1628 18th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 5990607.41489 | 2104273.45371 | 37.757393083633 | -122.475515630561 | (37.757393083633, -122.475515630561) | 1 | 8 | 4 | 56 | 12 | |||
183583 | 218987 | DPW Maintained 1 | Fraxinus velutina :: Modesto Ash 541 | 1628 18th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 5990606.34235 | 2104296.88686 | 37.7574573626709 | -122.475521050754 | (37.7574573626709, -122.475521050754) | 1 | 8 | 4 | 56 | 12 | |||
193004 | 225890 | DPW Maintained 1 | Fraxinus velutina :: Modesto Ash 541 | 39 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005395.2934 | 2103444.34761 | 37.7559626984425 | -122.424314260517 | (37.7559626984425, -122.424314260517) | 2 | 4 | 5 | 28859 | 19 | |||
111190 | 180983 | DPW Maintained 1 | Yucca aloifolia :: Spanish bayonet 540 | 537 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6001996.80464 | 2090363.25365 | 37.719852558421 | -122.435131771037 | (37.719852558421, -122.435131771037) | 9 | 7 | 6 | 28861 | 5 | |||
110730 | 23365 | DPW Maintained 1 | Eucalyptus simmondsi :: Simmond's Peppermint 539 | 1356X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | |||
137657 | 23368 | DPW Maintained 1 | Eucalyptus simmondsi :: Simmond's Peppermint 539 | 1356X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | |||
109247 | 136057 | DPW Maintained 1 | Pseudopanax lessonii :: Five finger 538 | 331 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998559.64472 | 2115379.19074 | 37.7883443679496 | -122.448813707713 | (37.7883443679496, -122.448813707713) | 13 | 6 | 1 | 54 | 31 | |||
107508 | 194431 | DPW Maintained 1 | Pinus coulteri :: Coulter pine 537 | 889 Vermont St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011332.59627 | 2104195.66484 | 37.7583591218854 | -122.403833861042 | (37.7583591218854, -122.403833861042) | 10 | 3 | 8 | 28856 | 29 | ||||
116580 | 194430 | DPW Maintained 1 | Pinus coulteri :: Coulter pine 537 | 800 Vermont St | 44 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 5ft | 6011313.02989 | 2104102.06211 | 37.7581010164682 | -122.403894943896 | (37.7581010164682, -122.403894943896) | 10 | 3 | 8 | 28856 | 29 | |||
118947 | 194429 | DPW Maintained 1 | Pinus coulteri :: Coulter pine 537 | 800 Vermont St | 31 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011307.95664 | 2104238.22353 | 37.7584746020401 | -122.403922071066 | (37.7584746020401, -122.403922071066) | 10 | 3 | 8 | 28856 | 29 | ||||
168219 | 117624 | Undocumented 4 | Pinus coulteri :: Coulter pine 537 | 890x VERMONT ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
107155 | 49167 | DPW Maintained 1 | Acer tegmentosum :: Manchurian snakebark maple 536 | 559 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2003 12:00:00 AM | 4 | Permit Number 46289 | 6011256.10583 | 2105759.63482 | 37.7626491605637 | -122.40420847274 | (37.7626491605637, -122.40420847274) | 8 | 3 | 8 | 28856 | 29 | ||
101163 | 21434 | DPW Maintained 1 | Pinus pinaster :: Maritime Pine 535 | 2692X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
98041 | 58103 | DPW Maintained 1 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 534 | 756 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52383 | 6011525.71136 | 2104836.68468 | 37.7601300066003 | -122.403211071536 | (37.7601300066003, -122.403211071536) | 10 | 3 | 8 | 28856 | 29 | |
167522 | 104778 | Undocumented 4 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 534 | 736 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6002380.5 | 2103803.5 | 37.7567781475012 | -122.434766079383 | (37.7567781475012, -122.434766079383) | 2 | 4 | 5 | 28862 | 3 | |||
184451 | 57101 | Permitted Site 7 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 534 | 3721 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 4 | 3x3 | Permit Number 14371 | 6004927.69179762 | 2102493.53287665 | 37.7533255682373 | -122.425863704952 | (37.7533255682373, -122.425863704952) | 2 | 4 | 5 | 28862 | 22 | |
97942 | 122731 | Undocumented 4 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 533 | 310 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003508 | 2106439 | 37.7640785470532 | -122.431054869188 | (37.7640785470532, -122.431054869188) | 15 | 4 | 5 | 28862 | 3 | |||
146294 | 35968 | Permitted Site 7 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 533 | 123 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39126 | 6005630.57353586 | 2096425.6693507 | 37.7367042924726 | -122.423001748533 | (37.7367042924726, -122.423001748533) | 2 | 7 | 7 | 28859 | 2 | ||
97363 | 136633 | DPW Maintained 1 | Taxodium distichum :: Bald Cypress 532 | 3599 Washington St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5997616.03056 | 2115729.47725 | 37.7892521553188 | -122.45210372631 | (37.7892521553188, -122.45210372631) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||||
95427 | 199510 | DPW Maintained 1 | Quercus engelmannii :: Engelmann oak 530 | 1 01st St | 14 | : Yard | Tree | Private 2 | 5 | 6014434.26374 | 2105920.54159 | 37.7632680488164 | -122.393227539228 | (37.7632680488164, -122.393227539228) | 14 | 3 | 8 | 28856 | 29 | ||||
135268 | 18552 | DPW Maintained 1 | Quercus engelmannii :: Engelmann oak 530 | 1700X Quesada Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | 19 | 6014642.29362 | 2095077.14438 | 37.7335059182554 | -122.391749808332 | (37.7335059182554, -122.391749808332) | 10 | 3 | 8 | 58 | 1 | |||
158113 | 36980 | DPW Maintained 1 | Quercus engelmannii :: Engelmann oak 530 | 250 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39605 | 5993091.47222 | 2113806.34594 | 37.7837115501487 | -122.467618105783 | (37.7837115501487, -122.467618105783) | 11 | 6 | 2 | 54 | 11 | |
183735 | 199509 | DPW Maintained 1 | Quercus engelmannii :: Engelmann oak 530 | 800 19th St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6015055.67161 | 2105341.31512 | 37.7617121209521 | -122.39103778987 | (37.7617121209521, -122.39103778987) | 10 | 3 | 8 | 28856 | 29 | |||
95154 | 105979 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 415 De Haro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770296 | 6012057.7607 | 2106482.39696 | 37.7646784654506 | -122.401486617939 | (37.7646784654506, -122.401486617939) | 14 | 3 | 8 | 28856 | 29 | |||
95764 | 105978 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 415 De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770296 | 6012057.85881 | 2106472.16492 | 37.7646503760327 | -122.401485559435 | (37.7646503760327, -122.401485559435) | 14 | 3 | 8 | 28856 | 29 | |||
107888 | 239232 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 320 Church St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6004143.99896 | 2107037.13204 | 37.7657568919901 | -122.428897780335 | (37.7657568919901, -122.428897780335) | 8 | 4 | 5 | 28862 | 3 | |||
110900 | 105975 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 415 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770296 | 6012063.31118 | 2106384.67685 | 37.7644104575886 | -122.401460551957 | (37.7644104575886, -122.401460551957) | 14 | 3 | 8 | 28856 | 29 | |||
152492 | 105976 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 415 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770296 | 6012059.4558 | 2106418.56473 | 37.7645032910104 | -122.401476268538 | (37.7645032910104, -122.401476268538) | 14 | 3 | 8 | 28856 | 29 | |||
188489 | 213909 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 1447 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992088.33251 | 2105587.87582 | 37.7610878772322 | -122.470489805259 | (37.7610878772322, -122.470489805259) | 1 | 8 | 4 | 56 | 12 | |||
193434 | 105977 | DPW Maintained 1 | Pyrus calleryana 'Cleveland' :: Ornamental Pear Tree 'Cleveland' 529 | 415 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770296 | 6012059.23491 | 2106428.83235 | 37.764531471273 | -122.401477754202 | (37.764531471273, -122.401477754202) | 14 | 3 | 8 | 28856 | 29 | |||
94771 | 110864 | Undocumented 4 | Aesculus spp :: Horsechestnut 528 | 1798x 22ND ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6012787 | 2103832 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | 10 | 3 | 8 | 28856 | 29 | |||||
93958 | 205609 | DPW Maintained 1 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 527 | 1484 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5991184.61852 | 2105324.79706 | 37.760313237173 | -122.473596140059 | (37.760313237173, -122.473596140059) | 1 | 8 | 4 | 56 | 12 | |||
95163 | 188232 | DPW Maintained 1 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 527 | 1498 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014336.19933 | 2102024.08192 | 37.7525637629087 | -122.393294034206 | (37.7525637629087, -122.393294034206) | 10 | 3 | 8 | 28856 | 29 | |||
137888 | 256220 | Undocumented 4 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 527 | 159X Brewster St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
161315 | 221178 | DPW Maintained 1 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 527 | 1101 San Jose Ave | 68 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005051.84205 | 2096632.86271 | 37.7372405248233 | -122.425017413417 | (37.7372405248233, -122.425017413417) | 2 | 7 | 5 | 28859 | 2 | |||
92542 | 23447 | DPW Maintained 1 | Eucalyptus odorata :: Peppermint Box 526 | 2100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006027.0678818 | 2117578.0674993 | 37.7948061313097 | -122.423133960124 | (37.7948061313097, -122.423133960124) | 13 | 9 | 10 | 28858 | 32 | |||
176461 | 108981 | Permitted Site 7 | Eucalyptus odorata :: Peppermint Box 526 | 10 ARBOR ST | Front Yard : Yard | Tree | Private 2 | 03/02/2015 12:00:00 AM | 3 | Permit Number 774690 | 6002183.8 | 2097008.7 | 37.7381100606509 | -122.434960408352 | (37.7381100606509, -122.434960408352) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
91728 | 106979 | DPW Maintained 1 | Prunus domestica 'Green Gage' :: Green Gage Plum 524 | 801X Clipper St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 24 | 5999765.50041 | 2100345.59515 | 37.7471347718267 | -122.443561289165 | (37.7471347718267, -122.443561289165) | 2 | 4 | 5 | 63 | 22 | ||||
91119 | 239667 | DPW Maintained 1 | Schinus polygamus :: Chilean pepper tree 523 | 3700 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 10ft | 6005776.56879 | 2100568.79388 | 37.7480886132065 | -122.42279133238 | (37.7480886132065, -122.42279133238) | 2 | 4 | 5 | 28859 | 19 | |||
165872 | 5459 | DPW Maintained 1 | Schinus polygamus :: Chilean pepper tree 523 | 589 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 8X8 | 6004997.42906 | 2104935.20905 | 37.7600337791527 | -122.425796320748 | (37.7600337791527, -122.425796320748) | 2 | 4 | 5 | 28859 | 19 | |||
89056 | 53144 | Permitted Site 7 | Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 | 1498@ KEITH Underwood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
114148 | 108985 | DPW Maintained 1 | Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773348 | 5997959.2 | 2107274.4 | 37.7660563608956 | -122.450306679338 | (37.7660563608956, -122.450306679338) | 15 | 5 | 11 | 29492 | 9 |
118188 | 122503 | Permitted Site 7 | Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 | 849 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5997959.2 | 2107274.4 | 37.7660563608956 | -122.450306679338 | (37.7660563608956, -122.450306679338) | 15 | 5 | 11 | 29492 | 9 | |||
187182 | 56743 | Permitted Site 7 | Acer x freemanii 'Autumn Blaze' :: Autumn Blaze Freeman Maple 522 | 18 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52607 | 6003487.54955553 | 2105682.63980927 | 37.7620006052609 | -122.431071613448 | (37.7620006052609, -122.431071613448) | 15 | 4 | 5 | 28862 | 3 | |
87607 | 126006 | DPW Maintained 1 | Chamaecyparis obtusa :: Hinoki cypress 521 | 701 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999557.02765 | 2121502.29325 | 37.8052137627552 | -122.445803472668 | (37.8052137627552, -122.445803472668) | 13 | 9 | 1 | 57 | 17 | ||||
135085 | 126005 | DPW Maintained 1 | Chamaecyparis obtusa :: Hinoki cypress 521 | 210 Spruce St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5997133.44267 | 2115543.98512 | 37.7887151881134 | -122.453760013122 | (37.7887151881134, -122.453760013122) | 11 | 6 | 1 | 54 | 31 | |||
154607 | 126004 | DPW Maintained 1 | Chamaecyparis obtusa :: Hinoki cypress 521 | 210 Spruce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5997131.82438 | 2115550.37373 | 37.7887326367523 | -122.45376607366 | (37.7887326367523, -122.45376607366) | 11 | 6 | 1 | 54 | 31 | |||
189653 | 126007 | DPW Maintained 1 | Chamaecyparis obtusa :: Hinoki cypress 521 | 675 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999772.35767 | 2121527.71898 | 37.8052958672686 | -122.445060128138 | (37.8052958672686, -122.445060128138) | 13 | 9 | 1 | 57 | 17 | ||||
87247 | 119416 | DPW Maintained 1 | Callistemon 'Jeffers' :: Purple bottlebrush 520 | 475 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5985918.25244 | 2112723.39878 | 37.7803213158293 | -122.492354609513 | (37.7803213158293, -122.492354609513) | 11 | 6 | 2 | 55 | 26 | |||
115128 | 121859 | DPW Maintained 1 | Callistemon 'Jeffers' :: Purple bottlebrush 520 | 694 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990070.82749 | 2110676.13912 | 37.7749420038205 | -122.477839380532 | (37.7749420038205, -122.477839380532) | 11 | 6 | 2 | 55 | 26 | |||
123810 | 247133 | DPW Maintained 1 | Callistemon 'Jeffers' :: Purple bottlebrush 520 | 500 27th St | 3 | Front Yard : Yard | Tree | Private 2 | 10 | 6003198.2141 | 2100093.86711 | 37.7466387612816 | -122.431673280594 | (37.7466387612816, -122.431673280594) | 2 | 7 | 5 | 63 | 22 | ||||
148036 | 247008 | DPW Maintained 1 | Callistemon 'Jeffers' :: Purple bottlebrush 520 | 401 Valley St | 8 | Side Yard : Yard | Tree | Private 2 | 5 | Width 8ft | 6003270.60035 | 2099185.34055 | 37.74414826155 | -122.431358132986 | (37.74414826155, -122.431358132986) | 2 | 7 | 5 | 63 | 22 | |||
86786 | 63293 | Permitted Site 7 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 519 | 15 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23859 | 6008094.27360425 | 2100056.59433468 | 37.7468127256176 | -122.414740525712 | (37.7468127256176, -122.414740525712) | 2 | 7 | 7 | 28859 | 2 | ||
104896 | 108072 | Permitted Site 7 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 519 | 101 BUENA VISTA AVE EAST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001336 | 2108482 | 37.7695648051764 | -122.438713569331 | (37.7695648051764, -122.438713569331) | 15 | 5 | 5 | 29492 | 9 |
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) );