Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by qAddress

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
53867 204800 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 0 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5991281.57381 2102416.71556 37.752334025717296 -122.473048745206 (37.7523340257173, -122.473048745206)
29723 177927 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     5988959.91996 2089504.3338 37.716745265857 -122.48013237763 (37.716745265857, -122.48013237763)
61160 177926 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5988935.7978 2089543.3512799998 37.7168509964648 -122.480218609114 (37.7168509964648, -122.480218609114)
61899 177929 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5988839.75679 2089455.3276 37.7166037242653 -122.48054413220699 (37.7166037242653, -122.480544132207)
69696 177930 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5988862.76325 2089422.54432 37.7165150466091 -122.480462212988 (37.7165150466091, -122.480462212988)
70010 177934 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     5988635.61259 2089280.10032 37.7161107276166 -122.481236924063 (37.7161107276166, -122.481236924063)
131812 177931 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     5988808.760919999 2089375.86435 37.716383736599205 -122.480645454328 (37.7163837365992, -122.480645454328)
135710 177932 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     5988789.67714 2089358.2569799998 37.7163342819918 -122.480710128176 (37.7163342819918, -122.480710128176)
146613 177923 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5988561.02848 2089156.81478 37.715767879956104 -122.481485695422 (37.7157678799561, -122.481485695422)
148235 177933 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988685.34824 2089320.7162799998 37.7162251402652 -122.481067988213 (37.7162251402652, -122.481067988213)
178623 177928 Undocumented 2 Olea europaea :: Olive Tree 41 0 Bucareli Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     5988855.6313 2089468.65527 37.716641241284705 -122.480490237638 (37.7166412412847, -122.480490237638)
35071 176378 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Crespi Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     5989827.05129 2090325.18948 37.7190494782331 -122.477195118066 (37.7190494782331, -122.477195118066)
36449 176377 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Crespi Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989839.20092 2090334.4554299999 37.7190756251255 -122.47715379871201 (37.7190756251255, -122.477153798712)
73344 176058 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Crespi Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     5989854.78687 2090110.33741 37.7184611570226 -122.47708355628599 (37.7184611570226, -122.477083556286)
135205 177925 Undocumented 2 Olea europaea :: Olive Tree 41 0 Crespi Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28     5989826.52584 2090074.03315 37.71835983492971 -122.477178590321 (37.7183598349297, -122.477178590321)
184101 177924 Undocumented 2 Olea europaea :: Olive Tree 41 0 Crespi Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5989730.82285 2090240.32639 37.718810881792 -122.47752153959 (37.718810881792, -122.47752153959)
69468 177945 Undocumented 2 Olea europaea :: Olive Tree 41 0 Diaz Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5990273.00331 2089979.48461 37.718126121809604 -122.47562842082701 (37.7181261218096, -122.475628420827)
22882 176369 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5990491.08034 2089186.3269 37.7159609464097 -122.47481676917101 (37.7159609464097, -122.474816769171)
25725 178308 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31     5990210.12045 2089417.27348 37.716578783365605 -122.47580474370501 (37.7165787833656, -122.475804743705)
38217 176045 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5990157.58815 2089581.85402 37.7170276349961 -122.475998332672 (37.7170276349961, -122.475998332672)
44468 176364 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5988874.21496 2090711.48965 37.720054833031504 -122.480516928613 (37.7200548330315, -122.480516928613)
53417 176367 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989068.70923 2090618.6052 37.7198110969962 -122.479837842465 (37.7198110969962, -122.479837842465)
65336 176043 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     5989267.954919999 2090414.23117 37.7192615104927 -122.47913418591499 (37.7192615104927, -122.479134185915)
71655 176365 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5988916.46599 2090663.1949 37.719924683163 -122.48036734976999 (37.719924683163, -122.48036734977)
75369 176363 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5988462.773440001 2091307.9607099998 37.7216686718604 -122.48198279658399 (37.7216686718604, -122.481982796584)
134960 176366 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5989001.162169999 2090698.46083 37.720026436042104 -122.48007716733801 (37.7200264360421, -122.480077167338)
136145 176368 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     5990356.63176 2089404.5642 37.7165523801656 -122.475297405564 (37.7165523801656, -122.475297405564)
136573 177298 Undocumented 2 Magnolia doltsopa :: Himalayan Magnolia 187 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5988403.4281 2091243.7200900002 37.721488831717 -122.48218323117099 (37.721488831717, -122.482183231171)
151804 176362 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5988643.66331 2091104.1894200002 37.721119686105204 -122.481342600695 (37.7211196861052, -122.481342600695)
153599 176040 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     5989182.3515099995 2090508.47222 37.719515300969206 -122.479436972335 (37.7195153009692, -122.479436972335)
161995 176044 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21     5990534.22824 2089263.3063400001 37.7161748133009 -122.47467324639099 (37.7161748133009, -122.474673246391)
163843 176041 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5989102.080019999 2090436.91452 37.71931415859461 -122.479709205217 (37.7193141585946, -122.479709205217)
166239 176046 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5990073.98867 2089647.08481 37.7172018948419 -122.47629205486 (37.7172018948419, -122.47629205486)
183286 177914 Undocumented 2 Olea europaea :: Olive Tree 41 0 Font Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5989849.3669300005 2089820.74775 37.7176657012986 -122.477081140675 (37.7176657012986, -122.477081140675)
185959 176042 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Font Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     5989234.3289 2090278.8910299998 37.7188879474116 -122.47924052173599 (37.7188879474116, -122.479240521736)
25292 177947 Undocumented 2 Olea europaea :: Olive Tree 41 0 Fuente Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989601.96089 2090504.09134 37.7195276360688 -122.477986231896 (37.7195276360688, -122.477986231896)
32094 177949 Undocumented 2 Olea europaea :: Olive Tree 41 0 Fuente Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989559.04866 2090448.7873900002 37.7193732944219 -122.47813052091101 (37.7193732944219, -122.478130520911)
54108 176348 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 0 Fuente Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     5989603.79735 2090546.09261 37.7196430676648 -122.47798295295799 (37.7196430676648, -122.477982952958)
62097 177948 Undocumented 2 Olea europaea :: Olive Tree 41 0 Fuente Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5989566.53985 2090511.4530000002 37.7195457933774 -122.47810920609601 (37.7195457933774, -122.478109206096)
123716 177946 Undocumented 2 Olea europaea :: Olive Tree 41 0 Fuente Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5989610.43005 2090657.9013200002 37.7199504514394 -122.477968195982 (37.7199504514394, -122.477968195982)
27126 177939 Undocumented 2 Olea europaea :: Olive Tree 41 0 Garces Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5989472.35628 2089125.29207 37.7157342731997 -122.478333458321 (37.7157342731997, -122.478333458321)
51889 177940 Undocumented 2 Olea europaea :: Olive Tree 41 0 Garces Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     5989427.62768 2089128.0215200002 37.7157391708956 -122.478488258642 (37.7157391708956, -122.478488258642)
149147 177935 Undocumented 2 Olea europaea :: Olive Tree 41 0 Garces Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15     5989493.36658 2088932.77712 37.715206894553795 -122.47824676997699 (37.7152068945538, -122.478246769977)
172901 177937 Undocumented 2 Olea europaea :: Olive Tree 41 0 Garces Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     5989487.39768 2088989.39507 37.7153620069155 -122.47827153820299 (37.7153620069155, -122.478271538203)
176036 177936 Undocumented 2 Olea europaea :: Olive Tree 41 0 Garces Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     5989491.06081 2088964.9371200001 37.715295064093205 -122.478257089699 (37.7152950640932, -122.478257089699)
184364 177938 Undocumented 2 Olea europaea :: Olive Tree 41 0 Garces Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     5989480.9198900005 2089050.18574 37.71552854698071 -122.478298370392 (37.7155285469807, -122.478298370392)
24035 178607 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
24183 175768 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
24841 175769 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
24880 178117 Undocumented 2 Photinia fraseri :: Photinia: Chinese photinia 104 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988789.573419999 2089765.1297400002 37.717451446800204 -122.480740256365 (37.7174514468002, -122.480740256365)
27306 178328 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29     5990317.34225 2090043.8786900002 37.718305502374704 -122.47547986090599 (37.7183055023747, -122.475479860906)
29157 175654 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     5989491.89044 2089216.44658 37.7159856948481 -122.478272601196 (37.7159856948481, -122.478272601196)
29386 177222 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5989183.517969999 2089355.54971 37.7163497314364 -122.479348640047 (37.7163497314364, -122.479348640047)
31497 178323 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     5990245.32384 2089538.4798299999 37.7169136270349 -122.475691910275 (37.7169136270349, -122.475691910275)
36738 181277 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988402.74919 2089827.8491900002 37.7176011677477 -122.482081905481 (37.7176011677477, -122.482081905481)
36921 175655 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     5989994.06268 2089291.6225400001 37.7162212479866 -122.476542364932 (37.7162212479866, -122.476542364932)
40050 176160 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5990378.89561 2089837.21304 37.7177416175535 -122.47525201947701 (37.7177416175535, -122.475252019477)
40111 178175 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5989026.35056 2089515.5020599999 37.7167797908382 -122.47990357931002 (37.7167797908382, -122.47990357931)
40567 176049 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989054.79394 2089564.29309 37.716915411303 -122.479808833919 (37.716915411303, -122.479808833919)
40789 176052 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     5989234.209980001 2089407.1197400002 37.716494274064495 -122.47917719598 (37.7164942740645, -122.47917719598)
41434 175767 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989494.93952 2089175.43765 37.7158732715029 -122.478259065526 (37.7158732715029, -122.478259065526)
43657 177729 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5990316.61378 2090071.1896099998 37.718380449173395 -122.47548437190399 (37.7183804491734, -122.475484371904)
44057 175774 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5990113.97654 2089437.91841 37.7166298945381 -122.47613856845 (37.7166298945381, -122.47613856845)
44691 175766 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989094.03032 2089506.27121 37.7167583770722 -122.47966897135001 (37.7167583770722, -122.47966897135)
44701 175656 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5990014.1272599995 2089314.5953099998 37.716285489253 -122.476474690052 (37.716285489253, -122.476474690052)
51076 177220 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5989003.1682400005 2089530.2906900002 37.7168190498446 -122.47998478988801 (37.7168190498446, -122.479984789888)
53937 175653 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     5988966.88544 2089648.46014 37.7171414055178 -122.480118843736 (37.7171414055178, -122.480118843736)
55378 176054 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5989245.31981 2089315.2477799999 37.7162426617475 -122.47913207879101 (37.7162426617475, -122.479132078791)
56400 175657 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     5990127.49163 2089397.98883 37.716521041479204 -122.476088939347 (37.7165210414792, -122.476088939347)
56811 178172 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988133.68649 2089845.1312099998 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625)
59851 175772 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5989911.02174 2089222.5365 37.716026738112 -122.47682434649201 (37.716026738112, -122.476824346492)
60239 178116 Undocumented 2 Photinia fraseri :: Photinia: Chinese photinia 104 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988774.083930001 2089765.9400900002 37.7174527715132 -122.480793855056 (37.7174527715132, -122.480793855056)
62427 176057 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989281.98257 2089351.5172299999 37.7163443777799 -122.479008007435 (37.7163443777799, -122.479008007435)
63730 178606 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5989765.07873 2089203.5232 37.715966065363205 -122.47732740025499 (37.7159660653632, -122.477327400255)
67488 177728 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5990346.90752 2090145.93714 37.7185874434309 -122.475385114628 (37.7185874434309, -122.475385114628)
67578 178320 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28     5988848.05481 2089780.78106 37.7174978203386 -122.480539260585 (37.7174978203386, -122.480539260585)
69208 176048 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5989010.93647 2089619.81285 37.7170653066825 -122.479964486788 (37.7170653066825, -122.479964486788)
69442 178322 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31     5989407.26888 2089196.13882 37.7159250221006 -122.478563605643 (37.7159250221006, -122.478563605643)
70417 177219 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988139.55796 2089802.05972 37.7175150450661 -122.48298973781 (37.7175150450661, -122.48298973781)
71083 175563 Undocumented 2 Betula pendula :: European White Birch 146 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     5988277.07749 2089797.21556 37.71750974536221 -122.482514046798 (37.7175097453622, -122.482514046798)
90725 178324 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30     5990257.3816599995 2089553.17282 37.7169546693979 -122.475651304982 (37.7169546693979, -122.475651304982)
117022 177727 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5989471.66726 2089216.87415 37.715985694863896 -122.47834253249201 (37.7159856948639, -122.478342532492)
127115 178176 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325)
130676 178327 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28     5990329.946140001 2089929.88135 37.7179932244997 -122.475427976322 (37.7179932244997, -122.475427976322)
132572 177726 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5989405.70354 2089245.5650799999 37.7160606434521 -122.478572628528 (37.7160606434521, -122.478572628528)
132856 178174 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988358.3694 2089791.63303 37.717499145949 -122.48223265254101 (37.717499145949, -122.482232652541)
134179 178325 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28     5990390.33795 2089760.9336299999 37.7175328363477 -122.47520690318599 (37.7175328363477, -122.475206903186)
135161 178321 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5989145.21541 2089457.7452900002 37.716628110272005 -122.479488503489 (37.716628110272, -122.479488503489)
146394 178605 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988508.8443599995 2089780.72483 37.71747794624039 -122.48171173733299 (37.7174779462404, -122.481711737333)
148106 178604 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988124.07873 2089803.3530000001 37.7175176953569 -122.48304333649999 (37.7175176953569, -122.4830433365)
152019 178326 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     5990372.2115400005 2089922.4902 37.7179753801352 -122.475281345478 (37.7179753801352, -122.475281345478)
152141 177221 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989179.19874 2089367.33922 37.7163818516244 -122.479364431248 (37.7163818516244, -122.479364431248)
154455 175771 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     5989791.935380001 2089208.15493 37.7159803412063 -122.477234910356 (37.7159803412063, -122.477234910356)
154485 176056 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5989277.7182599995 2089365.90518 37.7163836358725 -122.47902379861401 (37.7163836358725, -122.479023798614)
156730 181275 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988424.04089 2089826.4329400002 37.7175985174299 -122.482008206935 (37.7175985174299, -122.482008206935)
160065 176051 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     5989218.52603 2089406.1518400002 37.7164907055632 -122.479231336085 (37.7164907055632, -122.479231336085)
165883 178118 Undocumented 2 Photinia fraseri :: Photinia: Chinese photinia 104 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988803.05395 2089760.9840900002 37.7174408474004 -122.480693357611 (37.7174408474004, -122.480693357611)
167088 175765 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5988629.85447 2089774.3019599998 37.7174673468061 -122.481292995899 (37.7174673468061, -122.481292995899)
168076 175652 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     5988848.344219999 2089725.7642299999 37.717346774709505 -122.480534235175 (37.7173467747095, -122.480534235175)
168519 181276 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5988413.87941 2089827.13064 37.7175998421416 -122.482043381217 (37.7175998421416, -122.482043381217)

Next page

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