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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186967 | 186967 | 246066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999949.17 | 2108444.1555 | 37.7693819003429 | -122.443507828871 | (37.7693819003429, -122.443507828871) | |||
24517 | 24517 | 129740 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012353.73266 | 2119674.7684299997 | 37.8009181627066 | -122.401390109871 | (37.8009181627066, -122.401390109871) | |||
27635 | 27635 | 129744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012609.98453 | 2119710.6419 | 37.801030956563395 | -122.400505885653 | (37.8010309565634, -122.400505885653) | |||
28393 | 28393 | 129742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012372.32254 | 2119675.23965 | 37.8009204937473 | -122.401325813756 | (37.8009204937473, -122.401325813756) | |||
71250 | 71250 | 129745 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012618.68817 | 2119711.1441 | 37.8010328208639 | -122.400475802435 | (37.8010328208639, -122.400475802435) | |||
171510 | 171510 | 129743 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012600.30896 | 2119709.91151 | 37.8010284114971 | -122.400539316148 | (37.8010284114971, -122.400539316148) | |||
177163 | 177163 | 129741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012363.448469999 | 2119674.7409900003 | 37.80091862944111 | -122.40135648692 | (37.8009186294411, -122.40135648692) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
48143 | 48143 | 208054 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 San Fernando Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992102.39322 | 2096463.5019599998 | 37.736035512423 | -122.46977686683 | (37.736035512423, -122.46977686683) | |||
165952 | 165952 | 245931 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Beulah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997879.1818 | 2107870.9 | 37.767689618362496 | -122.450626454426 | (37.7676896183625, -122.450626454426) | |||
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) | |||
81767 | 81767 | 39513 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40964 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | |||
122007 | 122007 | 39514 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40964 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | |||
16521 | 16521 | 19806 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
6803 | 6803 | 19590 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7231 | 7231 | 19588 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
7407 | 7407 | 19591 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
12970 | 12970 | 19589 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY4 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
52524 | 52524 | 191128 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012078.814590001 | 2104152.3276 | 37.758281787386 | -122.401250047675 | (37.758281787386, -122.401250047675) | |||
1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
1851 | 1851 | 4718 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008205.1504 | 2120957.4944 | 37.804207866952204 | -122.415836885075 | (37.8042078669522, -122.415836885075) | |||
5299 | 5299 | 4716 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008306.8566 | 2120868.0824 | 37.803968081269204 | -122.415478587922 | (37.8039680812692, -122.415478587922) | |||
6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
6383 | 6383 | 4717 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008242.0329 | 2120925.0825 | 37.804120945419 | -122.415706953629 | (37.804120945419, -122.415706953629) | ||
8454 | 8454 | 4715 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008330.3273 | 2120843.4941 | 37.803901887177204 | -122.415395624015 | (37.8039018871772, -122.415395624015) | ||
124851 | 124851 | 4719 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008486.129587 | 2120728.7244 | 37.803595514004 | -122.41484833114401 | (37.803595514004, -122.414848331144) | |||
30755 | 30755 | 208080 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991162.63824 | 2089810.37082 | 37.7177133113937 | -122.472541042839 | (37.7177133113937, -122.472541042839) | |||
33216 | 33216 | 208082 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991232.009819999 | 2090962.1201799999 | 37.720879746979705 | -122.47238517505 | (37.7208797469797, -122.47238517505) | |||
42602 | 42602 | 208081 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991233.74878 | 2090918.35178 | 37.720759670396106 | -122.47237597496999 | (37.7207596703961, -122.47237597497) | |||
65001 | 65001 | 208083 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x Junipero Serra Blvd | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991231.056580001 | 2090980.0304 | 37.720928868853896 | -122.472389775075 | (37.7209288688539, -122.472389775075) | |||
150090 | 150090 | 140685 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000x WEBSTER ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6003852.8969 | 2112257.5815 | 37.7800744864318 | -122.43027712243799 | (37.7800744864318, -122.430277122438) | |||
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) | ||
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) | |||
97490 | 97490 | 100180 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997991.0 | 2108152.0 | 37.768467847026294 | -122.450259955793 | (37.7684678470263, -122.450259955793) | ||||
115162 | 115162 | 112277 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||||
146082 | 146082 | 58491 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1978 12:00:00 AM | 4x4 | Permit Number 17662 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||
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) | ||
50299 | 50299 | 227796 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997239.9919300005 | 2106930.72577 | 37.7650715330364 | -122.452769455742 | (37.7650715330364, -122.452769455742) | |||
158395 | 158395 | 227795 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5997235.15112 | 2106961.34501 | 37.7651553282738 | -122.452788408983 | (37.7651553282738, -122.452788408983) | |||
185632 | 185632 | 227794 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1023 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5997230.41248 | 2106977.41048 | 37.7651991684211 | -122.45280595835399 | (37.7651991684211, -122.452805958354) | |||
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) | ||
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) | |
169034 | 169034 | 228001 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1027 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998100.634380001 | 2106690.05164 | 37.764459981474204 | -122.44977537345899 | (37.7644599814742, -122.449775373459) | |||
146691 | 146691 | 228002 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1033 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998104.33903 | 2106671.65488 | 37.764409680579 | -122.449761234305 | (37.764409680579, -122.449761234305) | |||
171296 | 171296 | 52472 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1038@ 12th AVE Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | Permit Number 48583 | 5992323.330569999 | 2111390.84025 | 37.777034850900606 | -122.470099615521 | (37.7770348509006, -122.470099615521) | |
135564 | 135564 | 228004 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1039 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998111.03938 | 2106633.51885 | 37.7643053520281 | -122.449735311348 | (37.7643053520281, -122.449735311348) | |||
159772 | 159772 | 228003 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1039 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998107.95915 | 2106649.18866 | 37.7643482011369 | -122.44974709425199 | (37.7643482011369, -122.449747094252) | |||
185336 | 185336 | 227730 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1044 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997692.15164 | 2106891.22645 | 37.7649889770905 | -122.451202705446 | (37.7649889770905, -122.451202705446) | |||
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) | ||
67648 | 67648 | 248339 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 105 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998213.3537 | 2108180.6942 | 37.76855935635471 | -122.4494929252 | (37.7685593563547, -122.4494929252) | |||
178240 | 178240 | 228005 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1051 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998115.625990001 | 2106592.03461 | 37.7641917091996 | -122.44971645795401 | (37.7641917091996, -122.449716457954) | |||
141934 | 141934 | 58614 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1052 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1979 12:00:00 AM | 3x3 | Permit Number 17828 | 5998153.64010117 | 2106679.35024276 | 37.764433630662204 | -122.449591270882 | (37.7644336306622, -122.449591270882) | ||
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) | ||
25393 | 25393 | 228021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1054 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998157.054409999 | 2106607.36365 | 37.7642361689933 | -122.44957427424102 | (37.7642361689933, -122.449574274241) | |||
57577 | 57577 | 129724 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007826.23151 | 2119905.33102 | 37.801297582165205 | -122.417073568702 | (37.8012975821652, -122.417073568702) | |||
136534 | 136534 | 129723 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007809.591659999 | 2119903.72607 | 37.801292239302796 | -122.417131036286 | (37.8012922393028, -122.417131036286) | |||
136861 | 136861 | 129726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007892.05327 | 2119913.90484 | 37.8013248262425 | -122.41684640354299 | (37.8013248262425, -122.416846403543) | |||
163183 | 163183 | 129725 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007869.3354400005 | 2119911.2573599997 | 37.801316279082705 | -122.416924829814 | (37.8013162790827, -122.416924829814) | |||
67771 | 67771 | 228006 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1057 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998117.27341 | 2106573.00208 | 37.76413954493321 | -122.449709388403 | (37.7641395449332, -122.449709388403) | |||
150442 | 150442 | 248323 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 106 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998260.7465 | 2108151.4712 | 37.768481828451705 | -122.449326892475 | (37.7684818284517, -122.449326892475) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||
134532 | 134532 | 227811 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1068 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5998996.78199 | 2106266.6439900002 | 37.7633486415415 | -122.44664539098999 | (37.7633486415415, -122.44664539099) | |||
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) | ||
35063 | 35063 | 227915 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999880.17425 | 2106931.0988 | 37.765223490583296 | -122.443637771174 | (37.7652234905833, -122.443637771174) | |||
36630 | 36630 | 227914 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999872.11976 | 2106925.98957 | 37.7652090025309 | -122.44366526256701 | (37.7652090025309, -122.443665262567) | |||
187164 | 187164 | 227916 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999889.55267 | 2106936.18055 | 37.7652379786836 | -122.44360569865299 | (37.7652379786836, -122.443605698653) | |||
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) | ||
27930 | 27930 | 129716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006809.35 | 2120459.5660099997 | 37.8027621146536 | -122.42063180021299 | (37.8027621146536, -122.420631800213) | |||
28107 | 28107 | 129718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006845.74669 | 2120464.39586 | 37.8027774273877 | -122.42050619192699 | (37.8027774273877, -122.420506191927) | |||
33165 | 33165 | 129714 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006770.61766 | 2120452.09935 | 37.8027394301331 | -122.420765303696 | (37.8027394301331, -122.420765303696) | |||
69185 | 69185 | 129717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006827.222569999 | 2120461.26491 | 37.8027677866551 | -122.420570072569 | (37.8027677866551, -122.420570072569) | |||
86026 | 86026 | 129719 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006860.09044 | 2120465.9602200002 | 37.802782531050795 | -122.420456666246 | (37.8027825310508, -122.420456666246) | |||
153938 | 153938 | 129713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006753.58301 | 2120450.7966299998 | 37.802734893067495 | -122.420824159811 | (37.8027348930675, -122.420824159811) | |||
161282 | 161282 | 129715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006786.6709199995 | 2120456.10735 | 37.8027513398688 | -122.420710035851 | (37.8027513398688, -122.420710035851) | |||
178469 | 178469 | 129721 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006892.13335 | 2120470.8795 | 37.8027978438157 | -122.420346130572 | (37.8027978438157, -122.420346130572) | |||
178527 | 178527 | 129720 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006876.11825 | 2120468.72973 | 37.802791038628705 | -122.42040139843 | (37.8027910386287, -122.42040139843) | |||
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) | |||
58341 | 58341 | 228009 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 109 Alma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998119.85145 | 2106206.2133 | 37.7631325830122 | -122.44967403874399 | (37.7631325830122, -122.449674038744) | |||
46897 | 46897 | 30588 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 109 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34558 | 6003337.11539 | 2108646.4783400004 | 37.770130061294104 | -122.431803534827 | (37.7701300612941, -122.431803534827) | ||
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) | |
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) | |||
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) | |||
54983 | 54983 | 227892 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003807.3589 | 2108238.1096 | 37.7690354253758 | -122.43014783075199 | (37.7690354253758, -122.430147830752) | |||
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) | |||
75949 | 75949 | 208138 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Santa Rita Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5993885.92048 | 2100911.41075 | 37.748351281781 | -122.463933307785 | (37.748351281781, -122.463933307785) | |||
152889 | 152889 | 248322 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998263.1691 | 2108132.3929 | 37.7684295828689 | -122.449317138225 | (37.7684295828689, -122.449317138225) | |||
73080 | 73080 | 208074 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994748.8803900005 | 2095031.81828 | 37.732257074696705 | -122.460523248557 | (37.7322570746967, -122.460523248557) | |||
134696 | 134696 | 208073 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 110 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5994756.9312 | 2095079.7197900002 | 37.732389063688395 | -122.46049888501999 | (37.7323890636884, -122.46049888502) | |||
23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) |
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");