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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25607 | 25607 | 227742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1232 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997482.84112 | 2105527.7140599997 | 37.761233131234896 | -122.451828281975 | (37.7612331312349, -122.451828281975) | |||
| 40568 | 40568 | 227743 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1232 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997480.00415 | 2105547.5565400003 | 37.7612874511878 | -122.4518395253 | (37.7612874511878, -122.4518395253) | |||
| 159842 | 159842 | 227744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1232 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997475.21829 | 2105577.8706 | 37.7613704118299 | -122.45185826446199 | (37.7613704118299, -122.451858264462) | |||
| 36435 | 36435 | 227741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1234 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997486.846 | 2105477.27302 | 37.7610948622513 | -122.451810791941 | (37.7610948622513, -122.451810791941) | |||
| 150467 | 150467 | 227806 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1235 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997433.43236 | 2105521.01823 | 37.7612119162092 | -122.45199868191901 | (37.7612119162092, -122.451998681919) | |||
| 77149 | 77149 | 228014 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1236 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998231.861819999 | 2106073.6543400004 | 37.7627750170686 | -122.44927708336901 | (37.7627750170686, -122.449277083369) | |||
| 167202 | 167202 | 227740 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1238 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5997488.32113 | 2105461.41587 | 37.761051407006796 | -122.45180454616501 | (37.7610514070068, -122.451804546165) | |||
| 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) | |||
| 159409 | 159409 | 227738 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1240 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997494.2501 | 2105433.9553400003 | 37.7609763468939 | -122.451782059502 | (37.7609763468939, -122.451782059502) | |||
| 162310 | 162310 | 228010 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1241 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998195.31145 | 2106018.04873 | 37.7626202473408 | -122.449399490988 | (37.7626202473408, -122.449399490988) | |||
| 58045 | 58045 | 227805 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1245 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997449.679930001 | 2105419.4002900003 | 37.760933829642894 | -122.45193515737499 | (37.7609338296429, -122.451935157375) | |||
| 164909 | 164909 | 227737 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1246 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997502.45152 | 2105394.21767 | 37.7608677069951 | -122.451750827852 | (37.7608677069951, -122.451750827852) | |||
| 162687 | 162687 | 227804 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1247 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5997450.82299 | 2105395.3535599997 | 37.760867868864395 | -122.451929469171 | (37.7608678688644, -122.451929469171) | |||
| 38283 | 38283 | 227736 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1248 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997502.04655 | 2105374.80245 | 37.7608143745065 | -122.45175082785101 | (37.7608143745065, -122.451750827851) | |||
| 71904 | 71904 | 227791 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 125 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003492.804819999 | 2096117.76895 | 37.7357380050008 | -122.430370978657 | (37.7357380050008, -122.430370978657) | |||
| 147972 | 147972 | 227735 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1250 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5997506.65894 | 2105353.48409 | 37.7607561038274 | -122.45173333784099 | (37.7607561038274, -122.451733337841) | |||
| 59603 | 59603 | 227803 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1253 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5997459.417780001 | 2105347.40102 | 37.7607366955736 | -122.45189628420601 | (37.7607366955736, -122.451896284206) | |||
| 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) | |||
| 129788 | 129788 | 227802 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1255 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997461.62204 | 2105334.79743 | 37.760702215547205 | -122.451887751416 | (37.7607022155472, -122.451887751416) | |||
| 128281 | 128281 | 69079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33087 | 5992094.79631072 | 2106892.73003089 | 37.764671035074 | -122.470562489037 | (37.764671035074, -122.470562489037) | |
| 167306 | 167306 | 208019 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992092.96115 | 2106864.9565 | 37.7645946702215 | -122.470566813326 | (37.7645946702215, -122.470566813326) | |||
| 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) | |||
| 57431 | 57431 | 227733 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1260 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997517.10872 | 2105267.26195 | 37.760519958043 | -122.451690977075 | (37.760519958043, -122.451690977075) | |||
| 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) | |||
| 167580 | 167580 | 227732 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1262 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997519.63349 | 2105248.18161 | 37.7604677128334 | -122.45168086870301 | (37.7604677128334, -122.451680868703) | |||
| 89930 | 89930 | 114515 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5997459.0 | 2105253.0 | 37.7604774702611 | -122.451890918585 | (37.7604774702611, -122.451890918585) | ||||
| 96758 | 96758 | 114514 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5997459.0 | 2105253.0 | 37.7604774702611 | -122.451890918585 | (37.7604774702611, -122.451890918585) | ||||
| 45933 | 45933 | 227801 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5997468.36846 | 2105263.95223 | 37.7605080789056 | -122.451859307684 | (37.7605080789056, -122.451859307684) | |||
| 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) | |||
| 61185 | 61185 | 142086 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001773.8514 | 2110797.0501 | 37.7759462550936 | -122.43736485566299 | (37.7759462550936, -122.437364855663) | |||
| 23901 | 23901 | 55472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 2 | Permit Number 24549 | 6001757.1677 | 2110793.9605 | 37.7759368233505 | -122.437422347525 | (37.7759368233505, -122.437422347525) | |
| 113473 | 113473 | 114516 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5997462.0 | 2105228.0 | 37.7604089983939 | -122.451878739419 | (37.7604089983939, -122.451878739419) | ||||
| 136347 | 136347 | 227799 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1265 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 6ft | 5997473.24622 | 2105221.8097 | 37.760392645519 | -122.45183939756599 | (37.760392645519, -122.451839397566) | |||
| 165175 | 165175 | 227731 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1266 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5997522.1994900005 | 2105232.66102 | 37.7604252441598 | -122.451670874538 | (37.7604252441598, -122.451670874538) | |||
| 39989 | 39989 | 227790 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 127 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003497.77442 | 2096110.61078 | 37.735718631796395 | -122.430353286268 | (37.7357186317964, -122.430353286268) | |||
| 53171 | 53171 | 85317 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | ||||
| 112317 | 112317 | 85318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2007 12:00:00 AM | Permit Number 49596 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | |||
| 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) | ||||
| 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) | |||
| 126155 | 126155 | 116878 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 129 HENRY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5x5 | 6002678.0 | 2107362.0 | 37.766565813604295 | -122.43399157531401 | (37.7665658136043, -122.433991575314) | |||
| 36287 | 36287 | 227888 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 129 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002659.7336 | 2107360.61662 | 37.7665609785316 | -122.434054656597 | (37.7665609785316, -122.434054656597) | |||
| 137505 | 137505 | 140480 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1299 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003282.5124 | 2112534.0115 | 37.780801170096005 | -122.43227008675 | (37.780801170096, -122.43227008675) | |||
| 147776 | 147776 | 140475 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1299 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003263.9128 | 2112672.0778 | 37.7811792109881 | -122.43234429543699 | (37.7811792109881, -122.432344295437) | |||
| 169453 | 169453 | 140474 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1299 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003260.6519 | 2112697.5052 | 37.781248843361205 | -122.43235739312 | (37.7812488433612, -122.43235739312) | |||
| 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) | |||
| 29318 | 29318 | 248428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 130 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998278.3106 | 2108020.0433 | 37.768121965532295 | -122.449256670048 | (37.7681219655323, -122.449256670048) | |||
| 104554 | 104554 | 38282 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 111573 | 111573 | 38271 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 49865 | 49865 | 51646 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 2 | Permit Number 47930 | 6003261.002 | 2112980.3977 | 37.7820256151298 | -122.43237639268801 | (37.7820256151298, -122.432376392688) | ||
| 63843 | 63843 | 51639 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 1 | Permit Number 47930 | 6003279.6605 | 2112867.2804 | 37.7817160813577 | -122.432303761604 | (37.7817160813577, -122.432303761604) | ||
| 156910 | 156910 | 51645 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003273.8297 | 2112901.0989 | 37.7818086078686 | -122.43232634946399 | (37.7818086078686, -122.432326349464) | |||
| 158575 | 158575 | 51642 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.782268304126795 | -122.432423068554 | (37.7822683041268, -122.432423068554) | |||
| 159617 | 159617 | 51644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 47930 | 6003258.6697 | 2113006.0531 | 37.7820959261745 | -122.43238629430701 | (37.7820959261745, -122.432386294307) | ||
| 52181 | 52181 | 51643 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 47930 | 6003254.005 | 2113044.5364 | 37.7822013271565 | -122.432405181484 | (37.7822013271565, -122.432405181484) | ||
| 49482 | 49482 | 191518 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.96067 | 2102295.09834 | 37.7533649068725 | -122.38976221485201 | (37.7533649068725, -122.389762214852) | ||||
| 132918 | 132918 | 191519 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1301 Minnesota St | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.355280001 | 2102287.9269 | 37.7533451820439 | -122.38976380757 | (37.7533451820439, -122.38976380757) | ||||
| 150669 | 150669 | 227994 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1306 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6003859.6662099995 | 2100626.63224 | 37.748139081362794 | -122.42942403481001 | (37.7481390813628, -122.42942403481) | |||
| 153954 | 153954 | 140413 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1307 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003235.7717 | 2112855.6935 | 37.781681777993995 | -122.43245476821998 | (37.781681777994, -122.43245476822) | |||
| 12206 | 12206 | 65603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 131 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 15 | 3x3 | Permit Number 28506 | 6004245.84033 | 2093781.6134799998 | 37.7293660735617 | -122.427601053271 | (37.7293660735617, -122.427601053271) |
| 31979 | 31979 | 129746 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1310 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011484.09994 | 2119879.99013 | 37.801433092922004 | -122.40441387701401 | (37.801433092922, -122.404413877014) | |||
| 38079 | 38079 | 140412 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1315 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003232.5898 | 2112885.9212 | 37.7817645952487 | -122.43246793575899 | (37.7817645952487, -122.432467935759) | |||
| 33815 | 33815 | 228012 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1317 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998216.16813 | 2105874.44581 | 37.762227142891504 | -122.449317008786 | (37.7622271428915, -122.449317008786) | |||
| 153751 | 153751 | 228011 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1317 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998213.13693 | 2105892.48984 | 37.7622765138731 | -122.44932879261002 | (37.7622765138731, -122.44932879261) | |||
| 42466 | 42466 | 227858 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 132 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004094.70808 | 2102310.5679200003 | 37.7527760802641 | -122.428731293332 | (37.7527760802641, -122.428731293332) | |||
| 27545 | 27545 | 140410 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1325 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003227.817000001 | 2112933.649 | 37.7818953731726 | -122.43248785744301 | (37.7818953731726, -122.432487857443) | |||
| 136504 | 136504 | 140411 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1325 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003228.6125 | 2112911.376 | 37.7818342622099 | -122.432483514028 | (37.7818342622099, -122.432483514028) | |||
| 27561 | 27561 | 227876 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 133 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002056.6842 | 2105072.72951 | 37.7602447556215 | -122.43597676861 | (37.7602447556215, -122.43597676861) | |||
| 26610 | 26610 | 228013 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1343 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998231.8221 | 2105759.10992 | 37.76191135493279 | -122.449254558076 | (37.7619113549328, -122.449254558076) | |||
| 57039 | 57039 | 140409 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1345 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003222.2488 | 2112956.7175 | 37.7819583977331 | -122.432508769039 | (37.7819583977331, -122.432508769039) | |||
| 80190 | 80190 | 9860 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 80526 | 80526 | 9862 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 92762 | 92762 | 9859 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 167145 | 167145 | 58941 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1366 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 13 | Permit Number 18219 | 6011964.85898 | 2102013.4641 | 37.7524025792275 | -122.401493839477 | (37.7524025792275, -122.401493839477) | ||
| 58750 | 58750 | 208151 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001394.62924 | 2094896.4943 | 37.7322655930748 | -122.43753774257799 | (37.7322655930748, -122.437537742578) | |||
| 174097 | 174097 | 208149 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hamerton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6001382.20466 | 2095404.6567400002 | 37.7336601834577 | -122.43761707629 | (37.7336601834577, -122.43761707629) | |||
| 85299 | 85299 | 64872 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778656 | 6003401.65761863 | 2105041.71161228 | 37.760235902821606 | -122.43132292695499 | (37.7602359028216, -122.431322926955) | |
| 156841 | 156841 | 227870 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003364.20801 | 2105044.49788 | 37.7602414308096 | -122.431452646343 | (37.7602414308096, -122.431452646343) | |||
| 72799 | 72799 | 208158 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 137 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999136.82993 | 2093762.64441 | 37.7290236809976 | -122.445261947704 | (37.7290236809976, -122.445261947704) | |||
| 164001 | 164001 | 56674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1371 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5984603.4838 | 2105851.1543 | 37.761375137437604 | -122.496395703433 | (37.7613751374376, -122.496395703433) | ||||
| 131133 | 131133 | 250130 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1377 Post St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6005624.52501 | 2114452.88232 | 37.786202430153395 | -122.42430443452601 | (37.7862024301534, -122.424304434526) | |||
| 150255 | 150255 | 250129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1377 Post St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6005609.22184 | 2114451.0225400003 | 37.786196459532704 | -122.42435724721201 | (37.7861964595327, -122.424357247212) | |||
| 97080 | 97080 | 46078 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2001 12:00:00 AM | Permit Number 44459 | 6016168.14280668 | 2094664.01192279 | 37.7324561236274 | -122.38644566841499 | (37.7324561236274, -122.386445668415) | |||
| 175774 | 175774 | 31530 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35085 | 6011132.9028199995 | 2101918.55735 | 37.7520955300081 | -122.404364216429 | (37.7520955300081, -122.404364216429) | |
| 129549 | 129549 | 250027 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1388 Gough St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6005504.43903 | 2114371.51964 | 37.7859722468757 | -122.424714110791 | (37.7859722468757, -122.424714110791) | |||
| 67443 | 67443 | 140408 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1395 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003217.0783 | 2112984.5587 | 37.7820345494787 | -122.43252864581699 | (37.7820345494787, -122.432528645817) | |||
| 132615 | 132615 | 140407 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1395 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003214.6919 | 2113013.1955 | 37.7821130436189 | -122.432538947764 | (37.7821130436189, -122.432538947764) | |||
| 176506 | 176506 | 140406 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1395 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003211.51 | 2113040.2412 | 37.7821871238844 | -122.432551888118 | (37.7821871238844, -122.432551888118) | |||
| 46247 | 46247 | 250029 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1398 Gough St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6005499.34318 | 2114400.53474 | 37.7860516273342 | -122.424733805923 | (37.7860516273342, -122.424733805923) | |||
| 162304 | 162304 | 249548 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1398 Gough St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6005498.68778 | 2114410.1852 | 37.78607808808621 | -122.424736760212 | (37.7860780880862, -122.424736760212) | |||
| 22378 | 22378 | 26756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005569.26951 | 2114444.1495 | 37.7861753317646 | -122.424494982868 | (37.7861753317646, -122.424494982868) | |||
| 22416 | 22416 | 26753 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005527.1532 | 2114438.07435 | 37.7861562724304 | -122.424640262031 | (37.7861562724304, -122.424640262031) | |||
| 22571 | 22571 | 26752 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005515.49515 | 2114435.63395 | 37.7861489132884 | -122.424680422175 | (37.7861489132884, -122.424680422175) | |||
| 22634 | 22634 | 26754 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005539.86656 | 2114440.61457 | 37.7861639652384 | -122.424596457885 | (37.7861639652384, -122.424596457885) | |||
| 22794 | 22794 | 26757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005593.49204 | 2114448.7926 | 37.786189448429205 | -122.42441150958099 | (37.7861894484292, -122.424411509581) | |||
| 22804 | 22804 | 26755 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005555.38127 | 2114442.5721400003 | 37.7861702164197 | -122.424542920326 | (37.7861702164197, -122.424542920326) | |||
| 82308 | 82308 | 26759 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.786134771520096 | -122.42479560486 | (37.7861347715201, -122.42479560486) | |||
| 140171 | 140171 | 26758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.786134771520096 | -122.42479560486 | (37.7861347715201, -122.42479560486) | |||
| 170311 | 170311 | 191127 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 14 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012309.5966300005 | 2104032.1963400003 | 37.7579648060593 | -122.400443459212 | (37.7579648060593, -122.400443459212) | |||
| 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) |
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");