Street_Tree_List

Data source: data.sfgov.org

15 rows where qSiteInfo = 9 and qSpecies = 49

✎ View and edit SQL

This data as json, CSV (advanced)

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

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 15 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
32354 32354 224078 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 37 Mars St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   5999600.0223900005 2105581.97574 37.761503152657106 -122.444509776331 (37.7615031526571, -122.444509776331)
34670 34670 185158 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 2500 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5985178.5125 2097636.1993 37.7388527871834 -122.49380155463699 (37.7388527871834, -122.493801554637)
36646 36646 191087 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1050 18th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6014377.05875 2105781.79588 37.762883905197 -122.393415683687 (37.762883905197, -122.393415683687)
40591 40591 191084 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1050 18th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6014440.039609999 2105781.9689 37.7628878793072 -122.393197865211 (37.7628878793072, -122.393197865211)
51462 51462 191085 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1050 18th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6014420.63086 2105780.4317900003 37.762882580487 -122.393264886285 (37.762882580487, -122.393264886285)
59512 59512 104074 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 841 32nd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/06/2013 12:00:00 AM 2   Permit Number 770392 5986000.25731 2110187.13166 37.7733622428275 -122.491884144737 (37.7733622428275, -122.491884144737)
73147 73147 191083 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1050 18th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6014452.20409 2105784.61715 37.7628958266015 -122.39315597748998 (37.7628958266015, -122.39315597749)
75029 75029 181341 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 2500 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985179.8406 2097655.4564 37.738905739718795 -122.49379838145501 (37.7389057397188, -122.493798381455)
82440 82440 103917 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300X Fitzgerald Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728)
87135 87135 103919 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300X Fitzgerald Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728)
121549 121549 103923 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300X Fitzgerald Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728)
134369 134369 207591 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 207 Flood Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5999361.39835 2094045.00117 37.7298117829776 -122.444505884965 (37.7298117829776, -122.444505884965)
138966 138966 103921 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300X Fitzgerald Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728)
141000 141000 103915 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1300X Fitzgerald Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728)
153372 153372 191086 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1050 18th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   6014399.78897 2105779.8886 37.762879931094 -122.393336933676 (37.762879931094, -122.393336933676)

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