trees
16 rows where PlotSize = "Width 5ft" and qSpecies_id = 65 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16727 | 227695 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6001245.67427 | 2103366.3123 | 37.7555132424609 | -122.438659390527 | (37.7555132424609, -122.438659390527) | 2 | 4 | 5 | 28862 | 3 | |||
22632 | 221918 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 78 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004080.11539 | 2102633.34286 | 37.7536615185686 | -122.428804766139 | (37.7536615185686, -122.428804766139) | 2 | 4 | 5 | 28862 | 22 | |||
30130 | 221910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6003225.80615 | 2101486.76003 | 37.7504648828526 | -122.431677300586 | (37.7504648828526, -122.431677300586) | 2 | 4 | 5 | 28862 | 22 | |||
33222 | 203575 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | 9 | 7 | 5 | 63 | 40 | |||
39037 | 124123 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 83 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5996382.54086 | 2112452.81509 | 37.7801845808517 | -122.456134428556 | (37.7801845808517, -122.456134428556) | 11 | 6 | 2 | 54 | 16 | |||
52355 | 175197 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005286.47432 | 2092498.92071 | 37.7259028886841 | -122.423912306729 | (37.7259028886841, -122.423912306729) | 9 | 7 | 7 | 309 | 5 | |||
91117 | 221789 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6005341.04131 | 2103147.38287 | 37.7551442389361 | -122.424480760089 | (37.7551442389361, -122.424480760089) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
99045 | 221908 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6003228.29657 | 2101452.81084 | 37.7503718075255 | -122.431666264992 | (37.7503718075255, -122.431666264992) | 2 | 4 | 5 | 28862 | 22 | |||
99862 | 221909 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6003227.24309 | 2101470.4878 | 37.7504202845862 | -122.43167116991 | (37.7504202845862, -122.43167116991) | 2 | 4 | 5 | 28862 | 22 | |||
100205 | 221884 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | 2 | 7 | 7 | 28859 | 2 | |||
100713 | 221919 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6004080.1128 | 2102611.51792 | 37.7536015922648 | -122.428803219313 | (37.7536015922648, -122.428803219313) | 2 | 4 | 5 | 28862 | 22 | |||
101047 | 221790 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 5ft | 6005327.10837 | 2103145.45598 | 37.7551381613168 | -122.424528807253 | (37.7551381613168, -122.424528807253) | 2 | 4 | 5 | 28859 | 19 | |||
149504 | 221911 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 5ft | 6003226.50292 | 2101503.3413 | 37.7505104506147 | -122.431676074804 | (37.7505104506147, -122.431676074804) | 2 | 4 | 5 | 28862 | 22 | |||
159038 | 221793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6009169.37019 | 2099491.8572 | 37.745322428991 | -122.410983048655 | (37.745322428991, -122.410983048655) | 2 | 7 | 7 | 28859 | 2 | |||
175391 | 203584 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 391 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 5997518.2723 | 2093790.63155 | 37.729008004011 | -122.450859415354 | (37.729008004011, -122.450859415354) | 9 | 7 | 4 | 28861 | 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) );