trees
19 rows where DBH = 4 and qSpecies_id = 79
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
345 | 222831 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3300x Cesar Chavez St | 8 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6007377.19749 | 2100569.29044 | 37.7481801578885 | -122.417256437759 | (37.7481801578885, -122.417256437759) | 2 | 4 | 7 | 28859 | 2 | |||
24963 | 222810 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 9 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6006867.8232 | 2100561.0017 | 37.7481287283566 | -122.419017253646 | (37.7481287283566, -122.419017253646) | 2 | 4 | 7 | 28859 | 2 | |||
27461 | 222835 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3050x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6009216.18805 | 2100578.21721 | 37.7483079587602 | -122.410897872946 | (37.7483079587602, -122.410897872946) | 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 | |||
43109 | 222834 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3250x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6007896.61363 | 2100571.958 | 37.7482166910443 | -122.415460497013 | (37.7482166910443, -122.415460497013) | 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 | |||
52569 | 222833 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3250x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6007916.1727 | 2100571.55763 | 37.7482166910602 | -122.415392833805 | (37.7482166910602, -122.415392833805) | 2 | 4 | 7 | 28859 | 2 | |||
62449 | 222840 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 7 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6008831.31577 | 2100575.76415 | 37.7482796345996 | -122.412228582693 | (37.7482796345996, -122.412228582693) | 2 | 4 | 7 | 28859 | 2 | |||
64410 | 222823 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 16 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6006010.36461 | 2100542.85713 | 37.7480305853438 | -122.42198103152 | (37.7480305853438, -122.42198103152) | 2 | 4 | 7 | 28859 | 22 | |||
75391 | 35886 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 75 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 4 | Permit Number 39086 | 6011194.17734 | 2096389.63188 | 37.7369177176839 | -122.403763315527 | (37.7369177176839, -122.403763315527) | 10 | 3 | 8 | 58 | 1 | |
89933 | 222812 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 14 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6006765.73797 | 2100560.25714 | 37.748120934852 | -122.419370208764 | (37.748120934852, -122.419370208764) | 2 | 4 | 7 | 28859 | 2 | |||
100512 | 222838 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6008897.70998 | 2100576.69978 | 37.7482859289478 | -122.411999058607 | (37.7482859289478, -122.411999058607) | 2 | 4 | 7 | 28859 | 2 | |||
113670 | 222816 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6006226.8204 | 2100563.55642 | 37.7480996262972 | -122.421234004258 | (37.7480996262972, -122.421234004258) | 2 | 4 | 7 | 28859 | 2 | |||
123479 | 222828 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3300x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6007445.92362 | 2100568.5836 | 37.7481820833534 | -122.417018734321 | (37.7481820833534, -122.417018734321) | 2 | 4 | 7 | 28859 | 2 | |||
139536 | 222779 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2950x Cesar Chavez St | 3 | Median : Yard | Tree | DPW 1 | 4 | 6009657.1726 | 2100582.18465 | 37.7483435701032 | -122.409373233383 | (37.7483435701032, -122.409373233383) | 2 | 4 | 7 | 28859 | 2 | ||||
164691 | 222778 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2950x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 4 | 6009634.24461 | 2100581.85859 | 37.7483413901636 | -122.409452495138 | (37.7483413901636, -122.409452495138) | 2 | 4 | 7 | 28859 | 2 | ||||
165152 | 222836 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3050x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6009193.15407 | 2100577.54159 | 37.7483048120374 | -122.410977476444 | (37.7483048120374, -122.410977476444) | 2 | 4 | 7 | 28859 | 2 | |||
172814 | 222811 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 13 | Median : Yard | Tree | DPW 1 | 4 | Width 10ft | 6006785.07009 | 2100560.48159 | 37.7481226399447 | -122.419303374748 | (37.7481226399447, -122.419303374748) | 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) );