trees

20 rows where SiteOrder = 2 and qSpecies_id = 101

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
405 113785 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
1942 113791 Undocumented 4 Ficus Spp. :: 101 1152 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
6787 133029 DPW Maintained 1 Ficus Spp. :: 101 899 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009680.35355 2116058.51937 37.790839305841 -122.410385687447 (37.790839305841, -122.410385687447) 5 1 10 28857 21
12510 176400 DPW Maintained 1 Ficus Spp. :: 101 640 Rolph St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6002836.32134 2087254.29787 37.7113636849491 -122.432007969613 (37.7113636849491, -122.432007969613) 9 7 6 28861 5
16405 114682 Undocumented 4 Ficus Spp. :: 101 235 GEARY ST 2 Sidewalk: Curb side : Pot Tree Private 2           6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
26643 126615 DPW Maintained 1 Ficus Spp. :: 101 728 Washington St 2 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6011119.33477 2117657.8785 37.7953113232058 -122.405519543093 (37.7953113232058, -122.405519543093) 3 1 10 28857 4
32024 109349 DPW Maintained 1 Ficus Spp. :: 101 2505 Pacific Ave 2 Sidewalk: Property side : Cutout Landscaping Private 2   02/11/2015 12:00:00 AM 3 .5x1   6002092 2116990 37.7929686009801 -122.43670770269 (37.7929686009801, -122.43670770269) 13 6 1 29490 27
34419 116605 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Front Yard : Yard Tree MTA 3           5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
34442 113460 Undocumented 4 Ficus Spp. :: 101 18X LEROY PL 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008359 2116564 37.7921530708525 -122.414993316892 (37.7921530708525, -122.414993316892) 5 1 10 28858 21
34778 176401 DPW Maintained 1 Ficus Spp. :: 101 70 Seville St 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6001944.11467 2087434.6478 37.7118082639075 -122.435104550352 (37.7118082639075, -122.435104550352) 9 7 6 28861 5
69386 138057 DPW Maintained 1 Ficus Spp. :: 101 1881 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003668.147 2114533.432 37.7863129354864 -122.431078737912 (37.7863129354864, -122.431078737912) 13 9 11 29490 13
73906 113789 Undocumented 4 Ficus Spp. :: 101 1156 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008031 2101136 37.7497729763299 -122.415035709272 (37.7497729763299, -122.415035709272) 2 4 7 28859 19
95857 115108 Undocumented 4 Ficus Spp. :: 101 1500x VALLEJO ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006364 2118351 37.7969474175895 -122.422023061413 (37.7969474175895, -122.422023061413) 13 9 10 28858 32
99594 218964 DPW Maintained 1 Ficus Spp. :: 101 530 Rockdale Dr 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997978.47661 2097724.68038 37.7398362974137 -122.449551820875 (37.7398362974137, -122.449551820875) 9 7 4 59 40
126028 224466 DPW Maintained 1 Ficus Spp. :: 101 915 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6009421.97023 2103694.42004 37.7568758925253 -122.410406283718 (37.7568758925253, -122.410406283718) 2 4 7 28859 19
130742 224461 DPW Maintained 1 Ficus Spp. :: 101 1079 Hampshire St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6010270.40379 2102959.48183 37.7549054419377 -122.407420259331 (37.7549054419377, -122.407420259331) 10 4 7 28859 19
132762 187569 DPW Maintained 1 Ficus Spp. :: 101 138 Alpha St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 10ft   6010894.99244 2088100.29699 37.7141402059746 -122.404214497313 (37.7141402059746, -122.404214497313) 9 7 8 309 39
137291 199416 DPW Maintained 1 Ficus Spp. :: 101 1650 Davidson Ave 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 4ft   6014427.53961 2099828.51957 37.7465402873024 -122.392824572817 (37.7465402873024, -122.392824572817) 10 3 8 58 1
142301 114953 Undocumented 4 Ficus Spp. :: 101 601x OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
145690 116607 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12

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