Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by qSiteInfo 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
110409 110409 98703 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 7070@ 32nd Ave California St 4 Front Yard : 25 Tree 1 Private 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
43379 43379 223787 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 4404 20th St 9 : Yard 23 Tree 1 Private 1     44 Width 3ft   6003650.35726 2104229.2336 37.75801912330729 -122.430404821951 (37.7580191233073, -122.430404821951)
45680 45680 176101 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 491 La Grande Ave 3 : Yard 23 Tree 1 Private 1     26     6004411.36222 2089192.97967 37.716776055035794 -122.426702192554 (37.7167760550358, -122.426702192554)
108835 108835 113062 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2X Cranleigh Dr 3 : Yard 23 Tree 1 DPW 2   08/18/2016 09:59:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
119367 119367 113063 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2X Cranleigh Dr 4 : Yard 23 Tree 1 DPW 2   08/18/2016 09:56:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
122547 122547 176099 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 491 La Grande Ave 1 : Yard 23 Tree 1 Private 1     43     6004400.9540099995 2089156.27858 37.716674693347 -122.42673555649999 (37.716674693347, -122.4267355565)
130707 130707 190965 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 24th St 17 : Yard 23 Tree 1 Private 1     6     6017293.94065 2102634.4333599997 37.754403540203796 -122.38310803210899 (37.7544035402038, -122.383108032109)
162701 162701 176100 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 491 La Grande Ave 2 : Yard 23 Tree 1 Private 1     19     6004405.409030001 2089175.08917 37.7167265950249 -122.42672149649799 (37.7167265950249, -122.426721496498)
24212 24212 181351 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 5 unknown : Yard 19 Tree 1 Private 1     32 Width 0ft   5985090.6387 2098949.4558 37.7424534945744 -122.49420214621 (37.7424534945744, -122.49420214621)
24279 24279 138266 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2600 GEARY BLVD 34 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5999024.6838 2113178.2607 37.7823277718518 -122.44704630425699 (37.7823277718518, -122.447046304257)
25247 25247 185431 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 47 unknown : Yard 19 Tree 1 Private 1     40 Width 0ft   5985098.6365 2099386.335 37.743653514796705 -122.49420668637899 (37.7436535147967, -122.494206686379)
27191 27191 186631 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 7 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980860.0426 2105683.7293 37.7606954284135 -122.50933003298901 (37.7606954284135, -122.509330032989)
29764 29764 185497 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 51 unknown : Yard 19 Tree 1 Private 1     33 Width 0ft   5985111.7766 2098651.8474 37.7416375791026 -122.494107128969 (37.7416375791026, -122.494107128969)
34013 34013 185453 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 3 unknown : Yard 19 Tree 1 Private 1     32 Width 0ft   5985125.7214 2098256.744 37.740553547520705 -122.494029800854 (37.7405535475207, -122.494029800854)
34361 34361 185493 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 46 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5985113.7687 2098601.3804 37.741499126889295 -122.49409652237499 (37.7414991268893, -122.494096522375)
34443 34443 186561 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 32 unknown : Yard 19 Tree 1 Private 1     85 Width 0ft   5984740.943 2104715.6846 37.758265506246296 -122.495836533834 (37.7582655062463, -122.495836533834)
34689 34689 186540 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 11 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984760.5184 2104876.1604 37.7587072745291 -122.49578067192199 (37.7587072745291, -122.495780671922)
37856 37856 185490 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 43 unknown : Yard 19 Tree 1 Private 1     18 Width 0ft   5985127.7135 2098570.8346 37.741416072315204 -122.49404605602501 (37.7414160723152, -122.494046056025)
38172 38172 185416 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 32 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5985081.6412 2099232.3776 37.743229794878296 -122.49425410551599 (37.7432297948783, -122.494254105516)
38441 38441 185474 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 26 unknown : Yard 19 Tree 1 Private 1     27 Width 0ft   5985113.1047 2098438.0268 37.7410505630538 -122.494086781525 (37.7410505630538, -122.494086781525)
39570 39570 186559 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 30 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984761.8792 2104726.5714 37.7582966244824 -122.495764931436 (37.7582966244824, -122.495764931436)
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)
45810 45810 185494 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 47 unknown : Yard 19 Tree 1 Private 1     25 Width 0ft   5985136.346 2098616.6534 37.74154238350489 -122.494019584309 (37.7415423835049, -122.494019584309)
53374 53374 185417 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 33 unknown : Yard 19 Tree 1 Private 1     24 Width 0ft   5985081.6412 2099246.8736 37.7432695969748 -122.49425517376801 (37.7432695969748, -122.494255173768)
57083 57083 185434 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     20 Width 0ft   5985080.6415 2099410.3284 37.7437183411386 -122.494270675975 (37.7437183411386, -122.494270675975)
62482 62482 185414 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 30 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985079.1419 2099209.8838 37.743167886728 -122.494261089675 (37.743167886728, -122.494261089675)
64027 64027 186552 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 23 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984760.623 2104776.3995 37.758433365006105 -122.49577295137699 (37.7584333650061, -122.495772951377)
66692 66692 185457 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 7 unknown : Yard 19 Tree 1 Private 1     13 Width 0ft   5985129.0416 2098307.8751 37.740694134038 -122.494022088477 (37.740694134038, -122.494022088477)
68374 68374 185458 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 8 unknown : Yard 19 Tree 1 Private 1     22 Width 0ft   5985125.7214 2098330.4524 37.7407559309555 -122.49403523184401 (37.7407559309555, -122.494035231844)
73057 73057 185408 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 23 unknown : Yard 19 Tree 1 Private 1     10 Width 0ft   5985102.6354 2099127.4066 37.742942801420796 -122.49417377884599 (37.7429428014208, -122.494173778846)
73687 73687 186630 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 6 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980860.7453 2105672.8381 37.7606655657469 -122.50932679385099 (37.7606655657469, -122.509326793851)
76180 76180 185454 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 4 unknown : Yard 19 Tree 1 Private 1     25 Width 0ft   5985131.0337 2098272.681 37.7405976170701 -122.494012607503 (37.7405976170701, -122.494012607503)
132337 132337 186535 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 6 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984732.8826 2104894.5843 37.7587562429314 -122.495877606831 (37.7587562429314, -122.495877606831)
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)
134264 134264 185433 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 49 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985073.6434 2099396.3323 37.7436795021074 -122.49429384193199 (37.7436795021074, -122.494293841932)
136486 136486 186550 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 21 unknown : Yard 19 Tree 1 Private 1     42 Width 0ft   5984736.7558 2104791.4736 37.7584733565115 -122.49585660551 (37.7584733565115, -122.49585660551)
137771 137771 181360 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 49 unknown : Yard 19 Tree 1 Private 1     47 Width 0ft   5985113.1047 2098629.2701 37.7415756656355 -122.494100873291 (37.7415756656355, -122.494100873291)
150480 150480 186577 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 48 unknown : Yard 19 Tree 1 Private 1     29 Width 0ft   5984764.3916 2104600.9543 37.75795186201471 -122.495746976697 (37.7579518620147, -122.495746976697)
153024 153024 186626 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 2 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313)
155462 155462 186632 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 8 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980861.0966 2105687.2426 37.7607051370684 -122.509326648666 (37.7607051370684, -122.509326648666)
157058 157058 185451 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 1 unknown : Yard 19 Tree 1 Private 1     30 Width 0ft   5985130.3697 2098228.1903 37.740475418723506 -122.49401162519399 (37.7404754187235, -122.494011625194)
166154 166154 186488 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Lower Great Hwy 34 unknown : Yard 19 Tree 1 Private 1     15 Width 0ft   5980888.4423 2105382.2174 37.7598692379346 -122.50920942183998 (37.7598692379346, -122.50920942184)
172365 172365 186543 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 14 unknown : Yard 19 Tree 1 Private 1     21 Width 0ft   5984724.0894 2104873.2294 37.7586970933352 -122.495906441969 (37.7586970933352, -122.495906441969)
172640 172640 185503 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 57 unknown : Yard 19 Tree 1 Private 1     40 Width 0ft   5985131.0337 2098785.3193 37.7420051837622 -122.49405038008001 (37.7420051837622, -122.49405038008)
172749 172749 186574 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 45 unknown : Yard 19 Tree 1 Private 1     46 Width 0ft   5984720.0068 2104642.8266 37.7580642323025 -122.495903564638 (37.7580642323025, -122.495903564638)
174389 174389 186633 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 9 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980876.555 2105686.5399 37.760704119089 -122.509273133786 (37.760704119089, -122.509273133786)
175132 175132 185488 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 41 unknown : Yard 19 Tree 1 Private 1     27 Width 0ft   5985122.4012 2098536.3046 37.741320951397704 -122.494061879541 (37.7413209513977, -122.494061879541)
178107 178107 186569 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 40 unknown : Yard 19 Tree 1 Private 1     26 Width 0ft   5984763.5541 2104672.9747 37.7581495609485 -122.49575518551701 (37.7581495609485, -122.495755185517)
178149 178149 181354 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 19 unknown : Yard 19 Tree 1 Private 1     25 Width 0ft   5985076.1427 2099074.9211 37.742797140118796 -122.494261514147 (37.7427971401188, -122.494261514147)
178921 178921 186554 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 25 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5984714.9821 2104746.2514 37.7583479137241 -122.495928571528 (37.7583479137241, -122.495928571528)
179607 179607 185430 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 46 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985106.6343 2099374.8382 37.7436224157034 -122.49417818512899 (37.7436224157034, -122.494178185129)
181515 181515 185432 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 48 unknown : Yard 19 Tree 1 Private 1     28 Width 0ft   5985081.6412 2099386.335 37.7436525202566 -122.49426545113899 (37.7436525202566, -122.494265451139)
183931 183931 185393 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 6 unknown : Yard 19 Tree 1 Private 1     30 Width 0ft   5985089.6389999995 2098965.9512 37.742498727988895 -122.49420681837499 (37.7424987279889, -122.494206818375)
185674 185674 185392 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 3 unknown : Yard 19 Tree 1 Private 1     38 Width 0ft   5985108.1339 2098944.4572 37.7424407935289 -122.494141285581 (37.7424407935289, -122.494141285581)
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)
3361 3361 253428 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3 Valletta Ct 1 Side Yard : Cutout 18 Tree 1 Private 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
10134 10134 173877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2651 San Jose Ave 1 Side Yard : Cutout 18 Tree 1 Private 1       3x3   5997397.0 2088796.0 37.7152869722449 -122.450918658158 (37.7152869722449, -122.450918658158)
1875 1875 251783 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 610 Clipper St 5 Side Yard : Yard 17 Tree 1 DPW 2       Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672)
9916 9916 173733 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 14 Richland Ave 1 Side Yard : Yard 17 Tree 1 DPW 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
13271 13271 187638 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 875 El Camino Del Mar 2 Side Yard : Yard 17 Tree 1 Private 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 13275 187637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 875 El Camino Del Mar 1 Side Yard : Yard 17 Tree 1 Private 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
30768 30768 223720 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Crescent Ave 3 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196)
34240 34240 247903 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 582 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     31     6009830.823 2098729.7061900003 37.743266798225605 -122.40864208815701 (37.7432667982256, -122.408642088157)
35115 35115 126414 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2836 Larkin St 10 Side Yard : Yard 17 Tree 1 Private 1     12     6006501.05561 2120998.5397099997 37.804224619123296 -122.421736962694 (37.8042246191233, -122.421736962694)
35448 35448 176098 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 184 Mount Vernon Ave 8 Side Yard : Yard 17 Tree 1 Private 1     6     5998949.65718 2089392.42013 37.717013369950706 -122.44559487852699 (37.7170133699507, -122.445594878527)
38454 38454 249866 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1497 Montgomery St 2 Side Yard : Yard 17 Tree 1 Private 1     20 Width 0ft   6011357.005059999 2120690.5710400003 37.8036516466761 -122.404910787509 (37.8036516466761, -122.404910787509)
44565 44565 201717 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 2 Side Yard : Yard 17 Tree 1 Private 1     24     6017089.1408 2095350.86435 37.7343930239173 -122.38330932287201 (37.7343930239173, -122.383309322872)
46469 46469 250199 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 201 Union St 5 Side Yard : Yard 17 Tree 1 Private 1     15 Width 0ft   6011821.07725 2119768.34547 37.8011453692141 -122.403239919993 (37.8011453692141, -122.403239919993)
51235 51235 201716 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 1 Side Yard : Yard 17 Tree 1 Private 1     17     6017085.9132900005 2095352.6498 37.7343977480421 -122.38332060578001 (37.7343977480421, -122.38332060578)
53056 53056 248184 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 216 Esmeralda Ave 3 Side Yard : Yard 17 Tree 1 Private 1     28     6007432.5204300005 2098714.89498 37.7430915158666 -122.416933765486 (37.7430915158666, -122.416933765486)
55847 55847 201720 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 5 Side Yard : Yard 17 Tree 1 Private 1     17     6017109.38533 2095355.2358400002 37.734406145933704 -122.383239634411 (37.7344061459337, -122.383239634411)
58146 58146 201718 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 3 Side Yard : Yard 17 Tree 1 Private 1     14     6017093.28201 2095356.3247099998 37.7344082458391 -122.38329538517401 (37.7344082458391, -122.383295385174)
59780 59780 126415 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2836 Larkin St 11 Side Yard : Yard 17 Tree 1 Private 1     48     6006502.51226 2121001.4648 37.804232732814704 -122.421732129727 (37.8042327328147, -122.421732129727)
60552 60552 250197 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 201 Union St 3 Side Yard : Yard 17 Tree 1 Private 1     14 Width 0ft   6011839.72623 2119769.92251 37.8011507408769 -122.403175497057 (37.8011507408769, -122.403175497057)
65706 65706 201723 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 6 Side Yard : Yard 17 Tree 1 Private 1     10     6017160.60225 2095378.34378 37.734472425960895 -122.383064166774 (37.7344724259609, -122.383064166774)
65775 65775 176097 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 184 Mount Vernon Ave 6 Side Yard : Yard 17 Tree 1 Private 1     12     5998962.663240001 2089377.08137 37.716971995749795 -122.445548820645 (37.7169719957498, -122.445548820645)
66895 66895 176112 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 35 Tomaso Ct 4 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6009187.4096 2086275.4475900002 37.7090339795175 -122.409987838189 (37.7090339795175, -122.409987838189)
67552 67552 223719 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Crescent Ave 4 Side Yard : Yard 17 Tree 1 Private 1     6 Width 3ft   6005300.64092 2095902.62438 37.735249504969104 -122.424105284154 (37.7352495049691, -122.424105284154)
69463 69463 205919 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 230 Edna St 2 Side Yard : Yard 17 Tree 1 Private 1     34     5998797.1475 2095343.94395 37.7333461617934 -122.44654997291599 (37.7333461617934, -122.446549972916)
75219 75219 176164 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 654 Peru Ave 2 Side Yard : Yard 17 Tree 1 Private 1     33     6005136.16004 2092540.09119 37.7260074465758 -122.42443486048201 (37.7260074465758, -122.424434860482)
135623 135623 247911 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 399 Franconia St 2 Side Yard : Yard 17 Tree 1 Private 1     39     6009944.29918 2098783.53182 37.7434209465163 -122.408253510886 (37.7434209465163, -122.408253510886)
136128 136128 218153 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 22 Ashton Ave 1 Side Yard : Yard 17 Tree 1 Private 1     20     5994153.71185 2090014.1877400002 37.7184456203604 -122.46221709555 (37.7184456203604, -122.46221709555)
146514 146514 201719 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 4 Side Yard : Yard 17 Tree 1 Private 1     15     6017095.79964 2095357.4210400002 37.7344113952763 -122.38328675710501 (37.7344113952763, -122.383286757105)
152144 152144 223808 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 6 Miguel St 1 Side Yard : Yard 17 Tree 1 Private 1     37     6003326.01138 2097344.7820099997 37.739097652747205 -122.431035195413 (37.7390976527472, -122.431035195413)
156317 156317 250196 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 201 Union St 2 Side Yard : Yard 17 Tree 1 Private 1     18 Width 0ft   6011857.70339 2119785.90004 37.801195615236395 -122.403114412425 (37.8011956152364, -122.403114412425)
158925 158925 248059 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 18 Rutledge St 1 Side Yard : Yard 17 Tree 1 Private 1     41     6010698.28988 2099365.5413599997 37.7450612101031 -122.40568737459299 (37.7450612101031, -122.405687374593)
166544 166544 176163 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 654 Peru Ave 1 Side Yard : Yard 17 Tree 1 Private 1     23     6005125.75661 2092550.7271200002 37.726036063007705 -122.42447158070601 (37.7260360630077, -122.424471580706)
167034 167034 176166 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 654 Peru Ave 4 Side Yard : Yard 17 Tree 1 Private 1     30     6005147.67241 2092530.2100099998 37.7259809651314 -122.424394360408 (37.7259809651314, -122.424394360408)
167728 167728 201724 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Hawkins Ln 7 Side Yard : Yard 17 Tree 1 Private 1     28     6017165.24184 2095383.9343 37.7344880327856 -122.383048514986 (37.7344880327856, -122.383048514986)
171449 171449 249865 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1497 Montgomery St 1 Side Yard : Yard 17 Tree 1 Private 1     24 Width 0ft   6011350.601919999 2120707.91777 37.8036989186248 -122.404934168095 (37.8036989186248, -122.404934168095)
179538 179538 176165 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 654 Peru Ave 3 Side Yard : Yard 17 Tree 1 Private 1     27     6005141.81262 2092533.90812 37.7259907884276 -122.42441488026199 (37.7259907884276, -122.424414880262)
180895 180895 176096 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 184 Mount Vernon Ave 5 Side Yard : Yard 17 Tree 1 Private 1     15     5998966.43073 2089373.6298 37.7169627336137 -122.445535550248 (37.7169627336137, -122.445535550248)
181873 181873 250227 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 312 Filbert St 7 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6011220.88869 2120048.61475 37.8018813824768 -122.40533659221902 (37.8018813824768, -122.405336592219)
184674 184674 126416 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2836 Larkin St 12 Side Yard : Yard 17 Tree 1 Private 1     46     6006501.512069999 2121012.26216 37.804262323204895 -122.421736358356 (37.8042623232049, -122.421736358356)
186272 186272 223809 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 6 Miguel St 2 Side Yard : Yard 17 Tree 1 Private 1     34     6003330.909440001 2097346.2966299998 37.7391020890899 -122.431018368229 (37.7391020890899, -122.431018368229)
186554 186554 250195 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 201 Union St 1 Side Yard : Yard 17 Tree 1 Private 1     18 Width 0ft   6011875.28376 2119779.56963 37.8011792152183 -122.40305313080401 (37.8011792152183, -122.403053130804)
2764 2764 253207 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 89 Woodhaven Ct 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5996069.0 2103645.0 37.75598259914371 -122.45658197288401 (37.7559825991437, -122.456581972884)
110956 110956 118356 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 100 RACCOON DR 2 Back Yard : Cutout 16 Tree 1 Private 1     48     5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
112771 112771 109706 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 96 CRESTA VISTA DR   Back Yard : Cutout 16 Tree 1 Private 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
117016 117016 110120 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 507X JOOST AVE 2 Back Yard : Cutout 16 Tree 1 Private 1     45 3x3   5998608.0 2094933.0 37.7322070010706 -122.44717434081801 (37.7322070010706, -122.447174340818)

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