Street_Tree_List

Data source: data.sfgov.org

40 rows where qSiteInfo = 9 and qSpecies = 110

View and edit SQL

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
30321 132368 Undocumented 2 Pittosporum eugenioides :: Tarata 110 3100 Lyon St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   5999060.82328 2119520.3698400003 37.7997435923452 -122.44737790226999 (37.7997435923452, -122.44737790227)
31583 132369 Undocumented 2 Pittosporum eugenioides :: Tarata 110 3100 Lyon St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   5999059.80174 2119527.5303700003 37.7997631948618 -122.44738195283199 (37.7997631948618, -122.447381952832)
32833 132402 Undocumented 2 Pittosporum eugenioides :: Tarata 110 93 MacOndray Ln 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6008127.0764 2119094.13477 37.7990871592098 -122.41597503153 (37.7990871592098, -122.41597503153)
33137 132366 Undocumented 2 Pittosporum eugenioides :: Tarata 110 3100 Lyon St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   5999060.873319999 2119508.71315 37.7997115890667 -122.44737688965 (37.7997115890667, -122.44737688965)
36060 132385 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   6005829.912880001 2119675.1182 37.8005529731893 -122.423965339721 (37.8005529731893, -122.423965339721)
37209 178397 Undocumented 2 Pittosporum eugenioides :: Tarata 110 127 Athens St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6004928.6124599995 2092474.3613599997 37.7258152443728 -122.42514766493 (37.7258152443728, -122.42514766493)
41431 132390 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   6005781.1261599995 2119669.33652 37.8005343437344 -122.42413375038099 (37.8005343437344, -122.424133750381)
46330 178393 Undocumented 2 Pittosporum eugenioides :: Tarata 110 73 Capistrano Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6001400.33163 2093764.0907400001 37.729156597198795 -122.437436967259 (37.7291565971988, -122.437436967259)
46631 132401 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2745 Larkin St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6006539.0247599995 2120646.9147799998 37.8032612878284 -122.421580578682 (37.8032612878284, -122.421580578682)
46960 132377 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6008207.47508 2117062.00893 37.793511965045205 -122.415552871766 (37.7935119650452, -122.415552871766)
54276 194583 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1698 Galvez Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6015441.64874 2098018.63828 37.7416270022859 -122.38919150780899 (37.7416270022859, -122.389191507809)
54754 178398 Undocumented 2 Pittosporum eugenioides :: Tarata 110 300 Gaven St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 4ft   6008862.12496 2094845.7594299999 37.732548023354504 -122.41171723086501 (37.7325480233545, -122.411717230865)
57415 194585 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1698 Galvez Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6015429.91647 2098027.47569 37.741650617592 -122.389232691343 (37.741650617592, -122.389232691343)
61763 132373 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6008208.92851 2117034.44521 37.793436363556204 -122.415545890356 (37.7934363635562, -122.415545890356)
62614 178399 Undocumented 2 Pittosporum eugenioides :: Tarata 110 339 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6004188.88481 2091298.12563 37.7225437445683 -122.42762108566002 (37.7225437445683, -122.42762108566)
64368 249601 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2200 Golden Gate Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5998898.09787 2111497.4092 37.777705355751294 -122.447363215433 (37.7777053557513, -122.447363215433)
64626 132374 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6008210.17068 2117040.38905 37.7934527536983 -122.41554201335899 (37.7934527536983, -122.415542013359)
69840 132367 Undocumented 2 Pittosporum eugenioides :: Tarata 110 3100 Lyon St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   5999061.27495 2119513.94993 37.7997259908076 -122.44737587699801 (37.7997259908076, -122.447375876998)
69854 132400 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2745 Larkin St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6006513.749919999 2120658.41667 37.8032914438996 -122.421668860656 (37.8032914438996, -122.421668860656)
70254 122245 Undocumented 2 Pittosporum eugenioides :: Tarata 110 47 Lake St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   5990779.800559999 2114787.3723 37.7862714344884 -122.47568719317199 (37.7862714344884, -122.475687193172)
71019 132386 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6005813.32494 2119673.13314 37.8005465862138 -122.42402259955799 (37.8005465862138, -122.424022599558)
73279 132378 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6008205.50053 2117066.58011 37.7935244053907 -122.415560027676 (37.7935244053907, -122.415560027676)
75547 132405 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2671 Leavenworth St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6007317.65081 2121868.01026 37.8066579786473 -122.418972771382 (37.8066579786473, -122.418972771382)
75850 132406 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2671 Leavenworth St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25     6007315.11916 2121861.5465700002 37.8066400884465 -122.41898107391701 (37.8066400884465, -122.418981073917)
89513 132372 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6008211.08199 2117028.50784 37.793420182046 -122.41553801857401 (37.793420182046, -122.415538018574)
93214 132388 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6005798.70292 2119672.07683 37.800542860316 -122.424073122581 (37.800542860316, -122.424073122581)
130402 132376 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     6008205.53038 2117047.83844 37.793472947059605 -122.41555859686001 (37.7934729470596, -122.41555859686)
133226 122244 Undocumented 2 Pittosporum eugenioides :: Tarata 110 47 Lake St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5990784.64686 2114787.2699700003 37.7862714344765 -122.475670418927 (37.7862714344765, -122.475670418927)
148064 132371 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6008212.2961800005 2117019.5633099996 37.7933956908179 -122.41553318381399 (37.7933956908179, -122.415533183814)
155205 132370 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6008212.89333 2117013.5005900003 37.793379077646996 -122.415530688191 (37.793379077647, -122.415530688191)
155644 194584 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1698 Galvez Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   6015435.57046 2098024.5169599997 37.7416428069711 -122.389212935026 (37.7416428069711, -122.389212935026)
163158 132375 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6008208.36982 2117045.10307 37.793465596010996 -122.41554857839701 (37.793465596011, -122.415548578397)
166409 187083 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2600 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985170.5104 2097012.8962 37.7371408955553 -122.49378330233499 (37.7371408955553, -122.493783302335)
168536 132404 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2671 Leavenworth St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6007312.64985 2121879.37275 37.806688895542294 -122.418990884623 (37.8066888955423, -122.418990884623)
178667 123936 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1 08th Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   5993306.8177 2114889.70076 37.786698577308705 -122.466951883723 (37.7866985773087, -122.466951883723)
180543 194589 Undocumented 2 Pittosporum eugenioides :: Tarata 110 11 Bridgeview Way 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6016121.54622 2108188.95403 37.7695902108346 -122.387549998659 (37.7695902108346, -122.387549998659)
183631 194586 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1698 Galvez Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6015412.99907 2098039.7697 37.7416834365362 -122.38929204481701 (37.7416834365362, -122.389292044817)
185315 132360 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2801 Pierce St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   6001534.76184 2118041.80057 37.795824887369896 -122.43871117439 (37.7958248873699, -122.43871117439)
185912 178400 Undocumented 2 Pittosporum eugenioides :: Tarata 110 802 Excelsior Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6004451.61665 2091406.41613 37.7228559442383 -122.426720588195 (37.7228559442383, -122.426720588195)
188984 132403 Undocumented 2 Pittosporum eugenioides :: Tarata 110 93 MacOndray Ln 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6008160.59399 2119098.20458 37.799100218256704 -122.415859337341 (37.7991002182567, -122.415859337341)

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