trees
18 rows where Supervisor Districts = 6 and qSpecies_id = 116 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71574 | 51838 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 135 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 8 | Permit Number 48065 | 6000803.77084 | 2087905.29553 | 37.7130357386885 | -122.43907959427 | (37.7130357386885, -122.43907959427) | 9 | 7 | 6 | 28861 | 5 | ||
| 109574 | 215417 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.462546063947 | (37.7141751725286, -122.462546063947) | 9 | 8 | 6 | 28861 | 24 | ||||
| 110970 | 65602 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.91359 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | 9 | 7 | 6 | 28861 | 5 | |
| 155667 | 47386 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 400 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45302 | 5998534.7421818 | 2087640.83447452 | 37.7121802187249 | -122.446903063491 | (37.7121802187249, -122.446903063491) | 9 | 7 | 6 | 28861 | 25 | |||
| 164234 | 215418 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 5994025.68496 | 2088506.93737 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | 9 | 8 | 6 | 28861 | 24 | ||||
| 169945 | 179965 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 86 Arago St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999606.18552 | 2093002.38033 | 37.7269629528551 | -122.443584762453 | (37.7269629528551, -122.443584762453) | 9 | 7 | 6 | 28861 | 25 | ||||
| 171280 | 215416 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 5994027.68196 | 2088444.22736 | 37.7141276262766 | -122.462538908049 | (37.7141276262766, -122.462538908049) | 9 | 8 | 6 | 28861 | 24 | ||||
| 42342 | 215419 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Minerva St | 36 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5996348.60637 | 2088999.95907 | 37.7157869222005 | -122.454557070559 | (37.7157869222005, -122.454557070559) | 9 | 8 | 6 | 28861 | 24 | |||
| 51525 | 161041 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 200 Munich St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781115 | 6004713.602 | 2091215.63937 | 37.722346921643 | -122.425801386648 | (37.722346921643, -122.425801386648) | 9 | 7 | 6 | 28861 | 5 | |
| 68174 | 179967 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6005275.29843 | 2092450.03888 | 37.7257680389529 | -122.423947466603 | (37.7257680389529, -122.423947466603) | 9 | 7 | 6 | 309 | 5 | |||
| 103790 | 179968 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 675 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6005852.39602 | 2093589.23287 | 37.7289285803821 | -122.422033372066 | (37.7289285803821, -122.422033372066) | 9 | 7 | 6 | 28861 | 5 | |||
| 120616 | 179966 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005255.40982 | 2092462.48384 | 37.725801087223 | -122.424017104714 | (37.725801087223, -122.424017104714) | 9 | 7 | 6 | 309 | 5 | |||
| 46615 | 179964 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002952.82685 | 2087126.87824 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | 9 | 7 | 6 | 28861 | 5 | |||
| 117066 | 179963 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002963.44574 | 2087110.53022 | 37.7109761365014 | -122.431558338255 | (37.7109761365014, -122.431558338255) | 9 | 7 | 6 | 28861 | 5 | |||
| 177846 | 179970 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 307 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004288.05392 | 2091472.8528 | 37.7230291158735 | -122.427290720601 | (37.7230291158735, -122.427290720601) | 9 | 7 | 6 | 28861 | 5 | |||
| 48118 | 179956 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5998852.53516 | 2088480.84158 | 37.7145048379104 | -122.44586505734 | (37.7145048379104, -122.44586505734) | 9 | 7 | 6 | 28861 | 25 | |||
| 50905 | 179971 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 160 Baltimore Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002384.15556 | 2086207.41957 | 37.7084635404231 | -122.43349600315 | (37.7084635404231, -122.43349600315) | 9 | 7 | 6 | 28861 | 5 | |||
| 84902 | 179955 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5998862.1125 | 2088471.16796 | 37.7144788232093 | -122.445831259031 | (37.7144788232093, -122.445831259031) | 9 | 7 | 6 | 28861 | 25 |
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) );