trees

14 rows where Zip Codes = 29491 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Zip Codes

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)
23215 218419 DPW Maintained 1 Taxus baccata :: Irish Yew 86 206 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5994236.56093 2100588.83344 37.7474857670642 -122.462697413572 (37.7474857670642, -122.462697413572) 1 8 4 29491 40
38031 215288 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Pacheco St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5991477.1073 2101838.1015 37.7507566211347 -122.472330389247 (37.7507566211347, -122.472330389247) 1 8 4 29491 12
42109 215292 DPW Maintained 1 Taxus baccata :: Irish Yew 86 275 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     31 Width 4ft   5994414.45382 2100572.16969 37.747450256423 -122.462081067713 (37.747450256423, -122.462081067713) 1 8 4 29491 40
44075 215290 DPW Maintained 1 Taxus baccata :: Irish Yew 86 496 Pacheco St 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 6ft   5993542.94164 2101911.83549 37.7510784210541 -122.465191965655 (37.7510784210541, -122.465191965655) 1 8 4 29491 12
61794 215293 DPW Maintained 1 Taxus baccata :: Irish Yew 86 275 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     33 Width 4ft   5994427.84018 2100560.89209 37.747420061691 -122.462033961208 (37.747420061691, -122.462033961208) 1 8 4 29491 40
89241 215332 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2075 09th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     25 Width 3ft   5993490.42536 2101424.27814 37.7497366847097 -122.46533815853 (37.7497366847097, -122.46533815853) 1 8 4 29491 40
92970 215331 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2095 09th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5993556.00602 2101376.01116 37.7496079377635 -122.465107874536 (37.7496079377635, -122.465107874536) 1 8 4 29491 40
105158 215289 DPW Maintained 1 Taxus baccata :: Irish Yew 86 496 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 6ft   5993555.20621 2101912.20382 37.7510801396391 -122.465149580605 (37.7510801396391, -122.465149580605) 1 8 4 29491 12
119328 215333 DPW Maintained 1 Taxus baccata :: Irish Yew 86 8 Mendosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5993587.48804 2101138.42118 37.7489573915925 -122.464981756306 (37.7489573915925, -122.464981756306) 1 8 4 29491 40
127847 218418 DPW Maintained 1 Taxus baccata :: Irish Yew 86 206 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5994240.64803 2100595.30557 37.7475037732855 -122.462683750177 (37.7475037732855, -122.462683750177) 1 8 4 29491 40
157108 114608 Undocumented 4 Taxus baccata :: Irish Yew 86 2398X 15TH AVE 2 Sidewalk: Property side : Cutout Tree Private 2     6     5991654 2099150 37.7433860243849 -122.471522828523 (37.7433860243849, -122.471522828523) 1 8 4 29491 40
166505 215294 DPW Maintained 1 Taxus baccata :: Irish Yew 86 275 Pacheco St 4 Sidewalk: Curb side : Yard Tree Private 2     32 Width 4ft   5994441.43842 2100548.35757 37.7473864279531 -122.461986030947 (37.7473864279531, -122.461986030947) 1 8 4 29491 40
171043 215330 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2095 09th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5993552.71459 2101379.42964 37.7496171342399 -122.465119504581 (37.7496171342399, -122.465119504581) 1 8 4 29491 40
190200 215291 DPW Maintained 1 Taxus baccata :: Irish Yew 86 275 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 4ft   5994404.07408 2100583.57652 37.7474809790792 -122.462117787007 (37.7474809790792, -122.462117787007) 1 8 4 29491 40

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);