Street_Tree_List

Data source: data.sfgov.org

264 rows where qLegalStatus = 7 sorted by qSiteInfo

View and edit SQL

qLegalStatus

  • Property Tree · 64
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
115357 98501 Property Tree 7 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard 13 Landscaping 2 Private 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
117738 104008 Property Tree 7 Pinus radiata :: Monterey Pine 3 357 Collingwood St 1 Back Yard : Yard 13 Tree 1 Private 1     36     6002124.0 2103789.0 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093)
118325 109374 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 1 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
119332 120526 Property Tree 7 Pinus radiata :: Monterey Pine 3 1439 47th Ave 1 Back Yard : Yard 13 Tree 1 Private 1     20 3x3   5981489.0 2105275.0 37.759610238830206 -122.50712446853998 (37.7596102388302, -122.50712446854)
119700 100472 Property Tree 7 Pinus radiata :: Monterey Pine 3 70 Stanford Heights Ave   Back Yard : Yard 13 Tree 1 Private 1           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729)
119975 112668 Property Tree 7 Pinus radiata :: Monterey Pine 3 129 Henry St   Back Yard : Yard 13 Tree 1 Private 1           6002668.0 2107340.8 37.766507036069605 -122.434024647923 (37.7665070360696, -122.434024647923)
120579 114365 Property Tree 7 Pinus radiata :: Monterey Pine 3 2546 28th Ave 1 Back Yard : Yard 13 Tree 1 Private 1     35     5987735.7 2097954.4 37.739875761389605 -122.48498344199601 (37.7398757613896, -122.484983441996)
120804 96938 Property Tree 7 Tree(s) :: 17 1306 Cole St   Back Yard : Yard 13 Tree 1 Private 1         Backyard tree on private property 5998246.0 2105961.0 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104)
122333 97685 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 84 Coventry Ct   Back Yard : Yard 13 Tree 1 Private 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
124085 116154 Property Tree 7 Pinus Spp :: Pine Spp 105 324 POPE ST 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6000502.0 2087202.0 37.711087470467795 -122.440072212787 (37.7110874704678, -122.440072212787)
124250 99374 Property Tree 7 Pinus radiata :: Monterey Pine 3 21 Panorama Dr   Back Yard : Yard 13 Tree 1 Private 1     24     5998009.0 2100230.0 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288)
125346 100148 Property Tree 7 Tree(s) :: 17 209 Vicksburg St   Back Yard : Yard 13 Tree 1 Private 1           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815)
127758 109376 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 3 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
128066 98503 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 208 Glenview Dr   Back Yard : Yard 13 Tree 1 Private 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
128311 98265 Property Tree 7 Pinus pinea :: Italian Stone Pine 143 755 O'Farrell St   Back Yard : Yard 13 Tree 1 Private 1         Backyard tree; not significant 6007700.0 2113968.3 37.784988860902295 -122.417089467607 (37.7849888609023, -122.417089467607)
129004 108871 Property Tree 7 Tree(s) :: 17 99x OAKWOOD ST 1 Back Yard : Yard 13 Tree 1 Private 1           6005305.0 2104962.0 37.760124716943295 -122.424734485609 (37.7601247169433, -122.424734485609)
129259 122558 Property Tree 7 Pinus radiata :: Monterey Pine 3 1760 Diamond St 1 Back Yard : Yard 13 Tree 1 Private 1     20 3x3   6001927.0 2098732.0 37.7428272563398 -122.43597156823799 (37.7428272563398, -122.435971568238)
129485 97033 Property Tree 7 Afrocarpus gracilior :: Fern Pine 70 61 Vicksburg St   Back Yard : Yard 13 Tree 1 Private 1         Possible significant tree; Nellie RoW; rear yard 6004120.0 2102703.0 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406)
139657 117644 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 1111X SANSOME ST 1 Back Yard : Yard 13 Tree 1 Private 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
140030 103504 Property Tree 7 Pinus radiata :: Monterey Pine 3 148 Huntington Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5984515.0 2095210.0 37.732152252278794 -122.49591670504999 (37.7321522522788, -122.49591670505)
140844 102706 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 1342 Funston Ave 1 Back Yard : Yard 13 Tree 1 Private 1           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645)
141038 102381 Property Tree 7 Pinus radiata :: Monterey Pine 3 258 Molimo Dr   Back Yard : Yard 13 Tree 1 Private 1           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905)
141787 103673 Property Tree 7 :: 54 64 Henry St   Back Yard : Yard 13 Tree 1 Private 1           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662)
142266 98139 Property Tree 7 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 556 Laidley St   Back Yard : Yard 13 Tree 1 Private 1       3x3   6003085.0 2096041.0 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062)
142682 102752 Property Tree 7 Sequoia sempervirens :: Coast Redwood 116 2452 Green St   Back Yard : Yard 13 Tree 1 Private 1           6001313.0 2117994.0 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164)
144179 102639 Property Tree 7 Pinus radiata :: Monterey Pine 3 251 Dorado Ter 1 Back Yard : Yard 13 Tree 1 Private 1           5994312.1 2092840.7 37.726215661035106 -122.461874461465 (37.7262156610351, -122.461874461465)
145060 102056 Property Tree 7 Pinus radiata :: Monterey Pine 3 332 19th Ave 1 Back Yard : Yard 13 Tree 1 Private 1           5990007.7 2113121.3 37.781652074321705 -122.47823656971501 (37.7816520743217, -122.478236569715)
145716 98878 Property Tree 7 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard 13 Landscaping 2 Private 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
631 251294 Property Tree 7 :: 54 7126 Geary Blvd 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
903 225889 Property Tree 7 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 3255x 24th St 7 Back Yard : Cutout 16 Tree 1 MTA 6     18 Width 8ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
2764 253207 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 89 Woodhaven Ct 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
78510 114817 Property Tree 7 Pinus radiata :: Monterey Pine 3 100 RACCOON DR 1 Back Yard : Cutout 16 Tree 1 Private 1           5998725.0 2104028.0 37.757186355085004 -122.447424250084 (37.757186355085, -122.447424250084)
85764 115641 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 7 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
86412 115638 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 4 Back Yard : Cutout 16 Tree 1 DPW 2     7 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
90360 115646 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 12 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
95069 115635 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 1 Back Yard : Cutout 16 Tree 1 DPW 2     20 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
96699 115645 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 11 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
97160 115639 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 5 Back Yard : Cutout 16 Tree 1 DPW 2     6 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
99755 115644 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 10 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102527 115648 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 14 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102675 115649 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 15 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
105687 122518 Property Tree 7 Pinus radiata :: Monterey Pine 3 772X Panorama Dr 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5996713.0 2102901.0 37.753976715350106 -122.45430108189 (37.7539767153501, -122.45430108189)
108009 115652 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 18 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
108742 110939 Property Tree 7 Pinus radiata :: Monterey Pine 3 38 SAINT CHARLES AVE 1 Back Yard : Cutout 16 Tree 1 Private 1     30 3x3   5992046.0 2088201.0 37.7133454608488 -122.46937060641001 (37.7133454608488, -122.46937060641)
111875 115636 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 2 Back Yard : Cutout 16 Tree 1 DPW 2     16 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
113407 115650 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 16 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
118558 115640 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 6 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
122253 115643 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 9 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
124724 115642 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 8 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125004 115653 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 19 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
127152 115647 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 13 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139401 115654 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 20 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139921 115637 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 3 Back Yard : Cutout 16 Tree 1 DPW 2     14 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
142076 115655 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 21 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
144101 115651 Property Tree 7 Pinus radiata :: Monterey Pine 3 81x ELSIE ST 17 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
3552 253469 Property Tree 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 701 Stanyan St 5 Side Yard : Yard 17 Tree 1 Private 1           5997178.0 2108423.0 37.7691653834469 -122.45309160151399 (37.7691653834469, -122.453091601514)
909 234895 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 3255x 24th St 6 Side Yard : Cutout 18 Tree 1 Private 1     40 Width 10ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
98218 122480 Property Tree 7 Pinus radiata :: Monterey Pine 3 596X Buckingham Way 1 Side Yard : Cutout 18 Tree 1 Private 1       3x3   5990152.0 2094375.0 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616)
85853 114950 Property Tree 7 Pinus radiata :: Monterey Pine 3 1X WOODACRE DR 2 unknown : Yard 19 Tree 1 DPW 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
111345 114949 Property Tree 7 Pinus radiata :: Monterey Pine 3 1X WOODACRE DR 1 unknown : Yard 19 Tree 1 DPW 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
126465 101951 Property Tree 7 Tree(s) :: 17 21 Lyell St   unknown : Yard 19 Tree 1 Private 1           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292)
113280 105686 Property Tree 7 Ficus microcarpa :: Chinese Banyan 94 635 08TH ST 3 Front Yard : Pot 30 Tree 1 Private 1     6     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
124771 105685 Property Tree 7 Ficus microcarpa :: Chinese Banyan 94 635 08TH ST 2 Front Yard : Pot 30 Tree 1 Private 1     8     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)
126368 105684 Property Tree 7 Ficus microcarpa :: Chinese Banyan 94 635 08TH ST 1 Front Yard : Pot 30 Tree 1 Private 1     10     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597)

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