Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60657 | 60657 | 213701 | Undocumented 2 | Prunus spp :: Cherry 84 | 700 Junipero Serra Blvd | 130 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991210.94255 | 2091714.66662 | 37.722944834118294 | -122.47251283382201 | (37.7229448341183, -122.472512833822) | |||
55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
75257 | 75257 | 186812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.764283401100705 | -122.495707883417 | (37.7642834011007, -122.495707883417) | |||
155382 | 155382 | 186813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 114 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.8556 | 2106897.4567 | 37.7642606048812 | -122.4957280144 | (37.7642606048812, -122.4957280144) | |||
55485 | 55485 | 186815 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 112 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984815.7546 | 2106849.1761 | 37.7641278583257 | -122.49573517813299 | (37.7641278583257, -122.495735178133) | |||
177422 | 177422 | 237963 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1000 San Jose Ave | 106 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005052.98208 | 2096959.6805599998 | 37.7381379574049 | -122.42503671826799 | (37.7381379574049, -122.425036718268) | ||||
104169 | 104169 | 115503 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2901 25th St | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.751172725188106 | -122.408119020981 | (37.7511727251881, -122.408119020981) | |
30069 | 30069 | 215263 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991309.897609999 | 2093234.8571099997 | 37.727124626686795 | -122.47228153268298 | (37.7271246266868, -122.472281532683) | |||
64339 | 64339 | 179789 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004745.296630001 | 2094368.88342 | 37.7310068245956 | -122.425916172505 | (37.7310068245956, -122.425916172505) | ||||
22299 | 22299 | 179788 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6004749.24947 | 2094369.67329 | 37.731009216793296 | -122.425902563064 | (37.7310092167933, -122.425902563064) | ||||
68637 | 68637 | 179787 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6004755.58459 | 2094369.3250900002 | 37.7310086187332 | -122.425880636693 | (37.7310086187332, -122.425880636693) | ||||
68758 | 68758 | 215262 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 68 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991312.446330001 | 2093241.21549 | 37.72714223271821 | -122.472273185176 | (37.7271422327182, -122.472273185176) | |||
30258 | 30258 | 179786 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004760.18002 | 2094369.44832 | 37.7310092167964 | -122.425864758274 | (37.7310092167964, -122.425864758274) | ||||
34648 | 34648 | 215261 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991310.9639 | 2093247.2582599998 | 37.7271587388628 | -122.47227875017799 | (37.7271587388628, -122.472278750178) | |||
30400 | 30400 | 179785 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004765.43097 | 2094369.55773 | 37.7310098139557 | -122.42584661262501 | (37.7310098139557, -122.425846612625) | ||||
186099 | 186099 | 179784 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004770.673219999 | 2094369.23235 | 37.7310092167841 | -122.425828466117 | (37.7310092167841, -122.425828466117) | ||||
24973 | 24973 | 179783 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6004773.760559999 | 2094370.4753299998 | 37.7310128042003 | -122.42581788109501 | (37.7310128042003, -122.425817881095) | ||||
34055 | 34055 | 179782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6004777.69099 | 2094370.17663 | 37.7310122061496 | -122.425804271672 | (37.7310122061496, -122.425804271672) | ||||
156427 | 156427 | 179781 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6004781.59903 | 2094368.78968 | 37.7310086187399 | -122.425790662224 | (37.7310086187399, -122.425790662224) | |||
52338 | 52338 | 179780 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6004783.3793 | 2094370.27736 | 37.7310128041816 | -122.42578461337601 | (37.7310128041816, -122.425784613376) | |||
60275 | 60275 | 187125 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2600 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985146.9994 | 2097362.2698 | 37.738098806432205 | -122.493890328885 | (37.7380988064322, -122.493890328885) | |||
56356 | 56356 | 187374 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2200 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985054.3016 | 2099973.6311 | 37.745263476241796 | -122.49440326645 | (37.7452634762418, -122.49440326645) | |||
130287 | 130287 | 179779 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6004785.30631 | 2094368.27777 | 37.7310074226485 | -122.425777809099 | (37.7310074226485, -122.425777809099) | |||
29456 | 29456 | 179778 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 6004787.32766 | 2094370.8495200002 | 37.731014598327796 | -122.42577100392799 | (37.7310145983278, -122.425771003928) | |||
57457 | 57457 | 179777 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6004790.57095 | 2094369.0403200001 | 37.731009813945 | -122.42575966259301 | (37.731009813945, -122.425759662593) | |||
38234 | 38234 | 179776 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6004793.39482 | 2094368.1113 | 37.7310074226383 | -122.42574983389 | (37.7310074226383, -122.42574983389) | |||
60071 | 60071 | 179775 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6004797.54841 | 2094368.02582 | 37.731007422644794 | -122.42573546813699 | (37.7310074226448, -122.425735468137) | |||
152214 | 152214 | 179774 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6004801.46093 | 2094366.85627 | 37.7310044324123 | -122.425721858672 | (37.7310044324123, -122.425721858672) | |||
185594 | 185594 | 179773 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6004804.49451 | 2094365.48732 | 37.731000845003 | -122.425711273668 | (37.731000845003, -122.425711273668) | |||
186908 | 186908 | 179772 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6004808.00576 | 2094366.06815 | 37.7310026382465 | -122.42569917600201 | (37.7310026382465, -122.425699176002) | |||
154864 | 154864 | 179771 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6004812.59198 | 2094365.7559599997 | 37.7310020401985 | -122.42568329844299 | (37.7310020401985, -122.425683298443) | |||
36563 | 36563 | 202259 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013218.01399 | 2093376.8881599999 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | ||||
48523 | 48523 | 179770 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6004816.30399 | 2094365.4617599999 | 37.7310014421459 | -122.425670444458 | (37.7310014421459, -122.425670444458) | |||
152838 | 152838 | 237644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 310 Liberty St | 50 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6003839.23208 | 2103927.37536 | 37.757200989362104 | -122.42973008309099 | (37.7572009893621, -122.429730083091) | |||
155749 | 155749 | 179769 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6004822.1930599995 | 2094364.6874799998 | 37.730999648917106 | -122.425650029849 | (37.7309996489171, -122.425650029849) | |||
177784 | 177784 | 179768 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6004827.00692 | 2094364.8062200001 | 37.7310002469633 | -122.425633395959 | (37.7310002469633, -122.425633395959) | |||
148931 | 148931 | 179767 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6004828.96528 | 2094364.3303 | 37.7309990508516 | -122.425626591714 | (37.7309990508516, -122.425626591714) | |||
35245 | 35245 | 179766 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6004833.3420400005 | 2094364.4580400002 | 37.7309996489081 | -122.425611469595 | (37.7309996489081, -122.425611469595) | |||
187970 | 187970 | 179765 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 10ft | 6004837.08963 | 2094365.9052400002 | 37.731003834354794 | -122.42559861649599 | (37.7310038343548, -122.425598616496) | |||
180747 | 180747 | 179764 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6004840.3284599995 | 2094363.87865 | 37.7309984527989 | -122.425587275126 | (37.7309984527989, -122.425587275126) | |||
46708 | 46708 | 179763 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6004845.971969999 | 2094361.80258 | 37.7309930712551 | -122.42556761684901 | (37.7309930712551, -122.425567616849) | |||
163872 | 163872 | 186776 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984864.7511 | 2106787.9137 | 37.763962518214505 | -122.49556119714799 | (37.7639625182145, -122.495561197148) | |||
28334 | 28334 | 186775 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984844.3759 | 2106784.0328 | 37.7639506692175 | -122.495631381575 | (37.7639506692175, -122.495631381575) | |||
33080 | 33080 | 215260 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 43 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991332.77888 | 2093518.51077 | 37.7279047930719 | -122.472223101042 | (37.7279047930719, -122.472223101042) | |||
56876 | 56876 | 179762 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6004847.12334 | 2094364.61005 | 37.731000844999706 | -122.42556383609801 | (37.7310008449997, -122.425563836098) | |||
102961 | 102961 | 39036 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009448.598999999 | 2105916.703 | 37.762979270155505 | -122.410471107096 | (37.7629792701555, -122.410471107096) | ||
175316 | 175316 | 235818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004748.03107 | 2096617.2038599998 | 37.7371803628754 | -122.426066713609 | (37.7371803628754, -122.426066713609) | ||||
129663 | 129663 | 237865 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004416.51581 | 2096041.25908 | 37.735580206346704 | -122.427171901277 | (37.7355802063467, -122.427171901277) | ||||
132517 | 132517 | 186774 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984836.1288 | 2106787.9137 | 37.76396084213079 | -122.495660191684 | (37.7639608421308, -122.495660191684) | |||
133278 | 133278 | 179761 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6004848.16693 | 2094362.1927 | 37.730994266461394 | -122.42556005625099 | (37.7309942664614, -122.425560056251) | |||
177543 | 177543 | 214300 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993888.01583 | 2096515.6983900003 | 37.7362818799091 | -122.46360708499701 | (37.7362818799091, -122.463607084997) | ||||
35443 | 35443 | 237864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004410.62481 | 2096042.76783 | 37.735584015890204 | -122.427192376154 | (37.7355840158902, -122.427192376154) | ||||
68654 | 68654 | 186773 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984840.0098 | 2106777.241 | 37.7639317651664 | -122.495645981391 | (37.7639317651664, -122.495645981391) | |||
110004 | 110004 | 39034 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009405.63 | 2105912.797 | 37.7629661362051 | -122.410619446859 | (37.7629661362051, -122.410619446859) | ||
171129 | 171129 | 187022 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2501 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984980.0493 | 2097896.5997 | 37.7395561634642 | -122.49450692872 | (37.7395561634642, -122.49450692872) | |||
185858 | 185858 | 215259 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991333.88736 | 2093532.9142200002 | 37.7279444054996 | -122.472220318525 | (37.7279444054996, -122.472220318525) | |||
187897 | 187897 | 179760 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6004853.85523 | 2094362.29345 | 37.730994864507 | -122.425540397994 | (37.730994864507, -122.425540397994) | |||
46004 | 46004 | 212540 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993897.21452 | 2096501.63961 | 37.7362438080119 | -122.46357426156 | (37.7362438080119, -122.46357426156) | ||||
55581 | 55581 | 249708 | Undocumented 2 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2400 Baker St | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5999695.18411 | 2117183.83938 | 37.7933643296589 | -122.44501472497 | (37.7933643296589, -122.44501472497) | ||||
119962 | 119962 | 39033 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009388.268999999 | 2105911.495 | 37.7629615878496 | -122.410679400873 | (37.7629615878496, -122.410679400873) | ||
131775 | 131775 | 179759 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 10ft | 6004857.12989 | 2094362.0082599998 | 37.7309942664668 | -122.425529056646 | (37.7309942664668, -122.425529056646) | |||
55258 | 55258 | 212539 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993900.48922 | 2096491.80191 | 37.736216984813105 | -122.463562225914 | (37.7362169848131, -122.463562225914) | ||||
61578 | 61578 | 238534 | Undocumented 2 | Prunus spp :: Cherry 84 | 671 Church St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004315.939809999 | 2105094.00544 | 37.7604312615151 | -122.428164581928 | (37.7604312615151, -122.428164581928) | |||
130866 | 130866 | 179758 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6004859.59518 | 2094360.54227 | 37.7309903804801 | -122.42552042942499 | (37.7309903804801, -122.425520429425) | |||
140786 | 140786 | 39032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009362.227000001 | 2105911.495 | 37.7629601277229 | -122.410769471544 | (37.7629601277229, -122.410769471544) | ||
155612 | 155612 | 249707 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999697.96101 | 2117191.03981 | 37.793384258626205 | -122.445005634599 | (37.7933842586262, -122.445005634599) | ||||
69276 | 69276 | 39031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009344.866 | 2105909.325 | 37.7629531959614 | -122.410829364237 | (37.7629531959614, -122.410829364237) | ||
165194 | 165194 | 212538 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5993893.90506 | 2096479.6500900001 | 37.736183239558 | -122.463584108238 | (37.736183239558, -122.463584108238) | ||||
165979 | 165979 | 179757 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6004862.372140001 | 2094361.68258 | 37.7309936684225 | -122.425510910124 | (37.7309936684225, -122.425510910124) | |||
142018 | 142018 | 39020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009326.637 | 2105908.456 | 37.7629497877468 | -122.410892350936 | (37.7629497877468, -122.410892350936) | ||
168424 | 168424 | 179756 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6004864.308119999 | 2094360.1184200002 | 37.7309894829744 | -122.42550410583401 | (37.7309894829744, -122.425504105834) | |||
124880 | 124880 | 39029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009306.238 | 2105908.456 | 37.762948643891 | -122.410962904321 | (37.762948643891, -122.410962904321) | ||
128920 | 128920 | 31250 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990801.243009999 | 2098168.10201 | 37.7406406146101 | -122.474399775861 | (37.7406406146101, -122.474399775861) | ||
130202 | 130202 | 179755 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6004867.641009999 | 2094362.6631900002 | 37.730996658661205 | -122.425492764501 | (37.7309966586612, -122.425492764501) | |||
176516 | 176516 | 235822 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Eugenia Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006569.74565 | 2098123.14893 | 37.7414181446448 | -122.419875033313 | (37.7414181446448, -122.419875033313) | ||||
60082 | 60082 | 249703 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2400 Baker St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999691.6374699995 | 2117215.06978 | 37.793449877667 | -122.445029242728 | (37.793449877667, -122.445029242728) | ||||
72665 | 72665 | 179754 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6004870.43826 | 2094360.4278900002 | 37.730990679074004 | -122.42548293491001 | (37.730990679074, -122.42548293491) | |||
115780 | 115780 | 31249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990802.25301 | 2098150.9350099997 | 37.74059353695289 | -122.474395031258 | (37.7405935369529, -122.474395031258) | ||
20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
45573 | 45573 | 179753 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6004874.81924 | 2094360.77335 | 37.7309918751611 | -122.42546781368999 | (37.7309918751611, -122.42546781369) | |||
51189 | 51189 | 196345 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015663.1317300005 | 2099868.27306 | 37.7467179933348 | -122.388554766215 | (37.7467179933348, -122.388554766215) | ||||
89371 | 89371 | 31248 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990803.26301 | 2098117.61001 | 37.740502093576005 | -122.474389107834 | (37.740502093576, -122.474389107834) | ||
133585 | 133585 | 213649 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999480.38992 | 2096117.32238 | 37.735508679678 | -122.44424337825001 | (37.735508679678, -122.44424337825) | |||
88180 | 88180 | 31247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990804.27301 | 2098092.3640099997 | 37.7404328330574 | -122.47438377383499 | (37.7404328330574, -122.474383773835) | ||
131586 | 131586 | 196344 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015666.28786 | 2099877.42762 | 37.7467433047611 | -122.38854449143801 | (37.7467433047611, -122.388544491438) | ||||
133843 | 133843 | 213648 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999490.37481 | 2096123.0943099998 | 37.735525097687294 | -122.44420927146002 | (37.7355250976873, -122.44420927146) | |||
144691 | 144691 | 39043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009263.703 | 2105753.075 | 37.7625196179381 | -122.411099042798 | (37.7625196179381, -122.411099042798) | ||
155802 | 155802 | 179752 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6004881.332719999 | 2094358.46125 | 37.7309858946651 | -122.425445130998 | (37.7309858946651, -122.425445130998) | |||
27498 | 27498 | 179751 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6004881.94818 | 2094356.48865 | 37.7309805131181 | -122.42544286291901 | (37.7309805131181, -122.425442862919) | |||
81527 | 81527 | 39026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009266.307 | 2105730.9390000002 | 37.762458983569495 | -122.411088472825 | (37.7624589835695, -122.411088472825) | ||
85443 | 85443 | 31246 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098068.1280099996 | 37.7403663457385 | -122.474378513531 | (37.7403663457385, -122.474378513531) | ||
152229 | 152229 | 215258 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 500 Junipero Serra Blvd | 32 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991336.01745 | 2093595.78763 | 37.7281171634535 | -122.472217536006 | (37.7281171634535, -122.472217536006) | |||
32300 | 32300 | 196138 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6013054.7193 | 2103811.53724 | 37.757400449098604 | -122.39785101412 | (37.7574004490986, -122.39785101412) | ||||
58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
68337 | 68337 | 196343 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015689.423719999 | 2099879.91957 | 37.7467514292439 | -122.388464663129 | (37.7467514292439, -122.388464663129) | ||||
95229 | 95229 | 31251 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098048.9410099997 | 37.740313663161395 | -122.47437711373101 | (37.7403136631614, -122.474377113731) | ||
125544 | 125544 | 39030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009267.609 | 2105685.366 | 37.7623339235365 | -122.411080750478 | (37.7623339235365, -122.411080750478) | ||
134608 | 134608 | 213647 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 31 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5999489.23346 | 2096109.45083 | 37.7354875707953 | -122.444212237426 | (37.7354875707953, -122.444212237426) |
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");