trees
16 rows where Neighborhoods (old) = 2 and qSpecies_id = 119
This data as json, CSV (advanced)
These facets timed out: Neighborhoods (old)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
9830 | 224122 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008272.03754 | 2096094.48518 | 37.7359436331948 | -122.413845611379 | (37.7359436331948, -122.413845611379) | 2 | 7 | 7 | 28859 | 2 | |||
9946 | 247879 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 8 | Side Yard : Yard | Tree | Private 2 | 3 | 6009924.14803 | 2098382.32436 | 37.7423181897436 | -122.408294896795 | (37.7423181897436, -122.408294896795) | 10 | 7 | 7 | 28859 | 2 | ||||
11577 | 224121 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008290.10508 | 2096093.22608 | 37.7359411906366 | -122.413783055452 | (37.7359411906366, -122.413783055452) | 2 | 7 | 7 | 28859 | 2 | |||
19239 | 224123 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 601X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008526.38321 | 2098121.40646 | 37.7415233967761 | -122.413109512687 | (37.7415233967761, -122.413109512687) | 10 | 7 | 7 | 28859 | 2 | ||||
38491 | 246771 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1850 Alabama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6009333.37029 | 2098874.50038 | 37.743636497837 | -122.410372378408 | (37.743636497837, -122.410372378408) | 2 | 7 | 7 | 28859 | 2 | ||||
47047 | 246754 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1838 Alabama St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6009313.62627 | 2099009.88757 | 37.7440071345341 | -122.410450206611 | (37.7440071345341, -122.410450206611) | 2 | 7 | 7 | 28859 | 2 | ||||
54915 | 246770 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 99 Waltham St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | 2 | 7 | 7 | 28859 | 2 | ||||
56150 | 224116 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 400 Prospect Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6006205.79839 | 2097605.42741 | 37.7399760871276 | -122.421096686769 | (37.7399760871276, -122.421096686769) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
110805 | 246755 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1838 Alabama St | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 6009311.20113 | 2098998.06122 | 37.7439745260177 | -122.410457757318 | (37.7439745260177, -122.410457757318) | 2 | 7 | 7 | 28859 | 2 | ||||
120318 | 247873 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009888.01932 | 2098399.59712 | 37.7423635938187 | -122.408421037503 | (37.7423635938187, -122.408421037503) | 10 | 7 | 7 | 28859 | 2 | ||||
124641 | 248210 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 69 Fair Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007064.668 | 2099422.3589 | 37.7450133544796 | -122.418255851634 | (37.7450133544796, -122.418255851634) | 2 | 7 | 7 | 28859 | 2 | |||
126650 | 247967 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 16 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6010333.49571 | 2098927.49611 | 37.7438380268983 | -122.40691790615 | (37.7438380268983, -122.40691790615) | 2 | 7 | 7 | 28859 | 2 | ||||
158281 | 246774 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1850 Alabama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6009457.96402 | 2098740.81971 | 37.7432764236648 | -122.409932126974 | (37.7432764236648, -122.409932126974) | 2 | 7 | 7 | 28859 | 2 | ||||
187997 | 246764 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 70 Waltham St | 8 | Front Yard : Yard | Tree | Private 2 | 8 | 6009279.96949 | 2098891.64841 | 37.7436805888792 | -122.410558236772 | (37.7436805888792, -122.410558236772) | 2 | 7 | 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) );