Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28294 | 28294 | 188658 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | ||||
| 26454 | 26454 | 188657 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6016750.167669999 | 2099204.87087 | 37.744956608177205 | -122.38474966268801 | (37.7449566081772, -122.384749662688) | ||||
| 56563 | 56563 | 188656 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 122 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016757.253769999 | 2099196.6677 | 37.7449344758533 | -122.384724588679 | (37.7449344758533, -122.384724588679) | ||||
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 32317 | 32317 | 186821 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 105 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.763780672010896 | -122.49568123753599 | (37.7637806720109, -122.495681237536) | |||
| 153690 | 153690 | 186825 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 100 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984841.1725 | 2106636.9913 | 37.763546746968295 | -122.49563161459999 | (37.7635467469683, -122.4956316146) | |||
| 49403 | 49403 | 186616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 87 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984717.3898 | 2104397.9779 | 37.75739179261161 | -122.495894553165 | (37.7573917926116, -122.495894553165) | |||
| 131350 | 131350 | 186614 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 85 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984775.1737 | 2104397.9779 | 37.7573951766754 | -122.495694716519 | (37.7573951766754, -122.495694716519) | |||
| 159840 | 159840 | 186613 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 84 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984762.1933 | 2104405.0962 | 37.7574139613926 | -122.49574013227699 | (37.7574139613926, -122.495740132277) | |||
| 35253 | 35253 | 186612 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 83 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984740.0009 | 2104413.4707 | 37.7574356557736 | -122.49581749901002 | (37.7574356557736, -122.49581749901) | |||
| 167469 | 167469 | 186611 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 82 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984721.5770000005 | 2104411.7958 | 37.7574299779546 | -122.49588109168998 | (37.7574299779546, -122.49588109169) | |||
| 67433 | 67433 | 186610 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 81 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984720.7396 | 2104420.1703 | 37.7574529229595 | -122.49588460547199 | (37.7574529229595, -122.495884605472) | |||
| 70272 | 70272 | 186802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 80 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984846.4625 | 2106932.8738 | 37.76435946696029 | -122.495635143928 | (37.7643594669603, -122.495635143928) | |||
| 172909 | 172909 | 186609 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 80 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984732.0451 | 2104419.3328 | 37.7574512855375 | -122.49584544534599 | (37.7574512855375, -122.495845445346) | |||
| 155155 | 155155 | 186608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 79 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984734.9762 | 2104426.0324 | 37.757469852437794 | -122.49583580278299 | (37.7574698524378, -122.495835802783) | |||
| 181452 | 181452 | 220191 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6004894.80738 | 2096532.47755 | 37.7369560180099 | -122.425553212433 | (37.7369560180099, -122.425553212433) | ||||
| 53208 | 53208 | 220190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004897.78998 | 2096535.50608 | 37.73696450219779 | -122.425543115723 | (37.7369645021978, -122.425543115723) | ||||
| 146508 | 146508 | 220189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004903.37501 | 2096531.93768 | 37.7369550197456 | -122.425523551887 | (37.7369550197456, -122.425523551887) | ||||
| 163668 | 163668 | 186606 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984755.9124 | 2104439.8503 | 37.757509018663505 | -122.495764417358 | (37.7575090186635, -122.495764417358) | |||
| 176241 | 176241 | 184888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984676.0208 | 2106738.9985 | 37.7638171575071 | -122.496210339991 | (37.7638171575071, -122.496210339991) | |||
| 51775 | 51775 | 184075 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Sunset Blvd | 76 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984932.9377 | 2104018.8187 | 37.756363348236604 | -122.49512115533199 | (37.7563633482366, -122.495121155332) | |||
| 178188 | 178188 | 220188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004898.43848 | 2096540.4001099998 | 37.736977976744 | -122.425541221768 | (37.736977976744, -122.425541221768) | ||||
| 65971 | 65971 | 220202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6003538.0871 | 2095667.4408599997 | 37.7345040713105 | -122.430182303581 | (37.7345040713105, -122.430182303581) | ||||
| 182151 | 182151 | 220187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004907.90324 | 2096539.115 | 37.736974982905295 | -122.42550840641 | (37.7369749829053, -122.42550840641) | ||||
| 185060 | 185060 | 184887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984636.53 | 2106768.6166 | 37.763896167173705 | -122.496349110122 | (37.7638961671737, -122.496349110122) | |||
| 29433 | 29433 | 186603 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984731.2077 | 2104430.2197 | 37.7574811288953 | -122.49584914444799 | (37.7574811288953, -122.495849144448) | |||
| 170910 | 170910 | 220201 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6003510.43036 | 2095660.01539 | 37.734482116158105 | -122.430277392481 | (37.7344821161581, -122.430277392481) | |||
| 171906 | 171906 | 220186 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004903.97159 | 2096543.19438 | 37.736985961816295 | -122.42552229012699 | (37.7369859618163, -122.425522290127) | ||||
| 30490 | 30490 | 184072 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984928.5463 | 2103997.684 | 37.756305061112705 | -122.495134783659 | (37.7563050611127, -122.495134783659) | |||
| 35284 | 35284 | 186795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984860.9644 | 2106903.0931 | 37.764278546741295 | -122.49558278994301 | (37.7642785467413, -122.495582789943) | |||
| 41974 | 41974 | 184884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984688.9312 | 2106783.4256 | 37.7639398980625 | -122.49616896553101 | (37.7639398980625, -122.496168965531) | |||
| 158439 | 158439 | 220185 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004909.032430001 | 2096549.6336299998 | 37.7370039284954 | -122.42550525066002 | (37.7370039284954, -122.42550525066) | ||||
| 160587 | 160587 | 220200 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6003513.54179 | 2095663.72893 | 37.7344924889333 | -122.430266900093 | (37.7344924889333, -122.430266900093) | |||
| 188967 | 188967 | 186602 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984723.2519 | 2104439.4316 | 37.7575059562709 | -122.495877337913 | (37.7575059562709, -122.495877337913) | |||
| 165475 | 165475 | 220184 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004926.8696 | 2096549.97699 | 37.737005879105396 | -122.425443603957 | (37.7370058791054, -122.425443603957) | ||||
| 177194 | 177194 | 184883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984691.969 | 2106787.6025 | 37.763951544593795 | -122.49615876703399 | (37.7639515445938, -122.496158767034) | |||
| 30179 | 30179 | 184882 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984668.0467 | 2106784.9445 | 37.763942845201996 | -122.496241309763 | (37.763942845202, -122.496241309763) | |||
| 38042 | 38042 | 220199 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6003519.67627 | 2095667.91857 | 37.73450434019979 | -122.43024598997499 | (37.7345043401998, -122.430245989975) | |||
| 173065 | 173065 | 220183 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6004926.20278 | 2096562.8505 | 37.7370411891885 | -122.425446825336 | (37.7370411891885, -122.425446825336) | ||||
| 28954 | 28954 | 186921 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985168.1725 | 2096748.5598 | 37.736414961632704 | -122.493771912003 | (37.7364149616327, -122.493771912003) | |||
| 42488 | 42488 | 220198 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 5ft | 6003524.19467 | 2095672.0219999999 | 37.7345158632135 | -122.430230661025 | (37.7345158632135, -122.430230661025) | |||
| 47210 | 47210 | 184881 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984647.1621 | 2106788.3619999997 | 37.7639510053125 | -122.496313794444 | (37.7639510053125, -122.496313794444) | |||
| 74654 | 74654 | 220182 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004985.47233 | 2096611.09675 | 37.737177011099604 | -122.425245335799 | (37.7371770110996, -122.425245335799) | ||||
| 59482 | 59482 | 184880 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984640.7069 | 2106797.4752 | 37.763975649452 | -122.496336793184 | (37.763975649452, -122.496336793184) | |||
| 73216 | 73216 | 220197 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 69 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 5ft | 6003530.33086 | 2095674.11312 | 37.734521952510796 | -122.43020959532 | (37.7345219525108, -122.43020959532) | |||
| 130783 | 130783 | 186598 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984775.1737 | 2104452.8307 | 37.7575457872194 | -122.49569876247699 | (37.7575457872194, -122.495698762477) | |||
| 38739 | 38739 | 186794 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984862.0002 | 2106886.7785 | 37.7642338120894 | -122.495578004049 | (37.7642338120894, -122.495578004049) | |||
| 55241 | 55241 | 184879 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984636.1502 | 2106802.0319 | 37.7639878939354 | -122.49635288946101 | (37.7639878939354, -122.496352889461) | |||
| 76034 | 76034 | 220196 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 68 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 5ft | 6003535.06176 | 2095676.5512700002 | 37.7345289150748 | -122.43019341291401 | (37.7345289150748, -122.430193412914) | |||
| 27189 | 27189 | 220159 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 67 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004532.29415 | 2096115.9287299998 | 37.73579177907 | -122.426776927106 | (37.73579177907, -122.426776927106) | ||||
| 38062 | 38062 | 220195 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 67 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 6003539.74229 | 2095678.61576 | 37.734534848798205 | -122.43017737800301 | (37.7345348487982, -122.430177378003) | |||
| 42663 | 42663 | 184878 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984672.2236 | 2106800.5130000003 | 37.763985836593 | -122.496228012074 | (37.763985836593, -122.496228012074) | |||
| 24548 | 24548 | 184805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984688.1718 | 2105711.6678 | 37.7609971073609 | -122.496092516316 | (37.7609971073609, -122.496092516316) | |||
| 47311 | 47311 | 220158 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004531.65878 | 2096118.78837 | 37.735799595073104 | -122.426779327416 | (37.7357995950731, -122.426779327416) | ||||
| 147959 | 147959 | 220194 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 5ft | 6003545.8031 | 2095679.42322 | 37.7345374091774 | -122.430156481356 | (37.7345374091774, -122.430156481356) | |||
| 179644 | 179644 | 184877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984676.4005 | 2106805.4493 | 37.763999634952505 | -122.49621392986201 | (37.7639996349525, -122.496213929862) | |||
| 50471 | 50471 | 220157 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004526.08475 | 2096117.80265 | 37.7357965733541 | -122.426798528853 | (37.7357965733541, -122.426798528853) | ||||
| 135166 | 135166 | 187379 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985060.734 | 2100052.5124 | 37.7454804393236 | -122.494386838151 | (37.7454804393236, -122.494386838151) | |||
| 155970 | 155970 | 184876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984660.832 | 2106807.7277 | 37.764004978839296 | -122.496267944002 | (37.7640049788393, -122.496267944002) | |||
| 164531 | 164531 | 186916 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985173.6735 | 2096745.3508 | 37.736406472409705 | -122.49375265661101 | (37.7364064724097, -122.493752656611) | |||
| 177243 | 177243 | 220193 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 5ft | 6003549.85445 | 2095682.63787 | 37.734546465338504 | -122.43014270374901 | (37.7345464653385, -122.430142703749) | |||
| 70806 | 70806 | 220156 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004516.6061 | 2096115.66582 | 37.7357901701732 | -122.426831148142 | (37.7357901701732, -122.426831148142) | ||||
| 135813 | 135813 | 186790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984851.9007 | 2106879.5275 | 37.764213311472794 | -122.49561239995701 | (37.7642133114728, -122.495612399957) | |||
| 138114 | 138114 | 220192 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 5ft | 6003556.22665 | 2095685.5144599997 | 37.7345547247094 | -122.430120878078 | (37.7345547247094, -122.430120878078) | |||
| 146855 | 146855 | 186915 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985160.3793 | 2096738.0161 | 37.7363855555031 | -122.49379807923401 | (37.7363855555031, -122.493798079234) | |||
| 150808 | 150808 | 184875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984644.1243 | 2106811.5248 | 37.764014425890394 | -122.496326010311 | (37.7640144258904, -122.496326010311) | |||
| 157545 | 157545 | 187378 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985080.0311 | 2100042.6945 | 37.745454611339504 | -122.494319389248 | (37.7454546113395, -122.494319389248) | |||
| 29694 | 29694 | 186789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984864.8488 | 2106874.8662 | 37.7642012710686 | -122.495567273023 | (37.7642012710686, -122.495567273023) | |||
| 156817 | 156817 | 186913 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985168.1725 | 2096717.3871 | 37.7363293697196 | -122.493769615567 | (37.7363293697196, -122.493769615567) | |||
| 179664 | 179664 | 184874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984695.3865 | 2106820.2584 | 37.7640414086876 | -122.496149356564 | (37.7640414086876, -122.496149356564) | |||
| 42429 | 42429 | 186912 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985181.9251 | 2096714.1782 | 37.736321363521796 | -122.493721831405 | (37.7363213635218, -122.493721831405) | |||
| 50308 | 50308 | 181501 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984882.2605 | 2105466.1502 | 37.7603343510083 | -122.495403150426 | (37.7603343510083, -122.495403150426) | |||
| 165781 | 165781 | 186788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.1597 | 2106871.2408 | 37.7641905736904 | -122.495610892905 | (37.7641905736904, -122.495610892905) | |||
| 67384 | 67384 | 181500 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984893.9566 | 2105458.3528 | 37.760313626354105 | -122.49536212461099 | (37.7603136263541, -122.495362124611) | |||
| 159541 | 159541 | 184871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984661.2117 | 2106828.9919 | 37.7640633865909 | -122.496268199792 | (37.7640633865909, -122.496268199792) | |||
| 172587 | 172587 | 184870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984657.0348 | 2106822.5367 | 37.7640454177531 | -122.496282169928 | (37.7640454177531, -122.496282169928) | |||
| 42608 | 42608 | 184797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984676.0208 | 2105815.7109 | 37.761282068862 | -122.496142217022 | (37.761282068862, -122.496142217022) | |||
| 182639 | 182639 | 187196 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2301 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984952.6117 | 2099047.6172 | 37.7427149412723 | -122.49468663060101 | (37.7427149412723, -122.494686630601) | |||
| 138203 | 138203 | 186787 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984857.5979 | 2106862.4359999998 | 37.7641667166364 | -122.495591434544 | (37.7641667166364, -122.495591434544) | |||
| 147407 | 147407 | 188588 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 57 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | ||||
| 184990 | 184990 | 221388 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 671 Church St | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 3ft | 6004298.752230001 | 2105308.1718200003 | 37.7610183389455 | -122.428239289531 | (37.7610183389455, -122.428239289531) | |||
| 73850 | 73850 | 184867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.0111 | 2106821.7773 | 37.7640420425175 | -122.496358286248 | (37.7640420425175, -122.496358286248) | |||
| 63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
| 153394 | 153394 | 185996 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984845.7236 | 2100974.1524 | 37.7479984261704 | -122.495198251611 | (37.7479984261704, -122.495198251611) | |||
| 35947 | 35947 | 184865 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.3908 | 2106835.0674 | 37.7640785556344 | -122.49635795369 | (37.7640785556344, -122.49635795369) | |||
| 163857 | 163857 | 184864 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984647.1621 | 2106835.0674 | 37.7640792451971 | -122.496317240818 | (37.7640792451971, -122.496317240818) | |||
| 23851 | 23851 | 200603 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.38560931762301 | (37.733790555057, -122.385609317623) | |||
| 25539 | 25539 | 185720 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5984894.4324 | 2100359.2446 | 37.7463129086346 | -122.494984487249 | (37.7463129086346, -122.494984487249) | |||
| 27415 | 27415 | 185199 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2500 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985167.8879 | 2097938.3372 | 37.739681755184705 | -122.49386054871201 | (37.7396817551847, -122.493860548712) | |||
| 56071 | 56071 | 184863 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984668.8061 | 2106833.1689 | 37.764075300319 | -122.496242241592 | (37.764075300319, -122.496242241592) | |||
| 185892 | 185892 | 187116 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985139.0056 | 2097294.5581 | 37.7379124205271 | -122.493912978366 | (37.7379124205271, -122.493912978366) | |||
| 72616 | 72616 | 188650 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014234.97615 | 2095377.1002900002 | 37.734306916536 | -122.39317901359699 | (37.734306916536, -122.393179013597) | ||||
| 137314 | 137314 | 200611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | |||
| 155834 | 155834 | 184862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984672.6033 | 2106838.8646 | 37.764091161536996 | -122.496229528652 | (37.764091161537, -122.496229528652) | |||
| 59915 | 59915 | 200610 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.733836134681795 | -122.385618942498 | (37.7338361346818, -122.385618942498) | |||
| 69580 | 69580 | 188649 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.734213959905205 | -122.393020304839 | (37.7342139599052, -122.393020304839) | |||
| 176885 | 176885 | 184861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984691.2095 | 2106834.308 | 37.7640797402699 | -122.496164839998 | (37.7640797402699, -122.496164839998) | |||
| 31867 | 31867 | 184860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984687.0326 | 2106838.4849 | 37.7640909641996 | -122.496179594648 | (37.7640909641996, -122.496179594648) | |||
| 44040 | 44040 | 185717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984895.0862 | 2100394.2234 | 37.746408989169105 | -122.494984805259 | (37.7464089891691, -122.494984805259) |
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");