trees
3,965 rows where qSpecies_id = 70 sorted by PlotSize descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45528 | 123191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 571 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 9ft | 5993121.2243 | 2111602.66813 | 37.7776625670642 | -122.467354883235 | (37.7776625670642, -122.467354883235) | 11 | 6 | 2 | 54 | 11 | |||
| 57110 | 125268 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | 5 | 9 | 1 | 28858 | 32 | |||
| 99003 | 124644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Arguello Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 9ft | 5995537.35644 | 2115745.75128 | 37.7891775496077 | -122.459296819974 | (37.7891775496077, -122.459296819974) | 11 | 6 | 1 | 54 | 31 | |||
| 111441 | 123190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 575 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 9ft | 5993120.96689 | 2111576.90099 | 37.7775918025948 | -122.467353899584 | (37.7775918025948, -122.467353899584) | 11 | 6 | 2 | 54 | 11 | |||
| 163258 | 220153 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6 | Width 9ft | 6004145.42049 | 2095858.4508 | 37.735062921706 | -122.428096157927 | (37.735062921706, -122.428096157927) | 2 | 7 | 5 | 28861 | 2 | |||
| 183663 | 201376 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Fairfax Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6018269.69343 | 2095669.23069 | 37.7353323666994 | -122.379249829039 | (37.7353323666994, -122.379249829039) | 10 | 3 | 8 | 58 | 1 | |||
| 5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
| 13449 | 123516 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2750 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5994807.17299 | 2110239.19888 | 37.7740160273107 | -122.461423785316 | (37.7740160273107, -122.461423785316) | 11 | 6 | 2 | 54 | 11 | |||
| 20406 | 188744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6014566.93251 | 2086961.44697 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | 10 | 3 | 8 | 58 | 1 | |||
| 26532 | 123517 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2750 Fulton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 5994790.647 | 2110238.4346 | 37.7740129776239 | -122.461480895699 | (37.7740129776239, -122.461480895699) | 11 | 6 | 2 | 54 | 11 | |||
| 28393 | 175015 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 5 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6013189.92411 | 2087076.36729 | 37.7114566649583 | -122.39621055537 | (37.7114566649583, -122.39621055537) | 10 | 3 | 8 | 309 | 1 | |||
| 28824 | 188743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | 10 | 3 | 8 | 58 | 1 | |||
| 29177 | 187712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51x Executive Park Blvd | 3 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6013733.01886 | 2087017.85621 | 37.7113262093072 | -122.394329370613 | (37.7113262093072, -122.394329370613) | 10 | 3 | 8 | 58 | 1 | |||
| 31259 | 187699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 8 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | 10 | 3 | 8 | 58 | 1 | |||
| 39635 | 175016 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | Width 8ft | 6013191.1859 | 2087080.9939 | 37.7114694389303 | -122.396206518314 | (37.7114694389303, -122.396206518314) | 10 | 3 | 8 | 309 | 1 | |||
| 41461 | 203906 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990638.47075 | 2093500.44016 | 37.727814969685 | -122.47462199853 | (37.727814969685, -122.47462199853) | 9 | 8 | 4 | 64 | 40 | |||
| 53098 | 188733 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Executive Park Blvd | 1 | : | Tree | Private 2 | 8 | Width 8ft | 6014289.08954 | 2086985.67825 | 37.7112687498269 | -122.392405184751 | (37.7112687498269, -122.392405184751) | 10 | 3 | 8 | 58 | 1 | |||
| 61131 | 123515 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2744 Fulton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 5994816.13065 | 2110240.7885 | 37.7740209075455 | -122.461392914729 | (37.7740209075455, -122.461392914729) | 11 | 6 | 2 | 54 | 11 | |||
| 70466 | 187701 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 10 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 6014160.4254 | 2086993.65928 | 37.7112835184788 | -122.392850441814 | (37.7112835184788, -122.392850441814) | 10 | 3 | 8 | 58 | 1 | |||
| 74908 | 203780 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5995711.83898 | 2094094.29693 | 37.7297382193253 | -122.457126310455 | (37.7297382193253, -122.457126310455) | 9 | 7 | 4 | 28861 | 40 | |||
| 75672 | 188747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 15 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6014639.49411 | 2086953.6057 | 37.7112001369439 | -122.391191848221 | (37.7112001369439, -122.391191848221) | 10 | 3 | 8 | 58 | 1 | |||
| 78454 | 118056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 494 36th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5984738.41738 | 2112623.76679 | 37.7799787079086 | -122.49642879092 | (37.7799787079086, -122.49642879092) | 11 | 6 | 2 | 55 | 26 | |||
| 86216 | 188746 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 14 | Median : Yard | Tree | DPW 1 | 19 | Width 8ft | 6014613.42303 | 2086955.91765 | 37.7112050382485 | -122.391282118582 | (37.7112050382485, -122.391282118582) | 10 | 3 | 8 | 58 | 1 | |||
| 91179 | 188736 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 4 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6014364.73249 | 2086978.28388 | 37.7112526465696 | -122.39214322484 | (37.7112526465696, -122.39214322484) | 10 | 3 | 8 | 58 | 1 | |||
| 93416 | 188737 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 5 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6014387.73209 | 2086976.03412 | 37.7112477461551 | -122.392063574599 | (37.7112477461551, -122.392063574599) | 10 | 3 | 8 | 58 | 1 | |||
| 93679 | 188742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 10 | Median : Yard | Tree | DPW 1 | 16 | Width 8ft | 6014513.51098 | 2086966.09658 | 37.7112274421761 | -122.391628153428 | (37.7112274421761, -122.391628153428) | 10 | 3 | 8 | 58 | 1 | |||
| 95832 | 203808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 335x Pacheco St | 30 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5994148.64523 | 2101441.50601 | 37.7498219260394 | -122.46306327486 | (37.7498219260394, -122.46306327486) | 1 | 8 | 4 | 29491 | 40 | |||
| 98072 | 188735 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 3 | Median : Yard | Tree | DPW 1 | 18 | Width 8ft | 6014342.21925 | 2086979.24909 | 37.7112540468105 | -122.392221104316 | (37.7112540468105, -122.392221104316) | 10 | 3 | 8 | 58 | 1 | |||
| 101254 | 175012 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6013182.79855 | 2087056.15726 | 37.7114007756959 | -122.396233767795 | (37.7114007756959, -122.396233767795) | 10 | 3 | 8 | 309 | 1 | |||
| 101464 | 175043 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 199 Shakespeare St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.7092485595475 | -122.464240538697 | (37.7092485595475, -122.464240538697) | 9 | 8 | 6 | 28861 | 25 | |||
| 103333 | 203807 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 335x Pacheco St | 20 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5994179.66762 | 2101287.15386 | 37.7493999011887 | -122.462944801787 | (37.7493999011887, -122.462944801787) | 1 | 8 | 4 | 29491 | 40 | |||
| 109405 | 188745 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 13 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6014589.91668 | 2086958.4326 | 37.711210639227 | -122.391363538721 | (37.711210639227, -122.391363538721) | 10 | 3 | 8 | 58 | 1 | |||
| 113579 | 203904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357 | (37.7272777533559, -122.47464379357) | 9 | 8 | 4 | 64 | 40 | |||
| 116338 | 188738 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 6 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6014415.87146 | 2086974.70005 | 37.7112456453465 | -122.391966223888 | (37.7112456453465, -122.391966223888) | 10 | 3 | 8 | 58 | 1 | |||
| 116972 | 125295 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1306x Montgomery St | 24 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6011445.95838 | 2119999.7387 | 37.8017597617706 | -122.40455429894 | (37.8017597617706, -122.40455429894) | 3 | 1 | 10 | 308 | 23 | |||
| 118307 | 188763 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 6 | Median : Yard | Tree | DPW 1 | 22 | Width 8ft | 6014060.27429 | 2087007.0702 | 37.7113147789343 | -122.393197529766 | (37.7113147789343, -122.393197529766) | 10 | 3 | 8 | 58 | 1 | |||
| 118510 | 201561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Jerrold Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 6019745.83299 | 2093765.29662 | 37.7301858218198 | -122.374014373583 | (37.7301858218198, -122.374014373583) | 10 | 3 | 8 | 58 | 1 | |||
| 123116 | 123510 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 8ft | 5994935.84099 | 2110268.05044 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | 11 | 6 | 2 | 54 | 11 | |||
| 123125 | 187700 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 9 | Median : Yard | Tree | DPW 1 | 18 | Width 8ft | 6014134.28387 | 2086999.7269 | 37.7112987269389 | -122.392941218475 | (37.7112987269389, -122.392941218475) | 10 | 3 | 8 | 58 | 1 | |||
| 125014 | 188761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 4 | Median : Yard | Tree | DPW 1 | 23 | Width 8ft | 6013991.40971 | 2087009.07901 | 37.7113164687655 | -122.39343568552 | (37.7113164687655, -122.39343568552) | 10 | 3 | 8 | 58 | 1 | |||
| 128569 | 187710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 1 | : | Tree | Private 2 | 2 | Width 8ft | 6013683.2298 | 2086994.45862 | 37.7112591963142 | -122.39449981823 | (37.7112591963142, -122.39449981823) | 10 | 3 | 8 | 58 | 1 | |||
| 130125 | 187713 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51x Executive Park Blvd | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013756.45463 | 2087023.92934 | 37.7113441876472 | -122.394248794959 | (37.7113441876472, -122.394248794959) | 10 | 3 | 8 | 58 | 1 | |||
| 149369 | 175013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6013185.59041 | 2087064.24232 | 37.7114231310315 | -122.396224684625 | (37.7114231310315, -122.396224684625) | 10 | 3 | 8 | 309 | 1 | |||
| 149838 | 187711 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51x Executive Park Blvd | 2 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 6013709.84578 | 2087009.99178 | 37.7113033269547 | -122.394408912955 | (37.7113033269547, -122.394408912955) | 10 | 3 | 8 | 58 | 1 | |||
| 153662 | 188764 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 7 | Median : Yard | Tree | DPW 1 | 22 | Width 8ft | 6014090.1968 | 2087004.61854 | 37.711309709434 | -122.393093937756 | (37.711309709434, -122.393093937756) | 10 | 3 | 8 | 58 | 1 | |||
| 159739 | 188734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6014314.36158 | 2086981.85227 | 37.7112596477808 | -122.392317570118 | (37.7112596477808, -122.392317570118) | 10 | 3 | 8 | 58 | 1 | |||
| 162002 | 188741 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 9 | Median : Yard | Tree | DPW 1 | 19 | Width 8ft | 6014489.73327 | 2086967.85233 | 37.7112309432358 | -122.391710458464 | (37.7112309432358, -122.391710458464) | 10 | 3 | 8 | 58 | 1 | |||
| 162299 | 203781 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Northwood Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 8ft | 5995760.05053 | 2094044.54603 | 37.7296043840153 | -122.456956041797 | (37.7296043840153, -122.456956041797) | 9 | 7 | 4 | 28861 | 40 | |||
| 167880 | 188760 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6013911.80932 | 2087014.99746 | 37.7113282966477 | -122.393711220721 | (37.7113282966477, -122.393711220721) | 10 | 3 | 8 | 58 | 1 | |||
| 170082 | 188762 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 5 | Median : Yard | Tree | DPW 1 | 28 | Width 8ft | 6014035.24999 | 2087007.26896 | 37.7113139344492 | -122.393284034653 | (37.7113139344492, -122.393284034653) | 10 | 3 | 8 | 58 | 1 | |||
| 178658 | 188740 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 8 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | 10 | 3 | 8 | 58 | 1 | |||
| 181074 | 123514 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2744 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 5994834.09227 | 2110246.18844 | 37.7740367681104 | -122.461331174398 | (37.7740367681104, -122.461331174398) | 11 | 6 | 2 | 54 | 11 | |||
| 183618 | 203902 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5002 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5990623.07246 | 2093226.54081 | 37.7270620185855 | -122.474655248248 | (37.7270620185855, -122.474655248248) | 9 | 8 | 4 | 64 | 40 | |||
| 187416 | 123185 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 591 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 5993121.76543 | 2111452.55215 | 37.7772504203411 | -122.46734209303 | (37.7772504203411, -122.46734209303) | 11 | 6 | 2 | 54 | 11 | |||
| 190199 | 175014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 8ft | 6013188.07866 | 2087071.75218 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | 10 | 3 | 8 | 309 | 1 | |||
| 191307 | 188739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 7 | Median : Yard | Tree | DPW 1 | 18 | Width 8ft | 6014439.36233 | 2086971.42049 | 37.7112379444543 | -122.391884803738 | (37.7112379444543, -122.391884803738) | 10 | 3 | 8 | 58 | 1 | |||
| 193975 | 203903 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5002 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990622.28371 | 2093237.14363 | 37.727091085566 | -122.474658748425 | (37.727091085566, -122.474658748425) | 9 | 8 | 4 | 64 | 40 | |||
| 23323 | 203284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 5999187.02892 | 2095000.6796 | 37.73242590082 | -122.445177379037 | (37.73242590082, -122.445177379037) | 9 | 7 | 4 | 59 | 40 | |||
| 45033 | 203285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999181.66056 | 2095001.81408 | 37.7324287094117 | -122.445196020186 | (37.7324287094117, -122.445196020186) | 9 | 7 | 4 | 59 | 40 | |||
| 51595 | 224778 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1379 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 7ft | 6005255.28133 | 2100266.52541 | 37.7472292273526 | -122.424572428891 | (37.7472292273526, -122.424572428891) | 2 | 7 | 5 | 28859 | 22 | |||
| 57112 | 122188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 7ft | 5991455.25466 | 2115068.89976 | 37.7870835661247 | -122.473370861161 | (37.7870835661247, -122.473370861161) | 11 | 6 | 1 | 61 | 33 | |||
| 66657 | 122193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 45 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 7ft | 5991455.48516 | 2114922.34945 | 37.7866811931032 | -122.473359370807 | (37.7866811931032, -122.473359370807) | 11 | 6 | 1 | 54 | 33 | |||
| 72530 | 122191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 7ft | 5991455.42177 | 2114972.80191 | 37.7868197178511 | -122.473363271315 | (37.7868197178511, -122.473363271315) | 11 | 6 | 1 | 54 | 33 | |||
| 78800 | 122189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 21 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 7ft | 5991458.24563 | 2115020.83895 | 37.7869517777125 | -122.473357006468 | (37.7869517777125, -122.473357006468) | 11 | 6 | 1 | 54 | 33 | |||
| 79039 | 188649 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x Quesada Ave | 50 | Median : Yard | Tree | DPW 1 | 3 | Width 7ft | 6014280.17751 | 2095342.33163 | 37.7342139599052 | -122.393020304839 | (37.7342139599052, -122.393020304839) | 10 | 3 | 8 | 58 | 1 | |||
| 99759 | 220135 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 547 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 7ft | 6004984.87724 | 2105183.53951 | 37.7607149265858 | -122.425857408117 | (37.7607149265858, -122.425857408117) | 2 | 4 | 5 | 28859 | 19 | |||
| 120931 | 122195 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 57 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 7ft | 5991459.56182 | 2114871.18886 | 37.7865409564132 | -122.473341533858 | (37.7865409564132, -122.473341533858) | 11 | 6 | 1 | 54 | 33 | |||
| 128925 | 123557 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 127 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 7ft | 5994252.36498 | 2114696.31424 | 37.7862221198903 | -122.463666500407 | (37.7862221198903, -122.463666500407) | 11 | 6 | 1 | 54 | 11 | |||
| 146761 | 188595 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/05/2017 12:00:00 AM | 3 | Width 7ft | 6011997.61193 | 2102271.8897 | 37.7531139870419 | -122.401398733477 | (37.7531139870419, -122.401398733477) | 10 | 3 | 8 | 28856 | 29 | ||
| 156261 | 203283 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 5999191.65926 | 2095001.09495 | 37.7324273055688 | -122.445161400772 | (37.7324273055688, -122.445161400772) | 9 | 7 | 4 | 59 | 40 | |||
| 178494 | 122190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 27 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 7ft | 5991456.07949 | 2114996.8975 | 37.786885915722 | -122.473362753885 | (37.786885915722, -122.473362753885) | 11 | 6 | 1 | 54 | 33 | |||
| 192235 | 188596 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Rhode Island St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 7ft | 6011998.11194 | 2102296.49626 | 37.7531815791825 | -122.401398733471 | (37.7531815791825, -122.401398733471) | 10 | 3 | 8 | 28856 | 29 | |||
| 1805 | 203698 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1696 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | Width 6ft | 5993434.49176 | 2103973.54477 | 37.7567330891842 | -122.46571676863 | (37.7567330891842, -122.46571676863) | 1 | 8 | 4 | 56 | 12 | |||
| 9745 | 175056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989706.76868 | 2089771.19579 | 37.7175213699925 | -122.477570413242 | (37.7175213699925, -122.477570413242) | 1 | 8 | 4 | 64 | 14 | |||
| 15359 | 124880 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3820 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5996409.41763 | 2115616.90715 | 37.7888738770624 | -122.456270294343 | (37.7888738770624, -122.456270294343) | 11 | 6 | 1 | 54 | 31 | |||
| 16567 | 175055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5989631.25858 | 2089762.2141 | 37.7174923263774 | -122.477830757993 | (37.7174923263774, -122.477830757993) | 1 | 8 | 4 | 64 | 14 | |||
| 21164 | 220127 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 6ft | 6004864.42666 | 2105831.25856 | 37.762486601794 | -122.426320110198 | (37.762486601794, -122.426320110198) | 8 | 4 | 5 | 28859 | 3 | |||
| 23699 | 124946 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3636 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5997401.33489 | 2115425.81933 | 37.7884060911058 | -122.452824617461 | (37.7884060911058, -122.452824617461) | 11 | 6 | 1 | 54 | 31 | |||
| 27128 | 124972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2957 Divisadero St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 6000499.51434 | 2118479.2792 | 37.7969671396726 | -122.442324734908 | (37.7969671396726, -122.442324734908) | 13 | 9 | 1 | 57 | 17 | |||
| 36643 | 124791 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 5999559.93091 | 2118054.14735 | 37.7957462443483 | -122.445545320468 | (37.7957462443483, -122.445545320468) | 13 | 9 | 1 | 57 | 17 | |||
| 43578 | 203789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1992 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993502.4088 | 2101925.36953 | 37.7511132445989 | -122.465333114245 | (37.7511132445989, -122.465333114245) | 1 | 8 | 4 | 29491 | 12 | |||
| 44855 | 220129 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6004868.0084 | 2105745.84567 | 37.7622522807502 | -122.426301640812 | (37.7622522807502, -122.426301640812) | 8 | 4 | 5 | 28862 | 3 | |||
| 52631 | 220132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 Dolores St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 6ft | 6004930.63233 | 2104667.35951 | 37.7592945526249 | -122.426008271162 | (37.7592945526249, -122.426008271162) | 2 | 4 | 5 | 28862 | 3 | |||
| 57249 | 187780 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Middle Point Rd | 3 | Side Yard : Yard | Tree | Private 2 | 4 | Width 6ft | 6018250.04699 | 2096453.90064 | 37.7374858320104 | -122.379372242948 | (37.7374858320104, -122.379372242948) | 10 | 3 | 8 | 58 | 1 | |||
| 62189 | 124823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Cervantes Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6000834.31444 | 2121522.83872 | 37.8053430214345 | -122.441384750901 | (37.8053430214345, -122.441384750901) | 13 | 9 | 1 | 57 | 17 | |||
| 63054 | 218196 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1365 Portola Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 5993444.70941 | 2097719.48366 | 37.7395616201724 | -122.465227177697 | (37.7395616201724, -122.465227177697) | 1 | 8 | 4 | 59 | 40 | |||
| 64199 | 203674 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1410 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5990860.835 | 2105757.95381 | 37.7614838136435 | -122.474747560073 | (37.7614838136435, -122.474747560073) | 1 | 8 | 4 | 56 | 12 | |||
| 65029 | 220128 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 6004866.25236 | 2105787.5349 | 37.7623666502118 | -122.4263106826 | (37.7623666502118, -122.4263106826) | 8 | 4 | 5 | 28859 | 3 | |||
| 69899 | 203797 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 459 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5993806.73069 | 2101751.79114 | 37.7506541883464 | -122.464268145176 | (37.7506541883464, -122.464268145176) | 1 | 8 | 4 | 29491 | 40 | |||
| 71881 | 218193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1395 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5993287.55487 | 2097626.31365 | 37.7392967347478 | -122.465763778003 | (37.7392967347478, -122.465763778003) | 1 | 8 | 4 | 59 | 40 | |||
| 74761 | 174977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001002.85904 | 2088768.34496 | 37.7154168062239 | -122.4384532767 | (37.7154168062239, -122.4384532767) | 9 | 7 | 6 | 28861 | 5 | |||
| 74918 | 220131 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 6ft | 6004876.29383 | 2105622.20284 | 37.7619132552264 | -122.42626418137 | (37.7619132552264, -122.42626418137) | 8 | 4 | 5 | 28862 | 3 | |||
| 78317 | 218195 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1365 Portola Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5993371.57779 | 2097679.74373 | 37.7394482867046 | -122.465477146946 | (37.7394482867046, -122.465477146946) | 1 | 8 | 4 | 59 | 40 | |||
| 79488 | 124945 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3636 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5997417.65837 | 2115427.52314 | 37.7884117046867 | -122.452768264141 | (37.7884117046867, -122.452768264141) | 11 | 6 | 1 | 54 | 31 | |||
| 85312 | 175074 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1082 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 6001979.9665 | 2087165.3446 | 37.7110708522134 | -122.434961389078 | (37.7110708522134, -122.434961389078) | 9 | 7 | 6 | 28861 | 5 | |||
| 88175 | 218192 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1395 Portola Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993247.05423 | 2097602.68671 | 37.7392295248094 | -122.465902093723 | (37.7392295248094, -122.465902093723) | 1 | 8 | 4 | 59 | 40 | |||
| 91333 | 203788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2010 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 5993504.43454 | 2101812.32675 | 37.7508029748893 | -122.465317898622 | (37.7508029748893, -122.465317898622) | 1 | 8 | 4 | 29491 | 40 | |||
| 92627 | 220130 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Dolores St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6004868.33246 | 2105707.16087 | 37.7621460797944 | -122.426297765642 | (37.7621460797944, -122.426297765642) | 8 | 4 | 5 | 28862 | 3 | |||
| 100203 | 174978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001016.58593 | 2088794.32712 | 37.7154889282344 | -122.438407690968 | (37.7154889282344, -122.438407690968) | 9 | 7 | 6 | 28861 | 5 | |||
| 111391 | 203790 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1992 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993499.03124 | 2101963.03013 | 37.7512164561752 | -122.46534752949 | (37.7512164561752, -122.46534752949) | 1 | 8 | 4 | 29491 | 12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );