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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
53709 | 53709 | 192226 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009587.30245 | 2108684.25048 | 37.7705860940019 | -122.410186781721 | (37.7705860940019, -122.410186781721) | |||
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) | |||
54845 | 54845 | 192324 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011702.91759 | 2107830.29721 | 37.7683596900813 | -122.40280873732999 | (37.7683596900813, -122.40280873733) | |||
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) | |||
55477 | 55477 | 225792 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007807.819130001 | 2105426.09185 | 37.761540045560295 | -122.416111269835 | (37.7615400455603, -122.416111269835) | |||
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) | |||
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) | |||
56814 | 56814 | 192271 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009005.79575 | 2108670.8406700003 | 37.7705166618411 | -122.41219727910601 | (37.7705166618411, -122.412197279106) | |||
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) | |||
57400 | 57400 | 192214 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009421.09589 | 2108858.33176 | 37.7710547630982 | -122.41077399042 | (37.7710547630982, -122.41077399042) | |||
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) | |||
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) | |||
58873 | 58873 | 192257 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009251.0050099995 | 2108416.23569 | 37.7698313316731 | -122.41133110605301 | (37.7698313316731, -122.411331106053) | |||
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) | |||
60652 | 60652 | 192335 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007868.48614 | 2110574.3182900003 | 37.775679279409296 | -122.416266089906 | (37.7756792794093, -122.416266089906) | |||
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) |
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");