Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 175173 | 175173 | 200284 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017057.48354 | 2097042.3029900002 | 37.739035626492296 | -122.38353648713199 | (37.7390356264923, -122.383536487132) | |||
| 68482 | 68482 | 200275 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017053.42195 | 2097063.51512 | 37.7390936462465 | -122.38355200672702 | (37.7390936462465, -122.383552006727) | |||
| 173001 | 173001 | 200279 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.91134 | 2097012.03507 | 37.7389520983484 | -122.383560561973 | (37.7389520983484, -122.383560561973) | |||
| 34090 | 34090 | 200282 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.10078 | 2097031.29718 | 37.7390049434275 | -122.383564705169 | (37.7390049434275, -122.383564705169) | |||
| 26638 | 26638 | 200276 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017047.12766 | 2097054.90505 | 37.7390696568319 | -122.383573170476 | (37.7390696568319, -122.383573170476) | |||
| 153586 | 153586 | 200280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017039.14807 | 2097019.94402 | 37.7389732198275 | -122.383598327225 | (37.7389732198275, -122.383598327225) | |||
| 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) | |||
| 162698 | 162698 | 200278 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017026.25444 | 2097031.5540099998 | 37.739004385852795 | -122.383643715978 | (37.7390043858528, -122.383643715978) | |||
| 166660 | 166660 | 191534 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016265.973669999 | 2107216.92727 | 37.7669292347089 | -122.386982621765 | (37.7669292347089, -122.386982621765) | |||
| 43198 | 43198 | 191533 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016236.27796 | 2107216.03359 | 37.7669251365154 | -122.387085273085 | (37.7669251365154, -122.387085273085) | |||
| 169931 | 169931 | 191532 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016209.16515 | 2107214.5091 | 37.766919449199 | -122.38717894646999 | (37.766919449199, -122.38717894647) | |||
| 58277 | 58277 | 191531 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016181.25153 | 2107212.70143 | 37.766912939908295 | -122.387275369984 | (37.7669129399083, -122.387275369984) | |||
| 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) | |||
| 76361 | 76361 | 191530 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016138.64503 | 2107209.62915 | 37.7669021444474 | -122.387422526024 | (37.7669021444474, -122.387422526024) | |||
| 69140 | 69140 | 191529 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6016082.02245 | 2107209.5732299997 | 37.7668988547309 | -122.387618372283 | (37.7668988547309, -122.387618372283) | |||
| 327 | 327 | 191528 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | Width 5ft | 6016052.47786 | 2107208.19392 | 37.76689343092 | -122.38772046693501 | (37.76689343092, -122.387720466935) | ||
| 157738 | 157738 | 191527 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.76688400872221 | -122.387813186138 | (37.7668840087222, -122.387813186138) | |||
| 36206 | 36206 | 191526 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.766879529196295 | -122.387914043316 | (37.7668795291963, -122.387914043316) | |||
| 59631 | 59631 | 191142 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3 Bryant St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6015882.39445 | 2114438.5684700003 | 37.7867370114514 | -122.388813583003 | (37.7867370114514, -122.388813583003) | |||
| 133563 | 133563 | 191137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6015869.60508 | 2099707.91773 | 37.7462891309579 | -122.387829608652 | (37.7462891309579, -122.387829608652) | ||||
| 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) | ||||
| 37214 | 37214 | 191135 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6015829.2920699995 | 2099737.9733599997 | 37.7463694242077 | -122.387971104383 | (37.7463694242077, -122.387971104383) | ||||
| 46300 | 46300 | 191141 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3 Bryant St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6015816.86409 | 2114381.01819 | 37.78657535921089 | -122.389036284815 | (37.7865753592109, -122.389036284815) | |||
| 82063 | 82063 | 21900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
| 114646 | 114646 | 21898 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
| 139049 | 139049 | 21899 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2065 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015783.090580001 | 2106025.2302 | 37.7636303426542 | -122.388569659247 | (37.7636303426542, -122.388569659247) | |||
| 82555 | 82555 | 41201 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 97143 | 97143 | 41197 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 157294 | 157294 | 59707 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1133 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19137 | 6015590.05369 | 2103684.27955 | 37.757191894493296 | -122.38907386028299 | (37.7571918944933, -122.389073860283) | ||
| 166783 | 166783 | 191517 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1129 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015588.78153 | 2103719.02877 | 37.7572872379344 | -122.389080686136 | (37.7572872379344, -122.389080686136) | |||
| 156880 | 156880 | 33828 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 7 | Permit Number 37844 | 6015588.22624 | 2103756.71192 | 37.757390677059 | -122.38908523761299 | (37.757390677059, -122.389085237613) | ||
| 42285 | 42285 | 33829 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 15 | Permit Number 37844 | 6015587.6013400005 | 2103776.1855900004 | 37.7574441129692 | -122.38908875844601 | (37.7574441129692, -122.389088758446) | ||
| 168458 | 168458 | 59599 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1117 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 14 | Permit Number 19000 | 6015586.46491 | 2103801.69873 | 37.7575141036211 | -122.38909447005699 | (37.7575141036211, -122.389094470057) | ||
| 153581 | 153581 | 59603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1109 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 13 | Permit Number 19004 | 6015581.75911 | 2103854.91189 | 37.7576599547603 | -122.38911446017599 | (37.7576599547603, -122.389114460176) | ||
| 49489 | 49489 | 59601 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1113 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 15 | Permit Number 19002 | 6015581.41308 | 2103829.5931 | 37.757590415576 | -122.389113889098 | (37.757590415576, -122.389113889098) | ||
| 55121 | 55121 | 59604 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1105 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 12 | Permit Number 19005 | 6015580.10762 | 2103879.44891 | 37.7577272366388 | -122.38912188497801 | (37.7577272366388, -122.389121884978) | ||
| 63400 | 63400 | 67610 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1095 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 9 | Permit Number 31188 | 6015569.94295 | 2104025.3864 | 37.7581273863874 | -122.389167228807 | (37.7581273863874, -122.389167228807) | |
| 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) | |||
| 46761 | 46761 | 191521 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1099 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015569.33397 | 2104003.49166 | 37.7580672343431 | -122.38916780615801 | (37.7580672343431, -122.389167806158) | |||
| 176226 | 176226 | 191522 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1089 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015567.39851 | 2104058.65501 | 37.7582185938385 | -122.389178351619 | (37.7582185938385, -122.389178351619) | |||
| 175248 | 175248 | 59607 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1069 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 17 | Permit Number 19009 | 6015565.5861599995 | 2104116.66963 | 37.7583777891326 | -122.38918867043999 | (37.7583777891326, -122.38918867044) | ||
| 73157 | 73157 | 59608 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1067 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 15 | Permit Number 19010 | 6015563.891919999 | 2104132.18346 | 37.7584202928751 | -122.389195613182 | (37.7584202928751, -122.389195613182) | ||
| 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) | ||
| 16371 | 16371 | 59613 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1025 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 10 | 3x3 | Permit Number 19016 | 6015555.95429 | 2104293.41546 | 37.7588625614652 | -122.389234323603 | (37.7588625614652, -122.389234323603) | |
| 159167 | 159167 | 59612 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1049 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2014 12:00:00 AM | 13 | Permit Number 19014 | 6015555.050530001 | 2104225.77952 | 37.758676797525 | -122.38923272642 | (37.758676797525, -122.38923272642) | ||
| 14243 | 14243 | 105849 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1025 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 19016 | 6015551.36754 | 2104359.7286799997 | 37.7590443891103 | -122.389254817379 | (37.7590443891103, -122.389254817379) | ||
| 150081 | 150081 | 59706 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1001 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19136 | 6015543.40178 | 2104492.11293 | 37.7594074463272 | -122.389291611327 | (37.7594074463272, -122.389291611327) | ||
| 33495 | 33495 | 105991 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 997 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x9 | 6015541.70538 | 2104536.18595 | 37.7595283673583 | -122.389300555992 | (37.7595283673583, -122.389300555992) | |||
| 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) | ||
| 136710 | 136710 | 191525 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 7ft | 6015505.26646 | 2104138.41993 | 37.758434166722395 | -122.38939880333099 | (37.7584341667224, -122.389398803331) | |||
| 73547 | 73547 | 191524 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 7ft | 6015503.99036 | 2104179.13483 | 37.7585458903883 | -122.38940605994499 | (37.7585458903883, -122.389406059945) | |||
| 50223 | 50223 | 191523 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 7ft | 6015501.46651 | 2104207.8933 | 37.7586247150714 | -122.389416796942 | (37.7586247150714, -122.389416796942) | |||
| 166751 | 166751 | 59610 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1060 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 19 | Permit Number 19012 | 6015498.92125 | 2104246.5894 | 37.7587308251729 | -122.389428301996 | (37.7587308251729, -122.389428301996) | ||
| 135179 | 135179 | 59708 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1010 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1981 12:00:00 AM | 11 | Permit Number 19138 | 6015489.89793 | 2104400.82935 | 37.7591538347945 | -122.389470280533 | (37.7591538347945, -122.389470280533) | ||
| 16387 | 16387 | 111703 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1006 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x12 | 6015488.19364 | 2104440.58048 | 37.7592628883951 | -122.389478950919 | (37.7592628883951, -122.389478950919) | |||
| 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) | ||
| 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) | ||||
| 147342 | 147342 | 76428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1998 12:00:00 AM | 1 | 6015359.03097 | 2115547.59056 | 37.7897531109548 | -122.390701840925 | (37.7897531109548, -122.390701840925) | ||
| 127747 | 127747 | 92232 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 49975 | 6015152.0 | 2105524.0 | 37.762219079001795 | -122.390717392856 | (37.7622190790018, -122.390717392856) | |||
| 49087 | 49087 | 87032 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 654 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 11 | Permit Number 49975 | 6015139.67842 | 2105542.64874 | 37.762269600786 | -122.390761312191 | (37.762269600786, -122.390761312191) | ||
| 134358 | 134358 | 200263 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014881.06262 | 2088948.3619 | 37.7166907534629 | -122.39049621274799 | (37.7166907534629, -122.390496212748) | |||
| 73104 | 73104 | 200264 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 828x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014856.837309999 | 2088987.16565 | 37.716795957049996 | -122.390582658263 | (37.71679595705, -122.390582658263) | |||
| 42611 | 42611 | 191144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 75 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014827.1240300005 | 2113162.01848 | 37.7831733516173 | -122.39237527782 | (37.7831733516173, -122.39237527782) | |||
| 34476 | 34476 | 191143 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 75 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014816.78786 | 2113152.41079 | 37.7831463971164 | -122.39241036486 | (37.7831463971164, -122.39241036486) | |||
| 157992 | 157992 | 200265 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014784.79531 | 2089078.0954900002 | 37.7170416356268 | -122.390838025257 | (37.7170416356268, -122.390838025257) | |||
| 63521 | 63521 | 200266 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014773.14657 | 2089094.60205 | 37.7170863130726 | -122.39087944264999 | (37.7170863130726, -122.39087944265) | |||
| 26865 | 26865 | 200267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6014763.4294300005 | 2089103.4873400002 | 37.7171101711671 | -122.39091365107001 | (37.7171101711671, -122.39091365107) | |||
| 151014 | 151014 | 200268 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014637.958740001 | 2089223.7051900001 | 37.7174333029868 | -122.39135574608801 | (37.7174333029868, -122.391355746088) | |||
| 50356 | 50356 | 200269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014632.09061 | 2089229.7896900002 | 37.7174496841459 | -122.39137645477501 | (37.7174496841459, -122.391376454775) | |||
| 51688 | 51688 | 200270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014621.84489 | 2089234.87823 | 37.717463087626705 | -122.39141222532 | (37.7174630876267, -122.39141222532) | |||
| 36890 | 36890 | 191535 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6014535.49417 | 2103905.68613 | 37.757741315531504 | -122.392736452724 | (37.7577413155315, -122.392736452724) | |||
| 34340 | 34340 | 200271 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014518.22002 | 2089293.0618599998 | 37.7176170965211 | -122.391774477626 | (37.7176170965211, -122.391774477626) | |||
| 39056 | 39056 | 200272 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014501.14248 | 2089299.14768 | 37.7176328589541 | -122.39183393271401 | (37.7176328589541, -122.391833932714) | |||
| 32695 | 32695 | 191536 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014495.86116 | 2103903.97635 | 37.7577344195295 | -122.39287340149099 | (37.7577344195295, -122.392873401491) | |||
| 113028 | 113028 | 110257 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 116771 | 116771 | 110256 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 142550 | 142550 | 110258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 155762 | 155762 | 191537 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6014473.63415 | 2103902.4166 | 37.7577289021798 | -122.392950163136 | (37.7577289021798, -122.392950163136) | |||
| 68304 | 68304 | 191117 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 699 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6014453.67904 | 2103916.00921 | 37.757765116097495 | -122.39302012769501 | (37.7577651160975, -122.393020127695) | |||
| 53032 | 53032 | 191118 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 699 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014452.77288 | 2103943.8150400002 | 37.7578414145789 | -122.393025207069 | (37.7578414145789, -122.393025207069) | |||
| 88170 | 88170 | 121721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 116383 | 116383 | 121705 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 121023 | 121023 | 121709 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 148441 | 148441 | 121722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014436.80562 | 2102990.4188599996 | 37.7552227065741 | -122.39301372360599 | (37.7552227065741, -122.393013723606) | ||||
| 166932 | 166932 | 121719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014433.09577 | 2103038.00285 | 37.7553531559357 | -122.39302988263799 | (37.7553531559357, -122.393029882638) | ||||
| 54747 | 54747 | 121720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6014432.547780001 | 2103023.07571 | 37.755312138768204 | -122.39303073340099 | (37.7553121387682, -122.393030733401) | ||||
| 15638 | 15638 | 121717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.9321099995 | 2103065.57675 | 37.755428803314295 | -122.39303583615101 | (37.7554288033143, -122.393035836151) | ||
| 15784 | 15784 | 121716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779222 | 6014431.75751 | 2103081.25316 | 37.7554718376765 | -122.39303753677 | (37.7554718376765, -122.39303753677) | |
| 131597 | 131597 | 121718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6014431.62012 | 2103050.15485 | 37.7553864407519 | -122.393035836129 | (37.7553864407519, -122.393035836129) | ||||
| 16736 | 16736 | 121715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.39304689240299 | (37.7555585790683, -122.393046892403) | ||
| 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) | ||||
| 175212 | 175212 | 121714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6014427.84636 | 2103131.0451599997 | 37.755608338569104 | -122.39305454654699 | (37.7556083385691, -122.393054546547) | ||||
| 69648 | 69648 | 191550 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014425.29285 | 2102980.5331200003 | 37.7551949229254 | -122.39305284682301 | (37.7551949229254, -122.393052846823) | ||||
| 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) | ||||
| 60865 | 60865 | 121710 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6014421.90164 | 2103226.1823299997 | 37.7558692345973 | -122.39308176182199 | (37.7558692345973, -122.393081761822) | ||||
| 74264 | 74264 | 121711 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6014421.639169999 | 2103213.20868 | 37.7558335971581 | -122.393081761812 | (37.7558335971581, -122.393081761812) |
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");