Street_Tree_List

Data source: data.sfgov.org

18 rows where qSiteInfo = 4 and qSpecies = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
38028 38028 204732 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 Junipero Serra Blvd 92 : 4 Tree 1 Private 1     9 Width 0ft   5991226.61275 2092125.57221 37.7240739859998 -122.472488607886 (37.7240739859998, -122.472488607886)
43676 43676 204727 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 38 : 4 Tree 1 Private 1     4 Width 0ft   5991391.65527 2094396.58957 37.73031918497 -122.47208354153798 (37.73031918497, -122.472083541538)
54760 54760 188413 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 398 Mississippi St 4 : 4 Tree 1 Private 1     1 Width 3ft   6014027.478680001 2105319.8341099997 37.7615960301482 -122.394592417822 (37.7615960301482, -122.394592417822)
62795 62795 188412 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 398 Mississippi St 3 : 4 Tree 1 Private 1     1 Width 3ft   6014026.1658 2105339.44297 37.761649798808996 -122.394598331744 (37.761649798809, -122.394598331744)
68906 68906 204731 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 25 : 4 Tree 1 Private 1     5 Width 0ft   5991352.35851 2093912.8371599999 37.728988647895 -122.472184145999 (37.728988647895, -122.472184145999)
72067 72067 204730 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 20 : 4 Tree 1 Private 1     7 Width 0ft   5991365.099780001 2094040.0062400002 37.7293385597172 -122.472149364714 (37.7293385597172, -122.472149364714)
77059 77059 188411 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 398 Mississippi St 2 : 4 Tree 1 Private 1     1 Width 3ft   6014024.24871 2105357.36092 37.7616988910081 -122.394606216998 (37.7616988910081, -122.394606216998)
129739 129739 204728 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 13 : 4 Tree 1 Private 1     2 Width 0ft   5991366.51565 2094145.3724 37.729627950748295 -122.47215214722401 (37.7296279507483, -122.472152147224)
135308 135308 204726 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 30 : 4 Tree 1 Private 1     5 Width 0ft   5991392.43358 2094433.51883 37.7304206284982 -122.472083541544 (37.7304206284982, -122.472083541544)
153957 153957 218236 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 353 Wawona St 1 : 4 Tree 1 Private 1     1 Width 3ft   5991977.13565 2097137.64691 37.7378793033766 -122.47025900595101 (37.7378793033766, -122.470259005951)
154057 154057 204723 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 12 : 4 Tree 1 Private 1     5 Width 0ft   5991397.3981 2094531.5501400002 37.7306900851772 -122.47207352129801 (37.7306900851772, -122.472073521298)
159639 159639 188416 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1790 McKinnon Ave 1 : 4 Tree 1 Private 1     20 Width 8ft   6014390.68688 2096696.7168 37.7379389617097 -122.392732952571 (37.7379389617097, -122.392732952571)
170368 170368 204724 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 21 : 4 Tree 1 Private 1     8 Width 0ft   5991391.18592 2094484.3447599998 37.730560111554496 -122.47209155808999 (37.7305601115545, -122.47209155809)
170450 170450 204725 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 29 : 4 Tree 1 Private 1     5 Width 0ft   5991390.23736 2094439.33755 37.730436478151496 -122.47209155807501 (37.7304364781515, -122.472091558075)
174132 174132 188415 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2 Jennings St 2 : 4 Tree 1 Private 1     1 Width 3ft   6019090.329030001 2097590.47628 37.7406529492792 -122.37654576818998 (37.7406529492792, -122.37654576819)
176601 176601 188418 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1790 McKinnon Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   6014392.11707 2096695.01257 37.737934361678796 -122.39272788847401 (37.7379343616788, -122.392727888474)
178316 178316 202043 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 52 Exeter St 2 : 4 Tree 1 Private 1     1 Width 3ft   6012522.16713 2090984.69593 37.722150974681604 -122.398792625891 (37.7221509746816, -122.398792625891)
188538 188538 204729 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 16 : 4 Tree 1 Private 1     1 Width 0ft   5991368.5463 2094108.06034 37.729525618690204 -122.47214240847 (37.7295256186902, -122.47214240847)

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