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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172704 | 172704 | 208038 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993764.599359999 | 2103288.67174 | 37.754871640034 | -122.46452541781 | (37.754871640034, -122.46452541781) | |||
41944 | 41944 | 208039 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993764.89188 | 2103262.79505 | 37.7548006061648 | -122.464522527406 | (37.7548006061648, -122.464522527406) | |||
41985 | 41985 | 208040 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993765.03944 | 2103252.9034 | 37.7547734547454 | -122.464521298918 | (37.7547734547454, -122.464521298918) | |||
157634 | 157634 | 208041 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993766.80604 | 2103235.31839 | 37.7547252726705 | -122.46451391281299 | (37.7547252726705, -122.464513912813) | |||
178319 | 178319 | 208042 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993767.09464 | 2103220.25366 | 37.7546839254342 | -122.464511820986 | (37.7546839254342, -122.464511820986) | |||
79221 | 79221 | 50462 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
82830 | 82830 | 50459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
94029 | 94029 | 50463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
127573 | 127573 | 50460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
142581 | 142581 | 50461 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
144848 | 144848 | 50458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
167670 | 167670 | 208127 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1980 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5993803.248930001 | 2102010.84689 | 37.7513652885894 | -122.46429899101801 | (37.7513652885894, -122.464298991018) | |||
167552 | 167552 | 208137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5993786.87978 | 2100730.78266 | 37.7478496147728 | -122.464262673683 | (37.7478496147728, -122.464262673683) | |||
175402 | 175402 | 208063 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 459 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5993844.11289 | 2101701.56795 | 37.750518442888705 | -122.464135229877 | (37.7505184428887, -122.464135229877) | |||
26653 | 26653 | 208094 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993960.310959999 | 2106767.61522 | 37.7644351970401 | -122.46410113478001 | (37.7644351970401, -122.46410113478) | |||
140108 | 140108 | 103137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993979.5 | 2106772.5 | 37.7644497152943 | -122.46403512031799 | (37.7644497152943, -122.464035120318) | ||||
130428 | 130428 | 59095 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 671 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18396 | 5994079.76607 | 2110941.26812 | 37.775901829120606 | -122.463990963797 | (37.7759018291206, -122.463990963797) | ||
75949 | 75949 | 208138 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Santa Rita Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5993885.92048 | 2100911.41075 | 37.748351281781 | -122.463933307785 | (37.748351281781, -122.463933307785) | |||
160043 | 160043 | 218388 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 50 San Marcos Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5993887.93086 | 2100247.90665 | 37.7465295835701 | -122.463878201824 | (37.7465295835701, -122.463878201824) | |||
34733 | 34733 | 208139 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Santa Rita Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5993922.554140001 | 2100955.0265200003 | 37.7484731507208 | -122.463809795788 | (37.7484731507208, -122.463809795788) | |||
155699 | 155699 | 218390 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 285 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5993922.82192 | 2100262.91397 | 37.7465728005083 | -122.46375864234899 | (37.7465728005083, -122.463758642349) | |||
89614 | 89614 | 123551 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 69 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994236.53379 | 2115140.07553 | 37.787439655324896 | -122.463753492359 | (37.7874396553249, -122.463753492359) | |||
177104 | 177104 | 218391 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 285 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5993948.050340001 | 2100272.5498200003 | 37.746600711853205 | -122.463672105083 | (37.7466007118532, -122.463672105083) | |||
156870 | 156870 | 208134 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 55 Linares Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993988.16475 | 2102163.97452 | 37.7517963948082 | -122.463670648202 | (37.7517963948082, -122.463670648202) | |||
32656 | 32656 | 123589 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 32 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994275.31768 | 2115360.29886 | 37.7880465633309 | -122.463635298323 | (37.7880465633309, -122.463635298323) | |||
63460 | 63460 | 208133 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 55 Linares Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994003.63439 | 2102147.0151299997 | 37.751750720028205 | -122.463615921765 | (37.7517507200282, -122.463615921765) | |||
34010 | 34010 | 123582 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5994285.08275 | 2115071.4711700003 | 37.7872540838992 | -122.463580543309 | (37.7872540838992, -122.463580543309) | |||
180981 | 180981 | 123583 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994285.44541 | 2115062.1508 | 37.7872285135982 | -122.46357861191002 | (37.7872285135982, -122.46357861191) | |||
106871 | 106871 | 59867 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1981 12:00:00 AM | 10 | Permit Number 19326 | 5994285.52331 | 2115052.43823 | 37.7872018500152 | -122.463577637239 | (37.7872018500152, -122.463577637239) | ||
72982 | 72982 | 208132 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 55 Linares Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994015.17426 | 2102138.30951 | 37.751727481539604 | -122.46357538391001 | (37.7517274815396, -122.46357538391) | |||
32066 | 32066 | 208129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 14 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994035.372909999 | 2102011.52015 | 37.751380514111396 | -122.463496334396 | (37.7513805141114, -122.463496334396) | |||
146442 | 146442 | 208131 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 55 Linares Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994041.4329 | 2102104.78116 | 37.7516369342059 | -122.463482145784 | (37.7516369342059, -122.463482145784) | |||
135917 | 135917 | 208130 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5994048.17405 | 2102062.9067599997 | 37.7515223461842 | -122.46345579566099 | (37.7515223461842, -122.463455795661) | |||
30431 | 30431 | 208020 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1285 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994218.151430001 | 2106814.05581 | 37.7645775678277 | -122.463212712505 | (37.7645775678277, -122.463212712505) | |||
24703 | 24703 | 208140 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994042.19484 | 2092647.64079 | 37.7256700254358 | -122.462793502527 | (37.7256700254358, -122.462793502527) | |||
148025 | 148025 | 208128 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994282.9508 | 2101575.2771099997 | 37.7501969631249 | -122.462608546171 | (37.7501969631249, -122.462608546171) | |||
50522 | 50522 | 31991 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 215 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35392 | 5994587.26751 | 2113998.16217 | 37.784324475145795 | -122.462457175798 | (37.7843244751458, -122.462457175798) | |
172116 | 172116 | 208079 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 370 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994204.7092699995 | 2092293.8325900002 | 37.7247079127335 | -122.462206059069 | (37.7247079127335, -122.462206059069) | |||
135648 | 135648 | 208078 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994204.15445 | 2092252.12785 | 37.7245933696677 | -122.462204953795 | (37.7245933696677, -122.462204953795) | |||
129182 | 129182 | 62460 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 360 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1985 12:00:00 AM | Permit Number 22628 | 5994209.59395504 | 2092281.24653849 | 37.724673635737 | -122.46218826108101 | (37.724673635737, -122.462188261081) | |||
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) | |||
68862 | 68862 | 208093 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1262 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994573.02345 | 2106902.75125 | 37.7648415395259 | -122.461991747019 | (37.7648415395259, -122.461991747019) | |||
50632 | 50632 | 208065 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 235 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5994449.77739 | 2100350.4958099998 | 37.7468436295384 | -122.461942849988 | (37.7468436295384, -122.461942849988) | |||
130752 | 130752 | 208064 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 275 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5994455.63892 | 2100507.88466 | 37.7472761170959 | -122.461933992563 | (37.7472761170959, -122.461933992563) | |||
31533 | 31533 | 43679 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 540 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 6 | Permit Number 43322 | 5994712.920030001 | 2111843.24303 | 37.7784148808037 | -122.461866155284 | (37.7784148808037, -122.461866155284) | |
90213 | 90213 | 100247 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
129288 | 129288 | 100248 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/31/2012 12:00:00 AM | Permit Number 768792 | 5994535.8 | 2101777.0 | 37.750765401507 | -122.461748809074 | (37.750765401507, -122.461748809074) | |||
32758 | 32758 | 208066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5994517.25257 | 2100489.12784 | 37.7472281625491 | -122.46171957892099 | (37.7472281625491, -122.461719578921) | |||
183642 | 183642 | 208067 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5994528.34567 | 2100501.93042 | 37.7472639537695 | -122.461682148211 | (37.7472639537695, -122.461682148211) | |||
76885 | 76885 | 208068 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5994541.71354 | 2100515.18677 | 37.7473011218565 | -122.461636884428 | (37.7473011218565, -122.461636884428) | |||
134840 | 134840 | 59231 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 732 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1980 12:00:00 AM | 14 | Permit Number 18553 | 5994760.56149 | 2110552.22329 | 37.7748728265586 | -122.46160772076401 | (37.7748728265586, -122.461607720764) | ||
167817 | 167817 | 208069 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5994554.01203 | 2100525.45715 | 37.7473300296505 | -122.461595101959 | (37.7473300296505, -122.461595101959) | |||
154610 | 154610 | 208070 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Marcela Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5994562.006580001 | 2100534.56463 | 37.7473554966651 | -122.461568117774 | (37.7473554966651, -122.461568117774) | |||
43375 | 43375 | 208071 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5994586.62981 | 2100556.35867 | 37.74741675489079 | -122.46148455276399 | (37.7474167548908, -122.461484552764) | |||
152212 | 152212 | 208113 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 293 Magellan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994585.68235 | 2100211.44576 | 37.7464696563432 | -122.461462827849 | (37.7464696563432, -122.461462827849) | |||
162236 | 162236 | 208114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 289 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994607.46337 | 2100232.24442 | 37.74652801785779 | -122.461389019583 | (37.7465280178578, -122.461389019583) | |||
75826 | 75826 | 208118 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 907 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994500.10104 | 2094002.40377 | 37.7294162386642 | -122.461308732617 | (37.7294162386642, -122.461308732617) | |||
166578 | 166578 | 208119 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 915 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994530.86611 | 2094005.87306 | 37.7294275350513 | -122.461202626994 | (37.7294275350513, -122.461202626994) | |||
55067 | 55067 | 208055 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 920 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5994534.77621 | 2093970.7327700001 | 37.729331273397705 | -122.46118656331998 | (37.7293312733977, -122.46118656332) | |||
173727 | 173727 | 208120 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 925 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994563.96243 | 2094007.92247 | 37.7294350668528 | -122.461088359166 | (37.7294350668528, -122.461088359166) | |||
27768 | 27768 | 208072 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 48 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994750.66862 | 2100768.2505900003 | 37.7480079970652 | -122.460932676625 | (37.7480079970652, -122.460932676625) | |||
37037 | 37037 | 208121 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994733.18466 | 2099795.5260099997 | 37.745336133767296 | -122.46092264556499 | (37.7453361337673, -122.460922645565) | |||
161652 | 161652 | 208092 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1258 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994884.89694 | 2106931.75767 | 37.764939133955295 | -122.4609151668 | (37.7649391339553, -122.4609151668) | |||
173917 | 173917 | 208122 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994754.50081 | 2099786.0148400003 | 37.7453112450104 | -122.46084824916299 | (37.7453112450104, -122.460848249163) | |||
179602 | 179602 | 208091 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 247 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994538.89775 | 2088695.72634 | 37.714847610008 | -122.46079017812599 | (37.714847610008, -122.460790178126) | |||
172372 | 172372 | 208123 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994792.79131 | 2099776.97175 | 37.7452886180713 | -122.460715192672 | (37.7452886180713, -122.460715192672) | |||
51173 | 51173 | 208115 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 245 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994810.59334 | 2100418.8909400003 | 37.747052191323796 | -122.460700146993 | (37.7470521913238, -122.460700146993) | |||
153459 | 153459 | 208124 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994815.96906 | 2099777.31016 | 37.7452908807659 | -122.46063507296199 | (37.7452908807659, -122.460635072962) | |||
27923 | 27923 | 208116 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994839.35424 | 2100452.13911 | 37.747145137147704 | -122.460603103876 | (37.7471451371477, -122.460603103876) | |||
177311 | 177311 | 208125 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994834.63211 | 2099779.39133 | 37.7452976688552 | -122.46057069048099 | (37.7452976688552, -122.460570690481) | |||
73080 | 73080 | 208074 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994748.8803900005 | 2095031.81828 | 37.732257074696705 | -122.460523248557 | (37.7322570746967, -122.460523248557) | |||
132638 | 132638 | 208126 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994854.63064 | 2099785.9766 | 37.7453169008687 | -122.460502016464 | (37.7453169008687, -122.460502016464) | |||
134696 | 134696 | 208073 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5994756.9312 | 2095079.7197900002 | 37.732389063688395 | -122.46049888501999 | (37.7323890636884, -122.46049888502) | |||
92315 | 92315 | 52824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 301FERNWOOD Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48849 | 5994767.16572707 | 2095140.66542727 | 37.732556994280706 | -122.46046791665701 | (37.7325569942807, -122.460467916657) | ||||
173095 | 173095 | 208117 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 210 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994935.49087 | 2100588.28306 | 37.7475244846715 | -122.460280535917 | (37.7475244846715, -122.460280535917) | |||
94901 | 94901 | 53018 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 210@ SOLA AVE Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 48998 | 5994944.05105454 | 2100605.63053534 | 37.747572608877 | -122.460252192206 | (37.747572608877, -122.460252192206) | |||
88085 | 88085 | 35688 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38992 | 5994858.93773428 | 2095456.23739151 | 37.7334287567384 | -122.460173495672 | (37.7334287567384, -122.460173495672) | |||
153369 | 153369 | 208143 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5995206.3178199995 | 2099507.68118 | 37.7445729969391 | -122.459265799394 | (37.7445729969391, -122.459265799394) | |||
147210 | 147210 | 208142 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.6173 | 2099521.98382 | 37.7446122856405 | -122.459265799391 | (37.7446122856405, -122.459265799391) | |||
147806 | 147806 | 208146 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995205.6435 | 2099446.88271 | 37.7444060207274 | -122.45926372915001 | (37.7444060207274, -122.45926372915) | |||
27892 | 27892 | 208144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.64176 | 2099494.55804 | 37.7445369826924 | -122.459263729149 | (37.7445369826924, -122.459263729149) | |||
60172 | 60172 | 208141 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5995208.500519999 | 2099554.73561 | 37.7447023221602 | -122.459261658906 | (37.7447023221602, -122.459261658906) | |||
64151 | 64151 | 208145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 5995207.23946 | 2099465.92772 | 37.7444584053336 | -122.459259589568 | (37.7444584053336, -122.459259589568) | |||
178440 | 178440 | 123473 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 625 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995601.020219999 | 2111940.74017 | 37.7787336686397 | -122.458800964288 | (37.7787336686397, -122.458800964288) | |||
46423 | 46423 | 45764 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3954 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44411 | 5995797.28433 | 2115532.1043599998 | 37.788605873462 | -122.45838203677799 | (37.788605873462, -122.458382036778) | ||
65171 | 65171 | 45763 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3954 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44411 | 5995817.4754 | 2115534.8475099998 | 37.7886145656939 | -122.45831237779 | (37.7886145656939, -122.45831237779) | ||
158292 | 158292 | 124632 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 725 Euclid Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5996054.27356 | 2113786.59674 | 37.7838279424009 | -122.457366568591 | (37.7838279424009, -122.457366568591) | |||
31872 | 31872 | 124631 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 725 Euclid Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5996077.92539 | 2113787.58101 | 37.783832003391296 | -122.45728481381501 | (37.7838320033913, -122.457284813815) | |||
130687 | 130687 | 38879 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40702 | 5996216.25426 | 2115095.08483 | 37.7874300029464 | -122.456900851289 | (37.7874300029464, -122.456900851289) | |
45277 | 45277 | 208077 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 338 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995744.67706 | 2091237.28528 | 37.7218954350055 | -122.456806235434 | (37.7218954350055, -122.456806235434) | |||
157651 | 157651 | 217741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 683 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5996265.43539 | 2107251.80334 | 37.7658972375023 | -122.45616340274599 | (37.7658972375023, -122.456163402746) | |||
63797 | 63797 | 217744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 641 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 5996399.257130001 | 2107269.94525 | 37.765954731152895 | -122.455701855365 | (37.7659547311529, -122.455701855365) | |||
176674 | 176674 | 31878 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3740 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35316 | 5996936.65811 | 2115356.47325 | 37.7881890469296 | -122.454427304671 | (37.7881890469296, -122.454427304671) | ||
169158 | 169158 | 38901 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 164 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40715 | 5996940.8515 | 2113271.4959 | 37.7824644937943 | -122.45426213802 | (37.7824644937943, -122.45426213802) | |
159745 | 159745 | 69952 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 565 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 8 | 5997087.15611 | 2114145.30542 | 37.7848721322932 | -122.453819112066 | (37.7848721322932, -122.453819112066) | ||
42124 | 42124 | 141441 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2920 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997035.9754 | 2111593.694 | 37.77786314542929 | -122.45381185366301 | (37.7778631454293, -122.453811853663) | |||
150212 | 150212 | 141454 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2920 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997043.7716 | 2111595.4265 | 37.7778683493908 | -122.45378500917101 | (37.7778683493908, -122.453785009171) | |||
73021 | 73021 | 227798 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 5997129.95127 | 2106058.68083 | 37.762670813522604 | -122.453087101682 | (37.7626708135226, -122.453087101682) | |||
160654 | 160654 | 227797 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 78 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5997131.78555 | 2106048.44481 | 37.762642813136 | -122.453080018655 | (37.762642813136, -122.453080018655) | |||
93583 | 93583 | 58647 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 840 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17869 | 5997188.31162677 | 2107608.64597093 | 37.7669299671715 | -122.45299714312 | (37.7669299671715, -122.45299714312) |
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");