trees
29 rows where qSpecies_id = 88 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10813 | 100543 | Undocumented 4 | Acer spp :: Maple 88 | 290X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | |||||||||||||
767 | 100549 | Undocumented 4 | Acer spp :: Maple 88 | 290X Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | |||||||||||||
315 | 106681 | Undocumented 4 | Acer spp :: Maple 88 | 272 COLLINGWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002031.2 | 2104270.9 | 37.7580416780136 | -122.436007529668 | (37.7580416780136, -122.436007529668) | 2 | 4 | 5 | 28862 | 3 | |||||
48033 | 106682 | Undocumented 4 | Acer spp :: Maple 88 | 212 COLLINGWOOD ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002028.5 | 2104520.8 | 37.7587276896571 | -122.436034749265 | (37.7587276896571, -122.436034749265) | 2 | 4 | 5 | 28862 | 3 | ||||||
822 | 112248 | DPW Maintained 1 | Acer spp :: Maple 88 | 1799X TAYLOR ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 15 | 6008739 | 2118839 | 37.7984210068607 | -122.413839504702 | (37.7984210068607, -122.413839504702) | 5 | 1 | 10 | 308 | 21 | ||||
44506 | 122799 | DPW Maintained 1 | Acer spp :: Maple 88 | 182 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5995585.03649 | 2114951.39804 | 37.7869992113112 | -122.459074312759 | (37.7869992113112, -122.459074312759) | 11 | 6 | 1 | 54 | 31 | ||||
132699 | 125419 | DPW Maintained 1 | Acer spp :: Maple 88 | 2122 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000404.99268 | 2115981.33663 | 37.790103057869 | -122.442472370315 | (37.790103057869, -122.442472370315) | 13 | 6 | 1 | 29490 | 27 | |||
18398 | 20325 | DPW Maintained 1 | Acer spp :: Maple 88 | 101X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
108564 | 203438 | DPW Maintained 1 | Acer spp :: Maple 88 | 714 Detroit St | 13 | Side Yard : Yard | Tree | Private 2 | 6 | 5999448.55059 | 2095428.31344 | 37.7336150069073 | -122.444303960174 | (37.7336150069073, -122.444303960174) | 9 | 7 | 4 | 63 | 40 | ||||
82454 | 23723 | Permitted Site 7 | Acer spp :: Maple 88 | 802X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2008 12:00:00 AM | 3 | 4X4 | 6003990.0153246 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | 7 | 9 | 11 | 28852 | 41 | ||
15747 | 245365 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001863.1078 | 2108862.114 | 37.7706384767443 | -122.436917542168 | (37.7706384767443, -122.436917542168) | 15 | 5 | 11 | 29492 | 9 | |||
128199 | 245906 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001865.9151 | 2108842.8634 | 37.7705857789269 | -122.436906453346 | (37.7705857789269, -122.436906453346) | 15 | 5 | 11 | 29492 | 9 | |||
145248 | 245908 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001868.7225 | 2108822.4097 | 37.7705297776993 | -122.436895278053 | (37.7705297776993, -122.436895278053) | 15 | 5 | 11 | 29492 | 9 | |||
131201 | 245911 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001845.0604 | 2108986.0395 | 37.7709777196527 | -122.436988841745 | (37.7709777196527, -122.436988841745) | 15 | 5 | 11 | 29492 | 9 | |||
116687 | 245912 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6001842.253 | 2109004.087 | 37.771027114039 | -122.436999844882 | (37.771027114039, -122.436999844882) | 15 | 5 | 11 | 29492 | 9 | |||
29830 | 245913 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001839.4456 | 2109021.7333 | 37.7710754068283 | -122.437010819306 | (37.7710754068283, -122.437010819306) | 15 | 5 | 11 | 29492 | 9 | |||
44874 | 245916 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001847.8677 | 2108968.7942 | 37.7709305279013 | -122.436977896408 | (37.7709305279013, -122.436977896408) | 15 | 5 | 11 | 29492 | 9 | |||
81118 | 245918 | DPW Maintained 1 | Acer spp :: Maple 88 | 200x Divisadero St | 4 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6001860.7014 | 2108879.7604 | 37.7706867926106 | -122.436927129425 | (37.7706867926106, -122.436927129425) | 15 | 5 | 11 | 29492 | 9 | |||
14290 | 251816 | DPW Maintained 1 | Acer spp :: Maple 88 | 1800 Ellis St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002197 | 2113045 | 37.7821426069022 | -122.436061972283 | (37.7821426069022, -122.436061972283) | 15 | 5 | 11 | 29490 | 41 | ||||
6928 | 260474 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 2 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
3724 | 260475 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
14900 | 260476 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 4 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
160732 | 31146 | DPW Maintained 1 | Acer spp :: Maple 88 | 500 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 3 | Permit Number 34853 | 5998061.9745 | 2094408.95279 | 37.7307368778053 | -122.44902432803 | (37.7307368778053, -122.44902432803) | 9 | 7 | 4 | 59 | 40 | |
36275 | 3752 | DPW Maintained 1 | Acer spp :: Maple 88 | 1000 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012438.0377853 | 2103297.9664682 | 37.755955933673 | -122.399947693157 | (37.755955933673, -122.399947693157) | 10 | 3 | 8 | 28856 | 29 | |||
15647 | 47041 | Permitted Site 7 | Acer spp :: Maple 88 | 50 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 1 | 3x3 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | 7 | 9 | 11 | 28852 | 10 | |
63856 | 58664 | Permitted Site 7 | Acer spp :: Maple 88 | 1177 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2010 12:00:00 AM | 3x3 | Permit Number 53728 | 5997356.04409087 | 2106085.73086087 | 37.7627580410745 | -122.452307083545 | (37.7627580410745, -122.452307083545) | 15 | 5 | 11 | 29492 | 12 | ||
93265 | 61909 | Permitted Site 7 | Acer spp :: Maple 88 | 440 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2014 12:00:00 AM | 18 | 4x4 | Permit Number 773023 | 6005831.34530489 | 2107876.05968072 | 37.7681557493195 | -122.423121239386 | (37.7681557493195, -122.423121239386) | 8 | 4 | 5 | 28853 | 19 | |
94831 | 6371 | DPW Maintained 1 | Acer spp :: Maple 88 | 2101 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/1992 12:00:00 AM | 6 | 3X3 | 6000750.81979 | 2112712.53473 | 37.7811474767301 | -122.441041230886 | (37.7811474767301, -122.441041230886) | 15 | 5 | 1 | 29490 | 41 | ||
184972 | 91267 | Permitted Site 7 | Acer spp :: Maple 88 | 1169 Tennessee St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2009 12:00:00 AM | 3x3 | Permit Number 52050 | 6015590 | 2103554 | 37.7568341715918 | -122.389064949913 | (37.7568341715918, -122.389064949913) | 10 | 3 | 8 | 28856 | 29 |
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) );