trees
18 rows where Fire Prevention Districts = 11 and qSpecies_id = 43 sorted by qLegalStatus_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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67090 | 90956 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.43871 | 2110931.20899 | 37.7751208933778 | -122.508698002643 | (37.7751208933778, -122.508698002643) | 11 | 6 | 2 | 55 | 26 | ||
| 79658 | 141253 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | 11 | 6 | 1 | 54 | 31 | |||
| 104093 | 36188 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 35 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 7 | Permit Number 39256 | 5996804.8059 | 2114366.2904 | 37.7854627064304 | -122.454811918638 | (37.7854627064304, -122.454811918638) | 11 | 6 | 1 | 54 | 31 | |
| 106945 | 140845 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | 11 | 6 | 1 | 54 | 31 | |||
| 140389 | 36187 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 35 Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 8 | Permit Number 39256 | 5996805.8212 | 2114349.7078 | 37.7854172332631 | -122.45480720749 | (37.7854172332631, -122.45480720749) | 11 | 6 | 1 | 54 | 31 | |
| 155194 | 55092 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.7779243407011 | -122.474992253786 | (37.7779243407011, -122.474992253786) | 11 | 6 | 2 | 54 | 26 | ||
| 180365 | 141254 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | 11 | 6 | 1 | 54 | 31 | |||
| 61291 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712 | 2113143 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | 11 | 6 | 2 | 54 | 11 | |
| 34181 | 68180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 75 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31952 | 5996329.36645327 | 2111693.70801186 | 37.7780972208044 | -122.456263479509 | (37.7780972208044, -122.456263479509) | 11 | 6 | 2 | 54 | 16 | ||
| 41684 | 68560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.7786889858471 | -122.506043321809 | (37.7786889858471, -122.506043321809) | 11 | 6 | 2 | 55 | 26 | ||
| 64036 | 43694 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 750 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43338 | 5993218.66242977 | 2110366.15850001 | 37.7742730687673 | -122.46692789928 | (37.7742730687673, -122.46692789928) | 11 | 6 | 2 | 54 | 11 | ||
| 70992 | 38813 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 343 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | 11 | 6 | 2 | 54 | 11 | ||
| 77362 | 42163 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4630 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42458 | 5989047.18920071 | 2109907.45432155 | 37.7727719459225 | -122.481324019174 | (37.7727719459225, -122.481324019174) | 11 | 6 | 2 | 55 | 26 | ||
| 97486 | 36111 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1290 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39208 | 5992413.02593495 | 2106678.51938145 | 37.7641012654702 | -122.469446232974 | (37.7641012654702, -122.469446232974) | 11 | 8 | 11 | 56 | 12 | ||
| 108586 | 38812 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 343 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | 11 | 6 | 2 | 54 | 11 | ||
| 129953 | 42147 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 490 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42443 | 5990026.73861506 | 2112033.51240967 | 37.7786664170583 | -122.478091152159 | (37.7786664170583, -122.478091152159) | 11 | 6 | 2 | 55 | 26 | |||
| 162238 | 68548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.7783322447781 | -122.504940366327 | (37.7783322447781, -122.504940366327) | 11 | 6 | 2 | 55 | 26 | ||
| 162751 | 43695 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | 11 | 6 | 2 | 54 | 11 |
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) );