Street_Tree_List

Data source: data.sfgov.org

19 rows where SiteOrder = 4, qSiteInfo = 9 and qSpecies = 55

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24079 24079 207947 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2300 09th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5992701.4282599995 2100499.03593 37.74715067337829 -122.467999226394 (37.7471506733783, -122.467999226394)
24921 24921 185624 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2100 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985032.5384 2100289.574 37.74612969593421 -122.49450180509399 (37.7461296959342, -122.494501805094)
32112 32112 191454 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 110 Main St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6014422.1933 2115994.29604 37.790927639935205 -122.39397451700701 (37.7909276399352, -122.393974517007)
35118 35118 249626 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2450 Golden Gate Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 7ft   5997629.20154 2111320.8976 37.7771481106256 -122.45174000362199 (37.7771481106256, -122.451740003622)
46096 46096 122133 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 15th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     5991114.065719999 2115007.37065 37.7868948615896 -122.474546795399 (37.7868948615896, -122.474546795399)
48603 48603 177091 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1 Santa Barbara Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5993412.52644 2086599.2418 37.709026289400796 -122.46453122115801 (37.7090262894008, -122.464531221158)
50894 50894 177115 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 34 Vienna St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6005069.55264 2093328.8991099999 37.7281695777432 -122.424721208244 (37.7281695777432, -122.424721208244)
54144 54144 120481 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2201 Lake St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 1ft   5988593.25091 2114641.37666 37.7857435664695 -122.48324129171101 (37.7857435664695, -122.483241291711)
58525 58525 207855 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 494 Victoria St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   5993274.09777 2090428.4072099999 37.719532280163 -122.46528760316099 (37.719532280163, -122.465287603161)
60586 60586 207937 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 145 Ridgewood Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5996773.96274 2094591.1270299999 37.7311633363083 -122.45349031003201 (37.7311633363083, -122.453490310032)
62185 62185 227290 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 685 29th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6002218.42059 2098832.30166 37.7431192122842 -122.434971090944 (37.7431192122842, -122.434971090944)
76604 76604 207995 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 395 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   5999470.3608 2094946.2688099998 37.7322926698604 -122.44419392902799 (37.7322926698604, -122.444193929028)
131196 131196 207959 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 70 Woodside Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5995748.658340001 2100247.6965 37.7466360605992 -122.45744403462 (37.7466360605992, -122.45744403462)
149329 149329 207836 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 100 De Montfort Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5995005.14377 2091917.0493299998 37.7237194121086 -122.459411800719 (37.7237194121086, -122.459411800719)
149576 149576 177053 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 765 Delano Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5998955.229780001 2090176.99773 37.719167958508 -122.445632005212 (37.719167958508, -122.445632005212)
156713 156713 177062 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 550 Geneva Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   5999011.63296 2090530.40369 37.720141550179896 -122.44546243984199 (37.7201415501799, -122.445462439842)
159816 159816 208005 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 551 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   5998445.88865 2094954.90573 37.7322578849907 -122.447736370247 (37.7322578849907, -122.447736370247)
181849 181849 227282 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4412 23rd St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 5ft   6000544.37543 2102304.8503 37.7525588049644 -122.441008545612 (37.7525588049644, -122.441008545612)
183703 183703 227267 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 739 27th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   6001720.54184 2099972.41794 37.7462214209976 -122.436774216378 (37.7462214209976, -122.436774216378)

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