19 rows where qSpecies_id = 326

View and edit SQL

Suggested facets: qLegalStatus_id, qAddress, qSiteInfo, qCaretaker_id, PlotSize, Police Districts, 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)
8743 261207 Significant Tree 6 Umbellularia californica :: California Bay 326 2301 Leavenworth St 3 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
13348 198717 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 38 Front Yard : Yard Tree Private 2     10     6012427.07884 2104786.19155 37.7600416617243 -122.400090104772 (37.7600416617243, -122.400090104772) 10 3 8 28856 29
28947 198719 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 40 Front Yard : Yard Tree Private 2     5     6012426.60188 2104780.3365 37.760025558456 -122.40009134316 (37.760025558456, -122.40009134316) 10 3 8 28856 29
34867 198712 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 12 Front Yard : Yard Tree Private 2     4     6012409.2868 2104740.75677 37.7599159158162 -122.400148448317 (37.7599159158162, -122.400148448317) 10 3 8 28856 29
40665 97022 Property Tree 8 Umbellularia californica :: California Bay 326 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
55491 198720 DPW Maintained 1 Umbellularia californica :: California Bay 326 1800 Illinois St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 7ft   6016247.28658 2100667.2131 37.7489440726059 -122.386590499372 (37.7489440726059, -122.386590499372) 10 3 8 58 1
56866 198718 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 39 Front Yard : Yard Tree Private 2     7     6012424.05702 2104786.65184 37.7600427570935 -122.400100588189 (37.7600427570935, -122.400100588189) 10 3 8 28856 29
60497 198711 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 11 Front Yard : Yard Tree Private 2     9     6012390.58934 2104733.77688 37.7598957080306 -122.400212623923 (37.7598957080306, -122.400212623923) 10 3 8 28856 29
63577 242817 DPW Maintained 1 Umbellularia californica :: California Bay 326 1001 San Jose Ave 75 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6005376.58121 2097527.53797 37.7397154402194 -122.423958242285 (37.7397154402194, -122.423958242285) 2 7 5 28859 2
68375 198716 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 37 Front Yard : Yard Tree Private 2     5     6012435.45526 2104782.66199 37.7600324373651 -122.400060886699 (37.7600324373651, -122.400060886699) 10 3 8 28856 29
75182 242818 DPW Maintained 1 Umbellularia californica :: California Bay 326 1001 San Jose Ave 76 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6005391.8173 2097529.9468 37.7397229144901 -122.423905733564 (37.7397229144901, -122.423905733564) 2 7 5 28859 2
103904 187619 DPW Maintained 1 Umbellularia californica :: California Bay 326 27 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005553 2098709 37.7429694263933 -122.423432230366 (37.7429694263933, -122.423432230366) 2 7 5 28859 22
142619 198714 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 14 Front Yard : Yard Tree Private 2     6     6012392.10432 2104746.43 37.7599305351797 -122.40020827299 (37.7599305351797, -122.40020827299) 10 3 8 28856 29
163082 187620 DPW Maintained 1 Umbellularia californica :: California Bay 326 33 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005528 2098708 37.7429652695588 -122.423518602522 (37.7429652695588, -122.423518602522) 2 7 5 28859 22
166443 242816 DPW Maintained 1 Umbellularia californica :: California Bay 326 2 Trainor St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008308.46792 2108230.50138 37.7692684406077 -122.41457818386 (37.7692684406077, -122.41457818386) 8 4 7 28853 19
170012 137083 DPW Maintained 1 Umbellularia californica :: California Bay 326 3699 Webster St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002550.0727 2121200.59628 37.8045558214586 -122.435424089363 (37.8045558214586, -122.435424089363) 13 9 1 57 17
177851 191362 DPW Maintained 1 Umbellularia californica :: California Bay 326 999 Key Ave 2 Sidewalk: Curb side : Yard Tree Private 2     27     6013336.3333 2089743.87801 37.7187892674983 -122.39589132572 (37.7187892674983, -122.39589132572) 10 3 8 58 1
189504 198713 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 13 Front Yard : Yard Tree Private 2     3     6012404.84739 2104738.96788 37.759910756386 -122.400163676537 (37.759910756386, -122.400163676537) 10 3 8 28856 29
193943 198715 DPW Maintained 1 Umbellularia californica :: California Bay 326 1 Jack Balestreri Way 15 Front Yard : Yard Tree Private 2     4     6012393.75722 2104758.14097 37.7599627830829 -122.40020337888 (37.7599627830829, -122.40020337888) 10 3 8 28856 29

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