339 rows where qSpecies_id = 30 sorted by rowid descending

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)
193830 221480 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 13 Median : Cutout Tree DPW 1   04/29/2015 05:03:00 AM 1 Width 3ft   6005548.13055 2106148.77804 37.7633970583515 -122.423978006683 (37.7633970583515, -122.423978006683) 8 4 5 28859 19
193458 110773 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 2 Median : Cutout Tree DPW 1   05/26/2015 03:06:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
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
192188 221509 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1201 San Jose Ave 38 Front Yard : Yard Tree Private 2     2     6004439.44088 2096038.01178 37.7355725864019 -122.427092409311 (37.7355725864019, -122.427092409311) 2 7 5 28861 2
191935 91240 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 842x Guerrero St 2 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
191122 221533 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 9 Median : Cutout Tree DPW 1     8 Width 3ft   6005767.42939 2102227.70946 37.75264309841 -122.422940823082 (37.75264309841, -122.422940823082) 2 4 5 28859 19
190784 152422 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 11 Median : Cutout Tree DPW 1     0 Width 3ft   6005644.93763 2104427.72747 37.7586769234173 -122.423520817442 (37.7586769234173, -122.423520817442) 2 4 5 28859 19
190513 115514 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 5 Median : Cutout Tree DPW 1   02/09/2016 11:36:00 AM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 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
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
187472 221450 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 6 Median : Cutout Tree DPW 1   02/09/2016 11:34:00 AM 1 Width 3ft   6005469.47774 2107557.31332 37.7672601204903 -122.424350229795 (37.7672601204903, -122.424350229795) 8 4 5 28853 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
186954 221539 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 2 Median : Cutout Tree DPW 1     5 Width 3ft   6005756.51513 2102435.13947 37.753212037416 -122.422993308391 (37.753212037416, -122.422993308391) 2 4 5 28859 19
186895 221549 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 6 Median : Cutout Tree DPW 1     1 Width 3ft   6005728.89674 2102911.59468 37.7545187145683 -122.423122682192 (37.7545187145683, -122.423122682192) 2 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
185467 221510 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 13 Median : Cutout Tree DPW 1     7 Width 3ft   6005838.80296 2100921.02333 37.7490592658716 -122.422601154533 (37.7490592658716, -122.422601154533) 2 4 5 28859 19
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
182979 221555 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 13 Median : Cutout Tree DPW 1     2 Width 3ft   6005738.9106 2102712.57542 37.753972818908 -122.423073906548 (37.753972818908, -122.423073906548) 2 4 5 28859 19
182752 221536 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 5 Median : Cutout Tree DPW 1     9 Width 3ft   6005762.1987 2102333.32685 37.7529328042098 -122.422966417762 (37.7529328042098, -122.422966417762) 2 4 5 28859 19
182549 221521 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 12 Median : Cutout Tree DPW 1     7 Width 3ft   6005805.66932 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142) 2 4 5 28859 19
181202 221498 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 5 Median : Cutout Tree DPW 1     3 Width 3ft   6005599.77613 2105242.7413 37.7609122108583 -122.423734955914 (37.7609122108583, -122.423734955914) 2 4 5 28859 19
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
179554 110784 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 13 Median : Cutout Tree DPW 1   05/26/2015 02:11:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 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
177960 221491 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 11 Median : Cutout Tree DPW 1     1 Width 3ft   6005578.642 2105634.14294 37.7619857144891 -122.423835881448 (37.7619857144891, -122.423835881448) 8 4 5 28859 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
176610 43726 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   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
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
176363 221550 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 7 Median : Cutout Tree DPW 1     1 Width 3ft   6005729.97057 2102894.68155 37.7544723356343 -122.423117766494 (37.7544723356343, -122.423117766494) 2 4 5 28859 19
175781 221463 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 8 Median : Cutout Tree DPW 1   06/08/2017 12:00:00 AM 3 Width 3ft   6005505.30672 2106900.54865 37.7654588242817 -122.424179588833 (37.7654588242817, -122.424179588833) 8 4 5 28853 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
174659 221511 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 11 Median : Cutout Tree DPW 1     6 Width 3ft   6005835.54562 2100976.57743 37.7492116209326 -122.422616365666 (37.7492116209326, -122.422616365666) 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
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
172006 110783 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 12 Median : Cutout Tree DPW 1   05/26/2015 02:16:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
171592 221452 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 4 Median : Cutout Tree DPW 1   02/09/2016 11:41:00 AM 1 Width 3ft   6005465.56003 2107641.57919 37.7674912732207 -122.424369774755 (37.7674912732207, -122.424369774755) 8 4 5 28853 19
171275 109699 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 7 Median : Cutout Tree DPW 1   02/28/2015 11:10:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 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
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
170287 110760 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 2 Median : Cutout Tree DPW 1   06/19/2015 10:54:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
169286 221474 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 7 Median : Cutout Tree DPW 1   04/29/2015 10:16:00 AM 1 Width 3ft   6005537.16302 2106367.52425 37.7639970644374 -122.424031496564 (37.7639970644374, -122.424031496564) 8 4 5 28859 19
169041 115511 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 2 Median : Cutout Tree DPW 1   02/09/2016 12:48:00 PM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
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
167540 221475 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 8 Median : Cutout Tree DPW 1   04/29/2015 10:13:00 AM 1 Width 3ft   6005538.26376 2106334.58706 37.7639066888645 -122.424025347 (37.7639066888645, -122.424025347) 8 4 5 28859 19
166262 110762 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 4 Median : Cutout Tree DPW 1   06/19/2015 10:45:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 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
163402 110782 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 11 Median : Cutout Tree DPW 1   05/26/2015 02:21:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 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
162959 91286 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1212x Guerrero St 6 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
162764 91266 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100X Guerrero St 2 Median : Cutout Tree DPW 1   06/21/2016 01:48:00 PM 3 3x500   6005744.445578 2102548.346221 37.7535221958931 -122.423043093148 (37.7535221958931, -122.423043093148) 2 4 5 28859 19
162604 115521 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 12 Median : Cutout Tree DPW 1           6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 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
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
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
159617 221472 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 5 Median : Cutout Tree DPW 1   04/29/2015 10:24:00 AM 1 Width 3ft   6005534.31082 2106426.8401 37.7641597706703 -122.424045579956 (37.7641597706703, -122.424045579956) 8 4 5 28859 19
159092 91256 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 940X Guerrero St 2 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
158366 110767 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 9 Median : Cutout Tree DPW 1   06/19/2015 10:25:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
157919 91293 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 812x Guerrero St 2 Median : Cutout Tree DPW 1   11/20/2001 12:00:00 AM 3     6005612 2104238 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698) 2 4 5 28859 19
156993 110649 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 12 Median : Cutout Tree DPW 1   04/28/2015 07:46:00 PM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
156067 221563 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 4286 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001305.60339 2102341.6071 37.7527030580007 -122.438378727412 (37.7527030580007, -122.438378727412) 2 4 5 28862 22
155313 221482 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 2 Median : Cutout Tree DPW 1     1 Width 3ft   6005559.28434 2105952.19302 37.7628579120838 -122.423925449408 (37.7628579120838, -122.423925449408) 8 4 5 28859 19
154412 221458 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 3 Median : Cutout Tree DPW 1   06/19/2015 10:49:00 AM 2 Width 3ft   6005493.2574 2107088.45627 37.7659740935515 -122.424234630048 (37.7659740935515, -122.424234630048) 8 4 5 28853 19
154318 221443 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 16 Median : Cutout Tree DPW 1     1 Width 3ft   6005451.42839 2107920.02985 37.7682550341586 -122.424438462286 (37.7682550341586, -122.424438462286) 8 4 5 28853 19
154018 221558 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 5 Median : Cutout Tree DPW 1     3 Width 3ft   6005728.5881 2102926.21051 37.7545588288301 -122.423124788381 (37.7545588288301, -122.423124788381) 2 4 5 28859 19
152774 221559 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1306 York St 4 : Tree Private 2     7 Width 3ft   6010039.89073 2101557.14399 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954) 2 4 7 28859 19
152652 109694 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 2 Median : Cutout Tree DPW 1   02/21/2015 10:54:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 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
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
150560 201715 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 726 Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6015296.60638 2088393.85947 37.715191240972 -122.389021178889 (37.715191240972, -122.389021178889) 10 3 8 58 1
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
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
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
145226 91283 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1212x Guerrero St 3 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
143846 221417 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 3 Median : Cutout Tree DPW 1     1 Width 3ft   6005673.16306 2103886.4908 37.7571924071266 -122.423384724831 (37.7571924071266, -122.423384724831) 2 4 5 28859 19
143760 221493 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 13 Median : Cutout Tree DPW 1     2 Width 3ft   6005583.08285 2105563.4275 37.7617917972666 -122.423815493808 (37.7617917972666, -122.423815493808) 8 4 5 28859 19
142764 221453 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 3 Median : Cutout Tree DPW 1   02/09/2016 12:40:00 PM 1 Width 3ft   6005462.88888 2107675.99901 37.7675856309877 -122.424381462352 (37.7675856309877, -122.424381462352) 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
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
141785 43728 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   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
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
140820 221534 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 8 Median : Cutout Tree DPW 1     7 Width 3ft   6005765.63484 2102254.12398 37.7527155253202 -122.422948906168 (37.7527155253202, -122.422948906168) 2 4 5 28859 19
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
138398 43727 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   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
137951 221439 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 12 Median : Cutout Tree DPW 1     1 Width 3ft   6005446.76573 2108031.65533 37.7685612677047 -122.424462530821 (37.7685612677047, -122.424462530821) 8 4 5 28853 19
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
136051 221508 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1201 San Jose Ave 15 Front Yard : Yard Tree Private 2     1     6004291.81357 2095940.5809 37.7352967139782 -122.427595874056 (37.7352967139782, -122.427595874056) 2 7 5 28861 2
135542 187782 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 101 Pennsylvania Ave 14 Front Yard : Yard Tree Private 2     1     6014325.58247 2106437.08289 37.764680319858 -122.393639589702 (37.764680319858, -122.393639589702) 14 3 8 310 29
135342 110761 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 3 Median : Cutout Tree DPW 1   06/19/2015 10:49:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
133232 109704 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 12 Median : Cutout Tree DPW 1   02/28/2015 10:40:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 19
132204 110622 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 5 Median : Cutout Tree DPW 1   04/29/2015 10:24:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 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
131382 115515 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 6 Median : Cutout Tree DPW 1   02/09/2016 11:34:00 AM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
129565 109701 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 9 Median : Cutout Tree DPW 1   02/21/2015 11:07:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 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
129525 221459 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 4 Median : Cutout Tree DPW 1   06/19/2015 10:45:00 AM 3 Width 3ft   6005495.53604 2107056.71588 37.7658870706576 -122.424224491084 (37.7658870706576, -122.424224491084) 8 4 5 28853 19
128979 221516 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 6 Median : Cutout Tree DPW 1     9 Width 3ft   6005827.473 2101138.31675 37.749655264584 -122.422655773047 (37.749655264584, -122.422655773047) 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
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
126359 221444 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 12 Median : Cutout Tree DPW 1     1 Width 3ft   6005482.04836 2107327.01142 37.7666284762413 -122.424290368213 (37.7666284762413, -122.424290368213) 8 4 5 28853 19
126324 221520 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 13 Median : Cutout Tree DPW 1     6 Width 3ft   6005805.49109 2101500.8171 37.7506493670819 -122.422757545722 (37.7506493670819, -122.422757545722) 2 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)
);