Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189129 | 189129 | 182301 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2537 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986893.9274 | 2105029.3143 | 37.7592525025823 | -122.488413720954 | (37.7592525025823, -122.488413720954) | |||
| 189027 | 189027 | 177145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 646 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001109.079969999 | 2090060.7156599998 | 37.718971408083796 | -122.438178657041 | (37.7189714080838, -122.438178657041) | |||
| 188862 | 188862 | 142199 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000263.9441 | 2109999.4219 | 37.7736702167976 | -122.44253072194599 | (37.7736702167976, -122.442530721946) | |||
| 188764 | 188764 | 227739 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1238 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997491.60164 | 2105445.52074 | 37.7610079508779 | -122.451792053664 | (37.7610079508779, -122.451792053664) | |||
| 188692 | 188692 | 227961 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3401 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005587.18256 | 2103705.02041 | 37.7566892787089 | -122.42366917680201 | (37.7566892787089, -122.423669176802) | |||
| 188493 | 188493 | 191514 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012567.22578 | 2112551.0938 | 37.7813701434666 | -122.40015074427099 | (37.7813701434666, -122.400150744271) | |||
| 188394 | 188394 | 208043 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1954 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992271.8581 | 2102134.57412 | 37.751616623007 | -122.469603676282 | (37.751616623007, -122.469603676282) | |||
| 188107 | 188107 | 208154 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 523 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997951.24674 | 2095236.71061 | 37.7330033708131 | -122.449466749514 | (37.7330033708131, -122.449466749514) | ||||
| 187943 | 187943 | 247318 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002751.6889 | 2109356.6539 | 37.7720468252571 | -122.433879285742 | (37.7720468252571, -122.433879285742) | |||
| 187714 | 187714 | 228024 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4977 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997519.34069 | 2105604.1197599997 | 37.7614450124062 | -122.451707557883 | (37.7614450124062, -122.451707557883) | |||
| 187505 | 187505 | 129706 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3248 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5999211.511 | 2115678.78718 | 37.78920423673 | -122.44657992842698 | (37.78920423673, -122.446579928427) | |||
| 187429 | 187429 | 200283 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017069.557019999 | 2097033.93305 | 37.7390133116224 | -122.383494159632 | (37.7390133116224, -122.383494159632) | |||
| 187394 | 187394 | 227947 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009924.719330001 | 2103404.59086 | 37.7561082572986 | -122.40864713697901 | (37.7561082572986, -122.408647136979) | |||
| 187258 | 187258 | 191132 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 853 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012171.3747 | 2104414.8785 | 37.759007857755 | -122.400948379065 | (37.759007857755, -122.400948379065) | |||
| 187164 | 187164 | 227916 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999889.55267 | 2106936.18055 | 37.7652379786836 | -122.44360569865299 | (37.7652379786836, -122.443605698653) | |||
| 187159 | 187159 | 208135 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 15x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993326.71612 | 2100337.0457 | 37.7467419791719 | -122.465825280839 | (37.7467419791719, -122.465825280839) | |||
| 186967 | 186967 | 246066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999949.17 | 2108444.1555 | 37.7693819003429 | -122.443507828871 | (37.7693819003429, -122.443507828871) | |||
| 186783 | 186783 | 208098 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991684.149119999 | 2099849.94635 | 37.74530964152321 | -122.471469573465 | (37.7453096415232, -122.471469573465) | |||
| 186620 | 186620 | 191136 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6015849.43406 | 2099722.2269099997 | 37.7463273035772 | -122.387900356534 | (37.7463273035772, -122.387900356534) | ||||
| 186002 | 186002 | 227800 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997468.87753 | 2105248.92719 | 37.760466853092396 | -122.4518564631 | (37.7604668530924, -122.4518564631) | |||
| 186000 | 186000 | 227717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 810 Clayton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998661.93056 | 2107540.16812 | 37.7668262848355 | -122.447895221086 | (37.7668262848355, -122.447895221086) | |||
| 185713 | 185713 | 70681 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 366 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 9 | 6010590.1917 | 2106606.8545 | 37.7649382022496 | -122.406571346991 | (37.7649382022496, -122.406571346991) | ||
| 185632 | 185632 | 227794 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5997230.41248 | 2106977.41048 | 37.7651991684211 | -122.45280595835399 | (37.7651991684211, -122.452805958354) | |||
| 185559 | 185559 | 227814 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 175 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007586.8611 | 2097826.9970400003 | 37.740662225776504 | -122.416337219986 | (37.7406622257765, -122.416337219986) | |||
| 185438 | 185438 | 129683 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3301 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5999811.38198 | 2119884.1742 | 37.8007853625219 | -122.444806866442 | (37.8007853625219, -122.444806866442) | |||
| 185336 | 185336 | 227730 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1044 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997692.15164 | 2106891.22645 | 37.7649889770905 | -122.451202705446 | (37.7649889770905, -122.451202705446) | |||
| 184855 | 184855 | 191125 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012379.91168 | 2103993.92822 | 37.7578636511905 | -122.400197590856 | (37.7578636511905, -122.400197590856) | |||
| 184736 | 184736 | 227989 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 419 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003146.12885 | 2099470.64592 | 37.744924588703604 | -122.431808894759 | (37.7449245887036, -122.431808894759) | |||
| 184721 | 184721 | 101219 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012016.9704 | 2106218.6671 | 37.7639520461846 | -122.401609164037 | (37.7639520461846, -122.401609164037) | |||
| 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) | |||
| 184480 | 184480 | 227779 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 580 Eureka St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001536.070230001 | 2102382.39018 | 37.752828144727296 | -122.437584653928 | (37.7528281447273, -122.437584653928) | |||
| 184303 | 184303 | 191520 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1099 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015569.63455 | 2103986.90153 | 37.7580216980478 | -122.389165608225 | (37.7580216980478, -122.389165608225) | |||
| 184300 | 184300 | 227789 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003244.21071 | 2096170.02845 | 37.7358674129555 | -122.43123419382201 | (37.7358674129555, -122.431234193822) | |||
| 184251 | 184251 | 140383 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1401 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003196.4724 | 2113126.1683 | 37.782422205359104 | -122.432610051145 | (37.7824222053591, -122.432610051145) | |||
| 184247 | 184247 | 227829 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 330 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008104.996669999 | 2096968.11505 | 37.7383330473413 | -122.41448493944999 | (37.7383330473413, -122.41448493945) | |||
| 184120 | 184120 | 191139 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 763 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011643.5293 | 2113893.61304 | 37.7850048407399 | -122.403440779973 | (37.7850048407399, -122.403440779973) | |||
| 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) | |||
| 183593 | 183593 | 116264 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6001382.9491 | 2114260.8581 | 37.7854347614906 | -122.4389653769 | (37.7854347614906, -122.4389653769) | |||
| 183591 | 183591 | 246071 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 Central Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999960.6775 | 2108354.2152 | 37.769135603145706 | -122.44346156363399 | (37.7691356031457, -122.443461563634) | |||
| 183578 | 183578 | 227946 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2368 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6009653.02559 | 2103553.74233 | 37.756502573159 | -122.40959727609501 | (37.756502573159, -122.409597276095) | |||
| 183264 | 183264 | 121707 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6014418.633880001 | 2103271.30813 | 37.755992958831705 | -122.393096220215 | (37.7559929588317, -122.393096220215) | ||||
| 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) | |||
| 182976 | 182976 | 227963 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 90 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005370.370519999 | 2103212.80554 | 37.7553255305724 | -122.42438398405899 | (37.7553255305724, -122.424383984059) | |||
| 182930 | 182930 | 227721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 918 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998766.13277 | 2106812.06725 | 37.764833058920495 | -122.44748239 | (37.7648330589205, -122.44748239) | |||
| 182700 | 182700 | 227712 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 35 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998426.53585 | 2106550.1272400003 | 37.764094425039794 | -122.448638096177 | (37.7640944250398, -122.448638096177) | |||
| 182016 | 182016 | 79734 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 278 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 9 | 6011401.4545599995 | 2111396.60649 | 37.7781351201838 | -122.404102493055 | (37.7781351201838, -122.404102493055) | ||
| 181716 | 181716 | 227844 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 870 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003075.387490001 | 2103155.88804 | 37.7550393860631 | -122.43231665379601 | (37.7550393860631, -122.432316653796) | |||
| 181542 | 181542 | 200281 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017058.90214 | 2097021.55085 | 37.7389787236965 | -122.38353013790702 | (37.7389787236965, -122.383530137907) | |||
| 181488 | 181488 | 138661 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001335.1269 | 2114544.7059 | 37.7862114136354 | -122.43915117832199 | (37.7862114136354, -122.439151178322) | |||
| 181311 | 181311 | 227860 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004105.0319300005 | 2102887.37623 | 37.7543604446946 | -122.42873670723499 | (37.7543604446946, -122.428736707235) | |||
| 181212 | 181212 | 129699 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6000522.034519999 | 2116191.05959 | 37.7906855730291 | -122.442082476442 | (37.7906855730291, -122.442082476442) | |||
| 181130 | 181130 | 191134 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2200 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010446.9321 | 2107891.83414 | 37.7684584473369 | -122.407157433385 | (37.7684584473369, -122.407157433385) | |||
| 181104 | 181104 | 227905 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbin Pl | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000059.13401 | 2105667.04747 | 37.7617629245349 | -122.442928012733 | (37.7617629245349, -122.442928012733) | |||
| 181051 | 181051 | 246069 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 5 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999956.4379 | 2108386.6179 | 37.769224331039 | -122.44347855599301 | (37.769224331039, -122.443478555993) | |||
| 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) | |||
| 180898 | 180898 | 227893 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003803.161309999 | 2108272.90307 | 37.7691307220413 | -122.430164832458 | (37.7691307220413, -122.430164832458) | |||
| 180850 | 180850 | 208057 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992245.259459999 | 2101079.6682 | 37.7487185865149 | -122.46961886943599 | (37.7487185865149, -122.469618869436) | |||
| 180818 | 180818 | 208044 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992692.13842 | 2098948.0132400002 | 37.7428914239144 | -122.467918553594 | (37.7428914239144, -122.467918553594) | |||
| 180813 | 180813 | 227843 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 752 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001510.70701 | 2102061.19954 | 37.7519447901408 | -122.437649363754 | (37.7519447901408, -122.437649363754) | |||
| 180779 | 180779 | 191121 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 209 Mississippi St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014043.01019 | 2106106.8395700003 | 37.7637578384722 | -122.394593812648 | (37.7637578384722, -122.394593812648) | |||
| 180624 | 180624 | 208155 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 523 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5997950.371590001 | 2095226.7551900002 | 37.7329759855362 | -122.449469058051 | (37.7329759855362, -122.449469058051) | ||||
| 180241 | 180241 | 200262 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009387.05751 | 2110614.20287 | 37.7758740662749 | -122.411015772257 | (37.7758740662749, -122.411015772257) | |||
| 180211 | 180211 | 140277 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2064 Hayes St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997990.6776 | 2109965.9876 | 37.773448573595296 | -122.45039185353599 | (37.7734485735953, -122.450391853536) | |||
| 180131 | 180131 | 43801 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 525 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43431 | 5988746.62136 | 2111728.0872299997 | 37.777753417998206 | -122.48249713450899 | (37.7777534179982, -122.482497134509) | |
| 180126 | 180126 | 58243 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1074 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 16 | Permit Number 19008 | 6015506.93589 | 2104104.58893 | 37.758341366580204 | -122.38939066713999 | (37.7583413665802, -122.38939066714) | ||
| 179943 | 179943 | 208052 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 San Benito Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992910.68234 | 2095197.7097 | 37.732606649283106 | -122.466890318243 | (37.7326066492831, -122.466890318243) | |||
| 179894 | 179894 | 208025 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1652 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5993735.965559999 | 2104244.11909 | 37.7574934012238 | -122.464693817688 | (37.7574934012238, -122.464693817688) | |||
| 179852 | 179852 | 71574 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 970 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1995 12:00:00 AM | 10 | 6015483.05138 | 2104523.27151 | 37.759489655143 | -122.389502510438 | (37.759489655143, -122.389502510438) | ||
| 179606 | 179606 | 142190 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000475.0555 | 2110262.6596 | 37.774405032375604 | -122.441819353615 | (37.7744050323756, -122.441819353615) | |||
| 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) | |||
| 179600 | 179600 | 227967 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1521 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008757.48735 | 2099882.37849 | 37.7463716086597 | -122.41243487546998 | (37.7463716086597, -122.41243487547) | |||
| 179593 | 179593 | 140477 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1299 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003269.6358 | 2112623.4327 | 37.781045968224795 | -122.43232102145201 | (37.7810459682248, -122.432321021452) | |||
| 179520 | 179520 | 140602 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700x WEBSTER ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003984.6897 | 2111298.7883 | 37.7774493417916 | -122.429752786414 | (37.7774493417916, -122.429752786414) | |||
| 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) | |||
| 179260 | 179260 | 140378 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1405 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003179.4968 | 2113257.9784 | 37.782783160075 | -122.432678197788 | (37.782783160075, -122.432678197788) | |||
| 178986 | 178986 | 191122 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 240 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6013995.5302099995 | 2105883.52142 | 37.7631420160238 | -122.394742392343 | (37.7631420160238, -122.394742392343) | |||
| 178877 | 178877 | 59611 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1053 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 11 | Permit Number 19013 | 6015558.09296 | 2104209.88833 | 37.758633332376704 | -122.389221094589 | (37.7586333323767, -122.389221094589) | ||
| 178697 | 178697 | 191124 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012423.59359 | 2105049.6302900002 | 37.760764811978 | -122.400120660154 | (37.760764811978, -122.400120660154) | |||
| 178527 | 178527 | 129720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006876.11825 | 2120468.72973 | 37.802791038628705 | -122.42040139843 | (37.8027910386287, -122.42040139843) | |||
| 178469 | 178469 | 129721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006892.13335 | 2120470.8795 | 37.8027978438157 | -122.420346130572 | (37.8027978438157, -122.420346130572) | |||
| 178460 | 178460 | 142198 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000271.762999999 | 2109964.8883 | 37.7735758419466 | -122.442501195383 | (37.7735758419466, -122.442501195383) | |||
| 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) | |||
| 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) | |||
| 178306 | 178306 | 227734 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1254 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5997512.1218 | 2105315.9669 | 37.7606534039507 | -122.451711737929 | (37.7606534039507, -122.451711737929) | |||
| 178240 | 178240 | 228005 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1051 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998115.625990001 | 2106592.03461 | 37.7641917091996 | -122.44971645795401 | (37.7641917091996, -122.449716457954) | |||
| 178079 | 178079 | 122999 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 42 07th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5993659.38134 | 2115213.58534 | 37.787608218531794 | -122.46575564845699 | (37.7876082185318, -122.465755648457) | |||
| 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) | |||
| 177856 | 177856 | 121713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014428.12864 | 2103144.99804 | 37.755646665865605 | -122.39305454654499 | (37.7556466658656, -122.393054546545) | ||||
| 177803 | 177803 | 227783 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Worth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 6000861.52654 | 2103067.6121400003 | 37.754671223414604 | -122.43996647237302 | (37.7546712234146, -122.439966472373) | |||
| 177683 | 177683 | 121712 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6014424.3017 | 2103198.95123 | 37.755794597164396 | -122.393071556308 | (37.7557945971644, -122.393071556308) | ||||
| 177633 | 177633 | 227850 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3945 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003516.46145 | 2101835.6997 | 37.751439460175206 | -122.4306970908 | (37.7514394601752, -122.4306970908) | |||
| 177357 | 177357 | 227792 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 234 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004387.52295 | 2097025.09932 | 37.7382799693533 | -122.427342203202 | (37.7382799693533, -122.427342203202) | |||
| 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) | |||
| 177285 | 177285 | 200285 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017066.92688 | 2097055.31943 | 37.739071888953795 | -122.38350474196699 | (37.7390718889538, -122.383504741967) | |||
| 177208 | 177208 | 129711 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2015 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6004372.94608 | 2117332.24552 | 37.7940376826321 | -122.428839917937 | (37.7940376826321, -122.428839917937) | |||
| 177185 | 177185 | 200277 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017033.1973 | 2097041.97927 | 37.7390333952753 | -122.38362043613 | (37.7390333952753, -122.38362043613) | |||
| 177163 | 177163 | 129741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012363.448469999 | 2119674.7409900003 | 37.80091862944111 | -122.40135648692 | (37.8009186294411, -122.40135648692) | |||
| 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) | |||
| 177100 | 177100 | 191131 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 863 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012174.34155 | 2104398.8086099997 | 37.758963898878996 | -122.400936989166 | (37.758963898879, -122.400936989166) | |||
| 177099 | 177099 | 248491 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 761 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998570.692000001 | 2107873.0198 | 37.767734995757706 | -122.44823476937701 | (37.7677349957577, -122.448234769377) |
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");