Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52418 | 52418 | 177149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991352.53535 | 2088761.3617099999 | 37.714843978538205 | -122.47180825186301 | (37.7148439785382, -122.471808251863) | |||
| 162256 | 162256 | 177150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991357.8727400005 | 2088731.5467 | 37.7147624226096 | -122.471787632218 | (37.7147624226096, -122.471787632218) | |||
| 7054 | 7054 | 4734 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6007950.0877 | 2121194.0464 | 37.80484303663339 | -122.416736319981 | (37.8048430366334, -122.416736319981) | |||
| 8565 | 8565 | 4733 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3x3 | 6007980.3619 | 2121165.8966 | 37.80476744709579 | -122.416629557244 | (37.8047674470958, -122.416629557244) | |||
| 8587 | 8587 | 4732 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | 3x3 | 6008014.3541 | 2121137.2157 | 37.8046906082857 | -122.41650989053801 | (37.8046906082857, -122.416509890538) | |||
| 87462 | 87462 | 4736 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Columbus Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3x3 | 6008154.5819477 | 2121037.0963081 | 37.804423590750396 | -122.41601752221001 | (37.8044235907504, -122.41601752221) | |||
| 223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
| 1722 | 1722 | 23787 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003801.3315 | 2112607.883 | 37.781033406276705 | -122.430480512141 | (37.7810334062767, -122.430480512141) | ||
| 2139 | 2139 | 23790 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003786.8931 | 2112715.8268 | 37.7813289751352 | -122.43053816621901 | (37.7813289751352, -122.430538166219) | |||
| 5279 | 5279 | 23791 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 6003783.4554 | 2112735.7654 | 37.7813835268154 | -122.430551482109 | (37.7813835268154, -122.430551482109) | |||
| 7642 | 7642 | 23788 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003799.2688 | 2112646.3852 | 37.7811390068769 | -122.43049039607 | (37.7811390068769, -122.43049039607) | |||
| 36379 | 36379 | 142721 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100x COLUMBUS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6008079.1516 | 2121077.7294 | 37.804530917755706 | -122.416281435895 | (37.8045309177557, -122.416281435895) | |||
| 45194 | 45194 | 142722 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100x COLUMBUS AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6008044.6283 | 2121108.5348 | 37.804613560274504 | -122.416403090609 | (37.8046135602745, -122.416403090609) | |||
| 168454 | 168454 | 96089 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1101 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767146 | 6012237.5036 | 2103271.25294 | 37.7558714019501 | -122.400639334242 | (37.7558714019501, -122.400639334242) | |
| 51744 | 51744 | 39563 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1102 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40984 | 6012176.35989 | 2103275.1391 | 37.7558786621771 | -122.400851063421 | (37.7558786621771, -122.400851063421) | |
| 55121 | 55121 | 59604 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1105 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 12 | Permit Number 19005 | 6015580.10762 | 2103879.44891 | 37.7577272366388 | -122.38912188497801 | (37.7577272366388, -122.389121884978) | ||
| 153581 | 153581 | 59603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1109 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 13 | Permit Number 19004 | 6015581.75911 | 2103854.91189 | 37.7576599547603 | -122.38911446017599 | (37.7576599547603, -122.389114460176) | ||
| 137384 | 137384 | 208053 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 111 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5993326.69721 | 2093754.23227 | 37.7286672184966 | -122.465347248004 | (37.7286672184966, -122.465347248004) | |||
| 109022 | 109022 | 29640 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 110556 | 110556 | 29641 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 144121 | 144121 | 29639 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
| 63311 | 63311 | 228020 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1112 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998182.13932 | 2106442.54702 | 37.7637850591596 | -122.449475636595 | (37.7637850591596, -122.449475636595) | |||
| 49489 | 49489 | 59601 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1113 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 15 | Permit Number 19002 | 6015581.41308 | 2103829.5931 | 37.757590415576 | -122.389113889098 | (37.757590415576, -122.389113889098) | ||
| 168458 | 168458 | 59599 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1117 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 14 | Permit Number 19000 | 6015586.46491 | 2103801.69873 | 37.7575141036211 | -122.38909447005699 | (37.7575141036211, -122.389094470057) | ||
| 177956 | 177956 | 228018 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1118 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998188.96847 | 2106410.92165 | 37.7636986145324 | -122.44944973792101 | (37.7636986145324, -122.449449737921) | |||
| 183153 | 183153 | 228019 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1118 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998187.56387 | 2106423.37848 | 37.7637327374956 | -122.44945549358299 | (37.7637327374956, -122.449455493583) | |||
| 42285 | 42285 | 33829 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 15 | Permit Number 37844 | 6015587.6013400005 | 2103776.1855900004 | 37.7574441129692 | -122.38908875844601 | (37.7574441129692, -122.389088758446) | ||
| 156880 | 156880 | 33828 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 7 | Permit Number 37844 | 6015588.22624 | 2103756.71192 | 37.757390677059 | -122.38908523761299 | (37.757390677059, -122.389085237613) | ||
| 68517 | 68517 | 227725 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1125 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998884.79342 | 2105911.12846 | 37.7623660872596 | -122.447007136094 | (37.7623660872596, -122.447007136094) | |||
| 166783 | 166783 | 191517 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1129 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015588.78153 | 2103719.02877 | 37.7572872379344 | -122.389080686136 | (37.7572872379344, -122.389080686136) | |||
| 157294 | 157294 | 59707 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1133 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19137 | 6015590.05369 | 2103684.27955 | 37.757191894493296 | -122.38907386028299 | (37.7571918944933, -122.389073860283) | ||
| 63354 | 63354 | 228017 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998195.21077 | 2106351.13938 | 37.7635348245821 | -122.44942384014601 | (37.7635348245821, -122.449423840146) | |||
| 43056 | 43056 | 191129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012185.62091 | 2103105.89638 | 37.7554144753107 | -122.400807145928 | (37.7554144753107, -122.400807145928) | |||
| 142405 | 142405 | 121587 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6012170.0 | 2103110.0 | 37.7554248716487 | -122.400861456416 | (37.7554248716487, -122.400861456416) | ||
| 56359 | 56359 | 228007 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1139 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998149.3046699995 | 2106328.0712900003 | 37.763468859326295 | -122.44958095170901 | (37.7634688593263, -122.449580951709) | |||
| 131118 | 131118 | 227877 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Corwin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000737.7441300005 | 2104105.27937 | 37.7575133580643 | -122.440468962298 | (37.7575133580643, -122.440468962298) | |||
| 72800 | 72800 | 208075 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998390.034080001 | 2098450.75063 | 37.7418534470942 | -122.448181102087 | (37.7418534470942, -122.448181102087) | |||
| 65030 | 65030 | 54536 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 5 | Permit Number 10331 | 6009931.29054 | 2095213.10874 | 37.7336166059206 | -122.408046748666 | (37.7336166059206, -122.408046748666) | ||
| 154927 | 154927 | 227726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1143 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998891.01652 | 2105852.59143 | 37.7622057147555 | -122.44698140018801 | (37.7622057147555, -122.446981400188) | |||
| 54555 | 54555 | 227728 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998894.21082 | 2105816.78299 | 37.762107576228296 | -122.446967775438 | (37.7621075762283, -122.446967775438) | |||
| 131392 | 131392 | 227727 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998891.41091 | 2105829.4817 | 37.7621422837475 | -122.446978373068 | (37.7621422837475, -122.446978373068) | |||
| 42186 | 42186 | 228008 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998158.99229 | 2106286.14081 | 37.7633542830094 | -122.449544423956 | (37.7633542830094, -122.449544423956) | |||
| 42724 | 42724 | 227852 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004384.0702 | 2101006.82199 | 37.749212670433295 | -122.427637746503 | (37.7492126704333, -122.427637746503) | |||
| 62922 | 62922 | 227853 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004399.30217 | 2101007.45313 | 37.749215264974396 | -122.42758511905399 | (37.7492152649744, -122.427585119054) | |||
| 79135 | 79135 | 88593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51537 | 6004415.0 | 2101011.0 | 37.7492258917596 | -122.427531088347 | (37.7492258917596, -122.427531088347) | ||
| 86940 | 86940 | 88592 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51537 | 6004415.0 | 2101011.0 | 37.7492258917596 | -122.427531088347 | (37.7492258917596, -122.427531088347) | ||
| 32695 | 32695 | 191536 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014495.86116 | 2103903.97635 | 37.7577344195295 | -122.39287340149099 | (37.7577344195295, -122.392873401491) | |||
| 36890 | 36890 | 191535 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6014535.49417 | 2103905.68613 | 37.757741315531504 | -122.392736452724 | (37.7577413155315, -122.392736452724) | |||
| 155762 | 155762 | 191537 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6014473.63415 | 2103902.4166 | 37.7577289021798 | -122.392950163136 | (37.7577289021798, -122.392950163136) | |||
| 74327 | 74327 | 38387 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 13 | Permit Number 40446 | 6014272.48503 | 2096672.22783 | 37.7378651543499 | -122.39313992457399 | (37.7378651543499, -122.393139924574) | ||
| 51194 | 51194 | 99324 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5989313.9402 | 2097680.7708 | 37.739216248209 | -122.479506595172 | (37.739216248209, -122.479506595172) | |||
| 59050 | 59050 | 99321 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989362.5919 | 2097683.4007 | 37.7392262951159 | -122.47933857369101 | (37.7392262951159, -122.479338573691) | |||
| 76802 | 76802 | 99318 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989408.3581 | 2097684.4234 | 37.7392317612483 | -122.47918041128 | (37.7392317612483, -122.47918041128) | |||
| 134764 | 134764 | 99319 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989394.1498 | 2097683.839 | 37.73922933145371 | -122.479229493917 | (37.7392293314537, -122.479229493917) | |||
| 165203 | 165203 | 99322 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5989346.812999999 | 2097682.9624 | 37.739224175183 | -122.479393097373 | (37.739224175183, -122.479393097373) | |||
| 166570 | 166570 | 99320 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5989380.1241 | 2097683.1815 | 37.7392267115304 | -122.479277939862 | (37.7392267115304, -122.479277939862) | |||
| 173203 | 173203 | 99323 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5989330.3766 | 2097681.8666 | 37.73922021170971 | -122.479449846275 | (37.7392202117097, -122.479449846275) | |||
| 91835 | 91835 | 99325 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150@23rd Ave Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x6 | 5989403.0 | 2097682.0 | 37.73922479603689 | -122.479198759749 | (37.7392247960369, -122.479198759749) | ||||
| 64321 | 64321 | 69193 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1151 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1994 12:00:00 AM | 8 | Permit Number 33239 | 6008629.33261 | 2117936.9394099996 | 37.79593801218729 | -122.41415513556299 | (37.7959380121873, -122.414155135563) | ||
| 53154 | 53154 | 227957 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 116 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006644.85008 | 2105377.83742 | 37.7613420921909 | -122.42013008553002 | (37.7613420921909, -122.42013008553) | |||
| 91189 | 91189 | 37009 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1160 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 39623 | 6009190.78707009 | 2102400.91082818 | 37.753311244715704 | -122.41111443855101 | (37.7533112447157, -122.411114438551) | ||
| 1594 | 1594 | 4731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | 3x3 | 6007886.219880001 | 2121257.05551 | 37.8050124513131 | -122.416961809043 | (37.8050124513131, -122.416961809043) | |||
| 7655 | 7655 | 4730 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 3x3 | 6007911.57425 | 2121225.41132 | 37.8049269905411 | -122.41687182377 | (37.8049269905411, -122.41687182377) | |||
| 124836 | 124836 | 37755 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1182 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40102 | 6008642.9285748005 | 2101663.94572247 | 37.7512569652384 | -122.41295695053101 | (37.7512569652384, -122.412956950531) | ||
| 136755 | 136755 | 227997 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1183 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5997362.1332 | 2106037.84673 | 37.7626269122233 | -122.452282568209 | (37.7626269122233, -122.452282568209) | |||
| 63959 | 63959 | 227998 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1187 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997369.80314 | 2106003.7248299997 | 37.7625336615227 | -122.45225357855101 | (37.7625336615227, -122.452253578551) | |||
| 126936 | 126936 | 52650 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1187@ RIVOLI Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | Permit Number 48734 | 5997369.46824352 | 2105989.04982963 | 37.7624933485057 | -122.452253677885 | (37.7624933485057, -122.452253677885) | |||
| 113028 | 113028 | 110257 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 116771 | 116771 | 110256 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 142550 | 142550 | 110258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 65932 | 65932 | 227864 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 12 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6004060.23994 | 2102916.80485 | 37.7544387135775 | -122.428893707302 | (37.7544387135775, -122.428893707302) | |||
| 184489 | 184489 | 227863 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 12 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004062.73699 | 2102929.44749 | 37.7544735686269 | -122.42888597313 | (37.7544735686269, -122.42888597313) | |||
| 3859 | 3859 | 23825 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003756.6414 | 2112968.1539 | 37.782020088596504 | -122.43066083333599 | (37.7820200885965, -122.430660833336) | |||
| 5117 | 5117 | 23827 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003747.0158 | 2113043.0957 | 37.7822253147353 | -122.430699482992 | (37.7822253147353, -122.430699482992) | |||
| 6075 | 6075 | 23828 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003742.203 | 2113074.035 | 37.78230999365589 | -122.430718341656 | (37.7823099936559, -122.430718341656) | |||
| 6800 | 6800 | 23823 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003765.5794 | 2112902.15 | 37.781839364726 | -122.430625200646 | (37.781839364726, -122.430625200646) | |||
| 7386 | 7386 | 23826 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003751.8286 | 2113008.0312 | 37.78212930904171 | -122.43068032991002 | (37.7821293090417, -122.43068032991) | |||
| 8699 | 8699 | 23824 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003763.5168 | 2112936.527 | 37.78193363853529 | -122.430634790088 | (37.7819336385353, -122.430634790088) | |||
| 24243 | 24243 | 191114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6014324.849769999 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | |||
| 64112 | 64112 | 191115 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014343.6764 | 2103848.6809400003 | 37.757574136063 | -122.39339585366001 | (37.757574136063, -122.39339585366) | |||
| 149158 | 149158 | 191116 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6014365.71293 | 2103847.64812 | 37.7575725244821 | -122.39331956955 | (37.7575725244821, -122.39331956955) | |||
| 157390 | 157390 | 191113 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014310.15926 | 2103847.10708 | 37.7575679523209 | -122.393511660254 | (37.7575679523209, -122.393511660254) | |||
| 44337 | 44337 | 103160 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||
| 79048 | 79048 | 103163 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 128045 | 128045 | 103161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||||
| 145871 | 145871 | 103166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 74460 | 74460 | 228016 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1208 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998218.953980001 | 2106172.93012 | 37.7630468650329 | -122.449328879841 | (37.7630468650329, -122.449328879841) | |||
| 48455 | 48455 | 227846 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1210 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003824.99851 | 2101233.9622 | 37.749804704938995 | -122.429587222175 | (37.749804704939, -122.429587222175) | |||
| 150146 | 150146 | 245178 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1216 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000704.3825 | 2109304.0037 | 37.7717858689809 | -122.44095728321301 | (37.7717858689809, -122.440957283213) | |||
| 44961 | 44961 | 208090 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994177.92287 | 2090747.0249299998 | 37.720459209606396 | -122.46218652760099 | (37.7204592096064, -122.462186527601) | |||
| 36840 | 36840 | 228015 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1224 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5998227.909 | 2106103.56312 | 37.7628569129495 | -122.44929290966199 | (37.7628569129495, -122.449292909662) | |||
| 84150 | 84150 | 107412 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1227 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997428.0 | 2105607.0 | 37.761447689258 | -122.452023673629 | (37.761447689258, -122.452023673629) | |||||
| 156293 | 156293 | 227999 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1227 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 5997427.0236 | 2105612.47787 | 37.7614626741762 | -122.452027445805 | (37.7614626741762, -122.452027445805) | |||
| 179466 | 179466 | 228000 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1229 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 5997430.92734 | 2105573.7354599996 | 37.761356520915896 | -122.452011149197 | (37.7613565209159, -122.452011149197) | |||
| 66497 | 66497 | 227925 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001796.41757 | 2096593.1915099998 | 37.736947167771795 | -122.436270052841 | (37.7369471677718, -122.436270052841) | |||
| 131248 | 131248 | 227926 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001798.975190001 | 2096621.3956 | 37.737024754984 | -122.43626322786301 | (37.737024754984, -122.436263227863) | |||
| 135828 | 135828 | 227927 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 123 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001800.50314 | 2096635.61515 | 37.7370638853866 | -122.436258962388 | (37.7370638853866, -122.436258962388) | |||
| 114893 | 114893 | 112001 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1230x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997480.0 | 2105522.0 | 37.7612172791461 | -122.451837695923 | (37.7612172791461, -122.451837695923) | ||||
| 116518 | 116518 | 112002 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1230x STANYAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997480.0 | 2105522.0 | 37.7612172791461 | -122.451837695923 | (37.7612172791461, -122.451837695923) | ||||
| 121450 | 121450 | 112003 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1230x STANYAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997480.0 | 2105522.0 | 37.7612172791461 | -122.451837695923 | (37.7612172791461, -122.451837695923) |
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");