trees
26 rows where Zip Codes = 28861 and qSpecies_id = 202
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 70475 | 115759 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1718 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998106.99194 | 2088701.93877 | 37.7150693216746 | -122.448457855865 | (37.7150693216746, -122.448457855865) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 112583 | 175217 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 San Jose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6001607.87231 | 2094169.86531 | 37.7302825582951 | -122.436748518241 | (37.7302825582951, -122.436748518241) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 144618 | 175221 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 127 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001956.44701 | 2093481.30015 | 37.728411719314 | -122.435494211294 | (37.728411719314, -122.435494211294) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );