Street_Tree_List

Data source: data.sfgov.org

1,501 rows where qSpecies = 62 sorted by Location

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 ▼
1529 251578 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 6 Median : Cutout 11 Tree 1 DPW 2                    
5701 35451 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
6310 35452 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
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            
7488 35443 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
7802 35460 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
8146 35450 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
8339 37971 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 620 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40201          
8797 35455 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9539 35456 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9554 35448 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
9566 95785 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 347 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/2011 12:00:00 AM   3x3 Permit Number 767529          
9594 35445 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10262 35446 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10483 35442 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
10753 35454 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
11139 35047 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 700 Peninsula Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/1998 12:00:00 AM     Permit Number 38613          
11629 35449 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
12085 35458 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
12173 37972 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 624 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40202          
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            
14341 35444 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14595 35457 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14838 35048 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/1998 12:00:00 AM     Permit Number 38613          
15544 37973 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 630 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40203          
16105 35453 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
16221 35459 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
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            
17025 35447 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 790 Peninsula Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/1998 12:00:00 AM     Permit Number 38883          
77005 69406 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 791 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 8   Permit Number 33510 6002424.30927 2087088.10255 37.7108839820803 -122.43342011837 (37.7108839820803, -122.43342011837)
133317 177153 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 701 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6002643.53653 2087345.7216599998 37.711603783270704 -122.43268080909401 (37.7116037832707, -122.432680809094)
167014 177146 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 183 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010243.9758 2087974.1482400002 37.7137574284457 -122.406455788622 (37.7137574284457, -122.406455788622)
105098 30048 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Junipero Serra Blvd 29 Median : Cutout 11 Tree 1 DPW 2     3 3X3   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
105889 30047 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Junipero Serra Blvd 28 Median : Cutout 11 Tree 1 DPW 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
146267 30049 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1400X Junipero Serra Blvd 30 Median : Cutout 11 Tree 1 DPW 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
64816 177147 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 184 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010274.23891 2088006.9688799998 37.71384924022011 -122.406353498838 (37.7138492402201, -122.406353498838)
41501 109608 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 30 Curtis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6000500.58572 2088469.85865 37.7145686465987 -122.440167960077 (37.7145686465987, -122.440167960077)
117105 109646 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 30 CURTIS ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3   6000484.3 2088475.7 37.7145837584364 -122.44022466861401 (37.7145837584364, -122.440224668614)
162256 177150 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1100 Junipero Serra Blvd 13 : 4 Tree 1 Private 1     3 Width 0ft   5991357.8727400005 2088731.5467 37.7147624226096 -122.471787632218 (37.7147624226096, -122.471787632218)
52418 177149 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1100 Junipero Serra Blvd 12 : 4 Tree 1 Private 1     3 Width 0ft   5991352.53535 2088761.3617099999 37.714843978538205 -122.47180825186301 (37.7148439785382, -122.471808251863)
179602 208091 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 247 Lobos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994538.89775 2088695.72634 37.714847610008 -122.46079017812599 (37.714847610008, -122.460790178126)
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)
11071 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 500 Raymond Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
134358 200263 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 828x Jamestown Ave 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014881.06262 2088948.3619 37.7166907534629 -122.39049621274799 (37.7166907534629, -122.390496212748)
73104 200264 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 828x Jamestown Ave 6 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014856.837309999 2088987.16565 37.716795957049996 -122.390582658263 (37.71679595705, -122.390582658263)
18793 114373 Property Tree 7 Liquidambar styraciflua :: American Sweet Gum 62 805 GONZALEZ DR 1 Front Yard : Yard 7 Tree 1 Private 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
157992 200265 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 860x Jamestown Ave 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014784.79531 2089078.0954900002 37.7170416356268 -122.390838025257 (37.7170416356268, -122.390838025257)
63521 200266 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 860x Jamestown Ave 3 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014773.14657 2089094.60205 37.7170863130726 -122.39087944264999 (37.7170863130726, -122.39087944265)
26865 200267 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 860x Jamestown Ave 4 Median : Cutout 11 Tree 1 DPW 2     1 Width 5ft   6014763.4294300005 2089103.4873400002 37.7171101711671 -122.39091365107001 (37.7171101711671, -122.39091365107)
151014 200268 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 860x Jamestown Ave 10 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014637.958740001 2089223.7051900001 37.7174333029868 -122.39135574608801 (37.7174333029868, -122.391355746088)
50356 200269 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 860x Jamestown Ave 11 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014632.09061 2089229.7896900002 37.7174496841459 -122.39137645477501 (37.7174496841459, -122.391376454775)
51688 200270 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 860x Jamestown Ave 12 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014621.84489 2089234.87823 37.717463087626705 -122.39141222532 (37.7174630876267, -122.39141222532)
34340 200271 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 920x Jamestown Ave 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014518.22002 2089293.0618599998 37.7176170965211 -122.391774477626 (37.7176170965211, -122.391774477626)
39056 200272 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 920x Jamestown Ave 3 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014501.14248 2089299.14768 37.7176328589541 -122.39183393271401 (37.7176328589541, -122.391833932714)
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)
164766 200273 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 920x Jamestown Ave 10 Median : Cutout 11 Tree 1 DPW 2     3 Width 5ft   6014418.93045 2089354.50359 37.7177802911084 -122.392121973844 (37.7177802911084, -122.392121973844)
49142 200274 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 920x Jamestown Ave 11 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   6014408.1626699995 2089360.68754 37.7177966731557 -122.392159625791 (37.7177966731557, -122.392159625791)
109022 29640 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1110X Junipero Serra Blvd 13 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
110556 29641 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1110X Junipero Serra Blvd 14 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
144121 29639 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1110X Junipero Serra Blvd 12 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
189027 177145 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 646 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6001109.079969999 2090060.7156599998 37.718971408083796 -122.438178657041 (37.7189714080838, -122.438178657041)
9948 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 6 Higuera Ave 1 Front Yard : Cutout 8 Tree 1 Private 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
113595 114068 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 8 HIGUERA AVE 1 Front Yard : Yard 7 Tree 1 Private 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
86962 114103 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 5 ACEVEDO AVE 2 Front Yard : Yard 7 Tree 1 Private 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
103750 114102 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 7 ACEVEDO AVE 1 Front Yard : Yard 7 Tree 1 Private 1     18     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
81710 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 201 Gonzalez Dr   Front Yard : Yard 7 Tree 1 Private 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
72156 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 835 Gonzalez Dr 1 Front Yard : Yard 7 Tree 1 Private 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
99811 104936 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 837 Gonzalez Dr 1 Front Yard : Yard 7 Tree 1 Private 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
109347 104937 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 839 Gonzalez Dr 2 Front Yard : Yard 7 Tree 1 Private 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
114209 104934 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 805 Gonzalez Dr 1 Front Yard : Yard 7 Tree 1 Private 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
44961 208090 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 122 Ashton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5994177.92287 2090747.0249299998 37.720459209606396 -122.46218652760099 (37.7204592096064, -122.462186527601)
123544 95666 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 800 Colby St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2011 12:00:00 AM   3x3 Permit Number 767425 6009110.0 2090446.0 37.720481117261706 -122.41054968459 (37.7204811172617, -122.41054968459)
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)
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)
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)
28751 72246 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 418 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1996 12:00:00 AM 6     6002360.66039 2091027.7988900002 37.721697906115104 -122.433921526363 (37.7216979061151, -122.433921526363)
45277 208077 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 338 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995744.67706 2091237.28528 37.7218954350055 -122.456806235434 (37.7218954350055, -122.456806235434)
18117 11765 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Junipero Serra Blvd 3 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991272.34511 2091581.45548 37.7225826231682 -122.47229087392 (37.7225826231682, -122.47229087392)
20128 11766 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Junipero Serra Blvd 4 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 6X6   5991273.54078 2091606.60865 37.72265175674929 -122.47228857348101 (37.7226517567493, -122.472288573481)
21942 11767 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Junipero Serra Blvd 5 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991276.05264 2091631.0711599998 37.7227190701221 -122.472281672976 (37.7227190701221, -122.472281672976)
174064 177152 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 649 Hamilton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   6009816.38769 2091371.81115 37.7230627793063 -122.408173178961 (37.7230627793063, -122.408173178961)
169032 66942 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 645 Cambridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1992 12:00:00 AM 4   Permit Number 30268 6007235.19224 2091579.2151400002 37.7234873977973 -122.41711056590201 (37.7234873977973, -122.417110565902)
141526 66940 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 633 Cambridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/1992 12:00:00 AM 8   Permit Number 30266 6007221.66075 2091629.66903 37.7236251721365 -122.417160915365 (37.7236251721365, -122.417160915365)
88746 11784 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 810X Junipero Serra Blvd 16 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 6X6   5991252.992504 2092079.9575241 37.7239502662313 -122.472394094235 (37.7239502662313, -122.472394094235)
135648 208078 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 360 Ashton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5994204.15445 2092252.12785 37.7245933696677 -122.462204953795 (37.7245933696677, -122.462204953795)
129182 62460 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 360 Ashton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/1985 12:00:00 AM     Permit Number 22628 5994209.59395504 2092281.24653849 37.724673635737 -122.46218826108101 (37.724673635737, -122.462188261081)
172116 208079 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 370 Ashton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5994204.7092699995 2092293.8325900002 37.7247079127335 -122.462206059069 (37.7247079127335, -122.462206059069)
24703 208140 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 9 Keystone Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994042.19484 2092647.64079 37.7256700254358 -122.462793502527 (37.7256700254358, -122.462793502527)
38457 208084 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800x Junipero Serra Blvd 53 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991354.011469999 2092835.9648 37.726031920722605 -122.47209997035 (37.7260319207226, -122.47209997035)
31262 177151 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 183 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004046.6041 2092611.27045 37.7261413007669 -122.428206457066 (37.7261413007669, -122.428206457066)
150230 208085 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800x Junipero Serra Blvd 55 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   5991358.2999 2092881.5903900003 37.726157445407296 -122.47208846980301 (37.7261574454073, -122.472088469803)
25223 208086 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800x Junipero Serra Blvd 56 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5991357.47228 2092905.4597099999 37.7262229367261 -122.472093069866 (37.7262229367261, -122.472093069866)
19955 29580 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Junipero Serra Blvd 2 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991386.6913 2093344.7747799999 37.7274308773069 -122.47202406848 (37.7274308773069, -122.47202406848)
19813 29581 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500X Junipero Serra Blvd 3 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991390.5187800005 2093368.54568 37.7274963677541 -122.47201256884199 (37.7274963677541, -122.472012568842)
90967 208087 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 500x Junipero Serra Blvd 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   5991392.30049 2093421.51137 37.7276419014288 -122.472010268365 (37.7276419014288, -122.472010268365)
140520 29589 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 610X Junipero Serra Blvd 3 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991336.987432401 2093443.9543843998 37.7277003234109 -122.472203119704 (37.7277003234109, -122.472203119704)
91557 29978 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 610X Junipero Serra Blvd 5 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3x3   5991336.00972369 2093444.32433125 37.7277012826104 -122.47220652658001 (37.7277012826104, -122.47220652658)
101082 29979 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 610X Junipero Serra Blvd 6 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3x3   5991336.00972369 2093444.32433125 37.7277012826104 -122.47220652658001 (37.7277012826104, -122.47220652658)

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 901.308ms · Data source: data.sfgov.org