59 rows where qSpecies_id = 87

View and edit SQL

Suggested facets: qLegalStatus_id, qSiteInfo, qCaretaker_id, PlantDate, 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)
300 234411 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 10x Benton Ave 4 Median : Yard Tree DPW 1     32     6004755.33467 2095032.93123 37.7328307189427 -122.425928720736 (37.7328307189427, -122.425928720736) 2 7 7 28861 2
966 251257 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1748x Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986101 2094852 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046) 1 8 4 64 35
7458 178095 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1015 Excelsior Ave 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 2ft   6004841.82949 2091227.47838 37.7223866743918 -122.425358975944 (37.7223866743918, -122.425358975944) 9 7 6 28861 5
13089 234406 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 147 Valencia St 1 : Tree Private 2     20 Width 8ft   6006058.10348 2108951.831 37.7711223543454 -122.422413351811 (37.7711223543454, -122.422413351811) 8 2 9 28853 19
16429 262110 Significant Tree 6 Phoenix dactylifera :: Date Palm 87 25 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002200 2092574 37.7259343081174 -122.434587389509 (37.7259343081174, -122.434587389509) 9 7 6 28861 25
20844 113318 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 174 VALENCIA ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005996 2108657 37.7703093154737 -122.422607215927 (37.7703093154737, -122.422607215927) 8 2 5 28853 19
22798 201709 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 2 Coronado St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 8ft   6014934.03017 2089213.58115 37.717421931959 -122.390331648502 (37.717421931959, -122.390331648502) 10 3 8 58 1
24324 113320 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 175X VALENCIA ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6006045 2108809 37.7707294354185 -122.422448526781 (37.7707294354185, -122.422448526781) 8 2 9 28853 19
25053 194399 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1121 Jamestown Ave 11 Sidewalk: Curb side : Yard Tree Private 2     7     6013370.43296 2090062.5178 37.7196660858089 -122.395795770954 (37.7196660858089, -122.395795770954) 10 3 8 58 1
25648 234410 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 2230 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009609.68289 2104362.91127 37.7587219398878 -122.409804286564 (37.7587219398878, -122.409804286564) 2 4 7 28859 19
27847 194401 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1121 Jamestown Ave 15 Sidewalk: Curb side : Yard Tree Private 2     15     6013389.43326 2090047.39318 37.719625613601 -122.395729034071 (37.719625613601, -122.395729034071) 10 3 8 58 1
30984 178091 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 327 Maynard St 1 Sidewalk: Property side : Yard Tree Private 2     19 Width 8ft   6005482.97407 2093860.26389 37.7296519293885 -122.423329751081 (37.7296519293885, -122.423329751081) 9 7 6 28861 5
33998 178089 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 627 Paris St 1 Sidewalk: Curb side : Yard Tree Private 2     37     6001428.27595 2089993.7852 37.7188057808522 -122.437070533975 (37.7188057808522, -122.437070533975) 9 7 6 28861 5
34569 234412 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 270 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 4ft   6006505.66108 2098159.00052 37.7415129745481 -122.420099159673 (37.7415129745481, -122.420099159673) 2 7 7 28859 2
38672 178098 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 638 Burrows St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009383.33887 2092966.76941 37.7274179414659 -122.409782676733 (37.7274179414659, -122.409782676733) 10 3 7 309 28
41262 178096 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1015 Excelsior Ave 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 2ft   6004838.97157 2091229.63894 37.7223924453503 -122.425369008793 (37.7223924453503, -122.425369008793) 9 7 6 28861 5
44434 210933 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 154 Margaret Ave 1 Sidewalk: Curb side : Pot Tree Private 2     27 Width 10ft   5996718.73035 2089319.81928 37.7166864052207 -122.453300837263 (37.7166864052207, -122.453300837263) 9 8 6 28861 24
47244 22894 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 178 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/02/1994 12:00:00 AM 6 3X3   6006031.57399 2108654.01225 37.77030311873 -122.422483953068 (37.77030311873, -122.422483953068) 8 2 5 28853 19
47473 201710 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 2 Coronado St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 8ft   6014843.66984 2089083.1115 37.7170586750936 -122.390634872922 (37.7170586750936, -122.390634872922) 10 3 8 58 1
53949 210931 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 2 Edna St 2 Sidewalk: Property side : Yard Tree Private 2     32     5998770.31007 2092974.74869 37.7268393752316 -122.446472369507 (37.7268393752316, -122.446472369507) 9 7 4 28861 40
57631 251258 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1748x Eucalyptus Dr 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5986101 2094852 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046) 1 8 4 64 35
58534 107481 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1300x Montgomery St 1 Median : Cutout Tree DPW 1           6011490.99877 2119741.79528 37.8010540290465 -122.404380271142 (37.8010540290465, -122.404380271142) 3 1 10 308 23
60908 178090 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 45 Paulding St 2 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6000057.91018 2093284.34129 37.7277629052183 -122.442043393704 (37.7277629052183, -122.442043393704) 9 7 6 28861 25
64183 178092 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1021 Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004868.00529 2091200.35953 37.7223136907999 -122.425266563405 (37.7223136907999, -122.425266563405) 9 7 6 28861 5
66704 107130 Property Tree 8 Phoenix dactylifera :: Date Palm 87 751 DOLORES ST 1 Front Yard : Cutout Tree Private 2           6005081.8 2103948.4 37.7573290011944 -122.425434294507 (37.7573290011944, -122.425434294507) 2 4 5 28859 19
69176 110478 Permitted Site 7 Phoenix dactylifera :: Date Palm 87 151 VALENCIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     22 9x8   6006061 2108804 37.7707166091945 -122.422392827103 (37.7707166091945, -122.422392827103) 8 2 9 28853 19
69818 194397 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1797 Bancroft Ave 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 1ft   6013420.92243 2092796.80792 37.7271767046165 -122.395812737565 (37.7271767046165, -122.395812737565) 10 3 8 58 1
71026 178094 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1015 Excelsior Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   6004860.24486 2091216.32738 37.7223570965959 -122.425294525118 (37.7223570965959, -122.425294525118) 9 7 6 28861 5
72920 249892 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 230 Greenwich St 28 Back Yard : Yard Tree Private 2     36 Width 0ft   6011427.28959 2120425.37078 37.8029274001332 -122.404648882458 (37.8029274001332, -122.404648882458) 3 1 10 28860 6
77804 185246 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 2563 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 0ft   5986117.5685 2097805.0277 37.7393712405593 -122.490567199309 (37.7393712405593, -122.490567199309) 1 8 3 29491 35
77930 25124 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1550 Dolores St 5 Median : Cutout Tree DPW 1     40 20   6005279.44295 2099098.54576 37.7440235867185 -122.424405817773 (37.7440235867185, -122.424405817773) 2 7 5 63 22
80394 194400 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1121 Jamestown Ave 12 Sidewalk: Curb side : Yard Tree Private 2     8     6013373.9192 2090059.88362 37.7196590468175 -122.395783535707 (37.7196590468175, -122.395783535707) 10 3 8 58 1
82439 234416 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 567 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003675.33514 2104944.37224 37.7599841383641 -122.430369460604 (37.7599841383641, -122.430369460604) 2 4 5 28862 3
83678 201708 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 5 Coronado St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 8ft   6014858.65018 2089061.02704 37.7169988665682 -122.390581550311 (37.7169988665682, -122.390581550311) 10 3 8 58 1
87111 234405 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 177 Valencia St 3 : Tree Private 2     22 Width 8ft   6006077.65974 2108680.63405 37.7703788155623 -122.422326434118 (37.7703788155623, -122.422326434118) 8 2 7 28853 19
90198 132135 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 844 Bay St 2 Sidewalk: Curb side : Pot Tree Private 2     16 Width 3ft   6006652.21719 2121188.57892 37.8047549412394 -122.421227358273 (37.8047549412394, -122.421227358273) 5 1 1 28858 32
90927 194398 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1121 Jamestown Ave 8 Sidewalk: Curb side : Yard Tree Private 2     8     6013340.66521 2090086.19155 37.7197294331555 -122.395900326164 (37.7197294331555, -122.395900326164) 10 3 8 58 1
92638 119952 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 300 28th Ave 3 Sidewalk: Property side : Yard Tree Private 2     18 Width 3ft   5987169.40244 2113876.4433 37.7835603139772 -122.488111110065 (37.7835603139772, -122.488111110065) 11 6 2 55 26
94556 25081 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1200X Dolores St 1 Median : Cutout Tree DPW 1   10/03/2012 12:00:00 AM 20 20   6005156.57495 2101303.54282 37.7500710634364 -122.424987519083 (37.7500710634364, -122.424987519083) 2 4 5 28862 22
94770 210932 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 116 Tara St 1 Sidewalk: Property side : Yard Tree Private 2     25 Width 6ft   5998072.9046 2090918.03439 37.7211522595526 -122.448735198692 (37.7211522595526, -122.448735198692) 9 8 6 28861 24
96400 234415 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 10x Benton Ave 5 Median : Yard Tree DPW 1     33     6004760.79404 2095007.84902 37.732762157335 -122.425908061504 (37.732762157335, -122.425908061504) 2 7 7 28861 2
101018 25142 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1798X Dolores St 8 Median : Cutout Tree DPW 1     36 20   6005303.4758509 2097774.014097 37.7403880804322 -122.42422853473 (37.7403880804322, -122.42422853473) 2 7 5 28859 7
105705 234413 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 280 Justin Dr 1 : Yard Tree Private 2     26 Width 3ft   6005966.47626 2094899.24737 37.7325320253145 -122.42173199844 (37.7325320253145, -122.42173199844) 2 7 7 28861 2
118684 249956 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 285 Filbert St 2 Side Yard : Yard Tree Private 2     23 Width 0ft   6011495.62979 2120073.57822 37.8019652829314 -122.404387612316 (37.8019652829314, -122.404387612316) 3 1 10 308 23
122901 30675 Permitted Site 7 Phoenix dactylifera :: Date Palm 87 1040 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/30/1995 12:00:00 AM   3x3 Permit Number 34599 6007565.37727332 2109755.15641274 37.7734130071983 -122.417256559972 (37.7734130071983, -122.417256559972) 8 2 9 28853 19
124793 69360 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1695 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1994 12:00:00 AM 4   Permit Number 33454 6002664.21541 2120911.8448 37.803769467759 -122.435008424509 (37.803769467759, -122.435008424509) 13 9 1 57 17
124839 132134 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 844 Bay St 1 Sidewalk: Curb side : Pot Tree Private 2     18 Width 3ft   6006665.94728 2121190.24519 37.8047602904276 -122.421179962201 (37.8047602904276, -122.421179962201) 5 1 1 28858 32
146580 18534 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 268 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6006513.58338 2098175.55734 37.741558882232 -122.420072941732 (37.741558882232, -122.420072941732) 2 7 7 28859 2
151503 210930 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 2 Edna St 1 Sidewalk: Property side : Yard Tree Private 2     44     5998770.14435 2092952.36281 37.7267778993647 -122.446471332592 (37.7267778993647, -122.446471332592) 9 7 4 28861 40
153050 194396 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 404 Texas St 2 : Tree Private 2     5 Width 3ft   6013753.00749 2105172.57058 37.7611764136899 -122.395531390984 (37.7611764136899, -122.395531390984) 10 3 8 28856 29
155453 234404 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 100 Valencia St 3 : Tree Private 2     20 Width 8ft   6006014.35416 2108978.59433 37.7711933719978 -122.422566584574 (37.7711933719978, -122.422566584574) 8 2 9 28853 19
160743 234409 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1750x Dolores St 2 Median : Yard Tree DPW 1     18     6005335.11777 2098093.36784 37.7412667401708 -122.424141835295 (37.7412667401708, -122.424141835295) 2 7 5 63 7
170324 178093 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1021 Excelsior Ave 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   6004866.88335 2091211.98696 37.7223455537972 -122.425271268681 (37.7223455537972, -122.425271268681) 9 7 6 28861 5
176164 234408 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1700x Dolores St 6 Median : Yard Tree DPW 1     18     6005328.71951 2098210.15562 37.7415870517023 -122.424172262039 (37.7415870517023, -122.424172262039) 2 7 5 63 7
184876 185064 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 20 Crestlake Dr 2 Sidewalk: Property side : Yard Tree Private 2     34 Width 0ft   5989046.5946 2096130.9763 37.7349453809922 -122.480317540903 (37.7349453809922, -122.480317540903) 1 8 3 64 35
185787 178097 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 201 Trumbull St 71 Sidewalk: Property side : Yard Tree Private 2     16     6004719.38437 2094363.75444 37.7309912771155 -122.426005390643 (37.7309912771155, -122.426005390643) 9 7 6 28861 5
186336 210929 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 1 Marne Ave 5 Sidewalk: Property side : Yard Tree Private 2     38 Width 4ft   5995223.39717 2097839.86385 37.7399945663944 -122.459086001528 (37.7399945663944, -122.459086001528) 9 7 4 59 40
188109 234414 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 280 2 : Yard Tree Private 2     23 Width 3ft   6005979.04288 2094923.96665 37.7326006076366 -122.421690307661 (37.7326006076366, -122.421690307661) 2 7 7 28861 2
192523 234407 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 100x Dolores St 8 Median : Yard Tree DPW 1     18     6004812.29017 2107562.9589 37.7672384899902 -122.426623750084 (37.7672384899902, -122.426623750084) 8 4 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)
);