Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12088 | 12088 | 108908 | Permitted Site 1 | Ceanothus Sps :: California lilac 270 | 85 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772733 | 5999781.28744 | 2087663.9934900003 | 37.7123149446499 | -122.442596312184 | (37.7123149446499, -122.442596312184) |
| 21750 | 21750 | 26516 | Permitted Site 1 | Ceanothus Sps :: California lilac 270 | 2892 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008953.000080001 | 2101655.65675 | 37.7512516061773 | -122.411884099184 | (37.7512516061773, -122.411884099184) | |||
| 23445 | 23445 | 222731 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1435 Douglass St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6001402.34337 | 2099545.22287 | 37.7450303552734 | -122.437843913168 | (37.7450303552734, -122.437843913168) | |||
| 23496 | 23496 | 222676 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 701 Church St | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6004317.3839 | 2104765.72552 | 37.7595299645462 | -122.428136192139 | (37.7595299645462, -122.428136192139) | |||
| 23504 | 23504 | 222733 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1335 Douglass St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001395.73584 | 2099802.9643099997 | 37.745737676549204 | -122.437885218135 | (37.7457376765492, -122.437885218135) | |||
| 23865 | 23865 | 188421 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 602 Arthur Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015740.2817 | 2099823.35637 | 37.7465989366059 | -122.388284852668 | (37.7465989366059, -122.388284852668) | ||||
| 24095 | 24095 | 204706 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 368 Cresta Vista Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5997198.1227 | 2096218.6359599999 | 37.735656390616995 | -122.45214130629 | (37.735656390617, -122.45214130629) | |||
| 24154 | 24154 | 79962 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2002 12:00:00 AM | 2 | 5991293.33065 | 2110344.2165900003 | 37.774101509723 | -122.47358630593399 | (37.774101509723, -122.473586305934) | ||
| 25049 | 25049 | 117730 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 454 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5983478.41225 | 2112771.8045099997 | 37.780311281435 | -122.500798593525 | (37.780311281435, -122.500798593525) | |||
| 28776 | 28776 | 222722 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 456 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5998557.53354 | 2106542.30606 | 37.764080439692705 | -122.448184452078 | (37.7640804396927, -122.448184452078) | |||
| 31355 | 31355 | 205928 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 201 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5994258.7191699995 | 2098719.4731 | 37.7423542498388 | -122.46248522033501 | (37.7423542498388, -122.462485220335) | |||
| 31610 | 31610 | 204708 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 60 Sequoia Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998200.81211 | 2097480.11593 | 37.7391774990296 | -122.448765470767 | (37.7391774990296, -122.448765470767) | |||
| 34348 | 34348 | 117879 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 600 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5982899.694730001 | 2111629.29997 | 37.777140304321705 | -122.502716018744 | (37.7771403043217, -122.502716018744) | |||
| 37141 | 37141 | 222643 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 2892 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008956.86387 | 2101628.0145900003 | 37.751175923754204 | -122.41186878462099 | (37.7511759237542, -122.411868784621) | |||
| 38209 | 38209 | 222655 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 310 Liberty St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6004252.67601 | 2103946.69939 | 37.7572774515136 | -122.428301610753 | (37.7572774515136, -122.428301610753) | |||
| 38268 | 38268 | 222737 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 840 27th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6001059.80246 | 2099994.7201799997 | 37.7462450839594 | -122.439060564612 | (37.7462450839594, -122.439060564612) | |||
| 39476 | 39476 | 121924 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 634 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990987.34247 | 2111070.84307 | 37.776078902206294 | -122.4746978058 | (37.7760789022063, -122.4746978058) | |||
| 40654 | 40654 | 222653 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 168 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6000185.103019999 | 2104897.86614 | 37.7596581233442 | -122.44243711328501 | (37.7596581233442, -122.442437113285) | |||
| 41026 | 41026 | 222716 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4800 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998213.80869 | 2105679.41887 | 37.761691512976206 | -122.44931111732299 | (37.7616915129762, -122.449311117323) | |||
| 42164 | 42164 | 222712 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1101 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004716.12579 | 2096285.00945 | 37.7362664286601 | -122.426153382197 | (37.7362664286601, -122.426153382197) | ||||
| 43395 | 43395 | 222669 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 740 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003665.94004 | 2103977.3690299997 | 37.757328445773204 | -122.43033296071998 | (37.7573284457732, -122.43033296072) | |||
| 44270 | 44270 | 175819 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 357 Allison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000300.689180001 | 2087012.0311900002 | 37.7105543958389 | -122.440754372043 | (37.7105543958389, -122.440754372043) | |||
| 44764 | 44764 | 205937 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 50 Circular Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000127.5419 | 2093913.2935099998 | 37.7294938303644 | -122.44184779835501 | (37.7294938303644, -122.441847798355) | ||||
| 46318 | 46318 | 222635 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 520 Powhattan Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6008405.39649 | 2098099.49386 | 37.7414564368646 | -122.41352629539499 | (37.7414564368646, -122.413526295395) | |||
| 47643 | 47643 | 205929 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 30 Northgate Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994458.86462 | 2093951.3949900002 | 37.7292738076366 | -122.461447593334 | (37.7292738076366, -122.461447593334) | |||
| 47745 | 47745 | 222638 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 500 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008447.3692 | 2098096.32026 | 37.7414500795592 | -122.41338094337 | (37.7414500795592, -122.41338094337) | |||
| 48097 | 48097 | 204709 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 545 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998992.2871199995 | 2097331.34526 | 37.7388142385985 | -122.446018219969 | (37.7388142385985, -122.446018219969) | |||
| 48818 | 48818 | 222665 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6003145.04093 | 2104185.04238 | 37.7578691478694 | -122.432149263871 | (37.7578691478694, -122.432149263871) | |||
| 49748 | 49748 | 222647 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 820 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003702.48516 | 2103374.94949 | 37.755676414553 | -122.43016359769699 | (37.755676414553, -122.430163597697) | |||
| 50255 | 50255 | 175817 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1601 San Jose Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6001662.2391 | 2094184.27122 | 37.7303252032495 | -122.436561595945 | (37.7303252032495, -122.436561595945) | ||||
| 51368 | 51368 | 222640 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 189 Powhattan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6008566.69278 | 2098086.62744 | 37.7414301640605 | -122.41296767703501 | (37.7414301640605, -122.412967677035) | |||
| 51370 | 51370 | 74568 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 751 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5991294.510430001 | 2110282.3084 | 37.773931595001706 | -122.473577708136 | (37.7739315950017, -122.473577708136) | ||
| 51883 | 51883 | 222639 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 189 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6008550.17911 | 2098088.6135 | 37.741434690349706 | -122.41302491618099 | (37.7414346903497, -122.413024916181) | |||
| 52765 | 52765 | 222642 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 121 Montcalm St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010304.9642199995 | 2099829.75812 | 37.7463138452157 | -122.407080146555 | (37.7463138452157, -122.407080146555) | |||
| 54365 | 54365 | 205934 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 906 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998837.85984 | 2095588.97571 | 37.734021286451004 | -122.44642684135201 | (37.734021286451, -122.446426841352) | |||
| 54643 | 54643 | 222645 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 123 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005341.09942 | 2096203.92936 | 37.7360791052728 | -122.423986823631 | (37.7360791052728, -122.423986823631) | |||
| 56702 | 56702 | 222673 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 190 Storrie St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000769.8265 | 2105310.91905 | 37.7608255764675 | -122.440444475527 | (37.7608255764675, -122.440444475527) | |||
| 57535 | 57535 | 222746 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 100 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008660.00908 | 2098066.70808 | 37.7413807076628 | -122.412643612617 | (37.7413807076628, -122.412643612617) | |||
| 57880 | 57880 | 222625 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 29 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005844.30057 | 2097770.6143400003 | 37.740409268065704 | -122.422358332172 | (37.7404092680657, -122.422358332172) | |||
| 57983 | 57983 | 222648 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 400 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003683.04706 | 2103350.38442 | 37.75560786372171 | -122.43022906832898 | (37.7556078637217, -122.430229068329) | |||
| 59701 | 59701 | 222671 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 841 Church St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004365.5079 | 2104119.71112 | 37.7577588846739 | -122.42792372191002 | (37.7577588846739, -122.42792372191) | |||
| 59972 | 59972 | 222740 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 648 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002389.29196 | 2099761.78027 | 37.7456810435418 | -122.43444670615 | (37.7456810435418, -122.43444670615) | |||
| 60566 | 60566 | 222654 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 352 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001768.69391 | 2103784.5826 | 37.7566914514695 | -122.43688057198999 | (37.7566914514695, -122.43688057199) | |||
| 61738 | 61738 | 222734 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1335 Douglass St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6001387.85036 | 2099809.36545 | 37.745754804151204 | -122.437912943329 | (37.7457548041512, -122.437912943329) | |||
| 62643 | 62643 | 222720 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 460 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998559.9629999995 | 2106518.60762 | 37.764015508625604 | -122.448174342784 | (37.7640155086256, -122.448174342784) | |||
| 62705 | 62705 | 205936 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 16 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5998119.51434 | 2093651.58316 | 37.7286606102943 | -122.448770873875 | (37.7286606102943, -122.448770873875) | |||
| 64083 | 64083 | 175818 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 12 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000786.090009999 | 2088431.87786 | 37.7144806101721 | -122.439178423455 | (37.7144806101721, -122.439178423455) | |||
| 64918 | 64918 | 222656 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 310 Liberty St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004069.16963 | 2103935.80533 | 37.757237153785795 | -122.428935470922 | (37.7572371537858, -122.428935470922) | |||
| 65341 | 65341 | 222675 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 110 Henry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002794.36582 | 2107408.76473 | 37.766700821303395 | -122.433592429354 | (37.7667008213034, -122.433592429354) | |||
| 65367 | 65367 | 222666 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4090 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 8 | Width 3ft | 6003140.83414 | 2104172.66898 | 37.7578349349576 | -122.432162929082 | (37.7578349349576, -122.432162929082) | |||
| 65425 | 65425 | 222650 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 91 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000677.8334 | 2104602.16707 | 37.7588742787364 | -122.44071179810899 | (37.7588742787364, -122.440711798109) | |||
| 65732 | 65732 | 222626 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 101 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006239.659469999 | 2097553.04485 | 37.7398341651269 | -122.42097589073201 | (37.7398341651269, -122.420975890732) | |||
| 66922 | 66922 | 188419 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 1300x De Haro St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 6012288.5470199995 | 2102174.31533 | 37.7528622973756 | -122.40038576319901 | (37.7528622973756, -122.400385763199) | |||
| 67883 | 67883 | 205930 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 235 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996324.55462 | 2094916.82803 | 37.7320318610725 | -122.45506751047701 | (37.7320318610725, -122.455067510477) | |||
| 68069 | 68069 | 222657 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 397 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003712.18229 | 2103887.0958 | 37.7570831961356 | -122.430166596908 | (37.7570831961356, -122.430166596908) | |||
| 68180 | 68180 | 222641 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 121 Montcalm St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6010335.8633 | 2099846.97477 | 37.7463628474829 | -122.40697451397699 | (37.7463628474829, -122.406974513977) | |||
| 68353 | 68353 | 222660 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 737 Sanchez St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6003698.27718 | 2104074.03497 | 37.7575956991109 | -122.43022802242201 | (37.7575956991109, -122.430228022422) | |||
| 70437 | 70437 | 222724 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 250 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008607.3441699995 | 2097436.28567 | 37.7396467499959 | -122.41278115135201 | (37.7396467499959, -122.412781151352) | |||
| 70443 | 70443 | 222652 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 11 Corwin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6001110.99108 | 2103921.57138 | 37.7570301865074 | -122.439164960595 | (37.7570301865074, -122.439164960595) | |||
| 71559 | 71559 | 222633 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 520 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6008371.35926 | 2098103.14981 | 37.74146456403 | -122.413644243307 | (37.74146456403, -122.413644243307) | |||
| 73405 | 73405 | 222630 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 625 Holly Park Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006168.95016 | 2096431.03637 | 37.736749394259206 | -122.421140724779 | (37.7367493942592, -122.421140724779) | |||
| 74515 | 74515 | 222723 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 6 Roscoe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6006834.2082 | 2095713.35843 | 37.734816289844495 | -122.41878975035601 | (37.7348162898445, -122.418789750356) | |||
| 76943 | 76943 | 222667 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 645 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003055.60188 | 2104525.93514 | 37.7588000864676 | -122.432482929452 | (37.7588000864676, -122.432482929452) | |||
| 78107 | 78107 | 100047 | Permitted Site 1 | Ceanothus Sps :: California lilac 270 | 191@ 23rd Ave 23rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 5988664.0 | 2114068.0 | 37.7841733536199 | -122.48295448443399 | (37.7841733536199, -122.482954484434) | ||||
| 89376 | 89376 | 54986 | Permitted Site 1 | Ceanothus Sps :: California lilac 270 | 630 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 774083 | 5990989.66226 | 2111091.4426 | 37.7761355972955 | -122.47469128492399 | (37.7761355972955, -122.474691284924) | ||
| 123449 | 123449 | 222646 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 4209 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001770.77195 | 2101738.59247 | 37.7510737715579 | -122.43672693271499 | (37.7510737715579, -122.436726932715) | |||
| 123456 | 123456 | 222674 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 190 Storrie St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 3ft | 6000781.07373 | 2105315.7314400002 | 37.760839430522104 | -122.440405921593 | (37.7608394305221, -122.440405921593) | |||
| 129673 | 129673 | 222711 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 276 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6002996.93111 | 2096284.15675 | 37.7361667666773 | -122.432097283983 | (37.7361667666773, -122.432097283983) | |||
| 129980 | 129980 | 222742 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 500x 27th St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 6002891.174980001 | 2100067.71005 | 37.7465495314539 | -122.432733120839 | (37.7465495314539, -122.432733120839) | |||
| 131016 | 131016 | 74721 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 751 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5991294.08826 | 2110301.56991 | 37.7739844574191 | -122.47358057378099 | (37.7739844574191, -122.473580573781) | ||
| 132525 | 132525 | 222744 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 276 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6002992.57035 | 2096281.2367900002 | 37.7361585018991 | -122.43211215244601 | (37.7361585018991, -122.432112152446) | |||
| 133216 | 133216 | 188423 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 602 Arthur Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015745.55798 | 2099807.317 | 37.7465551881795 | -122.38826548846201 | (37.7465551881795, -122.388265488462) | ||||
| 133500 | 133500 | 222726 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 99 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6007291.44171 | 2098736.64268 | 37.743143293435395 | -122.41742311988999 | (37.7431432934354, -122.41742311989) | ||||
| 134432 | 134432 | 175820 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 261 Pope St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6000467.452330001 | 2087520.4423 | 37.711959875208 | -122.440214438857 | (37.711959875208, -122.440214438857) | |||
| 134738 | 134738 | 204707 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 368 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5997187.85064 | 2096211.7529900002 | 37.7356369032136 | -122.4521763241 | (37.7356369032136, -122.4521763241) | |||
| 135549 | 135549 | 222727 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 2 Mirabel Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6007299.39658 | 2099783.87243 | 37.7460191994426 | -122.41746981629 | (37.7460191994426, -122.41746981629) | |||
| 137216 | 137216 | 222714 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 501 York St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6009828.15271 | 2105893.93218 | 37.762938017409 | -122.40915674860099 | (37.762938017409, -122.409156748601) | |||
| 137744 | 137744 | 222738 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1643 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6002073.55581 | 2099180.0465 | 37.7440658116781 | -122.43549686518499 | (37.7440658116781, -122.435496865185) | |||
| 138201 | 138201 | 122243 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1602 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5990412.22012 | 2114764.44305 | 37.7861871602654 | -122.476957236709 | (37.7861871602654, -122.476957236709) | |||
| 146680 | 146680 | 222729 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 297 Glenview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999301.184669999 | 2100808.44264 | 37.7483791472865 | -122.445200121084 | (37.7483791472865, -122.445200121084) | |||
| 147161 | 147161 | 222719 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1401 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5997793.014830001 | 2105883.03644 | 37.762226516948296 | -122.45078114824899 | (37.7622265169483, -122.450781148249) | |||
| 149921 | 149921 | 222728 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 2 Mirabel Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6007312.24014 | 2099789.9547900003 | 37.7460366228875 | -122.41742583583 | (37.7460366228875, -122.41742583583) | |||
| 150235 | 150235 | 222637 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 500 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6008432.5305699995 | 2098099.2612799997 | 37.7414573218076 | -122.413432458347 | (37.7414573218076, -122.413432458347) | |||
| 152376 | 152376 | 204712 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 400x Marietta Dr | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 5999156.87837 | 2097007.3059599998 | 37.7379339012297 | -122.44542584913201 | (37.7379339012297, -122.445425849132) | |||
| 152992 | 152992 | 222745 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999630.16383 | 2107483.17366 | 37.7667250877199 | -122.444542176192 | (37.7667250877199, -122.444542176192) | |||
| 153032 | 153032 | 222651 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 11 Corwin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6001073.475459999 | 2103923.13331 | 37.7570323403783 | -122.439294815506 | (37.7570323403783, -122.439294815506) | |||
| 153391 | 153391 | 222739 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 540 28th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6002408.85386 | 2099476.32277 | 37.744898354569 | -122.434358658948 | (37.744898354569, -122.434358658948) | |||
| 154092 | 154092 | 65017 | Permitted Site 1 | Ceanothus Sps :: California lilac 270 | 773 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1989 12:00:00 AM | 4 | Permit Number 26064 | 5991300.61602 | 2110165.83871 | 37.7736121544932 | -122.47354809070299 | (37.7736121544932, -122.473548090703) | ||
| 155218 | 155218 | 205927 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 351 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994099.7296 | 2099750.24687 | 37.7451753385886 | -122.463109727528 | (37.7451753385886, -122.463109727528) | |||
| 155795 | 155795 | 204705 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1550 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993090.57371 | 2104919.01452 | 37.7593092592319 | -122.466974886903 | (37.7593092592319, -122.466974886903) | |||
| 156473 | 156473 | 188422 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 602 Arthur Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015740.58656 | 2099810.1489 | 37.746562688524996 | -122.38828287686 | (37.746562688525, -122.38828287686) | ||||
| 156893 | 156893 | 205932 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 381 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998139.098569999 | 2094067.5739099998 | 37.7298039426763 | -122.44873312034599 | (37.7298039426763, -122.448733120346) | |||
| 157820 | 157820 | 222717 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1130 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5998192.89709 | 2106359.88718 | 37.763558711483704 | -122.44943247273001 | (37.7635587114837, -122.44943247273) | |||
| 158315 | 158315 | 175821 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1703 San Jose Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6001663.95995 | 2094186.51128 | 37.7303314517312 | -122.436555807014 | (37.7303314517312, -122.436555807014) | |||
| 159383 | 159383 | 222631 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006175.49755 | 2096399.14047 | 37.736662184315 | -122.421115823447 | (37.736662184315, -122.421115823447) | |||
| 160024 | 160024 | 222730 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 55 Murray St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004958.048719999 | 2095319.35308 | 37.733628623559 | -122.425248260418 | (37.733628623559, -122.425248260418) | ||||
| 160194 | 160194 | 205925 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 339 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993786.38841 | 2105256.23483 | 37.7602753154789 | -122.46459292724501 | (37.7602753154789, -122.464592927245) | |||
| 160252 | 160252 | 222628 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006154.8131 | 2096494.16604 | 37.7369219373074 | -122.42119408424401 | (37.7369219373074, -122.421194084244) | |||
| 160853 | 160853 | 204711 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 400x Marietta Dr | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5999138.58947 | 2096999.87001 | 37.737912439812796 | -122.445488548067 | (37.7379124398128, -122.445488548067) | |||
| 161303 | 161303 | 222644 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 121 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005291.14603 | 2096211.0656 | 37.736095879417796 | -122.424160040259 | (37.7360958794178, -122.424160040259) |
JSON shape: default, array, newline-delimited
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");