trees

484 rows where qSpecies_id = 56

✎ View and edit SQL

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)
77234 207754 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1364 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5993663.75343 2106217.17575 37.7629067380829 -122.4650868556 (37.7629067380829, -122.4650868556) 1 8 11 56 12
77703 224237 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 29 Front Yard : Yard Tree Private 2     19     6004814.56562 2096681.78705 37.7373614539559 -122.425841268876 (37.7373614539559, -122.425841268876) 2 7 5 63 7
77709 209026 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 36 Martha Ave 3 Front Yard : Yard Tree Private 2     24     6000767.091 2095571.91906 37.7340844539158 -122.439755686569 (37.7340844539158, -122.439755686569) 9 7 5 63 40
77856 254300 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
77868 207784 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 270 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 10ft   5993081.21532 2096255.53806 37.7355210237716 -122.466377603044 (37.7355210237716, -122.466377603044) 1 8 4 59 40
78408 254301 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 4 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
78464 224232 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 22 Front Yard : Yard Tree Private 2     6     6004847.66693 2096700.74316 37.7374153737207 -122.425728171024 (37.7374153737207, -122.425728171024) 2 7 5 63 7
78746 224242 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 40 Front Yard : Yard Tree Private 2     5     6004773.22407 2096631.25513 37.7372203683314 -122.425980609816 (37.7372203683314, -122.425980609816) 2 7 5 63 7
79003 208937 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 64 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     36 Width 10ft   5991925.34536 2095973.96809 37.7346811406131 -122.470353347532 (37.7346811406131, -122.470353347532) 9 8 4 59 40
79539 95436 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2675 25th Ave 3 Unaccepted Street : Yard Tree Private 2     16     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
79769 207767 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 20 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     26 Width 10ft   5993205.66214 2097402.75145 37.7386781648646 -122.466030683288 (37.7386781648646, -122.466030683288) 1 8 4 59 40
80047 254287 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100X Junipero Serra Blvd 3 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 40
80068 207790 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 265 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     39 Width 10ft   5993131.48438 2096255.50329 37.735523828762 -122.466203802777 (37.735523828762, -122.466203802777) 1 8 4 59 40
80374 248219 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Fair Ave 2 Side Yard : Yard Tree Private 2     38     6007128.32554 2099340.74379 37.7447928407342 -122.418029950029 (37.7447928407342, -122.418029950029) 2 7 7 28859 2
80518 207797 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 145 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     42 Width 10ft   5993240.65413 2096747.66446 37.7368814785997 -122.465862113458 (37.7368814785997, -122.465862113458) 1 8 4 59 40
81100 207787 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 292 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 10ft   5993086.25016 2096104.57414 37.7351068050182 -122.466349227661 (37.7351068050182, -122.466349227661) 1 8 4 59 40
81197 92036 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
81211 116020 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2023 09TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5993447 2101700 37.7504912419676 -122.465508351594 (37.7504912419676, -122.465508351594) 1 8 4 29491 40
81221 208950 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 440 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     26 Width 10ft   5992985.54967 2096006.72468 37.7348323238367 -122.466690272156 (37.7348323238367, -122.466690272156) 9 8 4 59 40
81662 209017 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 33 Martha Ave 1 : Yard Tree Private 2     25     6000774.79116 2095519.58157 37.7339411856303 -122.439725313784 (37.7339411856303, -122.439725313784) 9 7 5 63 40
82626 258290 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 7 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
82650 209042 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 419 Baden St 7 Front Yard : Yard Tree Private 2     7     6000746.1619 2095340.78312 37.7334486170489 -122.439811478728 (37.7334486170489, -122.439811478728) 9 7 5 63 40
82743 209039 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 419 Baden St 4 Front Yard : Yard Tree Private 2     1     6000750.66308 2095345.51302 37.7334618604699 -122.439796255913 (37.7334618604699, -122.439796255913) 9 7 5 63 40
82854 114075 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     26     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
82917 254315 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200X Junipero Serra Blvd 2 Median : Yard Tree Private 2       10x10   5991374 2095037 37.73207656946 -122.472191241156 (37.73207656946, -122.472191241156) 1 8 4 64 40
82973 126581 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 556 Pine St 2 Sidewalk: Property side : Yard Tree Private 2     20 Width 5ft   6011285.65956 2116338.25251 37.7916972455684 -122.404851076143 (37.7916972455684, -122.404851076143) 5 1 10 28857 6
83967 176343 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450 Raymond Ave 1 Sidewalk: Property side : Yard Tree Private 2     76     6008484.74111 2088383.42134 37.7147826330863 -122.412565284366 (37.7147826330863, -122.412565284366) 9 7 8 309 18
84225 209038 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 419 Baden St 3 Front Yard : Yard Tree Private 2     6     6000746.77902 2095349.32051 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065) 9 7 5 63 40
84733 253848 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 230 Junipero Serra Blvd 3 Median : Yard Tree Private 2       10X10   5991365 2094903 37.7317081183109 -122.472212591573 (37.7317081183109, -122.472212591573) 1 8 4 64 40
84756 208946 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 300 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 10ft   5992719.83793 2096001.79663 37.7348034547201 -122.467608563598 (37.7348034547201, -122.467608563598) 9 8 4 59 40
85322 208931 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 435 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     27 Width 10ft   5993027.44059 2096068.92828 37.7350055368649 -122.466549961711 (37.7350055368649, -122.466549961711) 1 8 4 59 40
85357 208926 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 301 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     43 Width 10ft   5992668.30531 2096054.89965 37.7349462868375 -122.467790589077 (37.7349462868375, -122.467790589077) 1 8 4 59 40
85519 113859 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
86597 208949 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 402 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     26 Width 10ft   5992933.73617 2096006.17085 37.7348278128415 -122.466869367631 (37.7348278128415, -122.466869367631) 9 8 4 59 40
87214 224248 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 512 Clipper St 4 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   6001839.26935 2100907.02963 37.7487943903519 -122.43643055214 (37.7487943903519, -122.43643055214) 2 4 5 28862 22
87323 173856 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 118 Saint Mary's Ave 2 Sidewalk: Property side : Yard Tree DPW 1       Width 3ft   6003956.18287 2095944.61673 37.7352888053199 -122.42875656067 (37.7352888053199, -122.42875656067) 2 7 5 63 7
87775 246757 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Waltham St 1 Front Yard : Yard Tree Private 2     27     6009117.20748 2098899.99025 37.7436943673943 -122.41112161979 (37.7436943673943, -122.41112161979) 2 7 7 28859 2
88934 247919 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 4 Side Yard : Yard Tree Private 2     22     6010242.48982 2098715.37522 37.7432504962209 -122.40721763491 (37.7432504962209, -122.40721763491) 10 7 7 28859 2
89376 209032 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 38 Martha Ave 1 Front Yard : Yard Tree Private 2     5     6000749.17916 2095580.79962 37.7341078183059 -122.439818249733 (37.7341078183059, -122.439818249733) 9 7 5 63 40
89483 224222 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 3 Front Yard : Yard Tree Private 2     14     6004869.89816 2096730.73115 37.7374989702074 -122.425653440952 (37.7374989702074, -122.425653440952) 2 7 5 63 7
89575 113506 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200x Mansell St 12 Median : Cutout Tree DPW 1     39 3x3   6011135.08211 2090555.53588 37.7208952054249 -122.403557288932 (37.7208952054249, -122.403557288932) 10 3 7 309 28
90362 254305 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
90994 113367 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 6X Christopher Dr 1 Front Yard : Yard Tree DPW 1     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361) 1 5 4 63 12
91634 208930 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 435 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     55 Width 10ft   5993068.37064 2096069.711 37.7350100478567 -122.466408510055 (37.7350100478567, -122.466408510055) 1 8 4 59 40
91970 208996 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 4ft   5993421.96829 2097241.5815 37.7382481090644 -122.465271101502 (37.7382481090644, -122.465271101502) 1 8 4 59 40
91988 224256 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 355 Buena Vista Ave East 12 Sidewalk: Property side : Yard Tree Private 2     24 Width 3ft   6001050.21768 2107873.33716 37.7678773063135 -122.439658435714 (37.7678773063135, -122.439658435714) 15 5 5 29492 3
92601 208973 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 136 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 6ft   5994259.72598 2096572.09553 37.7364581434207 -122.462326027748 (37.7364581434207, -122.462326027748) 9 8 4 59 40
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
93771 29600 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900X Junipero Serra Blvd 9 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478) 9 8 4 64 40
94300 113861 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
96359 122535 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 199x Coso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6007478 2099565 37.7454282725128 -122.416836723884 (37.7454282725128, -122.416836723884) 2 7 7 28859 2
96951 247928 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     22     6010393.74755 2098772.89885 37.7434169076795 -122.406698675702 (37.7434169076795, -122.406698675702) 10 7 7 28859 2
97103 247917 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     32     6010231.88216 2098716.76824 37.7432537274832 -122.407254411775 (37.7432537274832, -122.407254411775) 10 7 7 28859 2
97567 254310 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 2 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
97814 208935 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 3 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 10ft   5991812.79149 2095969.62922 37.7346627188958 -122.470742164934 (37.7346627188958, -122.470742164934) 9 8 4 59 40
98944 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 301X Sargent St 1 Front Yard : Cutout Tree Private 2       3x3   5993018 2089140 37.7159798527116 -122.466079257059 (37.7159798527116, -122.466079257059) 9 8 6 64 24
99245 224225 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 15 Front Yard : Yard Tree Private 2     32     6004862.25492 2096710.90423 37.737444098063 -122.425678456492 (37.737444098063, -122.425678456492) 2 7 5 63 7
100447 208954 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 600 Saint Francis Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     30 Width 8ft   5993495.97502 2095994.95159 37.7348294415148 -122.464924714122 (37.7348294415148, -122.464924714122) 9 8 4 59 40
100794 209022 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 34 Martha Ave 2 Front Yard : Yard Tree Private 2     33     6000785.93499 2095562.56819 37.7340598511869 -122.439689867014 (37.7340598511869, -122.439689867014) 9 7 5 63 40
101469 254309 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 6 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
102459 208944 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 234 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     41 Width 10ft   5992497.26068 2095992.67828 37.7347655644733 -122.468377420108 (37.7347655644733, -122.468377420108) 9 8 4 59 40
102664 207795 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 213 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993167.32945 2096610.60875 37.7365009277821 -122.466105670558 (37.7365009277821, -122.466105670558) 1 8 4 59 40
103049 185917 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2000 Sunset Blvd 60 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5985004.5736 2101420.7172 37.7492338700088 -122.494681880668 (37.7492338700088, -122.494681880668) 1 8 3 29491 35
103215 3751 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 990 Carolina St 1 Median : Cutout Tree DPW 1     42 18   6012435.5557064 2103342.2152382 37.7560772927341 -122.399959384248 (37.7560772927341, -122.399959384248) 10 3 8 28856 29
103652 247921 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 6 Side Yard : Yard Tree Private 2     38     6010260.8237 2098716.17835 37.7432537274883 -122.407154297447 (37.7432537274883, -122.407154297447) 10 7 7 28859 2
104292 253843 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 130X Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x30   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
104435 106173 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 267 Green St 1 Front Yard : Yard Tree Private 2         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098) 3 1 10 308 23
104555 258287 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 4 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
104699 114731 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 934 BRANNAN ST   Back Yard : Yard Tree Private 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
104749 111529 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900x BOSWORTH ST 7 Front Yard : Yard Tree DPW 1     24     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
104882 254303 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 6 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
104986 114043 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 4 Front Yard : Yard Tree DPW 1       3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
105571 208927 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 301 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     36 Width 10ft   5992731.01578 2096057.52147 37.7349571065737 -122.467573969373 (37.7349571065737, -122.467573969373) 1 8 4 59 40
105925 111513 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 800x BOSWORTH ST 8 Front Yard : Yard Tree DPW 1     16     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
106420 224238 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 30 Front Yard : Yard Tree Private 2     6     6004809.6017 2096680.00592 37.737356282853 -122.425858304718 (37.737356282853, -122.425858304718) 2 7 5 63 7
106599 224227 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 17 Front Yard : Yard Tree Private 2     12     6004843.36157 2096707.31423 37.7374331731056 -122.425743524245 (37.7374331731056, -122.425743524245) 2 7 5 63 7
106673 256140 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 892 Moultrie St 1 Side Yard : Yard Tree Private 2       3x3   6007512 2095150 37.7333075704823 -122.416406492547 (37.7333075704823, -122.416406492547) 2 7 7 28859 2
107250 92038 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
107735 207766 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 14 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5993184.09693 2097461.91411 37.7388393665447 -122.466109543018 (37.7388393665447, -122.466109543018) 1 8 4 59 40
107750 208968 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 34 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 6ft   5993576.11533 2097077.37044 37.7378061147578 -122.464726220253 (37.7378061147578, -122.464726220253) 1 8 4 59 40
107830 209027 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 36 Martha Ave 4 Front Yard : Yard Tree Private 2     10     6000763.85093 2095573.2374 37.7340878893448 -122.439766982962 (37.7340878893448, -122.439766982962) 9 7 5 63 40
108706 209006 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 172 Kensington Way 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 3ft   5994773.63128 2098602.47798 37.7420626491773 -122.460696346461 (37.7420626491773, -122.460696346461) 1 8 4 59 40
108717 224262 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 91 Stanton St 2 : Yard Tree Private 2     22 Width 3ft   6000293.691 2103856.20704 37.7568041715846 -122.44198679486 (37.7568041715846, -122.44198679486) 2 4 5 28862 38
108912 245009 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1466 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   5999558.6674 2109145.6245 37.7712856788974 -122.444908986977 (37.7712856788974, -122.444908986977) 15 5 11 29492 9
110057 191738 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 920 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     39     6011311.04969 2104026.19787 37.757892599481 -122.403896453867 (37.757892599481, -122.403896453867) 10 3 8 28856 29
110371 112189 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 301x CORBETT AVE 1 Sidewalk: Property side : Yard Tree DPW 1     12 3x3   5999677 2105220 37.760513648973 -122.444217531177 (37.760513648973, -122.444217531177) 15 5 5 28862 3
110387 207760 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 333 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 10ft   5993144.47081 2095802.99513 37.7342821033408 -122.466126031205 (37.7342821033408, -122.466126031205) 9 8 4 59 40
110527 208925 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 235 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     45 Width 10ft   5992554.16067 2096052.70309 37.7349336639503 -122.468185064096 (37.7349336639503, -122.468185064096) 1 8 4 59 40
111198 208961 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1575 07th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   5993977.82871 2104681.32491 37.7587077962432 -122.463889098911 (37.7587077962432, -122.463889098911) 1 5 4 56 12
111534 224236 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 26 Front Yard : Yard Tree Private 2     25     6004818.97924 2096691.85028 37.737389334736 -122.425826725021 (37.737389334736, -122.425826725021) 2 7 5 63 7
111543 209044 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 690 Mangels Ave 8 Sidewalk: Property side : Yard Tree Private 2     30 Width 10ft   5996811.85436 2095301.80777 37.7331168670328 -122.453410604043 (37.7331168670328, -122.453410604043) 9 7 4 59 40
111670 104402 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 301 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2           6000011.7 2094912.1 37.7322297190532 -122.442319949129 (37.7322297190532, -122.442319949129) 9 7 4 63 40
111701 209033 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 38 Martha Ave 2 Front Yard : Yard Tree Private 2     10     6000746.95442 2095582.5977 37.7341126287783 -122.439826070211 (37.7341126287783, -122.439826070211) 9 7 5 63 40
112183 224260 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 355 Buena Vista Ave East 16 Sidewalk: Property side : Yard Tree Private 2     23 Width 3ft   6001102.84855 2107909.89342 37.7679806761809 -122.439479012854 (37.7679806761809, -122.439479012854) 15 5 5 29492 3
112500 209000 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 135 Yerba Buena Ave 5 Sidewalk: Curb side : Yard Tree Private 2     27 Width 4ft   5994206.5655 2096669.18291 37.7367216600723 -122.462516864768 (37.7367216600723, -122.462516864768) 9 8 4 59 40
112642 208952 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 440 Saint Francis Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     18 Width 10ft   5993062.86843 2096011.9995 37.7348512689743 -122.466423339872 (37.7348512689743, -122.466423339872) 9 8 4 59 40
112880 191737 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6010885.73151 2096220.33708 37.7364356342809 -122.404817839882 (37.7364356342809, -122.404817839882) 10 3 8 58 1
114012 112188 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 301x CORBETT AVE 2 Sidewalk: Property side : Yard Tree DPW 1     45 3x3   5999677 2105220 37.760513648973 -122.444217531177 (37.760513648973, -122.444217531177) 15 5 5 28862 3
114444 176336 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 9 Side Yard : Yard Tree Private 2     31     6012249.60162 2087766.47281 37.7132991905898 -122.39950899437 (37.7132991905898, -122.39950899437) 10 3 8 309 1
114597 208945 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 234 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     40 Width 10ft   5992554.30272 2095990.82137 37.7347637604433 -122.46818007286 (37.7347637604433, -122.46818007286) 9 8 4 59 40

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