Street_Tree_List

Data source: data.sfgov.org

58 rows where qSpecies = 24

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
52 233897 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1021 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003182.0050800005 2102290.73647 37.75266992967379 -122.43188616810801 (37.7526699296738, -122.431886168108)
255 19810 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 100 STAIRWAY24 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
10652 85929 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 1706 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988139.8339 2103656.0542 37.7555545188612 -122.484004126341 (37.7555545188612, -122.484004126341)
16666 19812 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 100 STAIRWAY24 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
22308 248932 Landmark tree 9 Araucaria heterophylla :: Norfolk Island Pine 24 46 Cook St 1 Front Yard : Yard 7 Tree 1 Private 1         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
24730 222027 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 310 Liberty St 60 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6003716.8909599995 2103932.15667 37.7572071892775 -122.430153527076 (37.7572071892775, -122.430153527076)
25420 185893 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2000 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985001.2813 2101166.1106 37.748534597155704 -122.49467449717399 (37.7485345971557, -122.494674497174)
28801 44101 Permitted Site 1 Araucaria heterophylla :: Norfolk Island Pine 24 2900 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2000 12:00:00 AM 33   Permit Number 43613 5999651.42803 2117418.51494 37.794006189278996 -122.44518300341801 (37.794006189279, -122.445183003418)
28809 222024 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1000 Jarboe Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6009378.65021 2096845.36529 37.7380674730247 -122.410072588498 (37.7380674730247, -122.410072588498)
37019 222023 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1000 Jarboe Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6009382.55591 2096845.28557 37.7380674730416 -122.410059078869 (37.7380674730416, -122.410059078869)
38893 204763 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 15 Mesa Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 3ft   5993655.2243 2100726.8322900003 37.74783117867911 -122.46471764161899 (37.7478311786791, -122.464717641619)
39126 184014 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1600 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984965.7137 2103757.8086 37.755648605544295 -122.494988561115 (37.7556486055443, -122.494988561115)
44076 204762 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 514 Arch St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5992759.51953 2090548.2744200001 37.7198317175461 -122.467075007517 (37.7198317175461, -122.467075007517)
44520 204760 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2 Mesa Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 4ft   5993716.1634599995 2100737.36398 37.7478636091272 -122.46450768320801 (37.7478636091272, -122.464507683208)
44913 222025 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 562 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007847.71054 2104641.6331599997 37.7593883456249 -122.41591774922199 (37.7593883456249, -122.415917749222)
47090 181401 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1500 Sunset Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984931.8298 2104672.7619 37.758158829946 -122.495173208442 (37.758158829946, -122.495173208442)
52395 186279 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984978.0469 2102499.6631 37.752194806922 -122.494853149984 (37.752194806922, -122.494853149984)
53924 185395 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2300 Sunset Blvd 7 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985077.1425 2098975.4486 37.7425240740104 -122.494250726815 (37.7425240740104, -122.494250726815)
54513 222028 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 190 Storrie St 9 Front Yard : Yard 7 Tree 1 Private 1     3 Width 3ft   6000755.512680001 2105304.8247599998 37.7608080280015 -122.440493543449 (37.7608080280015, -122.440493543449)
54868 30424 Permitted Site 1 Araucaria heterophylla :: Norfolk Island Pine 24 225 Wheeler Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/1972 12:00:00 AM 25   Permit Number 10489 6012257.47083 2087577.3317 37.7127802853635 -122.399468524874 (37.7127802853635, -122.399468524874)
55315 183955 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2100 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985033.6446 2100586.6805 37.746945534293 -122.494519878447 (37.746945534293, -122.494519878447)
55838 222020 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 211 Ogden Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6008297.46428 2096092.63045 37.7359399684425 -122.413757569564 (37.7359399684425, -122.413757569564)
56929 222030 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 35 Mars St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   5999601.42077 2105598.42745 37.7615484047597 -122.444506122353 (37.7615484047597, -122.444506122353)
58553 204758 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1696 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   5993741.9732099995 2103977.3015 37.7567611354409 -122.464653666529 (37.7567611354409, -122.464653666529)
60439 185423 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2300 Sunset Blvd 39 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985071.643999999 2099284.3632 37.7433719482454 -122.494292503743 (37.7433719482454, -122.494292503743)
60595 183954 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2100 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985054.4746 2100602.91 37.746991315173794 -122.494449047407 (37.7469913151738, -122.494449047407)
63529 187142 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984897.1125 2099461.8744 37.7438491307401 -122.494909065698 (37.7438491307401, -122.494909065698)
64387 187161 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984952.2414 2099389.4695 37.7436535534966 -122.494713108664 (37.7436535534966, -122.494713108664)
66439 187150 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984947.2414 2099450.3955 37.74382054712321 -122.494734888113 (37.7438205471232, -122.494734888113)
67097 187153 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984906.5006 2099427.4325 37.7437551121762 -122.494874065391 (37.7437551121762, -122.494874065391)
69553 186176 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1700 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984967.0954 2103538.8321 37.755047437501 -122.49496763736 (37.755047437501, -122.49496763736)
70425 222022 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 211 Ogden Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008277.8244900005 2096093.47725 37.7359411906319 -122.413825532246 (37.7359411906319, -122.413825532246)
73259 185895 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2000 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985036.6346 2101201.464 37.748633737152296 -122.49455485368799 (37.7486337371523, -122.494554853688)
73428 125575 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1931 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5999445.841580001 2115532.3349099997 37.7888154993698 -122.445758639673 (37.7888154993698, -122.445758639673)
74095 204759 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2 Mesa Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5993698.72815 2100745.29899 37.747884391552205 -122.4645685493 (37.7478843915522, -122.4645685493)
74803 222029 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 144 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002834.60405 2107464.25398 37.76685546424061 -122.433457218072 (37.7668554642406, -122.433457218072)
75867 204761 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 179 Ashton Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     5994134.44181 2091130.3042799998 37.7215090988363 -122.46236461136101 (37.7215090988363, -122.462364611361)
77799 105836 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 2100X SLOAT BLVD 1 Median : Yard 3 Tree 1 DPW 2     2     5984309.0 2095832.0 37.733848030924 -122.49667476772 (37.733848030924, -122.49667476772)
94753 110144 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 129 DE SOTO ST 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     15 10x10   5993256.9 2092045.6 37.723971707155705 -122.465464466989 (37.7239717071557, -122.465464466989)
99119 121475 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 705 Victoria St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       10x10   5993498.0 2091842.0 37.723426573455896 -122.464616252006 (37.7234265734559, -122.464616252006)
104673 117535 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 278 JUANITA WAY 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 6x3   5995559.0 2097690.0 37.7396023643565 -122.457914790839 (37.7396023643565, -122.457914790839)
105495 112955 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 24 121X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5991652.84779157 2095347.0788301998 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136)
108029 86830 Permitted Site 1 Araucaria heterophylla :: Norfolk Island Pine 24 144 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3 unpermitted private planting on DPW-maintained street 6002845.0 2107418.0 37.7667290519071 -122.43341795453999 (37.7667290519071, -122.43341795454)
108075 116951 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 24 299 Tara St 1 Front Yard : Yard 7 Tree 1 Private 1           5997754.0 2090179.6 37.7191064490611 -122.44978436622101 (37.7191064490611, -122.449784366221)
114869 111205 Landmark tree 9 Araucaria heterophylla :: Norfolk Island Pine 24 46 COOK ST   Back Yard : Yard 13 Tree 1 Private 1     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
128569 97396 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 1203X Sunset Blvd 15 Median : Yard 3 Tree 1 DPW 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
130897 186280 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985011.8758 2102500.8713 37.7522001044765 -122.494736255211 (37.7522001044765, -122.494736255211)
132070 181429 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1500 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984933.5007 2104844.5838 37.7586307029356 -122.495180100301 (37.7586307029356, -122.495180100301)
133583 204764 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 281 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 10ft   6000236.12204 2094924.0509099998 37.73227532195 -122.44154493094901 (37.73227532195, -122.441544930949)
142749 97395 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 1203X Sunset Blvd 14 Median : Yard 3 Tree 1 DPW 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
147449 186314 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984957.5078 2102814.9976 37.7530594263796 -122.494947425095 (37.7530594263796, -122.494947425095)
148559 184085 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1600 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984928.3026 2104071.5069 37.756507744074604 -122.495141070042 (37.7565077440746, -122.495141070042)
159405 222021 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 211 Ogden Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008284.08114 2096093.57167 37.735941801256295 -122.413803907119 (37.7359418012563, -122.413803907119)
165539 222019 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 241 Crescent Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006672.98133 2095813.6352 37.735082548524794 -122.419354279976 (37.7350825485248, -122.419354279976)
167100 186055 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1901 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984800.4513 2102206.1385 37.751378471683005 -122.495445647673 (37.751378471683, -122.495445647673)
169988 183953 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2100 Sunset Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985069.1522 2100584.5154 37.74694166760111 -122.49439693858 (37.7469416676011, -122.49439693858)
172794 222026 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 47 Seward St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000832.932440001 2104328.85596 37.7581326645179 -122.440155795856 (37.7581326645179, -122.440155795856)
185669 186313 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984992.9477 2102798.4858 37.753016164086205 -122.494823651515 (37.7530161640862, -122.494823651515)

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