339 rows where qSpecies_id = 30 sorted by SiteOrder

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
112972 88538 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1306 York St   Sidewalk: Property side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367022 (37.7511299031436, -122.40816367022) 2 4 7 28859 19
53 264969 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
813 221494 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 1 Median : Cutout Tree DPW 1   02/21/2015 10:53:00 PM 2 3x3 Permit Number 56125 6005589.49697 2105398.29386 37.7613387412987 -122.423781567769 (37.7613387412987, -122.423781567769) 2 4 5 28859 19
1947 240678 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 1 Median : Cutout Tree DPW 1     4 3x3 Permit Number 56125 6005819.90053 2101295.53343 37.7500865182761 -122.422693129992 (37.7500865182761, -122.422693129992) 2 4 5 28859 19
5169 221481 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 1 Median : Cutout Tree DPW 1     2 3x3 Permit Number 56125 6005557.32843 2105982.39063 37.7629407171602 -122.423934361684 (37.7629407171602, -122.423934361684) 8 4 5 28859 19
6358 208585 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1424 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2019 12:00:00 AM 3 Width 3ft Permit Number 784722 5993062.7204 2105752.14993 37.7615952234535 -122.467131790705 (37.7615952234535, -122.467131790705) 1 8 4 56 12
8919 91244 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 852x Guerrero St 1 Median : Cutout Tree DPW 1   01/20/2016 07:21:00 AM 3     6005625 2104006 37.7575178330554 -122.423559787953 (37.7575178330554, -122.423559787953) 2 4 5 28859 19
12213 221456 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 1 Median : Cutout Tree DPW 1   06/19/2015 10:59:00 AM 2 3x3 Permit Number 56125 6005491.36744 2107155.48275 37.7661580255906 -122.424245934501 (37.7661580255906, -122.424245934501) 8 4 5 28853 19
18821 118346 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 1 Median : Cutout Tree DPW 1   07/15/2016 05:47:00 AM 3                        
19567 109693 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 1 Median : Cutout Tree DPW 1   02/21/2015 10:53:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 19
20296 43734 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 777 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.461768297306 (37.7181537802459, -122.461768297306) 9 8 6 28861 24
24279 175079 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1104x Alemany Blvd 1 Median : Yard Tree DPW 1     1 Width 10ft   6003837.73065 2094453.46286 37.7311877286109 -122.429059809376 (37.7311877286109, -122.429059809376) 9 7 6 28861 25
26579 221545 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 1 Median : Cutout Tree DPW 1     2 Width 3ft   6005721.87722 2103062.70747 37.7549332390947 -122.423157698184 (37.7549332390947, -122.423157698184) 2 4 5 28859 19
27720 221540 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 1 Median : Cutout Tree DPW 1     6 Width 3ft   6005754.92272 2102467.80763 37.753301646771 -122.423001136993 (37.753301646771, -122.423001136993) 2 4 5 28859 19
29249 221506 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 1 Median : Cutout Tree DPW 1     5 Width 3ft   6005698.11962 2103476.06965 37.7560668947992 -122.423269241105 (37.7560668947992, -122.423269241105) 2 4 5 28859 19
34481 201714 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 726 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6015317.96334 2088364.51894 37.7151118613908 -122.388945312084 (37.7151118613908, -122.388945312084) 10 3 8 58 1
38198 91254 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 928x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005681.979082 2103558.204453 37.7562915069181 -122.423330899086 (37.7562915069181, -122.423330899086) 2 4 5 28859 19
43244 91259 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 952x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005689.43944 2103423.018644 37.755920739203 -122.423295489065 (37.755920739203, -122.423295489065) 2 4 5 28859 19
44242 221415 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 1 Median : Cutout Tree DPW 1     1 Width 3ft   6005678.5014 2103825.14435 37.7570242653802 -122.423361901832 (37.7570242653802, -122.423361901832) 2 4 5 28859 19
44318 91245 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 870x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005631 2103898 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417) 2 4 5 28859 19
44991 187786 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1650 Galvez Ave 1 Side Yard : Yard Tree Private 2     6     6015560.61147 2097934.79581 37.7414033822515 -122.388774319486 (37.7414033822515, -122.388774319486) 10 3 8 58 1
49439 37574 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 30 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/2014 12:00:00 AM 3   Permit Number 773155 6001973.00287599 2105680.02476784 37.7619074866084 -122.436309645561 (37.7619074866084, -122.436309645561) 15 4 5 28862 3
50929 91248 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 888x Guerrero St 1 Median : Cutout Tree DPW 1   01/20/2016 07:34:00 AM 3     6005668.887935 2103795.421709 37.7569421113624 -122.423393035961 (37.7569421113624, -122.423393035961) 2 4 5 28859 19
51627 91264 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 978X Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005697.521495 2103276.567378 37.7555190742141 -122.423257128608 (37.7555190742141, -122.423257128608) 2 4 5 28859 19
54019 91241 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 842x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005622 2104059 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211) 2 4 5 28859 19
57604 91292 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1286x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005762 2101471 37.7505650422621 -122.422905822788 (37.7505650422621, -122.422905822788) 2 4 5 28859 19
57813 91247 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 880x Guerrero St 1 Median : Cutout Tree DPW 1   01/20/2016 07:29:00 AM 3     6005634 2103838 37.7570570522806 -122.423516718678 (37.7570570522806, -122.423516718678) 2 4 5 28859 19
59581 91291 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1282x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005761 2101495 37.7506308843168 -122.422910986406 (37.7506308843168, -122.422910986406) 2 4 5 28859 19
62006 43724 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 759 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.461200257981 (37.7181601624587, -122.461200257981) 9 8 6 28861 24
62222 54118 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973) 9 8 6 28861 24
63104 221529 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 1 Median : Cutout Tree DPW 1     10 Width 3ft   6005786.9094 2101880.52554 37.751690910628 -122.422848785557 (37.751690910628, -122.422848785557) 2 4 5 28859 19
63230 91280 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1180x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005731 2102090 37.7522629243783 -122.423057015276 (37.7522629243783, -122.423057015276) 2 4 5 28859 19
63393 91276 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1156x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005723 2102230 37.7526468806007 -122.4230946307 (37.7526468806007, -122.4230946307) 2 4 5 28859 19
67854 91236 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 804 Guerrero St 1 Median : Tree DPW 1   11/20/2009 12:00:00 AM 3 3x100   6005614 2104300 37.7583244674077 -122.423618732861 (37.7583244674077, -122.423618732861) 2 4 5 28859 19
68623 91249 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 870x Guerrero St 1 Median : Cutout Tree DPW 1   01/20/2016 07:26:00 AM 3     6005631 2103898 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417) 2 4 5 28859 19
79544 91239 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 842x Guerrero St 1 Median : Hanging Pot Tree DPW 1   11/20/1989 12:00:00 AM 3     6005622 2104059 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211) 2 4 5 28859 19
83337 221569 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 616 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003001.08037 2104529.5167 37.7588068286936 -122.432671745707 (37.7588068286936, -122.432671745707) 2 4 5 28862 3
83971 105071 Significant Tree 6 Acacia stenophylla :: Shoestring Acacia 30 1808 Vallejo St 1 Front Yard : Yard Tree Private 2     3   Permit Number 771033 6004794.05676 2118138.55822 37.7962754378239 -122.427440299436 (37.7962754378239, -122.427440299436) 13 9 1 57 17
94186 110618 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 1 Median : Cutout Tree DPW 1   04/29/2015 10:37:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
94820 91289 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1258x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005785.088369 2101640.018452 37.7510304308024 -122.422837991942 (37.7510304308024, -122.422837991942) 2 4 5 28859 19
94933 91269 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1120x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005712 2102441 37.7532256170659 -122.423147667433 (37.7532256170659, -122.423147667433) 2 4 5 28859 19
96242 221567 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 324 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004154.58593 2103373.98314 37.7556993571514 -122.428600021096 (37.7556993571514, -122.428600021096) 2 4 5 28862 22
102302 91258 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 948x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005688.196047 2103445.549621 37.7559825338488 -122.423301390711 (37.7559825338488, -122.423301390711) 2 4 5 28859 19
106244 152412 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 1 Median : Cutout Tree DPW 1     0 Width 3ft   6005623.17605 2104812.38517 37.7597318749526 -122.4236234274 (37.7597318749526, -122.4236234274) 2 4 5 28859 19
109528 91246 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 876x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005633 2103862 37.7571228942355 -122.423521883288 (37.7571228942355, -122.423521883288) 2 4 5 28859 19
115886 91243 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 850x Guerrero St 1 Median : Cutout Tree DPW 1   02/10/2009 12:00:00 AM 3     6005625 2104018 37.7575507822519 -122.423560641088 (37.7575507822519, -122.423560641088) 2 4 5 28859 19
119683 221468 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 1 Median : Cutout Tree DPW 1   04/29/2015 10:37:00 AM 2 Width 3ft   6005525.86145 2106563.70328 37.764535087455 -122.424084537671 (37.764535087455, -122.424084537671) 8 4 5 28859 19
122448 91275 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1150x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005721 2102265 37.7527428696504 -122.423104034617 (37.7527428696504, -122.423104034617) 2 4 5 28859 19
123034 91255 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 940x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032) 2 4 5 28859 19
124564 257893 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 23 Canyon Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003365 2086282 37.7087239233851 -122.430111404197 (37.7087239233851, -122.430111404197) 9 7 6 28861 5
125308 43729 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 763 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638) 9 8 6 28861 24
127657 91271 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1130x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005715 2102383 37.7530665317795 -122.423133170481 (37.7530665317795, -122.423133170481) 2 4 5 28859 19
128664 115510 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 1 Median : Cutout Tree DPW 1   02/09/2016 12:55:00 PM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
131495 56924 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 140 Tingley St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 3   Permit Number 14167 6002240.5096 2093994.70553 37.7298375431559 -122.434548888919 (37.7298375431559, -122.434548888919) 9 7 5 28861 25
136892 201711 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 724 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6015357.64919 2088292.55339 37.7149164576082 -122.388803118478 (37.7149164576082, -122.388803118478) 10 3 8 58 1
140454 91265 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 986x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005700.008282 2103231.505425 37.7553954849101 -122.423245325469 (37.7553954849101, -122.423245325469) 2 4 5 28859 19
141491 110772 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 1 Median : Cutout Tree DPW 1   05/26/2015 03:10:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
145933 221566 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 4286 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001342.88204 2102344.46852 37.7527130350975 -122.438250016433 (37.7527130350975, -122.438250016433) 2 4 5 28862 22
147940 91288 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1250x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005751 2101683 37.7511465247873 -122.422958927632 (37.7511465247873, -122.422958927632) 2 4 5 28859 19
148907 91252 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 908x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005675.762116 2103670.859284 37.7566004799608 -122.423360407709 (37.7566004799608, -122.423360407709) 2 4 5 28859 19
150645 91274 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1144x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005719 2102300 37.7528388586979 -122.423113438558 (37.7528388586979, -122.423113438558) 2 4 5 28859 19
151302 91263 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 970x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005695.03471 2103321.62929 37.7556426634019 -122.423268931776 (37.7556426634019, -122.423268931776) 2 4 5 28859 19
159812 91238 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 812x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005612 2104238 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698) 2 4 5 28859 19
162498 221455 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 1 Median : Cutout Tree DPW 1   02/09/2016 12:55:00 PM 1 Width 3ft   6005458.87953 2107745.71785 37.7677768358576 -122.424400289657 (37.7677768358576, -122.424400289657) 8 4 5 28853 19
162980 96193 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1640 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 4x50   6015077.4 2097255.4 37.7395111076977 -122.390397652393 (37.7395111076977, -122.390397652393) 10 3 8 58 1
168740 221570 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 117 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001705.56397 2108155.3423 37.7686889012963 -122.437411868978 (37.7686889012963, -122.437411868978) 15 5 5 29492 3
170354 91272 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1136x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005717 2102348 37.7529705427373 -122.423123766486 (37.7529705427373, -122.423123766486) 2 4 5 28859 19
170754 91277 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1170x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005728 2102148 37.752422009696 -122.423071511908 (37.752422009696, -122.423071511908) 2 4 5 28859 19
173380 91281 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1212x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3     6005738 2101906 37.7517580978369 -122.42301973134 (37.7517580978369, -122.42301973134) 2 4 5 28859 19
174532 91273 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1140x Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3     6005718 2102324 37.7529047007181 -122.423118602517 (37.7529047007181, -122.423118602517) 2 4 5 28859 19
176441 110759 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 1 Median : Cutout Tree DPW 1   06/19/2015 10:59:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
177826 91237 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 808 Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 3 4x15   6005611 2104262 37.7582199589604 -122.423626406477 (37.7582199589604, -122.423626406477) 2 4 5 28859 19
178245 56594 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 533 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224 2096098 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259) 2 7 5 63 7
180105 221568 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 359 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001813.22675 2103761.96483 37.7566318794794 -122.436724942504 (37.7566318794794, -122.436724942504) 2 4 5 28862 3
185336 91251 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 906X Guerrero St 1 Median : Cutout Tree DPW 1   11/20/2008 12:00:00 AM 3 3x100   6005675.14042 2103682.124768 37.7566313772663 -122.423363358583 (37.7566313772663, -122.423363358583) 2 4 5 28859 19
189657 221428 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 1 Median : Cutout Tree DPW 1   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.7694674075229 -122.424551705821 (37.7694674075229, -122.424551705821) 8 4 5 28853 19
190176 184203 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1466 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983430.71 2105161.519 37.7594128206633 -122.500400782356 (37.7594128206633, -122.500400782356) 1 8 3 56 35
193332 66265 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 4020 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344) 2 4 5 28862 22
2093 221427 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 10 Median : Cutout Tree DPW 1     6 3x3 Permit Number 56125 6005696.85287 2103501.5592 37.7561368116793 -122.423275433821 (37.7561368116793, -122.423275433821) 2 4 5 28859 19
13786 221552 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 10 Median : Cutout Tree DPW 1     3 3x3 Permit Number 56125 6005734.10722 2102815.94179 37.7542563679477 -122.423097864468 (37.7542563679477, -122.423097864468) 2 4 5 28859 19
15770 118355 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 10 Median : Cutout Tree DPW 1   07/15/2016 06:48:00 AM 3                        
17216 240679 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 10 Median : Cutout Tree DPW 1     4 3x3 Permit Number 56125 6005802.65315 2101583.39169 37.7508759377955 -122.422773227227 (37.7508759377955, -122.422773227227) 2 4 5 28859 19
24729 110768 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 10 Median : Cutout Tree DPW 1   06/19/2015 10:21:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
42708 110627 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 10 Median : Cutout Tree DPW 1   04/29/2015 05:29:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
46202 152421 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 10 Median : Cutout Tree DPW 1     0 Width 3ft   6005642.99765 2104457.73967 37.7587592203909 -122.42352966049 (37.7587592203909, -122.42352966049) 2 4 5 28859 19
69768 221446 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 10 Median : Cutout Tree DPW 1   02/09/2016 11:45:00 AM 1 Width 3ft   6005477.30623 2107402.8649 37.7668364840384 -122.424312165974 (37.7668364840384, -122.424312165974) 8 4 5 28853 19
85812 221490 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 10 Median : Cutout Tree DPW 1     3 Width 3ft   6005576.38505 2105666.63585 37.7620748049423 -122.423845997918 (37.7620748049423, -122.423845997918) 8 4 5 28859 19
106696 110781 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 10 Median : Cutout Tree DPW 1   05/26/2015 02:26:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
118820 115519 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 10 Median : Cutout Tree DPW 1   02/09/2016 11:45:00 AM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
129550 221465 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 10 Median : Cutout Tree DPW 1   06/19/2015 10:21:00 AM 2 Width 3ft   6005511.34873 2106807.42823 37.7652034788903 -122.424152067776 (37.7652034788903, -122.424152067776) 8 4 5 28853 19
142195 221437 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 10 Median : Cutout Tree DPW 1   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.33614 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027) 8 4 5 28853 19
142437 221532 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 10 Median : Cutout Tree DPW 1     8 Width 3ft   6005770.104 2102168.30473 37.7524801376575 -122.422927352112 (37.7524801376575, -122.422927352112) 2 4 5 28859 19
160656 221503 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 10 Median : Cutout Tree DPW 1   02/21/2015 11:06:00 PM 2 Width 3ft   6005610.53101 2105047.42068 37.7603765134773 -122.423683871708 (37.7603765134773, -122.423683871708) 2 4 5 28859 19
165700 221422 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 10 Median : Cutout Tree DPW 1     6 Width 3ft   6005661.88318 2104154.96713 37.7579289437835 -122.42344282103 (37.7579289437835, -122.42344282103) 2 4 5 28859 19
175672 221477 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 10 Median : Cutout Tree DPW 1   04/29/2015 05:29:00 AM 1 Width 3ft   6005543.73868 2106251.90953 37.7636799850545 -122.424000531101 (37.7636799850545, -122.424000531101) 8 4 5 28859 19
185643 221512 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 10 Median : Cutout Tree DPW 1     7 Width 3ft   6005835.43443 2101000.02463 37.7492759952973 -122.422618416129 (37.7492759952973, -122.422618416129) 2 4 5 28859 19
187231 109702 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 10 Median : Cutout Tree DPW 1   02/21/2015 11:06:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 19
5912 221553 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 11 Median : Cutout Tree DPW 1     3 3x3 Permit Number 56125 6005734.11141 2102791.4847 37.7541892146839 -122.423096111708 (37.7541892146839, -122.423096111708) 2 4 5 28859 19
11768 221543 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 11 Median : Cutout Tree DPW 1     8 Width 3ft   6005707.0284 2103306.91954 37.7556029507207 -122.42322640819 (37.7556029507207, -122.42322640819) 2 4 5 28859 19
12484 221478 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 11 Median : Cutout Tree DPW 1   04/29/2015 05:18:00 AM 1 3x3 Permit Number 56125 6005544.06849 2106215.1538 37.7635790811436 -122.423996776447 (37.7635790811436, -122.423996776447) 8 4 5 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);