trees
112 rows where qLegalStatus_id = 6 and qSiteInfo = "Front Yard : Cutout" sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3182 | 261252 | Significant Tree 6 | Banksia integrifolia :: Coast Banksia 21 | 100 Collins St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | |||||||||||||
15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | ||
3099 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 953 Indiana St | 1 | Front Yard : Cutout | Tree | Private 2 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | |||||
29803 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X Oakdale Ave | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.83637 | 37.735069048787 | -122.391004288315 | (37.735069048787, -122.391004288315) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
105286 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 135 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout | Tree | Private 2 | 15 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
85934 | 88453 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2801 Oakdale Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089 | -122.404551775442 | (37.742488010089, -122.404551775442) | 10 | 3 | 8 | 58 | 1 | |||
118020 | 88454 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2801 Oakdale Ave | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089 | -122.404551775442 | (37.742488010089, -122.404551775442) | 10 | 3 | 8 | 58 | 1 | |||
138601 | 88455 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2801 Oakdale Ave | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089 | -122.404551775442 | (37.742488010089, -122.404551775442) | 10 | 3 | 8 | 58 | 1 | |||
129885 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 600x MANSELL ST | 1 | Front Yard : Cutout | Tree | DPW 1 | 48 | 3x3 | 6010142 | 2090267 | 37.7200474236955 | -122.406969764511 | (37.7200474236955, -122.406969764511) | 10 | 3 | 8 | 309 | 28 | |||
156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 | ||||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
100356 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
110541 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | ||||
54248 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 811 TREAT AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 3x3 | 6008597 | 2103712 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | 2 | 4 | 7 | 28859 | 19 | |||
69512 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 500 Raymond Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.87951 | 2088473.93147 | 37.7150170728648 | -122.413438766187 | (37.7150170728648, -122.413438766187) | 9 | 7 | 8 | 309 | 18 | ||
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 | |||||
152275 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 748 Treat Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 8 | 3x3 | 6008496.2 | 2104169 | 37.7581270399512 | -122.413641518528 | (37.7581270399512, -122.413641518528) | 2 | 4 | 7 | 28859 | 19 | |||
14597 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 4 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | ||||
69806 | 106872 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 3 | Front Yard : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | |||
76208 | 106874 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 5 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | ||||
135261 | 106871 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 2 | Front Yard : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | |||
182623 | 106870 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 2 | Permit Number 769156 | 6008504.13663 | 2111439.18954 | 37.7780897331906 | -122.414128411309 | (37.7780897331906, -122.414128411309) | 8 | 2 | 9 | 28853 | 34 | ||
45867 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Florence St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | 5 | 1 | 10 | 308 | 21 | ||||
27985 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 6007603.98274 | 2103104.14442 | 37.7551530486792 | -122.416651764192 | (37.7551530486792, -122.416651764192) | 2 | 4 | 7 | 28859 | 19 | ||||
57122 | 104444 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 507 Capp St | 1 | Front Yard : Cutout | Tree | Private 2 | 2x6 | Permit Number 770679 | 6007300 | 2104257.5 | 37.7583027968034 | -122.417784776473 | (37.7583027968034, -122.417784776473) | 2 | 4 | 7 | 28859 | 19 | |||
189920 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 507 Capp St | 2 | Front Yard : Cutout | Tree | Private 2 | 2x6 | Permit Number 770679 | 6007300 | 2104257.5 | 37.7583027968034 | -122.417784776473 | (37.7583027968034, -122.417784776473) | 2 | 4 | 7 | 28859 | 19 | |||
154007 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 101 LUNDYS LN | 1 | Front Yard : Cutout | Tree | Private 2 | 18 | 6006875 | 2098969 | 37.7437578546964 | -122.418879543436 | (37.7437578546964, -122.418879543436) | 2 | 7 | 7 | 28859 | 2 | ||||
5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
80380 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060 | 2120781 | 37.8036588138585 | -122.41978724304 | (37.8036588138585, -122.41978724304) | 5 | 1 | 1 | 28858 | 32 | ||
13092 | 261764 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 130 Bartlett St | 2 | Front Yard : Cutout | Tree | Private 2 | 4x4 | 6006663 | 2102839 | 37.7543720553146 | -122.419887150249 | (37.7543720553146, -122.419887150249) | 2 | 4 | 7 | 28859 | 19 | ||||
29057 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 6006172 | 2100967 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | 2 | 4 | 5 | 28859 | 19 | |||
12050 | 261306 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1555 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6005549 | 2118864 | 37.7983099861265 | -122.424879674285 | (37.7983099861265, -122.424879674285) | 13 | 9 | 1 | 57 | 17 | ||||
22312 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 2 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
99950 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 3 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
105893 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
113506 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 461X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005199.36333 | 2111122.83043 | 37.7770349120596 | -122.425538300101 | (37.7770349120596, -122.425538300101) | 7 | 9 | 11 | 28852 | 10 | |||||
65723 | 108022 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 76 | 455X Ivy St | 2 | Front Yard : Cutout | Tree | Private 2 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | 7 | 9 | 11 | 28852 | 10 | |||||
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 | |||||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
62475 | 107113 | Significant Tree 6 | Brahea edulis :: Guadalupe Palm 218 | 2100 MARKET ST | Front Yard : Cutout | Tree | Private 2 | 6004034 | 2107672.1 | 37.7674941340109 | -122.429323526179 | (37.7674941340109, -122.429323526179) | 7 | 9 | 5 | 28862 | 3 | ||||||
73226 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.7901043022718 | -122.429743441495 | (37.7901043022718, -122.429743441495) | 13 | 9 | 1 | 29490 | 27 | |
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 | |
8573 | 264725 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 136 Addison St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002996 | 2096937 | 37.7379592717499 | -122.432147110586 | (37.7379592717499, -122.432147110586) | 2 | 7 | 5 | 63 | 7 | ||||
51498 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
77876 | 88571 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 62 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
121105 | 88572 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 66 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
130549 | 88570 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 61 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
141035 | 88568 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 59 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
145466 | 88567 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 39 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
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 | |||
19453 | 261628 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3930 21st St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002255 | 2103579 | 37.7561545985327 | -122.435184046951 | (37.7561545985327, -122.435184046951) | 2 | 4 | 5 | 28862 | 3 | ||||
80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
100759 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 3 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
92659 | 85428 | Significant Tree 6 | Tree(s) :: 17 | 43 Ora Way | 1 | Front Yard : Cutout | Tree | Private 2 | 08/23/2007 12:00:00 AM | Permit Number 49665 | 6001553.3 | 2098294.6 | 37.7416050219872 | -122.437232403771 | (37.7416050219872, -122.437232403771) | 2 | 7 | 5 | 63 | 7 | |||
32335 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
24634 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 707 Douglass St | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775627 | 6001281 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | 2 | 4 | 5 | 28862 | 22 | ||||
59089 | 116955 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 818 Douglass St | 1 | Front Yard : Cutout | Tree | Private 2 | 6 | 3x3 | 6001245 | 2101454 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | 2 | 4 | 5 | 28862 | 22 | |||
18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 | ||||
8456 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 1 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 | |||||
188669 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 2 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 | |||||
429 | 259715 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 210 Gold Mine Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000723 | 2098465 | 37.7420256658379 | -122.440115509428 | (37.7420256658379, -122.440115509428) | 2 | 7 | 5 | 63 | 7 | ||||
69856 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
137101 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2777 Pine St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 779015 | 6000658 | 2114782 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | 13 | 6 | 1 | 29490 | 27 | |||
89841 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 4450 24th St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 0ft | Permit Number 780574 | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | 2 | 4 | 5 | 28862 | 22 | |||
166780 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338 | 2118225 | 37.7962597494046 | -122.442865342513 | (37.7962597494046, -122.442865342513) | 13 | 9 | 1 | 57 | 17 | |
160978 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 MASONIC AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | ||||
72773 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2224 Baker St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | 13 | 6 | 1 | 29490 | 27 | |||
29379 | 254551 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 1433 Cayuga Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5999129 | 2089595 | 37.7175798453783 | -122.444989533853 | (37.7175798453783, -122.444989533853) | 9 | 7 | 6 | 28861 | 25 | ||||
186507 | 254476 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1511 Lyon St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999620 | 2114151 | 37.7850326563334 | -122.445056733542 | (37.7850326563334, -122.445056733542) | 15 | 6 | 1 | 29490 | 31 | |||||
131538 | 173716 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1652 Fell St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999516 | 2109850 | 37.7732172801378 | -122.445107222354 | (37.7732172801378, -122.445107222354) | 15 | 5 | 11 | 29492 | 16 | |||||
111048 | 113744 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 909 ASHBURY ST | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5999156 | 2107025 | 37.7654399906909 | -122.44614926226 | (37.7654399906909, -122.44614926226) | 15 | 5 | 11 | 29492 | 9 | ||||
99727 | 258388 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2770 Lombard St | 2 | Front Yard : Cutout | Tree | Private 2 | 5999223 | 2119112 | 37.7986315842223 | -122.446787313103 | (37.7986315842223, -122.446787313103) | 13 | 9 | 1 | 57 | 17 | |||||
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 | |||||
58472 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | 13 | 6 | 1 | 54 | 31 | |||
164452 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 731 CLAYTON ST | 1 | Front Yard : Cutout | Tree | Private 2 | 5998515 | 2108057 | 37.7682369747157 | -122.448440651351 | (37.7682369747157, -122.448440651351) | 15 | 5 | 11 | 29492 | 9 | |||||
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 | |||
48200 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout | Tree | Private 2 | 5998663.3699 | 2115944.31994 | 37.789901994506 | -122.448495552231 | (37.789901994506, -122.448495552231) | 13 | 6 | 1 | 54 | 31 | |||||
15969 | 261831 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 1507 Cole St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5998279 | 2105297 | 37.7606452154312 | -122.449058098094 | (37.7606452154312, -122.449058098094) | 15 | 5 | 11 | 29492 | 12 | ||||
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 | ||||
157634 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 66 Clarendon Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.7588714791444 | -122.450538092312 | (37.7588714791444, -122.450538092312) | 15 | 5 | 11 | 28862 | 12 | |||
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 | |||
44979 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3524 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||
104764 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 3524 Jackson St | 2 | Front Yard : Cutout | Tree | Private 2 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||||
64719 | 253770 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 234 Carl St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 770677 | 5997066 | 2107091 | 37.7655016335596 | -122.453382820195 | (37.7655016335596, -122.453382820195) | 15 | 5 | 11 | 29492 | 12 | |||
11600 | 260651 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
16260 | 260650 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
128997 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.7457002690083 | -122.457505029341 | (37.7457002690083, -122.457505029341) | 1 | 5 | 4 | 59 | 40 | ||
14356 | 264786 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 451 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995368 | 2094795 | 37.7316424274687 | -122.458365690275 | (37.7316424274687, -122.458365690275) | 9 | 7 | 4 | 59 | 40 | ||||
34696 | 253950 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 431 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | ||||
130286 | 253951 | Significant Tree 6 | Tree(s) :: 17 | 431 Yerba Buena Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780852 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | |
20150 | 256573 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 145 Castenada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5994569 | 2100949 | 37.74849383418 | -122.461573977381 | (37.74849383418, -122.461573977381) | 1 | 8 | 4 | 29491 | 40 | ||||
43207 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
75962 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1836 08TH AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | |||
97746 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
127456 | 107197 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 339 Kirkham St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/07/2014 12:00:00 AM | 3x3 | Permit Number 773549 | 5993785.2645 | 2105241.58741 | 37.7602350326789 | -122.464595750688 | (37.7602350326789, -122.464595750688) | 1 | 8 | 4 | 56 | 12 | ||
165013 | 85367 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1990 09th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49643 | 5993523.3 | 2101996.8 | 37.7513105791605 | -122.465266058842 | (37.7513105791605, -122.465266058842) | 1 | 8 | 4 | 29491 | 12 | |||
125570 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 180 San Aleso Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319 | 2094440 | 37.7305497238902 | -122.465423653439 | (37.7305497238902, -122.465423653439) | 9 | 8 | 4 | 59 | 40 |
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) );