Street_Tree_List

Data source: data.sfgov.org

2,202 rows where qSpecies = 55 sorted by Longitude

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
7848 51578 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/04/2005 12:00:00 AM     Permit Number 47872          
10202 173900 Private 5 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
10204 173902 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
12636 99746 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4250 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
185883 67262 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 511 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1992 12:00:00 AM 6   Permit Number 30729 5981280.933019999 2112230.5095 37.7786957851972 -122.508360365452 (37.7786957851972, -122.508360365452)
171311 67223 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 555 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1992 12:00:00 AM 6   Permit Number 30682 5981290.9854 2111950.9362 37.7779287520405 -122.508304833393 (37.7779287520405, -122.508304833393)
70184 67244 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 5524 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1992 12:00:00 AM 7   Permit Number 30708 5981494.88729 2111682.33433 37.7772032645806 -122.50757954173599 (37.7772032645806, -122.507579541736)
70732 46972 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1686 44th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2002 12:00:00 AM 2   Permit Number 44991 5982549.0126 2103652.333 37.755217228081996 -122.50333832645 (37.755217228082, -122.50333832645)
50486 46971 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1686 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2002 12:00:00 AM 2   Permit Number 44991 5982549.6238 2103640.11 37.7551837030962 -122.50333530778 (37.7551837030962, -122.50333530778)
71064 183299 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1286 42nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5983077.482999999 2106392.3859 37.7627716918826 -122.501713459776 (37.7627716918826, -122.501713459776)
160628 183298 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1286 42nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5983077.482999999 2106384.7622 37.762750759369105 -122.501712895715 (37.7627507593691, -122.501712895715)
56852 183625 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1431 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983375.6866 2105398.8736 37.7600612994594 -122.50060862808701 (37.7600612994594, -122.500608628087)
122515 100230 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 701X 39th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5983807.86909 2110960.60417 37.7753575879766 -122.49952497559799 (37.7753575879766, -122.499524975598)
19637 100232 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 701X 39th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5983809.619390001 2110917.38856 37.775239033091104 -122.499515726535 (37.7752390330911, -122.499515726535)
68444 184122 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3340 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983807.3681 2104294.0393 37.7570530669968 -122.49903404016001 (37.7570530669968, -122.49903404016)
154101 62594 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 735 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 9   Permit Number 22900 5984433.86075 2110817.8986299997 37.7750024687546 -122.497349020618 (37.7750024687546, -122.497349020618)
159008 62593 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 731 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 9   Permit Number 22899 5984434.98291 2110845.2368799997 37.7750775975018 -122.49734715750401 (37.7750775975018, -122.497347157504)
121186 62592 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 763 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM     Permit Number 22898 5984437.65774708 2110651.26442232 37.7745451616246 -122.497323582278 (37.7745451616246, -122.497323582278)
64603 62591 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 759 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 9   Permit Number 22897 5984439.68457 2110661.64848 37.774573792054795 -122.497317337939 (37.7745737920548, -122.497317337939)
75651 118275 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 763 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5984440.01732 2110639.37608 37.7745126579414 -122.497314542381 (37.7745126579414, -122.497314542381)
41938 62597 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 765 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 7   Permit Number 22903 5984441.0146 2110622.99108 37.7744677278845 -122.49730988283301 (37.7744677278845, -122.497309882833)
158341 118272 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 801 37th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5984451.19382 2110333.53689 37.7736735662944 -122.497253299741 (37.7736735662944, -122.497253299741)
26884 54531 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 855 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/1972 12:00:00 AM 12   Permit Number 10326 5984466.31691 2110015.99536 37.7728025745037 -122.497177542996 (37.7728025745037, -122.497177542996)
175876 118089 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 7049 Geary Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 1ft   5985075.84275 2112426.03783 37.7794555626476 -122.49524691703199 (37.7794555626476, -122.495246917032)
24921 185624 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2100 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985032.5384 2100289.574 37.74612969593421 -122.49450180509399 (37.7461296959342, -122.494501805094)
38825 186910 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2700 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985181.9251 2096700.884 37.7362848611965 -122.49372085206998 (37.7362848611965, -122.49372085207)
40802 182830 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1811 34th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5985639.2314 2102838.2271 37.7531630922797 -122.49259163632401 (37.7531630922797, -122.492591636324)
159993 119447 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 895 32nd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5986012.28825 2109834.94123 37.7723959307274 -122.49181659590599 (37.7723959307274, -122.491816595906)
172508 182848 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1795 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5985939.7457 2103040.5574 37.7537362025059 -122.491567304651 (37.7537362025059, -122.491567304651)
130474 119507 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 725 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5986293.694519999 2110943.52758 37.7754562387381 -122.49092478893101 (37.7754562387381, -122.490924788931)
65846 37203 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1574 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM 5   Permit Number 39770 5986243.4033 2104539.0139 37.7578682946863 -122.49062744276699 (37.7578682946863, -122.490627442767)
151314 119942 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 346 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5986553.230140001 2113597.32948 37.7827579817147 -122.490222261455 (37.7827579817147, -122.490222261455)
180317 185606 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2123 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5987259.0828 2100808.0996 37.7476834885004 -122.48684086956699 (37.7476834885004, -122.486840869567)
179715 120187 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 218 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5987760.31768 2114496.30361 37.7852967290916 -122.486112314519 (37.7852967290916, -122.486112314519)
148718 59149 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 218 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/1980 12:00:00 AM 7   Permit Number 18458 5987761.12595 2114471.82373 37.7852295614332 -122.48610772054501 (37.7852295614332, -122.486107720545)
175991 101635 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1800X 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5987855.0174 2102962.611 37.753633925344296 -122.484938226474 (37.7536339253443, -122.484938226474)
122091 114098 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 219x VIDAL DR 1 Front Yard : Cutout 8 Tree 1 Private 1     40     5987664.0 2090565.0 37.719582202213104 -122.48468943736401 (37.7195822022131, -122.484689437364)
88441 114094 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 239x VIDAL DR 1 Front Yard : Yard 7 Tree 1 Private 1     24     5987668.0 2090475.0 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602)
184181 120484 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2309 Lake St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 1ft   5988270.499009999 2114625.30582 37.785680652510294 -122.48435672889299 (37.7856806525103, -122.484356728893)
64567 120483 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2309 Lake St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5988277.53401 2114625.15663 37.7856806525102 -122.48433237916201 (37.7856806525102, -122.484332379162)
33362 55257 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 810 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/1972 12:00:00 AM 5   Permit Number 11179 5988221.44369 2110421.88962 37.7741363990758 -122.48421806494801 (37.7741363990758, -122.484218064948)
58329 120302 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 361 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   5988369.83373 2113569.61422 37.7827878063085 -122.483935624743 (37.7827878063085, -122.483935624743)
124121 12823 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/2007 12:00:00 AM 3 5   5988577.51702 2114639.82314 37.785738385289896 -122.483295611932 (37.7857383852899, -122.483295611932)
68485 120482 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 1ft   5988588.087169999 2114640.4078900004 37.7857406059941 -122.483259085533 (37.7857406059941, -122.483259085533)
54144 120481 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 1ft   5988593.25091 2114641.37666 37.7857435664695 -122.48324129171101 (37.7857435664695, -122.483241291711)
157541 120479 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5988612.47401 2114641.5086 37.785745047419 -122.48317479571301 (37.785745047419, -122.483174795713)
69652 120478 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5988614.91495 2114641.72629 37.78574578718071 -122.483166366817 (37.7857457871807, -122.483166366817)
147156 182589 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2483 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5988272.3462 2098420.0243 37.741185487105 -122.483162087393 (37.741185487105, -122.483162087393)
185708 120477 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5988623.03819 2114641.82381 37.785746527658 -122.483138270198 (37.785746527658, -122.483138270198)
168055 120397 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 101 23rd Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 1ft   5988633.138590001 2114628.42785 37.785710333915404 -122.48310234386899 (37.7857103339154, -122.483102343869)
182263 120396 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 101 23rd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 1ft   5988633.9259 2114634.88666 37.7857281137897 -122.48310009361099 (37.7857281137897, -122.483100093611)
177288 101277 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2323 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5988481.6146 2106443.4757 37.7632279152074 -122.48302644728001 (37.7632279152074, -122.48302644728)
149295 120400 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 163 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5988653.91402 2114240.5156099997 37.7846464457785 -122.483002026322 (37.7846464457785, -122.483002026322)
154151 101278 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2323 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   5988527.6084 2106443.4757 37.763230591454395 -122.482867371906 (37.7632305914544, -122.482867371906)
11487 110355 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2300 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5988563.2444 2106497.4984 37.763380996470005 -122.482748079472 (37.76338099647, -122.482748079472)
32562 183926 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1595 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5988583.1369 2101004.688 37.7483003735732 -122.482276819356 (37.7483003735732, -122.482276819356)
29382 183930 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1595 Quintara St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5988704.6498 2101009.2638 37.748320004874 -122.48185697108299 (37.748320004874, -122.481856971083)
168157 101109 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1790 24th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3 Permit Number 14067 5988776.9552 2103216.747 37.754385370533704 -122.48176861229099 (37.7543853705337, -122.481768612291)
187811 101108 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1790 24th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3X3 Permit Number 14067 5988777.5028 2103198.1315 37.754334289199704 -122.481765355128 (37.7543342891997, -122.481765355128)
44679 101107 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1790 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3X3 Permit Number 14067 5988779.1453 2103160.9003 37.7542321578078 -122.48175694812299 (37.7542321578078, -122.481756948123)
60756 56836 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1790 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/1974 12:00:00 AM 2 3X3 Permit Number 14067 5988782.4304 2103136.262 37.7541646986668 -122.48174378301701 (37.7541646986668, -122.481743783017)
66400 183931 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1595 Quintara St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5988739.7309 2101009.2638 37.748322044963395 -122.48173566297301 (37.7483220449634, -122.481735662973)
164311 181320 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2130 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5989076.012999999 2106520.0924 37.7634728536567 -122.48097625438999 (37.7634728536567, -122.48097625439)
99192 101266 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2126 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989175.0 2106519.0 37.7634756077712 -122.48063381405599 (37.7634756077712, -122.480633814056)
26544 101281 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2049 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   5989322.9543 2106470.5284 37.763351115778796 -122.48011854571301 (37.7633511157788, -122.480118545713)
151635 101284 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2034 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5989388.4992 2106533.1127 37.7635267635243 -122.479896429915 (37.7635267635243, -122.479896429915)
107084 101265 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2034 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989459.10715 2106523.8610900003 37.7635054630097 -122.47965154526001 (37.7635054630097, -122.47965154526)
57258 61503 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 174 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/1986 12:00:00 AM 8   Permit Number 23383 5989631.93083 2114222.6944 37.784654374553206 -122.479617149177 (37.7846543745532, -122.479617149177)
34167 181337 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1943 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5989659.6191 2106483.3237 37.7634058040829 -122.478955080908 (37.7634058040829, -122.478955080908)
10520 95069 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1924 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12     5989718.6012 2106543.0694 37.7635732745448 -122.478755452983 (37.7635732745448, -122.478755452983)
145747 101261 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1945 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989742.0 2106485.0 37.763415190264894 -122.478670277794 (37.7634151902649, -122.478670277794)
47167 182701 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1706 21st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5989689.5329 2103706.6241 37.75578346921429 -122.478648542868 (37.7557834692143, -122.478648542868)
60829 101260 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1900 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5989805.9135 2106546.133 37.7635867556905 -122.47845369468399 (37.7635867556905, -122.478453694684)
24097 177096 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 0 Serrano Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32     5989524.60255 2090740.4518099998 37.720172132521206 -122.47827090148199 (37.7201721325212, -122.478270901482)
55289 177095 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 0 Serrano Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     48     5989637.49515 2090738.06528 37.720172132515 -122.47788049948 (37.720172132515, -122.47788049948)
63108 56420 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 231 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/1973 12:00:00 AM 7   Permit Number 12580 5990219.564180001 2113818.4640099998 37.783578588527796 -122.47755460021799 (37.7835785885278, -122.477554600218)
178868 56417 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 222 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/1973 12:00:00 AM 10   Permit Number 12577 5990267.02613 2113888.22786 37.783772894624 -122.47739550229299 (37.783772894624, -122.477395502293)
132975 56418 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 226 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/1973 12:00:00 AM 9   Permit Number 12578 5990267.28978 2113858.89022 37.783692356954205 -122.477392445306 (37.7836923569542, -122.477392445306)
165885 56421 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 232 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/1973 12:00:00 AM 12 5x5 Permit Number 12581 5990270.934780001 2113836.22748 37.7836303428936 -122.47737817827 (37.7836303428936, -122.47737817827)
33941 40560 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 458 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/06/1999 12:00:00 AM 7   Permit Number 41604 5990324.44539 2112242.31069 37.779256995112 -122.47707654197399 (37.779256995112, -122.477076541974)
74160 122271 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1600 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5990587.5386 2111332.78753 37.776774954972204 -122.476099955577 (37.7767749549722, -122.476099955577)
135631 122270 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1600 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5990596.49847 2111330.4876599996 37.7767691597055 -122.47606879302 (37.7767691597055, -122.47606879302)
158754 67388 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 779 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1992 12:00:00 AM 12   Permit Number 30885 5990666.23465 2110099.72843 37.7733938754744 -122.475737660544 (37.7733938754744, -122.475737660544)
118589 34242 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1263 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/1997 12:00:00 AM     Permit Number 38052 5990773.84225381 2106807.51859079 37.7643605962692 -122.47512505139099 (37.7643605962692, -122.475125051391)
41939 207892 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2119 18th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5990666.05125 2100929.33737 37.7482144184726 -122.47506873135299 (37.7482144184726, -122.475068731353)
164052 55004 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 585 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/1972 12:00:00 AM 9   Permit Number 10882 5990928.49024 2111392.95682 37.7769599278948 -122.474924907094 (37.7769599278948, -122.474924907094)
170030 122095 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 585 16th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5990929.30413 2111377.25898 37.776916873099 -122.474920945501 (37.776916873099, -122.474920945501)
187706 55001 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 546 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/1972 12:00:00 AM 12   Permit Number 10879 5990967.23553 2111663.9992 37.777706381155205 -122.474810664746 (37.7777063811552, -122.474810664746)
150383 56174 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 701 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/1973 12:00:00 AM 9   Permit Number 12282 5990956.32694 2110582.1012 37.774735153466295 -122.474769414984 (37.7747351534663, -122.474769414984)
136063 122093 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 701 16th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5990957.61701 2110561.8313599997 37.774679572778204 -122.474763472642 (37.7746795727782, -122.474763472642)
172427 56173 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 680 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/1973 12:00:00 AM 9   Permit Number 12281 5990998.5556 2110774.78809 37.7752666659576 -122.474637404879 (37.7752666659576, -122.474637404879)
46096 122133 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     5991114.065719999 2115007.37065 37.7868948615896 -122.474546795399 (37.7868948615896, -122.474546795399)
34798 122131 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     5991115.120209999 2115013.7594 37.786912464412104 -122.47454361357 (37.7869124644121, -122.47454361357)
167324 122130 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19     5991115.18782 2115016.9633400002 37.7869212654547 -122.474543613569 (37.7869212654547, -122.474543613569)
167000 122135 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20     5991115.45698 2114997.03818 37.78686657212 -122.47454122766099 (37.78686657212, -122.474541227661)
44820 122132 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     5991115.98152 2115010.99351 37.7869049199545 -122.47454043173401 (37.7869049199545, -122.474540431734)
182203 122137 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     5991115.84231 2114982.60549 37.786826966306 -122.47453884083001 (37.786826966306, -122.47453884083)
155404 122134 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     5991116.74625 2115003.65081 37.78688480325761 -122.4745372499 (37.7868848032576, -122.4745372499)
24194 122139 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     5991116.38675 2114975.72508 37.7868081061645 -122.474536454895 (37.7868081061645, -122.474536454895)
186663 122136 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     5991117.00305 2114994.0290099997 37.786858399358294 -122.47453565898 (37.7868583993583, -122.47453565898)

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