Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189119 | 189119 | 192323 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6011703.7817400005 | 2107812.61007 | 37.7683111734485 | -122.402804504224 | (37.7683111734485, -122.402804504224) | |||
| 189108 | 189108 | 192278 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009081.35576 | 2108813.05858 | 37.770911398573205 | -122.411945967131 | (37.7709113985732, -122.411945967131) | |||
| 188995 | 188995 | 192310 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011946.18566 | 2107352.67758 | 37.76706183436821 | -122.40193371137501 | (37.7670618343682, -122.401933711375) | |||
| 188952 | 188952 | 192296 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.762396094938104 | -122.406134800806 | (37.7623960949381, -122.406134800806) | |||
| 188795 | 188795 | 192219 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009481.185869999 | 2108795.76031 | 37.770886325461504 | -122.410561717149 | (37.7708863254615, -122.410561717149) | |||
| 188482 | 188482 | 192215 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009439.261530001 | 2108838.29328 | 37.77100076061021 | -122.410709739261 | (37.7710007606102, -122.410709739261) | |||
| 188474 | 188474 | 218968 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5993617.45125 | 2101661.58733 | 37.7503955999976 | -122.464916133678 | (37.7503955999976, -122.464916133678) | |||
| 188237 | 188237 | 244215 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997712.0535 | 2108841.8253 | 37.7703459631123 | -122.451274559097 | (37.7703459631123, -122.451274559097) | |||
| 187664 | 187664 | 218966 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 255 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992657.85366 | 2095112.0231700002 | 37.7323567798226 | -122.467758171218 | (37.7323567798226, -122.467758171218) | |||
| 187202 | 187202 | 225803 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 378 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001778.51091 | 2103657.66309 | 37.7563435190568 | -122.43683753583099 | (37.7563435190568, -122.436837535831) | |||
| 186917 | 186917 | 192345 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007899.18679 | 2110450.27855 | 37.775340422048394 | -122.41615110171301 | (37.7753404220484, -122.416151101713) | |||
| 186884 | 186884 | 192227 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009609.32047 | 2108657.10894 | 37.7705128037596 | -122.41010870437799 | (37.7705128037596, -122.410108704378) | |||
| 186614 | 186614 | 247293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1187 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999369.2896 | 2108822.0623 | 37.7703864492561 | -122.445540779928 | (37.7703864492561, -122.445540779928) | |||
| 186545 | 186545 | 75860 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 9 | 6011761.31231 | 2118758.70866 | 37.7983698131588 | -122.40337566547701 | (37.7983698131588, -122.403375665477) | ||
| 186425 | 186425 | 192241 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009464.70125 | 2108402.9741599998 | 37.7698069016093 | -122.41059099638599 | (37.7698069016093, -122.410590996386) | |||
| 186119 | 186119 | 192210 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009362.83863 | 2108918.5244 | 37.771216771459706 | -122.410979757131 | (37.7712167714597, -122.410979757131) | |||
| 186100 | 186100 | 225815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 815 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 6001846.90883 | 2108236.07795 | 37.768918616038 | -122.43692874956301 | (37.768918616038, -122.436928749563) | |||
| 184629 | 184629 | 225785 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 96 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005776.35688 | 2103464.45432 | 37.7560394169139 | -122.422997844584 | (37.7560394169139, -122.422997844584) | |||
| 183829 | 183829 | 218974 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5995324.88397 | 2091369.23318 | 37.7222336187729 | -122.458266889107 | (37.7222336187729, -122.458266889107) | |||
| 183667 | 183667 | 225780 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007669.1739300005 | 2105574.3226 | 37.76193925642529 | -122.41660128882401 | (37.7619392564253, -122.416601288824) | |||
| 183653 | 183653 | 30522 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 25 | Permit Number 34528 | 6008488.127169999 | 2112769.36057 | 37.781741165964704 | -122.414277931689 | (37.7817411659647, -122.414277931689) | |
| 182467 | 182467 | 192331 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007941.721940001 | 2110498.34035 | 37.775474779871395 | -122.41600736667401 | (37.7754747798714, -122.416007366674) | |||
| 181842 | 181842 | 225802 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 372 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001775.08554 | 2103686.11524 | 37.75642144712079 | -122.436851418666 | (37.7564214471208, -122.436851418666) | |||
| 181341 | 181341 | 192236 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009533.94871 | 2108466.41752 | 37.7699849844405 | -122.41035595047899 | (37.7699849844405, -122.410355950479) | |||
| 181150 | 181150 | 57868 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1999 12:00:00 AM | 7 | Permit Number 16812 | 6008032.73051 | 2113659.8813099996 | 37.784160729883205 | -122.41591647488801 | (37.7841607298832, -122.415916474888) | |
| 181015 | 181015 | 192314 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011714.34761 | 2107590.0026599998 | 37.767700533789395 | -122.402752300399 | (37.7677005337894, -122.402752300399) | |||
| 180754 | 180754 | 192285 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009183.75419 | 2108910.9438099996 | 37.771185913038 | -122.411598684054 | (37.771185913038, -122.411598684054) | |||
| 180692 | 180692 | 225809 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002900.20105 | 2107141.3628 | 37.765972605181204 | -122.433207255136 | (37.7659726051812, -122.433207255136) | |||
| 179474 | 179474 | 192289 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009238.64118 | 2108962.03516 | 37.771329276649105 | -122.411412437151 | (37.7713292766491, -122.411412437151) | |||
| 179390 | 179390 | 218976 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 208 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000663.81639 | 2094977.92785 | 37.73244761315671 | -122.440070159711 | (37.7324476131567, -122.440070159711) | |||
| 179125 | 179125 | 124030 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991790.3652800005 | 2114364.58828 | 37.78516912121479 | -122.47216010553801 | (37.7851691212148, -122.472160105538) | |||
| 178887 | 178887 | 225808 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 67 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6003135.1243900005 | 2107389.8867200003 | 37.766668315309 | -122.43241245589199 | (37.766668315309, -122.432412455892) | |||
| 178248 | 178248 | 192235 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009557.26279 | 2108491.22918 | 37.7700544184084 | -122.410277059238 | (37.7700544184084, -122.410277059238) | |||
| 177737 | 177737 | 192282 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009136.7517800005 | 2108866.0128099998 | 37.7710599063301 | -122.41175809248101 | (37.7710599063301, -122.411758092481) | |||
| 177456 | 177456 | 225383 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 464 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002919.07295 | 2099218.44031 | 37.744219217150395 | -122.432576000288 | (37.7442192171504, -122.432576000288) | |||
| 177223 | 177223 | 192288 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009225.94574 | 2108950.58791 | 37.7712971330939 | -122.411455542555 | (37.7712971330939, -122.411455542555) | |||
| 177143 | 177143 | 64058 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 3700 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1987 12:00:00 AM | 5 | Permit Number 24817 | 5987163.87734 | 2111884.56933 | 37.7780908722437 | -122.48798381967501 | (37.7780908722437, -122.487983819675) | ||
| 176581 | 176581 | 225385 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004766.71932 | 2101872.10114 | 37.7516101631948 | -122.42637613885701 | (37.7516101631948, -122.426376138857) | |||
| 176443 | 176443 | 192242 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009444.52854 | 2108382.3130900003 | 37.7697490401119 | -122.41065931427299 | (37.7697490401119, -122.410659314273) | |||
| 175865 | 175865 | 192254 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009288.060869999 | 2108377.0794900004 | 37.7697258960749 | -122.411200163874 | (37.7697258960749, -122.411200163874) | |||
| 175310 | 175310 | 120475 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2153 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5988722.30623 | 2114650.7724599997 | 37.7857768742694 | -122.48279549106701 | (37.7857768742694, -122.482795491067) | |||
| 175214 | 175214 | 192301 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011807.32161 | 2102351.9134 | 37.753323095606106 | -122.402062424168 | (37.7533230956061, -122.402062424168) | |||
| 175184 | 175184 | 225800 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 839 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6003765.43327 | 2103426.88271 | 37.755822575974705 | -122.429949607592 | (37.7558225759747, -122.429949607592) | |||
| 174637 | 174637 | 192342 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007873.4377 | 2110478.3105900004 | 37.775415943530604 | -122.41624215986099 | (37.7754159435306, -122.416242159861) | |||
| 174316 | 174316 | 120304 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988688.31832 | 2114612.7837400003 | 37.7856705904605 | -122.482910293069 | (37.7856705904605, -122.482910293069) | |||
| 174228 | 174228 | 192222 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009520.501130001 | 2108752.11009 | 37.7707686761527 | -122.410422641486 | (37.7707686761527, -122.410422641486) | |||
| 174186 | 174186 | 225782 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007716.52666 | 2105576.00343 | 37.761946534627 | -122.416437632899 | (37.761946534627, -122.416437632899) | |||
| 173864 | 173864 | 225381 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1643 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006512.204919999 | 2107283.08365 | 37.7665659760752 | -122.42072411023001 | (37.7665659760752, -122.42072411023) | |||
| 173132 | 173132 | 192225 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009566.76232 | 2108703.16706 | 37.770636883201206 | -122.41025916634399 | (37.7706368832012, -122.410259166344) | |||
| 172999 | 172999 | 83898 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 661 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50511 | 6001665.34461 | 2093208.93849 | 37.7276473387373 | -122.436481078764 | (37.7276473387373, -122.436481078764) | |
| 172597 | 172597 | 128817 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008554.10037 | 2112777.08556 | 37.7817660825767 | -122.414050241334 | (37.7817660825767, -122.414050241334) | |||
| 172557 | 172557 | 218973 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 550 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997760.19795 | 2094413.18303 | 37.7307312291661 | -122.450067916609 | (37.7307312291661, -122.450067916609) | |||
| 171787 | 171787 | 192338 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 59 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007624.10398 | 2110832.2606 | 37.7763737826504 | -122.417129752033 | (37.7763737826504, -122.417129752033) | |||
| 171215 | 171215 | 44078 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2000 12:00:00 AM | 16 | Permit Number 43599 | 6012239.93104 | 2118827.2823900003 | 37.7985848203962 | -122.40172431143401 | (37.7985848203962, -122.401724311434) | |
| 170242 | 170242 | 192294 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010701.8989 | 2105624.20056 | 37.7622463056326 | -122.40611574324 | (37.7622463056326, -122.40611574324) | |||
| 169673 | 169673 | 192233 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009583.6177 | 2108515.2759 | 37.7701219224206 | -122.41018759559401 | (37.7701219224206, -122.410187595594) | |||
| 169637 | 169637 | 192234 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009571.19084 | 2108505.46163 | 37.7700942781462 | -122.410229887119 | (37.7700942781462, -122.410229887119) | |||
| 169012 | 169012 | 192341 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007845.7339699995 | 2110504.26388 | 37.7754856472738 | -122.416339832511 | (37.7754856472738, -122.416339832511) | |||
| 168681 | 168681 | 192277 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009066.01772 | 2108798.85518 | 37.7708715388111 | -122.411998018109 | (37.7708715388111, -122.411998018109) | |||
| 168557 | 168557 | 192332 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007926.51606 | 2110514.48292 | 37.7755182485986 | -122.416061111038 | (37.7755182485986, -122.416061111038) | |||
| 168506 | 168506 | 192326 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6011698.18772 | 2107878.52746 | 37.7684918553317 | -122.40282849005699 | (37.7684918553317, -122.402828490057) | |||
| 168395 | 168395 | 225816 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 220 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000887.34044 | 2106474.16774 | 37.7640262618211 | -122.440121464252 | (37.7640262618211, -122.440121464252) | |||
| 168265 | 168265 | 225805 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 367 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001818.89494 | 2103707.75244 | 37.7564833474558 | -122.436701459403 | (37.7564833474558, -122.436701459403) | |||
| 167643 | 167643 | 192230 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009632.52889 | 2108561.57413 | 37.7702517881052 | -122.41002168056299 | (37.7702517881052, -122.410021680563) | |||
| 166725 | 166725 | 192284 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009171.26495 | 2108898.08726 | 37.771149911371204 | -122.41164097644699 | (37.7711499113712, -122.411640976447) | |||
| 166557 | 166557 | 192206 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009319.54279 | 2108962.9583900003 | 37.77133634892171 | -122.411132658949 | (37.7713363489217, -122.411132658949) | |||
| 166498 | 166498 | 128820 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6008600.12871 | 2112713.96294 | 37.7815953480768 | -122.413886537756 | (37.7815953480768, -122.413886537756) | |||
| 165124 | 165124 | 225801 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4201 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001928.34635 | 2105251.90853 | 37.7607294461137 | -122.43643345245 | (37.7607294461137, -122.43643345245) | |||
| 164652 | 164652 | 192352 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1040 Palou Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6017850.25276 | 2093091.0077 | 37.728229933050706 | -122.380520862443 | (37.7282299330507, -122.380520862443) | |||
| 163536 | 163536 | 192307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011941.53927 | 2107440.75625 | 37.7673034192378 | -122.40195597501001 | (37.7673034192378, -122.40195597501) | |||
| 163347 | 163347 | 218971 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 736 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997513.55349 | 2097982.45512 | 37.7405174763054 | -122.451177906656 | (37.7405174763054, -122.451177906656) | |||
| 163044 | 163044 | 192316 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011712.06819 | 2107638.3864700003 | 37.7678332575256 | -122.40276358778401 | (37.7678332575256, -122.402763587784) | |||
| 162836 | 162836 | 192328 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 237 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008484.68025 | 2109928.45568 | 37.7739405229657 | -122.414088812365 | (37.7739405229657, -122.414088812365) | |||
| 162556 | 162556 | 192253 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009298.19676 | 2108366.80418 | 37.769698250893605 | -122.411164378061 | (37.7696982508936, -122.411164378061) | |||
| 161289 | 161289 | 192251 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009321.461680001 | 2108343.14872 | 37.769634603179 | -122.41108223395901 | (37.769634603179, -122.411082233959) | |||
| 160879 | 160879 | 192245 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009401.17079 | 2108343.15985 | 37.7696391033908 | -122.410806522516 | (37.7696391033908, -122.410806522516) | |||
| 160677 | 160677 | 192347 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 134 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008123.05736 | 2110213.2209099997 | 37.7747021030553 | -122.415359893447 | (37.7747021030553, -122.415359893447) | |||
| 160485 | 160485 | 192212 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009404.47018 | 2108873.18774 | 37.771094621956294 | -122.410832548904 | (37.7710946219563, -122.410832548904) | |||
| 160266 | 160266 | 192202 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 10th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009124.54034 | 2109165.9585 | 37.7718828021889 | -122.411821530666 | (37.7718828021889, -122.411821530666) | |||
| 159958 | 159958 | 192246 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009392.3217400005 | 2108335.84797 | 37.769618530488295 | -122.410836614725 | (37.7696185304883, -122.410836614725) | |||
| 159013 | 159013 | 192201 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008912.071409999 | 2109388.51463 | 37.772481967387705 | -122.412572213639 | (37.7724819673877, -122.412572213639) | |||
| 158448 | 158448 | 192243 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009432.09679 | 2108372.2648 | 37.7697207528275 | -122.41070160579599 | (37.7697207528275, -122.410701605796) | |||
| 158326 | 158326 | 192198 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 313 10th St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008924.99319 | 2109468.55838 | 37.7727024739698 | -122.412533174959 | (37.7727024739698, -122.412533174959) | |||
| 158173 | 158173 | 45643 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 13 | Permit Number 44346 | 6011195.59877 | 2118453.88611 | 37.797501231757 | -122.40531173944599 | (37.797501231757, -122.405311739446) | ||
| 158058 | 158058 | 225799 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3965 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004086.71679 | 2101282.70984 | 37.7499533700549 | -122.428685663533 | (37.7499533700549, -122.428685663533) | |||
| 157090 | 157090 | 192208 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009341.19534 | 2108940.97548 | 37.771277203218396 | -122.4110562085 | (37.7712772032184, -122.4110562085) | |||
| 156923 | 156923 | 192312 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011718.3988 | 2107518.4291 | 37.767504235158704 | -122.402733253659 | (37.7675042351587, -122.402733253659) | |||
| 156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
| 155375 | 155375 | 192351 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008765.23275 | 2109539.84577 | 37.772889245185794 | -122.413090847292 | (37.7728892451858, -122.413090847292) | |||
| 155337 | 155337 | 192293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009269.83054 | 2108992.53867 | 37.7714147814913 | -122.411306706546 | (37.7714147814913, -122.411306706546) | |||
| 155272 | 155272 | 75920 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 12 | 6011822.33856 | 2118769.3001099997 | 37.7984023029841 | -122.403165240278 | (37.7984023029841, -122.403165240278) | ||
| 154365 | 154365 | 192265 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009141.52204 | 2108524.0703 | 37.77012127938921 | -122.411717426925 | (37.7701212793892, -122.411717426925) | |||
| 153786 | 153786 | 192287 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009214.87169 | 2108937.93629 | 37.771261773548204 | -122.41149295433998 | (37.7712617735482, -122.41149295434) | |||
| 153479 | 153479 | 192286 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009200.74698 | 2108925.5815 | 37.7712270578992 | -122.411540939462 | (37.7712270578992, -122.411540939462) | |||
| 152796 | 152796 | 225789 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 409 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997048.20072 | 2102795.35511 | 37.753705857856204 | -122.453134258532 | (37.7537058578562, -122.453134258532) | |||
| 152668 | 152668 | 192298 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2200 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011908.73866 | 2102359.4276900003 | 37.7533493881837 | -122.40171222904699 | (37.7533493881837, -122.401712229047) | |||
| 151890 | 151890 | 192390 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 233 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6014050.42421 | 2105956.49266 | 37.763345430981396 | -122.394557641045 | (37.7633454309814, -122.394557641045) | |||
| 151652 | 151652 | 192231 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009620.79732 | 2108551.27729 | 37.7702228578355 | -122.410061533137 | (37.7702228578355, -122.410061533137) | |||
| 151429 | 151429 | 192339 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 59 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007610.66005 | 2110846.20818 | 37.776411323063606 | -122.41717724703301 | (37.7764113230636, -122.417177247033) | |||
| 151326 | 151326 | 192217 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009459.542640001 | 2108818.21129 | 37.7709467572235 | -122.410638167623 | (37.7709467572235, -122.410638167623) |
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");