trees

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

✎ 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)
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
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
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
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 12
57424 101476 Significant Tree 6 :: 45 541 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089 2095440.1 37.7336838892166 -122.442090592963 (37.7336838892166, -122.442090592963) 9 7 4 63 40
108660 105368 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 180 CLIFFORD TER   Sidewalk: Curb side : Cutout Tree Private 2           5999283.1 2106587.2 37.7642451591147 -122.445678167683 (37.7642451591147, -122.445678167683) 15 5 5 29492 9
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
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
27860 107983 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2405x Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6001231.00707 2116743.47753 37.7922427464694 -122.439669095376 (37.7922427464694, -122.439669095376) 13 6 1 29490 27
104499 107984 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2401x SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
161834 107985 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2401x SCOTT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
82918 107986 Significant Tree 6 Juniperus chinensis :: Juniper 113 2401x SCOTT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001257 2116757 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378) 13 6 1 29490 27
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
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
113215 108560 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 3790 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003155.9 2103640.4 37.7563743055091 -122.432072816055 (37.7563743055091, -122.432072816055) 2 4 5 28862 3
170923 109294 Significant Tree 6 Ficus nitida :: Laurel Fig 53 370 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
3842 109772 Significant Tree 6 Yucca elephantipes :: Giant Yucca 268 2200x SAN JOSE AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
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
101112 110321 Significant Tree 6 Ilex opaca :: American Holly 473 1x SAN PABLO AVE   Sidewalk: Curb side : Cutout Tree Private 2   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773 2097898 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756) 9 8 4 59 40
49235 110583 Significant Tree 6 Phoenix canariensis :: Canary Island Date Palm 160 46 COOK ST 5 Sidewalk: Curb side : Cutout Tree Private 2     36     5997534 2113434 37.782944683725 -122.452221842699 (37.782944683725, -122.452221842699) 15 6 1 54 31
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
124026 110739 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 6 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
133714 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
34293 111094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150x FONT BLVD   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976 2089133 37.7158426125161 -122.473136789074 (37.7158426125161, -122.473136789074) 1 8 4 64 14
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
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
179316 112056 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 762 FUNSTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
137332 112057 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 762 FUNSTON AVE 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
89539 112250 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 243 WINSTON DR 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990059 2093141 37.7267944442094 -122.476598971146 (37.7267944442094, -122.476598971146) 1 8 4 64 14
149763 112290 Significant Tree 6 Acer rubrum :: Red Maple 75 34 YERBA BUENA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 776546 5993584 2097045 37.7377176881769 -122.464696609393 (37.7377176881769, -122.464696609393) 1 8 4 59 40
90582 112375 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 1 Sidewalk: Curb side : Cutout Tree MTA 3     42     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
124516 112376 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 2 Sidewalk: Curb side : Cutout Tree MTA 3     24     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
43088 112378 Significant Tree 6 :: 45 1850 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
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
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
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
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
132771 112955 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 121X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2           5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
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
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
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
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
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
92766 114034 Significant Tree 6 Ulmus pumila :: Siberian Elm 99 198x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x3   5990818 2089012 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302) 1 8 4 64 14
76029 114099 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 201x VIDAL DR 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5987665 2090646 37.7198046658936 -122.484691919383 (37.7198046658936, -122.484691919383) 1 8 4 64 14
149016 114404 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
175794 114405 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
44683 114406 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
81808 114407 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 500X ARBALLO DR 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
130345 114408 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
119656 114409 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X ARBALLO DR 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
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
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
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
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
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
36038 115661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 341 HAZELWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5996066 2095432 37.7334315621613 -122.455998615118 (37.7334315621613, -122.455998615118) 9 7 4 59 40
73267 115729 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
71364 115730 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
96718 115731 Significant Tree 6 Acer rubrum :: Red Maple 75 15 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776556 5993468.8 2097225 37.7382052810266 -122.465107977902 (37.7382052810266, -122.465107977902) 1 8 4 59 40
139444 115733 Significant Tree 6 Acer rubrum :: Red Maple 75 50 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776548 5993693.2 2096969 37.7375153061033 -122.464313539267 (37.7375153061033, -122.464313539267) 1 8 4 59 40
188463 115734 Significant Tree 6 Acer rubrum :: Red Maple 75 55 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 776555 5993732.7 2097034 37.7376960566374 -122.464181687663 (37.7376960566374, -122.464181687663) 1 8 4 59 40
193868 115735 Significant Tree 6 Acer rubrum :: Red Maple 75 57 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776554 5993777.6 2097002.8 37.7376129769989 -122.464024183823 (37.7376129769989, -122.464024183823) 1 8 4 59 40
54288 115736 Significant Tree 6 Acer rubrum :: Red Maple 75 66 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776551 5993801.4 2096894.7 37.7373175329251 -122.463934052027 (37.7373175329251, -122.463934052027) 1 8 4 59 40
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
182457 115738 Significant Tree 6 Acer rubrum :: Red Maple 75 95x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
188246 115749 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
179237 115750 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
177311 115751 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
116051 115752 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
179132 115753 Significant Tree 6 Acer rubrum :: Red Maple 75 135x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776552 5994185.89401 2096656.23912 37.7366849291808 -122.46258739592 (37.7366849291808, -122.46258739592) 9 8 4 59 40
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
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
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
120116 116009 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 777954 5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
47809 116010 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
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
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
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
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
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
185127 116345 Significant Tree 6 Tree(s) :: 17 85x SANTA CLARA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777165 5993361 2096925 37.7373753392635 -122.465458906558 (37.7373753392635, -122.465458906558) 1 8 4 59 40
117265 116346 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 121 SAN BENITO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777164 5992901 2095856 37.7344135917102 -122.466971633047 (37.7344135917102, -122.466971633047) 9 8 4 59 40
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
180538 116957 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 10x Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
155480 116958 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 777762 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
178096 117248 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 299x GRAYSTONE TER 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999641 2104067 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093) 2 5 5 28862 3
158598 117249 Significant Tree 6 Pinus radiata :: Monterey Pine 15 299x GRAYSTONE TER 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999641 2104067 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093) 2 5 5 28862 3
72904 117269 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 399X SANTA CLARA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x10   5993324 2095440 37.7332957649176 -122.465478985137 (37.7332957649176, -122.465478985137) 9 8 4 59 40
92153 117518 Significant Tree 6 Ulmus americana :: American Elm 74 30 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2016 12:00:00 AM 3   Permit Number 777803 5993995.8 2097679.6 37.7394838741894 -122.463318866351 (37.7394838741894, -122.463318866351) 1 8 4 59 40
83943 118327 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 109 ALPINE TER   Sidewalk: Curb side : Cutout Tree Private 2     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181 (37.7688096651516, -122.43737752181) 15 5 5 29492 3
87883 120156 Significant Tree 6 Ficus nitida :: Laurel Fig 53 758 10th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2     10     5992930 2110298 37.7740692588728 -122.467921468059 (37.7740692588728, -122.467921468059) 11 6 2 54 11
1533 120590 Significant Tree 6 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 52 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003308 2106220 37.7634658909933 -122.43173097309 (37.7634658909933, -122.43173097309) 15 4 5 28862 3
95104 120593 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree MTA 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
116578 120595 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25

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