Street_Tree_List

Data source: data.sfgov.org

1,501 rows where qSpecies = 62 sorted by qAddress

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 251578 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 6 Median : Cutout 11 Tree 1 DPW 2                    
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 954.287ms · Data source: data.sfgov.org