34 rows where qSpecies_id = 191

View and edit SQL

Suggested facets: Police Districts

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)
1533 120590 Significant Tree 6 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 52 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003308 2106220 37.7634658909933 -122.43173097309 (37.7634658909933, -122.43173097309) 15 4 5 28862 3
6794 213749 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 300 Junipero Serra Blvd 35 : Tree Private 2     3 Width 0ft   5991393.22767 2094416.18381 37.730373076833 -122.472079533242 (37.730373076833, -122.472079533242) 9 8 4 64 40
25396 213754 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 500 Junipero Serra Blvd 42 : Tree Private 2     14 Width 0ft   5991330.93641 2093526.56464 37.7279268003585 -122.472230057282 (37.7279268003585, -122.472230057282) 9 8 4 64 40
25811 213750 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 300 Junipero Serra Blvd 44 : Tree Private 2     6 Width 0ft   5991387.79086 2094362.06295 37.7302241598981 -122.472094385544 (37.7302241598981, -122.472094385544) 9 8 4 64 40
27254 196562 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1498x Tennessee St 11 Median : Yard Tree DPW 1     6 Width 7ft   6015638.13327 2101940.52008 37.7524065650316 -122.388785850611 (37.7524065650316, -122.388785850611) 10 3 8 28856 1
37683 239037 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 3911 21st St 7 Side Yard : Yard Tree Private 2     21     6002388.77933 2103534.57817 37.7560402227013 -122.434718216874 (37.7560402227013, -122.434718216874) 2 4 5 28862 22
45193 239038 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 701 Church St 33 Front Yard : Yard Tree Private 2     7 Width 3ft   6004323.63277 2104691.6 37.7593267870093 -122.428109297917 (37.7593267870093, -122.428109297917) 2 4 5 28862 3
46567 246705 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1 Bonview St 11 Sidewalk: Curb side : Yard Tree Private 2     3     6007711.52028 2099134.96568 37.7442606264379 -122.415998797912 (37.7442606264379, -122.415998797912) 2 7 7 28859 2
46863 213751 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 500 Junipero Serra Blvd 10 : Tree Private 2     8 Width 0ft   5991347.65642 2093747.02637 37.7285331008133 -122.472188319746 (37.7285331008133, -122.472188319746) 9 8 4 64 40
47014 246886 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 3090x Market St 19 Median : Yard Tree DPW 1     9     5999895.8145 2105286.9731 37.7607100216774 -122.443465565401 (37.7607100216774, -122.443465565401) 15 5 5 28862 3
58913 213752 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 500 Junipero Serra Blvd 26 : Tree Private 2     6 Width 0ft   5991341.26433 2093653.7862 37.7282767166862 -122.472203623505 (37.7282767166862, -122.472203623505) 9 8 4 64 40
60303 86768 Permitted Site 7 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
62307 239036 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 3911 21st St 6 Side Yard : Yard Tree Private 2     16     6002387.68734 2103532.26119 37.7560337988348 -122.434721827658 (37.7560337988348, -122.434721827658) 2 4 5 28862 22
65790 196568 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 901 Phelps St 3 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6014815.41866 2097322.93796 37.7396820169172 -122.391308197122 (37.7396820169172, -122.391308197122) 10 3 8 58 1
72554 213753 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 500 Junipero Serra Blvd 36 : Tree Private 2     3 Width 0ft   5991334.64723 2093568.96607 37.7280434388513 -122.472220318534 (37.7280434388513, -122.472220318534) 9 8 4 64 40
73411 213748 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 262 Arch St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   5992736.49418 2088941.69865 37.7154191201708 -122.467037856528 (37.7154191201708, -122.467037856528) 9 8 6 64 24
78078 196565 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1 24th St 22 : Yard Tree Private 2     9     6017179.65065 2102592.91539 37.7542832244069 -122.383500390136 (37.7542832244069, -122.383500390136) 10 3 8 28856 29
81232 213746 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1500 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8     5991556.54065 2105092.12844 37.7596959227377 -122.472292886606 (37.7596959227377, -122.472292886606) 1 8 4 56 12
84621 246703 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1 Bonview St 9 Sidewalk: Curb side : Yard Tree Private 2     6     6007703.57405 2099117.43264 37.7442120378532 -122.416025032948 (37.7442120378532, -122.416025032948) 2 7 7 28859 2
90194 196566 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1 24th St 23 : Yard Tree Private 2     13     6017174.31899 2102601.55087 37.7543066409576 -122.383519429672 (37.7543066409576, -122.383519429672) 10 3 8 28856 29
91694 179182 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 88 Gillette Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013108.05998 2086970.43833 37.7111612493575 -122.39648608068 (37.7111612493575, -122.39648608068) 10 3 8 309 1
100746 196564 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 601 Illinois St 3 Sidewalk: Property side : Yard Tree Private 2     4     6016015.19806 2106200.05754 37.764123241124 -122.387779064061 (37.764123241124, -122.387779064061) 14 3 8 310 29
119132 179183 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1127 Bowdoin St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6009633.06743 2090939.37068 37.7218651215463 -122.408776389343 (37.7218651215463, -122.408776389343) 10 3 7 309 28
125407 179181 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 287 Hester Ave 6 Side Yard : Yard Tree Private 2     11     6012224.031 2087775.33367 37.7133220954184 -122.399597997574 (37.7133220954184, -122.399597997574) 10 3 8 309 1
139087 196567 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1 Jack Balestreri Way 7 Front Yard : Yard Tree Private 2     6     6012442.35809 2104735.38747 37.7599030168327 -122.400033693004 (37.7599030168327, -122.400033693004) 10 3 8 28856 29
142377 239039 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 701 Church St 35 Front Yard : Yard Tree Private 2     5 Width 3ft   6004316.03281 2104742.09155 37.75946499483 -122.428139180587 (37.75946499483, -122.428139180587) 2 4 5 28862 3
143158 179184 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 29 Tucker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010982.20182 2088482.44495 37.7151943796056 -122.40393994239 (37.7151943796056, -122.40393994239) 9 7 8 309 39
153232 213747 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 157 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995317.06195 2090909.93378 37.7209720425975 -122.458260700892 (37.7209720425975, -122.458260700892) 9 8 6 28861 24
153886 196563 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 1 25th St 22 : Yard Tree Private 2     5     6014971.47986 2102285.2089 37.7533160359259 -122.391115357305 (37.7533160359259, -122.391115357305) 10 3 8 28856 29
163137 239035 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 459 Valley St 1 Sidewalk: Curb side : Yard Tree Private 2     4     6002938.47397 2099171.49854 37.7440914261797 -122.432505563593 (37.7440914261797, -122.432505563593) 2 7 5 63 22
169760 136059 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 2298 Beach St 4 Sidewalk: Property side : Yard Tree Private 2     14 Width 6ft   5999328.6793 2120853.19077 37.8034184623604 -122.44654696828 (37.8034184623604, -122.44654696828) 13 9 1 57 17
170418 213755 Undocumented 4 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 90 Melrose Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   5999563.10942 2095536.13882 37.7339176053979 -122.443915642793 (37.7339176053979, -122.443915642793) 9 7 4 63 40
178772 239040 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 671 Church St 34 Front Yard : Yard Tree Private 2     6 Width 3ft   6004302.69639 2105038.35145 37.7602776995716 -122.428206418399 (37.7602776995716, -122.428206418399) 2 4 5 28862 3
189838 246885 DPW Maintained 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 3090x Market St 18 Median : Yard Tree DPW 1     8     5999879.22099 2105284.18163 37.7607014106692 -122.443522754189 (37.7607014106692, -122.443522754189) 15 5 5 28862 3

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