trees
41 rows where PlotSize = "Width 10ft" and qSpecies_id = 79 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
146215 | 222822 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 15 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006028.77468 | 2100543.72066 | 37.7480339946844 | -122.421917431454 | (37.7480339946844, -122.421917431454) | 2 | 4 | 7 | 28859 | 22 | |||
158916 | 222821 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 14 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006053.42295 | 2100544.76657 | 37.7480382565647 | -122.421832272848 | (37.7480382565647, -122.421832272848) | 2 | 4 | 7 | 28859 | 22 | |||
154971 | 222820 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 13 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006079.97911 | 2100547.63598 | 37.7480476328877 | -122.421740646313 | (37.7480476328877, -122.421740646313) | 2 | 4 | 7 | 28859 | 22 | |||
185667 | 222819 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 12 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006102.45265 | 2100549.03678 | 37.7480527464562 | -122.42166303303 | (37.7480527464562, -122.42166303303) | 2 | 4 | 7 | 28859 | 22 | |||
25473 | 222818 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 11 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6006120.27144 | 2100551.46467 | 37.7480604176603 | -122.421601588647 | (37.7480604176603, -122.421601588647) | 2 | 4 | 7 | 28859 | 22 | |||
138021 | 222817 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 10 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6006145.22502 | 2100552.1939 | 37.7480638269962 | -122.421515351753 | (37.7480638269962, -122.421515351753) | 2 | 4 | 7 | 28859 | 22 | |||
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 | |||
47260 | 222814 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006266.09505 | 2100563.37105 | 37.748101331408 | -122.421098180538 | (37.748101331408, -122.421098180538) | 2 | 4 | 7 | 28859 | 2 | |||
129367 | 222815 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6006246.77566 | 2100563.7677 | 37.7481013314143 | -122.42116501457 | (37.7481013314143, -122.42116501457) | 2 | 4 | 7 | 28859 | 2 | |||
39785 | 222813 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 15 | Median : Yard | Tree | DPW 1 | 6 | Width 10ft | 6006748.5872 | 2100559.98827 | 37.7481192306161 | -122.419429496578 | (37.7481192306161, -122.419429496578) | 2 | 4 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
188294 | 222809 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 8 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006905.75522 | 2100562.66292 | 37.7481354256304 | -122.418886203547 | (37.7481354256304, -122.418886203547) | 2 | 4 | 7 | 28859 | 2 | |||
111695 | 222808 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 7 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006921.03633 | 2100562.97022 | 37.7481371298399 | -122.418833383667 | (37.7481371298399, -122.418833383667) | 2 | 4 | 7 | 28859 | 2 | |||
42136 | 222807 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006935.06482 | 2100562.99304 | 37.7481379823795 | -122.418784875139 | (37.7481379823795, -122.418784875139) | 2 | 4 | 7 | 28859 | 2 | |||
103143 | 222806 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006951.5861 | 2100562.96476 | 37.7481388349423 | -122.418727742984 | (37.7481388349423, -122.418727742984) | 2 | 4 | 7 | 28859 | 2 | |||
100204 | 222805 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006981.21986 | 2100563.90929 | 37.7481430968362 | -122.418625337193 | (37.7481430968362, -122.418625337193) | 2 | 4 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
150421 | 222830 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3300x Cesar Chavez St | 7 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6007397.54212 | 2100569.68358 | 37.7481823819289 | -122.417186114357 | (37.7481823819289, -122.417186114357) | 2 | 4 | 7 | 28859 | 2 | |||
160080 | 222829 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3300x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6007416.24383 | 2100569.30041 | 37.7481823819313 | -122.417121417131 | (37.7481823819313, -122.417121417131) | 2 | 4 | 7 | 28859 | 2 | |||
179129 | 222827 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3300x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6007469.11342 | 2100569.02723 | 37.7481846059292 | -122.416938575954 | (37.7481846059292, -122.416938575954) | 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 | |||
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 | |||
16249 | 222832 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3250x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 6 | Width 10ft | 6007936.88236 | 2100571.13372 | 37.7482166910686 | -122.415321190215 | (37.7482166910686, -122.415321190215) | 2 | 4 | 7 | 28859 | 2 | |||
168469 | 222826 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3200x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008154.70095 | 2100571.67515 | 37.7482304174003 | -122.414568016118 | (37.7482304174003, -122.414568016118) | 2 | 4 | 7 | 28859 | 2 | |||
133209 | 222825 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3200x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008183.00365 | 2100572.10257 | 37.7482331810351 | -122.414470176157 | (37.7482331810351, -122.414470176157) | 2 | 4 | 7 | 28859 | 2 | |||
51490 | 222824 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3200x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6008202.20567 | 2100572.21279 | 37.7482345623906 | -122.41440378373 | (37.7482345623906, -122.41440378373) | 2 | 4 | 7 | 28859 | 2 | |||
72682 | 222845 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 15 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6008656.93174 | 2100575.27687 | 37.7482685099843 | -122.412831565537 | (37.7482685099843, -122.412831565537) | 2 | 4 | 7 | 28859 | 2 | |||
76360 | 222843 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 13 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008698.15924 | 2100574.66503 | 37.7482691440259 | -122.412688958247 | (37.7482691440259, -122.412688958247) | 2 | 4 | 7 | 28859 | 2 | |||
130436 | 222844 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 14 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008676.6905 | 2100575.48577 | 37.7482701926188 | -122.412763254825 | (37.7482701926188, -122.412763254825) | 2 | 4 | 7 | 28859 | 2 | |||
25647 | 222842 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 9 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008782.20284 | 2100575.62151 | 37.748276486974 | -122.412398404384 | (37.748276486974, -122.412398404384) | 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 | |||
152977 | 222841 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6008807.15459 | 2100576.25792 | 37.7482796346101 | -122.412312166586 | (37.7482796346101, -122.412312166586) | 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 | |||
249 | 222839 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6008877.38377 | 2100577.11513 | 37.7482859289696 | -122.412069375694 | (37.7482859289696, -122.412069375694) | 2 | 4 | 7 | 28859 | 2 | |||
102706 | 222837 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3050x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 6 | Width 10ft | 6009168.22574 | 2100578.0507 | 37.7483048120351 | -122.411063714243 | (37.7483048120351, -122.411063714243) | 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 | |||
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 |
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) );