Street_Tree_List

Data source: data.sfgov.org

39 rows where qSiteInfo = 2 and qSpecies = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 39 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
789 789 175382 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80x Junipero Serra Blvd 19 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     2 Width 3ft   5991305.518069999 2089124.29272 37.7158377779634 -122.471997198511 (37.7158377779634, -122.471997198511)
26083 26083 123491 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30     5995674.45752 2111730.9534 37.77816187055421 -122.458531727532 (37.7781618705542, -122.458531727532)
28271 28271 215581 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991373.01779 2092318.20321 37.7246113758903 -122.471996546509 (37.7246113758903, -122.471996546509)
34747 34747 123483 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34     5995662.44998 2111958.25695 37.7787852957742 -122.458589724568 (37.7787852957742, -122.458589724568)
34942 34942 215575 Undocumented 2 Ulmus pumila :: Siberian Elm 53 95 Kirkham St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 3ft   5994715.1652 2105292.6604299997 37.76042882975 -122.461383388048 (37.76042882975, -122.461383388048)
36822 36822 215590 Undocumented 2 Ulmus pumila :: Siberian Elm 53 501 Junipero Serra Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 3ft   5991474.9385 2093941.2931 37.729073873942795 -122.47176245478701 (37.7290738739428, -122.471762454787)
37126 37126 124641 Undocumented 2 Ulmus pumila :: Siberian Elm 53 60 Arguello Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5995529.17868 2115583.09769 37.7887304767053 -122.459313330112 (37.7887304767053, -122.459313330112)
38271 38271 215583 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991379.44831 2092444.8187099998 37.7249594027384 -122.471983541404 (37.7249594027384, -122.471983541404)
42957 42957 137072 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3598 Clay St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5997679.8137 2115460.2442400004 37.788516566519604 -122.451863614513 (37.7885165665196, -122.451863614513)
44014 44014 215580 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5991366.74972 2092229.04743 37.7243662135233 -122.47201171896499 (37.7243662135233, -122.472011718965)
47125 47125 123486 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5995665.690219999 2111872.7664900003 37.7785507478592 -122.458572325088 (37.7785507478592, -122.458572325088)
48389 48389 182457 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 0ft   5986548.9803 2104732.6813 37.7584178970063 -122.48958488521099 (37.7584178970063, -122.489584885211)
49070 49070 137073 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3598 Clay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5997662.024569999 2115459.05462 37.7885122812527 -122.45192507598699 (37.7885122812527, -122.451925075987)
52498 52498 123489 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5995672.03179 2111788.60232 37.7783200198099 -122.458544293173 (37.7783200198099, -122.458544293173)
54701 54701 215577 Undocumented 2 Ulmus pumila :: Siberian Elm 53 95 Kirkham St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     48 Width 3ft   5994760.78175 2105295.21675 37.7604384740771 -122.461225807922 (37.7604384740771, -122.461225807922)
62104 62104 215587 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 29 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 3ft   5991411.41096 2092949.8935 37.7263480620905 -122.47190984556002 (37.7263480620905, -122.47190984556)
70741 70741 215579 Undocumented 2 Ulmus pumila :: Siberian Elm 53 851 Junipero Serra Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991331.01602 2091664.09591 37.7228129287478 -122.472094084291 (37.7228129287478, -122.472094084291)
76067 76067 215578 Undocumented 2 Ulmus pumila :: Siberian Elm 53 851 Junipero Serra Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991318.68956 2091495.76578 37.7223500225082 -122.47212443011101 (37.7223500225082, -122.472124430111)
77050 77050 181893 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2370 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   5987361.9916 2099162.5217 37.7431711693476 -122.486364226347 (37.7431711693476, -122.486364226347)
89632 89632 215576 Undocumented 2 Ulmus pumila :: Siberian Elm 53 95 Kirkham St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 3ft   5994736.06961 2105294.2713 37.7604344559039 -122.461311206651 (37.7604344559039, -122.461311206651)
134549 134549 215585 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5991388.97305 2092569.49487 37.725302283667396 -122.471959698575 (37.7253022836674, -122.471959698575)
135449 135449 123482 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35     5995660.39644 2111993.63742 37.7788823231397 -122.458599390427 (37.7788823231397, -122.458599390427)
138110 138110 215582 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991378.73804 2092411.11653 37.7248668238178 -122.47198354142999 (37.7248668238178, -122.47198354143)
145740 145740 123490 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     5995673.905040001 2111757.95548 37.7782359793629 -122.45853559389299 (37.7782359793629, -122.458535593893)
149241 149241 215584 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5991387.10122 2092540.18841 37.7252217070935 -122.471964034223 (37.7252217070935, -122.471964034223)
152798 152798 123480 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34     5995658.308019999 2112054.06112 37.7790481105637 -122.458610990374 (37.7790481105637, -122.458610990374)
158560 158560 123481 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34     5995659.669480001 2112025.6512 37.7789701827075 -122.458604223385 (37.7789701827075, -122.458604223385)
162620 162620 123479 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39     5995657.67406 2112077.16899 37.7791115222078 -122.458614856747 (37.7791115222078, -122.458614856747)
163752 163752 182456 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 0ft   5986548.9803 2104699.0505 37.758325556062104 -122.489582412162 (37.7583255560621, -122.489582412162)
165950 165950 215586 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5991393.3825900005 2092629.9672299998 37.725468580903 -122.471948860848 (37.725468580903, -122.471948860848)
170582 170582 242796 Undocumented 2 Ulmus pumila :: Siberian Elm 53 140 Belgrave Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 2ft   5997883.8658300005 2104916.82278 37.7595787374877 -122.450397275322 (37.7595787374877, -122.450397275322)
171488 171488 215651 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2105 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5993642.48221 2101265.6792599997 37.749309980671796 -122.46480082800501 (37.7493099806718, -122.464800828005)
171899 171899 123484 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33     5995663.25844 2111930.13675 37.778708131625294 -122.458584891633 (37.7787081316253, -122.458584891633)
173805 173805 123488 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5995672.61976 2111816.69318 37.7783971836602 -122.458544293173 (37.7783971836602, -122.458544293173)
177374 177374 123487 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     5995668.73883 2111844.87781 37.778474348143895 -122.45855975947599 (37.7784743481439, -122.458559759476)
177920 177920 182454 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 0ft   5986553.619 2104615.5531 37.7580965659316 -122.489560229786 (37.7580965659316, -122.489560229786)
178804 178804 215588 Undocumented 2 Ulmus pumila :: Siberian Elm 53 551 Junipero Serra Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991446.82162 2093469.8712 37.7277778402634 -122.47182531290899 (37.7277778402634, -122.471825312909)
181588 181588 137074 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3598 Clay St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 4ft   5997641.85824 2115456.61364 37.7885044238892 -122.45199467183998 (37.7885044238892, -122.45199467184)
183478 183478 215589 Undocumented 2 Ulmus pumila :: Siberian Elm 53 551 Junipero Serra Blvd 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991458.35334 2093660.05844 37.7283007142025 -122.47179930268999 (37.7283007142025, -122.47179930269)

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