Street_Tree_List

Data source: data.sfgov.org

56 rows where DBH = 5, qLegalStatus = 2 and qSpecies = 66

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
553 206616 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft Permit Number 779324 5994742.56026 2099334.6803900003 37.7440713065495 -122.460856833195 (37.7440713065495, -122.460856833195)
26843 206525 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 35 Madrone Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992946.5083 2098897.01812 37.7427660898953 -122.46703531413 (37.7427660898953, -122.46703531413)
27743 206657 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 41 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994149.03126 2101531.53277 37.7500691388799 -122.463068471138 (37.7500691388799, -122.463068471138)
33049 206535 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 665 Miramar Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995362.41808 2093767.65006 37.7288212525964 -122.458310655534 (37.7288212525964, -122.458310655534)
33279 206578 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 275 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993312.03833 2099686.0969 37.7449537923783 -122.46582874591199 (37.7449537923783, -122.465828745912)
34016 206586 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 360 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993997.55659 2099722.78299 37.745094043463396 -122.46346102880699 (37.7450940434634, -122.463461028807)
39199 206623 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1964 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993824.3832 2102096.20379 37.7516008749812 -122.464232103026 (37.7516008749812, -122.464232103026)
39280 206536 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 401 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994052.44062 2101520.15999 37.7500323476354 -122.463401659183 (37.7500323476354, -122.463401659183)
39830 70315 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 226 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1994 12:00:00 AM 5     5997860.8667 2109778.6627 37.7729267975155 -122.450827376517 (37.7729267975155, -122.450827376517)
44510 218322 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 420 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5993190.15092 2099959.3697 37.745697098249394 -122.466270063011 (37.7456970982494, -122.466270063011)
50429 206526 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 35 Madrone Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992953.91132 2098913.47299 37.742811698104205 -122.467010912843 (37.7428116981042, -122.467010912843)
50876 206684 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 647 Los Palmos Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996011.49185 2096001.54035 37.7349922529962 -122.456228229446 (37.7349922529962, -122.456228229446)
55179 184366 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2295 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987606.9921 2099709.6419 37.7446876937291 -122.485557233352 (37.7446876937291, -122.485557233352)
55439 223036 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2743 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008969.13541 2102480.10351 37.7535162573804 -122.411886554326 (37.7535162573804, -122.411886554326)
56319 206573 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 51 Cortes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993216.90415 2099626.41246 37.7447844257663 -122.466153363383 (37.7447844257663, -122.466153363383)
57787 206540 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 387 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994134.95664 2101369.7507 37.7496241156629 -122.46310540451401 (37.7496241156629, -122.463105404514)
59046 206654 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994247.90783 2101537.24109 37.7500905076701 -122.46272696707399 (37.7500905076701, -122.462726967074)
61321 206667 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993986.73582 2100929.3593 37.74840637335971 -122.46358599590499 (37.7484063733597, -122.463585995905)
61905 190927 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1050 Wisconsin St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6012767.00645 2102579.68997 37.7540020378723 -122.39875959738 (37.7540020378723, -122.39875959738)
62392 206521 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2290 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991723.002619999 2099864.63418 37.7453522181485 -122.471336295754 (37.7453522181485, -122.471336295754)
64527 206668 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 15 Sotelo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993998.36893 2100916.3469700003 37.7483713150869 -122.46354482495501 (37.7483713150869, -122.463544824955)
66424 206580 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 275 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993286.92729 2099684.15258 37.7449470052046 -122.46591543334401 (37.7449470052046, -122.465915433344)
66495 206683 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 647 Los Palmos Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995995.17419 2096006.3401799998 37.7350044954584 -122.45628499197399 (37.7350044954584, -122.456284991974)
66828 206680 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 657 Los Palmos Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995948.68471 2096013.6289400002 37.73502183977529 -122.456446248507 (37.7350218397753, -122.456446248507)
67024 206497 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1616 08th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5993722.387569999 2104477.6450099996 37.7581338201448 -122.464757733396 (37.7581338201448, -122.464757733396)
68999 206663 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 390 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994181.82756 2101452.31219 37.7498535084399 -122.46294931367399 (37.7498535084399, -122.462949313674)
74247 206636 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 159 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994544.936980001 2100878.69027 37.7482993963164 -122.461652089281 (37.7482993963164, -122.461652089281)
75436 206640 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 175 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994518.44354 2100835.0258299997 37.7481779797266 -122.46174053670201 (37.7481779797266, -122.461740536702)
126753 206613 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 432 Dewey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5995024.84981 2100327.10403 37.746812492318604 -122.459952623323 (37.7468124923186, -122.459952623323)
130265 206637 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 159 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994549.87925 2100894.15199 37.7483421347836 -122.461636120028 (37.7483421347836, -122.461636120028)
133199 206579 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 275 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993299.1056 2099684.88554 37.744949720257004 -122.46587337656601 (37.744949720257, -122.465873376566)
148350 206542 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 351 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994154.36407 2101104.3868400003 37.748896611800106 -122.46301904261999 (37.7488966118001, -122.46301904262)
148524 126381 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1022 Vallejo St 1 Front Yard : Yard 7 Tree 1 Private 1     5     6008596.5256900005 2118672.84077 37.7979567725457 -122.414320748412 (37.7979567725457, -122.414320748412)
150656 247816 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 550 30th St 1 : 4 Tree 1 Private 1     5 Width 3ft   6003030.78831 2098349.34835 37.741839226995204 -122.43212766126899 (37.7418392269952, -122.432127661269)
151567 206554 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 47 Sotelo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993895.61602 2101166.1129900003 37.749051188161296 -122.46391826663401 (37.7490511881613, -122.463918266634)
153873 206585 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 368 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993961.3420400005 2099692.54098 37.745008919941 -122.463584056983 (37.745008919941, -122.463584056983)
154984 206629 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 81 Ventura Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994298.95446 2101835.26425 37.7509117433916 -122.46257206157101 (37.7509117433916, -122.462572061571)
155591 206679 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 657 Los Palmos Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995939.36036 2096013.8239 37.7350218397738 -122.456478499997 (37.7350218397738, -122.456478499997)
157129 206655 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Alton Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994255.40167 2101538.8525799997 37.7500953640099 -122.462701170033 (37.7500953640099, -122.462701170033)
160214 206681 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 657 Los Palmos Dr 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995960.60425 2096012.63655 37.735019799206 -122.45640496693399 (37.735019799206, -122.456404966934)
162481 206599 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5995053.984619999 2100829.4455 37.748193471465704 -122.459888261529 (37.7481934714657, -122.459888261529)
164832 71420 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 637 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/26/1995 12:00:00 AM 5     6009832.0273 2120182.0847 37.8021701092209 -122.410152151595 (37.8021701092209, -122.410152151595)
165454 206630 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 81 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994323.8061 2101846.4166200003 37.7509437961254 -122.46248693172701 (37.7509437961254, -122.462486931727)
165652 206674 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 300 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995208.64941 2095407.77696 37.7333158051714 -122.458960944512 (37.7333158051714, -122.458960944512)
170563 206605 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Magellan Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5995038.86988 2100730.57279 37.7479211225827 -122.459933366148 (37.7479211225827, -122.459933366148)
170640 137632 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2175 TURK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5999619.2063 2111878.8056 37.7787937523144 -122.44489608677401 (37.7787937523144, -122.444896086774)
170709 206644 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 180 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994467.924 2100831.48615 37.748165352368105 -122.46191497372 (37.7481653523681, -122.46191497372)
171063 206569 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2435 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992009.07535 2098867.5883299997 37.7426311295378 -122.47027451837099 (37.7426311295378, -122.470274518371)
174269 223032 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 281 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006256.18709 2096109.4549 37.735871320489395 -122.42081628443898 (37.7358713204894, -122.420816284439)
174299 126377 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 122 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6001345.97363 2121147.25207 37.8043408951819 -122.439587150049 (37.8043408951819, -122.439587150049)
174659 206543 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 347 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994159.12368 2101087.0695700003 37.7488493371331 -122.463001327749 (37.7488493371331, -122.463001327749)
176273 206546 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 265 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5994442.894180001 2100449.8026 37.747115904674004 -122.46197385141399 (37.747115904674, -122.461973851414)
179932 206676 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 240 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994971.50428 2095856.22795 37.7345335069973 -122.459813287749 (37.7345335069973, -122.459813287749)
181807 206656 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Alton Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994277.8238699995 2101540.85875 37.75010216378529 -122.46262377888 (37.7501021637853, -122.46262377888)
186378 206627 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 40 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994076.75455 2101874.6545700002 37.751007100296604 -122.463343302157 (37.7510071002966, -122.463343302157)
187180 223054 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 701 Church St 15 Front Yard : Yard 7 Tree 1 Private 1     5 Width 3ft   6004339.171130001 2104460.25399 37.758692444824206 -122.42803907256099 (37.7586924448242, -122.428039072561)

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