trees

29 rows where qLegalStatus_id = 4 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

qLegalStatus_id ✖

  • Undocumented · 29 ✖
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)
1841 113206 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
31564 113207 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
49622 113208 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
57700 113210 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
73407 113205 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
112453 113209 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
160970 107168 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 65 SCOTT ST   Sidewalk: Curb side : Cutout Tree Private 2       2x2   6002336.3 2108640.7 37.7700574118158 -122.435264926513 (37.7700574118158, -122.435264926513) 15 5 5 29492 9
1070 261149 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 322x Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991839 2099782 37.7451320352893 -122.470929181064 (37.7451320352893, -122.470929181064) 1 8 4 29491 40
3681 106711 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3990 FOLSOM ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008366.1 2096547.2 37.7371919715517 -122.413552407719 (37.7371919715517, -122.413552407719) 2 7 7 28859 2
4589 261026 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 758 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5989802 2110189 37.7735888483109 -122.478733667362 (37.7735888483109, -122.478733667362) 11 6 2 55 26
8836 262545 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 1919 Donner Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/2020 12:00:00 AM 3 3x3   6011672 2093386 37.7286970547273 -122.401900181645 (37.7286970547273, -122.401900181645) 10 3 8 58 1
9568 261150 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
16950 261148 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
19544 261022 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 393 30th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5986499 2113341 37.7820510072297 -122.490391009154 (37.7820510072297, -122.490391009154) 11 6 2 55 26
35685 99537 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2012 12:00:00 AM   3x3 Permit Number 768635 6004924.7 2102557.1 37.7534999396673 -122.425878575683 (37.7534999396673, -122.425878575683) 2 4 5 28862 22
52019 119902 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 598 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002915 2095952 37.7352500947879 -122.43235683741 (37.7352500947879, -122.43235683741) 2 7 5 63 7
63335 102588 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 222 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002344.3 2109244.2 37.7717149279992 -122.435280428905 (37.7717149279992, -122.435280428905) 15 5 11 29492 9
69208 119901 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 598 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002915 2095952 37.7352500947879 -122.43235683741 (37.7352500947879, -122.43235683741) 2 7 5 63 7
73676 102018 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 4252 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001333 2103370 37.7555283353782 -122.438357655981 (37.7555283353782, -122.438357655981) 2 4 5 28862 3
88447 113211 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 50x DASHIELL HAMMETT ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
100013 112856 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 1700x BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6000040 2114920 37.7871680933118 -122.443658934554 (37.7871680933118, -122.443658934554) 15 6 1 29490 31
106236 120108 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3528 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2016 12:00:00 AM 3 3x3 Permit Number 778087 6004858 2103141 37.7550994230029 -122.426150804554 (37.7550994230029, -122.426150804554) 2 4 5 28862 22
111705 74111 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 500X Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1994 12:00:00 AM 15 3x3   6003976.59234436 2092494.78352221 37.7258174919201 -122.428440184616 (37.7258174919201, -122.428440184616) 9 7 6 28861 5
135740 112364 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 501X 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5993143 2111731 37.7780161887977 -122.467288887933 (37.7780161887977, -122.467288887933) 11 6 2 54 11
172907 112365 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 501x 09TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993143 2111731 37.7780161887977 -122.467288887933 (37.7780161887977, -122.467288887933) 11 6 2 54 11
186207 114881 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 122 COLLEGE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6004593 2095924 37.7352682180932 -122.426553380791 (37.7352682180932, -122.426553380791) 2 7 5 28861 2
92787 114424 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 724 MOULTRIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 4x2   6007601 2096031 37.735731608506 -122.416161167234 (37.735731608506, -122.416161167234) 2 7 7 28859 2
164117 109153 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 124 LILY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x2   6005951.6 2110200.9 37.7745459888588 -122.422870538078 (37.7745459888588, -122.422870538078) 7 9 11 28852 10
181605 107942 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 415 KIRKHAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2016 12:00:00 AM 3 6x5 Permit Number 775659 5993574.7 2105234.4 37.760203156894 -122.465323466087 (37.760203156894, -122.465323466087) 1 8 4 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)
);