trees
18 rows where Neighborhoods (old) = 19 and qSpecies_id = 133 sorted by qCaretaker_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25370 | 28296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2003 12:00:00 AM | 6 | 2X3 | 6005818.9272 | 2100626.68333 | 37.7482499542668 | -122.422648971496 | (37.7482499542668, -122.422648971496) | 2 | 4 | 5 | 28859 | 19 | ||
31240 | 47741 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1384 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 45524 | 6010066.05430582 | 2101146.00958918 | 37.7499146097647 | -122.407999079784 | (37.7499146097647, -122.407999079784) | 2 | 4 | 7 | 28859 | 19 | ||
32772 | 255586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
33731 | 67340 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.7519606958911 | -122.403505842523 | (37.7519606958911, -122.403505842523) | 10 | 4 | 8 | 28859 | 19 | ||
34239 | 46345 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 382 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44591 | 6005460.79581087 | 2101487.62598308 | 37.7505936931274 | -122.423948593876 | (37.7505936931274, -122.423948593876) | 2 | 4 | 5 | 28859 | 19 | ||
40601 | 223023 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006515.40022 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | 2 | 4 | 7 | 28859 | 19 | |||
45934 | 69199 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1342 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33247 | 6009509.54623645 | 2101351.16759285 | 37.7504467544428 | -122.409938000531 | (37.7504467544428, -122.409938000531) | 2 | 4 | 7 | 28859 | 19 | ||
52294 | 28791 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.411895265148 | (37.7535963186214, -122.411895265148) | 2 | 4 | 7 | 28859 | 19 | |||
56077 | 51543 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 47842 | 6006500.80110502 | 2104175.14616456 | 37.7580316646871 | -122.4205429163 | (37.7580316646871, -122.4205429163) | 2 | 4 | 7 | 28859 | 19 | ||
70202 | 223024 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009975.92603 | 2103539.78877 | 37.756482348292 | -122.408479582484 | (37.756482348292, -122.408479582484) | 2 | 4 | 7 | 28859 | 19 | |||
70967 | 28792 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008964.24348 | 2102548.86607 | 37.7537047894643 | -122.411908330514 | (37.7537047894643, -122.411908330514) | 2 | 4 | 7 | 28859 | 19 | |||
85167 | 223025 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 380 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005467.6636 | 2101500.58617 | 37.7506296665394 | -122.423925765973 | (37.7506296665394, -122.423925765973) | 2 | 4 | 5 | 28859 | 19 | |||
106219 | 34302 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1261 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38090 | 6010338.30191232 | 2101880.05024725 | 37.7519453623814 | -122.407109364623 | (37.7519453623814, -122.407109364623) | 10 | 4 | 7 | 28859 | 19 | ||
123656 | 223036 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | 2 | 4 | 7 | 28859 | 19 | |||
134483 | 34301 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38089 | 6010337.06875453 | 2101902.38195398 | 37.7520066112995 | -122.407115203053 | (37.7520066112995, -122.407115203053) | 10 | 4 | 7 | 28859 | 19 | ||
155068 | 255587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
165574 | 65260 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) | 2 | 4 | 7 | 28859 | 19 | ||
165972 | 34344 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1325 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38101 | 6010099.44079349 | 2101484.52277039 | 37.7508459613928 | -122.407907495355 | (37.7508459613928, -122.407907495355) | 2 | 4 | 7 | 28859 | 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) );