trees
20 rows where Zip Codes = 28852 and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11806 | 233511 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 301 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782005 | 6004633.78606 | 2109456.48744 | 37.7724275683009 | -122.427376074351 | (37.7724275683009, -122.427376074351) | 7 | 9 | 11 | 28852 | 10 | |
| 27505 | 233596 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 44 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006549.90248 | 2110330.35444 | 37.7749351803449 | -122.420810081832 | (37.7749351803449, -122.420810081832) | 7 | 9 | 11 | 28852 | 10 | |||
| 48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 53952 | 233597 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 197 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006526.51025 | 2110764.29313 | 37.776125353047 | -122.420921816282 | (37.776125353047, -122.420921816282) | 7 | 9 | 11 | 28852 | 10 | |||
| 60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
| 66091 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 77554 | 115072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 65 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006230 | 2110204 | 37.7745702053319 | -122.421907716929 | (37.7745702053319, -122.421907716929) | 7 | 9 | 11 | 28852 | 10 | ||||
| 77613 | 66110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 124 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29164 | 6005954.05152204 | 2110038.74835026 | 37.7741008978737 | -122.422850531283 | (37.7741008978737, -122.422850531283) | 7 | 9 | 11 | 28852 | 10 | ||
| 100606 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 3 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 113409 | 92745 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2009 12:00:00 AM | Permit Number 52969 | 6006237.3 | 2110147.2 | 37.7744146578956 | -122.42187842919 | (37.7744146578956, -122.42187842919) | 7 | 9 | 11 | 28852 | 10 | |||
| 118036 | 7723 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 175X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006514.1274 | 2110757.9768 | 37.7761073119325 | -122.420964203399 | (37.7761073119325, -122.420964203399) | 7 | 9 | 11 | 28852 | 10 | |||
| 121551 | 30727 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 45 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
| 121967 | 233509 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 599 Buchanan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6004544.20196 | 2110431.59381 | 37.7750999055671 | -122.427755444356 | (37.7750999055671, -122.427755444356) | 7 | 9 | 11 | 28852 | 10 | |||
| 126757 | 233595 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006199.44 | 2110210.42189 | 37.7745861147813 | -122.422013886425 | (37.7745861147813, -122.422013886425) | 7 | 9 | 11 | 28852 | 10 | |||
| 127438 | 6957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 627 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004338.3385 | 2110455.1046 | 37.7751528130593 | -122.428469247762 | (37.7751528130593, -122.428469247762) | 7 | 9 | 11 | 28852 | 10 | |||
| 128687 | 62278 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22416 | 6004275.31529715 | 2109405.62927883 | 37.7722676437754 | -122.428612433422 | (37.7722676437754, -122.428612433422) | 7 | 9 | 11 | 28852 | 10 | ||
| 147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 158702 | 16839 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 97X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1999 12:00:00 AM | 75 | 3X3 | 6006555.51402 | 2110416.39536 | 37.7751717443167 | -122.420796779971 | (37.7751717443167, -122.420796779971) | 7 | 9 | 11 | 28852 | 10 | ||
| 174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 |
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) );