trees
34 rows where qSpecies_id = 191
This data as json, CSV (advanced)
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
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) );