trees
26 rows where SiteOrder = 1 and qSpecies_id = 87
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||
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 | |||
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 | ||
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 | |||||
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 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );