trees
39,840 rows where qLegalStatus_id = 7 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95012 | 100000 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
50134 | 100004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
60809 | 100009 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
175170 | 100019 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
72619 | 100020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
129974 | 100021 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
124561 | 100022 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
33339 | 100023 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
160909 | 100025 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
29882 | 100026 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
44949 | 100027 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
143924 | 100028 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
57271 | 100029 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
77303 | 100044 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1250 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2012 12:00:00 AM | 3x3 | Permit Number 768984 | 6012201 | 2102568.4 | 37.7539394855375 | -122.400716201774 | (37.7539394855375, -122.400716201774) | 10 | 3 | 8 | 28856 | 29 | ||
43487 | 100048 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1445 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2012 12:00:00 AM | 3x3 | Permit Number 769137 | 5991161 | 2110614 | 37.7748345969519 | -122.47406374416 | (37.7748345969519, -122.47406374416) | 11 | 6 | 2 | 54 | 26 | ||
20994 | 100049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 768990 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | ||
173940 | 100065 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 322 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2012 12:00:00 AM | 3x3 | Permit Number 58746 | 6004276.4 | 2099889 | 37.7461372993162 | -122.427930429145 | (37.7461372993162, -122.427930429145) | 2 | 7 | 5 | 63 | 22 | ||
116936 | 100068 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 303 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990392 | 2090762 | 37.720281613079 | -122.47527420247 | (37.720281613079, -122.47527420247) | 1 | 8 | 4 | 64 | 40 | |||
188916 | 100069 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 619 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||
187521 | 100073 | Permitted Site 7 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 930@ Lorraine Ct Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2012 12:00:00 AM | 3x3 | Permit Number 769060 | 5996162 | 2112255 | 37.7796287713947 | -122.456883064061 | (37.7796287713947, -122.456883064061) | 11 | 6 | 2 | 54 | 16 | ||
85361 | 100087 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003216.8 | 2118972.8 | 37.7984767167189 | -122.432957560795 | (37.7984767167189, -122.432957560795) | 13 | 9 | 1 | 57 | 17 | |||||
116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
64071 | 100096 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
57950 | 100097 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
81454 | 100098 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
23589 | 100099 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
171998 | 100100 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
122906 | 100101 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
138742 | 100157 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||||
34119 | 100158 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | Permit Number 769008 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||
159845 | 100167 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
171432 | 100168 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 710 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
101769 | 100178 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
84934 | 100179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
159785 | 10018 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1993 12:00:00 AM | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | ||
38085 | 100183 | Permitted Site 7 | Tree(s) :: 17 | 956 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003075.2 | 2102641.9 | 37.7536280862965 | -122.432280596021 | (37.7536280862965, -122.432280596021) | 2 | 4 | 5 | 28862 | 22 | ||||
111037 | 100187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
168610 | 100188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
28194 | 10019 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | |||
106283 | 100202 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2389 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | Permit Number 768863 | 6003320.6 | 2116507.6 | 37.79171379901 | -122.432422214141 | (37.79171379901, -122.432422214141) | 13 | 9 | 1 | 29490 | 27 | |||
24948 | 100206 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006736.3 | 2098711.7 | 37.7430435558186 | -122.4193408869 | (37.7430435558186, -122.4193408869) | 2 | 7 | 7 | 28859 | 2 | ||||
64294 | 100207 | Permitted Site 7 | Tree(s) :: 17 | 149X Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006751.8 | 2098740.3 | 37.7431229579688 | -122.419289320387 | (37.7431229579688, -122.419289320387) | 2 | 7 | 7 | 28859 | 2 | ||||
65243 | 100210 | Permitted Site 7 | Tree(s) :: 17 | 701 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | Permit Number 769013 | 6011921.4 | 2105078.9 | 37.7608171664666 | -122.401859591355 | (37.7608171664666, -122.401859591355) | 10 | 3 | 8 | 28856 | 29 | |||
160532 | 100223 | Permitted Site 7 | Tree(s) :: 17 | 3841 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004154.3 | 2102433.2 | 37.75311617172 | -122.428533954088 | (37.75311617172, -122.428533954088) | 2 | 4 | 5 | 28862 | 22 | |
135684 | 100224 | Permitted Site 7 | Tree(s) :: 17 | 101X Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | 2 | 4 | 5 | 28862 | 22 | |
67433 | 100225 | Permitted Site 7 | Tree(s) :: 17 | 101X Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | 2 | 4 | 5 | 28862 | 22 | |
57928 | 100247 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 15 Castenada Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | 1 | 8 | 4 | 29491 | 40 | |||
23885 | 100248 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | 1 | 8 | 4 | 29491 | 40 | |||
40429 | 100253 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 1456 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | 4x4 | Permit Number 769196 | 5993711.5 | 2105567.7 | 37.7611262002583 | -122.464874548889 | (37.7611262002583, -122.464874548889) | 1 | 8 | 11 | 56 | 12 | ||
160805 | 100255 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1456 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 769196 | 5993711.5 | 2105567.7 | 37.7611262002583 | -122.464874548889 | (37.7611262002583, -122.464874548889) | 1 | 8 | 11 | 56 | 12 | ||
117911 | 100285 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 10129 | 5994323.3 | 2105790 | 37.7617718339078 | -122.462774738749 | (37.7617718339078, -122.462774738749) | 1 | 5 | 11 | 56 | 12 | ||||
93945 | 100307 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202X Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52417 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.433805877135 | (37.7592732879998, -122.433805877135) | 2 | 4 | 5 | 28862 | 3 | |||
108882 | 100308 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 202X Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52417 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.433805877135 | (37.7592732879998, -122.433805877135) | 2 | 4 | 5 | 28862 | 3 | |||
99115 | 100310 | Permitted Site 7 | Myoporum laetum :: Myoporum 62 | 3899 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996194.7 | 2115482.8 | 37.7884933268854 | -122.457003479054 | (37.7884933268854, -122.457003479054) | 11 | 6 | 1 | 54 | 31 | |||||
165867 | 100311 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 200X Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013423 | 2117972 | 37.796302366794 | -122.397570474592 | (37.796302366794, -122.397570474592) | 3 | 1 | 10 | 28860 | 6 | |||||
143933 | 100312 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 200X Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013423 | 2117972 | 37.796302366794 | -122.397570474592 | (37.796302366794, -122.397570474592) | 3 | 1 | 10 | 28860 | 6 | |||||
33559 | 100316 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 1683 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769149 | 6015429.5 | 2097921.2 | 37.7413587833137 | -122.38922671217 | (37.7413587833137, -122.38922671217) | 10 | 3 | 8 | 58 | 1 | |
150376 | 100333 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x7 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
19766 | 100334 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x9 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
51584 | 100335 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x9 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
123523 | 100336 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x9 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
137389 | 100337 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 769202 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | |||
77007 | 100345 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 | ||
32053 | 100346 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 | ||
81725 | 100347 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 | ||
81311 | 100351 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 534 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x5 | Permit Number 33129 | 5992660 | 2104598 | 37.7584029758516 | -122.468440651471 | (37.7584029758516, -122.468440651471) | 1 | 8 | 4 | 56 | 12 | |||
75430 | 100358 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | 11 | 6 | 2 | 54 | 26 | ||||
153976 | 100359 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | 11 | 6 | 2 | 54 | 26 | |||
6355 | 100391 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6002817 | 2092256 | 37.7250961583897 | -122.432431760897 | (37.7250961583897, -122.432431760897) | 9 | 7 | 6 | 28861 | 5 | ||||
178622 | 100392 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
110591 | 100393 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
91712 | 100394 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
134008 | 100395 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
145475 | 100397 | Permitted Site 7 | Myoporum laetum :: Myoporum 62 | 204 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2014 12:00:00 AM | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.465279221291 | (37.7585961040831, -122.465279221291) | 1 | 8 | 4 | 56 | 12 | |
65367 | 100398 | Permitted Site 7 | Myoporum laetum :: Myoporum 62 | 204 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.465279221291 | (37.7585961040831, -122.465279221291) | 1 | 8 | 4 | 56 | 12 | ||
189983 | 1004 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1810X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6001283.16417 | 2091702.46996 | 37.7234891944335 | -122.437694433548 | (37.7234891944335, -122.437694433548) | 9 | 7 | 6 | 28861 | 25 | ||
32661 | 100407 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
138619 | 100408 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
2426 | 100409 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
59153 | 100410 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | |||
191489 | 100411 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | |||
149657 | 100412 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | |||
137622 | 100413 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | ||||
130051 | 100414 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | ||||
115665 | 100415 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | ||||
110709 | 100420 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1701X 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | 1 | 8 | 4 | 56 | 12 | ||
93305 | 100421 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1701X 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | 1 | 8 | 4 | 56 | 12 | ||
67641 | 100422 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1701X 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2012 12:00:00 AM | 3x4 | Permit Number 769064 | 5993374 | 2103847.1 | 37.7563824151434 | -122.465916782185 | (37.7563824151434, -122.465916782185) | 1 | 8 | 4 | 56 | 12 | ||
40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
62259 | 100426 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 200X Stonecrest Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
89621 | 100427 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 200X Stonecrest Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
33745 | 100428 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 200X Stonecrest Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
77101 | 100429 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 200X Stonecrest Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
169022 | 100430 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 200X Stonecrest Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
33964 | 100435 | Permitted Site 7 | Tree(s) :: 17 | 2601 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 769212 | 5999189 | 2117684 | 37.7947087350095 | -122.446802156989 | (37.7947087350095, -122.446802156989) | 11 | 1 | 57 | 30 | ||||
182738 | 10045 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 375 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2007 12:00:00 AM | 6 | 2X2 | 6005552.9439989 | 2106809.2959802 | 37.7652109557568 | -122.424008332395 | (37.7652109557568, -122.424008332395) | 8 | 4 | 5 | 28853 | 19 | ||
110176 | 100457 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4400 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 32872 | 6001426 | 2104682 | 37.7591360587515 | -122.438130013791 | (37.7591360587515, -122.438130013791) | 2 | 4 | 5 | 28862 | 3 | |||
151002 | 100458 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4400 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 32872 | 6001426 | 2104682 | 37.7591360587515 | -122.438130013791 | (37.7591360587515, -122.438130013791) | 2 | 4 | 5 | 28862 | 3 |
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) );