158 rows where qSpecies_id = 202 sorted by XCoord 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)
187038 203596 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 431 Gennessee St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5997432.94788 2094904.04016 37.7320602742514 -122.451234652068 (37.7320602742514, -122.451234652068) 9 7 4 59 40
168365 114971 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 431 Gennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 771835 5997422.4 2094904.1 37.7320598346121 -122.45127112252 (37.7320598346121, -122.45127112252) 9 7 4 59 40
116243 203604 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 349 Howth St 1 : Tree Private 2     2 Width 3ft   5997115.15384 2090174.96464 37.7190571494366 -122.451992266143 (37.7190571494366, -122.451992266143) 9 8 6 28861 24
41452 203615 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 240 Colon Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5996037.38323 2094398.48179 37.7305921283128 -122.456022857589 (37.7305921283128, -122.456022857589) 9 7 4 28861 40
51205 203592 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1485x Northwood Dr 1 Median : Yard Tree DPW 1     2     5995892.33391 2093907.44512 37.7292355333897 -122.456488817009 (37.7292355333897, -122.456488817009) 9 7 4 28861 40
190155 203597 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 50 De Montfort Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995113.88228 2091909.79504 37.7237057451058 -122.45903538769 (37.7237057451058, -122.45903538769) 9 8 4 28861 24
55533 123429 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 690 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5995057.91765 2110847.92629 37.7757018603334 -122.460600543143 (37.7757018603334, -122.460600543143) 11 6 2 54 11
64600 203602 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 601 Capitol Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5995030.39824 2089062.56731 37.7158831361758 -122.459117905878 (37.7158831361758, -122.459117905878) 9 8 6 28861 24
55725 203601 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 601 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5995029.86532 2089100.67816 37.7159877489258 -122.459122505898 (37.7159877489258, -122.459122505898) 9 8 6 28861 24
131041 203603 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 533 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995027.64484 2088883.389 37.7153909965718 -122.459114456087 (37.7153909965718, -122.459114456087) 9 8 6 28861 24
177274 203598 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995008.49221 2089033.02481 37.715800760085 -122.459191484793 (37.715800760085, -122.459191484793) 9 8 6 28861 24
137530 123393 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 667 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5995006.92654 2111007.28114 37.7761364727826 -122.460788484161 (37.7761364727826, -122.460788484161) 11 6 2 54 11
43318 115333 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 667 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3   Permit Number 776458 5994991 2111007.6 37.7761364319113 -122.460843601074 (37.7761364319113, -122.460843601074) 11 6 2 54 11
95445 203599 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 Minerva St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994990.66494 2089034.05641 37.7158025676981 -122.459253178313 (37.7158025676981, -122.459253178313) 9 8 6 28861 24
38481 203600 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 Minerva St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994977.66041 2089033.88982 37.7158013626108 -122.459298115614 (37.7158013626108, -122.459298115614) 9 8 6 28861 24
145137 93572 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 757 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2010 12:00:00 AM 14   Permit Number 53252 5994718.18671 2110428.47346 37.7745306031117 -122.46174532831 (37.7745306031117, -122.46174532831) 11 6 2 54 11
96705 114970 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200X MINERVA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
116404 114968 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200X MINERVA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
175831 114969 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200X MINERVA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
71411 203618 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 185 Castenada Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994486.24709 2100807.40007 37.7481002729224 -122.461849867291 (37.7481002729224, -122.461849867291) 1 8 4 29491 40
184066 203617 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 185 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994473.17466 2100793.87749 37.7480623907666 -122.461894090539 (37.7480623907666, -122.461894090539) 1 8 4 29491 40
76777 203616 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 185 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994461.21943 2100782.80797 37.7480313083953 -122.461934628392 (37.7480313083953, -122.461934628392) 1 8 4 29491 40
9429 259571 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 298 Public Park 1 Unaccepted Street : Cutout Tree Private 2       5x10   5994238 2098707 37.7423188086517 -122.462555955845 (37.7423188086517, -122.462555955845) 1 8 4 59 40
33050 203605 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 556 Victoria St 1 : Tree Private 2     2 Width 3ft   5993274.01352 2090867.72296 37.7207385300422 -122.46531978899 (37.7207385300422, -122.46531978899) 9 8 6 64 24
167492 123228 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 790 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 6ft   5993224.04217 2110104.87798 37.7735559729611 -122.466890291652 (37.7735559729611, -122.466890291652) 11 6 2 54 11
137188 123227 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 790 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   5993222.74872 2110119.7569 37.7735967518389 -122.466895847723 (37.7735967518389, -122.466895847723) 11 6 2 54 11
171239 203609 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 120 Quintara St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993075.95674 2101213.42516 37.7491338250612 -122.466756070139 (37.7491338250612, -122.466756070139) 1 8 4 29491 12
99215 203610 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 146 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5992962.70532 2101209.82571 37.7491174052506 -122.467147429924 (37.7491174052506, -122.467147429924) 1 8 4 29491 12
18595 203611 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 146 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5992953.88881 2101207.94105 37.7491117215315 -122.467177780245 (37.7491117215315, -122.467177780245) 1 8 4 29491 12
7590 109072 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1570 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2015 12:00:00 AM 3 3x3 Permit Number 769406 5992498.7 2104770.7 37.7588678465638 -122.469011061686 (37.7588678465638, -122.469011061686) 1 8 4 56 12
70533 203606 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1570 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5992477.77859 2104773.12978 37.7588733092773 -122.469083593842 (37.7588733092773, -122.469083593842) 1 8 4 56 12
160089 97887 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1030 Cabrillo St 1 Sidewalk: Property side : Cutout Tree Private 2   11/23/2011 12:00:00 AM 1   Permit Number 768379 5992385.79681 2110712.74988 37.7751766093559 -122.469834146271 (37.7751766093559, -122.469834146271) 11 6 2 54 11
173788 69064 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1359 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3   Permit Number 773642 5992377.26935607 2106205.46978928 37.7628003299421 -122.469535465436 (37.7628003299421, -122.469535465436) 1 8 11 56 12
20692 203613 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1762 14th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5991879.53156 2103437.46302 37.755171333717 -122.471055286375 (37.755171333717, -122.471055286375) 1 8 4 56 12
20819 203614 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2555 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991713.86449 2098047.40615 37.7403620464585 -122.47123551863 (37.7403620464585, -122.47123551863) 1 8 4 29491 40
39893 203608 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2007 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991583.6607 2101714.46197 37.7504233054064 -122.471952911395 (37.7504233054064, -122.471952911395) 1 8 4 29491 12
159601 203607 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2007 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991582.5756 2101730.87003 37.7504682948863 -122.471957859468 (37.7504682948863, -122.471957859468) 1 8 4 29491 12
77859 203612 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1675 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5991397.55944 2103884.03923 37.7563696263767 -122.472754630933 (37.7563696263767, -122.472754630933) 1 8 4 56 12
65494 121978 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5991208.06978 2113958.75361 37.7840210969883 -122.474145024774 (37.7840210969883, -122.474145024774) 11 6 2 54 26
87180 121977 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5991207.54931 2113971.26516 37.7840554200842 -122.474147738612 (37.7840554200842, -122.474147738612) 11 6 2 54 26
84362 121976 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 200 15th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5991206.08725 2113988.74508 37.7841033304005 -122.474154072624 (37.7841033304005, -122.474154072624) 11 6 2 54 26
173878 108526 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1677 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773677 5990566.26137 2103985.48594 37.7566000147891 -122.475636927177 (37.7566000147891, -122.475636927177) 1 8 4 56 12
147338 203591 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1677 18th Ave 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   5990564.22398 2103984.5948 37.7565974498416 -122.475643908062 (37.7565974498416, -122.475643908062) 1 8 4 56 12
15844 89148 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 5530 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM 2 3x3 Permit Number 51801 5990364.38578 2114085.53443 37.7843202921023 -122.47707310075 (37.7843202921023, -122.47707310075) 11 6 2 55 26
144484 120754 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 25 20th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1     5989551.60902 2114996.46131 37.7867742543083 -122.479951676413 (37.7867742543083, -122.479951676413) 11 6 1 55 33
8257 261815 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 Quintara St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988457 2100975 37.7482115203177 -122.482710816875 (37.7482115203177, -122.482710816875) 1 8 3 29491 35
9220 261816 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 Quintara St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988457 2100975 37.7482115203177 -122.482710816875 (37.7482115203177, -122.482710816875) 1 8 3 29491 35
12158 261817 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1601 Quintara St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988457 2100975 37.7482115203177 -122.482710816875 (37.7482115203177, -122.482710816875) 1 8 3 29491 35
76932 108895 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 666 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM 1 3x3 Permit Number 774994 5987872.85836 2111424.89012 37.7768700551182 -122.485497487794 (37.7768700551182, -122.485497487794) 11 6 2 55 26
186577 109033 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2120 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772816 5987671.1 2103767.6 37.7558334934217 -122.48563331933 (37.7558334934217, -122.48563331933) 1 8 3 56 35
47258 109897 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1734 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2015 12:00:00 AM 3 3x3 Permit Number 775111 5987546.7 2103468.6 37.7550052713528 -122.486041582178 (37.7550052713528, -122.486041582178) 1 8 3 56 35
98834 70277 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 481 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/06/2012 12:00:00 AM 2   Permit Number 768624 5985297.75157 2112660.9809 37.7801136384547 -122.494496575839 (37.7801136384547, -122.494496575839) 11 6 2 55 26
139931 90809 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 3351X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2015 11:05:00 AM 3 3x3   5985151.30933 2110394.17837 37.7738810771312 -122.494835999778 (37.7738810771312, -122.494835999778) 11 6 2 55 26
163637 117322 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 590 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3   Permit Number 778502 5984157.3 2111842.1 37.7777984170787 -122.49838135403 (37.7777984170787, -122.49838135403) 11 6 2 55 26
113305 118234 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 590 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5984132.17313 2111832.67046 37.7777710528241 -122.498467578545 (37.7777710528241, -122.498467578545) 11 6 2 55 26
69998 47443 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 651 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 6   Permit Number 45354 5982552.26402 2111341.47096 37.7763295864148 -122.503896547887 (37.7763295864148, -122.503896547887) 11 6 2 55 26
90782 117307 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 714 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778519 5981710.1 2110853.1 37.7749391065248 -122.506773545049 (37.7749391065248, -122.506773545049) 11 6 2 55 26
90654 117306 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 732 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778516 5981405.4 2110730.6 37.7745848102238 -122.507818456039 (37.7745848102238, -122.507818456039) 11 6 2 55 26

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