trees
12 rows where qSiteInfo = ":" and qSpecies_id = 47 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77789 | 201278 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 28 Lydia Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | 10 | 3 | 8 | 58 | 1 | |||
98973 | 250332 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 141 27th Ave | 1 | : | Tree | Private 2 | 05/08/2002 12:00:00 AM | 4 | Width 3ft | Permit Number 45150 | 5987387.77846 | 2115003.34197 | 37.7866671925889 | -122.487438428541 | (37.7866671925889, -122.487438428541) | 11 | 6 | 1 | 55 | 33 | |
25781 | 207137 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 103 | : | Tree | Private 2 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | 9 | 8 | 4 | 64 | 40 | |||
26539 | 207135 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991243.40911 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | 9 | 8 | 4 | 64 | 40 | |||
37655 | 207106 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Tara St | 2 | : | Tree | Private 2 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | 9 | 8 | 6 | 28861 | 24 | |||
60345 | 207132 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | 9 | 8 | 4 | 64 | 40 | |||
61664 | 207136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 100 | : | Tree | Private 2 | 6 | Width 0ft | 5991240.31686 | 2092039.54753 | 37.7238385767639 | -122.472434966904 | (37.7238385767639, -122.472434966904) | 9 | 8 | 4 | 64 | 40 | |||
71159 | 207133 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 90 | : | Tree | Private 2 | 10 | Width 0ft | 5991231.48328 | 2092142.91587 | 37.7241218892943 | -122.472473035196 | (37.7241218892943, -122.472473035196) | 9 | 8 | 4 | 64 | 40 | |||
85806 | 207130 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Junipero Serra Blvd | 22 | : | Tree | Private 2 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | 9 | 8 | 4 | 64 | 40 | |||
91870 | 207134 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 98 | : | Tree | Private 2 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.7238892166875 | -122.472422854852 | (37.7238892166875, -122.472422854852) | 9 | 8 | 4 | 64 | 40 | |||
134954 | 207131 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Junipero Serra Blvd | 23 | : | Tree | Private 2 | 14 | Width 0ft | 5991341.74557 | 2093676.61882 | 37.7283394372056 | -122.472203623519 | (37.7283394372056, -122.472203623519) | 9 | 8 | 4 | 64 | 40 | |||
137267 | 207138 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 123 | : | Tree | Private 2 | 8 | Width 0ft | 5991217.22752 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | 9 | 8 | 4 | 64 | 40 |
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) );