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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 38564 | 38564 | 192200 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 0 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008879.18119 | 2109418.2333 | 37.7725617219648 | -122.41268808588998 | (37.7725617219648, -122.41268808589) | |||
| 451 | 451 | 192346 | Planning Code 138.1 required 4 | Fraxinus spp :: Ash Spp 83 | 118 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.5452799997 | 37.7750719195804 | -122.41581539288201 | (37.7750719195804, -122.415815392882) | |
| 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) | ||||
| 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) | |||
| 13842 | 13842 | 25983 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | |||
| 14010 | 14010 | 29020 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 154 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008187.55893 | 2110147.28508 | 37.774524683913896 | -122.41513210056401 | (37.7745246839139, -122.415132100564) | ||
| 14020 | 14020 | 28999 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 241 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008639.31193 | 2109768.7769299997 | 37.7735107666471 | -122.413542618094 | (37.7735107666471, -122.413542618094) | ||
| 14043 | 14043 | 29025 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 250 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008614.8600699995 | 2109695.18627 | 37.77330733098729 | -122.413621994964 | (37.7733073309873, -122.413621994964) | ||
| 14366 | 14366 | 29008 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 123 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008118.46736 | 2110307.2661 | 37.774960070880496 | -122.415382430453 | (37.7749600708805, -122.415382430453) | ||
| 14507 | 14507 | 29010 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 113 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008095.190140001 | 2110335.0874799998 | 37.7750351534761 | -122.415464921674 | (37.7750351534761, -122.415464921674) | ||
| 14608 | 14608 | 29018 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 128 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008069.48566 | 2110276.86185 | 37.774873834897 | -122.41554971607 | (37.774873834897, -122.41554971607) | ||
| 14816 | 14816 | 29032 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 330 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 02:58:00 PM | 3 | 3x3 | 6008959.5053199995 | 2109339.54752 | 37.7723501771487 | -122.412404672648 | (37.7723501771487, -122.412404672648) | ||
| 15152 | 15152 | 29034 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 358 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009078.53506 | 2109215.83285 | 37.7720171644901 | -122.411984191933 | (37.7720171644901, -122.411984191933) | ||
| 15223 | 15223 | 29006 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 135 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008170.1889 | 2110256.9147 | 37.774824724723395 | -122.415199949027 | (37.7748247247234, -122.415199949027) | ||
| 15761 | 15761 | 29004 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 151 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008239.15145 | 2110183.90276 | 37.7746281266267 | -122.41495622374399 | (37.7746281266267, -122.414956223744) | ||
| 16199 | 16199 | 29033 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009042.97746 | 2109247.69972 | 37.772102668444 | -122.412109441391 | (37.772102668444, -122.412109441391) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 23787 | 23787 | 192299 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.1113599995 | 2102354.12957 | 37.7533316805221 | -122.401907686797 | (37.7533316805221, -122.401907686797) | |||
| 23985 | 23985 | 192353 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1500 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6015367.9403099995 | 2101545.1725 | 37.7513060448498 | -122.38969261993 | (37.7513060448498, -122.38969261993) | |||
| 25376 | 25376 | 192340 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007835.1568599995 | 2110517.0734099997 | 37.7755202244095 | -122.416377328869 | (37.7755202244095, -122.416377328869) | |||
| 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) | ||
| 28457 | 28457 | 192322 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011704.5689199995 | 2107781.11389 | 37.7682247360183 | -122.40279956606301 | (37.7682247360183, -122.402799566063) | |||
| 28861 | 28861 | 192349 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008725.32275 | 2109583.20667 | 37.773006063508504 | -122.413231967974 | (37.7730060635085, -122.413231967974) | |||
| 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) | |||
| 32326 | 32326 | 225783 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3251 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007765.10393 | 2105579.72042 | 37.7619594722828 | -122.416269885947 | (37.7619594722828, -122.416269885947) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 40032 | 40032 | 45645 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 10 | Permit Number 44346 | 6011201.4795699995 | 2118401.58307 | 37.7973579490636 | -122.40528770508999 | (37.7973579490636, -122.40528770509) | ||
| 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) | |||
| 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) | ||
| 46622 | 46622 | 248136 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 226 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6010037.88024 | 2099520.31318 | 37.745449227116204 | -122.407981876971 | (37.7454492271162, -122.407981876971) | |||
| 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) | |||
| 54421 | 54421 | 128827 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1048 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011178.99904 | 2118580.19305 | 37.797847111915395 | -122.405378078855 | (37.7978471119154, -122.405378078855) | |||
| 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) | |||
| 55154 | 55154 | 192348 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 170 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008297.90047 | 2110029.55008 | 37.774207611721 | -122.414742072711 | (37.774207611721, -122.414742072711) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 58889 | 58889 | 128823 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012017.65592 | 2115254.86265 | 37.788763401662294 | -122.402242153673 | (37.7887634016623, -122.402242153673) | |||
| 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) | |||
| 59605 | 59605 | 30514 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 22 | Permit Number 42913 | 6008785.20324 | 2113547.07327 | 37.783893261596 | -122.41330519888201 | (37.783893261596, -122.413305198882) | |
| 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) | ||
| 60743 | 60743 | 192197 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 315 10th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008969.56374 | 2109417.5428 | 37.77256489838 | -122.412375393416 | (37.77256489838, -122.412375393416) | |||
| 63148 | 63148 | 128818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6008590.072819999 | 2112753.6633099997 | 37.7817037910346 | -122.413924135711 | (37.7817037910346, -122.413924135711) | |||
| 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) | |||
| 70435 | 70435 | 187490 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 750 Velasco Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6006575.2964699995 | 2086657.1322 | 37.709935258482 | -122.419042759324 | (37.709935258482, -122.419042759324) | ||||
| 74860 | 74860 | 192327 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 237 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008504.84777 | 2109907.53416 | 37.7738842101272 | -122.41401756896299 | (37.7738842101272, -122.414017568963) | |||
| 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) | |||
| 75995 | 75995 | 30523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 23 | Permit Number 34528 | 6008465.79864 | 2112766.79262 | 37.7817328607212 | -122.414354996407 | (37.7817328607212, -122.414354996407) | |
| 76249 | 76249 | 225794 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007798.59434 | 2105543.95905 | 37.761863162968105 | -122.416151522586 | (37.7618631629681, -122.416151522586) | |||
| 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) | |||
| 84512 | 84512 | 33479 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 140993 | 140993 | 56058 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49940 | 6009112.81160157 | 2103362.97509043 | 37.7559484836074 | -122.41145205807301 | (37.7559484836074, -122.411452058073) | ||
| 145428 | 145428 | 33475 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432.0 | 2098629.0 | 37.742799336995795 | -122.420387207052 | (37.7427993369958, -122.420387207052) | ||
| 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) | |||
| 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) | ||
| 148099 | 148099 | 192203 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009293.32816 | 2108991.82453 | 37.77141413846871 | -122.411225376349 | (37.7714141384687, -122.411225376349) | |||
| 149650 | 149650 | 192337 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 59 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007660.20523 | 2110795.5413599997 | 37.776274991226394 | -122.41700226506599 | (37.7762749912264, -122.417002265066) | |||
| 150364 | 150364 | 192199 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.1222 | 2109432.51416 | 37.77260025703389 | -122.412730809104 | (37.7726002570339, -122.412730809104) | |||
| 150402 | 150402 | 192229 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009648.37032 | 2108577.40653 | 37.7702961480689 | -122.409968002743 | (37.7702961480689, -122.409968002743) | |||
| 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) | |||
| 151026 | 151026 | 92523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 275 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52874 | 6008729.08615 | 2109670.8725400004 | 37.773246984679396 | -122.41322515024099 | (37.7732469846794, -122.413225150241) | |
| 152668 | 152668 | 192298 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2200 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011908.73866 | 2102359.4276900003 | 37.7533493881837 | -122.40171222904699 | (37.7533493881837, -122.401712229047) | |||
| 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) | |||
| 156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
| 156923 | 156923 | 192312 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011718.3988 | 2107518.4291 | 37.767504235158704 | -122.402733253659 | (37.7675042351587, -122.402733253659) | |||
| 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) | |||
| 158326 | 158326 | 192198 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 313 10th St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008924.99319 | 2109468.55838 | 37.7727024739698 | -122.412533174959 | (37.7727024739698, -122.412533174959) | |||
| 160266 | 160266 | 192202 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 10th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009124.54034 | 2109165.9585 | 37.7718828021889 | -122.411821530666 | (37.7718828021889, -122.411821530666) | |||
| 160677 | 160677 | 192347 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 134 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008123.05736 | 2110213.2209099997 | 37.7747021030553 | -122.415359893447 | (37.7747021030553, -122.415359893447) | |||
| 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) | |||
| 163536 | 163536 | 192307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011941.53927 | 2107440.75625 | 37.7673034192378 | -122.40195597501001 | (37.7673034192378, -122.40195597501) | |||
| 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) | |||
| 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) | |||
| 171215 | 171215 | 44078 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2000 12:00:00 AM | 16 | Permit Number 43599 | 6012239.93104 | 2118827.2823900003 | 37.7985848203962 | -122.40172431143401 | (37.7985848203962, -122.401724311434) | |
| 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) | |
| 173864 | 173864 | 225381 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1643 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006512.204919999 | 2107283.08365 | 37.7665659760752 | -122.42072411023001 | (37.7665659760752, -122.42072411023) | |||
| 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) | |||
| 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) | ||
| 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) |
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");