trees
26 rows where PlotSize = "Width 3ft" and qSpecies_id = 119 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115439 | 207722 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 300 Louisburg St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997412.90563 | 2090249.05124 | 37.7192776245304 | -122.450968397868 | (37.7192776245304, -122.450968397868) | 9 | 8 | 6 | 28861 | 24 | |||
| 143684 | 202013 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 7 Wheat St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012149.42791 | 2091374.55614 | 37.7232006759464 | -122.400108468936 | (37.7232006759464, -122.400108468936) | 10 | 3 | 8 | 58 | 1 | |||
| 158858 | 207724 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 132 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992208.61623 | 2088772.74591 | 37.7149247331539 | -122.46885013342 | (37.7149247331539, -122.46885013342) | 9 | 8 | 6 | 64 | 24 | |||
| 25767 | 191706 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1499 Rankin St | 7 | Side Yard : Yard | Tree | Private 2 | 1 | Width 3ft | 6012685.03055 | 2096691.54362 | 37.7378298766422 | -122.398629920547 | (37.7378298766422, -122.398629920547) | 10 | 3 | 8 | 58 | 1 | |||
| 151602 | 176282 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 8 | Side Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6009202.48899 | 2086331.05779 | 37.7091875189513 | -122.409939644414 | (37.7091875189513, -122.409939644414) | 9 | 7 | 8 | 309 | 39 | |||
| 188172 | 176283 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 9 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6009206.42472 | 2086339.23376 | 37.7092101890802 | -122.40992661864 | (37.7092101890802, -122.40992661864) | 9 | 7 | 8 | 309 | 39 | |||
| 58209 | 207718 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 315 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994723.84306 | 2090686.34608 | 37.7203240181088 | -122.46029507617 | (37.7203240181088, -122.46029507617) | 9 | 8 | 6 | 28861 | 24 | |||
| 65564 | 120404 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 527 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5988748.3356 | 2111702.11927 | 37.7776822169597 | -122.482489301184 | (37.7776822169597, -122.482489301184) | 11 | 6 | 2 | 55 | 26 | |||
| 76419 | 224128 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 18 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999679.40978 | 2101490.53022 | 37.7502735763867 | -122.443941232111 | (37.7502735763867, -122.443941232111) | 2 | 5 | 5 | 63 | 38 | |||
| 80510 | 224127 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 950 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999802.03186 | 2102082.04496 | 37.7519047262434 | -122.443559684852 | (37.7519047262434, -122.443559684852) | 2 | 5 | 5 | 63 | 38 | |||
| 83388 | 224126 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3213 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006857.14128 | 2103777.70396 | 37.7569604557817 | -122.419282344129 | (37.7569604557817, -122.419282344129) | 2 | 4 | 7 | 28859 | 19 | |||
| 87091 | 224118 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1525 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009611.07907 | 2100364.72243 | 37.7477438841853 | -122.409517278718 | (37.7477438841853, -122.409517278718) | 2 | 7 | 7 | 28859 | 2 | |||
| 89041 | 224124 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008668.58024 | 2101297.73586 | 37.7502528748804 | -122.412842355611 | (37.7502528748804, -122.412842355611) | 2 | 4 | 7 | 28859 | 19 | |||
| 107290 | 207710 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 641 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992286.81518 | 2103851.81856 | 37.7563325940936 | -122.46967695664 | (37.7563325940936, -122.46967695664) | 1 | 8 | 4 | 56 | 12 | |||
| 122502 | 207720 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 750 Grafton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994515.75563 | 2090598.91337 | 37.7200719768186 | -122.461008027219 | (37.7200719768186, -122.461008027219) | 9 | 8 | 6 | 28861 | 24 | |||
| 129645 | 207729 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 10 Mendosa Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993528.03028 | 2101159.37914 | 37.749011508282 | -122.465188881878 | (37.749011508282, -122.465188881878) | 1 | 8 | 4 | 29491 | 40 | |||
| 138423 | 118733 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 706 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5982303.90559 | 2110925.66237 | 37.7751732905824 | -122.504724857451 | (37.7751732905824, -122.504724857451) | 11 | 6 | 2 | 55 | 26 | |||
| 148176 | 176275 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 23 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999165.78727 | 2086612.07538 | 37.7093915094837 | -122.444648098339 | (37.7093915094837, -122.444648098339) | 9 | 7 | 6 | 28861 | 5 | |||
| 158130 | 191693 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2212 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012143.16846 | 2101895.7398 | 37.7520892815067 | -122.400868941954 | (37.7520892815067, -122.400868941954) | 10 | 3 | 8 | 28856 | 29 | |||
| 190243 | 224129 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 26 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999702.07185 | 2101445.78437 | 37.7501520078164 | -122.443859651015 | (37.7501520078164, -122.443859651015) | 2 | 5 | 5 | 63 | 38 | |||
| 35504 | 118831 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 662 46th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5981671.941 | 2111218.67307 | 37.7759406157401 | -122.506932665798 | (37.7759406157401, -122.506932665798) | 11 | 6 | 2 | 55 | 26 | |||
| 59884 | 207731 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 32 Malta Dr | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5999573.25493 | 2096045.34694 | 37.7353163497697 | -122.443917140176 | (37.7353163497697, -122.443917140176) | 9 | 7 | 4 | 63 | 40 | |||
| 149641 | 224132 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 310 Liberty St | 26 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004003.01868 | 2103934.91108 | 37.7572309538551 | -122.429164182884 | (37.7572309538551, -122.429164182884) | 2 | 4 | 5 | 28862 | 3 | |||
| 38804 | 207730 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 740 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5998158.00142 | 2095945.96511 | 37.7349626400957 | -122.44880301654 | (37.7349626400957, -122.44880301654) | 9 | 7 | 4 | 59 | 40 | |||
| 107253 | 207717 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1180 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995974.63238 | 2091762.70234 | 37.7233513070047 | -122.456049310222 | (37.7233513070047, -122.456049310222) | 9 | 8 | 4 | 28861 | 24 | |||
| 132651 | 207707 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1254 18th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990519.64263 | 2106849.66281 | 37.7644615768749 | -122.476007325895 | (37.7644615768749, -122.476007325895) | 11 | 8 | 3 | 56 | 12 |
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) );