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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||
| 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) | |
| 94836 | 94836 | 33480 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 6 | 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) | |||
| 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) | ||||
| 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) | ||||
| 112329 | 112329 | 33476 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 5 | 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) | |||
| 118261 | 118261 | 33474 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 4 | 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) | |||
| 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) | ||||
| 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) | ||
| 141574 | 141574 | 33477 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 3 | 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) | |||
| 143673 | 143673 | 33478 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 2 | 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 129868 | 129868 | 192343 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007880.06697 | 2110469.37964 | 37.7753917940266 | -122.416218594918 | (37.7753917940266, -122.416218594918) | |||
| 151326 | 151326 | 192217 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009459.542640001 | 2108818.21129 | 37.7709467572235 | -122.410638167623 | (37.7709467572235, -122.410638167623) | |||
| 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) | |||
| 161289 | 161289 | 192251 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009321.461680001 | 2108343.14872 | 37.769634603179 | -122.41108223395901 | (37.769634603179, -122.411082233959) | |||
| 169012 | 169012 | 192341 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007845.7339699995 | 2110504.26388 | 37.7754856472738 | -122.416339832511 | (37.7754856472738, -122.416339832511) | |||
| 174228 | 174228 | 192222 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009520.501130001 | 2108752.11009 | 37.7707686761527 | -122.410422641486 | (37.7707686761527, -122.410422641486) | |||
| 174637 | 174637 | 192342 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007873.4377 | 2110478.3105900004 | 37.775415943530604 | -122.41624215986099 | (37.7754159435306, -122.416242159861) | |||
| 177223 | 177223 | 192288 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009225.94574 | 2108950.58791 | 37.7712971330939 | -122.411455542555 | (37.7712971330939, -122.411455542555) | |||
| 186917 | 186917 | 192345 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007899.18679 | 2110450.27855 | 37.775340422048394 | -122.41615110171301 | (37.7753404220484, -122.416151101713) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 131904 | 131904 | 192291 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009258.26702 | 2108978.96062 | 37.77137685078 | -122.41134574611 | (37.77137685078, -122.41134574611) | |||
| 166725 | 166725 | 192284 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009171.26495 | 2108898.08726 | 37.771149911371204 | -122.41164097644699 | (37.7711499113712, -122.411640976447) | |||
| 168557 | 168557 | 192332 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007926.51606 | 2110514.48292 | 37.7755182485986 | -122.416061111038 | (37.7755182485986, -122.416061111038) | |||
| 173132 | 173132 | 192225 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009566.76232 | 2108703.16706 | 37.770636883201206 | -122.41025916634399 | (37.7706368832012, -122.410259166344) | |||
| 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) | |||
| 179474 | 179474 | 192289 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009238.64118 | 2108962.03516 | 37.771329276649105 | -122.411412437151 | (37.7713292766491, -122.411412437151) | |||
| 180754 | 180754 | 192285 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009183.75419 | 2108910.9438099996 | 37.771185913038 | -122.411598684054 | (37.771185913038, -122.411598684054) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 61003 | 61003 | 192207 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009328.31589 | 2108955.05277 | 37.771315133921 | -122.411101753766 | (37.771315133921, -122.411101753766) | |||
| 66815 | 66815 | 192268 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009073.27718 | 2108601.79495 | 37.7703308646077 | -122.411958979438 | (37.7703308646077, -122.411958979438) | |||
| 71057 | 71057 | 41070 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 255 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1999 12:00:00 AM | 3 | Permit Number 41832 | 6008672.12135 | 2109729.96637 | 37.773406044194495 | -122.413426379828 | (37.7734060441945, -122.413426379828) | |
| 73724 | 73724 | 192350 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008739.72067 | 2109564.6786599997 | 37.772955998255206 | -122.413180853213 | (37.7729559982552, -122.413180853213) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 133631 | 133631 | 192220 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009488.97607 | 2108785.76749 | 37.770859324239105 | -122.410534064794 | (37.7708593242391, -122.410534064794) | |||
| 133855 | 133855 | 192255 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009278.39034 | 2108387.11077 | 37.769752897294204 | -122.41123432280001 | (37.7697528972942, -122.4112343228) | |||
| 135679 | 135679 | 128811 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008019.0102 | 2113722.70436 | 37.78433245540771 | -122.415968392744 | (37.7843324554077, -122.415968392744) | |||
| 146519 | 146519 | 192204 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009304.82135 | 2108978.94613 | 37.7713794219438 | -122.41118471082 | (37.7713794219438, -122.41118471082) | |||
| 148715 | 148715 | 192281 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009122.35355 | 2108851.7905099997 | 37.7710200474802 | -122.411806891483 | (37.7710200474802, -122.411806891483) | |||
| 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) | |||
| 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) | |
| 151429 | 151429 | 192339 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 59 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007610.66005 | 2110846.20818 | 37.776411323063606 | -122.41717724703301 | (37.7764113230636, -122.417177247033) | |||
| 155337 | 155337 | 192293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009269.83054 | 2108992.53867 | 37.7714147814913 | -122.411306706546 | (37.7714147814913, -122.411306706546) | |||
| 169673 | 169673 | 192233 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009583.6177 | 2108515.2759 | 37.7701219224206 | -122.41018759559401 | (37.7701219224206, -122.410187595594) | |||
| 183667 | 183667 | 225780 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007669.1739300005 | 2105574.3226 | 37.76193925642529 | -122.41660128882401 | (37.7619392564253, -122.416601288824) | |||
| 186884 | 186884 | 192227 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009609.32047 | 2108657.10894 | 37.7705128037596 | -122.41010870437799 | (37.7705128037596, -122.410108704378) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 63906 | 63906 | 192329 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 135 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008156.7444 | 2110270.8623200003 | 37.774862266002 | -122.41524744403601 | (37.774862266002, -122.415247444036) | |||
| 69649 | 69649 | 192333 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007912.3493800005 | 2110528.44514 | 37.7755557890086 | -122.416111106161 | (37.7755557890086, -122.416111106161) | |||
| 69720 | 69720 | 192302 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011784.47888 | 2102348.07827 | 37.753311290205296 | -122.402141149916 | (37.7533112902053, -122.402141149916) | |||
| 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) | |||
| 122157 | 122157 | 192238 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009506.6298 | 2108441.21994 | 37.769914266262205 | -122.410448666999 | (37.7699142662622, -122.410448666999) | |||
| 130852 | 130852 | 192276 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009052.59315 | 2108786.2519900003 | 37.7708361801883 | -122.412043563376 | (37.7708361801883, -122.412043563376) | |||
| 130927 | 130927 | 109476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012009.31763 | 2118795.25368 | 37.7984840054917 | -122.402520057652 | (37.7984840054917, -122.402520057652) | |||
| 134215 | 134215 | 192336 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007840.5436 | 2110603.67429 | 37.775758312732 | -122.41636483009898 | (37.775758312732, -122.416364830099) | |||
| 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) | |||
| 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) | |||
| 155375 | 155375 | 192351 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008765.23275 | 2109539.84577 | 37.772889245185794 | -122.413090847292 | (37.7728892451858, -122.413090847292) | |||
| 157090 | 157090 | 192208 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009341.19534 | 2108940.97548 | 37.771277203218396 | -122.4110562085 | (37.7712772032184, -122.4110562085) | |||
| 166557 | 166557 | 192206 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009319.54279 | 2108962.9583900003 | 37.77133634892171 | -122.411132658949 | (37.7713363489217, -122.411132658949) | |||
| 167643 | 167643 | 192230 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009632.52889 | 2108561.57413 | 37.7702517881052 | -122.41002168056299 | (37.7702517881052, -122.410021680563) | |||
| 168681 | 168681 | 192277 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009066.01772 | 2108798.85518 | 37.7708715388111 | -122.411998018109 | (37.7708715388111, -122.411998018109) | |||
| 171787 | 171787 | 192338 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 59 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007624.10398 | 2110832.2606 | 37.7763737826504 | -122.417129752033 | (37.7763737826504, -122.417129752033) |
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");