Street_Tree_List

Data source: data.sfgov.org

25 rows where qSiteInfo = 9 and qSpecies = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 25 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3544 3544 253465 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3561 3561 253462 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3567 3567 253463 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3585 3585 253464 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
24102 24102 186759 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984850.1974 2106711.7495 37.7637525404811 -122.495605915184 (37.7637525404811, -122.495605915184)
34046 34046 186310 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1800 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984966.7705 2102775.9332 37.7529527085207 -122.49491251324899 (37.7529527085207, -122.494912513249)
36675 36675 186762 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984853.5932 2106716.1156 37.7637647274179 -122.49559449238701 (37.7637647274179, -122.495594492387)
44625 44625 186760 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984860.8701 2106711.7495 37.7637531654529 -122.495569002148 (37.7637531654529, -122.495569002148)
45882 45882 186748 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984868.1469 2106676.3356 37.7636563549354 -122.495541222153 (37.7636563549354, -122.495541222153)
50007 50007 186756 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984857.4742 2106702.5322 37.7637276584797 -122.495580067458 (37.7637276584797, -122.495580067458)
51787 51787 217831 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22     5991381.66969 2095739.8250799999 37.734006793868 -122.472215938837 (37.734006793868, -122.472215938837)
66007 66007 186752 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984851.1676 2106688.9488 37.7636899929755 -122.49560087776399 (37.7636899929755, -122.495600877764)
70133 70133 186750 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984851.1676 2106678.2761 37.763660688738206 -122.49560009051399 (37.7636606887382, -122.495600090514)
73459 73459 186747 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984869.1172 2106666.6331 37.76362977141179 -122.495537150576 (37.7636297714118, -122.495537150576)
133677 133677 185961 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2001 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984861.3455 2101337.8929 37.74899807274279 -122.495171051634 (37.7489980727428, -122.495171051634)
137835 137835 129468 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1151 Lombard St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     6006718.96895 2120094.36111 37.8017542606157 -122.420918621021 (37.8017542606157, -122.420918621021)
151432 151432 186745 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984852.3804 2106661.5394 37.763614805479 -122.495594661337 (37.763614805479, -122.495594661337)
152713 152713 129469 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1085 Vallejo St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808)
156319 156319 186749 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984860.385 2106678.2761 37.7636612284897 -122.495568210877 (37.7636612284897, -122.495568210877)
160044 160044 186041 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1900 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 0ft   5984992.0482 2102149.6578 37.7512346080754 -122.494778929254 (37.7512346080754, -122.494778929254)
164300 164300 186000 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1883 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5981612.0444 2102288.7145 37.7514179925848 -122.506477461595 (37.7514179925848, -122.506477461595)
171541 171541 186059 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1901 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984803.9529 2102180.8195 37.751309157700604 -122.495431671777 (37.7513091577006, -122.495431671777)
178737 178737 186058 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1901 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984794.5256 2102183.7824 37.7513167410032 -122.495464490464 (37.7513167410032, -122.495464490464)
184000 184000 186754 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984863.7808 2106693.8 37.763704051609004 -122.49555761110202 (37.763704051609, -122.495557611102)
188419 188419 129470 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 45 MacOndray Ln 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6008463.14234 2119145.61201 37.799247391416394 -122.414815771241 (37.7992473914164, -122.414815771241)

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