trees
32 rows where qSpecies_id = 284
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4985 | 260550 | Private 9 | Private shrub :: Private Shrub 284 | 155 Graystone Ter | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5999080 | 2104142 | 37.7575196509651 | -122.446204727568 | (37.7575196509651, -122.446204727568) | 2 | 5 | 5 | 28862 | 3 | ||||
| 8329 | 262123 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 270 Lansdale Ave | 1 | Back Yard : Yard | Landscaping | Private 2 | 5995063 | 2096577 | 37.7365178315951 | -122.459549144168 | (37.7365178315951, -122.459549144168) | 9 | 7 | 4 | 59 | 40 | |||||
| 26397 | 18629 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 33550 | 18622 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 56335 | 104565 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 18 FLOOD AVE | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000327 | 2094154 | 37.7301661180838 | -122.441175517042 | (37.7301661180838, -122.441175517042) | 9 | 7 | 4 | 63 | 40 | |||||
| 57751 | 253065 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 1x Drake St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6001423 | 2086924 | 37.7103765330093 | -122.436869130393 | (37.7103765330093, -122.436869130393) | 9 | 7 | 6 | 28861 | 5 | ||||
| 61396 | 7331 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 2049 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1X1 | 6002872.18494 | 2115397.07895 | 37.7886391548954 | -122.433894313536 | (37.7886391548954, -122.433894313536) | 13 | 9 | 1 | 29490 | 27 | |||
| 77045 | 109322 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 191 24TH AVE | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 5988309.1 | 2114757.6 | 37.7860461422813 | -122.484232887865 | (37.7860461422813, -122.484232887865) | 11 | 6 | 1 | 55 | 33 | ||||
| 82432 | 173805 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 221 Stillings Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5999380.73268965 | 2095746.24622826 | 37.7344841059817 | -122.444561268208 | (37.7344841059817, -122.444561268208) | 9 | 7 | 4 | 59 | 40 | ||||
| 89615 | 106576 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 507 STEINER ST | 1 | Front Yard : Yard | Landscaping | Private 2 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | 15 | 5 | 11 | 29492 | 10 | |||||
| 101080 | 107348 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 260 LANSDALE AVE | 1 | Back Yard : Yard | Landscaping | Private 2 | 5995019 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | 9 | 7 | 4 | 59 | 40 | |||||
| 101831 | 120995 | Property Tree 8 | Private shrub :: Private Shrub 284 | 231 Delano Ave | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6000066 | 2092260 | 37.7249507611268 | -122.44194193564 | (37.7249507611268, -122.44194193564) | 9 | 7 | 6 | 28861 | 25 | ||||
| 111677 | 18621 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 111699 | 18630 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 113059 | 24287 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 340 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X10 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
| 115221 | 120636 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 385 Nevada St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6008960 | 2096519 | 37.7371478708762 | -122.411497024701 | (37.7371478708762, -122.411497024701) | 10 | 7 | 7 | 28859 | 2 | ||||
| 116022 | 24653 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 360X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 6006517.3093042 | 2097793.0086809 | 37.7405086991672 | -122.420032917294 | (37.7405086991672, -122.420032917294) | 2 | 7 | 7 | 28859 | 2 | |||
| 126491 | 26899 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 291X Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1998 12:00:00 AM | 3 | 3X3 | 6006553.2770939 | 2098151.6222177 | 37.741495398116 | -122.419933996023 | (37.741495398116, -122.419933996023) | 2 | 7 | 7 | 28859 | 2 | ||
| 127102 | 18624 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 128684 | 106641 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 1323X CLAYTON ST | 1 | Back Yard : Yard | Landscaping | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
| 128970 | 106639 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 1321X CLAYTON ST | 1 | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2105100 | 37.7601403710114 | -122.446861587167 | (37.7601403710114, -122.446861587167) | 15 | 5 | 5 | 28862 | 12 | |||||
| 137283 | 109242 | Property Tree 8 | Private shrub :: Private Shrub 284 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | 2 | 7 | 5 | 63 | 7 | ||||||
| 141957 | 12941 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 725X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | 2 | 4 | 5 | 28859 | 19 | |||
| 145213 | 256660 | Property Tree 8 | Private shrub :: Private Shrub 284 | 40X Miguel St | 1 | Back Yard : Yard | Landscaping | Private 2 | 3x3 | 6003624 | 2097154 | 37.7385906898162 | -122.429991281012 | (37.7385906898162, -122.429991281012) | 2 | 7 | 5 | 63 | 7 | ||||
| 145530 | 251249 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 161 Lundys Ln | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6006716 | 2098685 | 37.7429691002686 | -122.41940918518 | (37.7429691002686, -122.41940918518) | 2 | 7 | 7 | 28859 | 2 | ||||
| 147156 | 18959 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 2895 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000967.25155 | 2115546.84002 | 37.7889420752515 | -122.440495828792 | (37.7889420752515, -122.440495828792) | 13 | 6 | 1 | 29490 | 27 | |||
| 152293 | 16932 | Permitted Site 7 | Private shrub :: Private Shrub 284 | 527 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 1PL | 6004455.35372 | 2110106.27978 | 37.7742016464532 | -122.428039602707 | (37.7742016464532, -122.428039602707) | 7 | 9 | 11 | 28852 | 10 | |||
| 156294 | 104564 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 18 FLOOD AVE | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000327 | 2094154 | 37.7301661180838 | -122.441175517042 | (37.7301661180838, -122.441175517042) | 9 | 7 | 4 | 63 | 40 | |||||
| 169797 | 18623 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 171003 | 117478 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 400 PERALTA AVE | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6009762 | 2099359 | 37.7449908466617 | -122.408924451675 | (37.7449908466617, -122.408924451675) | 2 | 7 | 7 | 28859 | 2 | ||||
| 184022 | 18625 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 10X Red Rock Way | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000354.243381 | 2100138.277416 | 37.7465990864335 | -122.441510594646 | (37.7465990864335, -122.441510594646) | 2 | 7 | 5 | 63 | 22 | |||
| 187002 | 252903 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 215 Capistrano Ave | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001180 | 2093207 | 37.7276144248307 | -122.438158778943 | (37.7276144248307, -122.438158778943) | 9 | 7 | 6 | 28861 | 25 |
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) );