339 rows where qSpecies_id = 30 sorted by SiteOrder 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)
1567 240680 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 9 Median : Cutout Tree DPW 1     8 3x3 Permit Number 56125 6005798.46813 2101640.54094 37.7510326203604 -122.422791760451 (37.7510326203604, -122.422791760451) 2 4 5 28859 19
3534 118354 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 9 Median : Cutout Tree DPW 1   07/15/2016 06:05:00 AM 3                        
6246 221421 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 9 Median : Cutout Tree DPW 1     7 3x3 Permit Number 56125 6005663.97142 2104121.3615 37.7578367884406 -122.423433209975 (37.7578367884406, -122.423433209975) 2 4 5 28859 19
8628 221426 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 9 Median : Cutout Tree DPW 1     6 3x3 Permit Number 56125 6005693.61577 2103548.60767 37.7562658131324 -122.423289973179 (37.7562658131324, -122.423289973179) 2 4 5 28859 19
30628 110780 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 9 Median : Cutout Tree DPW 1   05/26/2015 02:30:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
41302 221436 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 9 Median : Cutout Tree DPW 1   07/15/2016 06:05:00 AM 1 Width 3ft   6005440.21619 2108132.10005 37.7688366949854 -122.424492330751 (37.7688366949854, -122.424492330751) 8 4 5 28853 19
44481 221476 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 9 Median : Cutout Tree DPW 1   04/29/2015 09:37:00 AM 1 Width 3ft   6005539.09271 2106307.48846 37.7638323293302 -122.424020552718 (37.7638323293302, -122.424020552718) 8 4 5 28859 19
45689 221513 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 9 Median : Cutout Tree DPW 1     7 Width 3ft   6005831.83209 2101056.03846 37.7494295931996 -122.422634853028 (37.7494295931996, -122.422634853028) 2 4 5 28859 19
47290 110626 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 9 Median : Cutout Tree DPW 1   04/29/2015 09:37:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
52094 152420 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 9 Median : Cutout Tree DPW 1     0 Width 3ft   6005641.89151 2104501.69931 37.7588798608311 -122.42353661134 (37.7588798608311, -122.42353661134) 2 4 5 28859 19
53571 221464 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 9 Median : Cutout Tree DPW 1   06/19/2015 10:25:00 AM 2 Width 3ft   6005509.87291 2106837.48432 37.7652859224425 -122.42415931 (37.7652859224425, -122.42415931) 8 4 5 28853 19
62629 221502 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 9 Median : Cutout Tree DPW 1   02/21/2015 11:07:00 PM 2 Width 3ft   6005607.7078 2105081.85863 37.7604709126263 -122.42369608451 (37.7604709126263, -122.42369608451) 2 4 5 28859 19
71684 221447 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 9 Median : Cutout Tree DPW 1   02/09/2016 12:33:00 PM 1 Width 3ft   6005477.00515 2107432.00792 37.7669164868187 -122.424315280345 (37.7669164868187, -122.424315280345) 8 4 5 28853 19
73685 115518 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 9 Median : Cutout Tree DPW 1   02/09/2016 12:33:00 PM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
76054 221489 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 9 Median : Cutout Tree DPW 1     2 Width 3ft   6005574.23627 2105711.57302 37.7621980705008 -122.423856625205 (37.7621980705008, -122.423856625205) 8 4 5 28859 19
124826 221551 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 9 Median : Cutout Tree DPW 1     2 Width 3ft   6005731.5319 2102850.00284 37.7543497463656 -122.423109191463 (37.7543497463656, -122.423109191463) 2 4 5 28859 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
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
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
1553 221523 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 8 Median : Cutout Tree DPW 1     7 Width 3ft   6005797.77147 2101666.82906 37.751104762181 -122.422796037611 (37.751104762181, -122.422796037611) 2 4 5 28859 19
5824 221435 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 8 Median : Cutout Tree DPW 1   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.7689082693198 -122.424501499347 (37.7689082693198, -122.424501499347) 8 4 5 28853 19
7635 221501 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 8 Median : Cutout Tree DPW 1   02/21/2015 11:08:00 PM 2 3x3 Permit Number 56125 6005604.17413 2105138.97106 37.7606275304574 -122.423712366728 (37.7606275304574, -122.423712366728) 2 4 5 28859 19
10432 221544 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 8 Median : Cutout Tree DPW 1     7 3x3 Permit Number 56125 6005705.62338 2103333.32509 37.7556753749283 -122.423233144119 (37.7556753749283, -122.423233144119) 2 4 5 28859 19
19189 118353 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 8 Median : Cutout Tree DPW 1   07/15/2016 05:58:00 AM 3                        
31053 221448 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 8 Median : Cutout Tree DPW 1   02/09/2016 12:52:00 PM 1 Width 3ft   6005473.21673 2107488.56627 37.7670715686321 -122.42433240701 (37.7670715686321, -122.42433240701) 8 4 5 28853 19
31806 221488 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 8 Median : Cutout Tree DPW 1     2 Width 3ft   6005571.71667 2105739.51079 37.7622746387822 -122.42386732622 (37.7622746387822, -122.42386732622) 8 4 5 28859 19
52461 110625 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 8 Median : Cutout Tree DPW 1   04/29/2015 10:13:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
55166 115517 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 8 Median : Cutout Tree DPW 1   02/09/2016 12:52:00 PM 3     6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
58618 152419 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 8 Median : Cutout Tree DPW 1     0 Width 3ft   6005637.90033 2104551.94757 37.7590176055009 -122.423553987148 (37.7590176055009, -122.423553987148) 2 4 5 28859 19
84262 221514 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 8 Median : Cutout Tree DPW 1     8 Width 3ft   6005830.22915 2101083.18072 37.7495040291878 -122.42264232458 (37.7495040291878, -122.42264232458) 2 4 5 28859 19
89953 109700 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 8 Median : Cutout Tree DPW 1   02/21/2015 11:08:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 19
94316 110779 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 8 Median : Cutout Tree DPW 1   05/26/2015 02:35:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
98754 110766 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 8 Median : Cutout Tree DPW 1   06/19/2015 10:29:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
103645 221420 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 8 Median : Cutout Tree DPW 1   11/20/2009 12:00:00 AM 5 Width 3ft   6005663.71373 2104068.90036 37.7576927278639 -122.423430371709 (37.7576927278639, -122.423430371709) 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
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
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
1071 240683 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 7 Median : Cutout Tree DPW 1     6 3x3 Permit Number 56125 6005765.02468 2102281.28975 37.7527900818195 -122.422952946818 (37.7527900818195, -122.422952946818) 2 4 5 28859 19
3421 221449 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 7 Median : Cutout Tree DPW 1     1 Width 3ft   6005469.95975 2107527.18332 37.767177417921 -122.424346419355 (37.767177417921, -122.424346419355) 8 4 5 28853 19
6810 243265 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 7 Median : Cutout Tree DPW 1     0 3x3 Permit Number 56125 6005691.43766 2103575.20205 37.7563387121803 -122.42329939627 (37.7563387121803, -122.42329939627) 2 4 5 28859 19
9161 118352 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 7 Median : Cutout Tree DPW 1   07/15/2016 06:56:00 AM 3                        
27676 221462 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 7 Median : Cutout Tree DPW 1   06/19/2015 10:33:00 AM 1 Width 3ft   6005503.98521 2106938.10792 37.7655618784892 -122.424186831055 (37.7655618784892, -122.424186831055) 8 4 5 28853 19
53870 110778 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 7 Median : Cutout Tree DPW 1   05/26/2015 02:43:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
60014 221500 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 7 Median : Cutout Tree DPW 1   02/28/2015 11:10:00 PM 2 Width 3ft   6005602.08318 2105171.20834 37.7607159284129 -122.423721890569 (37.7607159284129, -122.423721890569) 2 4 5 28859 19
68247 221515 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 7 Median : Cutout Tree DPW 1     7 Width 3ft   6005828.19442 2101110.33186 37.7495784651962 -122.422651289924 (37.7495784651962, -122.422651289924) 2 4 5 28859 19
73812 221487 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 7 Median : Cutout Tree DPW 1     2 Width 3ft   6005570.24356 2105766.57088 37.7623488562382 -122.423874345421 (37.7623488562382, -122.423874345421) 8 4 5 28859 19
75109 221524 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 7 Median : Cutout Tree DPW 1     8 Width 3ft   6005795.8556 2101693.96335 37.7511791585977 -122.422804591074 (37.7511791585977, -122.422804591074) 2 4 5 28859 19
81807 243240 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 7 Median : Cutout Tree DPW 1     0 Width 3ft   6005663.74872 2104041.4182 37.7576172702474 -122.423428296996 (37.7576172702474, -122.423428296996) 2 4 5 28859 19
84453 152418 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 7 Median : Cutout Tree DPW 1     0 Width 3ft   6005636.4507 2104585.07924 37.7591084954784 -122.42356135619 (37.7591084954784, -122.42356135619) 2 4 5 28859 19
87178 110624 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 7 Median : Cutout Tree DPW 1   04/29/2015 10:16:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
90377 91287 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1212x Guerrero St 7 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
101099 115516 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 7 Median : Cutout Tree DPW 1           6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
102626 110765 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 7 Median : Cutout Tree DPW 1   06/19/2015 10:33:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
106689 221434 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 7 Median : Cutout Tree DPW 1   07/15/2016 06:56:00 AM 1 Width 3ft   6005437.11129 2108190.56795 37.7689970584876 -122.42450722982 (37.7689970584876, -122.42450722982) 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
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
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
8268 221535 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 6 Median : Cutout Tree DPW 1     4 3x3 Permit Number 56125 6005763.23809 2102308.0919 37.7528635735186 -122.422961029952 (37.7528635735186, -122.422961029952) 2 4 5 28859 19
15879 221486 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 6 Median : Cutout Tree DPW 1     3 3x3 Permit Number 56125 6005569.00136 2105791.30468 37.7624166992856 -122.423880400579 (37.7624166992856, -122.423880400579) 8 4 5 28859 19
18001 243333 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 6 Median : Cutout Tree DPW 1     0 3x3 Permit Number 56125 6005703.0197 2103377.21002 37.7557957257993 -122.423245267872 (37.7557957257993, -122.423245267872) 2 4 5 28859 19
18108 221419 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 6 Median : Cutout Tree DPW 1     6 3x3 Permit Number 56125 6005664.4202 2104015.71487 37.7575467328056 -122.423424147502 (37.7575467328056, -122.423424147502) 2 4 5 28859 19
18813 118351 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 6 Median : Cutout Tree DPW 1   07/15/2016 06:32:00 AM 3                        
23245 221461 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 6 Median : Cutout Tree DPW 1   06/19/2015 10:37:00 AM 2 Width 3ft   6005500.86915 2106969.86586 37.7656489022957 -122.424199867634 (37.7656489022957, -122.424199867634) 8 4 5 28853 19
35097 221433 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 6 Median : Cutout Tree DPW 1   07/15/2016 06:32:00 AM 1 Width 3ft   6005435.4614 2108218.98934 37.7690750036386 -122.424514958612 (37.7690750036386, -122.424514958612) 8 4 5 28853 19
36635 110623 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400X GUERRERO ST 6 Median : Cutout Tree DPW 1   04/29/2015 10:20:00 AM 3 3x3   6005439 2106552 37.7644980484366 -122.424384135711 (37.7644980484366, -122.424384135711) 8 4 5 28859 19
41721 110777 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 6 Median : Cutout Tree DPW 1   05/26/2015 02:47:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
42106 221525 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 6 Median : Cutout Tree DPW 1     4 Width 3ft   6005795.99168 2101720.64475 37.7512524272579 -122.422806016491 (37.7512524272579, -122.422806016491) 2 4 5 28859 19
50290 110764 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 6 Median : Cutout Tree DPW 1   06/19/2015 10:37:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
76998 109698 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 6 Median : Cutout Tree DPW 1   02/28/2015 11:01:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 19
96256 221499 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 6 Median : Cutout Tree DPW 1   02/28/2015 11:01:00 PM 2 Width 3ft   6005601.09047 2105206.48742 37.7608127404289 -122.423727832389 (37.7608127404289, -122.423727832389) 2 4 5 28859 19
107424 152417 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 6 Median : Cutout Tree DPW 1     0 Width 3ft   6005634.27087 2104624.16733 37.7592156991708 -122.423571674116 (37.7592156991708, -122.423571674116) 2 4 5 28859 19
119880 221473 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 6 Median : Cutout Tree DPW 1   04/29/2015 10:20:00 AM 1 Width 3ft   6005534.54232 2106397.63335 37.7640795889285 -122.424042702116 (37.7640795889285, -122.424042702116) 8 4 5 28859 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
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
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
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
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
2506 240677 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1300x Guerrero St 5 Median : Cutout Tree DPW 1     5 3x3 Permit Number 56125 6005825.90541 2101167.17913 37.7497344256173 -122.422663244623 (37.7497344256173, -122.422663244623) 2 4 5 28859 19
9030 221418 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 5 Median : Cutout Tree DPW 1   01/20/2016 07:34:00 AM 3 Width 3ft   6005666.2176 2103986.40391 37.757466353201 -122.423415847665 (37.757466353201, -122.423415847665) 2 4 5 28859 19
10576 118350 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 5 Median : Cutout Tree DPW 1   07/15/2016 05:53:00 AM 3                        
10894 221460 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 5 Median : Cutout Tree DPW 1   06/19/2015 10:41:00 AM 2 3x3 Permit Number 56125 6005499.89777 2107004.0817 37.7657427960049 -122.424205661071 (37.7657427960049, -122.424205661071) 8 4 5 28853 19
12356 152416 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 5 Median : Cutout Tree DPW 1     0 Width 3ft   6005631.99539 2104658.58909 37.7593100848133 -122.423581991114 (37.7593100848133, -122.423581991114) 2 4 5 28859 19
13182 243321 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 5 Median : Cutout Tree DPW 1     5 3x3 Permit Number 56125 6005700.91818 2103420.38667 37.7559141602344 -122.423255604682 (37.7559141602344, -122.423255604682) 2 4 5 28859 19
63421 91285 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1212x Guerrero St 5 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
73744 221562 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100 San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006161.28805 2102498.92878 37.75341002046 -122.421598049829 (37.75341002046, -122.421598049829) 2 4 5 28859 19
85250 221432 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 5 Median : Cutout Tree DPW 1   07/15/2016 05:53:00 AM 1 Width 3ft   6005434.00046 2108253.10785 37.7691686023842 -122.424522439153 (37.7691686023842, -122.424522439153) 8 4 5 28853 19
95085 109697 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x GUERRERO ST 5 Median : Cutout Tree DPW 1   02/21/2015 10:59:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.424312736622 (37.7613144297161, -122.424312736622) 2 4 5 28859 19
95760 110776 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 5 Median : Cutout Tree DPW 1   05/26/2015 02:53:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
98181 221451 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 5 Median : Cutout Tree DPW 1   02/09/2016 11:36:00 AM 1 Width 3ft   6005468.55001 2107589.96825 37.7673497307443 -122.424355761536 (37.7673497307443, -122.424355761536) 8 4 5 28853 19
104966 110763 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300X GUERRERO ST 5 Median : Cutout Tree DPW 1   06/19/2015 10:41:00 AM 3 3x3   6005492 2106949 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984) 8 4 5 28853 19
109163 221526 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 5 Median : Cutout Tree DPW 1     8 Width 3ft   6005792.85635 2101748.62489 37.7513290773756 -122.422818847126 (37.7513290773756, -122.422818847126) 2 4 5 28859 19
116925 221485 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 5 Median : Cutout Tree DPW 1     3 Width 3ft   6005566.92978 2105826.00789 37.7625118691551 -122.423890033211 (37.7625118691551, -122.423890033211) 8 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
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
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
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
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
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
1991 110775 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000X GUERRERO ST 4 Median : Cutout Tree DPW 1   05/26/2015 02:57:00 PM 3 3x3   6005663 2103080 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701) 2 4 5 28859 19
2731 91284 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1212x Guerrero St 4 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

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)
);