trees

121 rows where qSpecies_id = 82 sorted by PlotSize

✎ View and edit SQL

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)
15570 208891 DPW Maintained 1 Malus :: Crab Apple 82 843 Detroit St 11 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   5999418.11372 2095604.85507 37.7340980120977 -122.444421872075 (37.7340980120977, -122.444421872075) 9 7 4 59 40
30178 231494 DPW Maintained 1 Malus :: Crab Apple 82 339 Addison St 6 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   6002235.98479 2097691.64052 37.7399882198726 -122.434828804717 (37.7399882198726, -122.434828804717) 2 7 5 63 7
107357 208890 DPW Maintained 1 Malus :: Crab Apple 82 843 Detroit St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   5999418.03526 2095622.98585 37.734147790474 -122.444423445903 (37.734147790474, -122.444423445903) 9 7 4 59 40
119727 231493 DPW Maintained 1 Malus :: Crab Apple 82 339 Addison St 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6002237.63018 2097698.28157 37.7400065480711 -122.434823590441 (37.7400065480711, -122.434823590441) 2 7 5 63 7
122356 193445 DPW Maintained 1 Malus :: Crab Apple 82 545 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6012707.67421 2104954.65178 37.7605198573339 -122.399131478736 (37.7605198573339, -122.399131478736) 10 3 8 28856 29
141816 231495 DPW Maintained 1 Malus :: Crab Apple 82 339 Addison St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6002243.19948 2097700.16893 37.7400120465212 -122.434804469057 (37.7400120465212, -122.434804469057) 2 7 5 63 7
154390 208873 DPW Maintained 1 Malus :: Crab Apple 82 1915 11th Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   5992820.79743 2102456.25278 37.7525315806908 -122.46772878318 (37.7525315806908, -122.46772878318) 1 8 4 29491 12
161676 231488 DPW Maintained 1 Malus :: Crab Apple 82 215 Grand View Ave 5 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   6000742.39523 2103201.26061 37.7550314072854 -122.44038804397 (37.7550314072854, -122.44038804397) 2 4 5 28862 22
79973 208886 DPW Maintained 1 Malus :: Crab Apple 82 100 Joost Ave 9 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6001302.89972 2094970.3961 37.7324632946503 -122.437860163028 (37.7324632946503, -122.437860163028) 9 7 5 63 40
188003 246802 DPW Maintained 1 Malus :: Crab Apple 82 369 Mullen Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   6010622.51697 2099596.58355 37.7456913641809 -122.405965658085 (37.7456913641809, -122.405965658085) 2 7 7 28859 2
32185 208893 DPW Maintained 1 Malus :: Crab Apple 82 326 Detroit St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 7ft   5999451.44674 2094281.11232 37.7304652267742 -122.444211538625 (37.7304652267742, -122.444211538625) 9 7 4 63 40
20999 231487 DPW Maintained 1 Malus :: Crab Apple 82 2119 Castro St 1 Sidewalk: Curb side : Pot Tree Private 2     10 Width 8ft   6002708.75912 2099359.82748 37.7445955042953 -122.433313320275 (37.7445955042953, -122.433313320275) 2 7 5 63 22
35381 231477 DPW Maintained 1 Malus :: Crab Apple 82 600x San Jose Ave 1 Median : Yard Tree DPW 1     4 Width 8ft   6005974.01132 2099648.68915 37.7455733533412 -122.422043227715 (37.7455733533412, -122.422043227715) 2 7 5 28859 2
66097 231471 DPW Maintained 1 Malus :: Crab Apple 82 200 Kingston St 8 Front Yard : Yard Tree Private 2     6 Width 8ft   6006257.11637 2098029.51803 37.7411434377107 -122.42094935264 (37.7411434377107, -122.42094935264) 2 7 7 28859 2
73687 231482 DPW Maintained 1 Malus :: Crab Apple 82 60 Murray St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6004917.71249 2095272.09944 37.7334965967716 -122.425384353019 (37.7334965967716, -122.425384353019) 2 7 7 28861 2
108991 231481 DPW Maintained 1 Malus :: Crab Apple 82 60 Murray St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6004906.20838 2095274.16541 37.7335016194909 -122.425424273006 (37.7335016194909, -122.425424273006) 2 7 7 28861 2
140393 231479 DPW Maintained 1 Malus :: Crab Apple 82 600x San Jose Ave 3 Median : Yard Tree DPW 1     4 Width 8ft   6005963.86198 2099704.0736 37.7457248540265 -122.422082256503 (37.7457248540265, -122.422082256503) 2 7 5 28859 22
148199 231472 DPW Maintained 1 Malus :: Crab Apple 82 200 Kingston St 9 Front Yard : Yard Tree Private 2     4 Width 8ft   6006266.14334 2098022.56531 37.7411248559331 -122.420917647057 (37.7411248559331, -122.420917647057) 2 7 7 28859 2
190735 231478 DPW Maintained 1 Malus :: Crab Apple 82 600x San Jose Ave 2 Median : Yard Tree DPW 1     4 Width 8ft   6005969.94367 2099650.47553 37.745578028917 -122.422057419928 (37.745578028917, -122.422057419928) 2 7 5 28859 2
14757 208879 DPW Maintained 1 Malus :: Crab Apple 82 100x Idora Ave 19 Median : Yard Tree DPW 1     7 Width 9ft   5995727.40355 2099320.34097 37.7440885519582 -122.457450449475 (37.7440885519582, -122.457450449475) 1 8 4 59 40
80759 193451 DPW Maintained 1 Malus :: Crab Apple 82 760 De Haro St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 9ft   6012093.60455 2104911.13829 37.7603661389049 -122.401252219518 (37.7603661389049, -122.401252219518) 10 3 8 28856 29

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