Street_Tree_List

Data source: data.sfgov.org

21 rows where DBH = 3, PlotSize = "Width 5ft" and qSpecies = 48

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2381 201818 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 2 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021088.08179 2093322.4173400002 37.7290434795636 -122.369343396492 (37.7290434795636, -122.369343396492)
2390 201832 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020752.62591 2092874.74971 37.727795861786205 -122.370472171548 (37.7277958617862, -122.370472171548)
2400 201838 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020663.4716 2092744.71005 37.7274339035298 -122.37077139578501 (37.7274339035298, -122.370771395785)
2406 201829 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 284 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020846.41585 2093000.7945400001 37.7281471046068 -122.37015664263399 (37.7281471046068, -122.370156642634)
2409 201824 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 8 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021004.603680001 2093212.5880900002 37.728737329640495 -122.369624404053 (37.7287373296405, -122.369624404053)
2410 201817 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 1 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021101.98762 2093338.62944 37.7290887577236 -122.36929644199101 (37.7290887577236, -122.369296441991)
2411 201831 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020768.36275 2092897.8842900002 37.7278602487283 -122.37041936696698 (37.7278602487283, -122.370419366967)
2419 201835 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020706.7385 2092807.85492 37.72760966254629 -122.370626184075 (37.7276096625463, -122.370626184075)
2423 201830 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 292 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020827.60649 2092975.44043 37.7280764547545 -122.370219916224 (37.7280764547545, -122.370219916224)
2435 201826 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 250 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020898.42083 2093071.04954 37.7283428654122 -122.369981710984 (37.7283428654122, -122.369981710984)
2438 201823 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 7 : 4 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021023.85438 2093233.10906 37.728794732485206 -122.369559269737 (37.7287947324852, -122.369559269737)
2444 201828 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 268 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020862.97624 2093021.3694799999 37.728204508308 -122.3701008136 (37.728204508308, -122.3701008136)
2446 201827 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 258 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020879.65439 2093047.83852 37.7282781025329 -122.370044984594 (37.7282781025329, -122.370044984594)
2452 201837 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020676.58787 2092764.09442 37.7274878493838 -122.370727391967 (37.7274878493838, -122.370727391967)
2453 201836 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020688.4191 2092782.87071 37.7275400550072 -122.370687788509 (37.7275400550072, -122.370687788509)
2454 201833 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020733.63229 2092847.8779900002 37.727721034575296 -122.370535976659 (37.7277210345753, -122.370535976659)
2460 201825 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 232 Friedell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020928.29141 2093111.1924700001 37.7284547293849 -122.36988121894899 (37.7284547293849, -122.369881218949)
2461 201834 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 350 Friedell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020718.56969 2092826.63123 37.7276618681873 -122.37058658062 (37.7276618681873, -122.37058658062)
35773 121884 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 18th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5990230.5783400005 2114834.8193200002 37.78636985483121 -122.477590808601 (37.7863698548312, -122.477590808601)
65576 176919 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 140 Seville St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6001505.61042 2087336.29034 37.71151328628479 -122.436613103724 (37.7115132862848, -122.436613103724)
136694 227083 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 770 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6008514.3452699995 2104071.33726 37.75785989922729 -122.41357185686 (37.7578598992273, -122.41357185686)

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 530.228ms · Data source: data.sfgov.org