Street_Tree_List

Data source: data.sfgov.org

22 rows where qSiteInfo = 2 and qSpecies = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 22 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23452 23452 207071 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5993749.481269999 2102344.6615 37.752278758765605 -122.464509159894 (37.7522787587656, -122.464509159894)
31453 31453 207072 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 245 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994440.698340001 2100406.16627 37.7469959638947 -122.46197828057899 (37.7469959638947, -122.461978280579)
33222 33222 207070 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5993749.21516 2102356.41341 37.752311011160295 -122.464510933358 (37.7523110111603, -122.464510933358)
34497 34497 191363 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 955 Key Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013550.52728 2089583.75311 37.7183615103672 -122.395139727222 (37.7183615103672, -122.395139727222)
42271 42271 207076 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994497.66006 2100431.13069 37.7470677891411 -122.461783123205 (37.7470677891411, -122.461783123205)
45787 45787 207074 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994502.2451599995 2100385.66213 37.7469432078786 -122.46176397213301 (37.7469432078786, -122.461763972133)
46195 46195 207077 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994500.88494 2100452.87217 37.74712767141 -122.461773548104 (37.74712767141, -122.461773548104)
47675 47675 176920 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 671 London St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6001061.12784 2089906.70665 37.718545806627205 -122.43833338090299 (37.7185458066272, -122.438333380903)
56287 56287 227611 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 66 Balmy St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6008811.16325 2101739.4503099998 37.751473726132005 -122.412380510571 (37.751473726132, -122.412380510571)
62217 62217 250619 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 114 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5987113.722030001 2115192.60557 37.7871708695801 -122.48840049988002 (37.7871708695801, -122.48840049988)
130451 130451 176925 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 17 Curtis St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   6000534.5551 2088493.30994 37.7146349724878 -122.440052229032 (37.7146349724878, -122.440052229032)
133413 133413 250533 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 69 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5987683.92995 2115503.12844 37.7880567296852 -122.48645053678601 (37.7880567296852, -122.486450536786)
136250 136250 250532 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 79 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5987685.24066 2115481.63254 37.787997784513294 -122.486444423174 (37.7879977845133, -122.486444423174)
154559 154559 250620 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 114 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5987116.07946 2115204.5954 37.7872039277514 -122.48839322528099 (37.7872039277514, -122.488393225281)
163085 163085 183580 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2614 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5988349.2799 2097484.0905 37.7386201346216 -122.482827506776 (37.7386201346216, -122.482827506776)
168398 168398 129401 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 5 Dicha Aly 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5998309.94171 2113772.92465 37.7839197016653 -122.449561847418 (37.7839197016653, -122.449561847418)
171953 171953 207069 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 6ft   5993748.4844 2102370.47272 37.752349572298606 -122.46451448116999 (37.7523495722986, -122.46451448117)
175597 175597 207073 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994505.45248 2100370.5542599997 37.746901910105 -122.46175178633601 (37.746901910105, -122.461751786336)
175752 175752 183581 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2614 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5988348.717 2097504.9177 37.738677287922 -122.48283097892299 (37.738677287922, -122.482830978923)
176799 176799 182968 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2501 19th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5990431.4773 2098333.0499 37.7410720891089 -122.475690312642 (37.7410720891089, -122.475690312642)
182340 182340 207075 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5994498.162330001 2100407.0553599996 37.7470017132656 -122.461779641027 (37.7470017132656, -122.461779641027)
183467 183467 207095 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1565 Plymouth Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5995634.15192 2094407.3594099998 37.730593351393296 -122.457417521726 (37.7305933513933, -122.457417521726)

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