home / trees

Street_Tree_List

Data source: data.sfgov.org

90 rows where qSpecies = 59

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
299 100307 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 202X Hartford St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 52417 6002676.8 2104706.1 37.7592732879998 -122.43380587713499 (37.7592732879998, -122.433805877135) 2 4 5 28862 3
300 100308 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 202X Hartford St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 52417 6002676.8 2104706.1 37.7592732879998 -122.43380587713499 (37.7592732879998, -122.433805877135) 2 4 5 28862 3
5879 106776 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 202X Hartford St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 4x4 Permit Number 769790 6002676.8 2104706.1 37.7592732879998 -122.43380587713499 (37.7592732879998, -122.433805877135) 2 4 5 28862 3
27584 129682 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 2222 Lyon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 Width 4ft   5999361.98488 2116489.3764299997 37.791438495331796 -122.446117638238 (37.7914384953318, -122.446117638238) 13 6 1 29490 27
62961 191510 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 900x Carolina St 34 Median : Yard 11 Tree 1 DPW 1     26     6012478.66144 2103273.09419 37.7558899046023 -122.399805455861 (37.7558899046023, -122.399805455861) 10 3 8 28856 29
79518 208016 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 2348 Funston Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 4ft   5992345.588280001 2099437.95609 37.7442166639716 -122.469152467524 (37.7442166639716, -122.469152467524) 1 8 4 29491 40
79519 208017 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 133 Westgate Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 3ft   5993400.26342 2093895.06859 37.7290581627904 -122.465103152187 (37.7290581627904, -122.465103152187) 9 8 4 59 40
79520 208018 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 1268 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 3ft   5994573.78905 2106877.28551 37.764771661314896 -122.461987252204 (37.7647716613149, -122.461987252204) 15 5 11 56 12
98922 227522 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 749 Dolores St 8 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     24 Width 8ft   6005045.57864 2104083.12055 37.7576968656229 -122.425569150194 (37.7576968656229, -122.425569150194) 2 4 5 28859 19
98923 227523 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 3450 26th St 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     4 Width 6ft   6006737.2033 2100885.725 37.7490129885555 -122.419491968004 (37.7490129885555, -122.419491968004) 2 4 7 28859 19
98924 227524 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 3458 26th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6006695.80913 2100883.44136 37.7490043865639 -122.419634947601 (37.7490043865639, -122.419634947601) 2 4 7 28859 19
98925 227525 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 705 Douglass St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 Width 3ft   6001257.1165 2102241.08377 37.7524242870632 -122.438539201525 (37.7524242870632, -122.438539201525) 2 4 5 28862 22
98926 227526 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 705 Douglass St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6001255.81284 2102255.85885 37.7524647817245 -122.438544768324 (37.7524647817245, -122.438544768324) 2 4 5 28862 22
98927 227527 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 18 Worth St 1 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     2 Width 4ft   6000853.892999999 2103182.27868 37.7549856353975 -122.440001092669 (37.7549856353975, -122.440001092669) 2 4 5 28862 22
98928 227528 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 18 Worth St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2     3 Width 4ft   6000854.651000001 2103166.63578 37.7549427269363 -122.439997349707 (37.7549427269363, -122.439997349707) 2 4 5 28862 22
98929 227529 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 4297 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6001280.54465 2102294.52512 37.752572356836204 -122.438462011837 (37.7525723568362, -122.438462011837) 2 4 5 28862 22
98931 227530 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 25 Caselli Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 3ft   6000951.522369999 2104906.4844299997 37.75972544210779 -122.439787074722 (37.7597254421078, -122.439787074722) 2 4 5 28862 3
98932 227531 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 202 Hartford St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 3ft   6002677.00253 2104676.70583 37.75919259017461 -122.433803075747 (37.7591925901746, -122.433803075747) 2 4 5 28862 3
98933 227532 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 202 Hartford St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 3ft   6002679.72985 2104658.05028 37.759141521284796 -122.433792309982 (37.7591415212848, -122.433792309982) 2 4 5 28862 3
98934 227533 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 202 Hartford St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 Width 3ft   6002683.27293 2104635.8349599997 37.759080724411504 -122.43377846851999 (37.7590807244115, -122.43377846852) 2 4 5 28862 3
98935 227534 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 310 Liberty St 20 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     14 Width 3ft   6004116.82698 2103937.8336 37.757245420345896 -122.428770797837 (37.7572454203459, -122.428770797837) 2 4 5 28862 3
98936 227535 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 433 Liberty St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 Width 3ft   6003472.7376 2103874.65169 37.7570354628405 -122.430993799639 (37.7570354628405, -122.430993799639) 2 4 5 28862 3
132914 32238 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 800 Colby St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/22/1995 12:00:00 AM 1   Permit Number 35555 6009122.52689 2090393.35811 37.7203372759166 -122.410502667675 (37.7203372759166, -122.410502667675) 9 3 7 309 28
133777 33035 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 494 Bartlett St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50595 6006779.65662971 2100908.40918731 37.7490776652966 -122.41934677281 (37.7490776652966, -122.41934677281) 2 4 7 28859 19
141119 39790 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 50 San Jose Ave 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/19/1999 12:00:00 AM     Permit Number 41142 6006177.81610853 2102875.29261487 37.7544443606741 -122.42156762045201 (37.7544443606741, -122.421567620452) 2 4 5 28859 19
142812 41375 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 174 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/09/2000 12:00:00 AM     Permit Number 42012 5999838.35184821 2087267.05856995 37.7112283031088 -122.44237060256701 (37.7112283031088, -122.442370602567) 9 7 6 28861 5
145813 4414 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 1117 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/03/1992 12:00:00 AM 4 1X1   6004464.79166 2102375.2261799998 37.7529745552411 -122.42745608254299 (37.7529745552411, -122.427456082543) 2 4 5 28862 22
150409 48403 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 137 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/24/2002 12:00:00 AM     Permit Number 45784 5999838.90671346 2087440.10998802 37.7117034951385 -122.442381100461 (37.7117034951385, -122.442381100461) 9 7 6 28861 5
156079 53681 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 3676 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/23/1989 12:00:00 AM 12 7x9 Permit Number 28114 6005126.00914316 2104896.86340653 37.7599357563315 -122.42534889488701 (37.7599357563315, -122.425348894887) 2 4 5 28859 19
156133 5373 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 267 Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     36 3X3   6004889.68559 2106830.22133 37.7652309432866 -122.426303875628 (37.7652309432866, -122.426303875628) 8 4 5 28853 19
156176 53770 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 316 San Benito Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/12/1996 12:00:00 AM     Permit Number 9456 5992852.04223281 2094739.01017834 37.7313437896565 -122.46705971241 (37.7313437896565, -122.46705971241) 9 8 4 59 40
156828 5439 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 500X Dolores St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   03/01/1990 12:00:00 AM 45 6   6004897.2550099995 2105174.4218599997 37.7606849395651 -122.426159805147 (37.7606849395651, -122.426159805147) 2 4 5 28862 3
156890 5445 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 500X Dolores St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   03/20/1990 12:00:00 AM 8 6   6004913.51654 2104964.38719 37.76010915314279 -122.426088611215 (37.7601091531428, -122.426088611215) 2 4 5 28862 3
156975 5453 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 553 Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 6X6   6004986.22513 2105148.12108 37.7606177521254 -122.42585022520399 (37.7606177521254, -122.425850225204) 2 4 5 28859 19
158030 55504 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 869 Douglass St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/31/1992 12:00:00 AM     Permit Number 27152 6001313.84664035 2101330.48409718 37.7499272254089 -122.438277790254 (37.7499272254089, -122.438277790254) 2 4 5 28862 22
159908 5725 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 1676 Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 4X4   6005265.5295 2098569.21573 37.7425693811872 -122.424416284994 (37.7425693811872, -122.424416284994) 2 7 5 63 22
161193 58468 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 731 Clayton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/01/1997 12:00:00 AM     Permit Number 32215 5998538.83594579 2108065.94626606 37.7682629016755 -122.448358849843 (37.7682629016755, -122.448358849843) 15 5 11 29492 9
161199 58473 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 755 Clayton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/09/1993 12:00:00 AM   5x4 Permit Number 32218 5998560.64278981 2107909.72137719 37.767835194479396 -122.448272171383 (37.7678351944794, -122.448272171383) 15 5 11 29492 9
161581 58827 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 761 Clayton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/06/2003 12:00:00 AM     Permit Number 18081 5998566.09450379 2107870.66513368 37.767728267607204 -122.448250501912 (37.7677282676072, -122.448250501912) 15 5 11 29492 9
161759 59007 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 3731 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/17/1993 12:00:00 AM     Permit Number 29743 6005443.80886724 2104276.22523779 37.75824957931761 -122.42420563843099 (37.7582495793176, -122.424205638431) 2 4 5 28859 19
162125 59346 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 526 Lyon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/22/1996 12:00:00 AM     Permit Number 18694 6000169.01235763 2110692.10451001 37.7755667359424 -122.44290885654499 (37.7755667359424, -122.442908856545) 15 5 11 29492 16
162378 59580 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 157 Vicksburg St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/07/1981 12:00:00 AM     Permit Number 18972 6004144.08144051 2102300.97252485 37.752752527797206 -122.42855986736 (37.7527525277972, -122.42855986736) 2 4 5 28862 22
163699 60827 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 4248 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/19/1999 12:00:00 AM     Permit Number 25330 6001569.00146643 2102360.55614987 37.752770066010704 -122.437469208461 (37.7527700660107, -122.437469208461) 2 4 5 28862 22
165238 62266 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 107 Steiner St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/15/1994 12:00:00 AM     Permit Number 28558 6003332.16344898 2108632.83425409 37.770092317262296 -122.43181968917801 (37.7700923172623, -122.431819689178) 15 9 5 29492 9
165501 62509 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 30 Worth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/11/1986 12:00:00 AM     Permit Number 22685 6000849.16262918 2103158.67771698 37.7549205635855 -122.440015759403 (37.7549205635855, -122.440015759403) 2 4 5 28862 22
165503 62510 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 40 Worth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/11/1986 12:00:00 AM     Permit Number 22686 6000851.23665541 2103119.64379278 37.754813503958104 -122.440005788129 (37.7548135039581, -122.440005788129) 2 4 5 28862 22
165504 62511 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 45 Worth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/11/1986 12:00:00 AM     Permit Number 22687 6000904.22158412 2103102.48758677 37.7547694133198 -122.43982132206101 (37.7547694133198, -122.439821322061) 2 4 5 28862 22
165505 62512 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 47 Worth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/11/1986 12:00:00 AM     Permit Number 22688 6000904.62792341 2103094.84013439 37.7547484383972 -122.43981936856501 (37.7547484383972, -122.439819368565) 2 4 5 28862 22
165506 62513 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 48 Worth St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/11/1986 12:00:00 AM     Permit Number 22689 6000852.895877 2103088.41664199 37.7547278562227 -122.43999781112801 (37.7547278562227, -122.439997811128) 2 4 5 28862 22
166113 63076 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 199 Moultrie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/21/1986 12:00:00 AM     Permit Number 23555 6007806.32049195 2098166.67321626 37.7416072398469 -122.415602454818 (37.7416072398469, -122.415602454818) 2 7 7 28859 2
166301 63249 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 348 Lexington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/13/1986 12:00:00 AM     Permit Number 23801 6006507.15053837 2104074.67156974 37.7577561425846 -122.420513825277 (37.7577561425846, -122.420513825277) 2 4 7 28859 19
166305 63252 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 329 Lexington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/21/1987 12:00:00 AM     Permit Number 23804 6006551.99209013 2104189.58958185 37.7580742077609 -122.420366900872 (37.7580742077609, -122.420366900872) 2 4 7 28859 19
166306 63253 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 347 Lexington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/21/1987 12:00:00 AM     Permit Number 23805 6006558.34152348 2104089.11498703 37.7577986856169 -122.420337810485 (37.7577986856169, -122.420337810485) 2 4 7 28859 19
166332 63278 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 359 Lexington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/26/1987 12:00:00 AM     Permit Number 23839 6006562.57447992 2104022.1319099 37.7576150041382 -122.42031841700899 (37.7576150041382, -122.420318417009) 2 4 7 28859 19
166901 63800 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 98 Putnam St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/01/1997 12:00:00 AM     Permit Number 30485 6009121.91960633 2096902.39222229 37.7382096636994 -122.41096426405198 (37.7382096636994, -122.410964264052) 10 7 7 28859 2
167075 63971 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 464 Jersey St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 09/19/1987 12:00:00 AM       6002138.24458134 2101514.59186962 37.7504795961936 -122.435440154372 (37.7504795961936, -122.435440154372) 2 4 5 28862 22
167616 64486 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 1760 Mason St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/02/1995 12:00:00 AM     Permit Number 25361 6009183.88964129 2119335.0439705 37.799807995554296 -122.41233512381599 (37.7998079955543, -122.412335123816) 3 1 10 308 4
167936 64791 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 235 Pierce St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/14/1995 12:00:00 AM     Permit Number 25787 6002748.20782442 2109342.92244592 37.7720089245306 -122.43389034537701 (37.7720089245306, -122.433890345377) 15 5 11 29492 9
168413 65252 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 992 Florida St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/26/1989 12:00:00 AM     Permit Number 28051 6009395.74802139 2103403.69283522 37.7560761510907 -122.41047644187 (37.7560761510907, -122.41047644187) 2 4 7 28859 19
168528 65358 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 123 Conrad St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 09/30/1989 12:00:00 AM     Permit Number 28193 6001809.60745082 2096649.18793885 37.737101670399205 -122.43622845577299 (37.7371016703992, -122.436228455773) 2 7 5 63 7
168889 65699 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 201 Allison St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/17/1990 12:00:00 AM     Permit Number 28628 6000097.30491035 2087663.87118265 37.7123326179359 -122.441504055389 (37.7123326179359, -122.441504055389) 9 7 6 28861 5
168934 65740 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 131 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/20/1990 12:00:00 AM     Permit Number 28676 5999831.15536745 2087464.99186701 37.7117713733875 -122.44240967633301 (37.7117713733875, -122.442409676333) 9 7 6 28861 5
168935 65741 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 150 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/20/1990 12:00:00 AM     Permit Number 28678 5999807.34647383 2087366.58605487 37.711499816004896 -122.442484905562 (37.7114998160049, -122.442484905562) 9 7 6 28861 5
168936 65742 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 156 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/20/1990 12:00:00 AM     Permit Number 28679 5999815.09781742 2087341.70418364 37.7114319377923 -122.442456329735 (37.7114319377923, -122.442456329735) 9 7 6 28861 5
168937 65743 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 161 Concord St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/20/1990 12:00:00 AM     Permit Number 28700 5999869.91209267 2087340.5824876 37.7114319821081 -122.442266797514 (37.7114319821081, -122.442266797514) 9 7 6 28861 5
169116 65912 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 1319 06th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/04/1990 12:00:00 AM     Permit Number 28921 5994225.84250459 2106529.43291316 37.7637965106849 -122.46316545767401 (37.7637965106849, -122.463165457674) 1 5 11 56 12
169462 66230 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 122 Ashton Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/24/1990 12:00:00 AM     Permit Number 29327 5994183.35951866 2090739.39799628 37.7204385809106 -122.462167182155 (37.7204385809106, -122.462167182155) 9 8 6 28861 24
169835 66576 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 183 Edinburg St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/15/1991 12:00:00 AM     Permit Number 29766 6004051.78498145 2092614.17435811 37.7261495673942 -122.42818875391501 (37.7261495673942, -122.428188753915) 9 7 6 28861 5
170201 66929 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 175 Andover St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/07/1992 12:00:00 AM     Permit Number 31181 6007601.16481288 2097856.63104946 37.7407443985359 -122.41628986145399 (37.7407443985359, -122.416289861454) 2 7 7 28859 2
170329 67048 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 202X Hartford St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52417 6002670.77878077 2104705.7738753003 37.759272050861505 -122.433826678093 (37.7592720508615, -122.433826678093) 2 4 5 28862 3
170635 67336 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 616 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/22/1992 12:00:00 AM     Permit Number 30820 5993805.86166428 2111291.38109791 37.7768473564115 -122.46496389539301 (37.7768473564115, -122.464963895393) 11 6 2 54 11
171022 67695 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 64 Carmel St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/06/1995 12:00:00 AM     Permit Number 32214 5998556.66816134 2105411.31929459 37.7609749843529 -122.44810600505699 (37.7609749843529, -122.448106005057) 15 5 11 29492 12
171154 67819 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 132 Vicksburg St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/17/1992 12:00:00 AM     Permit Number 31475 6004088.24128484 2102368.84156133 37.7529357200137 -122.428757810552 (37.7529357200137, -122.428757810552) 2 4 5 28862 22
171296 67953 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 587 24th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/22/1993 12:00:00 AM     Permit Number 31669 5988423.51616993 2112003.2558784 37.778490152422705 -122.483635032376 (37.7784901524227, -122.483635032376) 11 6 2 55 26
171760 68388 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 4977 17th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/09/1993 12:00:00 AM 15   Permit Number 32213 5997544.8295208 2105597.02046098 37.7614269792514 -122.451618890925 (37.7614269792514, -122.451618890925) 15 5 11 29492 12
171763 68390 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 751 Clayton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/09/1993 12:00:00 AM     Permit Number 32217 5998557.00831722 2107935.75884853 37.767906478991 -122.448286617718 (37.767906478991, -122.448286617718) 15 5 11 29492 9
171955 68571 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 680 47th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/18/1993 12:00:00 AM     Permit Number 32462 5981371.58179768 2111111.81123309 37.775629511649704 -122.50796373535499 (37.7756295116497, -122.507963735355) 11 6 2 55 26
171956 68572 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 685 47th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/18/1993 12:00:00 AM     Permit Number 32463 5981320.71250249 2111079.78815826 37.7755385883149 -122.508137324272 (37.7755385883149, -122.508137324272) 11 6 2 55 26
172205 68802 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 39 Wawona St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/22/1993 12:00:00 AM     Permit Number 32743 5993216.60176137 2098854.68485021 37.7426654396593 -122.46609833981 (37.7426654396593, -122.46609833981) 1 8 4 59 40
176270 81485 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 1268 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50894 5994575.83487134 2106890.23144341 37.764807325258005 -122.46198111515 (37.764807325258, -122.46198111515) 15 5 11 56 12
176869 82867 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 243-245 08th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52430 6009431.77507071 2110559.3179918 37.775725872790204 -122.410857204902 (37.7757258727902, -122.410857204902) 8 2 9 28853 34
176870 82868 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 229- 08th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52430 6009387.0 2110633.0 37.775925675553296 -122.411017299189 (37.7759256755533, -122.411017299189) 8 2 9 28853 34
176933 82958 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 35 Caselli Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50805 6000912.41841684 2104895.69025966 37.7596935780473 -122.439921541658 (37.7596935780473, -122.439921541658) 2 4 5 28862 3
177099 83293 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 25 Caselli Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50806 6000965.01829306 2104898.82090875 37.759705168142396 -122.43973984968201 (37.7597051681424, -122.439739849682) 2 4 5 28862 3
177509 84039 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 1117-1119 Church St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/29/2008 12:00:00 AM     Permit Number 50428 6004461.93276532 2102391.33206178 37.753018616529005 -122.427467116446 (37.753018616529, -122.427467116446) 2 4 5 28862 22
177519 84061 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 4297 23rd St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50420 6001255.77068266 2102291.23804397 37.75256192209 -122.438547448801 (37.75256192209, -122.438547448801) 2 4 5 28862 22
177536 84102 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 4297 23rd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50420 6001255.77068266 2102291.23804397 37.75256192209 -122.438547448801 (37.75256192209, -122.438547448801) 2 4 5 28862 22
177537 84103 Permitted Site 2 Liquidambar orientalis :: Oriental Sweet Gum 59 4297 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50420 6001255.77068266 2102291.23804397 37.75256192209 -122.438547448801 (37.75256192209, -122.438547448801) 2 4 5 28862 22
177557 84124 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 1118 Brussels St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/05/2008 12:00:00 AM 6 3x3 Permit Number 50685 6011552.18251 2089642.5375 37.7184115873075 -122.402051338211 (37.7184115873075, -122.402051338211) 10 7 8 309 39
187520 95667 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 59 800 Colby St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/08/2011 12:00:00 AM 2 3x3 Permit Number 767425 6009127.32448 2090380.0074200002 37.7203008866705 -122.410485141671 (37.7203008866705, -122.410485141671) 9 3 7 309 28

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 116.372ms · Data source: data.sfgov.org