23 rows where qSpecies_id = 241 sorted by rowid descending

View and edit SQL

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)
183034 187976 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 5 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   6013686.9099 2092676.67516 37.726861637932 -122.394884804484 (37.726861637932, -122.394884804484) 10 3 8 58 1
177854 187977 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 6 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6013646.8498 2092708.23202 37.726946059107 -122.395025501647 (37.726946059107, -122.395025501647) 10 3 8 58 1
167600 200825 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5300 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6014263.6097 2093382.4616 37.7288316349873 -122.392940510044 (37.7288316349873, -122.392940510044) 10 3 8 58 1
152607 22359 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5330X 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/09/1995 12:00:00 AM 3 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574) 10 3 8 58 1
142371 22360 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5330X 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     5 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574) 10 3 8 58 1
126869 187975 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 4 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   6013720.25954 2092652.55253 37.7267972563783 -122.394767826095 (37.7267972563783, -122.394767826095) 10 3 8 58 1
119799 200827 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5300 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6014256.7382 2093362.9923 37.7287777945327 -122.392962903849 (37.7287777945327, -122.392962903849) 10 3 8 58 1
108622 187978 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 7 Sidewalk: Curb side : Yard Tree Private 2     11 Width 5ft   6013630.25148 2092720.21437 37.726978037202 -122.395083721055 (37.726978037202, -122.395083721055) 10 3 8 58 1
106830 187981 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 10 Sidewalk: Curb side : Yard Tree Private 2     11 Width 5ft   6013574.18197 2092762.03339 37.7270897455934 -122.395280481931 (37.7270897455934, -122.395280481931) 10 3 8 58 1
104977 100229 DPW Maintained 1 Alnus cordata :: Italian Alder 241 701X 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2016 12:00:00 AM 3 3x3 Permit Number 778265 5983807.97543 2110975.72776 37.7753991192247 -122.499525725678 (37.7753991192247, -122.499525725678) 11 6 2 55 26
104586 187983 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 12 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   6013541.30669 2092786.45742 37.7271549806017 -122.395395842461 (37.7271549806017, -122.395395842461) 10 3 8 58 1
99287 200826 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5300 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6014262.4645 2093372.7269 37.7288048418563 -122.392943788301 (37.7288048418563, -122.392943788301) 10 3 8 58 1
91995 222008 DPW Maintained 1 Alnus cordata :: Italian Alder 241 22 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 4ft   6004062.61518 2108585.10305 37.7700026390277 -122.429289661699 (37.7700026390277, -122.429289661699) 7 9 5 29492 10
88928 200824 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5300 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6014267.0455 2093396.2046 37.7288695613347 -122.392929593283 (37.7288695613347, -122.392929593283) 10 3 8 58 1
86071 187984 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 13 Sidewalk: Curb side : Yard Tree Private 2     11 Width 5ft   6013523.18412 2092800.17844 37.7271916477681 -122.395459453304 (37.7271916477681, -122.395459453304) 10 3 8 58 1
75896 187980 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 9 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   6013594.15592 2092747.34309 37.7270505198448 -122.395210403156 (37.7270505198448, -122.395210403156) 10 3 8 58 1
71375 181967 DPW Maintained 1 Alnus cordata :: Italian Alder 241 2423 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5986399.1816 2098739.8329 37.7419544119514 -122.489662245235 (37.7419544119514, -122.489662245235) 1 8 3 29491 35
62123 22361 DPW Maintained 1 Alnus cordata :: Italian Alder 241 5330X 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1     5 3X3   6014288.31752 2093466.43912 37.7290635926926 -122.392860965574 (37.7290635926926, -122.392860965574) 10 3 8 58 1
48480 187982 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 11 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   6013557.45285 2092775.26074 37.7271251348046 -122.395339240918 (37.7271251348046, -122.395339240918) 10 3 8 58 1
36367 187979 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 8 Sidewalk: Curb side : Yard Tree Private 2     11 Width 5ft   6013615.832 2092731.99702 37.7270095881002 -122.395134394263 (37.7270095881002, -122.395134394263) 10 3 8 58 1
27824 187974 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1740 Bancroft Ave 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6013741.64285 2092638.14431 37.7267588832154 -122.394692895458 (37.7267588832154, -122.394692895458) 10 3 8 58 1
7651 80467 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1780 Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10     6013451.73876 2092852.71308 37.7273319231299 -122.395710120444 (37.7273319231299, -122.395710120444) 10 3 8 58 1
2694 184872 DPW Maintained 1 Alnus cordata :: Italian Alder 241 1201 Sunset Blvd 61 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984669.9453 2106823.2961 37.7640482591194 -122.496237573009 (37.7640482591194, -122.496237573009) 1 8 3 56 35

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