Street_Tree_List

Data source: data.sfgov.org

856 rows where qSpecies = 97 sorted by Longitude

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
11938 19762 DPW Maintained 3 Ceratonia siliqua :: Carob 97 100 STAIRWAY16 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 30ST            
11951 19967 DPW Maintained 3 Ceratonia siliqua :: Carob 97 100 STAIRWAY41 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 25ST            
78897 20969 DPW Maintained 3 Ceratonia siliqua :: Carob 97 2002X Sunset Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
79162 20965 DPW Maintained 3 Ceratonia siliqua :: Carob 97 2002X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
109094 20967 DPW Maintained 3 Ceratonia siliqua :: Carob 97 2002X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
177476 32581 Permitted Site 1 Ceratonia siliqua :: Carob 97 1314 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 4   Permit Number 37055 5985876.1437 2106257.7648 37.762566049362704 -122.492024105228 (37.7625660493627, -122.492024105228)
63634 182440 Undocumented 2 Ceratonia siliqua :: Carob 97 1530 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5985926.0511 2104791.6519 37.7585434265078 -122.49174356193998 (37.7585434265078, -122.49174356194)
148086 182304 Undocumented 2 Ceratonia siliqua :: Carob 97 2531 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986925.2797 2105029.7497 37.759255527351606 -122.488305322992 (37.7592555273516, -122.488305322992)
134064 206001 Undocumented 2 Ceratonia siliqua :: Carob 97 1830 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5990646.261940001 2102911.1762200003 37.7536548815855 -122.47528182930701 (37.7536548815855, -122.475281829307)
122019 205987 Undocumented 2 Ceratonia siliqua :: Carob 97 1639 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541)
171108 206012 Undocumented 2 Ceratonia siliqua :: Carob 97 650 Vicente St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5990870.16608 2097736.47672 37.739459475161794 -122.474129983014 (37.7394594751618, -122.474129983014)
45525 206011 Undocumented 2 Ceratonia siliqua :: Carob 97 650 Vicente St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5990881.65673 2097736.82059 37.739461084972206 -122.47409027886299 (37.7394610849722, -122.474090278863)
172191 206010 Undocumented 2 Ceratonia siliqua :: Carob 97 650 Vicente St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5990906.39798 2097737.17838 37.7394635005399 -122.47400476141199 (37.7394635005399, -122.474004761412)
164290 206009 Undocumented 2 Ceratonia siliqua :: Carob 97 650 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5990946.443519999 2097737.21302 37.7394659152092 -122.47386630538 (37.7394659152092, -122.47386630538)
44285 206008 Undocumented 2 Ceratonia siliqua :: Carob 97 600 Vicente St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5990990.06403 2097739.22497 37.7394739659536 -122.47371563298701 (37.7394739659536, -122.473715632987)
74726 206007 Undocumented 2 Ceratonia siliqua :: Carob 97 600 Vicente St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991032.21326 2097741.2680200003 37.739482016692904 -122.473570049822 (37.7394820166929, -122.473570049822)
150091 206006 Undocumented 2 Ceratonia siliqua :: Carob 97 600 Vicente St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991049.3393 2097743.54574 37.7394892625221 -122.473511002145 (37.7394892625221, -122.473511002145)
157059 206005 Undocumented 2 Ceratonia siliqua :: Carob 97 600 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991064.94409 2097743.51009 37.7394900683054 -122.47345704553001 (37.7394900683054, -122.47345704553)
101854 114592 Undocumented 2 Ceratonia siliqua :: Carob 97 70 LOMITA AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5991433.0 2104626.0 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822)
126890 206004 Undocumented 2 Ceratonia siliqua :: Carob 97 10 Lomita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991469.80126 2104851.05791 37.7590289864229 -122.472575296214 (37.7590289864229, -122.472575296214)
121279 112815 Undocumented 2 Ceratonia siliqua :: Carob 97 10 LOMITA AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991472.0 2104830.0 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736)
186595 206002 Undocumented 2 Ceratonia siliqua :: Carob 97 1593 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991725.37276 2104496.31776 37.758069753342205 -122.47166556633199 (37.7580697533422, -122.471665566332)
34084 206003 Undocumented 2 Ceratonia siliqua :: Carob 97 1593 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991725.497880001 2104502.2556 37.7580860643266 -122.471665566325 (37.7580860643266, -122.471665566325)
117344 57469 Permitted Site 1 Ceratonia siliqua :: Carob 97 71 Cerritos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/08/1987 12:00:00 AM     Permit Number 24965 5992451.26080169 2092911.00734917 37.7263014049972 -122.46831233823299 (37.7263014049972, -122.468312338233)
33051 123914 Undocumented 2 Ceratonia siliqua :: Carob 97 389 09th Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993078.53663 2112857.8084299997 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963)
132092 206014 Undocumented 2 Ceratonia siliqua :: Carob 97 120 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992843.12782 2095854.05613 37.7344049138512 -122.467171573123 (37.7344049138512, -122.467171573123)
54347 206013 Undocumented 2 Ceratonia siliqua :: Carob 97 130 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5992845.13508 2095810.8192900002 37.7342863121439 -122.467161490835 (37.7342863121439, -122.467161490835)
187567 218314 Undocumented 2 Ceratonia siliqua :: Carob 97 437 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993129.70143 2099920.62697 37.7455872325622 -122.466476271275 (37.7455872325622, -122.466476271275)
60183 218315 Undocumented 2 Ceratonia siliqua :: Carob 97 437 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993144.55141 2099923.03964 37.7455947140337 -122.46642509806401 (37.7455947140337, -122.466425098064)
168692 205988 Undocumented 2 Ceratonia siliqua :: Carob 97 1469 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5993333.43827 2105504.18267 37.7609299931406 -122.46617747513099 (37.7609299931406, -122.466177475131)
65825 205992 Undocumented 2 Ceratonia siliqua :: Carob 97 452 Kenwood Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5993371.398019999 2093686.3141400001 37.728483309840996 -122.46518778469299 (37.728483309841, -122.465187784693)
45186 205991 Undocumented 2 Ceratonia siliqua :: Carob 97 452 Kenwood Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5993388.91946 2093682.37508 37.72847350453279 -122.465126926677 (37.7284735045328, -122.465126926677)
73260 205990 Undocumented 2 Ceratonia siliqua :: Carob 97 452 Kenwood Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5993405.09676 2093676.5167599998 37.7284583518695 -122.46507057606001 (37.7284583518695, -122.46507057606)
69557 205989 Undocumented 2 Ceratonia siliqua :: Carob 97 566 Dewey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 6ft   5994108.82044 2099457.01961 37.744370734026 -122.46305702188499 (37.744370734026, -122.463057021885)
176560 205994 Undocumented 2 Ceratonia siliqua :: Carob 97 334 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994253.11993 2101023.44894 37.7486800649323 -122.462671676761 (37.7486800649323, -122.462671676761)
154445 205993 Undocumented 2 Ceratonia siliqua :: Carob 97 334 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5994259.77922 2101011.29176 37.7486470679175 -122.46264776740401 (37.7486470679175, -122.462647767404)
119338 113383 Undocumented 2 Ceratonia siliqua :: Carob 97 146 CASTENADA AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   5994461.0 2101055.0 37.7487786662853 -122.46195512222401 (37.7487786662853, -122.461955122224)
34571 206020 Undocumented 2 Ceratonia siliqua :: Carob 97 146 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994480.54768 2101060.81011 37.7487957447457 -122.46188794817499 (37.7487957447457, -122.461887948175)
66533 206019 Undocumented 2 Ceratonia siliqua :: Carob 97 99 Merced Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5994816.51833 2099704.78199 37.745091768175605 -122.460627918846 (37.7450917681756, -122.460627918846)
43855 206018 Undocumented 2 Ceratonia siliqua :: Carob 97 99 Merced Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5994828.29695 2099714.01169 37.7451177882671 -122.460587859436 (37.7451177882671, -122.460587859436)
116284 2744 Permitted Site 1 Ceratonia siliqua :: Carob 97 1 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5995591.7347 2110770.58853 37.775520208006604 -122.458748349075 (37.7755202080066, -122.458748349075)
32711 124322 Undocumented 2 Ceratonia siliqua :: Carob 97 115 Jordan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5996192.87314 2113669.7360400003 37.7835150337529 -122.456878613619 (37.7835150337529, -122.456878613619)
51566 124321 Undocumented 2 Ceratonia siliqua :: Carob 97 115 Jordan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5996193.40211 2113658.2283900003 37.783483467186706 -122.45687595100901 (37.7834834671867, -122.456875951009)
43464 206016 Undocumented 2 Ceratonia siliqua :: Carob 97 1500 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5995893.6658 2094152.61505 37.7299087874515 -122.45650193453899 (37.7299087874515, -122.456501934539)
67325 206015 Undocumented 2 Ceratonia siliqua :: Carob 97 351 Montecito Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 3ft   5995922.8819 2094068.30815 37.7296789783055 -122.45639483786199 (37.7296789783055, -122.456394837862)
151522 206017 Undocumented 2 Ceratonia siliqua :: Carob 97 59 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5996580.0039099995 2094034.75678 37.72962455671671 -122.454120687124 (37.7296245567167, -122.454120687124)
91986 67186 Permitted Site 1 Ceratonia siliqua :: Carob 97 281 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1992 12:00:00 AM     Permit Number 30634 5996869.12207945 2106987.0610707 37.765204956904604 -122.454056265196 (37.7652049569046, -122.454056265196)
43510 225058 Undocumented 2 Ceratonia siliqua :: Carob 97 283 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996870.764690001 2106986.93981 37.76520471814 -122.454050575073 (37.76520471814, -122.454050575073)
55625 225059 Undocumented 2 Ceratonia siliqua :: Carob 97 245 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5997024.32382 2107012.23049 37.7652829636624 -122.453521279988 (37.7652829636624, -122.453521279988)
162230 225060 Undocumented 2 Ceratonia siliqua :: Carob 97 243 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5997087.67897 2106671.87912 37.76435207719771 -122.453277577199 (37.7643520771977, -122.453277577199)
1249 237914 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1001 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 Width 4ft   5997227.0 2107052.0 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368)
129912 225061 Undocumented 2 Ceratonia siliqua :: Carob 97 1289 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   5997502.5049 2105021.0962900002 37.7598432128005 -122.451723726786 (37.7598432128005, -122.451723726786)
31832 222918 Undocumented 2 Ceratonia siliqua :: Carob 97 140 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5997702.832359999 2107152.93734 37.7657081802151 -122.451184638974 (37.7657081802151, -122.451184638974)
100270 54886 Permitted Site 1 Ceratonia siliqua :: Carob 97 140 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/1972 12:00:00 AM   3x4 Permit Number 10751 5997750.13061777 2107162.33224107 37.7657366841835 -122.45102172287201 (37.7657366841835, -122.451021722872)
53992 222919 Undocumented 2 Ceratonia siliqua :: Carob 97 121 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5997880.24105 2107132.61559 37.765662537824895 -122.45056955843701 (37.7656625378249, -122.450569558437)
127787 58566 Permitted Site 1 Ceratonia siliqua :: Carob 97 119 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/1979 12:00:00 AM   3x3 Permit Number 17756 5997901.33257876 2107130.89979942 37.7656590338964 -122.450496484092 (37.7656590338964, -122.450496484092)
142476 68375 Permitted Site 1 Ceratonia siliqua :: Carob 97 175 Alma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM     Permit Number 32198 5997884.42699251 2106160.35589629 37.76299319850379 -122.45048498278999 (37.7629931985038, -122.45048498279)
68238 222920 Undocumented 2 Ceratonia siliqua :: Carob 97 957 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   5998076.5165 2106905.9783799998 37.765051481758 -122.449874352843 (37.765051481758, -122.449874352843)
177491 222921 Undocumented 2 Ceratonia siliqua :: Carob 97 957 Cole St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.44986610424601 (37.7649946607859, -122.449866104246)
59009 206021 Undocumented 2 Ceratonia siliqua :: Carob 97 42 Stanford Heights Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5997867.55836 2095818.65061 37.7345964514605 -122.449798003996 (37.7345964514605, -122.449798003996)
71127 222923 Undocumented 2 Ceratonia siliqua :: Carob 97 88 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5998162.74598 2106870.63901 37.764959382183704 -122.449573561064 (37.7649593821837, -122.449573561064)
35330 125967 Undocumented 2 Ceratonia siliqua :: Carob 97 3440 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   5998347.68841 2115559.3339299997 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485)
42030 206000 Undocumented 2 Ceratonia siliqua :: Carob 97 419 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5997987.32263 2094070.28162 37.729802697139604 -122.44925801953801 (37.7298026971396, -122.449258019538)
124297 59670 Permitted Site 1 Ceratonia siliqua :: Carob 97 98X PARNASSUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 15 3x3 Permit Number 32228 5998297.0 2106864.0 37.76494883262271 -122.449108733904 (37.7649488326227, -122.449108733904)
120218 51670 Permitted Site 1 Ceratonia siliqua :: Carob 97 848 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47948 5998713.82301338 2107188.47532501 37.765863591183 -122.44769041413299 (37.765863591183, -122.447690414133)
27876 222922 Undocumented 2 Ceratonia siliqua :: Carob 97 848 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5998725.13711 2107078.63003 37.7655626303238 -122.44764337315 (37.7655626303238, -122.44764337315)
35726 222928 Undocumented 2 Ceratonia siliqua :: Carob 97 912 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998758.16977 2106859.07637 37.764961679071796 -122.447513315894 (37.7649616790718, -122.447513315894)
140677 56842 Permitted Site 1 Ceratonia siliqua :: Carob 97 910 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/29/1992 12:00:00 AM 3   Permit Number 30536 5998759.08975741 2106864.1829233 37.76497575295679 -122.447510501506 (37.7649757529568, -122.447510501506)
90392 67184 Permitted Site 1 Ceratonia siliqua :: Carob 97 912 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1992 12:00:00 AM     Permit Number 30631 5998760.11857013 2106856.81248154 37.7649555743728 -122.447506412542 (37.7649555743728, -122.447506412542)
133409 222927 Undocumented 2 Ceratonia siliqua :: Carob 97 912 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5998760.527480001 2106841.60616 37.764913845009 -122.44750390358 (37.764913845009, -122.44750390358)
81979 56848 Permitted Site 1 Ceratonia siliqua :: Carob 97 1025 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/1974 12:00:00 AM   6x5 Permit Number 14082 5998817.86133668 2106377.94605096 37.763644027141396 -122.447272227776 (37.7636440271414, -122.447272227776)
174584 222924 Undocumented 2 Ceratonia siliqua :: Carob 97 1025 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5998822.080680001 2106365.6721900003 37.763610567293 -122.447256751019 (37.763610567293, -122.447256751019)
92019 94581 Permitted Site 1 Ceratonia siliqua :: Carob 97 1025 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5998825.0 2106371.0 37.763625362932 -122.44724703752199 (37.763625362932, -122.447247037522)
23379 222925 Undocumented 2 Ceratonia siliqua :: Carob 97 1025 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5998825.08997 2106348.09575 37.763562478748604 -122.44724507779499 (37.7635624787486, -122.447245077795)
97514 56845 Permitted Site 1 Ceratonia siliqua :: Carob 97 980 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/1974 12:00:00 AM   4x4 Permit Number 14078 5998833.42862215 2106621.08669964 37.7643125198309 -122.447235885769 (37.7643125198309, -122.447235885769)
174435 222926 Undocumented 2 Ceratonia siliqua :: Carob 97 980 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998842.04298 2106555.36385 37.7641325536076 -122.447201360861 (37.7641325536076, -122.447201360861)
163059 225062 Undocumented 2 Ceratonia siliqua :: Carob 97 139 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5998883.5307 2107364.0663900003 37.76635541778779 -122.44711607094601 (37.7663554177878, -122.447116070946)
167323 225063 Undocumented 2 Ceratonia siliqua :: Carob 97 247 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998979.478759999 2106681.18548 37.7644858801306 -122.44673506598998 (37.7644858801306, -122.44673506599)
185355 225064 Undocumented 2 Ceratonia siliqua :: Carob 97 253 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5998981.0777900005 2106664.05961 37.7644389481338 -122.446728303069 (37.7644389481338, -122.446728303069)
174545 205998 Undocumented 2 Ceratonia siliqua :: Carob 97 30 Molimo Dr 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5998781.20203 2096512.5772400002 37.736554040821204 -122.446689155601 (37.7365540408212, -122.446689155601)
57071 205997 Undocumented 2 Ceratonia siliqua :: Carob 97 30 Molimo Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5998801.07075 2096511.7970599998 37.736553033585295 -122.446620405109 (37.7365530335853, -122.446620405109)
127952 82121 Permitted Site 1 Ceratonia siliqua :: Carob 97 44 Molimo Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49840 5998809.17063994 2096527.78133102 37.7365973852663 -122.44659355011801 (37.7365973852663, -122.446593550118)
45915 205996 Undocumented 2 Ceratonia siliqua :: Carob 97 30 Molimo Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998822.4881 2096514.65172 37.736562095172296 -122.446546561796 (37.7365620951723, -122.446546561796)
157892 205995 Undocumented 2 Ceratonia siliqua :: Carob 97 30 Molimo Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5998862.6525 2096533.61775 37.7366164654663 -122.446409060855 (37.7366164654663, -122.446409060855)
20488 82142 Permitted Site 1 Ceratonia siliqua :: Carob 97 30 Molimo Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
106363 82092 Permitted Site 1 Ceratonia siliqua :: Carob 97 30 Molimo Dr 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
111792 82143 Permitted Site 1 Ceratonia siliqua :: Carob 97 30 Molimo Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
113829 82141 Permitted Site 1 Ceratonia siliqua :: Carob 97 30 Molimo Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
161602 225042 Undocumented 2 Ceratonia siliqua :: Carob 97 979 Ashbury St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5999193.16537 2106656.55415 37.764430453131105 -122.44599421345801 (37.7644304531311, -122.445994213458)
3892 222929 Permitted Site 1 Ceratonia siliqua :: Carob 97 979 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1979 12:00:00 AM 10 Width 4ft Permit Number 17592 5999199.8898 2106672.6396 37.7644750037296 -122.445972112616 (37.7644750037296, -122.445972112616)
155584 138737 Undocumented 2 Ceratonia siliqua :: Carob 97 2945 BUSH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5999415.669 2114277.6236 37.7853686673978 -122.44577276106199 (37.7853686673978, -122.445772761062)
185909 57320 Permitted Site 1 Ceratonia siliqua :: Carob 97 2728 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/31/1976 12:00:00 AM 15   Permit Number 16145 5999531.6355 2114001.5838 37.7846173544843 -122.445351698652 (37.7846173544843, -122.445351698652)
142096 10409 DPW Maintained 3 Ceratonia siliqua :: Carob 97 1398 HAIGHT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   5999436.0 2108778.0 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847)
135516 247504 Undocumented 2 Ceratonia siliqua :: Carob 97 1398 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5999483.6766 2108789.6708 37.7703040400286 -122.44514278745399 (37.7703040400286, -122.445142787454)
169707 57317 Permitted Site 1 Ceratonia siliqua :: Carob 97 2706 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/31/1976 12:00:00 AM 13   Permit Number 16141 5999606.4685 2114016.4513 37.7846624482509 -122.44509387174801 (37.7846624482509, -122.445093871748)
40687 57316 Permitted Site 1 Ceratonia siliqua :: Carob 97 1515 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/31/1976 12:00:00 AM 13   Permit Number 16140 5999629.2653 2114178.0114 37.7851073514303 -122.445026621162 (37.7851073514303, -122.445026621162)
39980 30908 Permitted Site 1 Ceratonia siliqua :: Carob 97 1511 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/1995 12:00:00 AM 7   Permit Number 34730 5999634.2212 2114153.2322 37.7850395970423 -122.44500769339199 (37.7850395970423, -122.445007693392)
65703 138239 Undocumented 2 Ceratonia siliqua :: Carob 97 1509 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5999639.177 2114119.037 37.784945988756 -122.444988088871 (37.784945988756, -122.444988088871)
65381 138240 Undocumented 2 Ceratonia siliqua :: Carob 97 1509 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   5999643.6372 2114098.2225 37.7848890921049 -122.444971161243 (37.7848890921049, -122.444971161243)
47133 138241 Undocumented 2 Ceratonia siliqua :: Carob 97 1509 Lyon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5999646.1152 2114082.8594 37.784847050450104 -122.444961483404 (37.7848470504501, -122.444961483404)

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