Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
155655 155655 206871 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 167 : 4 Tree 1 Private 1     28 Width 0ft   5991178.39011 2091334.0196900002 37.721897787630404 -122.472597620991 (37.7218977876304, -122.472597620991)
176049 176049 206870 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 153 : 4 Tree 1 Private 1     16 Width 0ft   5991175.977080001 2091433.26758 37.7221701581122 -122.47261319456699 (37.7221701581122, -122.472613194567)
73599 73599 206869 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 147 : 4 Tree 1 Private 1     26 Width 0ft   5991181.8353699995 2091497.44747 37.722346719311396 -122.472597620994 (37.7223467193114, -122.472597620994)
147332 147332 206868 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 142 : 4 Tree 1 Private 1     24 Width 0ft   5991190.247819999 2091564.0657099998 37.7225301234522 -122.472573395965 (37.7225301234522, -122.472573395965)
53576 53576 206867 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 134 : 4 Tree 1 Private 1     5 Width 0ft   5991202.1664 2091654.5365900001 37.7227792239685 -122.47253878915501 (37.7227792239685, -122.472538789155)
35459 35459 206866 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 132 : 4 Tree 1 Private 1     28 Width 0ft   5991206.46725 2091692.32993 37.7228832440624 -122.472526676182 (37.7228832440624, -122.472526676182)
185468 185468 206865 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 129 : 4 Tree 1 Private 1     25 Width 0ft   5991211.79314 2091726.01373 37.722976039705 -122.472510720395 (37.722976039705, -122.472510720395)
186983 186983 206877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 112 : 4 Tree 1 Private 1     24 Width 0ft   5991127.9538900005 2090310.3975099998 37.7190842541173 -122.472697367507 (37.7190842541173, -122.472697367507)
55517 55517 206864 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 108 : 4 Tree 1 Private 1     16 Width 0ft   5991230.74264 2091941.55129 37.7235689492395 -122.472460922234 (37.7235689492395, -122.472460922234)
43611 43611 206876 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 107 : 4 Tree 1 Private 1     15 Width 0ft   5991129.63237 2090361.82623 37.7192255618863 -122.472695313452 (37.7192255618863, -122.472695313452)
52900 52900 206875 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 102 : 4 Tree 1 Private 1     26 Width 0ft   5991134.69079 2090432.70427 37.71942046834911 -122.472682993629 (37.7194204683491, -122.472682993629)
155354 155354 206863 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 101 : 4 Tree 1 Private 1     16 Width 0ft   5991231.24746 2092036.74802 37.723830365071 -122.47246611402599 (37.723830365071, -122.472466114026)
42516 42516 184094 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 97 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984942.4654 2104248.1437 37.756993568912705 -122.49510511552201 (37.7569935689127, -122.495105115522)
62264 62264 206862 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 97 : 4 Tree 1 Private 1     16 Width 0ft   5991236.44384 2092069.53712 37.7239206965711 -122.47245054045601 (37.7239206965711, -122.472450540456)
45664 45664 184092 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 95 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 0ft   5984922.9495 2104224.59 37.756927754428894 -122.49517087102 (37.7569277544289, -122.49517087102)
74617 74617 206861 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 89 : 4 Tree 1 Private 1     15 Width 0ft   5991235.1013400005 2092148.3228200001 37.7241369448505 -122.47246092223 (37.7241369448505, -122.47246092223)
152873 152873 184088 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 89 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52 Width 0ft   5984924.9202 2104112.1254 37.756619073195 -122.49515576258999 (37.756619073195, -122.49515576259)
148491 148491 186615 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984738.326 2104396.7218 37.7573895698596 -122.495822055914 (37.7573895698596, -122.495822055914)
151754 151754 185361 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     72 Width 0ft   5985015.9398 2096870.9998 37.7367422415889 -122.49430725909599 (37.7367422415889, -122.494307259096)
162350 162350 185359 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 84 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 0ft   5984996.2598 2096910.7786 37.7368503118256 -122.49437823177 (37.7368503118256, -122.49437823177)
36628 36628 186839 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1200 Sunset Blvd 83 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984830.1212 2106502.1656 37.7631759062792 -122.49565989156099 (37.7631759062792, -122.495659891561)
30126 30126 223714 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1201 San Jose Ave 82 Front Yard : Yard 7 Tree 1 Private 1     34     6004606.42672 2096213.68372 37.736064383369396 -122.42652758019699 (37.7360643833694, -122.426527580197)
77269 77269 223713 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1201 San Jose Ave 81 Front Yard : Yard 7 Tree 1 Private 1     52     6004590.4575 2096203.6023099998 37.7360357993049 -122.426582074619 (37.7360357993049, -122.426582074619)
152844 152844 223706 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 80 Front Yard : Yard 7 Tree 1 Private 1     4     6004536.52923 2096375.8684900003 37.736505754442504 -122.42678079059999 (37.7365057544425, -122.4267807906)
159756 159756 206860 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 79 : 4 Tree 1 Private 1     14 Width 0ft   5991226.76432 2092227.75414 37.72435456098721 -122.472495529949 (37.7243545609872, -122.472495529949)
181738 181738 223705 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 79 Front Yard : Yard 7 Tree 1 Private 1     50     6004537.44257 2096386.8120900001 37.7365358547364 -122.426778411906 (37.7365358547364, -122.426778411906)
137317 137317 223704 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 78 Front Yard : Yard 7 Tree 1 Private 1     40     6004560.21701 2096406.8969299998 37.7365922907993 -122.426701100777 (37.7365922907993, -122.426701100777)
174966 174966 185935 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2000 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985034.4441 2101527.1648 37.7495278943342 -122.494586435864 (37.7495278943342, -122.494586435864)
183983 183983 186607 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984762.1933 2104423.9388 37.757465697935096 -122.495741522143 (37.7574656979351, -122.495741522143)
25632 25632 185934 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2000 Sunset Blvd 77 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 0ft   5984996.9702 2101528.251 37.74952868337 -122.494716099913 (37.74952868337, -122.494716099913)
49562 49562 223703 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 77 Front Yard : Yard 7 Tree 1 Private 1     18     6004573.37155 2096423.41392 37.7366383864359 -122.426656795699 (37.7366383864359, -122.426656795699)
46179 46179 187390 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2200 Sunset Blvd 76 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985059.3798 2100173.7118 37.745813140708705 -122.494400453146 (37.7458131407087, -122.494400453146)
148122 148122 187057 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 76 Sidewalk: Property side : Yard 9 Tree 1 Private 1     40 Width 0ft   5985000.5625 2097579.1506 37.738685734046996 -122.49441260957799 (37.738685734047, -122.494412609578)
159461 159461 223702 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 76 Front Yard : Yard 7 Tree 1 Private 1     26     6004596.80195 2096429.4382 37.7366562523786 -122.426576215516 (37.7366562523786, -122.426576215516)
53546 53546 223712 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1201 San Jose Ave 75 Front Yard : Yard 7 Tree 1 Private 1     59     6004557.86024 2096180.22234 37.7359697602838 -122.426693112116 (37.7359697602838, -122.426693112116)
133450 133450 187389 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2200 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44 Width 0ft   5985060.734 2100148.3209 37.745743503446704 -122.49439389926 (37.7457435034467, -122.49439389926)
63714 63714 181514 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 0ft   5984875.8554 2105578.3775 37.7606421208046 -122.49543357949301 (37.7606421208046, -122.495433579493)
72988 72988 184885 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1201 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5984635.3908 2106778.1095 37.763922165271104 -122.496353750703 (37.7639221652711, -122.496353750703)
29359 29359 181512 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984867.501 2105563.3396 37.760600341747896 -122.495461364037 (37.7606003417479, -122.495461364037)
157774 157774 187386 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2200 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985083.4165 2100125.6383 37.745682550612 -122.494313795975 (37.745682550612, -122.494313795975)
175582 175582 187210 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     40 Width 0ft   5984940.3895 2098925.3948 37.742378636211 -122.494719881886 (37.742378636211, -122.494719881886)
27053 27053 187052 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     40 Width 0ft   5984975.6777 2097633.6281 37.7388338582522 -122.494502663013 (37.7388338582522, -122.494502663013)
182159 182159 181511 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 0ft   5984874.1846 2105548.3017 37.7605594432249 -122.495437139743 (37.7605594432249, -122.495437139743)
43604 43604 206874 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 70 : 4 Tree 1 Private 1     20 Width 0ft   5991143.093090001 2090605.8468900002 37.7198963617096 -122.472666567502 (37.7198963617096, -122.472666567502)
131602 131602 187208 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 70 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 0ft   5984942.9821 2098945.7652 37.74243471957521 -122.494712419071 (37.7424347195752, -122.494712419071)
23770 23770 186402 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984820.6527 2102319.266 37.7516902715465 -122.495384132242 (37.7516902715465, -122.495384132242)
46072 46072 187207 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     49 Width 0ft   5984908.908 2098929.8392 37.742388996582996 -122.494829061404 (37.742388996583, -122.494829061404)
163323 163323 181509 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984883.3744 2105527.9727 37.7605041635582 -122.495403857574 (37.7605041635582, -122.495403857574)
54018 54018 187206 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     54 Width 0ft   5984916.3154 2098953.9133 37.7424555311495 -122.49480522378599 (37.7424555311495, -122.494805223786)
62342 62342 206859 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 68 : 4 Tree 1 Private 1     22 Width 0ft   5991233.44826 2092307.36701 37.724573545027205 -122.472478226105 (37.7245735450272, -122.472478226105)
149337 149337 187382 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2200 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 0ft   5985066.1507 2100087.3826 37.7455765004249 -122.494370678244 (37.7455765004249, -122.494370678244)
149399 149399 181508 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5984873.9061 2105511.8209 37.760459260826295 -122.495435412339 (37.7604592608263, -122.495435412339)
165444 165444 186919 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2700 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985188.342999999 2096744.4340000001 37.7364048133414 -122.493701871188 (37.7364048133414, -122.493701871188)
60814 60814 186596 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     67 Width 0ft   5984749.6315 2104462.0427 37.757569584992396 -122.495787775902 (37.7575695849924, -122.495787775902)
77263 77263 185735 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     71 Width 0ft   5984891.8172 2100271.961 37.7460730985326 -122.49498709535801 (37.7460730985326, -122.494987095358)
147554 147554 181434 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1500 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     63 Width 0ft   5984896.7414 2104905.8493 37.758796768768704 -122.495311746922 (37.7587967687687, -122.495311746922)
155847 155847 186256 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984812.6153 2103003.1364 37.7535675206606 -122.49546235883498 (37.7535675206606, -122.495462358835)
186893 186893 187048 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984981.0582 2097651.451 37.738883110049706 -122.494485373526 (37.7388831100497, -122.494485373526)
41093 41093 186399 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 0ft   5984798.0272 2102361.2847 37.7518043185405 -122.495465471731 (37.7518043185405, -122.495465471731)
45321 45321 187047 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984983.7484 2097658.1766 37.738901734187294 -122.49447656785601 (37.7389017341873, -122.494476567856)
55074 55074 185341 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     65 Width 0ft   5984987.4666 2096984.4739 37.7370521447921 -122.49441406407699 (37.7370521447921, -122.494414064077)
62919 62919 206858 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 66 : 4 Tree 1 Private 1     19 Width 0ft   5991244.79193 2092323.0787 37.72461734199471 -122.472440157785 (37.7246173419947, -122.472440157785)
75719 75719 186255 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     56 Width 0ft   5984790.3846 2103043.3124 37.753676531136705 -122.495542199313 (37.7536765311367, -122.495542199313)
122550 122550 181433 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1500 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984928.4881 2104916.9885 37.758829212628996 -122.49520277524401 (37.758829212629, -122.495202775244)
132817 132817 181506 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984860.5391 2105486.2008 37.76038813249 -122.495479752328 (37.76038813249, -122.495479752328)
148866 148866 187204 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 0ft   5984941.871 2098979.0985 37.742526178770795 -122.494718717837 (37.7425261787708, -122.494718717837)
33235 33235 186398 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     48 Width 0ft   5984807.1851 2102369.0959 37.751826302179104 -122.495434378973 (37.7518263021791, -122.495434378973)
178161 178161 186708 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1401 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984718.4366 2105053.49 37.7591917076208 -122.49593928954901 (37.7591917076208, -122.495939289549)
65826 65826 181431 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1500 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984906.2097 2104856.8369 37.758662748720205 -122.495275387185 (37.7586627487202, -122.495275387185)
151740 151740 206857 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 64 : 4 Tree 1 Private 1     17 Width 0ft   5991242.804690001 2092347.545 37.7246844053568 -122.47244881018601 (37.7246844053568, -122.472448810186)
181646 181646 187045 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984969.2884 2097687.4331 37.7389812183872 -122.494528719258 (37.7389812183872, -122.494528719258)
36127 36127 184802 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 0ft   5984710.1955 2105740.9062 37.7610786777919 -122.496018504161 (37.7610786777919, -122.496018504161)
49280 49280 186252 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52 Width 0ft   5984805.3836 2103092.3272 37.753811990528895 -122.49549394498501 (37.7538119905289, -122.495493944985)
55436 55436 185037 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     53 Width 0ft   5985002.122 2096263.6409999998 37.7350737878985 -122.49431027719999 (37.7350737878985, -122.4943102772)
171921 171921 184062 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     55 Width 0ft   5984941.4086 2103928.0299 37.7561145632567 -122.49508516598499 (37.7561145632567, -122.495085165985)
187759 187759 187201 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 0ft   5984911.8709 2099008.3578 37.742604760863294 -122.494824604589 (37.7426047608633, -122.494824604589)
26684 26684 185578 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     80 Width 0ft   5984888.727999999 2099615.9854 37.744271786934796 -122.49494941784201 (37.7442717869348, -122.494949417842)
28368 28368 185036 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984991.2351 2096277.6682 37.7351116657323 -122.494348950198 (37.7351116657323, -122.494348950198)
149828 149828 223773 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 310 Liberty St 62 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6003724.02134 2103929.75159 37.757200989348604 -122.430128695891 (37.7572009893486, -122.430128695891)
155838 155838 181502 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984910.6654 2105475.0616 37.7603604823662 -122.495305569795 (37.7603604823662, -122.495305569795)
172394 172394 185209 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2500 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 0ft   5985139.3342 2098053.216 37.73999551086 -122.493967737883 (37.73999551086, -122.493967737883)
188560 188560 185508 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 62 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5985138.3382 2098803.9124 37.742056662806796 -122.494026493821 (37.7420566628068, -122.494026493821)
134120 134120 185507 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 61 unknown : Yard 19 Tree 1 Private 1     40 Width 0ft   5985116.4249 2098801.2563 37.7420480876484 -122.494102066238 (37.7420480876484, -122.494102066238)
153184 153184 185035 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5985023.8956 2096287.7176 37.7351411700064 -122.49423677323401 (37.7351411700064, -122.494236773234)
186424 186424 184800 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984686.2732 2105775.8403 37.76117319587821 -122.496103817218 (37.7611731958782, -122.496103817218)
187491 187491 185577 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     43 Width 0ft   5984876.2578 2099639.0685 37.7443344368575 -122.4949942382 (37.7443344368575, -122.4949942382)
50391 50391 187198 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     46 Width 0ft   5984955.9451 2099026.506 37.7426571707346 -122.494673548768 (37.7426571707346, -122.494673548768)
58439 58439 185034 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984995.8411 2096292.7423 37.7351533247412 -122.494334136609 (37.7351533247412, -122.494334136609)
158741 158741 186911 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2700 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985189.7183 2096710.0524 37.7363104911026 -122.493694583533 (37.7363104911026, -122.493694583533)
184471 184471 187407 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2100 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985024.7009 2100846.8762 37.747659437344204 -122.49456998306101 (37.7476594373442, -122.494569983061)
35634 35634 187197 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 0ft   5984932.9821 2099043.9135 37.7427036229391 -122.49475423012899 (37.7427036229391, -122.494754230129)
40115 40115 185505 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 59 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5985087.8712 2098781.9991 37.7419935417222 -122.49419937536501 (37.7419935417222, -122.494199375365)
61489 61489 187406 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2100 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985050.9195 2100825.5458 37.7476024043745 -122.494477749786 (37.7476024043745, -122.494477749786)
166767 166767 223718 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1101 San Jose Ave 59 Front Yard : Yard 7 Tree 1 Private 1     4     6005036.8773300005 2096676.581 37.7373597200698 -122.42507226308999 (37.7373597200698, -122.42507226309)
167760 167760 181426 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1500 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984929.045 2104818.9637 37.7585600964022 -122.495193620608 (37.7585600964022, -122.495193620608)
40294 40294 185205 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2500 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     46 Width 0ft   5985139.9982 2098002.749 37.7398569808885 -122.493961723729 (37.7398569808885, -122.493961723729)
70399 70399 185574 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     81 Width 0ft   5984904.9127 2099653.9265 37.744376910333 -122.494896252369 (37.744376910333, -122.494896252369)
76140 76140 186587 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     48 Width 0ft   5984753.4001 2104537.4129 37.75777675130679 -122.495780302321 (37.7577767513068, -122.495780302321)
95338 95338 185440 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     36 Width 0ft   5985079.6418 2099480.3091 37.7439104306977 -122.494279289823 (37.7439104306977, -122.494279289823)
137779 137779 223717 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1101 San Jose Ave 58 Front Yard : Yard 7 Tree 1 Private 1     55     6005027.45143 2096662.24212 37.737319816266705 -122.425103832873 (37.7373198162667, -122.425103832873)

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