Street_Tree_List

Data source: data.sfgov.org

21 rows where qLegalStatus = 5 and qSpecies = 78

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1079 1079 3621 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 57 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:22:00 PM 3 3X3   6017849.66978 2098333.64293 37.7426251400454 -122.380887189608 (37.7426251400454, -122.380887189608)
4945 4945 3600 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 36 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:14:00 PM 3 3X3   6018222.967130001 2098056.59418 37.7418850159701 -122.379577179554 (37.7418850159701, -122.379577179554)
4950 4950 3646 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 82 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:16:00 AM 3 3X3   6017441.11571 2098662.50366 37.7435055673357 -122.38232273959999 (37.7435055673357, -122.3823227396)
4973 4973 3631 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 67 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:27:00 PM 3 3X3   6017682.09522 2098458.88711 37.7429597849556 -122.381475327351 (37.7429597849556, -122.381475327351)
4980 4980 83034 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 18 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/18/2017 02:59:00 PM 3     6018525.50747 2097831.43609 37.7412834585567 -122.37851545254298 (37.7412834585567, -122.378515452543)
4994 4994 3624 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 60 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:25:00 PM 3 3X3   6017797.96297 2098371.7943700003 37.742727042232396 -122.38106863050601 (37.7427270422324, -122.381068630506)
5023 5023 3601 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 10:11:00 AM 3 3X3   6018206.00756 2098069.0742900004 37.7419183484432 -122.379636687689 (37.7419183484432, -122.379636687689)
5038 5038 83035 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 17 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   04/10/2017 09:50:00 AM 3     6018541.89406 2097818.9676900003 37.741250126083706 -122.37845792741501 (37.7412501260837, -122.378457927415)
5049 5049 3594 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 30 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3x3   6018322.1359 2097981.33701 37.741683843926396 -122.379229056502 (37.7416838439264, -122.379229056502)
5054 5054 83037 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 15 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 5     6018575.81097 2097793.86484 37.74118306815279 -122.378338911137 (37.7411830681528, -122.378338911137)
5063 5063 3598 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 34 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   05/01/2017 03:10:00 PM 3 3X3   6018255.028469999 2098031.9569200003 37.7418191352571 -122.37946460960501 (37.7418191352571, -122.379464609605)
5070 5070 3618 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 54 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017899.85524 2098296.735 37.7425265680461 -122.380711096061 (37.7425265680461, -122.380711096061)
22311 22311 3643 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 79 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017487.6627 2098619.8542 37.7433910314633 -122.382158823763 (37.7433910314633, -122.382158823763)
22315 22315 3636 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 72 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017599.14752 2098522.45762 37.7431297568333 -122.38176656108601 (37.7431297568333, -122.381766561086)
22328 22328 3612 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 48 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6018020.628269999 2098207.76094 37.7422889275932 -122.380287312129 (37.7422889275932, -122.380287312129)
22335 22335 3628 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 64 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017730.69941 2098422.13413 37.7428615520079 -122.38130471064899 (37.7428615520079, -122.381304710649)
22337 22337 3609 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 45 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     9 3X3   6018070.77279 2098169.47823 37.7421865775631 -122.380111266222 (37.7421865775631, -122.380111266222)
22338 22338 3608 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 44 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6018087.01832 2098157.15518 37.7421536371939 -122.380054237523 (37.7421536371939, -122.380054237523)
22339 22339 3642 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 78 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017503.4842 2098606.02713 37.7433539389383 -122.382103154832 (37.7433539389383, -122.382103154832)
22340 22340 3632 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 68 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6017663.5913 2098472.7680200003 37.7429968775117 -122.38154027458799 (37.7429968775117, -122.381540274588)
22352 22352 3605 Private 5 Quercus ilex :: Holly Oak 78 100X Cargo Way 41 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6 3X3   6018137.75637 2098119.86028 37.7420540318827 -122.37987620861601 (37.7420540318827, -122.379876208616)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 52.071ms · Data source: data.sfgov.org