trees
23 rows where PlotSize = "Width 6ft" and qSpecies_id = 79 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13574 | 222784 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 28 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010005.90686 | 2100575.10884 | 37.7483436744252 | -122.408166814455 | (37.7483436744252, -122.408166814455) | 2 | 4 | 7 | 28859 | 2 | |||
21315 | 222803 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 5 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 6010452.68948 | 2100735.70398 | 37.748809640151 | -122.406633159205 | (37.748809640151, -122.406633159205) | 2 | 4 | 7 | 28859 | 2 | |||
29852 | 222782 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 30 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 6009967.71828 | 2100574.06034 | 37.7483386570983 | -122.408298796278 | (37.7483386570983, -122.408298796278) | 2 | 4 | 7 | 28859 | 2 | |||
30998 | 222783 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 29 | Median : Cutout | Tree | DPW 1 | 4 | Width 6ft | 6009988.44227 | 2100575.2331 | 37.7483430377012 | -122.408227215614 | (37.7483430377012, -122.408227215614) | 2 | 4 | 7 | 28859 | 2 | |||
34913 | 222797 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 11 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010346.58719 | 2100693.63731 | 37.7486881975031 | -122.406997097757 | (37.7486881975031, -122.406997097757) | 2 | 4 | 7 | 28859 | 2 | |||
40482 | 222792 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 16 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6010247.81472 | 2100654.1398 | 37.7485742183223 | -122.407335869678 | (37.7485742183223, -122.407335869678) | 2 | 4 | 7 | 28859 | 2 | |||
42418 | 222790 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 18 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6010204.45395 | 2100638.08521 | 37.7485277089977 | -122.407484679601 | (37.7485277089977, -122.407484679601) | 2 | 4 | 7 | 28859 | 2 | |||
44251 | 222798 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6010362.72058 | 2100700.08083 | 37.7487067927886 | -122.406941762453 | (37.7487067927886, -122.406941762453) | 2 | 4 | 7 | 28859 | 2 | |||
49753 | 222800 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 6ft | 6010400.66673 | 2100716.83589 | 37.7487549217978 | -122.406811725007 | (37.7487549217978, -122.406811725007) | 2 | 4 | 7 | 28859 | 2 | |||
53546 | 222786 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 26 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010045.33048 | 2100578.24772 | 37.7483545004769 | -122.408030709253 | (37.7483545004769, -122.408030709253) | 2 | 4 | 7 | 28859 | 2 | |||
55795 | 222788 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 20 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010168.99866 | 2100623.96537 | 37.7484869544098 | -122.407606288598 | (37.7484869544098, -122.407606288598) | 2 | 4 | 7 | 28859 | 2 | |||
56047 | 222804 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 6ft | 6010473.5023 | 2100743.88671 | 37.7488332725517 | -122.406561764722 | (37.7488332725517, -122.406561764722) | 2 | 4 | 7 | 28859 | 2 | |||
74118 | 222796 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 6010330.47003 | 2100687.99035 | 37.7486717902786 | -122.407052433049 | (37.7486717902786, -122.407052433049) | 2 | 4 | 7 | 28859 | 2 | |||
74633 | 222795 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 13 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010312.60007 | 2100681.0451 | 37.7486517201183 | -122.407113738008 | (37.7486517201183, -122.407113738008) | 2 | 4 | 7 | 28859 | 2 | |||
76509 | 222802 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010429.09117 | 2100727.82073 | 37.7487866741639 | -122.406714207005 | (37.7487866741639, -122.406714207005) | 2 | 4 | 7 | 28859 | 2 | |||
97646 | 222785 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 27 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010026.6545 | 2100576.07742 | 37.7483474956387 | -122.408095137598 | (37.7483474956387, -122.408095137598) | 2 | 4 | 7 | 28859 | 2 | |||
117676 | 222794 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 14 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010286.07268 | 2100668.6664 | 37.7486162463561 | -122.407204597414 | (37.7486162463561, -122.407204597414) | 2 | 4 | 7 | 28859 | 2 | |||
131467 | 222789 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 19 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010186.13966 | 2100630.80552 | 37.7485066954419 | -122.407547497242 | (37.7485066954419, -122.407547497242) | 2 | 4 | 7 | 28859 | 2 | |||
132500 | 222791 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 17 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010227.86602 | 2100646.66118 | 37.7485525671486 | -122.40740432517 | (37.7485525671486, -122.40740432517) | 2 | 4 | 7 | 28859 | 2 | |||
140727 | 222787 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 24 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010096.17882 | 2100593.44521 | 37.748399076272 | -122.407855947615 | (37.748399076272, -122.407855947615) | 2 | 4 | 7 | 28859 | 2 | |||
144033 | 222801 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 7 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010415.2689 | 2100722.39062 | 37.748770990899 | -122.406761621955 | (37.748770990899, -122.406761621955) | 2 | 4 | 7 | 28859 | 19 | |||
155232 | 222793 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 15 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6010266.15939 | 2100660.65315 | 37.748593129264 | -122.407272892851 | (37.748593129264, -122.407272892851) | 2 | 4 | 7 | 28859 | 2 | |||
184667 | 222799 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 9 | Median : Cutout | Tree | DPW 1 | 4 | Width 6ft | 6010384.90884 | 2100709.18955 | 37.7487330449049 | -122.406865677135 | (37.7487330449049, -122.406865677135) | 2 | 4 | 7 | 28859 | 2 |
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) );