trees
36 rows where Zip Codes = 28859 and qSpecies_id = 47 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102941 | 227682 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008186.7931 | 2096476.12564 | 37.7369867469298 | -122.41416732858 | (37.7369867469298, -122.41416732858) | 2 | 7 | 7 | 28859 | 2 | |||
| 104777 | 47604 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | 10 | 7 | 7 | 28859 | 2 | ||
| 107721 | 23670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 317 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006937.9415449 | 2098264.8464559 | 37.7418279505329 | -122.41861198258 | (37.7418279505329, -122.41861198258) | 2 | 7 | 7 | 28859 | 2 | |||
| 129532 | 52497 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 371 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48606 | 6007135.79724675 | 2096038.97616324 | 37.7357273409345 | -122.417770123047 | (37.7357273409345, -122.417770123047) | 2 | 7 | 7 | 28859 | 2 | ||
| 134216 | 68097 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31842 | 6008240.85722104 | 2100065.07433688 | 37.7468442446896 | -122.414234251858 | (37.7468442446896, -122.414234251858) | 2 | 7 | 7 | 28859 | 2 | ||
| 137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
| 139775 | 51442 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2004 12:00:00 AM | Permit Number 47761 | 6007380.25742092 | 2095203.71769531 | 37.7334476580973 | -122.416865768693 | (37.7334476580973, -122.416865768693) | 2 | 7 | 7 | 28859 | 2 | ||
| 155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 2 | 7 | 7 | 28859 | 2 | |||
| 185212 | 63714 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1997 12:00:00 AM | Permit Number 24378 | 6007857.54148412 | 2100263.37846132 | 37.7473672046192 | -122.415573763175 | (37.7473672046192, -122.415573763175) | 2 | 7 | 7 | 28859 | 2 | ||
| 187678 | 48774 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47773 | 6007825.24973386 | 2095718.75627166 | 37.7348868619711 | -122.415363748684 | (37.7348868619711, -122.415363748684) | 2 | 7 | 7 | 28859 | 2 | ||
| 21600 | 105136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175X ESMERALDA AVE | 2 | unknown : Yard | Tree | DPW 1 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | |||||
| 36450 | 247870 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 6009721.06953 | 2098395.0417 | 37.7423417348977 | -122.408997980481 | (37.7423417348977, -122.408997980481) | 10 | 7 | 7 | 28859 | 2 | ||||
| 103423 | 82598 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3503 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006166.2666896 | 2102562.46439955 | 37.7535847553547 | -122.421585344765 | (37.7535847553547, -122.421585344765) | 2 | 4 | 5 | 28859 | 19 | ||
| 157287 | 115975 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006168 | 2102576 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | 2 | 4 | 5 | 28859 | 19 | |||
| 88904 | 116681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 154236 | 247871 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6009746.3542 | 2098404.30325 | 37.7423685814537 | -122.408911206692 | (37.7423685814537, -122.408911206692) | 10 | 7 | 7 | 28859 | 2 | ||||
| 78182 | 113478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6006917 | 2098966 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | 2 | 7 | 7 | 28859 | 2 | ||||
| 141197 | 227672 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.424897379118 | (37.7383979127325, -122.424897379118) | 2 | 7 | 5 | 28859 | 7 | ||||
| 175565 | 248189 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 216 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | 2 | 7 | 7 | 28859 | 2 | ||||
| 82654 | 116655 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 87869 | 116654 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 |
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) );