Street_Tree_List

Data source: data.sfgov.org

352 rows where qSpecies = 71

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
280 194427 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 905 Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
1103 211013 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 44 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5991332.59313 2093509.69784 37.727880584217 -122.47222310103399 (37.727880584217, -122.472223101034)
1116 8576 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 3 Median : Cutout 11 Tree 1 DPW 2     48 6   6001010.5429 2113459.32 37.7832127479531 -122.440196288881 (37.7832127479531, -122.440196288881)
1548 8472 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 9 Median : Cutout 11 Tree 1 DPW 2     6 8   6002074.2026 2113678.2789 37.7838744530021 -122.436532136471 (37.7838744530021, -122.436532136471)
2179 252925 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 700 Sanchez St 2 Front Yard : Yard 7 Tree 1 DPW 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
3479 8471 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 8 Median : Cutout 11 Tree 1 DPW 2   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.783879157642104 -122.43635890448 (37.7838791576421, -122.43635890448)
3759 253555 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 27 Ceres St 1 Front Yard : Yard 7 Tree 1 Private 1 FUF 1         6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
4472 8393 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1500 Geary Blvd 4 Median : Cutout 11 Tree 1 DPW 2     36 8   6004320.9581 2113985.4149 37.7848451877241 -122.428781097193 (37.7848451877241, -122.428781097193)
4747 253677 Significant Tree 6 Pinus canariensis :: Canary Island Pine 71 199X Kissling St 1 Side Yard : Cutout 18 Tree 1 Private 1       5x10            
4769 194422 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 199X Kissling St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     52 Width 5ft   6007901.53326 2109054.5781799997 37.771508291196 -122.41604412194401 (37.771508291196, -122.416044121944)
5263 8574 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2     6 6   6001134.4053 2113480.9790000003 37.783279269060294 -122.43976932905301 (37.7832792690603, -122.439769329053)
5271 8390 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1500 Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2     36 8   6004488.7034 2114010.5767 37.784923768316396 -122.428202546761 (37.7849237683164, -122.428202546761)
5273 8391 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1500 Geary Blvd 2 Median : Cutout 11 Tree 1 DPW 2     36 8   6004438.3798 2114005.2394 37.784906265949004 -122.428376269712 (37.784906265949, -122.428376269712)
5280 8392 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1500 Geary Blvd 3 Median : Cutout 11 Tree 1 DPW 2     36 8   6004378.143999999 2113996.8521 37.784879827842296 -122.428584068109 (37.7848798278423, -122.428584068109)
5311 8577 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 4 Median : Cutout 11 Tree 1 DPW 2     36 6   6000958.4259 2113453.9053 37.783194913277796 -122.440376203878 (37.7831949132778, -122.440376203878)
5837 8395 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1500 Geary Blvd 6 Median : Cutout 11 Tree 1 DPW 2   06/09/1994 12:00:00 AM 6 8   6004192.8617 2113973.9777 37.7848065332396 -122.429223453232 (37.7848065332396, -122.429223453232)
6394 8581 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 8 Median : Cutout 11 Tree 1 DPW 2     24 6   6000715.1007 2113420.9091 37.7830904567466 -122.441215640748 (37.7830904567466, -122.441215640748)
6395 8394 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1500 Geary Blvd 5 Median : Cutout 11 Tree 1 DPW 2     36 8   6004234.0356 2113977.7901 37.784819331933 -122.429081276927 (37.784819331933, -122.429081276927)
6405 8469 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 6 Median : Cutout 11 Tree 1 DPW 2     48 8   6002244.0904 2113695.2 37.7839305664786 -122.435945599699 (37.7839305664786, -122.435945599699)
6701 8474 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 11 Median : Cutout 11 Tree 1 DPW 2     6 8   6001879.2717 2113651.8819999998 37.7837908949329 -122.437204633286 (37.7837908949329, -122.437204633286)
6954 8532 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2100 Geary Blvd 3 Median : Cutout 11 Tree 1 DPW 2   06/10/1994 12:00:00 AM 6 6   6001535.4351 2113580.6442 37.783575742772705 -122.438389071264 (37.7835757427727, -122.438389071264)
7041 20305 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 50X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
7070 8575 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 2 Median : Cutout 11 Tree 1 DPW 2     48 6   6001093.7947 2113474.2106 37.7832583731226 -122.439909339764 (37.7832583731226, -122.439909339764)
7244 8475 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 12 Median : Cutout 11 Tree 1 DPW 2   06/03/1994 12:00:00 AM 6 8   6001831.8926 2113645.1136 37.7837696172579 -122.43736806210899 (37.7837696172579, -122.437368062109)
7257 8535 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2100 Geary Blvd 6 Median : Cutout 11 Tree 1 DPW 2     18 6   6001300.5704 2113502.1304 37.7833468021346 -122.439195981768 (37.7833468021346, -122.439195981768)
7433 19666 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY5 65 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60ST            
7700 8586 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 13 Median : Cutout 11 Tree 1 DPW 2     24 6   6000400.7068 2113377.2527 37.782952673809795 -122.442300177437 (37.7829526738098, -122.442300177437)
8091 8578 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 5 Median : Cutout 11 Tree 1 DPW 2     18 6   6000905.6321 2113444.4294 37.7831658887746 -122.44055816885599 (37.7831658887746, -122.440558168856)
8635 8582 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 9 Median : Cutout 11 Tree 1 DPW 2     18 6   6000649.7853 2113412.1102 37.7830625764785 -122.441440973241 (37.7830625764785, -122.441440973241)
8796 8530 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2100X Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2   06/10/1994 12:00:00 AM 15     6001630.1932 2113615.3325 37.783676377346794 -122.438063730933 (37.7836763773468, -122.438063730933)
9646 114139 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1200X JUNIPERO SERRA BLVD 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9654 114138 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1200X JUNIPERO SERRA BLVD 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1   02/16/2016 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9658 114124 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1200X JUNIPERO SERRA BLVD 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9665 114123 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1200X JUNIPERO SERRA BLVD 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9672 114137 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1200X JUNIPERO SERRA BLVD 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9686 173637 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1155 Market St 99 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
9904 61559 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1096 Carolina St 1 Median : Cutout 11 Tree 1 DPW 2   08/25/1984 12:00:00 AM 16   Permit Number 21519 6012461.11053783 2102868.78681941 37.75477878641421 -122.399837764002 (37.7547787864142, -122.399837764002)
9922 173745 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 500X Grand View Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6000114.0 2102099.0 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417)
9930 173744 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500X Grand View Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000114.0 2102099.0 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417)
9932 173746 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 500X Grand View Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6000114.0 2102099.0 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417)
10919 19986 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY46 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 40            
11206 20301 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 50X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
11841 19663 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY5 62 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60ST            
11943 19664 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY5 63 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60ST            
12961 87019 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 10 Osceola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/2007 12:00:00 AM     Permit Number 49949          
14276 19667 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY5 66 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60ST            
16176 19976 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY45 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 30ST            
16885 19980 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 100 STAIRWAY45 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 30ST            
18019 111271 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 700X BOSWORTH ST 9 Front Yard : Yard 7 Tree 1 DPW 2     42     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
18734 94234 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 1501@Clearfield Sloat Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
20409 4367 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 973 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041)
25615 178137 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 8 : 4 Tree 1 Private 1     5 Width 0ft   5992316.61451 2087859.0919400002 37.712422298533895 -122.46841041712901 (37.7124222985339, -122.468410417129)
25884 186251 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1701 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984830.2927 2103110.5403 37.7538634572036 -122.495409148018 (37.7538634572036, -122.495409148018)
26747 178177 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 167 Vienna St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6004561.94872 2092421.1241099997 37.7256483463685 -122.426411406667 (37.7256483463685, -122.426411406667)
28596 186468 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1601 Sunset Blvd 56 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984781.1405 2103769.7876 37.755670689824704 -122.495627747424 (37.7556706898247, -122.495627747424)
28677 187129 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2600 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 0ft   5985149.8207 2097410.2322 37.738230663406604 -122.493884107972 (37.7382306634066, -122.493884107972)
29067 211025 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 95 : 4 Tree 1 Private 1     6 Width 0ft   5991234.71561 2092082.53367 37.723956281843705 -122.472457461651 (37.7239562818437, -122.472457461651)
29859 178135 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 6 : 4 Tree 1 Private 1     5 Width 0ft   5992385.6999699995 2087851.7958799999 37.7124062555186 -122.46817110840401 (37.7124062555186, -122.468171108404)
30200 185930 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2000 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985039.332 2101497.8374 37.7494476553955 -122.494567371863 (37.7494476553955, -122.494567371863)
33005 211017 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 49 : 4 Tree 1 Private 1     5 Width 0ft   5991258.9422 2092457.39845 37.724986969654495 -122.47240103009399 (37.7249869696545, -122.472401030094)
33800 178161 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 16 : 4 Tree 1 Private 1     6 Width 0ft   5993106.56964 2087853.50799 37.7124525633948 -122.46567970845899 (37.7124525633948, -122.465679708459)
33946 211008 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 700x Bosworth St 2 Median : Yard 3 Tree 1 DPW 2     33 Width 10ft   6002060.330030001 2095430.49234 37.7337696552405 -122.435274449372 (37.7337696552405, -122.435274449372)
34685 200547 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 23 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6016201.7309 2095635.0286 37.7351242000527 -122.386397222999 (37.7351242000527, -122.386397222999)
35161 211021 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 78 : 4 Tree 1 Private 1     6 Width 0ft   5991241.40021 2092233.4270099998 37.7243709844069 -122.472445349599 (37.7243709844069, -122.472445349599)
35365 186855 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2700 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985186.2801 2096278.9071 37.735126479902895 -122.49367471051 (37.7351264799029, -122.49367471051)
36257 186440 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1601 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984767.7413 2103960.7256 37.7561941679911 -122.495688168642 (37.7561941679911, -122.495688168642)
36495 178150 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 21 : 4 Tree 1 Private 1     4 Width 0ft   5991622.99627 2087995.81221 37.71275761073721 -122.47081770347401 (37.7127576107372, -122.470817703474)
37001 185960 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2001 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984855.8243 2101346.8117 37.7490222380818 -122.49519080130301 (37.7490222380818, -122.495190801303)
37263 185562 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2201 Sunset Blvd 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984881.299 2099768.8111 37.7446909699364 -122.494986371806 (37.7446909699364, -122.494986371806)
37669 211009 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 25 : 4 Tree 1 Private 1     4 Width 0ft   5991341.559830001 2093667.8062200001 37.728315229259 -122.472203623507 (37.728315229259, -122.472203623507)
38117 185308 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2601 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985001.1798 2097292.5499 37.737898841519105 -122.494389354717 (37.7378988415191, -122.494389354717)
38392 178159 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 14 : 4 Tree 1 Private 1     5 Width 0ft   5993218.97583 2087844.63687 37.7124346884772 -122.465290557432 (37.7124346884772, -122.465290557432)
39074 186875 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2700 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985206.2214 2096387.7822 37.7354265885186 -122.493613787113 (37.7354265885186, -122.493613787113)
39138 234477 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Grand View Ave 4 Front Yard : Yard 7 Tree 1 Private 1     3     5999979.4834199995 2101750.0189 37.751003181959895 -122.442922193204 (37.7510031819599, -122.442922193204)
39232 132164 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 150 Lombard St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   6011515.19186 2120799.8495099996 37.8039605395195 -122.404371067467 (37.8039605395195, -122.404371067467)
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)
40640 178151 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 4 : 4 Tree 1 Private 1     3 Width 0ft   5993597.52442 2087641.3827799999 37.7118984245322 -122.46396744335199 (37.7118984245322, -122.463967443352)
40730 178130 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 1 : 4 Tree 1 Private 1     7 Width 0ft   5992655.54446 2087848.4586 37.7124126730818 -122.4672382093 (37.7124126730818, -122.4672382093)
41068 211024 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 94 : 4 Tree 1 Private 1     6 Width 0ft   5991236.61569 2092101.4351299999 37.7240082905392 -122.472452270761 (37.7240082905392, -122.472452270761)
41214 211038 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 52 Burnside Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     36     6001171.81546 2095754.02956 37.7346075158123 -122.43836947339199 (37.7346075158123, -122.438369473392)
44219 186081 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1901 Sunset Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984821.8866 2101948.8735 37.7506733477582 -122.49535255189899 (37.7506733477582, -122.495352551899)
44224 186691 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1401 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984728.0673 2105259.502 37.7597579231437 -122.49592118002701 (37.7597579231437, -122.495921180027)
44889 178131 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 2 : 4 Tree 1 Private 1     5 Width 0ft   5992618.59421 2087849.2354599999 37.7124126730667 -122.46736597596501 (37.7124126730667, -122.467365975965)
44904 211027 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 700 Junipero Serra Blvd 157 : 4 Tree 1 Private 1     4 Width 0ft   5991179.7136 2091396.7999900002 37.7220702434165 -122.47259762098 (37.7220702434165, -122.47259762098)
44978 211007 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 600x Bosworth St 8 Median : Yard 3 Tree 1 DPW 2     26 Width 10ft   6002197.80666 2095393.39137 37.7336755906519 -122.43479650017001 (37.7336755906519, -122.43479650017)
45126 200542 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 18 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6016191.4179 2095647.8311 37.735158782265394 -122.38643377144 (37.7351587822654, -122.38643377144)
45298 186040 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1900 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985014.7934 2102133.6877 37.7511920899125 -122.49469909773998 (37.7511920899125, -122.49469909774)
45572 200536 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 12 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6016175.6148 2095666.5235 37.7352092330314 -122.38648971191002 (37.7352092330314, -122.38648971191)
46130 132162 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 165 Francisco St 11 Front Yard : Yard 7 Tree 1 Private 1     13     6010559.73859 2121313.26508 37.8053168133783 -122.40771371440901 (37.8053168133783, -122.407713714409)
47480 194424 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 5ft   6007931.050980001 2109095.29996 37.77162176316789 -122.41594490245599 (37.7716217631679, -122.415944902456)
49925 186380 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1801 Sunset Blvd 47 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984843.2782 2102467.9478 37.7520998356184 -122.495316855331 (37.7520998356184, -122.495316855331)
50141 178167 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 22 : 4 Tree 1 Private 1     5 Width 0ft   5992858.09731 2087851.4953400001 37.7124327018762 -122.466538351485 (37.7124327018762, -122.466538351485)
50188 178142 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 13 : 4 Tree 1 Private 1     5 Width 0ft   5991993.89623 2087943.0111099998 37.7126340744777 -122.469531924782 (37.7126340744777, -122.469531924782)
50501 211031 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2375 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   5992617.61467 2099318.2887 37.743903802420505 -122.468203163863 (37.7439038024205, -122.468203163863)
50538 211012 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 35 : 4 Tree 1 Private 1     3 Width 0ft   5991334.380059999 2093575.3838 37.7280610448729 -122.47222170976102 (37.7280610448729, -122.472221709761)
52015 200528 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 4 Median : Cutout 11 Tree 1 DPW 2     19 Width 0ft   6016143.3115 2095696.7293 37.7352903838014 -122.38660350279801 (37.7352903838014, -122.386603502798)
52632 178132 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 20 Brotherhood Way 3 : 4 Tree 1 Private 1     6 Width 0ft   5992585.12632 2087848.18621 37.7124078599039 -122.467481573927 (37.7124078599039, -122.467481573927)
53065 200527 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1400x La Salle Ave 3 Median : Cutout 11 Tree 1 DPW 2     15 Width 0ft   6016132.8234 2095707.6369 37.7353197532414 -122.386640524716 (37.7353197532414, -122.386640524716)
53718 187133 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2600 Sunset Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985163.4571 2097445.4987 37.738328293602294 -122.493839558913 (37.7383282936023, -122.493839558913)
54231 181385 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 1500 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984917.5854 2104501.8427 37.7576886993488 -122.495209866912 (37.7576886993488, -122.495209866912)

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