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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86442 | 86442 | 89466 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 3700 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987138.86697 | 2111884.81108 | 37.77809007701521 | -122.488070356177 | (37.7780900770152, -122.488070356177) | ||
| 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) | ||
| 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) | |||
| 45941 | 45941 | 120305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988689.97406 | 2114597.66035 | 37.7856291622608 | -122.48290345597601 | (37.7856291622608, -122.482903455976) | |||
| 132924 | 132924 | 120306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988689.7691 | 2114567.26931 | 37.7855457051568 | -122.482901936944 | (37.7855457051568, -122.482901936944) | |||
| 36050 | 36050 | 120307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988691.32321 | 2114547.3374400004 | 37.785491068319395 | -122.482895098939 | (37.7854910683194, -122.482895098939) | |||
| 129661 | 129661 | 120476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2153 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5988709.31254 | 2114650.77812 | 37.785776133796894 | -122.482840445446 | (37.7857761337969, -122.482840445446) | |||
| 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) | |||
| 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) | |||
| 97990 | 97990 | 11657 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 49592 | 49592 | 11636 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 93732 | 93732 | 11634 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 105125 | 105125 | 59141 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 588 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18448 | 5992243.78964 | 2111491.996 | 37.7773079985249 | -122.470382138383 | (37.7773079985249, -122.470382138383) | ||
| 45528 | 45528 | 59144 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 690 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18451 | 5992269.28731 | 2110774.7292400002 | 37.775340052701104 | -122.470241689466 | (37.7753400527011, -122.470241689466) | ||
| 59720 | 59720 | 56313 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 229 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12447 | 5993040.18993 | 2113916.11955 | 37.7840099974474 | -122.467803508187 | (37.7840099974474, -122.467803508187) | ||
| 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) | |||
| 56819 | 56819 | 68672 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 260 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32580 | 5993093.46375 | 2113748.31872 | 37.7835523382358 | -122.467606994541 | (37.7835523382358, -122.467606994541) | |
| 26010 | 26010 | 59099 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 488 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18401 | 5993459.272919999 | 2112191.2837799997 | 37.7792982564624 | -122.46622825483101 | (37.7792982564624, -122.466228254831) | ||
| 147724 | 147724 | 59101 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 654 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18403 | 5993502.53489 | 2111016.0685 | 37.7760739276641 | -122.465993175595 | (37.7760739276641, -122.465993175595) | ||
| 90352 | 90352 | 107514 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 76 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x10 | 5993384.0 | 2099214.0 | 37.7436616846124 | -122.4655456274 | (37.7436616846124, -122.4655456274) | |||
| 57020 | 57020 | 218969 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.750393275225704 | -122.46496537605499 | (37.7503932752257, -122.464965376055) | |||
| 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) | |||
| 150960 | 150960 | 218967 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 140 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5993644.45362 | 2101662.07824 | 37.7503985047832 | -122.46482279396099 | (37.7503985047832, -122.464822793961) | |||
| 32277 | 32277 | 218975 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 25 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993599.79076 | 2092994.2198700001 | 37.726596156286504 | -122.464347997761 | (37.7265961562865, -122.464347997761) | |||
| 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) | |||
| 69464 | 69464 | 218977 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 5996588.22406 | 2105623.7456099996 | 37.761445530401 | -122.45492930356701 | (37.761445530401, -122.454929303567) | |||
| 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) | |||
| 107280 | 107280 | 56260 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 238 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | Permit Number 12386 | 5997570.92464879 | 2106477.05534424 | 37.763844826719705 | -122.451592119849 | (37.7638448267197, -122.451592119849) | |||
| 54476 | 54476 | 218970 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 85 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997504.5128 | 2099195.16066 | 37.7438467530404 | -122.45129660546499 | (37.7438467530404, -122.451296605465) | |||
| 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) | |||
| 101611 | 101611 | 96698 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997732.0 | 2108845.0 | 37.770355822096704 | -122.451205793491 | (37.7703558220967, -122.451205793491) | |||
| 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) | |||
| 37040 | 37040 | 248584 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998013.4865 | 2107655.5885 | 37.7671061143032 | -122.450146392184 | (37.7671061143032, -122.450146392184) | |||
| 108119 | 108119 | 98345 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998016.0 | 2107622.0 | 37.767014032658 | -122.45013527715 | (37.767014032658, -122.45013527715) | ||||
| 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) | |||
| 121652 | 121652 | 115825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 403 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998362.0 | 2109233.0 | 37.7714572219689 | -122.449054588277 | (37.7714572219689, -122.449054588277) | ||||
| 150720 | 150720 | 225389 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 811 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998617.86055 | 2107510.18613 | 37.7667414427907 | -122.448045492407 | (37.7667414427907, -122.448045492407) | |||
| 50532 | 50532 | 225778 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 924 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5998777.438569999 | 2106776.2154 | 37.7647352648411 | -122.447440705541 | (37.7647352648411, -122.447440705541) | |||
| 101798 | 101798 | 113749 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 459 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998867.0 | 2109101.0 | 37.7711236529318 | -122.447298272426 | (37.7711236529318, -122.447298272426) | ||||
| 113355 | 113355 | 14546 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 815 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.773654699050496 | -122.44626515618 | (37.7736546990505, -122.44626515618) | |||
| 115239 | 115239 | 14548 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 815 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2000 12:00:00 AM | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.773654699050496 | -122.44626515618 | (37.7736546990505, -122.44626515618) | ||
| 53654 | 53654 | 225790 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 920 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999222.99784 | 2106999.85397 | 37.765374771852706 | -122.445915724224 | (37.7653747718527, -122.445915724224) | |||
| 75021 | 75021 | 225791 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 920 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999226.76064 | 2106974.09226 | 37.765304251518 | -122.44590085663799 | (37.765304251518, -122.445900856638) | |||
| 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) | |||
| 33903 | 33903 | 225779 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1559 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999770.51083 | 2107118.5981099997 | 37.765732061717294 | -122.44403054288901 | (37.7657320617173, -122.444030542889) | |||
| 116506 | 116506 | 116066 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 40 MALTA DR | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 5999623.0 | 2096071.0 | 37.7353896244756 | -122.44374699604401 | (37.7353896244756, -122.443746996044) | |||||
| 72951 | 72951 | 128809 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | |||
| 151215 | 151215 | 225817 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 220 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000861.2218 | 2106493.57318 | 37.764078057384296 | -122.440213192391 | (37.7640780573843, -122.440213192391) | |||
| 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) | |||
| 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) | |||
| 67135 | 67135 | 138603 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2662 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001201.7584 | 2114936.3549 | 37.787279191103295 | -122.439640685052 | (37.7872791911033, -122.439640685052) | |||
| 53357 | 53357 | 128808 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2501 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001383.33039 | 2116587.25055 | 37.7918224564007 | -122.439130852904 | (37.7918224564007, -122.439130852904) | |||
| 76795 | 76795 | 225788 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4436 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001105.5651 | 2101159.8137 | 37.7494467567732 | -122.43898580666 | (37.7494467567732, -122.43898580666) | |||
| 59057 | 59057 | 225804 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4433 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001581.80688 | 2104063.4307 | 37.7574464772949 | -122.437546862602 | (37.7574464772949, -122.437546862602) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 55974 | 55974 | 225806 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 363 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001815.68909 | 2103737.4020700003 | 37.7565645760008 | -122.43671466866002 | (37.7565645760008, -122.43671466866) | |||
| 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) | |||
| 109753 | 109753 | 985 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1628 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001654.0889800005 | 2092682.1975 | 37.7262003881553 | -122.436482304747 | (37.7262003881553, -122.436482304747) | |||
| 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) | |
| 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) | |||
| 79400 | 79400 | 41689 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | |||
| 56385 | 56385 | 225807 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002846.79255 | 2107449.48757 | 37.7668156107901 | -122.43341400475799 | (37.7668156107901, -122.433414004758) | |||
| 21141 | 21141 | 16624 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 143 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6002878.48419 | 2107471.6414099997 | 37.7668782377669 | -122.43330597190001 | (37.7668782377669, -122.4333059719) | |||
| 136363 | 136363 | 225813 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6002885.55761 | 2107343.69078 | 37.7665273178175 | -122.43327236244 | (37.7665273178175, -122.43327236244) | |||
| 18965 | 18965 | 16628 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 147 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2006 12:00:00 AM | 12 | 3X3 | 6002889.82891 | 2107449.635 | 37.766818457119896 | -122.433265159761 | (37.7668184571199, -122.433265159761) | ||
| 19824 | 19824 | 16637 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002887.79495 | 2107329.82108 | 37.7664893619256 | -122.433263632733 | (37.7664893619256, -122.433263632733) | |||
| 19707 | 19707 | 16635 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 153 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002890.76164 | 2107366.51768 | 37.766590290141394 | -122.43325599389 | (37.7665902901414, -122.43325599389) | |||
| 138106 | 138106 | 225814 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002898.26283 | 2107347.8267 | 37.7665393948003 | -122.43322871294501 | (37.7665393948003, -122.433228712945) | |||
| 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) | |||
| 40849 | 40849 | 225810 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6002901.372830001 | 2107162.40051 | 37.766030436082794 | -122.433204705528 | (37.7660304360828, -122.433204705528) | |||
| 42776 | 42776 | 225811 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002903.222130001 | 2107175.55757 | 37.766066667072 | -122.43319924936701 | (37.766066667072, -122.433199249367) | |||
| 40148 | 40148 | 225812 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6002912.30789 | 2107203.01713 | 37.7661425797454 | -122.43316978576999 | (37.7661425797454, -122.43316978577) | |||
| 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) | |||
| 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) | |||
| 115102 | 115102 | 2681 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2015 12:00:00 AM | 22 | 3X3 | 6003609.80751 | 2114718.21117 | 37.7868169864691 | -122.431293772174 | (37.7868169864691, -122.431293772174) | ||
| 8020 | 8020 | 2680 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2015 12:00:00 AM | 19 | 3X3 | 6003616.3325 | 2114868.6836 | 37.7872305155325 | -122.43128194219 | (37.7872305155325, -122.43128194219) | ||
| 146699 | 146699 | 128810 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2619 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003992.93502 | 2117891.72487 | 37.7955523541042 | -122.430194727727 | (37.7955523541042, -122.430194727727) | |||
| 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) | |||
| 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) | |||
| 36227 | 36227 | 225787 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 46 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004400.603180001 | 2095343.96322 | 37.7336646890731 | -122.42717726484 | (37.7336646890731, -122.42717726484) | |||
| 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) | |||
| 124107 | 124107 | 225384 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004767.459419999 | 2101889.24161 | 37.7516572687753 | -122.426374799776 | (37.7516572687753, -122.426374799776) | |||
| 30174 | 30174 | 225388 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 306 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6004766.979119999 | 2101818.89406 | 37.751464083609996 | -122.426371452475 | (37.75146408361, -122.426371452475) | |||
| 53360 | 53360 | 225386 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004769.89273 | 2101857.00053 | 37.751568879815395 | -122.42636408974501 | (37.7515688798154, -122.426364089745) | |||
| 25338 | 25338 | 225387 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | |||
| 91370 | 91370 | 51032 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 78 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47507 | 6004848.23489 | 2092967.4640400002 | 37.7271646546122 | -122.425460601145 | (37.7271646546122, -122.425460601145) | ||
| 57897 | 57897 | 51033 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 76 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47508 | 6004871.9247 | 2093005.4504099998 | 37.7272702952631 | -122.42538140772 | (37.7272702952631, -122.42538140772) | ||
| 58336 | 58336 | 225382 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005452.14403 | 2105496.18029 | 37.761599759639104 | -122.424263576509 | (37.7615997596391, -122.424263576509) | |||
| 87227 | 87227 | 64914 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.362986099 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | |
| 2265 | 2265 | 252991 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005528.0 | 2099293.0 | 37.7445715466522 | -122.423560184697 | (37.7445715466522, -122.423560184697) | ||||
| 134591 | 134591 | 225784 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 98 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005770.92499 | 2103464.5515400004 | 37.756039377343505 | -122.423016636805 | (37.7560393773435, -122.423016636805) | |||
| 57413 | 57413 | 225818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 98 Hill St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005774.11943 | 2103465.5032 | 37.7560421706386 | -122.423005656989 | (37.7560421706386, -122.423005656989) | |||
| 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) | |||
| 43682 | 43682 | 225786 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 94 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005786.7967300005 | 2103464.50998 | 37.7560401588409 | -122.422961744009 | (37.7560401588409, -122.422961744009) | |||
| 84899 | 84899 | 92547 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.42109327168501 | (37.740071660795, -122.421093271685) | |||
| 8049 | 8049 | 23281 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6006558.1517199995 | 2113495.8441 | 37.7836273122865 | -122.42100634895901 | (37.7836273122865, -122.421006348959) | |||
| 131457 | 131457 | 128813 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 843 Van Ness Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6006569.2006 | 2113431.92774 | 37.783452436413 | -122.42096358442 | (37.783452436413, -122.42096358442) | |||
| 7849 | 7849 | 23269 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006584.636609999 | 2113380.90993 | 37.7833132240722 | -122.42090655840201 | (37.7833132240722, -122.420906558402) |
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");