Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
| 5068 | 5068 | 253206 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2253 09th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
| 2603 | 2603 | 253136 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3059 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x5 | 5999298.0 | 2114593.0 | 37.786227889505604 | -122.446202552789 | (37.7862278895056, -122.446202552789) | ||||
| 3693 | 3693 | 252877 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1400 Baker St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 22896 | 22896 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22892 | 22892 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
| 174300 | 174300 | 248219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Fair Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6007128.325540001 | 2099340.74379 | 37.744792840734206 | -122.418029950029 | (37.7447928407342, -122.418029950029) | ||||
| 153590 | 153590 | 248107 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 138 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | ||||
| 59219 | 59219 | 247999 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 346 Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6009771.618319999 | 2099231.70155 | 37.744641851750295 | -122.40888221345101 | (37.7446418517503, -122.408882213451) | ||||
| 56692 | 56692 | 247937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1149 Esmeralda Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.40724215312599 | (37.7433393564296, -122.407242153126) | ||||
| 74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) | ||||
| 181095 | 181095 | 247932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010369.906140001 | 2098762.7933799997 | 37.743387826290395 | -122.406780401602 | (37.7433878262904, -122.406780401602) | ||||
| 31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 166763 | 166763 | 247928 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | ||||
| 70884 | 70884 | 247927 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.40695611204501 | (37.7433135063186, -122.406956112045) | ||||
| 59867 | 59867 | 247926 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010312.05046 | 2098736.31721 | 37.743311891127604 | -122.406978587005 | (37.7433118911276, -122.406978587005) | ||||
| 46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
| 30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
| 62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
| 147007 | 147007 | 247922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010270.948580001 | 2098720.09099 | 37.7432650373678 | -122.40711956383001 | (37.7432650373678, -122.40711956383) | ||||
| 169544 | 169544 | 247921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | ||||
| 25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
| 150294 | 150294 | 247917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | ||||
| 70101 | 70101 | 247851 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 152 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 79 | 6009070.86749 | 2098234.59559 | 37.7418647407582 | -122.411234858803 | (37.7418647407582, -122.411234858803) | ||||
| 172652 | 172652 | 247821 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009717.95526 | 2096849.3331900002 | 37.7380973799798 | -122.40889971695 | (37.7380973799798, -122.40889971695) | ||||
| 148899 | 148899 | 247820 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009707.559769999 | 2096850.2861400002 | 37.7380994142676 | -122.40893572671699 | (37.7380994142676, -122.408935726717) | ||||
| 146980 | 146980 | 247819 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 Jarboe Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009694.17454 | 2096850.5592099999 | 37.738099414264 | -122.408982025597 | (37.738099414264, -122.408982025597) | ||||
| 183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
| 182567 | 182567 | 246763 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009290.72604 | 2098884.53398 | 37.74366165725821 | -122.410520540796 | (37.7436616572582, -122.410520540796) | ||||
| 186126 | 186126 | 246762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6009259.9688 | 2098886.63063 | 37.743665689828 | -122.41062704033101 | (37.743665689828, -122.410627040331) | ||||
| 185207 | 185207 | 246760 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6009218.12342 | 2098889.2056 | 37.7436704139605 | -122.410771913907 | (37.7436704139605, -122.410771913907) | ||||
| 169268 | 169268 | 246758 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6009165.3759699995 | 2098887.8964 | 37.743663861508395 | -122.41095421008801 | (37.7436638615084, -122.410954210088) | ||||
| 63741 | 63741 | 246757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161978998 | (37.7436943673943, -122.41112161979) | ||||
| 177301 | 177301 | 245010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1480 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999484.2143 | 2109133.9912 | 37.7712494874058 | -122.44516568603999 | (37.7712494874058, -122.44516568604) | |||
| 183205 | 183205 | 245009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1466 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5999558.6674 | 2109145.6245 | 37.7712856788974 | -122.44490898697701 | (37.7712856788974, -122.444908986977) | |||
| 71541 | 71541 | 224269 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6011241.96431 | 2103719.95233 | 37.7570478572995 | -122.404113828986 | (37.7570478572995, -122.404113828986) | ||||
| 73320 | 73320 | 224268 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011248.24436 | 2103720.25065 | 37.757049027311204 | -122.40409213106001 | (37.7570490273112, -122.40409213106) | ||||
| 156972 | 156972 | 224267 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6011260.203430001 | 2103721.90369 | 37.7570542343818 | -122.40405088815001 | (37.7570542343818, -122.40405088815) | ||||
| 130703 | 130703 | 224266 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2300 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6011271.09407 | 2103721.28577 | 37.75705314619071 | -122.404013180481 | (37.7570531461907, -122.404013180481) | ||||
| 181159 | 181159 | 224265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 58 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 38 | 6002671.84671 | 2096513.9082400003 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) | ||||
| 186323 | 186323 | 224264 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004254.57068 | 2108904.38845 | 37.770890184456796 | -122.42864845406 | (37.7708901844568, -122.42864845406) | |||
| 69421 | 69421 | 224263 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004229.44428 | 2108900.2308400003 | 37.770877346636205 | -122.42873507047399 | (37.7708773466362, -122.428735070474) | |||
| 186405 | 186405 | 224262 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 91 Stanton St | 2 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6000293.691000001 | 2103856.2070400002 | 37.7568041715846 | -122.44198679486 | (37.7568041715846, -122.44198679486) | |||
| 171861 | 171861 | 224261 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6001117.5941 | 2107921.40745 | 37.768013130033204 | -122.439428835199 | (37.7680131300332, -122.439428835199) | |||
| 175102 | 175102 | 224260 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6001102.84855 | 2107909.89342 | 37.7679806761809 | -122.43947901285401 | (37.7679806761809, -122.439479012854) | |||
| 35751 | 35751 | 224259 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6001093.91519 | 2107903.0746400002 | 37.767961445086605 | -122.43950942341999 | (37.7679614450866, -122.43950942342) | |||
| 26913 | 26913 | 224258 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6001075.26018 | 2107893.8305599997 | 37.7679350014146 | -122.439573286101 | (37.7679350014146, -122.439573286101) | |||
| 61025 | 61025 | 224257 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6001064.07525 | 2107884.43165 | 37.767908557750204 | -122.439611299541 | (37.7679085577502, -122.439611299541) | |||
| 137374 | 137374 | 224256 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Buena Vista Ave East | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6001050.217680001 | 2107873.3371599996 | 37.7678773063135 | -122.439658435714 | (37.7678773063135, -122.439658435714) | |||
| 36905 | 36905 | 224255 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 388 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999122.55283 | 2104753.1321799997 | 37.7592000986313 | -122.446101520571 | (37.7592000986313, -122.446101520571) | |||
| 146709 | 146709 | 224254 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 190 Storrie St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6000752.12131 | 2105271.59361 | 37.760716590308704 | -122.440502889194 | (37.7607165903087, -122.440502889194) | |||
| 44163 | 44163 | 224253 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 755 Sanchez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003620.8208099995 | 2103873.1752 | 37.757039798462294 | -122.430481566473 | (37.7570397984623, -122.430481566473) | |||
| 159737 | 159737 | 224252 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 177 Powhattan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 3ft | 6008209.41115 | 2098117.01266 | 37.741493532991 | -122.41420518642299 | (37.741493532991, -122.414205186423) | |||
| 32753 | 32753 | 224251 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 177 Powhattan Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6008204.54136 | 2098121.72815 | 37.741506207147005 | -122.414222358085 | (37.741506207147, -122.414222358085) | |||
| 64417 | 64417 | 224250 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 425 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 5ft | 6007149.05774 | 2097827.31438 | 37.740638468384795 | -122.417851002914 | (37.7406384683848, -122.417851002914) | |||
| 165255 | 165255 | 224249 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x 27th St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | Width 4ft | 6002852.0087 | 2100065.56768 | 37.7465414276517 | -122.432868400457 | (37.7465414276517, -122.432868400457) | |||
| 33426 | 33426 | 224248 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055213998 | (37.7487943903519, -122.43643055214) | |||
| 76551 | 76551 | 224247 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 527 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 46 | 6008745.222630001 | 2098103.60695 | 37.74148680607821 | -122.412351580256 | (37.7414868060782, -122.412351580256) | ||||
| 73493 | 73493 | 224246 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 483 Valley St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 55 | 6002830.24391 | 2099168.61142 | 37.744077360782796 | -122.432879592517 | (37.7440773607828, -122.432879592517) | ||||
| 51062 | 51062 | 224245 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 160 Coso Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6007485.6356 | 2099587.10163 | 37.7454893881214 | -122.41681188667201 | (37.7454893881214, -122.416811886672) | ||||
| 41325 | 41325 | 224244 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004777.47133 | 2096641.4622900002 | 37.73724863492671 | -122.425966651467 | (37.7372486349267, -122.425966651467) | ||||
| 61748 | 61748 | 224243 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004771.77471 | 2096643.7523700001 | 37.737254601020005 | -122.425986510284 | (37.73725460102, -122.425986510284) | ||||
| 178073 | 178073 | 224242 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004773.2240699995 | 2096631.25513 | 37.7372203683314 | -122.425980609816 | (37.7372203683314, -122.425980609816) | ||||
| 136867 | 136867 | 224241 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004764.42793 | 2096634.9587599998 | 37.7372300405369 | -122.42601128568998 | (37.7372300405369, -122.42601128569) | ||||
| 135905 | 135905 | 224240 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6004759.95311 | 2096625.2597 | 37.7372031562031 | -122.426026066958 | (37.7372031562031, -122.426026066958) | ||||
| 50832 | 50832 | 224239 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004801.05123 | 2096666.83115 | 37.7373196246961 | -122.425886930149 | (37.7373196246961, -122.425886930149) | ||||
| 48572 | 48572 | 224238 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004809.6017 | 2096680.0059200001 | 37.737356282853 | -122.425858304718 | (37.737356282853, -122.425858304718) | ||||
| 63892 | 63892 | 224237 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004814.56562 | 2096681.78705 | 37.7373614539559 | -122.425841268876 | (37.7373614539559, -122.425841268876) | ||||
| 155920 | 155920 | 224236 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004818.97924 | 2096691.85028 | 37.737389334736 | -122.425826725021 | (37.737389334736, -122.425826725021) | ||||
| 179858 | 179858 | 224235 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004831.6413199995 | 2096688.95275 | 37.7373820943173 | -122.425782740103 | (37.7373820943173, -122.425782740103) | ||||
| 124116 | 124116 | 224234 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004836.880530001 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | ||||
| 181562 | 181562 | 224233 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004845.23458 | 2096693.0180000002 | 37.737394024725205 | -122.42573603111 | (37.7373940247252, -122.42573603111) | ||||
| 135102 | 135102 | 224232 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004847.66693 | 2096700.7431599998 | 37.7374153737207 | -122.425728171024 | (37.7374153737207, -122.425728171024) | ||||
| 162554 | 162554 | 224231 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004851.9976 | 2096696.37519 | 37.7374036249796 | -122.42571288706301 | (37.7374036249796, -122.425712887063) | ||||
| 133399 | 133399 | 224230 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004850.154069999 | 2096702.7007099998 | 37.7374208892559 | -122.425719711103 | (37.7374208892559, -122.425719711103) | ||||
| 63720 | 63720 | 224229 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004833.29966 | 2096702.67223 | 37.7374198586269 | -122.425777982686 | (37.7374198586269, -122.425777982686) | ||||
| 68974 | 68974 | 224228 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004840.27089 | 2096702.3446900002 | 37.7374193532181 | -122.425753856564 | (37.7374193532181, -122.425753856564) | ||||
| 41213 | 41213 | 224227 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004843.36157 | 2096707.31423 | 37.7374331731056 | -122.425743524245 | (37.7374331731056, -122.425743524245) | ||||
| 181724 | 181724 | 224226 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004846.937969999 | 2096712.6297900002 | 37.7374479705325 | -122.42573153718 | (37.7374479705325, -122.42573153718) | ||||
| 26944 | 26944 | 224225 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004862.254919999 | 2096710.90423 | 37.737444098063 | -122.42567845649201 | (37.737444098063, -122.425678456492) | ||||
| 63465 | 63465 | 224224 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004854.036780001 | 2096713.3958700001 | 37.737450475157296 | -122.42570704776199 | (37.7374504751573, -122.425707047762) | ||||
| 61471 | 61471 | 224223 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004855.412690001 | 2096718.43509 | 37.7374643894683 | -122.425702649156 | (37.7374643894683, -122.425702649156) | ||||
| 61204 | 61204 | 224222 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004869.898159999 | 2096730.73115 | 37.7374989702074 | -122.42565344095199 | (37.7374989702074, -122.425653440952) | ||||
| 177154 | 177154 | 224221 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1000 San Jose Ave | 63 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005093.2410699995 | 2097044.1609999998 | 37.7383721957242 | -122.424903531393 | (37.7383721957242, -122.424903531393) | ||||
| 164177 | 164177 | 224220 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6004122.93683 | 2095831.8247900002 | 37.734988540591395 | -122.42817199506099 | (37.7349885405914, -122.428171995061) | ||||
| 154936 | 154936 | 224219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004118.53569 | 2095824.9734900002 | 37.734969479450896 | -122.428186723249 | (37.7349694794509, -122.428186723249) | ||||
| 74562 | 74562 | 209046 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.732290932375605 | -122.442419949729 | (37.7322909323756, -122.442419949729) | |||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 161658 | 161658 | 209044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 690 Mangels Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 5996811.85436 | 2095301.80777 | 37.7331168670328 | -122.453410604043 | (37.7331168670328, -122.453410604043) | |||
| 46778 | 46778 | 209043 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 690 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 10ft | 5996832.93686 | 2095303.5906200001 | 37.7331229707542 | -122.453337845278 | (37.7331229707542, -122.453337845278) | |||
| 45082 | 45082 | 209042 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6000746.1619 | 2095340.78312 | 37.7334486170489 | -122.439811478728 | (37.7334486170489, -122.439811478728) | ||||
| 36668 | 36668 | 209041 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000751.4342 | 2095340.2355900002 | 37.7334474137664 | -122.43979321169901 | (37.7334474137664, -122.439793211699) | ||||
| 34595 | 34595 | 209040 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000753.71672 | 2095344.13435 | 37.7334582487793 | -122.43978559983 | (37.7334582487793, -122.43978559983) | ||||
| 157173 | 157173 | 209039 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6000750.66308 | 2095345.5130200002 | 37.7334618604699 | -122.439796255913 | (37.7334618604699, -122.439796255913) | ||||
| 35228 | 35228 | 209038 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 419 Baden St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6000746.779019999 | 2095349.3205099998 | 37.7334720938659 | -122.439809957065 | (37.7334720938659, -122.439809957065) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");