Street_Tree_List

Data source: data.sfgov.org

29 rows where qCaretaker = 1, qSiteInfo = 9 and qSpecies = 58

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2939 203654 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 42 Mangels Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001070.39767 2095226.13763 37.7331522778487 -122.438682294452 (37.7331522778487, -122.438682294452)
3005 208852 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 42 Mangels Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001113.97001 2095223.0116299998 37.733146173254205 -122.43853142959101 (37.7331461732542, -122.438531429591)
24848 188408 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2033 22nd St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
26902 175812 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
36636 188403 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6012073.44818 2105095.84941 37.7608721901295 -122.401334912194 (37.7608721901295, -122.401334912194)
39239 175813 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6005348.05368 2093155.48995 37.727709159929105 -122.42374609402201 (37.7277091599291, -122.423746094022)
42508 204742 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 933 Teresita Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   5998605.5734 2095661.21413 37.734206366028296 -122.44723512141701 (37.7342063660283, -122.447235121417)
51309 222685 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 145 Coso Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
52153 125934 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1715 Taylor St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6008711.31794 2118818.3670900003 37.7983627993626 -122.41393383309799 (37.7983627993626, -122.413933833098)
53963 205923 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 266 Judson Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998304.035759999 2093569.7761099997 37.7284465374612 -122.448127087008 (37.7284465374612, -122.448127087008)
54390 247973 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 155 Faith St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6010331.53551 2099090.76742 37.7442862247418 -122.406936189376 (37.7442862247418, -122.406936189376)
59138 222697 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 690 28th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6001460.97341 2099432.54018 37.744724288990895 -122.43763311299101 (37.7447242889909, -122.437633112991)
61378 204745 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 370 Monterey Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5999685.08818 2094723.93815 37.731694449820296 -122.44343560538799 (37.7316944498203, -122.443435605388)
63986 188409 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2033 22nd St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6011983.90541 2103708.46876 37.757057753421 -122.40154709194799 (37.757057753421, -122.401547091948)
68446 188417 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 274 Topeka Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6013295.80448 2094667.84679 37.7323072334974 -122.396376359792 (37.7323072334974, -122.396376359792)
72995 217762 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 470 West Portal Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     5991703.40817 2096440.7638 37.735950009376204 -122.471154649778 (37.7359500093762, -122.471154649778)
75485 175814 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 11 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3     6005376.332880001 2093192.89602 37.727813465104 -122.423650990705 (37.727813465104, -122.423650990705)
116006 106924 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 196 States St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
136139 222692 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 501 York St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6009835.7153900005 2105907.76012 37.7629764094606 -122.409131567579 (37.7629764094606, -122.409131567579)
136522 204722 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 422 Bright St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5993793.315830001 2090006.70292 37.7184043108851 -122.46346228245501 (37.7184043108851, -122.463462282455)
136961 205922 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 370 Monterey Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5999640.50046 2094726.6696 37.7316994068856 -122.443589949734 (37.7316994068856, -122.443589949734)
144682 106923 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 196 States St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
146575 222710 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 201 Randall St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6004263.21249 2097476.0489 37.7395111430209 -122.427804130079 (37.7395111430209, -122.427804130079)
149164 175811 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 15 Athens St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6005336.45581 2093162.3032099998 37.727727212929004 -122.423786672331 (37.727727212929, -122.423786672331)
166040 175807 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 156 San Juan Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6001266.11551 2092303.88748 37.725139581023605 -122.437796421768 (37.7251395810236, -122.437796421768)
169588 204739 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 463 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   5998365.55897 2095230.78545 37.7330107938072 -122.44803394331899 (37.7330107938072, -122.448033943319)
175957 204740 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 317 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   5999296.31857 2095221.44608 37.7330383112512 -122.44481540373 (37.7330383112512, -122.44481540373)
176434 124049 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 651 11th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5992517.64773 2111006.08275 37.775989642541795 -122.469399404795 (37.7759896425418, -122.469399404795)
185050 204744 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 545 Melrose Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   5996927.5801099995 2095415.2897 37.733435093958896 -122.453018700168 (37.7334350939589, -122.453018700168)

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