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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 103214 | 103214 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 267 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | ||||
| 43267 | 43267 | 121204 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 52 | 6008473.20212 | 2119153.5676 | 37.799269800719294 | -122.41478152415002 | (37.7992698007193, -122.41478152415) | ||||
| 151150 | 151150 | 126581 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 556 Pine St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6011285.65956 | 2116338.25251 | 37.7916972455684 | -122.404851076143 | (37.7916972455684, -122.404851076143) | |||
| 20653 | 20653 | 2618 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 78801 | 78801 | 2617 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 80756 | 80756 | 2614 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 116419 | 116419 | 2615 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 138324 | 138324 | 2616 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
| 89069 | 89069 | 138024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248002 | (37.7877405482561, -122.42694291248) | |||
| 126390 | 126390 | 2619 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 10X10 | 6004877.75733 | 2115027.26874 | 37.7877373561683 | -122.42692897924101 | (37.7877373561683, -122.426928979241) | |||
| 70742 | 70742 | 138025 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1651 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 49 | Width 0ft | 6004878.9655 | 2114979.8902 | 37.7876073348692 | -122.42692142358601 | (37.7876073348692, -122.426921423586) | |||
| 9488 | 9488 | 17957 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 2500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001928.8852 | 2115030.4127 | 37.7875788082428 | -122.437131721785 | (37.7875788082428, -122.437131721785) | |||
| 153710 | 153710 | 138026 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1641 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 57 | Width 0ft | 6004881.8597 | 2114953.8419999997 | 37.787535976676395 | -122.426909554358 | (37.7875359766764, -122.426909554358) | |||
| 41245 | 41245 | 138027 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1631 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | |||
| 176724 | 176724 | 138028 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1621 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 49 | Width 0ft | 6004887.6482 | 2114917.9533 | 37.7874377625804 | -122.426886970359 | (37.7874377625804, -122.426886970359) | |||
| 36877 | 36877 | 138087 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1611 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | |||
| 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) | ||||
| 6891 | 6891 | 7808 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 700X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006239.03041 | 2112534.82936 | 37.7809706070447 | -122.422042095466 | (37.7809706070447, -122.422042095466) | |||
| 684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
| 7960 | 7960 | 23202 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006708.88776 | 2112470.99571 | 37.7808218241176 | -122.420412091366 | (37.7808218241176, -122.420412091366) | |||
| 8841 | 8841 | 23183 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006719.9876 | 2112427.32903 | 37.780702551515496 | -122.42037059124901 | (37.7807025515155, -122.420370591249) | ||
| 656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
| 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) | ||||
| 54495 | 54495 | 118438 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 5201 Anza St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5982520.38622 | 2111663.82262 | 37.7772127952946 | -122.50403070229099 | (37.7772127952946, -122.504030702291) | |||
| 92339 | 92339 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010511.0 | 2109243.0 | 37.77217202356729 | -122.407031076357 | (37.7721720235673, -122.407031076357) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
| 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) | |||
| 158665 | 158665 | 191729 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | ||||
| 134906 | 134906 | 191730 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009966.3806300005 | 2107638.17528 | 37.767735053365705 | -122.40880172773399 | (37.7677350533657, -122.408801727734) | ||||
| 185592 | 185592 | 191731 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009975.967759999 | 2107617.96239 | 37.76768009039721 | -122.408767140702 | (37.7676800903972, -122.408767140702) | ||||
| 159705 | 159705 | 191732 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | ||||
| 164405 | 164405 | 191733 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009990.5053900005 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | ||||
| 50757 | 50757 | 191735 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010009.096969999 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | ||||
| 70209 | 70209 | 191734 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009976.801940001 | 2107534.39117 | 37.767450669731105 | -122.40875835881201 | (37.7674506697311, -122.408758358812) | ||||
| 48059 | 48059 | 43994 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | ||
| 105251 | 105251 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 119166 | 119166 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 128646 | 128646 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 143929 | 143929 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 149384 | 149384 | 207754 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1364 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5993663.7534300005 | 2106217.17575 | 37.7629067380829 | -122.46508685559999 | (37.7629067380829, -122.4650868556) | |||
| 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) | |||
| 102861 | 102861 | 112189 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
| 102986 | 102986 | 112188 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 45 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
| 179355 | 179355 | 207758 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 5994815.677630001 | 2105291.72467 | 37.7604320448236 | -122.461035696659 | (37.7604320448236, -122.461035696659) | ||||
| 138334 | 138334 | 207756 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | ||||
| 43564 | 43564 | 207757 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5994806.26925 | 2105291.62903 | 37.760431240817795 | -122.46106822873399 | (37.7604312408178, -122.461068228734) | ||||
| 134672 | 134672 | 207755 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.46113126040702 | (37.7604304368423, -122.461131260407) | ||||
| 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) | |||
| 84894 | 84894 | 105492 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1575 07TH AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773490 | 5993962.3 | 2104771.9 | 37.7589555970933 | -122.463949378571 | (37.7589555970933, -122.463949378571) | ||
| 132331 | 132331 | 208961 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1575 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5993977.82871 | 2104681.32491 | 37.75870779624321 | -122.463889098911 | (37.7587077962432, -122.463889098911) | |||
| 75518 | 75518 | 191738 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6011311.04969 | 2104026.1978700003 | 37.757892599481 | -122.40389645386699 | (37.757892599481, -122.403896453867) | ||||
| 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) | ||||
| 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) | ||||
| 55507 | 55507 | 191724 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6011608.5229400005 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | ||||
| 180599 | 180599 | 191725 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 46 | 6011608.2265 | 2103816.01851 | 37.75733209161471 | -122.40285390399201 | (37.7573320916147, -122.402853903992) | ||||
| 164592 | 164592 | 191726 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 700 Missouri St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6013632.69543 | 2103711.63212 | 37.757158302141 | -122.395845128465 | (37.757158302141, -122.395845128465) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
| 92343 | 92343 | 113367 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 6X Christopher Dr | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | ||||
| 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) | |||
| 141824 | 141824 | 121089 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
| 79476 | 79476 | 116530 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 745X SANCHEZ ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
| 153783 | 153783 | 191723 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x Carolina St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.39981689974701 | (37.7560429683291, -122.399816899747) | ||||
| 78981 | 78981 | 113860 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 92750 | 92750 | 113861 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 97315 | 97315 | 113859 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 141326 | 141326 | 113862 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 456 HILL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2103347.0 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | ||||
| 130593 | 130593 | 191727 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | ||||
| 39683 | 39683 | 191728 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1790 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201017999 | (37.754962860065, -122.39634201018) | ||||
| 43077 | 43077 | 191722 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014479.640380001 | 2101959.5389 | 37.752394509601494 | -122.392793471535 | (37.7523945096015, -122.392793471535) | ||||
| 139866 | 139866 | 115801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 9M CAIRE TER | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012720.0 | 2101959.0 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | |||||
| 85741 | 85741 | 114041 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
| 90640 | 90640 | 114042 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
| 101800 | 101800 | 114043 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
| 123394 | 123394 | 114040 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | |||
| 151444 | 151444 | 208979 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992891.21268 | 2101728.13425 | 37.7505364203394 | -122.467432335147 | (37.7505364203394, -122.467432335147) | |||
| 92823 | 92823 | 116020 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2023 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5993447.0 | 2101700.0 | 37.7504912419676 | -122.46550835159401 | (37.7504912419676, -122.465508351594) | ||||
| 128787 | 128787 | 116019 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2023 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5993447.0 | 2101700.0 | 37.7504912419676 | -122.46550835159401 | (37.7504912419676, -122.465508351594) | ||||
| 67133 | 67133 | 209003 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 96 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5994450.97172 | 2101378.39351 | 37.7496660456507 | -122.462013248027 | (37.7496660456507, -122.462013248027) | |||
| 76683 | 76683 | 185931 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985001.315 | 2101504.3546 | 37.749463324703996 | -122.494699314147 | (37.749463324704, -122.494699314147) | |||
| 77244 | 77244 | 185929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | |||
| 174806 | 174806 | 185917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985004.5736 | 2101420.7172 | 37.749233870008794 | -122.494681880668 | (37.7492338700088, -122.494681880668) | |||
| 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) |
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");