trees
14 rows where Fire Prevention Districts = 8 and qSpecies_id = 95 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32340 | 194551 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 364 09th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009495.1726 | 2109485.56506 | 37.7727811529595 | -122.410562055301 | (37.7727811529595, -122.410562055301) | 8 | 2 | 9 | 28853 | 34 | |||
52206 | 233518 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Hwy 101 Southbound | 10 | Back Yard : Yard | Tree | Private 2 | 7 | 6005873.99672 | 2108944.2877 | 37.7710912548825 | -122.423049648243 | (37.7710912548825, -122.423049648243) | 8 | 2 | 5 | 28853 | 19 | ||||
79049 | 194552 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1084 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6007595.2752 | 2109454.36065 | 37.772588775377 | -122.417131820472 | (37.772588775377, -122.417131820472) | 8 | 2 | 9 | 28853 | 19 | |||
129295 | 194553 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6011164.90304 | 2106222.99069 | 37.7639163349965 | -122.404556531081 | (37.7639163349965, -122.404556531081) | 8 | 3 | 8 | 28856 | 29 | ||||
150260 | 233517 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Hwy 101 Southbound | 12 | Back Yard : Yard | Tree | Private 2 | 7 | 6005882.82166 | 2108930.28485 | 37.7710533043986 | -122.423018127005 | (37.7710533043986, -122.423018127005) | 8 | 2 | 5 | 28853 | 19 | ||||
189412 | 194573 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 614 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009542.67378 | 2111646.52636 | 37.7787173088821 | -122.410550367712 | (37.7787173088821, -122.410550367712) | 8 | 2 | 9 | 28853 | 34 | |||
5674 | 69960 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1084 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007591.27933 | 2109447.46349 | 37.7725696126174 | -122.417145153823 | (37.7725696126174, -122.417145153823) | 8 | 2 | 9 | 28853 | 19 | |||
22936 | 42216 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 202X Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | 3X3 | Permit Number 42481 | 6009500.82528 | 2109156.27117 | 37.7718773055291 | -122.410519244875 | (37.7718773055291, -122.410519244875) | 8 | 2 | 9 | 28853 | 34 |
67193 | 61924 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 456 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1985 12:00:00 AM | Permit Number 21978 | 6005733.06565102 | 2107870.63152991 | 37.768135298323 | -122.423460793102 | (37.768135298323, -122.423460793102) | 8 | 4 | 5 | 28853 | 19 | ||
68096 | 68705 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3725 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32713 | 6004069.33935091 | 2105955.57435513 | 37.7627829682463 | -122.429078889929 | (37.7627829682463, -122.429078889929) | 8 | 4 | 5 | 28862 | 3 | ||
119750 | 55850 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3452 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1984 12:00:00 AM | Permit Number 21322 | 6003863.92608723 | 2106588.23979029 | 37.7645084855972 | -122.429834470805 | (37.7645084855972, -122.429834470805) | 8 | 4 | 5 | 28862 | 3 | ||
124906 | 62567 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 566 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1986 12:00:00 AM | Permit Number 22768 | 6011492.88408448 | 2105735.21386833 | 37.7625953337074 | -122.403387819029 | (37.7625953337074, -122.403387819029) | 8 | 3 | 8 | 28856 | 29 | ||
132937 | 61400 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3446 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1984 12:00:00 AM | Permit Number 21323 | 6003891.19192032 | 2106589.75258632 | 37.7645141833652 | -122.429740273636 | (37.7645141833652, -122.429740273636) | 8 | 4 | 5 | 28862 | 3 | ||
178700 | 61907 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 410 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1985 12:00:00 AM | Permit Number 21954 | 6006015.61965589 | 2107886.23746349 | 37.7681940923018 | -122.422484575665 | (37.7681940923018, -122.422484575665) | 8 | 4 | 5 | 28853 | 19 |
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) );