trees
24 rows where qSpecies_id = 215
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2107 | 113082 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 414 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6010030.65327 | 2092539.3572 | 37.7262806120542 | -122.407514778095 | (37.7262806120542, -122.407514778095) | 10 | 3 | 7 | 309 | 28 | ||
| 3788 | 110746 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010517.26001 | 2106013.51672 | 37.7633049506856 | -122.406781781161 | (37.7633049506856, -122.406781781161) | 8 | 4 | 8 | 28859 | 19 | ||
| 14075 | 110744 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010545.16814 | 2106015.79361 | 37.7633127639997 | -122.406685416098 | (37.7633127639997, -122.406685416098) | 8 | 4 | 8 | 28859 | 19 | ||
| 16603 | 110742 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010595.22782 | 2106018.33058 | 37.7633225306396 | -122.406512454011 | (37.7633225306396, -122.406512454011) | 8 | 4 | 8 | 28859 | 19 | ||
| 17154 | 110741 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010604.54028 | 2106019.56363 | 37.7633264372932 | -122.406480331995 | (37.7633264372932, -122.406480331995) | 8 | 4 | 8 | 28859 | 19 | ||
| 28648 | 253005 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 1201 Tennessee St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 31340 | 44122 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 3101 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43624 | 6008987.7517307 | 2101549.34835425 | 37.7509616566697 | -122.411756412734 | (37.7509616566697, -122.411756412734) | 2 | 4 | 7 | 28859 | 19 | |||
| 44011 | 43153 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 145 Harvard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42963 | 6006127.87968671 | 2093167.54853876 | 37.7277862609362 | -122.421051074662 | (37.7277862609362, -122.421051074662) | 9 | 7 | 7 | 309 | 5 | ||
| 54575 | 47764 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 560 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2002 12:00:00 AM | Permit Number 45543 | 6002706.57602401 | 2103299.52910824 | 37.7554128710112 | -122.433602373432 | (37.7554128710112, -122.433602373432) | 2 | 4 | 5 | 28862 | 22 | |||
| 60608 | 253006 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 1201 Tennessee St | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 95589 | 225124 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 11 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009212.85575 | 2099450.84457 | 37.7452122557381 | -122.410829786171 | (37.7452122557381, -122.410829786171) | 2 | 7 | 7 | 28859 | 2 | |||
| 104952 | 50993 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 142REVISED Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47476 | 5998040.17668955 | 2105982.21326987 | 37.7625129768246 | -122.449933460946 | (37.7625129768246, -122.449933460946) | 15 | 5 | 11 | 29492 | 9 | |||
| 117795 | 225126 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 3276 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009004.73271 | 2099632.84407 | 37.7457003142368 | -122.411562299281 | (37.7457003142368, -122.411562299281) | 2 | 7 | 7 | 28859 | 2 | |||
| 121910 | 40454 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 367 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41539 | 6006432.39897637 | 2097043.87729658 | 37.7384469673038 | -122.420273348712 | (37.7384469673038, -122.420273348712) | 2 | 7 | 7 | 28859 | 2 | ||
| 122232 | 124529 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 591 09th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5993123.8797 | 2111433.88692 | 37.7771992927101 | -122.467333421603 | (37.7771992927101, -122.467333421603) | 11 | 6 | 2 | 54 | 11 | |||
| 124299 | 44120 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 3101 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43624 | 6008987.7517307 | 2101549.34835425 | 37.7509616566697 | -122.411756412734 | (37.7509616566697, -122.411756412734) | 2 | 4 | 7 | 28859 | 19 | |||
| 130759 | 253004 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 1201 Tennessee St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 133975 | 225123 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 1 Bird St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005996.86725 | 2105736.88659 | 37.7622914255266 | -122.422396701747 | (37.7622914255266, -122.422396701747) | 8 | 4 | 5 | 28859 | 19 | |||
| 142906 | 40451 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 633 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/1999 12:00:00 AM | Permit Number 41536 | 6008000.55737724 | 2095962.28514198 | 37.7355653906838 | -122.414774876315 | (37.7355653906838, -122.414774876315) | 2 | 7 | 7 | 28859 | 2 | ||
| 146097 | 225125 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 3276 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009005.1841 | 2099614.11133 | 37.74564890359 | -122.411559415158 | (37.74564890359, -122.411559415158) | 2 | 7 | 7 | 28859 | 2 | |||
| 152284 | 225128 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 4125 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002350.83715 | 2102354.10683 | 37.7527967763571 | -122.434765021205 | (37.7527967763571, -122.434765021205) | 2 | 4 | 5 | 28862 | 22 | |||
| 160317 | 44121 | Permitted Site 7 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 3101 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43624 | 6008987.7517307 | 2101549.34835425 | 37.7509616566697 | -122.411756412734 | (37.7509616566697, -122.411756412734) | 2 | 4 | 7 | 28859 | 19 | |||
| 170168 | 225127 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 479 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003488.69838 | 2098907.50866 | 37.7433977575005 | -122.430584177336 | (37.7433977575005, -122.430584177336) | 2 | 7 | 5 | 63 | 22 | |||
| 194048 | 124514 | DPW Maintained 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2644 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996476.32022 | 2110803.03688 | 37.7756601063189 | -122.455690719205 | (37.7756601063189, -122.455690719205) | 11 | 6 | 2 | 54 | 16 |
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) );