Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 3ft" and qLegalStatus = 4

View and edit SQL

Suggested facets: qSpecies, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes, 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
14 196590 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 2 : 4 Tree 1 Private 1     10 Width 3ft Permit Number 772992 6007565.6944699995 2109618.27361 37.773037177355796 -122.41724576098301 (37.7730371773558, -122.417245760983)
15 196591 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 3 : 4 Tree 1 Private 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
30 196592 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 4 : 4 Tree 1 Private 1     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.41735848920901 (37.7731013709756, -122.417358489209)
369 192563 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.777668779422896 -122.413273679445 (37.7776687794229, -122.413273679445)
372 251291 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
400 251289 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
412 251290 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
416 192564 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
451 192346 Planning Code 138.1 required 4 Fraxinus spp :: Ash Spp 83 118 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
1634 199504 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342)
1642 199503 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1009 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.983080001 2111924.50305 37.7795342467397 -122.40725478770099 (37.7795342467397, -122.407254787701)
2257 229627 Planning Code 138.1 required 4 Magnolia grandiflora :: Southern Magnolia 21 3662 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6008456.11159 2097816.22885 37.7406815009641 -122.41333091228701 (37.7406815009641, -122.413330912287)
4329 239457 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437)
4369 222216 Planning Code 138.1 required 4 Callistemon citrinus :: Lemon Bottlebrush 28 2 Van Buren St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887)
4385 224618 Planning Code 138.1 required 4 Ficus microcarpa :: Chinese Banyan 94 165 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198)
4404 239458 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)

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