Street_Tree_List

Data source: data.sfgov.org

130 rows where qSpecies = 98 sorted by SiteOrder

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
140313 140313 99583 Undocumented 2 Shrub :: Shrub 98 650X Brunswick St 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
181183 181183 184754 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984657.4145 2106082.8434 37.762014449980704 -122.496226277389 (37.7620144499807, -122.496226277389)
164218 164218 185692 Undocumented 2 Shrub :: Shrub 98 2101 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984851.9348 2100530.8696 37.746781656202295 -122.495144090409 (37.7467816562023, -122.495144090409)
31848 31848 184755 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984688.1718 2106071.0721 37.7619839309054 -122.496119032944 (37.7619839309054, -122.496119032944)
97737 97737 30166 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 25 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
47657 47657 184756 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582)
51487 51487 186362 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5984819.5753 2102574.8802 37.7523920547151 -122.49540670794501 (37.7523920547151, -122.495406707945)
70454 70454 186363 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984829.0026 2102575.9576 37.752395564949104 -122.49537418673401 (37.7523955649491, -122.495374186734)
177379 177379 181571 Undocumented 2 Shrub :: Shrub 98 1200 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.49557246911101 (37.7638197374851, -122.495572469111)
172267 172267 186364 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402)
55306 55306 187251 Undocumented 2 Shrub :: Shrub 98 2401 Sunset Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984973.9834 2098481.6163 37.7411621065182 -122.494571017919 (37.7411621065182, -122.494571017919)
41030 41030 185311 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984965.5883 2097247.7465 37.737773740404 -122.49450910826799 (37.737773740404, -122.494509108268)
73198 73198 187253 Undocumented 2 Shrub :: Shrub 98 2401 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984962.1374 2098459.5582 37.741100847588896 -122.494610350765 (37.7411008475889, -122.494610350765)
59344 59344 185312 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984965.1696 2097238.5346 37.737748422490604 -122.494509877006 (37.7377484224906, -122.494509877006)
148012 148012 185313 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.49444731702299 (37.7377379790483, -122.494447317023)
51786 51786 185555 Undocumented 2 Shrub :: Shrub 98 2201 Sunset Blvd 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984902.7901 2099826.3861 37.7448503133319 -122.49491630522101 (37.7448503133319, -122.494916305221)
52950 52950 185897 Undocumented 2 Shrub :: Shrub 98 2000 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985016.2502 2101239.5934 37.7487372369942 -122.494628152274 (37.7487372369942, -122.494628152274)
184478 184478 187025 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984975.6777 2097882.1396 37.7395162040617 -122.494520977899 (37.7395162040617, -122.494520977899)
131967 131967 181355 Undocumented 2 Shrub :: Shrub 98 2300 Sunset Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985079.1419 2099429.3232 37.7437704079628 -122.49427726096201 (37.7437704079628, -122.494277260962)
167803 167803 187122 Undocumented 2 Shrub :: Shrub 98 2600 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985165.8082 2097341.5801 37.7380430985113 -122.49382377418101 (37.7380430985113, -122.493823774181)
179730 179730 184869 Undocumented 2 Shrub :: Shrub 98 1201 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984640.7069 2106821.7773 37.764042376179205 -122.496338586447 (37.7640423761792, -122.496338586447)
40776 40776 181577 Undocumented 2 Shrub :: Shrub 98 1200 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984846.2035 2106866.5794 37.76417742600729 -122.49563114953699 (37.7641774260073, -122.495631149537)
150729 150729 186250 Undocumented 2 Shrub :: Shrub 98 1701 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484)
57230 57230 181567 Undocumented 2 Shrub :: Shrub 98 1300 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.49555374589599 (37.7625264639896, -122.495553745896)
185026 185026 187377 Undocumented 2 Shrub :: Shrub 98 2200 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985052.2703 2100029.8298 37.7454176637381 -122.49441443213001 (37.7454176637381, -122.49441443213)
36265 36265 181582 Undocumented 2 Shrub :: Shrub 98 1200 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984863.0361 2106906.9776 37.7642893338004 -122.49557591115601 (37.7642893338004, -122.495575911156)
64376 64376 187053 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984954.1557 2097623.876 37.7388058219757 -122.494576356208 (37.7388058219757, -122.494576356208)
34598 34598 187054 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984950.4566 2097599.3275 37.738738201883294 -122.494587336532 (37.7387382018833, -122.494587336532)
42436 42436 187055 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984955.8371 2097567.7171 37.738651723125294 -122.49456640389 (37.7386517231253, -122.49456640389)
31687 31687 187056 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984980.0493 2097557.2924 37.7386245167659 -122.49448192258001 (37.7386245167659, -122.49448192258)

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