Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189078 | 189078 | 187940 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.39176144464899 | (37.7891719160015, -122.391761444649) | ||||
| 188625 | 188625 | 96283 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3229 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58766 | 6011911.44714 | 2090686.2999099998 | 37.721297592691 | -122.40088279510599 | (37.721297592691, -122.400882795106) | |
| 188610 | 188610 | 220464 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1900 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009491.007180001 | 2105849.8478099997 | 37.762798078402795 | -122.410319710493 | (37.7627980784028, -122.410319710493) | |||
| 188605 | 188605 | 220425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009445.91202 | 2107658.57784 | 37.767761908016205 | -122.41060341331399 | (37.7677619080162, -122.410603413314) | |||
| 187818 | 187818 | 81723 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014945.424980001 | 2104137.64024 | 37.7584009709475 | -122.39133494566201 | (37.7584009709475, -122.391334945662) | ||
| 187239 | 187239 | 220477 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 851 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998019.7394900005 | 2107271.17336 | 37.766050965816895 | -122.45009705375601 | (37.7660509658169, -122.450097053756) | |||
| 187201 | 187201 | 112596 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001324.7675 | 2112728.8365 | 37.7812249111251 | -122.439056830439 | (37.7812249111251, -122.439056830439) | |||
| 187187 | 187187 | 175134 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1447 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002380.17476 | 2093694.6098 | 37.72902147586029 | -122.434044607568 | (37.7290214758603, -122.434044607568) | |||
| 186987 | 186987 | 220459 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009533.63521 | 2106182.62398 | 37.763714195267205 | -122.410195770427 | (37.7637141952672, -122.410195770427) | |||
| 186986 | 186986 | 187899 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015181.09261 | 2100903.60273 | 37.7495340665546 | -122.39029394621201 | (37.7495340665546, -122.390293946212) | |||
| 185558 | 185558 | 220438 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6009797.76242 | 2100932.26628 | 37.749312693037 | -122.40891177146001 | (37.749312693037, -122.40891177146) | |||
| 184899 | 184899 | 203425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994247.20035 | 2096642.9024 | 37.7366518402943 | -122.46237446791099 | (37.7366518402943, -122.462374467911) | |||
| 184227 | 184227 | 220410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1504 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009388.45377 | 2107723.64208 | 37.7679373378588 | -122.410806750933 | (37.7679373378588, -122.410806750933) | |||
| 183883 | 183883 | 187930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6015248.50297 | 2115743.86859 | 37.790285912521 | -122.391097985077 | (37.790285912521, -122.391097985077) | |||
| 183186 | 183186 | 112594 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001343.2115 | 2112635.4321 | 37.7809694958311 | -122.438986327521 | (37.7809694958311, -122.438986327521) | |||
| 183183 | 183183 | 187866 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015120.62012 | 2100986.30773 | 37.7497578025782 | -122.390508841934 | (37.7497578025782, -122.390508841934) | |||
| 182547 | 182547 | 30769 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1642 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 7 | Permit Number 34649 | 6014556.9626 | 2093085.2912 | 37.7280319553097 | -122.391905589486 | (37.7280319553097, -122.391905589486) | |
| 182448 | 182448 | 140603 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 827 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003831.5032 | 2111426.0587 | 37.77779011925529 | -122.430291791287 | (37.7777901192553, -122.430291791287) | |||
| 182424 | 182424 | 187945 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015129.7605099995 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | ||||
| 182395 | 182395 | 140747 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001275.0195 | 2113083.841 | 37.7821968322814 | -122.43925438646299 | (37.7821968322814, -122.439254386463) | |||
| 182213 | 182213 | 125408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 830 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006361.841019999 | 2113219.81406 | 37.7828583334858 | -122.42166589828001 | (37.7828583334858, -122.42166589828) | |||
| 182191 | 182191 | 189100 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015967.06592 | 2097626.12065 | 37.7405783424142 | -122.38734740115801 | (37.7405783424142, -122.387347401158) | |||
| 181583 | 181583 | 187905 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011979.98788 | 2114548.14877 | 37.786820829172704 | -122.402322770701 | (37.7868208291727, -122.402322770701) | |||
| 181437 | 181437 | 220405 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1730 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6009447.51093 | 2106617.76818 | 37.7649041737225 | -122.410524378206 | (37.7649041737225, -122.410524378206) | |||
| 181067 | 181067 | 220488 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 4276 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6000665.21266 | 2102890.6244900003 | 37.754174080892795 | -122.44063268295 | (37.7541740808928, -122.44063268295) | |||
| 181050 | 181050 | 220417 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009481.38524 | 2107076.14024 | 37.7661646571972 | -122.41043958382099 | (37.7661646571972, -122.410439583821) | |||
| 180567 | 180567 | 141986 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1067 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004102.6078 | 2111812.2185 | 37.778865770833505 | -122.429381491168 | (37.7788657708335, -122.429381491168) | |||
| 180234 | 180234 | 247518 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001762.8451 | 2109678.405 | 37.7728741096846 | -122.437322810858 | (37.7728741096846, -122.437322810858) | |||
| 179995 | 179995 | 137750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209408995 | -122.43867130831 | (37.779356209409, -122.43867130831) | |||
| 179748 | 179748 | 81721 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014944.54926 | 2104094.31483 | 37.7582819600733 | -122.39133494567301 | (37.7582819600733, -122.391334945673) | ||
| 178826 | 178826 | 187900 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6015174.133909999 | 2101026.33165 | 37.749870668392504 | -122.390326583523 | (37.7498706683925, -122.390326583523) | |||
| 178645 | 178645 | 247510 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001703.2636 | 2110010.3317 | 37.7737821102395 | -122.43755268459299 | (37.7737821102395, -122.437552684593) | |||
| 178382 | 178382 | 247517 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001820.5087 | 2109214.383 | 37.771603298669 | -122.437090117747 | (37.771603298669, -122.437090117747) | |||
| 178281 | 178281 | 187871 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015124.4326599995 | 2100904.6710900003 | 37.7495338570216 | -122.39048995434601 | (37.7495338570216, -122.390489954346) | |||
| 177988 | 177988 | 220462 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1890 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009480.1125300005 | 2106070.9553400003 | 37.7634045784729 | -122.410373004307 | (37.7634045784729, -122.410373004307) | |||
| 177808 | 177808 | 112591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 3x3 | 6001352.6873 | 2112575.8699 | 37.7808064923129 | -122.438949276348 | (37.7808064923129, -122.438949276348) | |||
| 177732 | 177732 | 123077 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.47034576378599 | (37.774559431962, -122.470345763786) | |||
| 177676 | 177676 | 189062 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011094.42559 | 2108729.00589 | 37.7707933445767 | -122.404976750984 | (37.7707933445767, -122.404976750984) | |||
| 177449 | 177449 | 247507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | |||
| 177296 | 177296 | 187914 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013751.11841 | 2115368.97395 | 37.7891733324224 | -122.39625257892 | (37.7891733324224, -122.39625257892) | |||
| 177269 | 177269 | 175145 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6009104.5146 | 2093704.4733799999 | 37.729427890284704 | -122.41079865433201 | (37.7294278902847, -122.410798654332) | |||
| 177219 | 177219 | 187863 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014779.35542 | 2103919.85891 | 37.7577937720836 | -122.391894064084 | (37.7577937720836, -122.391894064084) | |||
| 176685 | 176685 | 187934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | |||
| 176178 | 176178 | 141591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001556.326 | 2111042.9577 | 37.776609086888 | -122.438134950627 | (37.776609086888, -122.438134950627) | |||
| 176057 | 176057 | 139863 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 716 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005598.3619 | 2112075.4809 | 37.7796731941675 | -122.42422580803002 | (37.7796731941675, -122.42422580803) | |||
| 176053 | 176053 | 189085 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011651.36739 | 2112788.81807 | 37.781971770130795 | -122.403335914547 | (37.7819717701308, -122.403335914547) | |||
| 176021 | 176021 | 187933 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015208.90661 | 2115787.01653 | 37.7904021894671 | -122.391238004144 | (37.7904021894671, -122.391238004144) | |||
| 175992 | 175992 | 220408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1340 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009370.35107 | 2108002.56697 | 37.7687021860891 | -122.41088906857901 | (37.7687021860891, -122.410889068579) | |||
| 175947 | 175947 | 203418 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993705.93526 | 2097033.15738 | 37.7376922003421 | -122.464274164331 | (37.7376922003421, -122.464274164331) | |||
| 175529 | 175529 | 220429 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009431.37889 | 2107954.66245 | 37.7685740731712 | -122.41067459375499 | (37.7685740731712, -122.410674593755) | |||
| 174445 | 174445 | 187881 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 17 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015141.96127 | 2100582.57644 | 37.748650425082005 | -122.39040683722601 | (37.748650425082, -122.390406837226) | |||
| 174214 | 174214 | 141990 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 780 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004028.4702 | 2111508.2869 | 37.778027052231394 | -122.42961628033301 | (37.7780270522314, -122.429616280333) | |||
| 174027 | 174027 | 137752 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001393.9748 | 2112237.1097 | 37.7798786918075 | -122.43878216092399 | (37.7798786918075, -122.438782160924) | |||
| 173970 | 173970 | 220426 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1501 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009442.98316 | 2107699.97849 | 37.767875420442294 | -122.410616467889 | (37.7678754204423, -122.410616467889) | |||
| 173706 | 173706 | 203398 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1898 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993787.6735 | 2102657.11631 | 37.753138881175 | -122.464399769949 | (37.753138881175, -122.464399769949) | |||
| 173360 | 173360 | 137725 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001532.7277 | 2111225.9053 | 37.7771100728165 | -122.438229692976 | (37.7771100728165, -122.438229692976) | |||
| 173013 | 173013 | 109047 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012842995 | -122.44235909620701 | (37.802017012843, -122.442359096207) | ||||
| 172488 | 172488 | 247421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 541 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003124.7415 | 2110178.9182 | 37.7743257229582 | -122.43264761463101 | (37.7743257229582, -122.432647614631) | |||
| 172170 | 172170 | 137762 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001439.6617 | 2111903.7642 | 37.7789660085719 | -122.438600218498 | (37.7789660085719, -122.438600218498) | |||
| 171758 | 171758 | 220443 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2579 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009781.64625 | 2102389.48256 | 37.75331298272479 | -122.40907031025499 | (37.7533129827248, -122.409070310255) | |||
| 171730 | 171730 | 203413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993820.42059 | 2102181.53499 | 37.7518349442394 | -122.464252000534 | (37.7518349442394, -122.464252000534) | |||
| 171631 | 171631 | 187872 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015125.026930001 | 2100883.99929 | 37.7494771295685 | -122.390486455093 | (37.7494771295685, -122.390486455093) | |||
| 171213 | 171213 | 141981 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 961 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004347.2458 | 2111841.6916 | 37.778960543925706 | -122.42853729271098 | (37.7789605439257, -122.428537292711) | |||
| 171189 | 171189 | 220432 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1650 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006509.92654 | 2099814.31154 | 37.7460583262406 | -122.420201864026 | (37.7460583262406, -122.420201864026) | |||
| 171009 | 171009 | 220470 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009551.6866 | 2096070.2477900002 | 37.7359488645495 | -122.409419625821 | (37.7359488645495, -122.409419625821) | |||
| 170700 | 170700 | 247515 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001817.1167 | 2109233.3781 | 37.7716552616846 | -122.437103211063 | (37.7716552616846, -122.437103211063) | |||
| 170239 | 170239 | 59325 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 345 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/1990 12:00:00 AM | 12 | Permit Number 29282 | 6006158.21098 | 2111403.55582 | 37.7778598467005 | -122.42224129259701 | (37.7778598467005, -122.422241292597) | ||
| 170038 | 170038 | 220474 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005470.47971 | 2102115.81456 | 37.7523191005603 | -122.423959772048 | (37.7523191005603, -122.423959772048) | |||
| 169901 | 169901 | 220435 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2680 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009751.75361 | 2101774.10517 | 37.7516216187644 | -122.409130266252 | (37.7516216187644, -122.409130266252) | |||
| 169888 | 169888 | 88172 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011709.51547 | 2112571.62711 | 37.7813786618321 | -122.403119465684 | (37.7813786618321, -122.403119465684) | |
| 169743 | 169743 | 137744 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001369.6084 | 2112388.3842 | 37.7802926669324 | -122.43887729860701 | (37.7802926669324, -122.438877298607) | |||
| 169734 | 169734 | 189064 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013706.30121 | 2112357.56717 | 37.7809022100091 | -122.39619650258801 | (37.7809022100091, -122.396196502588) | |||
| 169731 | 169731 | 187902 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 47 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6013611.03319 | 2115912.70701 | 37.790658500748 | -122.39677539438101 | (37.790658500748, -122.396775394381) | |||
| 169424 | 169424 | 220424 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009448.223730001 | 2107633.16245 | 37.7676922528232 | -122.41059362239099 | (37.7676922528232, -122.410593622391) | |||
| 168315 | 168315 | 220416 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009481.587040001 | 2107055.98222 | 37.766109319220206 | -122.410437462315 | (37.7661093192202, -122.410437462315) | |||
| 168192 | 168192 | 137721 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001519.5293 | 2111318.2945 | 37.7773629996088 | -122.438281970677 | (37.7773629996088, -122.438281970677) | |||
| 167748 | 167748 | 203403 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779896995 | -122.461902813967 | (37.736316779897, -122.461902813967) | |||
| 167597 | 167597 | 189091 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1433 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6016333.586630001 | 2097354.23847 | 37.739852101202004 | -122.38606115391 | (37.739852101202, -122.38606115391) | |||
| 167179 | 167179 | 220466 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2044 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009529.8002 | 2105117.4753400004 | 37.7607893248 | -122.410133830538 | (37.7607893248, -122.410133830538) | |||
| 167105 | 167105 | 189081 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011852.23142 | 2112709.4214 | 37.781764981806795 | -122.4026354281 | (37.7817649818068, -122.4026354281) | |||
| 166947 | 166947 | 189083 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011822.07431 | 2112680.25228 | 37.7816832064575 | -122.402737706174 | (37.7816832064575, -122.402737706174) | |||
| 166919 | 166919 | 187916 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013874.567969999 | 2115495.81816 | 37.7895284855 | -122.395834347372 | (37.7895284855, -122.395834347372) | |||
| 166881 | 166881 | 220441 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009797.097580001 | 2102115.80725 | 37.75256239684371 | -122.408997567676 | (37.7525623968437, -122.408997567676) | |||
| 166765 | 166765 | 123540 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 27 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994225.0963 | 2115400.2579200002 | 37.788153386103204 | -122.463811955609 | (37.7881533861032, -122.463811955609) | |||
| 166396 | 166396 | 141322 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001602.5949 | 2110732.7849 | 37.7757600616344 | -122.43795267106701 | (37.7757600616344, -122.437952671067) | |||
| 166093 | 166093 | 141605 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001571.749 | 2110948.7063 | 37.776351173378 | -122.438074845035 | (37.776351173378, -122.438074845035) | |||
| 165972 | 165972 | 112593 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001345.5805 | 2112610.0505 | 37.7808999391999 | -122.43897631246901 | (37.7808999391999, -122.438976312469) | |||
| 165831 | 165831 | 139861 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 710 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005666.4072 | 2112084.3112 | 37.779701281894205 | -122.42399103767299 | (37.7797012818942, -122.423991037673) | |||
| 165796 | 165796 | 187862 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014817.13681 | 2103921.30652 | 37.7577998442984 | -122.391763500508 | (37.7577998442984, -122.391763500508) | |||
| 165495 | 165495 | 137770 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001464.705 | 2111708.8332 | 37.778432201915 | -122.43849961368099 | (37.778432201915, -122.438499613681) | |||
| 165470 | 165470 | 220440 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2831 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009868.71469 | 2100872.67042 | 37.7491530301063 | -122.408662212302 | (37.7491530301063, -122.408662212302) | |||
| 165256 | 165256 | 49372 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005157.82583 | 2086153.99564 | 37.708473828664204 | -122.42390605733999 | (37.7084738286642, -122.42390605734) | |||
| 165225 | 165225 | 137749 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | |||
| 165105 | 165105 | 220486 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 80 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005005.11226 | 2096160.1953200002 | 37.73594004669339 | -122.42514535727899 | (37.7359400466934, -122.425145357279) | |||
| 165085 | 165085 | 189090 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1433 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016367.14346 | 2097329.17086 | 37.7397851277689 | -122.385943380483 | (37.7397851277689, -122.385943380483) | |||
| 163969 | 163969 | 187946 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015145.56326 | 2115239.56325 | 37.788895493169896 | -122.391418882079 | (37.7888954931699, -122.391418882079) | ||||
| 163928 | 163928 | 187917 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013888.85856 | 2115506.90932 | 37.7895597342357 | -122.395785680575 | (37.7895597342357, -122.395785680575) | |||
| 163804 | 163804 | 187932 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015226.56568 | 2115767.0795400003 | 37.790348427077106 | -122.39117551026101 | (37.7903484270771, -122.391175510261) | |||
| 163783 | 163783 | 187938 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 235 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6014012.10729 | 2114977.49045 | 37.7881129283138 | -122.395322147516 | (37.7881129283138, -122.395322147516) | |||
| 163683 | 163683 | 137745 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001366.2242 | 2112409.7048 | 37.7803510153457 | -122.438890534421 | (37.7803510153457, -122.438890534421) |
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");