trees

158 rows where qSpecies_id = 202 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
15374 125563 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999907.90369 2121547.81116 37.8053587703434 -122.44459250045 (37.8053587703434, -122.44459250045) 13 9 1 57 17
15744 125562 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5999907.00069 2121550.96509 37.8053673786573 -122.444595852214 (37.8053673786573, -122.444595852214) 13 9 1 57 17
50429 99288 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 1 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998881.62913 2121328.006 37.8046966310161 -122.448128205765 (37.8046966310161, -122.448128205765) 13 9 1 57 17
53582 125566 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2809 Buchanan St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6003481.18787 2118079.55095 37.7960390779962 -122.431978879228 (37.7960390779962, -122.431978879228) 13 9 1 57 17
54080 125567 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2809 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6003482.8439 2118067.55033 37.7960062212666 -122.431972291689 (37.7960062212666, -122.431972291689) 13 9 1 57 17
69401 125564 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 165 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 7ft   6002712.8181 2121563.83713 37.805562426341 -122.434886887435 (37.805562426341, -122.434886887435) 13 9 1 57 17
73720 125559 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 20 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001981.60949 2119919.32974 37.8010055012508 -122.437299505878 (37.8010055012508, -122.437299505878) 13 9 1 57 17
89333 101004 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2801X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2012 12:00:00 AM   3x3 Permit Number 769246 6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
115799 125561 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999906.36456 2121555.3188 37.8053792964712 -122.444598366729 (37.8053792964712, -122.444598366729) 13 9 1 57 17
148377 125560 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 20 Mallorca Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001979.15463 2119935.63772 37.8010501391173 -122.437309169106 (37.8010501391173, -122.437309169106) 13 9 1 57 17
173627 101003 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2801X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2012 12:00:00 AM   3x3 Permit Number 769246 6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
176820 99289 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 2 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998887.79124 2121333.18312 37.8047111982366 -122.448107254257 (37.8047111982366, -122.448107254257) 13 9 1 57 17
19831 189237 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1700 Bancroft Ave 16 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6013775.5681 2092627.05351 37.7267303162423 -122.394574839671 (37.7267303162423, -122.394574839671) 10 3 8 58 1
53648 189236 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1700 Bancroft Ave 13 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6013792.02021 2092615.53995 37.7266996169689 -122.394517158935 (37.7266996169689, -122.394517158935) 10 3 8 58 1
73206 187967 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1551 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015595.88641 2096776.81479 37.7382257582057 -122.38857153857 (37.7382257582057, -122.38857153857) 10 3 8 58 1
112042 96192 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1634 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x6   6015129.8118 2097200.08447 37.7393621298546 -122.390212570161 (37.7393621298546, -122.390212570161) 10 3 8 58 1
145708 52153 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 525 Phelps St 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 15 5x9 Permit Number 48345 6015376.33052 2098074.72194 37.7417773752369 -122.389421273787 (37.7417773752369, -122.389421273787) 10 3 8 58 1
153401 113268 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1034 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM     Permit Number 774686 6014704.8 2089850.3 37.7191575187873 -122.391168478676 (37.7191575187873, -122.391168478676) 10 3 8 58 1
157881 94615 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1700X Bancroft Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 6   Permit Number 53777 6013900.00533 2092534.62626 37.7264834469268 -122.394138192746 (37.7264834469268, -122.394138192746) 10 3 8 58 1
164248 189235 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1634 Jerrold Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6015126.70903 2097207.07467 37.7393811514086 -122.390223786492 (37.7393811514086, -122.390223786492) 10 3 8 58 1
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
42639 255491 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 139 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/31/2018 12:00:00 AM 3 3x3 Permit Number 781962 5999277.13576 2095481.56921 37.7337514533765 -122.444900415841 (37.7337514533765, -122.444900415841) 9 7 4 59 40
47616 203594 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 362 Teresita Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5997974.50347 2098199.84414 37.7411407550534 -122.449599788915 (37.7411407550534, -122.449599788915) 9 7 4 59 40
59906 121643 Undocumented 4 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 362 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       2x4   5997955 2098188 37.741107118117 -122.449666371295 (37.741107118117, -122.449666371295) 9 7 4 59 40
141556 203593 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 362 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5997967.66384 2098207.91651 37.7411625285389 -122.449624019335 (37.7411625285389, -122.449624019335) 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
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
15125 221968 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 155 Farnum St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6002473.47377 2097229.09787 37.7387316655458 -122.433974612434 (37.7387316655458, -122.433974612434) 2 7 5 63 7
27858 203619 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 2ft   6000138.38202 2095835.33472 37.7347719253748 -122.441948223841 (37.7347719253748, -122.441948223841) 9 7 5 63 40
41523 221967 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 448 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003863.12438 2096025.37276 37.7355052757557 -122.429084054179 (37.7355052757557, -122.429084054179) 2 7 5 63 7
62425 221952 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1636 Diamond St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6002001.1942 2099218.33488 37.7441668325278 -122.435749813916 (37.7441668325278, -122.435749813916) 2 7 5 63 22
71295 204746 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 2ft   6000138.08456 2095837.9726 37.7347791514248 -122.441949441533 (37.7347791514248, -122.441949441533) 9 7 5 63 40
81720 204747 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6000136.90983 2095840.80392 37.7347868586248 -122.441953706121 (37.7347868586248, -122.441953706121) 9 7 5 63 40
129751 169719 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 163 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 Width 3ft Permit Number 779875 6004059.21605 2097368.19833 37.7392034678777 -122.428501775552 (37.7392034678777, -122.428501775552) 2 7 5 63 7
143401 221955 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 271 Bemis St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6002975.66032 2096224.16146 37.7360008273625 -122.432166542558 (37.7360008273625, -122.432166542558) 2 7 5 63 7
179588 221951 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1636 Diamond St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6002000.14888 2099232.59033 37.7442059152698 -122.435754448124 (37.7442059152698, -122.435754448124) 2 7 5 63 22
186533 221954 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 10 Mateo St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003651.78928 2096634.42206 37.7371656211922 -122.429858148341 (37.7371656211922, -122.429858148341) 2 7 5 63 7
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

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