trees
23 rows where Neighborhoods (old) = 24 and qSpecies_id = 65 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
qLegalStatus_id ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
138 | 203559 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605794 | (37.7168578537955, -122.45182605794) | 9 | 8 | 6 | 28861 | 24 | |||
6932 | 112764 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908 | (37.7167707693614, -122.45190370908) | 9 | 8 | 6 | 28861 | 24 | ||
32128 | 96872 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 620 Palmetto Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x3 | 5991838.49017 | 2087239.32227 | 37.7106929318927 | -122.470017846453 | (37.7106929318927, -122.470017846453) | 9 | 8 | 4 | 64 | 24 | |||
50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
59853 | 1275 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5992427.65168 | 2087335.55006 | 37.710991191174 | -122.467988584733 | (37.710991191174, -122.467988584733) | 9 | 8 | 4 | 64 | 24 | |||
63762 | 53384 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.7192800571495 | -122.460304141 | (37.7192800571495, -122.460304141) | 9 | 8 | 6 | 28861 | 24 | ||
80252 | 112745 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.452086194059 | (37.7152791660762, -122.452086194059) | 9 | 8 | 6 | 28861 | 24 | ||
87773 | 203558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997048.33435 | 2088809.54157 | 37.7153041877202 | -122.45212476956 | (37.7153041877202, -122.45212476956) | 9 | 8 | 6 | 28861 | 24 | |||
89653 | 66234 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29332 | 5995321.94630668 | 2091329.89787669 | 37.7221254446058 | -122.458274198204 | (37.7221254446058, -122.458274198204) | 9 | 8 | 4 | 28861 | 24 | ||
93586 | 102654 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995004 | 2088355 | 37.7139388056528 | -122.459157943572 | (37.7139388056528, -122.459157943572) | 9 | 8 | 6 | 28861 | 24 | |||
103379 | 60473 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.7167021506206 | -122.451539811129 | (37.7167021506206, -122.451539811129) | 9 | 8 | 6 | 28861 | 24 | |||
104709 | 66250 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 718 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29350 | 5994696.57852166 | 2091262.84709817 | 37.721905383508 | -122.460431070774 | (37.721905383508, -122.460431070774) | 9 | 8 | 4 | 28861 | 24 | ||
112681 | 1278 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/1990 12:00:00 AM | 12 | 3X3 | 5992545.03604 | 2087392.68167 | 37.711154838998 | -122.467587032028 | (37.711154838998, -122.467587032028) | 9 | 8 | 4 | 64 | 24 | ||
118838 | 203560 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5997153.12879 | 2089368.29033 | 37.7168443846497 | -122.451802840126 | (37.7168443846497, -122.451802840126) | 9 | 8 | 6 | 28861 | 24 | |||
119492 | 203554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.7140014477918 | -122.459370769157 | (37.7140014477918, -122.459370769157) | 9 | 8 | 6 | 28861 | 24 | |||
143712 | 1265 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5992172.84146 | 2087217.03484 | 37.7106510585713 | -122.468860642897 | (37.7106510585713, -122.468860642897) | 9 | 8 | 4 | 64 | 24 | ||
144920 | 1269 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992328.07158 | 2087287.97745 | 37.7108548170665 | -122.468329295555 | (37.7108548170665, -122.468329295555) | 9 | 8 | 4 | 64 | 24 | |||
145465 | 96870 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 620 Palmetto Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x3 | 5991859.90832 | 2087240.59875 | 37.7106976749231 | -122.469943914081 | (37.7106976749231, -122.469943914081) | 9 | 8 | 4 | 64 | 24 | |||
151383 | 1266 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5992143.83128 | 2087204.78999 | 37.7106157610663 | -122.46896001711 | (37.7106157610663, -122.46896001711) | 9 | 8 | 4 | 64 | 24 | |||
159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
160387 | 203556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994991.30881 | 2088378.07982 | 37.7140014477822 | -122.45920347906 | (37.7140014477822, -122.45920347906) | 9 | 8 | 6 | 28861 | 24 | |||
182887 | 203553 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994715.67756 | 2090305.5088 | 37.7192778601644 | -122.46029572277 | (37.7192778601644, -122.46029572277) | 9 | 8 | 6 | 28861 | 24 | |||
189907 | 1274 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3995X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 778829 | 5992454.25389 | 2087344.92394 | 37.7110184658112 | -122.467897323323 | (37.7110184658112, -122.467897323323) | 9 | 8 | 4 | 64 | 24 |
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) );