trees
21 rows where SiteOrder = 5 and qSpecies_id = 116
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
| 11511 | 225198 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007149.23047 | 2103831.77129 | 37.7571253581517 | -122.418276020715 | (37.7571253581517, -122.418276020715) | 2 | 4 | 7 | 28859 | 19 | ||
| 14508 | 246217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | 15 | 5 | 11 | 29492 | 9 | |||
| 27954 | 197989 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 28 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012209.71616 | 2107476.11774 | 37.7674154774686 | -122.401030868501 | (37.7674154774686, -122.401030868501) | 14 | 3 | 8 | 28856 | 20 | |||
| 28989 | 247209 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 800 Duboce Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001860.51527 | 2108286.6653 | 37.7690582897368 | -122.436885307832 | (37.7690582897368, -122.436885307832) | 15 | 5 | 5 | 29492 | 9 | |||
| 53304 | 241211 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009079.81613 | 2106354.44033 | 37.7641605153159 | -122.411777537601 | (37.7641605153159, -122.411777537601) | 8 | 4 | 7 | 28859 | 19 | |||
| 65614 | 197983 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1809 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012297.3164 | 2105130.82765 | 37.7609807202963 | -122.400563103211 | (37.7609807202963, -122.400563103211) | 10 | 3 | 8 | 28856 | 29 | |||
| 76957 | 241198 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.7546903196133 | -122.426677105059 | (37.7546903196133, -122.426677105059) | 2 | 4 | 5 | 28862 | 22 | |||
| 85930 | 215438 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.446785584491 | (37.7290433761531, -122.446785584491) | 9 | 7 | 4 | 28861 | 40 | |||
| 89349 | 49073 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 93105 | 253487 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 97320 | 34082 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 102795 | 34050 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 103389 | 36792 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Donner Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015166.6448 | 2090882.8824 | 37.7220184063671 | -122.389644123655 | (37.7220184063671, -122.389644123655) | 10 | 3 | 8 | 58 | 1 |
| 109219 | 241183 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1720 Dolores St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005264.11037 | 2098316.58265 | 37.7418756279601 | -122.424403226839 | (37.7418756279601, -122.424403226839) | 2 | 7 | 5 | 63 | 7 | |||
| 127993 | 241196 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 285 Mullen Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010370.46966 | 2100029.81656 | 37.7468668275408 | -122.406867732983 | (37.7468668275408, -122.406867732983) | 2 | 7 | 7 | 28859 | 2 | |||
| 128873 | 215423 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993769.4086 | 2092813.96021 | 37.7261109828263 | -122.46374856184 | (37.7261109828263, -122.46374856184) | 9 | 8 | 4 | 59 | 40 | |||
| 137854 | 42733 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 144098 | 115615 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1400 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | 6012069.0366 | 2107045.8512 | 37.766226213653 | -122.401487220087 | (37.766226213653, -122.401487220087) | 14 | 3 | 8 | 28853 | 20 | |||
| 158182 | 16313 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
| 177793 | 215430 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993628.72422 | 2092981.53442 | 37.7265629928729 | -122.464247056069 | (37.7265629928729, -122.464247056069) | 9 | 8 | 4 | 59 | 40 |
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) );