trees
32 rows where Supervisor Districts = 9 and qSpecies_id = 59 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67051 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 2 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
| 93639 | 91056 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 750 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 6012569 | 2113092 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | 6 | 2 | 9 | 28853 | 34 | ||||
| 148445 | 91057 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 750 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 6x4 | 6012569 | 2113092 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | 6 | 2 | 9 | 28853 | 34 | |||
| 184663 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 1 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
| 6092 | 196018 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015632.04702 | 2110689.93838 | 37.7764302375944 | -122.389417852744 | (37.7764302375944, -122.389417852744) | 14 | 3 | 9 | 310 | 20 | ||||
| 10408 | 195999 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6016051.5903 | 2110711.60548 | 37.7765129824099 | -122.387968033214 | (37.7765129824099, -122.387968033214) | 14 | 3 | 9 | 310 | 20 | ||||
| 23490 | 196012 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015764.41678 | 2110694.68671 | 37.7764506135265 | -122.388960275907 | (37.7764506135265, -122.388960275907) | 14 | 3 | 9 | 310 | 20 | ||||
| 30255 | 196014 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015720.48392 | 2110692.27541 | 37.7764415573597 | -122.389112085054 | (37.7764415573597, -122.389112085054) | 14 | 3 | 9 | 310 | 20 | ||||
| 32582 | 196000 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6016029.90141 | 2110710.35403 | 37.7765083446095 | -122.38804297462 | (37.7765083446095, -122.38804297462) | 14 | 3 | 9 | 310 | 20 | ||||
| 37957 | 196010 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015807.5178 | 2110696.90854 | 37.7764591031505 | -122.38881133109 | (37.7764591031505, -122.38881133109) | 14 | 3 | 9 | 310 | 20 | ||||
| 39747 | 196021 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6015567.39764 | 2110686.7089 | 37.7764177856004 | -122.389641269543 | (37.7764177856004, -122.389641269543) | 14 | 3 | 9 | 310 | 20 | ||||
| 49343 | 196013 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015743.28218 | 2110693.67028 | 37.7764466511333 | -122.389033316139 | (37.7764466511333, -122.389033316139) | 14 | 3 | 9 | 310 | 20 | ||||
| 68586 | 196022 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6015549.75144 | 2110684.1794 | 37.7764098616684 | -122.389702136539 | (37.7764098616684, -122.389702136539) | 14 | 3 | 9 | 310 | 20 | ||||
| 80958 | 196006 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6015895.59891 | 2110702.13918 | 37.7764783468376 | -122.388506996001 | (37.7764783468376, -122.388506996001) | 14 | 3 | 9 | 310 | 20 | ||||
| 81978 | 196007 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015874.48096 | 2110701.94702 | 37.7764766489106 | -122.388580036236 | (37.7764766489106, -122.388580036236) | 14 | 3 | 9 | 310 | 20 | ||||
| 84576 | 196011 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015786.39152 | 2110696.30426 | 37.7764562729832 | -122.388884371337 | (37.7764562729832, -122.388884371337) | 14 | 3 | 9 | 310 | 20 | ||||
| 87935 | 196005 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015919.22066 | 2110703.31156 | 37.7764828749315 | -122.38842536276 | (37.7764828749315, -122.38842536276) | 14 | 3 | 9 | 310 | 20 | ||||
| 100049 | 196024 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6013848.21751 | 2107498.56576 | 37.7675683801977 | -122.395365047877 | (37.7675683801977, -122.395365047877) | 14 | 3 | 9 | 310 | 20 | |||
| 100061 | 195998 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6016075.49067 | 2110714.30849 | 37.7765217283366 | -122.387885542896 | (37.7765217283366, -122.387885542896) | 14 | 3 | 9 | 310 | 20 | ||||
| 108842 | 196023 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1670 Owen St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6013858.29957 | 2107482.27299 | 37.7675242045935 | -122.395329033601 | (37.7675242045935, -122.395329033601) | 14 | 3 | 9 | 310 | 20 | |||
| 121735 | 196003 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015962.95079 | 2110705.93329 | 37.7764924967751 | -122.388274269443 | (37.7764924967751, -122.388274269443) | 14 | 3 | 9 | 310 | 20 | ||||
| 126204 | 196009 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | 14 | 3 | 9 | 310 | 20 | ||||
| 137112 | 196001 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6016008.12939 | 2110708.52586 | 37.7765021186104 | -122.388118163334 | (37.7765021186104, -122.388118163334) | 14 | 3 | 9 | 310 | 20 | ||||
| 138177 | 196019 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015611.09455 | 2110687.68162 | 37.7764228793455 | -122.389490176245 | (37.7764228793455, -122.389490176245) | 14 | 3 | 9 | 310 | 20 | ||||
| 145197 | 196008 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015854.16157 | 2110700.296 | 37.7764709894889 | -122.388650212137 | (37.7764709894889, -122.388650212137) | 14 | 3 | 9 | 310 | 20 | ||||
| 155750 | 196017 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015653.37625 | 2110690.3321 | 37.776432501193 | -122.389344095768 | (37.776432501193, -122.389344095768) | 14 | 3 | 9 | 310 | 20 | ||||
| 158107 | 196020 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015589.15281 | 2110687.71234 | 37.7764217471115 | -122.38956608172 | (37.7764217471115, -122.38956608172) | 14 | 3 | 9 | 310 | 20 | ||||
| 169789 | 196016 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015678.42156 | 2110690.23877 | 37.7764336334278 | -122.389257449686 | (37.7764336334278, -122.389257449686) | 14 | 3 | 9 | 310 | 20 | ||||
| 175828 | 195997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | 14 | 3 | 9 | 310 | 20 | ||||
| 184380 | 196015 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015698.09519 | 2110690.66596 | 37.7764358970472 | -122.389189422279 | (37.7764358970472, -122.389189422279) | 14 | 3 | 9 | 310 | 20 | ||||
| 185058 | 196002 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015985.51722 | 2110706.09628 | 37.7764941946745 | -122.388196216398 | (37.7764941946745, -122.388196216398) | 14 | 3 | 9 | 310 | 20 | ||||
| 191532 | 196004 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015940.35109 | 2110704.12187 | 37.7764862707572 | -122.388352322497 | (37.7764862707572, -122.388352322497) | 14 | 3 | 9 | 310 | 20 |
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) );