trees
23 rows where Supervisor Districts = 9 and qSpecies_id = 69 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36890 | 189548 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6016430.12043 | 2108243.46973 | 37.7697569856242 | -122.3864864433 | (37.7697569856242, -122.3864864433) | 14 | 3 | 9 | 310 | 20 | |||
41111 | 189532 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6016506.09597 | 2108254.6757 | 37.7697919602649 | -122.386224424932 | (37.7697919602649, -122.386224424932) | 14 | 3 | 9 | 310 | 20 | |||
86687 | 189541 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6016412.49394 | 2108595.34148 | 37.7707221731193 | -122.386571952639 | (37.7707221731193, -122.386571952639) | 14 | 3 | 9 | 310 | 20 | |||
74197 | 189533 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6016504.19001 | 2108298.59573 | 37.7699124496335 | -122.386234080058 | (37.7699124496335, -122.386234080058) | 14 | 3 | 9 | 310 | 20 | |||
168670 | 189549 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016433.36634 | 2108206.11648 | 37.7696546013993 | -122.386472610837 | (37.7696546013993, -122.386472610837) | 14 | 3 | 9 | 310 | 20 | |||
191461 | 189542 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6016413.14494 | 2108555.50678 | 37.7706128317484 | -122.386566922731 | (37.7706128317484, -122.386566922731) | 14 | 3 | 9 | 310 | 20 | |||
79588 | 189543 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6016416.10016 | 2108521.78021 | 37.7705203895297 | -122.386554348427 | (37.7705203895297, -122.386554348427) | 14 | 3 | 9 | 310 | 20 | |||
101436 | 189550 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6016432.50666 | 2108181.51645 | 37.7695870074722 | -122.386473868975 | (37.7695870074722, -122.386473868975) | 14 | 3 | 9 | 310 | 20 | |||
192104 | 189534 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6016499.78476 | 2108334.00422 | 37.770009429824 | -122.386251786813 | (37.770009429824, -122.386251786813) | 14 | 3 | 9 | 310 | 20 | |||
95209 | 189551 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6016435.27108 | 2108120.27971 | 37.7694190177123 | -122.386460036521 | (37.7694190177123, -122.386460036521) | 14 | 3 | 9 | 310 | 20 | |||
154586 | 189535 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6016492.9216 | 2108447.01871 | 37.7703193631661 | -122.38628340695 | (37.7703193631661, -122.38628340695) | 14 | 3 | 9 | 310 | 20 | |||
186977 | 189544 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6016419.27306 | 2108480.80858 | 37.7704080660008 | -122.386540515932 | (37.7704080660008, -122.386540515932) | 14 | 3 | 9 | 310 | 20 | |||
27349 | 189552 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6016436.57026 | 2108094.55039 | 37.7693484425035 | -122.386453748452 | (37.7693484425035, -122.386453748452) | 14 | 3 | 9 | 310 | 20 | |||
123487 | 189536 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6016490.76801 | 2108485.29453 | 37.7704243410392 | -122.386293525233 | (37.7704243410392, -122.386293525233) | 14 | 3 | 9 | 310 | 20 | |||
179021 | 189545 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6016421.36303 | 2108440.22071 | 37.7702967362406 | -122.386530456128 | (37.7702967362406, -122.386530456128) | 14 | 3 | 9 | 310 | 20 | |||
6133 | 189537 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016488.60974 | 2108559.61758 | 37.7706282964998 | -122.386306173308 | (37.7706282964998, -122.386306173308) | 14 | 3 | 9 | 310 | 20 | |||
24020 | 189553 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6016439.48324 | 2108076.75272 | 37.7692997352157 | -122.386442431396 | (37.7692997352157, -122.386442431396) | 14 | 3 | 9 | 310 | 20 | |||
147793 | 189546 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6016422.17456 | 2108408.34728 | 37.7702092636618 | -122.386525426234 | (37.7702092636618, -122.386525426234) | 14 | 3 | 9 | 310 | 20 | |||
15039 | 189538 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6016476.02817 | 2108642.88921 | 37.7708562458475 | -122.386355500217 | (37.7708562458475, -122.386355500217) | 14 | 3 | 9 | 310 | 20 | |||
22450 | 189554 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 270 Terry A Francois Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6016441.41424 | 2108046.30409 | 37.7692162367782 | -122.386433628807 | (37.7692162367782, -122.386433628807) | 14 | 3 | 9 | 310 | 20 | |||
128541 | 189547 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 248 Terry A Francois Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6016425.39126 | 2108369.54662 | 37.7701029035595 | -122.386511593733 | (37.7701029035595, -122.386511593733) | 14 | 3 | 9 | 310 | 20 | |||
32412 | 189539 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6016468.45377 | 2108692.88455 | 37.7709931028916 | -122.386385186826 | (37.7709931028916, -122.386385186826) | 14 | 3 | 9 | 310 | 20 | |||
182502 | 189540 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 311 Terry A Francois Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6016455.58643 | 2108743.06847 | 37.7711301847333 | -122.386433195333 | (37.7711301847333, -122.386433195333) | 14 | 3 | 9 | 310 | 20 |
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) );