trees
21 rows where Fire Prevention Districts = 13 and qSpecies_id = 65 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92331 | 125545 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3211 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 5999423.84524 | 2115333.31799 | 37.7882677951647 | -122.445820424872 | (37.7882677951647, -122.445820424872) | 13 | 6 | 1 | 29490 | 31 | |||
125241 | 138631 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1704 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000076.1375 | 2114809.8269 | 37.7868676476344 | -122.443525989893 | (37.7868676476344, -122.443525989893) | 13 | 6 | 1 | 29490 | 27 | |||
33356 | 138630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1702 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000078.3648 | 2114795.7207 | 37.7868290426993 | -122.443517270296 | (37.7868290426993, -122.443517270296) | 13 | 6 | 1 | 29490 | 27 | |||
110025 | 255477 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2669 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780207 | 6000139.26098 | 2118831.12681 | 37.7979126806609 | -122.443596582177 | (37.7979126806609, -122.443596582177) | 13 | 9 | 1 | 57 | 17 | |
83313 | 68880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2018 12:00:00 AM | 3 | Permit Number 32851 | 6000180.50707 | 2120770.20455 | 37.8032392229736 | -122.443593228653 | (37.8032392229736, -122.443593228653) | 13 | 9 | 1 | 57 | 17 | |
39918 | 41209 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.442868349911 | (37.7996299225355, -122.442868349911) | 13 | 9 | 1 | 57 | 17 | |
16670 | 57208 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2238 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2015 12:00:00 AM | 3 | Permit Number 775007 | 6000879.71894 | 2116143.1485 | 37.7905743988346 | -122.440841472269 | (37.7905743988346, -122.440841472269) | 13 | 6 | 1 | 29490 | 27 | ||
141712 | 125540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001554.26648 | 2121557.3314 | 37.8054787165372 | -122.438895742254 | (37.8054787165372, -122.438895742254) | 13 | 9 | 1 | 57 | 17 | |||
91062 | 84740 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 143 Alhambra St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | 13 | 9 | 1 | 57 | 17 | |
160833 | 125544 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1410 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002431.61204 | 2121624.28708 | 37.8057124359506 | -122.435864366851 | (37.8057124359506, -122.435864366851) | 13 | 9 | 1 | 57 | 17 | |||
79432 | 41233 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.8051663037497 | -122.435520011048 | (37.8051663037497, -122.435520011048) | 13 | 9 | 1 | 57 | 17 | |
160053 | 107230 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | 13 | 9 | 1 | 28858 | 32 | |||
150779 | 125547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005968.56582 | 2119641.09275 | 37.8004673748183 | -122.423483123267 | (37.8004673748183, -122.423483123267) | 13 | 9 | 1 | 28858 | 32 | |||
193967 | 125548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006007.30583 | 2119647.97872 | 37.8004884684307 | -122.423349556855 | (37.8004884684307, -122.423349556855) | 13 | 9 | 1 | 28858 | 32 | |||
46734 | 125549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006015.52243 | 2119649.2025 | 37.8004922923456 | -122.423321211112 | (37.8004922923456, -122.423321211112) | 13 | 9 | 1 | 28858 | 32 | |||
81710 | 125550 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006031.52695 | 2119650.26621 | 37.8004961162623 | -122.423265904597 | (37.8004961162623, -122.423265904597) | 13 | 9 | 1 | 28858 | 32 | |||
178287 | 125551 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006045.33094 | 2119651.17602 | 37.8004993933977 | -122.423218201864 | (37.8004993933977, -122.423218201864) | 13 | 9 | 1 | 28858 | 32 | |||
169489 | 63578 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1359 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 17 | Permit Number 24201 | 6006442.54317 | 2119356.06995 | 37.799711515327 | -122.421822711261 | (37.799711515327, -122.421822711261) | 13 | 9 | 1 | 28858 | 32 | |
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
107607 | 37527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.418700444082 | (37.7894946107457, -122.418700444082) | 13 | 9 | 10 | 28858 | 21 |
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) );