trees
3,965 rows where qSpecies_id = 70 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3192 | 247788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 30th St | 4 | : | Tree | Private 2 | 14 | Width 3ft | 6004361.25599 | 2098418.69842 | 37.7421049892529 | -122.427532277614 | (37.7421049892529, -122.427532277614) | 2 | 7 | 5 | 63 | 22 | |||
| 8626 | 188622 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 20 | : | Tree | Private 2 | 16 | Width 3ft | 6016025.72974 | 2098951.35828 | 37.7442204222503 | -122.387236979699 | (37.7442204222503, -122.387236979699) | 10 | 3 | 8 | 58 | 1 | |||
| 11370 | 188616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 13 | : | Tree | Private 2 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442492 | (37.7437624397877, -122.38739442492) | 10 | 3 | 8 | 58 | 1 | |||
| 12430 | 220123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Haight St | 1 | : | Tree | Private 2 | 26 | Width 4ft | 6003680.56736 | 2109328.54381 | 37.772022309504 | -122.430664217001 | (37.772022309504, -122.430664217001) | 15 | 9 | 11 | 29492 | 10 | |||
| 20230 | 203896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5990596.84308 | 2090479.69294 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | 9 | 8 | 4 | 64 | 40 | |||
| 23392 | 203897 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | 9 | 8 | 4 | 64 | 40 | |||
| 28284 | 188619 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 17 | : | Tree | Private 2 | 18 | Width 3ft | 6015998.57647 | 2098868.23914 | 37.7439906904264 | -122.387325073699 | (37.7439906904264, -122.387325073699) | 10 | 3 | 8 | 58 | 1 | |||
| 28598 | 249574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Franklin St | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6006046.96797 | 2113547.66581 | 37.7837407734727 | -122.422778535918 | (37.7837407734727, -122.422778535918) | 7 | 9 | 11 | 28858 | 41 | |||
| 29162 | 188675 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 5 | : | Tree | Private 2 | 21 | Width 4ft | 6017168.99246 | 2097078.35566 | 37.739140782423 | -122.383153445176 | (37.739140782423, -122.383153445176) | 10 | 3 | 8 | 58 | 1 | |||
| 30838 | 188697 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 13 | : | Tree | DPW 1 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291 | (37.7397338556296, -122.38293388291) | 10 | 3 | 8 | 58 | 1 | |||
| 33139 | 188693 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1350 Evans Ave | 2 | : | Tree | Private 2 | 20 | Width 4ft | 6016935.69851 | 2097636.39062 | 37.7406601393594 | -122.383998925709 | (37.7406601393594, -122.383998925709) | 10 | 3 | 8 | 58 | 1 | |||
| 33615 | 188702 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Evans Ave | 2 | : | Tree | DPW 1 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | 10 | 3 | 8 | 58 | 1 | |||
| 42027 | 188598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Wisconsin St | 4 | : | Tree | Private 2 | 18 | Width 5ft | 6012781.12633 | 2102535.65122 | 37.7538819037331 | -122.398707676819 | (37.7538819037331, -122.398707676819) | 10 | 3 | 8 | 28856 | 29 | |||
| 49237 | 250322 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 27th Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5987406.48872 | 2114540.6222 | 37.785397787832 | -122.487339695585 | (37.785397787832, -122.487339695585) | 11 | 6 | 1 | 55 | 33 | |||
| 50488 | 188621 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 19 | : | Tree | Private 2 | 13 | Width 3ft | 6016020.78117 | 2098934.45484 | 37.7441737348321 | -122.387252912086 | (37.7441737348321, -122.387252912086) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 53428 | 188617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 14 | : | Tree | Private 2 | 10 | Width 3ft | 6015982.63525 | 2098803.51641 | 37.7438120922536 | -122.387375681249 | (37.7438120922536, -122.387375681249) | 10 | 3 | 8 | 58 | 1 | |||
| 53567 | 188668 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Fairfax Ave | 4 | : | Tree | Private 2 | 20 | Width 3ft | 6016461.41384 | 2097522.46714 | 37.7403210967391 | -122.38563089846 | (37.7403210967391, -122.38563089846) | 10 | 3 | 8 | 58 | 1 | |||
| 54214 | 188603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 6 | : | Tree | Private 2 | 11 | Width 3ft | 6012672.24718 | 2103750.00011 | 37.7572101741252 | -122.399169443623 | (37.7572101741252, -122.399169443623) | 10 | 3 | 8 | 28856 | 29 | |||
| 58146 | 249566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Franklin St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6005942.16382 | 2114329.62673 | 37.7858819315591 | -122.423196721549 | (37.7858819315591, -122.423196721549) | 13 | 9 | 1 | 28858 | 41 | |||
| 60216 | 188625 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 23 | : | Tree | Private 2 | 16 | Width 3ft | 6016045.06184 | 2099009.53481 | 37.7443812336116 | -122.387174189957 | (37.7443812336116, -122.387174189957) | 10 | 3 | 8 | 58 | 1 | |||
| 63455 | 188683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6018037.89274 | 2096788.1105 | 37.7383918036295 | -122.380128985564 | (37.7383918036295, -122.380128985564) | 10 | 3 | 8 | 58 | 1 | |||
| 64983 | 188602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 5 | : | Tree | Private 2 | 19 | Width 4ft | 6012654.45506 | 2103749.21947 | 37.7572070391022 | -122.39923092128 | (37.7572070391022, -122.39923092128) | 10 | 3 | 8 | 28856 | 29 | |||
| 72330 | 188609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 5 | : | Tree | Private 2 | 15 | Width 3ft | 6015915.65511 | 2098586.79243 | 37.7432133029551 | -122.387592167846 | (37.7432133029551, -122.387592167846) | 10 | 3 | 8 | 58 | 1 | |||
| 73923 | 249543 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1031 Franklin St | 4 | : | Tree | Private 2 | 20 | Width 4ft | 6006034.95999 | 2113672.91543 | 37.7840840006086 | -122.422828983387 | (37.7840840006086, -122.422828983387) | 7 | 9 | 11 | 28858 | 41 | |||
| 76510 | 188600 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 2 | : | Tree | Private 2 | 19 | Width 5ft | 6012542.53813 | 2103744.35344 | 37.7571874401736 | -122.399617634271 | (37.7571874401736, -122.399617634271) | 10 | 3 | 8 | 28856 | 29 | |||
| 81655 | 188698 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 2 | : | Tree | Private 2 | 16 | Width 4ft | 6016460.57689 | 2097987.87635 | 37.7415989695148 | -122.385666221144 | (37.7415989695148, -122.385666221144) | 10 | 3 | 8 | 58 | 1 | |||
| 81698 | 249563 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6005926.96353 | 2114419.55716 | 37.7861280004634 | -122.423255705403 | (37.7861280004634, -122.423255705403) | 13 | 9 | 1 | 28858 | 41 | |||
| 82195 | 188689 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 42 | : | Tree | Private 2 | 11 | Width 3ft | 6017291.85289 | 2097369.22431 | 37.7399462377322 | -122.382748880668 | (37.7399462377322, -122.382748880668) | 10 | 3 | 8 | 58 | 1 | |||
| 91136 | 188624 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 22 | : | Tree | Private 2 | 16 | Width 3ft | 6016039.52279 | 2098990.21434 | 37.7443278768366 | -122.387191995632 | (37.7443278768366, -122.387191995632) | 10 | 3 | 8 | 58 | 1 | |||
| 92090 | 188695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 10 | : | Tree | Private 2 | 15 | Width 3ft | 6017144.28131 | 2097363.3609 | 37.739921983914 | -122.383258718941 | (37.739921983914, -122.383258718941) | 10 | 3 | 8 | 58 | 1 | |||
| 98732 | 188613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 9 | : | Tree | Private 2 | 12 | Width 3ft | 6015951.71912 | 2098695.10264 | 37.7435126980454 | -122.387475021249 | (37.7435126980454, -122.387475021249) | 10 | 3 | 8 | 58 | 1 | |||
| 99925 | 188701 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Evans Ave | 1 | : | Tree | Private 2 | 20 | Width 4ft | 6015874.70018 | 2098310.48488 | 37.7424523506012 | -122.387714506242 | (37.7424523506012, -122.387714506242) | 10 | 3 | 8 | 58 | 1 | |||
| 102740 | 203893 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 Eucalyptus Dr | 2 | : | Tree | Private 2 | 5 | Width 2ft | 5991106.51635 | 2094658.68815 | 37.7310223370083 | -122.473088402602 | (37.7310223370083, -122.473088402602) | 9 | 8 | 4 | 64 | 40 | |||
| 103549 | 188694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 8 | : | Tree | Private 2 | 14 | Width 3ft | 6017109.80778 | 2097388.18297 | 37.7399882351628 | -122.38337964268 | (37.7399882351628, -122.38337964268) | 10 | 3 | 8 | 58 | 1 | |||
| 103659 | 188618 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 15 | : | Tree | Private 2 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | 10 | 3 | 8 | 58 | 1 | |||
| 107095 | 188601 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 22nd St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6012564.34837 | 2103745.33804 | 37.7571913593991 | -122.399542274663 | (37.7571913593991, -122.399542274663) | 10 | 3 | 8 | 28856 | 29 | |||
| 109135 | 188703 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Evans Ave | 6 | : | Tree | Private 2 | 22 | Width 4ft | 6016130.52396 | 2098117.14551 | 37.7419356478228 | -122.386816455808 | (37.7419356478228, -122.386816455808) | 10 | 3 | 8 | 58 | 1 | |||
| 111868 | 188667 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Dorman Ave | 2 | : | Tree | Private 2 | 24 | 6011636.48706 | 2097465.68323 | 37.7398970259256 | -122.402309681047 | (37.7398970259256, -122.402309681047) | 10 | 3 | 8 | 58 | 1 | ||||
| 116844 | 188615 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 12 | : | Tree | Private 2 | 14 | Width 3ft | 6015970.2074 | 2098765.17228 | 37.7437061188534 | -122.387415979867 | (37.7437061188534, -122.387415979867) | 10 | 3 | 8 | 58 | 1 | |||
| 120063 | 188605 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1133 19th St | 2 | : | Tree | Private 2 | 21 | Width 4ft | 6014119.83156 | 2105240.70267 | 37.7613838863743 | -122.394267463999 | (37.7613838863743, -122.394267463999) | 10 | 3 | 8 | 28856 | 29 | |||
| 122333 | 188597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Wisconsin St | 3 | : | Tree | Private 2 | 15 | Width 5ft | 6012781.38051 | 2102548.17796 | 37.7539163136043 | -122.398707676835 | (37.7539163136043, -122.398707676835) | 10 | 3 | 8 | 28856 | 29 | |||
| 124237 | 188666 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Dorman Ave | 1 | : | Tree | Private 2 | 40 | 6011771.13472 | 2097510.17605 | 37.7400267090698 | -122.401847249672 | (37.7400267090698, -122.401847249672) | 10 | 3 | 8 | 58 | 1 | ||||
| 125759 | 188670 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Fairfax Ave | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6016501.05956 | 2097495.23618 | 37.7402485196493 | -122.385491920814 | (37.7402485196493, -122.385491920814) | 10 | 3 | 8 | 58 | 1 | |||
| 126870 | 250556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 130 El Camino Del Mar | 4 | : | Tree | Private 2 | 10 | Width 4ft | 5988132.65183 | 2115364.44627 | 37.787702093729 | -122.48488787927 | (37.787702093729, -122.48488787927) | 11 | 6 | 1 | 55 | 33 | |||
| 128258 | 188671 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Fairfax Ave | 6 | : | Tree | Private 2 | 25 | Width 4ft | 6017541.51277 | 2096801.60961 | 37.7384014713541 | -122.381846181672 | (37.7384014713541, -122.381846181672) | 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 | |||
| 131789 | 188669 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401 Fairfax Ave | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6016481.22908 | 2097508.47417 | 37.7402837712823 | -122.385561409649 | (37.7402837712823, -122.385561409649) | 10 | 3 | 8 | 58 | 1 | |||
| 133480 | 94646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Middle Point Rd | 35 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
| 135846 | 187743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Dukes Ct | 1 | : | Tree | Private 2 | 19 | 6016146.18996 | 2096242.03151 | 37.7367878330931 | -122.386631563293 | (37.7367878330931, -122.386631563293) | 10 | 3 | 8 | 58 | 1 | ||||
| 135894 | 249446 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Ellis St | 6 | : | Tree | Private 2 | 21 | Width 5ft | 6005679.55916 | 2113469.5737 | 37.7835056151439 | -122.424044078095 | (37.7835056151439, -122.424044078095) | 7 | 9 | 11 | 28858 | 41 | |||
| 137679 | 249542 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1031 Franklin St | 2 | : | Tree | Private 2 | 17 | Width 4ft | 6006025.64483 | 2113728.66347 | 37.7842365454133 | -122.422865173892 | (37.7842365454133, -122.422865173892) | 7 | 9 | 11 | 28858 | 41 | |||
| 138512 | 188620 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 18 | : | Tree | Private 2 | 12 | Width 3ft | 6016010.19673 | 2098906.86946 | 37.7440974048845 | -122.387287587249 | (37.7440974048845, -122.387287587249) | 10 | 3 | 8 | 58 | 1 | |||
| 140188 | 188673 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1224 Fairfax Ave | 6 | : | Tree | Private 2 | 17 | Width 3ft | 6017369.13061 | 2096930.52417 | 37.7387459242774 | -122.382451168193 | (37.7387459242774, -122.382451168193) | 10 | 3 | 8 | 58 | 1 | |||
| 140409 | 188696 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 12 | : | Tree | Private 2 | 20 | Width 4ft | 6017175.78475 | 2097338.59897 | 37.7398557335482 | -122.383148069031 | (37.7398557335482, -122.383148069031) | 10 | 3 | 8 | 58 | 1 | |||
| 144556 | 188612 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 8 | : | Tree | Private 2 | 21 | Width 3ft | 6015945.00901 | 2098671.48737 | 37.7434474837177 | -122.387496576211 | (37.7434474837177, -122.387496576211) | 10 | 3 | 8 | 58 | 1 | |||
| 148046 | 249442 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Ellis St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6005782.21609 | 2113483.18621 | 37.7835487870901 | -122.423689892679 | (37.7835487870901, -122.423689892679) | 7 | 9 | 11 | 28858 | 41 | |||
| 148592 | 188699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 4 | : | Tree | Private 2 | 20 | Width 4ft | 6016428.50781 | 2098012.06788 | 37.7416636199942 | -122.385778791959 | (37.7416636199942, -122.385778791959) | 10 | 3 | 8 | 58 | 1 | |||
| 149199 | 220122 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Dolores St | 4 | : | Tree | Private 2 | 6 | Width 6ft | 6004793.59671 | 2107104.43038 | 37.7659784237974 | -122.42665575247 | (37.7659784237974, -122.42665575247) | 8 | 4 | 5 | 28862 | 3 | |||
| 149413 | 188627 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 25 | : | Tree | Private 2 | 6 | Width 3ft | 6016056.19485 | 2099050.87347 | 37.7444953575769 | -122.387138576789 | (37.7444953575769, -122.387138576789) | 10 | 3 | 8 | 58 | 1 | |||
| 149934 | 188628 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 26 | : | Tree | Private 2 | 9 | Width 3ft | 6016060.05409 | 2099067.529 | 37.7445413039446 | -122.38712639369 | (37.7445413039446, -122.38712639369) | 10 | 3 | 8 | 58 | 1 | |||
| 150724 | 221407 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 2 | : | Tree | Private 2 | 11 | 6001990.14587 | 2102921.253 | 37.7543335396806 | -122.436052935814 | (37.7543335396806, -122.436052935814) | 2 | 4 | 5 | 28862 | 22 | ||||
| 151230 | 188700 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 6 | : | Tree | Private 2 | 17 | Width 4ft | 6016385.13466 | 2098043.91296 | 37.7417486598831 | -122.385930982422 | (37.7417486598831, -122.385930982422) | 10 | 3 | 8 | 58 | 1 | |||
| 152216 | 188676 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1298 Fairfax Ave | 8 | : | Tree | Private 2 | 19 | Width 4ft | 6017117.52195 | 2097116.26843 | 37.7392420388994 | -122.383334047038 | (37.7392420388994, -122.383334047038) | 10 | 3 | 8 | 58 | 1 | |||
| 152895 | 188672 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1224 Fairfax Ave | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6017423.58872 | 2096888.36438 | 37.7386331699882 | -122.382259943553 | (37.7386331699882, -122.382259943553) | 10 | 3 | 8 | 58 | 1 | |||
| 154672 | 221406 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 1 | : | Tree | Private 2 | 11 | 6001983.38826 | 2102912.18264 | 37.7543082507347 | -122.43607565629 | (37.7543082507347, -122.43607565629) | 2 | 4 | 5 | 28862 | 22 | ||||
| 157125 | 188611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 7 | : | Tree | Private 2 | 15 | Width 3ft | 6015930.35397 | 2098630.21882 | 37.7433333570534 | -122.387544371599 | (37.7433333570534, -122.387544371599) | 10 | 3 | 8 | 58 | 1 | |||
| 157461 | 188704 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 85 Bay View St | 1 | : | Tree | Private 2 | 31 | Width 5ft | 6013901.34741 | 2094806.92994 | 37.7327228057098 | -122.394292577538 | (37.7327228057098, -122.394292577538) | 10 | 3 | 8 | 58 | 1 | |||
| 157470 | 188610 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 6 | : | Tree | Private 2 | 17 | Width 3ft | 6015921.48725 | 2098607.18682 | 37.7432696247982 | -122.387573424194 | (37.7432696247982, -122.387573424194) | 10 | 3 | 8 | 58 | 1 | |||
| 158197 | 188614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 10 | : | Tree | Private 2 | 15 | Width 3ft | 6015957.75681 | 2098712.25398 | 37.7435601265029 | -122.387455340492 | (37.7435601265029, -122.387455340492) | 10 | 3 | 8 | 58 | 1 | |||
| 160344 | 188626 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 24 | : | Tree | Private 2 | 15 | Width 3ft | 6016050.39554 | 2099032.09801 | 37.7444434828812 | -122.387157320458 | (37.7444434828812, -122.387157320458) | 10 | 3 | 8 | 58 | 1 | |||
| 160448 | 188629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 27 | : | Tree | Private 2 | 22 | Width 3ft | 6016065.14365 | 2099087.45333 | 37.7445962938924 | -122.387110184288 | (37.7445962938924, -122.387110184288) | 10 | 3 | 8 | 58 | 1 | |||
| 160585 | 247236 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Haight St | 1 | : | Tree | Private 2 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | 15 | 5 | 5 | 29492 | 9 | |||
| 162079 | 249441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1050 Ellis St | 1 | : | Tree | Private 2 | 21 | Width 5ft | 6005807.98079 | 2113486.28035 | 37.7835587371777 | -122.423600976706 | (37.7835587371777, -122.423600976706) | 7 | 9 | 11 | 28858 | 41 | |||
| 171345 | 188682 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6018053.21017 | 2096769.99546 | 37.7383429083925 | -122.380074766353 | (37.7383429083925, -122.380074766353) | 10 | 3 | 8 | 58 | 1 | |||
| 176568 | 188674 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1270 Fairfax Ave | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6017349.18345 | 2096943.80807 | 37.7387812973263 | -122.382521060803 | (37.7387812973263, -122.382521060803) | 10 | 3 | 8 | 58 | 1 | |||
| 177180 | 188684 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 6 | : | Tree | Private 2 | 18 | Width 4ft | 6017995.68606 | 2096837.17504 | 37.7385241964319 | -122.380278326092 | (37.7385241964319, -122.380278326092) | 10 | 3 | 8 | 58 | 1 | |||
| 179080 | 203895 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5990601.67154 | 2090472.14101 | 37.719497882902 | -122.474528301759 | (37.719497882902, -122.474528301759) | 9 | 8 | 4 | 64 | 40 | |||
| 186445 | 188686 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 20 | : | Tree | DPW 1 | 12 | Width 3ft | 6017760.57019 | 2097020.59109 | 37.7390148449557 | -122.381104000867 | (37.7390148449557, -122.381104000867) | 10 | 3 | 8 | 58 | 1 | |||
| 188057 | 188623 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 21 | : | Tree | Private 2 | 14 | Width 3ft | 6016032.4125 | 2098973.62438 | 37.7442819304642 | -122.387215424766 | (37.7442819304642, -122.387215424766) | 10 | 3 | 8 | 58 | 1 | |||
| 189818 | 221408 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 3 | : | Tree | Private 2 | 11 | 6001990.46485 | 2102928.21102 | 37.7543526628574 | -122.43605233057 | (37.7543526628574, -122.43605233057) | 2 | 4 | 5 | 28862 | 22 | ||||
| 190793 | 247792 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 30th St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113215 | -122.42834067009 | (37.742063113215, -122.42834067009) | 2 | 7 | 5 | 63 | 22 | |||
| 144610 | 188568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 24 | : Yard | Tree | Private 2 | 38 | 6017120.70508 | 2102612.37668 | 37.7543334029878 | -122.383705595635 | (37.7543334029878, -122.383705595635) | 10 | 3 | 8 | 28856 | 29 | ||||
| 157395 | 188569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 24th St | 26 | : Yard | Tree | Private 2 | 5 | 6017110.36972 | 2102585.17266 | 37.7542581351188 | -122.383739444343 | (37.7542581351188, -122.383739444343) | 10 | 3 | 8 | 28856 | 29 | ||||
| 12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
| 102401 | 115407 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 46 PROSPECT AVE | 1 | Back Yard : Cutout | Tree | Private 2 | 14 | 3x3 | 6007068 | 2099193 | 37.7443837739696 | -122.418228071909 | (37.7443837739696, -122.418228071909) | 2 | 7 | 7 | 28859 | 2 | |||
| 14016 | 249712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 1 | Back Yard : Yard | Tree | Private 2 | 21 | 5999372.04623 | 2116967.23886 | 37.7927511539072 | -122.44611721374 | (37.7927511539072, -122.44611721374) | 13 | 9 | 1 | 29490 | 27 | ||||
| 31010 | 249714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 3 | Back Yard : Yard | Tree | Private 2 | 20 | 5999388.9274 | 2116973.59042 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | 13 | 9 | 1 | 29490 | 27 | ||||
| 43870 | 188564 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Vermont St | 4 | Back Yard : Yard | Tree | Private 2 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | 8 | 3 | 8 | 28853 | 19 | ||||
| 45455 | 249872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Greenwich St | 8 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | 3 | 1 | 10 | 28860 | 6 | |||
| 47188 | 249874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Greenwich St | 10 | Back Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6011664.09828 | 2120483.35155 | 37.8030998334423 | -122.403833479743 | (37.8030998334423, -122.403833479743) | 3 | 1 | 10 | 28860 | 6 | |||
| 48779 | 203876 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | 9 | 8 | 6 | 64 | 24 | ||||
| 108347 | 203877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 6 | Back Yard : Yard | Tree | Private 2 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | 9 | 8 | 6 | 64 | 24 | ||||
| 108861 | 249715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 4 | Back Yard : Yard | Tree | Private 2 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | 13 | 9 | 1 | 29490 | 27 | ||||
| 150773 | 249713 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 2 | Back Yard : Yard | Tree | Private 2 | 15 | 5999382.51554 | 2116973.87968 | 37.7927699857003 | -122.446081467494 | (37.7927699857003, -122.446081467494) | 13 | 9 | 1 | 29490 | 27 | ||||
| 162539 | 203875 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | 9 | 8 | 6 | 64 | 24 | ||||
| 31158 | 117161 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | |||||
| 31746 | 104753 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2328 12TH AVE | Front Yard : Cutout | Tree | Private 2 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | 1 | 8 | 4 | 29491 | 40 | ||||
| 73680 | 117162 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 2 | Front Yard : Cutout | Tree | Private 2 | DPW | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | ||||
| 81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 |
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) );