Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5478 | 5478 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 234 | 930 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6007386.5238 | 2120591.4348299997 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | |||
| 16974 | 16974 | 16139 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 370 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999751.27991 | 2094724.82015 | 37.7317006461585 | -122.443206831334 | (37.7317006461585, -122.443206831334) | |||
| 17008 | 17008 | 29970 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.9439400001 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | ||
| 21337 | 21337 | 29575 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 400X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991376.3613 | 2094248.5524799998 | 37.7299118271724 | -122.472125628008 | (37.7299118271724, -122.472125628008) | ||
| 21553 | 21553 | 29606 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991168.88017 | 2091040.07708 | 37.721090143382796 | -122.472609073864 | (37.7210901433828, -122.472609073864) | ||
| 23719 | 23719 | 206443 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 581 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5993478.4128 | 2089802.60481 | 37.7178257581409 | -122.464535950688 | (37.7178257581409, -122.464535950688) | |||
| 25644 | 25644 | 126371 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | |||
| 26524 | 26524 | 222994 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500x 27th St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 4ft | 6002676.05036 | 2100055.6268 | 37.746504150749004 | -122.433476134415 | (37.746504150749, -122.433476134415) | |||
| 26780 | 26780 | 206487 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994954.72324 | 2099244.0614400003 | 37.7438346949325 | -122.46011666235 | (37.7438346949325, -122.46011666235) | |||
| 27241 | 27241 | 126360 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6007607.19826 | 2119575.42635 | 37.8003794229421 | -122.41780812417 | (37.8003794229421, -122.41780812417) | |||
| 27802 | 27802 | 206466 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999436.63595 | 2095454.0058900001 | 37.733684872551606 | -122.444346998137 | (37.7336848725516, -122.444346998137) | ||||
| 27988 | 27988 | 206453 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 38 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991335.3896699995 | 2093546.9091299998 | 37.72798291897001 | -122.47221614476999 | (37.72798291897, -122.47221614477) | |||
| 28951 | 28951 | 222996 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500x 27th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002734.51591 | 2100059.43623 | 37.746517927469604 | -122.43327423933901 | (37.7465179274696, -122.433274239339) | |||
| 29362 | 29362 | 223008 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1201 San Jose Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004238.84554 | 2095923.20533 | 37.735246008392295 | -122.427777766445 | (37.7352460083923, -122.427777766445) | ||||
| 29447 | 29447 | 206472 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 714 Detroit St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999457.34155 | 2095426.0503099998 | 37.733609294436796 | -122.444273404802 | (37.7336092944368, -122.444273404802) | ||||
| 29864 | 29864 | 126362 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6007597.962180001 | 2119573.74544 | 37.8003742878151 | -122.417839965548 | (37.8003742878151, -122.417839965548) | |||
| 32930 | 32930 | 206459 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995500.0924 | 2096986.4163099998 | 37.73766711193829 | -122.458067560678 | (37.7376671119383, -122.458067560678) | |||
| 33380 | 33380 | 222998 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6002164.76896 | 2103518.3821099997 | 37.7559830321046 | -122.435491759762 | (37.7559830321046, -122.435491759762) | ||||
| 35503 | 35503 | 206455 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 700 Junipero Serra Blvd | 62 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991225.43334 | 2092378.3173099998 | 37.7247678930137 | -122.472511102603 | (37.7247678930137, -122.472511102603) | |||
| 35638 | 35638 | 223005 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 246 Bemis St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6003031.63093 | 2096309.9705299998 | 37.7362396126721 | -122.431979155322 | (37.7362396126721, -122.431979155322) | ||||
| 36299 | 36299 | 190911 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1980 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6013087.193080001 | 2095914.17172 | 37.735717772963795 | -122.397184944736 | (37.7357177729638, -122.397184944736) | ||||
| 38451 | 38451 | 206435 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 2330 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992341.16366 | 2099574.90495 | 37.7445924349065 | -122.469177732164 | (37.7445924349065, -122.469177732164) | |||
| 40271 | 40271 | 176065 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6010824.423280001 | 2090455.4956599998 | 37.7206031577782 | -122.404624109729 | (37.7206031577782, -122.404624109729) | |||
| 40706 | 40706 | 206477 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Terrace Dr | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993822.05067 | 2096524.01563 | 37.7363009158535 | -122.463835755623 | (37.7363009158535, -122.463835755623) | ||||
| 42774 | 42774 | 223012 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1101 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005036.06332 | 2096630.9329400002 | 37.7372343347918 | -122.425071830505 | (37.7372343347918, -122.425071830505) | ||||
| 43561 | 43561 | 126357 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Priest St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6008293.622769999 | 2117215.49565 | 37.79393824372 | -122.41526566338999 | (37.79393824372, -122.41526566339) | |||
| 43928 | 43928 | 126361 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6007604.93039 | 2119574.72474 | 37.8003773688712 | -122.41781592216299 | (37.8003773688712, -122.417815922163) | |||
| 44025 | 44025 | 206475 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 399 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5997496.30816 | 2095514.15628 | 37.7337391349554 | -122.45105958374201 | (37.7337391349554, -122.451059583742) | |||
| 45052 | 45052 | 206433 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 401x Ortega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 2ft | 5992711.67251 | 2102602.15843 | 37.7529258983243 | -122.46811676507099 | (37.7529258983243, -122.468116765071) | |||
| 45280 | 45280 | 222980 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 San Jose Ave | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6004766.24957 | 2096663.35836 | 37.737308122382004 | -122.426007008515 | (37.737308122382, -122.426007008515) | ||||
| 45515 | 45515 | 222982 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1101 San Jose Ave | 67 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6005045.200569999 | 2096625.52578 | 37.7372200041006 | -122.425039854206 | (37.7372200041006, -122.425039854206) | |||
| 46759 | 46759 | 187578 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 211 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6009088.83114 | 2088896.1901099999 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | ||||
| 47116 | 47116 | 206467 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5999430.1593 | 2095426.08584 | 37.7336078411342 | -122.44436738395099 | (37.7336078411342, -122.444367383951) | ||||
| 47369 | 47369 | 126370 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580770995 | -122.40460372750601 | (37.801988580771, -122.404603727506) | |||
| 47383 | 47383 | 206451 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 33 | Width 0ft | 5991343.11877 | 2093722.6763 | 37.728465979004795 | -122.47220223225901 | (37.7284659790048, -122.472202232259) | |||
| 47540 | 47540 | 176072 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 653 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005100.84385 | 2092592.61654 | 37.7261496752474 | -122.42456068104299 | (37.7261496752474, -122.424560681043) | ||||
| 48472 | 48472 | 206454 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991330.30791 | 2093483.47791 | 37.7278084585838 | -122.472229090527 | (37.7278084585838, -122.472229090527) | |||
| 49481 | 49481 | 206479 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Terrace Dr | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5993821.596580001 | 2096532.5334599998 | 37.73632427753171 | -122.463837943662 | (37.7363242775317, -122.463837943662) | ||||
| 50785 | 50785 | 126368 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 12 MacOndray Ln | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6008550.57003 | 2119171.07932 | 37.799322230301 | -122.414515043334 | (37.799322230301, -122.414515043334) | ||||
| 52423 | 52423 | 206456 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 700 Junipero Serra Blvd | 84 | : 4 | Tree 1 | Private 1 | 30 | Width 0ft | 5991229.90591 | 2092186.8138700002 | 37.7242423310074 | -122.472481686706 | (37.7242423310074, -122.472481686706) | |||
| 55004 | 55004 | 222995 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500x 27th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002718.47536 | 2100057.70158 | 37.746512254535205 | -122.43332958181699 | (37.7465122545352, -122.433329581817) | |||
| 55746 | 55746 | 249827 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 339 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 6011143.97494 | 2120350.69369 | 37.8027065167616 | -122.405624039843 | (37.8027065167616, -122.405624039843) | |||
| 55889 | 55889 | 206482 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995108.2045599995 | 2099311.1994 | 37.744027865704396 | -122.45959082518401 | (37.7440278657044, -122.459590825184) | |||
| 56836 | 56836 | 176067 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 700x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6009780.9842300005 | 2090145.5665099998 | 37.719693784023 | -122.408209118574 | (37.719693784023, -122.408209118574) | |||
| 56845 | 56845 | 206431 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 951 Noriega St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5990974.62554 | 2103115.26643 | 37.7542342869058 | -122.47416117691799 | (37.7542342869058, -122.474161176918) | |||
| 57848 | 57848 | 249832 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 339 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011163.78015 | 2120353.2836700003 | 37.802714735662 | -122.40555568594601 | (37.802714735662, -122.405555685946) | |||
| 57953 | 57953 | 223006 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1001 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6005181.63876 | 2096892.7596599997 | 37.7379614744429 | -122.424587128296 | (37.7379614744429, -122.424587128296) | ||||
| 58020 | 58020 | 126356 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 101 Marina Blvd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002934.90654 | 2121377.37848 | 37.805063066958105 | -122.434104982679 | (37.8050630669581, -122.434104982679) | ||||
| 58821 | 58821 | 223001 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3944 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6002181.90808 | 2102965.21527 | 37.7544651419609 | -122.43539291887501 | (37.7544651419609, -122.435392918875) | ||||
| 59831 | 59831 | 206471 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 714 Detroit St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 5999468.77343 | 2095408.32034 | 37.7335612643209 | -122.444232607974 | (37.7335612643209, -122.444232607974) | ||||
| 61087 | 61087 | 190918 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 70 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6012519.44645 | 2102822.4393700003 | 37.754654778405296 | -122.399632767143 | (37.7546547784053, -122.399632767143) | ||||
| 61307 | 61307 | 222987 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002610.5339 | 2099487.4912400004 | 37.7449404662242 | -122.43366208545099 | (37.7449404662242, -122.433662085451) | ||||
| 61645 | 61645 | 126365 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1151 Lombard St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6006751.38188 | 2120096.64647 | 37.8017623625961 | -122.42080661943001 | (37.8017623625961, -122.42080661943) | ||||
| 61777 | 61777 | 206452 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 37 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991336.42216 | 2093557.70772 | 37.7280126289541 | -122.472213362281 | (37.7280126289541, -122.472213362281) | |||
| 63254 | 63254 | 190917 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 68 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6012519.74637 | 2102837.21301 | 37.7546953603194 | -122.399632767155 | (37.7546953603194, -122.399632767155) | ||||
| 63887 | 63887 | 223014 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 130 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000989.365569999 | 2097560.44411 | 37.7395571289679 | -122.439129688289 | (37.7395571289679, -122.439129688289) | |||
| 64206 | 64206 | 190913 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 10x Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017428.5626 | 2095806.2606900001 | 37.73566220385221 | -122.38216748876002 | (37.7356622038522, -122.38216748876) | ||||
| 64590 | 64590 | 222983 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 90 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007949.21318 | 2098212.09839 | 37.7417399985009 | -122.415111593326 | (37.7417399985009, -122.415111593326) | |||
| 64819 | 64819 | 246768 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 Waltham St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009274.77295 | 2098916.84453 | 37.7437494805599 | -122.410577984112 | (37.7437494805599, -122.410577984112) | ||||
| 65338 | 65338 | 223007 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1200 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004038.311369999 | 2095943.3058799999 | 37.735289853946 | -122.428472518792 | (37.735289853946, -122.428472518792) | ||||
| 65373 | 65373 | 206437 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5999552.5631800005 | 2097488.9767299998 | 37.7392790352022 | -122.444092377567 | (37.7392790352022, -122.444092377567) | |||
| 65519 | 65519 | 206480 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5995119.81246 | 2099322.2843400002 | 37.744058969658106 | -122.459551490632 | (37.7440589696581, -122.459551490632) | |||
| 66206 | 66206 | 206447 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 193 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5993726.91575 | 2088448.649 | 37.7141224416834 | -122.46357878423001 | (37.7141224416834, -122.46357878423) | |||
| 66443 | 66443 | 223013 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 400 Prospect Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6006209.38075 | 2097598.06666 | 37.739956078103205 | -122.421083777917 | (37.7399560781032, -122.421083777917) | ||||
| 66607 | 66607 | 113503 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6011155.5498 | 2090556.69361 | 37.7208995275826 | -122.40348661931299 | (37.7208995275826, -122.403486619313) | |||
| 67428 | 67428 | 206465 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 423 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5998611.46189 | 2095226.7392099998 | 37.733013737293604 | -122.44718350482901 | (37.7330137372936, -122.447183504829) | |||
| 70616 | 70616 | 223011 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1201 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004395.88546 | 2096037.5210900002 | 37.735568775981704 | -122.427242962114 | (37.7355687759817, -122.427242962114) | ||||
| 73947 | 73947 | 223002 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 256 Bemis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6003028.5059400005 | 2096309.1150200001 | 37.736237086475 | -122.43198989862199 | (37.736237086475, -122.431989898622) | ||||
| 74056 | 74056 | 126359 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6007620.5753 | 2119577.5831299997 | 37.8003860977102 | -122.41776198712799 | (37.8003860977102, -122.417761987128) | |||
| 74189 | 74189 | 206440 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1x Minerva St | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5996572.23219 | 2088998.68039 | 37.7157962346852 | -122.45378402860399 | (37.7157962346852, -122.453784028604) | |||
| 74273 | 74273 | 176066 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6010525.865540001 | 2090356.25733 | 37.7203139789786 | -122.40564914889 | (37.7203139789786, -122.40564914889) | |||
| 74817 | 74817 | 206488 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994928.93938 | 2099242.2168 | 37.7438281469548 | -122.460205682656 | (37.7438281469548, -122.460205682656) | |||
| 75364 | 75364 | 176064 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011103.67645 | 2090538.55711 | 37.720846830886394 | -122.40366465540501 | (37.7208468308864, -122.403664655405) | |||
| 75726 | 75726 | 222979 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1001 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005237.0546 | 2097014.53451 | 37.7382989702268 | -122.424404187313 | (37.7382989702268, -122.424404187313) | ||||
| 76073 | 76073 | 246435 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 501 Duncan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 6003234.36598 | 2099765.5285400003 | 37.7457392692468 | -122.431524834927 | (37.7457392692468, -122.431524834927) | |||
| 76969 | 76969 | 206469 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999419.31958 | 2095424.67998 | 37.733603362501604 | -122.444404758876 | (37.7336033625016, -122.444404758876) | ||||
| 89215 | 89215 | 122489 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 69x Bonview St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
| 129598 | 129598 | 222999 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | 6002171.060869999 | 2103519.51853 | 37.7559865097873 | -122.435470081578 | (37.7559865097873, -122.435470081578) | ||||
| 130374 | 130374 | 206449 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3020 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5990639.74875 | 2095092.0751099999 | 37.7321852719367 | -122.4747337006 | (37.7321852719367, -122.4747337006) | |||
| 131412 | 131412 | 222997 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002162.22875 | 2103520.28848 | 37.7559881222676 | -122.435500681007 | (37.7559881222676, -122.435500681007) | ||||
| 131448 | 131448 | 190921 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 875 Vermont St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6011349.18047 | 2104266.91512 | 37.7585556858022 | -122.403781518727 | (37.7585556858022, -122.403781518727) | |||
| 132192 | 132192 | 190914 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012455.864080001 | 2103644.27268 | 37.756907808551794 | -122.399910360878 | (37.7569078085518, -122.399910360878) | ||||
| 132666 | 132666 | 222988 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002598.0607 | 2099487.20989 | 37.7449389859493 | -122.433705195344 | (37.7449389859493, -122.433705195344) | ||||
| 132915 | 132915 | 206470 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999427.716030001 | 2095403.5068599998 | 37.733545705162705 | -122.44437420892599 | (37.7335457051627, -122.444374208926) | ||||
| 133034 | 133034 | 122924 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 2 11th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5992431.96311 | 2114886.35785 | 37.7866388652474 | -122.469978400459 | (37.7866388652474, -122.469978400459) | |||
| 133091 | 133091 | 223010 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1201 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004358.20734 | 2096003.62684 | 37.7354735791371 | -122.427370816017 | (37.7354735791371, -122.427370816017) | ||||
| 133440 | 133440 | 206486 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994998.43576 | 2099244.3383299997 | 37.743837969341 | -122.45996553579901 | (37.743837969341, -122.459965535799) | |||
| 133529 | 133529 | 222986 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 21 | 6002638.36895 | 2099488.8163799997 | 37.7449456841067 | -122.43356593172399 | (37.7449456841067, -122.433565931724) | ||||
| 134062 | 134062 | 206463 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 100 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6001362.70768 | 2094968.7442 | 37.732462159688 | -122.4376532749 | (37.732462159688, -122.4376532749) | |||
| 134302 | 134302 | 222985 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 517 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 10ft | 6002550.624530001 | 2098561.77605 | 37.7423952688291 | -122.433803088343 | (37.7423952688291, -122.433803088343) | |||
| 135280 | 135280 | 190915 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012505.66859 | 2103014.14021 | 37.7551803790787 | -122.399693874288 | (37.7551803790787, -122.399693874288) | ||||
| 135410 | 135410 | 206489 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994901.422809999 | 2099243.38936 | 37.7438297837176 | -122.46030091277201 | (37.7438297837176, -122.460300912772) | |||
| 135743 | 135743 | 222993 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | 6002546.229730001 | 2099483.20236 | 37.7449250410506 | -122.43388413076 | (37.7449250410506, -122.43388413076) | ||||
| 136629 | 136629 | 206481 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995111.8827 | 2099315.2957900004 | 37.74403932487021 | -122.45957840372101 | (37.7440393248702, -122.459578403721) | |||
| 137246 | 137246 | 222984 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 4699 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000341.30715 | 2101074.37399 | 37.7491686459265 | -122.441622492977 | (37.7491686459265, -122.441622492977) | |||
| 137496 | 137496 | 246436 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 498 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6003348.10613 | 2099802.17179 | 37.7458463290596 | -122.43113415324301 | (37.7458463290596, -122.431134153243) | |||
| 137634 | 137634 | 250505 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 55 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5987243.87038 | 2115583.5644400003 | 37.7882519230241 | -122.487978957983 | (37.7882519230241, -122.487978957983) | ||||
| 148076 | 148076 | 113495 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | 3x3 | 6011252.2338 | 2090588.8087900002 | 37.720993109219705 | -122.40315466785201 | (37.7209931092197, -122.403154667852) | |||
| 148103 | 148103 | 206457 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 900 Junipero Serra Blvd | 104 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991133.573530001 | 2090407.8832200002 | 37.719352251183 | -122.472685046772 | (37.719352251183, -122.472685046772) | |||
| 149266 | 149266 | 206439 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 171 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999612.35761 | 2094047.36229 | 37.7298325825057 | -122.44363846276501 | (37.7298325825057, -122.443638462765) |
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");