trees

19 rows where SiteOrder = 3 and qSpecies_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
3511 254247 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100x Beale St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/13/2018 12:00:00 AM 3                        
6150 259078 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1000 Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
16799 261042 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
28889 197972 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 90 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6011477.0733 2113572.89989 37.7841149391088 -122.403994090559 (37.7841149391088, -122.403994090559) 12 2 9 28853 34
37623 241174 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 315 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft Permit Number 778328 6003586.53553 2106468.03188 37.7641627114691 -122.430785309798 (37.7641627114691, -122.430785309798) 8 4 5 28862 3
39209 197933 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 218 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6014535.65426 2115358.35954 37.7891878106184 -122.393537417717 (37.7891878106184, -122.393537417717) 6 2 9 28855 6
42209 112149 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 101X 05TH ST 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34
43435 197956 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 355 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6014936.72139 2115049.06267 37.7883608291328 -122.392128124328 (37.7883608291328, -122.392128124328) 6 2 9 28855 6
45536 50054 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 646 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51273 6004256.47851591 2105135.14617147 37.7605408596837 -122.42837316341 (37.7605408596837, -122.42837316341) 2 4 5 28862 3
100470 121527 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
106319 197974 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 248 06th St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010760.66114 2111705.859 37.7789484310553 -122.406341036019 (37.7789484310553, -122.406341036019) 14 2 9 28853 34
123910 197949 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 375 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015139.49005 2114827.68285 37.7877642269846 -122.391411089446 (37.7877642269846, -122.391411089446) 6 2 9 28855 6
125287 197927 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 274 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6014884.10651 2115509.17799 37.7896212784354 -122.392342359022 (37.7896212784354, -122.392342359022) 6 2 9 28855 6
130425 197965 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 542 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013312.52382 2111204.97894 37.7777155477834 -122.397477924066 (37.7777155477834, -122.397477924066) 6 2 9 28856 34
144647 197937 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 220 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6014670.19606 2115221.91526 37.7888206408102 -122.393062365246 (37.7888206408102, -122.393062365246) 6 2 9 28855 6
154232 197924 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 Width 5ft   6013969.61875 2115974.72965 37.7908487523134 -122.395539045996 (37.7908487523134, -122.395539045996) 12 2 9 28855 6
158604 197941 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 351 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6015395.33914 2115073.46848 37.7884532947311 -122.390543073727 (37.7884532947311, -122.390543073727) 6 2 9 28855 6
184350 197968 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 153 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6010849.47884 2113039.65001 37.7826156766079 -122.406127771681 (37.7826156766079, -122.406127771681) 12 2 9 28853 34
194150 121524 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6

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