Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 623 | 623 | 192249 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | Permit Number 779594 | 6009343.40252 | 2108323.7349799997 | 37.7695825279367 | -122.411004969605 | (37.7695825279367, -122.411004969605) | ||
| 627 | 627 | 192272 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1490 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779594 | 6008997.70519 | 2108735.1603599996 | 37.77069281474439 | -122.41222981116002 | (37.7706928147444, -122.41222981116) | |
| 637 | 637 | 192270 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 11th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779594 | 6009046.84186 | 2108631.36839 | 37.770410583217505 | -122.41205250981199 | (37.7704105832175, -122.412052509812) | ||
| 640 | 640 | 251141 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779594 | 6009467.0 | 2108781.0 | 37.7708450017609 | -122.410609744119 | (37.7708450017609, -122.410609744119) | |
| 642 | 642 | 192273 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1490 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779594 | 6009013.0387699995 | 2108749.12963 | 37.7707320314935 | -122.41217775931001 | (37.7707320314935, -122.41217775931) | |
| 646 | 646 | 192250 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779594 | 6009332.59975 | 2108335.89703 | 37.7696153163206 | -122.411043195313 | (37.7696153163206, -122.411043195313) | |
| 2097 | 2097 | 97612 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 353 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780019 | 6009103.06895 | 2109288.8503400004 | 37.7722190299048 | -122.41190448769501 | (37.7722190299048, -122.411904487695) | |
| 2098 | 2098 | 97613 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 353 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780019 | 6009097.30811 | 2109294.5871599996 | 37.7722344586718 | -122.411924820485 | (37.7722344586718, -122.411924820485) | |
| 9454 | 9454 | 117082 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1538 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003149.0 | 2113637.0 | 37.7838221284182 | -122.432810788933 | (37.7838221284182, -122.432810788933) | |||
| 9814 | 9814 | 29017 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 120 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | |
| 10081 | 10081 | 28992 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 447 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009491.0 | 2108895.0 | 37.7711593648098 | -122.410534778589 | (37.7711593648098, -122.410534778589) | ||
| 17036 | 17036 | 85069 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 501 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818.0 | 2105945.0 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | |||
| 18378 | 18378 | 28991 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 455 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | Permit Number 768492 | 6009536.6012657005 | 2108818.9260503002 | 37.7709530398216 | -122.410371669109 | (37.7709530398216, -122.410371669109) | |
| 18923 | 18923 | 29003 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 225X 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008536.6481126 | 2109865.7521973 | 37.7737712727069 | -122.413904609778 | (37.7737712727069, -122.413904609778) | ||
| 19600 | 19600 | 6015 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1735 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 3 | 3X3 | 6002103.39353 | 2112426.40407 | 37.7804387805264 | -122.436341522247 | (37.7804387805264, -122.436341522247) | ||
| 20658 | 20658 | 103188 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1125 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003319.4 | 2112265.6 | 37.780066270641704 | -122.432123301144 | (37.7800662706417, -122.432123301144) | |||
| 24051 | 24051 | 84069 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 817 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51015 | 5999219.92840826 | 2110050.76557572 | 37.7737516279449 | -122.446145813494 | (37.7737516279449, -122.446145813494) | |
| 34098 | 34098 | 45606 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1100X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2001 12:00:00 AM | 4 | Permit Number 44335 | 6003389.50485138 | 2112095.5826586997 | 37.779603419827104 | -122.43186863372401 | (37.7796034198271, -122.431868633724) | ||
| 39902 | 39902 | 117084 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1548 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5x5 | 6003183.0 | 2113711.0 | 37.7840272420603 | -122.43269844956801 | (37.7840272420603, -122.432698449568) | |||
| 51511 | 51511 | 28995 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 405 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009327.356374 | 2109037.9792973 | 37.7715427770518 | -122.41111093135 | (37.7715427770518, -122.41111093135) | ||
| 53236 | 53236 | 48047 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 3251 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.000392599 | 2105579.22117963 | 37.76196079462721 | -122.416104194982 | (37.7619607946272, -122.416104194982) | ||
| 54664 | 54664 | 29069 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1002X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 15 | 3x3 | 6004818.3149515 | 2112301.2204093 | 37.780248943687205 | -122.4269404119 | (37.7802489436872, -122.4269404119) | ||
| 57582 | 57582 | 117083 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1548 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5x5 | 6003183.0 | 2113711.0 | 37.7840272420603 | -122.43269844956801 | (37.7840272420603, -122.432698449568) | |||
| 77524 | 77524 | 113650 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 78154 | 78154 | 101588 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 78384 | 78384 | 105602 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 78449 | 78449 | 101549 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 78877 | 78877 | 85070 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 501 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818.0 | 2105945.0 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | |||
| 79237 | 79237 | 105628 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1401X Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770812 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.41187893978201 | (37.7711042533217, -122.411878939782) | |||
| 79467 | 79467 | 101582 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 79645 | 79645 | 101579 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 79716 | 79716 | 29009 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 115 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008054.0284145 | 2110370.9946968 | 37.7751314325061 | -122.415609852325 | (37.7751314325061, -122.415609852325) | ||
| 79742 | 79742 | 101548 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 80607 | 80607 | 105619 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 401X 11th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009144.21767 | 2108487.31593 | 37.770020511651204 | -122.41170550536002 | (37.7700205116512, -122.41170550536) | ||||
| 80748 | 80748 | 105640 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1401X Harrison St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.41187893978201 | (37.7711042533217, -122.411878939782) | ||||
| 81011 | 81011 | 101587 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 81077 | 81077 | 101568 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 81732 | 81732 | 101569 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 81814 | 81814 | 103196 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1119 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003336.0 | 2112143.0 | 37.779730582772295 | -122.432057116929 | (37.7797305827723, -122.432057116929) | ||||
| 81921 | 81921 | 105612 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 401X 11th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009144.21767 | 2108487.31593 | 37.770020511651204 | -122.41170550536002 | (37.7700205116512, -122.41170550536) | ||||
| 81924 | 81924 | 14509 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 500X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2001 12:00:00 AM | 20 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | ||
| 82187 | 82187 | 48051 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 3251 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007813.000392599 | 2105579.22117963 | 37.76196079462721 | -122.416104194982 | (37.7619607946272, -122.416104194982) | ||
| 82205 | 82205 | 105562 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | ||||
| 82209 | 82209 | 91192 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 3251 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 2x2 | Permit Number 52041 | 6007819.0 | 2105585.0 | 37.761976999263794 | -122.41608385389699 | (37.7619769992638, -122.416083853897) | ||
| 82564 | 82564 | 101577 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 82728 | 82728 | 28988 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 479 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009637.1208705995 | 2108713.6945884 | 37.770669733011204 | -122.410016537501 | (37.7706697330112, -122.410016537501) | ||
| 83028 | 83028 | 105576 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | ||||
| 83250 | 83250 | 29015 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 13X 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007696.7579628 | 2110744.9905592 | 37.7761382468915 | -122.41687223645599 | (37.7761382468915, -122.416872236456) | ||
| 83278 | 83278 | 103238 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1240 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003317.0 | 2112564.0 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | ||||
| 83417 | 83417 | 105565 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770812 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | |||
| 83573 | 83573 | 7219 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1000X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 83662 | 83662 | 103233 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1180X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6003347.1 | 2112356.0 | 37.7803160569069 | -122.4320339316 | (37.7803160569069, -122.4320339316) | ||||
| 83844 | 83844 | 86785 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1390 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2009 12:00:00 AM | 3x3 | Permit Number 52918. Tree 5 on 10th St | 6007989.0 | 2110462.0 | 37.7753776559059 | -122.415841246268 | (37.7753776559059, -122.415841246268) | ||
| 84557 | 84557 | 85072 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 501 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818.0 | 2105945.0 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | |||
| 84642 | 84642 | 105579 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | ||||
| 84919 | 84919 | 101589 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 85019 | 85019 | 28998 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 325X 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008981.599613099 | 2109399.9435755 | 37.7725172504325 | -122.412332515783 | (37.7725172504325, -122.412332515783) | ||
| 85982 | 85982 | 105591 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 86259 | 86259 | 105599 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 86370 | 86370 | 85073 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 501 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2007 12:00:00 AM | Permit Number 49434 | 6009818.0 | 2105945.0 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | |||
| 86733 | 86733 | 105585 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 86853 | 86853 | 26442 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1424 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6003636.29086 | 2112833.4098799997 | 37.7816432962484 | -122.431067570908 | (37.7816432962484, -122.431067570908) | |||
| 87138 | 87138 | 33094 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1042 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37337 | 6011188.34764682 | 2118511.3203705 | 37.7976585269153 | -122.40534087715 | (37.7976585269153, -122.40534087715) | ||
| 87223 | 87223 | 26718 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1203X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003742.20526 | 2112831.75991 | 37.781644766894296 | -122.430701039692 | (37.7816447668943, -122.430701039692) | |||
| 87253 | 87253 | 105582 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 87336 | 87336 | 105590 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770812 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 87374 | 87374 | 101562 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 87441 | 87441 | 105638 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1401X Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.41187893978201 | (37.7711042533217, -122.411878939782) | ||||
| 87769 | 87769 | 29014 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 13X 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6007696.7579628 | 2110744.9905592 | 37.7761382468915 | -122.41687223645599 | (37.7761382468915, -122.416872236456) | ||
| 87782 | 87782 | 103234 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1180X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6003347.1 | 2112356.0 | 37.7803160569069 | -122.4320339316 | (37.7803160569069, -122.4320339316) | ||||
| 88276 | 88276 | 103237 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1240 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003317.0 | 2112564.0 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | ||||
| 88517 | 88517 | 105574 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770812 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | |||
| 88667 | 88667 | 105610 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 401X 11th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009144.21767 | 2108487.31593 | 37.770020511651204 | -122.41170550536002 | (37.7700205116512, -122.41170550536) | ||||
| 88710 | 88710 | 101550 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 89040 | 89040 | 105597 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 89090 | 89090 | 29028 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 290X 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008776.849104499 | 2109541.9048667 | 37.772895551088205 | -122.413050810433 | (37.7728955510882, -122.413050810433) | ||
| 89156 | 89156 | 101570 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 89392 | 89392 | 26722 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1203X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003742.20526 | 2112831.75991 | 37.781644766894296 | -122.430701039692 | (37.7816447668943, -122.430701039692) | |||
| 89489 | 89489 | 101576 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 89667 | 89667 | 101551 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 89757 | 89757 | 101581 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | |||
| 89779 | 89779 | 105637 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1401X Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009102.15962 | 2108882.87062 | 37.7711042533217 | -122.41187893978201 | (37.7711042533217, -122.411878939782) | ||||
| 89888 | 89888 | 29007 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 135 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008142.729220401 | 2110278.1359743 | 37.7748814500597 | -122.415296440644 | (37.7748814500597, -122.415296440644) | ||
| 90044 | 90044 | 101566 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 90091 | 90091 | 5957 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1499X Eddy St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003438.71486 | 2112759.60085 | 37.781429437525 | -122.431745818262 | (37.781429437525, -122.431745818262) | ||
| 90196 | 90196 | 101565 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 90832 | 90832 | 26720 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1203X Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003742.20526 | 2112831.75991 | 37.781644766894296 | -122.430701039692 | (37.7816447668943, -122.430701039692) | |||
| 90880 | 90880 | 101557 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 91290 | 91290 | 105560 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 10th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009467.7 | 2108781.2 | 37.770845590159794 | -122.410607336919 | (37.7708455901598, -122.410607336919) | ||||
| 91477 | 91477 | 105600 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1200X Bryant St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009691.5 | 2108599.6 | 37.770359503346704 | -122.409820383511 | (37.7703595033467, -122.409820383511) | ||||
| 91746 | 91746 | 87641 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1002X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 91808 | 91808 | 103239 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1240 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003317.0 | 2112564.0 | 37.7808854664086 | -122.432152919664 | (37.7808854664086, -122.432152919664) | ||||
| 92069 | 92069 | 94372 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1633 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | 6003065.02645 | 2113947.6858099997 | 37.7846704302621 | -122.433123511568 | (37.7846704302621, -122.433123511568) | |||
| 93414 | 93414 | 105606 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 401X 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009144.21767 | 2108487.31593 | 37.770020511651204 | -122.41170550536002 | (37.7700205116512, -122.41170550536) | ||||
| 93601 | 93601 | 101552 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 435X 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | |||
| 93721 | 93721 | 57895 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1390 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49662. Tree 1 on 10th St | 6007982.25227651 | 2110472.75189299 | 37.7754067987028 | -122.41586534981501 | (37.7754067987028, -122.415865349815) | |||
| 93863 | 93863 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 93875 | 93875 | 88265 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 650 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51251 | 5997597.8 | 2108325.1 | 37.7689206253965 | -122.451632481066 | (37.7689206253965, -122.451632481066) | ||
| 94287 | 94287 | 74526 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1190X Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1995 12:00:00 AM | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||||
| 94631 | 94631 | 105614 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 401X 11th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6009144.21767 | 2108487.31593 | 37.770020511651204 | -122.41170550536002 | (37.7700205116512, -122.41170550536) |
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");