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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 1810 | 1810 | 251708 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 239 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3x3 | Permit Number 776109 | 6008639.31193 | 2109768.7769299997 | 37.7735107666471 | -122.413542618094 | (37.7735107666471, -122.413542618094) | ||
| 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) | ||||
| 4450 | 4450 | 225795 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008004.64414 | 2103879.4657900003 | 37.7573044302625 | -122.415321039155 | (37.7573044302625, -122.415321039155) | |||
| 4515 | 4515 | 225797 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008067.53952 | 2103885.7722400003 | 37.75732528104621 | -122.41510396797301 | (37.7573252810462, -122.415103967973) | |||
| 4518 | 4518 | 225796 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008035.828509999 | 2103884.08468 | 37.7573188652869 | -122.415213517995 | (37.7573188652869, -122.415213517995) | |||
| 4521 | 4521 | 225798 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008119.80842 | 2103888.79141 | 37.757336508198705 | -122.414923414683 | (37.7573365081987, -122.414923414683) | |||
| 7259 | 7259 | 23270 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006591.05831 | 2113351.86982 | 37.783233848997 | -122.42088227939101 | (37.783233848997, -122.420882279391) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 14443 | 14443 | 25984 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013408.21183 | 2096665.5323700001 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 24702 | 24702 | 192280 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009110.344190001 | 2108839.3922200003 | 37.7709853309346 | -122.411847556143 | (37.7709853309346, -122.411847556143) | |||
| 25212 | 25212 | 192295 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010700.612380001 | 2105651.26498 | 37.7623205464704 | -122.406122099663 | (37.7623205464704, -122.406122099663) | |||
| 25322 | 25322 | 192237 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009520.068659999 | 2108454.52562 | 37.7699515539505 | -122.410403121719 | (37.7699515539505, -122.410403121719) | |||
| 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) | |||
| 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) | |||
| 25993 | 25993 | 192209 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009355.45651 | 2108925.4652 | 37.7712354153226 | -122.41100578260401 | (37.7712354153226, -122.411005782604) | |||
| 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) | ||
| 27042 | 27042 | 128824 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011998.07084 | 2115236.9646099997 | 37.7887131646294 | -122.40230865672301 | (37.7887131646294, -122.402308656723) | |||
| 27145 | 27145 | 192211 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009388.568940001 | 2108888.9656700003 | 37.7711370528685 | -122.410888666597 | (37.7711370528685, -122.410888666597) | |||
| 28167 | 28167 | 192309 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011943.7523300005 | 2107376.90821 | 37.767128230416105 | -122.401943831469 | (37.7671282304161, -122.401943831469) | |||
| 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) | |||
| 28875 | 28875 | 109474 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012029.14391 | 2118799.20085 | 37.7984959502925 | -122.402451729872 | (37.7984959502925, -122.402451729872) | |||
| 29899 | 29899 | 192224 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009548.42342 | 2108726.25306 | 37.770699244008895 | -122.410324231382 | (37.7706992440089, -122.410324231382) | |||
| 30042 | 30042 | 192221 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009500.9778 | 2108774.7519400003 | 37.7708297509354 | -122.41049177239599 | (37.7708297509354, -122.410491772396) | |||
| 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) | |||
| 30684 | 30684 | 192318 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011708.94846 | 2107685.56864 | 37.7679626349073 | -122.402777697245 | (37.7679626349073, -122.402777697245) | |||
| 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) | |||
| 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) | |||
| 32509 | 32509 | 192275 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009036.05094 | 2108770.66843 | 37.7707924632209 | -122.412099681957 | (37.7707924632209, -122.412099681957) | |||
| 33085 | 33085 | 109480 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011947.44314 | 2118785.89715 | 37.7984548602505 | -122.402733505447 | (37.7984548602505, -122.402733505447) | |||
| 33435 | 33435 | 192252 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009308.54371 | 2108355.35398 | 37.7696673915621 | -122.411127779219 | (37.7696673915621, -122.411127779219) | |||
| 33563 | 33563 | 192305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009925.06485 | 2105936.96188 | 37.763061595931894 | -122.40882459747 | (37.7630615959319, -122.40882459747) | |||
| 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) | |||
| 34034 | 34034 | 128825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011989.53481 | 2115248.11567 | 37.7887433063148 | -122.40233897468399 | (37.7887433063148, -122.402338974684) | |||
| 34313 | 34313 | 192355 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.39623367064199 | (37.7375943028269, -122.396233670642) | |||
| 34317 | 34317 | 192232 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.466630001 | 2108528.5531599997 | 37.7701592110077 | -122.41013717060899 | (37.7701592110077, -122.410137170609) | |||
| 34513 | 34513 | 192213 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009411.17621 | 2108867.66587 | 37.7710798361979 | -122.410808962379 | (37.7710798361979, -122.410808962379) | |||
| 35877 | 35877 | 192283 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009158.56943 | 2108886.63938 | 37.7711177659971 | -122.411684081879 | (37.7711177659971, -122.411684081879) | |||
| 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) | |||
| 36159 | 36159 | 192290 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009249.88348 | 2108971.40543 | 37.771355635782704 | -122.411374211455 | (37.7713556357827, -122.411374211455) | |||
| 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) | |||
| 37426 | 37426 | 192216 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009448.92717 | 2108828.0279599996 | 37.7709731163511 | -122.410675580336 | (37.7709731163511, -122.410675580336) | |||
| 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) | |||
| 38913 | 38913 | 192279 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009094.0417599995 | 2108824.03792 | 37.7709422570085 | -122.411902861747 | (37.7709422570085, -122.411902861747) | |||
| 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) | ||
| 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) | |||
| 40346 | 40346 | 128822 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012208.0631 | 2118824.10156 | 37.798574308201204 | -122.401834361485 | (37.7985743082012, -122.401834361485) | |||
| 40518 | 40518 | 192261 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009200.74359 | 2108465.0274400003 | 37.769962483400796 | -122.41150840741001 | (37.7699624834008, -122.41150840741) | |||
| 40753 | 40753 | 192274 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009024.55442 | 2108760.36704 | 37.770763532946795 | -122.412138720645 | (37.7707635329468, -122.412138720645) | |||
| 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) | |||
| 41323 | 41323 | 192218 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009470.84858 | 2108807.6783 | 37.770918469946295 | -122.410598315981 | (37.7709184699463, -122.410598315981) | |||
| 42094 | 42094 | 192240 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009484.38016 | 2108422.4744 | 37.7698615480128 | -122.41052430446001 | (37.7698615480128, -122.41052430446) | |||
| 42728 | 42728 | 192205 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009311.714459999 | 2108971.0789 | 37.7713582069357 | -122.411160311315 | (37.7713582069357, -122.411160311315) | |||
| 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) | |||
| 42948 | 42948 | 128819 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6008597.39864 | 2112731.9069 | 37.7816444645714 | -122.41389725225001 | (37.7816444645714, -122.41389725225) | |||
| 43494 | 43494 | 192247 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009385.61181 | 2108329.66334 | 37.76960117269039 | -122.410859387372 | (37.7696011726904, -122.410859387372) | |||
| 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) | |||
| 44739 | 44739 | 192244 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009411.93836 | 2108352.3057 | 37.7696648195127 | -122.410769923705 | (37.7696648195127, -122.410769923705) | |||
| 45431 | 45431 | 192262 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009184.592680001 | 2108480.10836 | 37.770002986167604 | -122.41156533898999 | (37.7700029861676, -122.41156533899) | |||
| 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) | ||
| 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) | |||
| 46017 | 46017 | 192334 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007885.81479 | 2110555.97346 | 37.775629883255796 | -122.416204846094 | (37.7756298832558, -122.416204846094) | |||
| 46347 | 46347 | 192248 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009375.77946 | 2108320.2642200002 | 37.7695748135605 | -122.410892733326 | (37.7695748135605, -122.410892733326) | |||
| 46407 | 46407 | 192330 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 113 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008064.12185 | 2110370.6241900004 | 37.775130982543004 | -122.41557491054701 | (37.775130982543, -122.415574910547) | |||
| 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) | |||
| 47218 | 47218 | 192303 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011758.176530001 | 2102347.8311400004 | 37.753309143502605 | -122.402232092032 | (37.7533091435026, -122.402232092032) | |||
| 47641 | 47641 | 75888 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 13 | 6011802.87578 | 2118766.0417 | 37.7983922692391 | -122.40323235850501 | (37.7983922692391, -122.403232358505) | ||
| 48659 | 48659 | 75815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6011743.63854 | 2118757.50225 | 37.7983655135139 | -122.403436737532 | (37.7983655135139, -122.403436737532) | ||
| 49533 | 49533 | 192344 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007890.6883 | 2110458.72798 | 37.7753631443241 | -122.41618109859199 | (37.7753631443241, -122.416181098592) | |||
| 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) | |||
| 49946 | 49946 | 192325 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011700.9501 | 2107853.89642 | 37.768424378313206 | -122.40281720266199 | (37.7684243783132, -122.402817202662) | |||
| 50297 | 50297 | 192239 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009494.20262 | 2108431.40539 | 37.769886621106295 | -122.410490959396 | (37.7698866211063, -122.410490959396) | |||
| 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) | |||
| 50544 | 50544 | 192292 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009264.77057 | 2108986.5542200003 | 37.7713980657949 | -122.41132378646499 | (37.7713980657949, -122.411323786465) | |||
| 51334 | 51334 | 192264 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009152.13248 | 2108514.01976 | 37.7700942781534 | -122.41168001514299 | (37.7700942781534, -122.411680015143) | |||
| 52799 | 52799 | 192306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3600 03rd St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6015896.02327 | 2098855.55467 | 37.74395018136929 | -122.38767879773701 | (37.7439501813693, -122.387678797737) | |||
| 52957 | 52957 | 192223 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009532.03276 | 2108741.1041599996 | 37.77073910287 | -122.410381975954 | (37.77073910287, -122.410381975954) | |||
| 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) |
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");