39,840 rows where qLegalStatus_id = 7 sorted by TreeID

View and edit SQL

rowid TreeID ▼ qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
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

Next page

Advanced export

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

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);