trees

257 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Curb side : Cutout" sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Curb side : Cutout · 257 ✖
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)
11338 85030 Significant Tree 6 Tree(s) :: 17 411 Panama St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2007 12:00:00 AM     Permit Number 49384                    
13434 260582 Significant Tree 6 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2101X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2019 12:00:00 AM 3 5x5 Permit Number 782628                    
140790 108047 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1301 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3 3x3   6017036.14467 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928) 10 3 8 58 1
40244 115123 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
46337 115125 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
110338 115124 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
7767 262288 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
18011 262289 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
2862 261320 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 872 Ingerson Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014869 2089377 37.7178670406836 -122.390567842363 (37.7178670406836, -122.390567842363) 10 3 8 58 1
70249 113112 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1633 OAKDALE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           6014731 2095647 37.7350755495662 -122.391482947841 (37.7350755495662, -122.391482947841) 10 3 8 58 1
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
154885 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
170444 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
3578 261993 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557x Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
11444 261994 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557x Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
45878 173675 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
50152 173671 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 299x Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
62378 173676 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
67391 173674 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
92116 173673 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
177074 173678 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 299x Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
181535 173677 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
182808 173672 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
16794 261146 Significant Tree 6 Ficus Spp. :: 101 375x Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2020 12:00:00 AM 3 3x3   6014494 2112212 37.780546313007 -122.393461254196 (37.780546313007, -122.393461254196) 6 2 9 28856 6
2213 261044 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
9433 261043 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
16799 261042 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
85061 255144 Significant Tree 6 Cupressus sempervirens :: Italian Cypress 204 101x Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013362 2113756 37.7847228211314 -122.3974857221 (37.7847228211314, -122.3974857221) 6 2 9 28856 6
168413 106611 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 1154 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6011908.79849 2103025.72201 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609) 10 3 8 28856 29
143592 105678 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 101X 03RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012079.1 2114345.8 37.7862707590298 -122.401965633825 (37.7862707590298, -122.401965633825) 12 2 9 28853 6
138347 116585 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2100 22nd St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2018 12:00:00 AM 30 3x3   6011855.05017 2103755.96694 37.7571809821214 -122.401996064067 (37.7571809821214, -122.401996064067) 10 3 8 28856 29
12165 260922 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 866 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774734 6011543 2104306 37.7586738299336 -122.403113948893 (37.7586738299336, -122.403113948893) 10 3 8 28856 29
18002 261423 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011254 2102764 37.7544236960072 -122.404004933004 (37.7544236960072, -122.404004933004) 10 4 8 28859 19
37577 100056 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
153818 100055 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
188934 100054 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
96193 88456 Significant Tree 6 Tree(s) :: 17 2801 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
148080 88457 Significant Tree 6 Tree(s) :: 17 2801 Oakdale Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
145228 173889 Significant Tree 6 Gleditsia triacanthos :: Honey Locust 182 190 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779949 6010824 2099939 37.7466428319545 -122.405293064953 (37.7466428319545, -122.405293064953) 2 7 7 28859 2
1871 261422 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2313 260963 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4089 260964 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4630 261689 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
6430 260967 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
8787 260968 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9216 261431 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10119 261688 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
13844 260966 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
14462 261432 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
16010 260965 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
93652 115295 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X 08TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010511 2109243 37.7721720235673 -122.407031076357 (37.7721720235673, -122.407031076357) 14 2 9 28853 34
66441 109838 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
61723 111634 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 3009 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6009514.91537658 2100993.40768569 37.7494647260255 -122.40989418187 (37.7494647260255, -122.40989418187) 2 4 7 28859 19
155030 113150 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 45 BRONTE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6009384 2097185 37.7390003361927 -122.410078062228 (37.7390003361927, -122.410078062228) 10 7 7 28859 2
110004 113695 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 907 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009441 2103786 37.7571284172194 -122.410346937481 (37.7571284172194, -122.410346937481) 2 4 7 28859 19
32139 112726 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
42938 112725 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
54607 108196 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 930 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
180439 108197 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 930 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
12676 251651 Significant Tree 6 Jacaranda mimosifolia :: Jacaranda 50 3237 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 782183 6009049 2099828 37.7462386522881 -122.411423013741 (37.7462386522881, -122.411423013741) 2 7 7 28859 2
94002 113187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3340 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008444 2099179 37.7444226899799 -122.413469145285 (37.7444226899799, -122.413469145285) 2 7 7 28859 2
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
13617 82366 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 51 Princeton St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059) 9 3 7 309 28
17239 32497 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 665 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 16   Permit Number 37002 6007442.30694 2095863.10154 37.7352616718948 -122.416697941676 (37.7352616718948, -122.416697941676) 2 7 7 28859 2
171699 121206 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 930 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.52821 37.8031223210123 -122.418746939923 (37.8031223210123, -122.418746939923) 5 1 1 28858 32
89489 112577 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3326 23RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24   Permit Number 775776 6006851 2102663.4 37.7539004875763 -122.419224541208 (37.7539004875763, -122.419224541208) 2 4 7 28859 19
3581 255621 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
9069 255620 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
107615 121415 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
131057 121416 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
61387 114840 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
55458 255165 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 371 Prospect Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 781717 6006352.58239 2097791.19314 37.7404944317648 -122.420602351048 (37.7404944317648, -122.420602351048) 2 7 7 28859 2
145683 112626 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3430X 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     12     6006285 2102686.4 37.7539317482446 -122.421183538041 (37.7539317482446, -122.421183538041) 2 4 5 28859 19
42649 115940 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 1 Sidewalk: Curb side : Cutout Tree Police Dept 10     20 3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
99418 115942 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 3 Sidewalk: Curb side : Cutout Tree Police Dept 10       3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
170533 115941 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 2 Sidewalk: Curb side : Cutout Tree Police Dept 10       3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
144689 253283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 673 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005929 2099335 37.7447094953859 -122.422176588207 (37.7447094953859, -122.422176588207) 2 7 5 28859 2
133531 187642 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2526 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006264 2119500 37.8000966404513 -122.42245076966 (37.8000966404513, -122.42245076966) 13 9 1 28858 32
73655 253718 Significant Tree 6 Acer buergeranum :: Trident Maple 110 227 Madison St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3 Permit Number 780760 6005690 2092595 37.7261894743752 -122.422524168298 (37.7261894743752, -122.422524168298) 9 7 7 309 5
96773 92813 Significant Tree 6 Tree(s) :: 17 365 Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 53020 6006011 2111744 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798) 7 9 11 28852 10
33858 255597 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
73188 255598 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
79307 255595 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
91730 255599 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
142991 255600 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
168619 255596 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
93101 251659 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
143771 251658 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
151937 251657 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
157788 251660 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
178107 251661 Significant Tree 6 Olea europaea :: Olive Tree 9 3200X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
153500 33327 Significant Tree 6 Arbutus unedo :: Strawberry Tree 106 1629 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2010 12:00:00 AM   3x3 Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued 6005242.65792202 2118493.60609418 37.7972756709044 -122.425913331435 (37.7972756709044, -122.425913331435) 13 9 1 57 17
28942 110737 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
67675 110738 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18

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