Street_Tree_List

Data source: data.sfgov.org

52 rows where qSiteInfo = 9 and qSpecies = 100

View and edit SQL

Suggested facets: SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23525 187316 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2200 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5985075.4607 2099608.8478 37.744263118481705 -122.494303219592 (37.7442631184817, -122.494303219592)
24453 185441 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2300 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985106.1344 2099492.3058 37.7439449206951 -122.49418856991899 (37.7439449206951, -122.494188569919)
25705 234339 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 3ft   6004868.93824 2105500.74139 37.7615793351331 -122.426280973507 (37.7615793351331, -122.426280973507)
29021 234332 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   6004849.34041 2105800.52772 37.7624013694379 -122.42637009990601 (37.7624013694379, -122.426370099906)
30108 210927 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 234 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35     6000492.41263 2094973.31916 37.732425199355 -122.44066241093701 (37.732425199355, -122.440662410937)
32150 186007 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1900 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985000.2752 2101640.5507 37.749837221065 -122.49471294958 (37.749837221065, -122.49471294958)
32528 247549 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 815 Buena Vista Ave West 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 2ft   6000106.41756 2108406.30035 37.7692869261681 -122.44296119951099 (37.7692869261681, -122.442961199511)
33897 132069 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 45 Havens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29     6007646.13343 2119391.20002 37.7998757746973 -122.417660327771 (37.7998757746973, -122.417660327771)
34789 119450 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 800 33rd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32     5985749.05602 2110390.9661 37.7739072286205 -122.49276808877701 (37.7739072286205, -122.492768088777)
36940 233930 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 451 Florida St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 9ft   6009251.7265800005 2106253.20346 37.763892184592706 -122.41117579493 (37.7638921845927, -122.41117579493)
39365 234337 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   6004866.4127400005 2105541.3308900003 37.7616906415182 -122.42629259813299 (37.7616906415182, -122.426292598133)
39811 234396 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1351 Douglass St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 6ft   6001401.68154 2099734.75899 37.74555073898829 -122.43785977451701 (37.7455507389883, -122.437859774517)
44771 234338 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     37 Width 3ft   6004867.72819 2105514.5268599996 37.761617118366104 -122.42628614009199 (37.7616171183661, -122.426286140092)
47083 186006 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1900 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985010.9219 2101633.2915 37.7498179124605 -122.494675598244 (37.7498179124605, -122.494675598244)
48105 118707 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4201 Balboa St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 2ft   5982546.62842 2110970.49419 37.775310661099795 -122.503888560039 (37.7753106610998, -122.503888560039)
52544 186008 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1900 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985026.892000001 2101640.0667 37.749837450044495 -122.494620873169 (37.7498374500445, -122.494620873169)
54583 132068 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 3601 Broderick St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5999659.130480001 2120925.06177 37.803634670174496 -122.445408603735 (37.8036346701745, -122.445408603735)
62633 185382 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2615 34th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     36 Width 0ft   5985803.8248 2097379.5833 37.7381847526444 -122.491620661903 (37.7381847526444, -122.491620661903)
63620 234384 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 899 Hampshire St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   6010216.7904900005 2104076.88773 37.757970587791 -122.407684453188 (37.757970587791, -122.407684453188)
64753 233931 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 451 Florida St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 9ft   6009251.45318 2106264.05651 37.763921969247704 -122.411177507234 (37.7639219692477, -122.411177507234)
68513 210928 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 617 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     37     5997342.33131 2095240.63361 37.732979290542104 -122.451572201795 (37.7329792905421, -122.451572201795)
69742 210912 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 443 Gennessee St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33     5997433.76219 2094954.34243 37.732198438902294 -122.451235463255 (37.7321984389023, -122.451235463255)
72122 234341 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 3ft   6004869.93402 2105476.5468200003 37.7615129588681 -122.42627580688401 (37.7615129588681, -122.426275806884)
100781 109174 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 63 KEYSTONE WAY 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   05/04/2015 12:00:00 AM 3 3x3 Permit Number 775282 5994095.9 2093146.9 37.7270439629203 -122.46264404963699 (37.7270439629203, -122.462644049637)
129577 120800 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4400 Fulton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 5ft   5989719.73075 2109944.0609999998 37.7729115360186 -122.47900032637399 (37.7729115360186, -122.479000326374)
131685 210910 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 151 Garcia Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5994660.64772 2099277.20114 37.743908769387005 -122.461135900907 (37.743908769387, -122.461135900907)
131778 234335 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 3ft   6004864.336759999 2105585.63058 37.7618121606106 -122.42630293224899 (37.7618121606106, -122.426302932249)
132648 210911 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 443 Gennessee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32     5997433.82925 2094957.55837 37.7322072729454 -122.451235463261 (37.7322072729454, -122.451235463261)
135856 234333 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 3ft   6004857.87037 2105688.78101 37.762095021687706 -122.42633264136002 (37.7620950216877, -122.42633264136)
136108 234331 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 3ft   6004849.00155 2105814.83535 37.762440635635 -122.426372290646 (37.762440635635, -122.426372290646)
136550 186179 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1700 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984928.6664 2103564.4514 37.755115531312704 -122.49510242297701 (37.7551155313127, -122.495102422977)
150774 118706 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4201 Balboa St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 2ft   5982550.59501 2110970.7524 37.7753116033094 -122.50387485804899 (37.7753116033094, -122.503874858049)
157052 210909 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 151 Garcia Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5994659.02084 2099296.69557 37.7439622025921 -122.46114293900601 (37.7439622025921, -122.461142939006)
157407 210926 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 39 Melrose Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 10ft   5999833.49072 2095475.12852 37.7337655048678 -122.44297647541 (37.7337655048678, -122.44297647541)
159203 132067 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 3038 Lyon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   5999089.102080001 2119262.1852 37.799036302553 -122.44726145536 (37.799036302553, -122.44726145536)
160623 234336 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   6004864.2449199995 2105581.16954 37.7617999064621 -122.42630293226101 (37.7617999064621, -122.426302932261)
163173 120801 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4400 Fulton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 5ft   5989725.4481 2109944.4345400003 37.7729128936687 -122.478980576929 (37.7729128936687, -122.478980576929)
163745 234334 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 3ft   6004862.85296 2105604.25637 37.7618632187373 -122.426309390288 (37.7618632187373, -122.426309390288)
164116 194276 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2347 19th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     46     6010780.52383 2105047.83738 37.7606681393399 -122.405803207256 (37.7606681393399, -122.405803207256)
164381 218156 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1396 Portola Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30     5993216.16649 2097685.94396 37.7394563464375 -122.46601493705799 (37.7394563464375, -122.466014937058)
164993 118208 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 578 35th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 2ft   5985073.59503 2111934.34638 37.7781053878802 -122.495218423393 (37.7781053878802, -122.495218423393)
166452 210925 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 43 Melrose Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     36 Width 10ft   5999799.64358 2095482.9145400003 37.7337849536105 -122.443094053648 (37.7337849536105, -122.443094053648)
168179 119407 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 375 32nd Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 9ft   5985884.85714 2113320.57304 37.78195903231371 -122.49251412874399 (37.7819590323137, -122.492514128744)
171635 234401 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 3899 19th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   6003740.055819999 2104771.47672 37.75951307439 -122.430133288745 (37.75951307439, -122.430133288745)
171992 218157 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1396 Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44     5993196.82548 2097677.0995099996 37.7394309459859 -122.46608116671001 (37.7394309459859, -122.46608116671)
174148 234400 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4 Corwin St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     43 Width 3ft   6001132.8816599995 2103964.26051 37.7571486461001 -122.439092314277 (37.7571486461001, -122.439092314277)
176298 247642 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 632 Banks St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 4ft   6008490.96565 2095907.56445 37.7354426820387 -122.41307547425501 (37.7354426820387, -122.413075474255)
179308 124647 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2 Arguello Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     5995536.8608800005 2115835.19472 37.789423108579996 -122.459305014392 (37.78942310858, -122.459305014392)
180226 186180 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1700 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984958.094 2103565.49 37.755120105782204 -122.49500073187099 (37.7551201057822, -122.495000731871)
181869 234340 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 3ft   6004869.08955 2105489.95301 37.7615497213531 -122.42627968206499 (37.7615497213531, -122.426279682065)
182456 234394 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1350 Noe St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30     6003187.2989 2100371.4904099996 37.7474004312881 -122.431730842629 (37.7474004312881, -122.431730842629)
186247 118708 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4201 Balboa St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 2ft   5982482.88801 2110969.6299 37.7753045397791 -122.504108985066 (37.7753045397791, -122.504108985066)

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