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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 173625 | 173625 | 227815 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 245 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008093.40262 | 2097451.32224 | 37.7396591768336 | -122.414559209965 | (37.7396591768336, -122.414559209965) | |||
| 176780 | 176780 | 67047 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2532 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1992 12:00:00 AM | 8 | Permit Number 30427 | 5988951.1175 | 2098070.1197 | 37.7402642171623 | -122.480789555517 | (37.7402642171623, -122.480789555517) | ||
| 60879 | 60879 | 208111 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2559 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992039.89052 | 2098021.8056099997 | 37.740310607054894 | -122.470106396399 | (37.7403106070549, -122.470106396399) | |||
| 153373 | 153373 | 208112 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992037.32657 | 2098038.7861599997 | 37.7403570831075 | -122.47011649758801 | (37.7403570831075, -122.470116497588) | |||
| 122400 | 122400 | 38006 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40217 | 5992035.60667724 | 2098055.00516972 | 37.740401516958705 | -122.47012362496099 | (37.7404015169587, -122.470123624961) | ||
| 162021 | 162021 | 227922 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 66 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6004271.33635 | 2097814.43726 | 37.7404407398594 | -122.42780014605499 | (37.7404407398594, -122.427800146055) | |||
| 166864 | 166864 | 227921 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1870 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004572.099230001 | 2097821.31291 | 37.7404766282059 | -122.426760715047 | (37.7404766282059, -122.426760715047) | |||
| 165944 | 165944 | 227923 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 274 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003834.67602 | 2097851.00619 | 37.7405164384923 | -122.42931255304899 | (37.7405164384923, -122.429312553049) | |||
| 173267 | 173267 | 227924 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 274 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003821.28382 | 2097859.76305 | 37.740539724631 | -122.429359482364 | (37.740539724631, -122.429359482364) | |||
| 50633 | 50633 | 227818 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6006782.14401 | 2097820.3325099996 | 37.7405986419274 | -122.419119157627 | (37.7405986419274, -122.419119157627) | |||
| 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) | |||
| 121761 | 121761 | 33593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37700 | 6006820.21311038 | 2097865.60877622 | 37.7407251042318 | -122.418990739568 | (37.7407251042318, -122.418990739568) | |||
| 159863 | 159863 | 227756 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007867.24029 | 2098177.26821 | 37.7416397555584 | -122.41539256401501 | (37.7416397555584, -122.415392564015) | |||
| 132801 | 132801 | 227755 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007852.28017 | 2098178.6405599997 | 37.7416426828781 | -122.415444388362 | (37.7416426828781, -122.415444388362) | |||
| 172346 | 172346 | 227754 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007840.26283 | 2098179.95266 | 37.7416456101503 | -122.41548603327499 | (37.7416456101503, -122.415486033275) | |||
| 157163 | 157163 | 227753 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Powhattan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007829.3265 | 2098181.7755400003 | 37.7416500006593 | -122.415523976565 | (37.7416500006593, -122.415523976565) | |||
| 72800 | 72800 | 208075 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 114 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998390.034080001 | 2098450.75063 | 37.7418534470942 | -122.448181102087 | (37.7418534470942, -122.448181102087) | |||
| 11928 | 11928 | 105246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2439 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x6 | 5989501.8448 | 2098751.2622 | 37.7421664525595 | -122.478935190185 | (37.7421664525595, -122.478935190185) | |||
| 151596 | 151596 | 227822 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 146 Elsie St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6007069.8584 | 2098388.70244 | 37.7421754574342 | -122.418164635198 | (37.7421754574342, -122.418164635198) | |||
| 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) | |||
| 109644 | 109644 | 37048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
| 142269 | 142269 | 37049 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
| 146566 | 146566 | 227983 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004966.62525 | 2098700.55868 | 37.742913135325296 | -122.42545915411199 | (37.7429131353253, -122.425459154112) | |||
| 174037 | 174037 | 227984 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004984.7941 | 2098700.56967 | 37.7429141920365 | -122.425396332001 | (37.7429141920365, -122.425396332001) | |||
| 172894 | 172894 | 208045 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992699.77164 | 2098959.9602799998 | 37.7429246682415 | -122.46789302904399 | (37.7429246682415, -122.467893029044) | |||
| 3079 | 3079 | 227980 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 7 | Width 3ft | Permit Number 49086 | 6005100.30377 | 2099043.7406 | 37.7438629866828 | -122.425021342566 | (37.7438629866828, -122.425021342566) | |
| 3098 | 3098 | 227979 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 6 | Width 3ft | Permit Number 49086 | 6005126.89466 | 2099045.69197 | 37.7438698467248 | -122.424929536192 | (37.7438698467248, -122.424929536192) | |
| 3085 | 3085 | 227978 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005155.75456 | 2099046.13918 | 37.7438727047738 | -122.42482977709601 | (37.7438727047738, -122.424829777096) | |
| 3092 | 3092 | 227977 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 4 | Width 3ft | Permit Number 49086 | 6005172.09288 | 2099047.67656 | 37.7438778488792 | -122.424773392283 | (37.7438778488792, -122.424773392283) | |
| 3086 | 3086 | 227976 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005186.74242 | 2099048.41612 | 37.7438807069453 | -122.424722790133 | (37.7438807069453, -122.424722790133) | |
| 3076 | 3076 | 227975 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200X 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 4 | Width 3ft | Permit Number 49086 | 6005200.1380900005 | 2099049.18147 | 37.7438835649874 | -122.424676525409 | (37.7438835649874, -122.424676525409) | |
| 3073 | 3073 | 227974 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200X 29th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 5 | Width 3ft | Permit Number 49086 | 6005213.325 | 2099049.95145 | 37.7438864239343 | -122.424630982854 | (37.7438864239343, -122.424630982854) | |
| 80858 | 80858 | 53166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 81932 | 81932 | 53168 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 87409 | 87409 | 53170 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 108069 | 108069 | 53167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 111983 | 111983 | 53171 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 115764 | 115764 | 53165 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 143865 | 143865 | 53169 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 74489 | 74489 | 208101 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2357 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992303.56626 | 2099363.27465 | 37.7440091795707 | -122.469292334575 | (37.7440091795707, -122.469292334575) | |||
| 76625 | 76625 | 208106 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2367 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992612.0223 | 2099358.1816 | 37.744013015182 | -122.46822540229999 | (37.744013015182, -122.4682254023) | |||
| 56459 | 56459 | 208046 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2356 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992347.94359 | 2099384.54976 | 37.744070159913996 | -122.469140437284 | (37.744070159914, -122.469140437284) | |||
| 57153 | 57153 | 208102 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2357 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992303.47716 | 2099394.44752 | 37.7440947671662 | -122.46929491115401 | (37.7440947671662, -122.469294911154) | |||
| 73671 | 73671 | 208047 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2356 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992346.98246 | 2099405.01198 | 37.744126288412396 | -122.46914524958 | (37.7441262884124, -122.46914524958) | |||
| 129860 | 129860 | 208103 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2353 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992301.035730001 | 2099420.10379 | 37.7441650716512 | -122.469305220056 | (37.7441650716512, -122.469305220056) | |||
| 159073 | 159073 | 208104 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2349 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5992300.54287 | 2099449.8007799997 | 37.7442465835224 | -122.469309085355 | (37.7442465835224, -122.469309085355) | |||
| 25465 | 25465 | 208048 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2344 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992344.38135 | 2099463.27392 | 37.74428611053071 | -122.469158483081 | (37.7442861105307, -122.469158483081) | |||
| 29643 | 29643 | 246620 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009078.777530001 | 2099136.29589 | 37.744341055486295 | -122.411271191437 | (37.7443410554863, -122.411271191437) | |||
| 74914 | 74914 | 246619 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 171 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6009083.01922 | 2099139.1845299997 | 37.7443492249476 | -122.411256728527 | (37.7443492249476, -122.411256728527) | |||
| 54764 | 54764 | 246617 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 179 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6009150.0999300005 | 2099139.59949 | 37.7443541262592 | -122.411024805947 | (37.7443541262592, -122.411024805947) | |||
| 158220 | 158220 | 208049 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992344.1762 | 2099503.1223 | 37.744395512154796 | -122.46916209207899 | (37.7443955121548, -122.469162092079) | |||
| 147806 | 147806 | 208146 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995205.6435 | 2099446.88271 | 37.7444060207274 | -122.45926372915001 | (37.7444060207274, -122.45926372915) | |||
| 64151 | 64151 | 208145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 5995207.23946 | 2099465.92772 | 37.7444584053336 | -122.459259589568 | (37.7444584053336, -122.459259589568) | |||
| 154679 | 154679 | 208105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2339 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5992296.97523 | 2099528.1746 | 37.7444615718506 | -122.469327124863 | (37.7444615718506, -122.469327124863) | |||
| 72962 | 72962 | 208050 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2338 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992343.816769999 | 2099531.60984 | 37.7444737108967 | -122.46916540785601 | (37.7444737108967, -122.469165407856) | |||
| 40839 | 40839 | 208110 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 5993194.87968 | 2099514.9753099997 | 37.744477176897504 | -122.466221422307 | (37.7444771768975, -122.466221422307) | |||
| 27892 | 27892 | 208144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.64176 | 2099494.55804 | 37.7445369826924 | -122.459263729149 | (37.7445369826924, -122.459263729149) | |||
| 153369 | 153369 | 208143 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5995206.3178199995 | 2099507.68118 | 37.7445729969391 | -122.459265799394 | (37.7445729969391, -122.459265799394) | |||
| 161883 | 161883 | 227774 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2104 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 6002638.6177199995 | 2099362.84532 | 37.744599811132005 | -122.433556070657 | (37.744599811132, -122.433556070657) | |||
| 147210 | 147210 | 208142 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.6173 | 2099521.98382 | 37.7446122856405 | -122.459265799391 | (37.7446122856405, -122.459265799391) | |||
| 33972 | 33972 | 227821 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 73 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006832.17705 | 2099290.0553200003 | 37.7446369891207 | -122.419050382891 | (37.7446369891207, -122.419050382891) | |||
| 60172 | 60172 | 208141 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5995208.500519999 | 2099554.73561 | 37.7447023221602 | -122.459261658906 | (37.7447023221602, -122.459261658906) | |||
| 58305 | 58305 | 208107 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992604.896919999 | 2099614.84743 | 37.7447173426335 | -122.468268708247 | (37.7447173426335, -122.468268708247) | |||
| 158225 | 158225 | 208108 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992604.0801800005 | 2099624.3028 | 37.7447432574969 | -122.468272220082 | (37.7447432574969, -122.468272220082) | |||
| 72595 | 72595 | 208109 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2325 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992602.58698 | 2099633.7724 | 37.7447691723617 | -122.468278072002 | (37.7447691723617, -122.468278072002) | |||
| 106403 | 106403 | 102105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2104 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 769122 | 6002645.0 | 2099438.0 | 37.7448065304391 | -122.43353937189501 | (37.7448065304391, -122.433539371895) | |||
| 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) | |||
| 174749 | 174749 | 227990 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1504 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003927.19996 | 2099465.05045 | 37.744953470419 | -122.42910769558901 | (37.744953470419, -122.429107695589) | |||
| 75102 | 75102 | 227988 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003841.41785 | 2099558.26389 | 37.7452045566614 | -122.429410960447 | (37.7452045566614, -122.429410960447) | |||
| 147761 | 147761 | 227987 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003864.381 | 2099559.4457400003 | 37.74520910181629 | -122.429331642062 | (37.7452091018163, -122.429331642062) | |||
| 83467 | 83467 | 35415 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 92740 | 92740 | 35414 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 144573 | 144573 | 35413 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 50500 | 50500 | 227986 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003891.46294 | 2099561.3900200003 | 37.7452159735461 | -122.42923813594999 | (37.7452159735461, -122.42923813595) | |||
| 153199 | 153199 | 208100 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991679.25346 | 2099828.9819099996 | 37.7452517953444 | -122.471484974349 | (37.7452517953444, -122.471484974349) | |||
| 26594 | 26594 | 208099 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991681.99819 | 2099835.94672 | 37.745271077706704 | -122.471475991035 | (37.7452710777067, -122.471475991035) | |||
| 172372 | 172372 | 208123 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994792.79131 | 2099776.97175 | 37.7452886180713 | -122.460715192672 | (37.7452886180713, -122.460715192672) | |||
| 153459 | 153459 | 208124 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994815.96906 | 2099777.31016 | 37.7452908807659 | -122.46063507296199 | (37.7452908807659, -122.460635072962) | |||
| 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) | |||
| 121033 | 121033 | 38222 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40349 | 5991678.28674141 | 2099849.72262287 | 37.745308688082396 | -122.471489828106 | (37.7453086880824, -122.471489828106) | |||
| 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) | |||
| 173917 | 173917 | 208122 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994754.50081 | 2099786.0148400003 | 37.7453112450104 | -122.46084824916299 | (37.7453112450104, -122.460848249163) | |||
| 132638 | 132638 | 208126 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994854.63064 | 2099785.9766 | 37.7453169008687 | -122.460502016464 | (37.7453169008687, -122.460502016464) | |||
| 162441 | 162441 | 227985 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 222 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 6004405.37253 | 2099591.374 | 37.7453273824517 | -122.427463259139 | (37.7453273824517, -122.427463259139) | |||
| 37037 | 37037 | 208121 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994733.18466 | 2099795.5260099997 | 37.745336133767296 | -122.46092264556499 | (37.7453361337673, -122.460922645565) | |||
| 97436 | 97436 | 62351 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22494 | 6005350.50245062 | 2099593.00770081 | 37.7453852789219 | -122.424195268575 | (37.7453852789219, -122.424195268575) | ||
| 59487 | 59487 | 227538 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005426.60172 | 2099601.35924 | 37.7454125068841 | -122.42393272313 | (37.7454125068841, -122.42393272313) | |||
| 30357 | 30357 | 227761 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005426.61046 | 2099602.37866 | 37.745415306472204 | -122.42393276538601 | (37.7454153064722, -122.423932765386) | |||
| 146748 | 146748 | 227966 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 329 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009444.02265 | 2099567.83625 | 37.745546448317704 | -122.410038704746 | (37.7455464483177, -122.410038704746) | |||
| 164304 | 164304 | 218332 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 490 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5992960.68129 | 2099942.11399 | 37.7456364758511 | -122.46706227402001 | (37.7456364758511, -122.46706227402) | |||
| 36958 | 36958 | 218331 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5992969.5872 | 2099943.88935 | 37.745641864594 | -122.46703160803601 | (37.745641864594, -122.467031608036) | |||
| 77020 | 77020 | 218330 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5992991.749009999 | 2099943.42348 | 37.7456418645961 | -122.46695494261499 | (37.7456418645961, -122.466954942615) | |||
| 70183 | 70183 | 218329 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5993003.09698 | 2099944.16622 | 37.745644558947895 | -122.466915757358 | (37.7456445589479, -122.466915757358) | |||
| 109086 | 109086 | 33481 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37592 | 6007052.40604971 | 2099676.37615129 | 37.7457101385308 | -122.418316258344 | (37.7457101385308, -122.418316258344) | ||
| 164582 | 164582 | 227820 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007044.27544 | 2099680.4476 | 37.745720860129104 | -122.41834466148799 | (37.7457208601291, -122.418344661488) | |||
| 170340 | 170340 | 218321 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 414 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5993266.671709999 | 2099966.5931 | 37.7457213466715 | -122.466005992402 | (37.7457213466715, -122.466005992402) | |||
| 50220 | 50220 | 218320 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 400 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5993320.26177 | 2099984.60198 | 37.7457738859626 | -122.465821995605 | (37.7457738859626, -122.465821995605) | |||
| 76236 | 76236 | 227819 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007068.6821800005 | 2099721.5782 | 37.7458351693761 | -122.418263182012 | (37.7458351693761, -122.418263182012) | |||
| 90336 | 90336 | 33497 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37588 | 6007021.25591613 | 2099725.96970318 | 37.745844557740604 | -122.418427487036 | (37.7458445577406, -122.418427487036) | |||
| 112719 | 112719 | 21073 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) |
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");