158 rows where qSpecies_id = 202 sorted by Neighborhoods (old)

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) ▼
162253 108566 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772549 6010648.77476 2091709.27229 37.7240359509768 -122.405319522179 (37.7240359509768, -122.405319522179) 10 3 7 309 28
190673 175222 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 300 Gaven St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008975.92118 2094875.47718 37.7326360049484 -122.411325907078 (37.7326360049484, -122.411325907078) 9 3 7 309 28
7320 189222 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 1 Front Yard : Yard Tree Private 2     2     6014335.23001 2106254.12043 37.7641784810862 -122.393593414898 (37.7641784810862, -122.393593414898) 14 3 8 310 29
41702 189228 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1300x De Haro St 16 Median : Yard Tree DPW 1     1     6012274.47933 2102155.74686 37.752810527903 -122.40043310802 (37.752810527903, -122.40043310802) 10 3 8 28856 29
41840 108726 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 460 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773097 6011176.24234 2106141.01313 37.7636918767911 -122.404511540684 (37.7636918767911, -122.404511540684) 8 3 8 28856 29
55921 189223 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 5 Front Yard : Yard Tree Private 2     1     6014330.31355 2106344.51761 37.7644264187655 -122.393616746937 (37.7644264187655, -122.393616746937) 14 3 8 310 29
81425 189225 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 28 Front Yard : Yard Tree Private 2     1     6014307.08555 2106575.78079 37.7650601260485 -122.393713274773 (37.7650601260485, -122.393713274773) 14 3 8 310 29
84172 189224 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 101 Pennsylvania Ave 15 Front Yard : Yard Tree Private 2     1     6014323.89166 2106455.06011 37.7647295874116 -122.393646696144 (37.7647295874116, -122.393646696144) 14 3 8 310 29
87270 189221 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1310 Indiana St 14 : Yard Tree Private 2     1     6015010.96324 2102373.36426 37.7535602828051 -122.390984975379 (37.7535602828051, -122.390984975379) 10 3 8 28856 29
87275 189229 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1459 Rhode Island St 2 Sidewalk: Curb side : Yard Tree Private 2     1     6012049.05152 2101579.41636 37.7512154759161 -122.401172188849 (37.7512154759161, -122.401172188849) 10 3 8 28856 29
110052 189232 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 7 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012390.79704 2103733.87239 37.7571502019395 -122.400141680908 (37.7571502019395, -122.400141680908) 10 3 8 28856 29
133070 189234 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 9 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012405.15003 2103734.72302 37.7571533378622 -122.400092102164 (37.7571533378622, -122.400092102164) 10 3 8 28856 29
160605 189231 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 5 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6012362.34011 2103730.31063 37.7571388353939 -122.4002398464 (37.7571388353939, -122.4002398464) 10 3 8 28856 29
166041 189227 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1766 18th St 2 Sidewalk: Curb side : Pot Tree Private 2     1 Width 1ft   6012472.41099 2105663.34278 37.7624526523798 -122.399994920552 (37.7624526523798, -122.399994920552) 14 3 8 28856 29
173458 189230 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6012335.96177 2103730.27512 37.7571372669841 -122.400331070924 (37.7571372669841, -122.400331070924) 10 3 8 28856 29
185073 189233 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1919 22nd St 8 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6012396.53776 2103734.18422 37.7571513782439 -122.400121849061 (37.7571513782439, -122.400121849061) 10 3 8 28856 29
28532 221966 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 190 Storrie St 7 Front Yard : Yard Tree Private 2     2 Width 3ft   6000752.80061 2105288.06191 37.7607618468996 -122.440501720974 (37.7607618468996, -122.440501720974) 15 4 5 28862 3
133708 221965 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 4001 20th St 5 : Yard Tree Private 2     4 Width 3ft   6003646.65326 2104187.92713 37.7579054957544 -122.430414684807 (37.7579054957544, -122.430414684807) 2 4 5 28862 3
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
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
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
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
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
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
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
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
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
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
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
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
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
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
128898 203595 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 423 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5997934.90621 2094082.1225 37.729832211087 -122.44944008102 (37.729832211087, -122.44944008102) 9 7 4 28861 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
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
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
148068 115208 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1014 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 774282 6001957.4 2112096.8 37.7795254745958 -122.436822979652 (37.7795254745958, -122.436822979652) 15 5 11 29490 41
156394 115207 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1014 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 774282 6001957.4 2112096.8 37.7795254745958 -122.436822979652 (37.7795254745958, -122.436822979652) 15 5 11 29490 41
11882 81047 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 961 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6001634.70169 2086773.55642 37.7099754779527 -122.436126687404 (37.7099754779527, -122.436126687404) 9 7 6 28861 5
37514 175226 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1150 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6001420.49828 2087082.59126 37.7108118474628 -122.43688912274 (37.7108118474628, -122.43688912274) 9 7 6 28861 5
44573 175223 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 39 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6002350.25908 2087113.68805 37.7109500327891 -122.433677880228 (37.7109500327891, -122.433677880228) 9 7 6 28861 5
78033 175218 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 93 Morse St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6001014.57653 2087970.42853 37.7132265721263 -122.438355644521 (37.7132265721263, -122.438355644521) 9 7 6 28861 5
79067 175225 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 762 Prague St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002385.00148 2087111.82933 37.7109469004454 -122.433557669663 (37.7109469004454, -122.433557669663) 9 7 6 28861 5
169515 175220 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 178 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6000035.73488 2087742.43428 37.7125448266481 -122.441722494022 (37.7125448266481, -122.441722494022) 9 7 6 28861 5
180191 175224 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 762 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002402.88459 2087125.99028 37.710986797965 -122.433496872809 (37.710986797965, -122.433496872809) 9 7 6 28861 5
186582 175227 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 225 Naylor St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6002635.08266 2086756.92621 37.709986599863 -122.432667995542 (37.709986599863, -122.432667995542) 9 7 6 28861 5
188343 175219 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 100 Morse St 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 1ft   6000840.49126 2087951.89335 37.7131657752649 -122.438956013912 (37.7131657752649, -122.438956013912) 9 7 6 28861 5
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
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
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
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
8692 247232 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 760 Duboce Ave 4 : Tree Private 2     3 Width 3ft   6002013.60886 2108293.7767 37.7690865158689 -122.436356276247 (37.7690865158689, -122.436356276247) 15 5 5 29492 9

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