Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139263 | 139263 | 54213 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9951 | 5993547.73398631 | 2106617.88649247 | 37.764000294064495 | -122.465517235123 | (37.7640002940645, -122.465517235123) | |||
| 142819 | 142819 | 101247 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 9951 | 5993550.0 | 2106615.0 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | ||||
| 183175 | 183175 | 54136 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | ||
| 3890 | 3890 | 161753 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022.0 | 2087749.0 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | |
| 3901 | 3901 | 253246 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173.0 | 2087586.0 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | |
| 5103 | 5103 | 253796 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.733158617067296 | -122.40094689916799 | (37.7331586170673, -122.400946899168) | ||
| 2565 | 2565 | 191072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.770338555601505 | -122.41354738542101 | (37.7703385556015, -122.413547385421) | ||
| 145 | 145 | 111561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.3886700002 | 37.7508975116216 | -122.40231700873699 | (37.7508975116216, -122.402317008737) | |
| 1997 | 1997 | 28906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.779528530663704 | -122.402635398413 | (37.7795285306637, -122.402635398413) | |
| 4088 | 4088 | 30930 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 342 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 02:15:00 PM | 3 | 4.5x9 | Permit Number 779282 | 5995716.95289 | 2091237.86508 | 37.7218954350219 | -122.45690211214199 | (37.7218954350219, -122.456902112142) |
| 9799 | 9799 | 121570 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1530 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779159 | 6010119.0 | 2100471.0 | 37.748064146234604 | -122.40776839943999 | (37.7480641462346, -122.40776839944) | |
| 100537 | 100537 | 116814 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3660x 23RD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779082 | 6005401.0 | 2102665.0 | 37.7538231135776 | -122.42423909941999 | (37.7538231135776, -122.42423909942) | |
| 105880 | 105880 | 67357 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 846 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778684 | 6009891.75487156 | 2104281.4240401 | 37.758513997926705 | -122.40882299904499 | (37.7585139979267, -122.408822999045) | |
| 10698 | 10698 | 117442 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | ||
| 140728 | 140728 | 117303 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1075 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778518 | 6009488.7 | 2102920.1 | 37.754753524299005 | -122.410120841459 | (37.754753524299, -122.410120841459) | ||
| 97585 | 97585 | 117316 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||
| 144433 | 144433 | 117317 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | ||
| 81751 | 81751 | 59516 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1648 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778498 | 5999918.58356785 | 2110586.79862923 | 37.775263312084604 | -122.443767580498 | (37.7752633120846, -122.443767580498) | ||
| 102954 | 102954 | 117321 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1648 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778498 | 5999899.0 | 2110608.7 | 37.775322330658796 | -122.443836898167 | (37.7753223306588, -122.443836898167) | |||
| 81758 | 81758 | 117333 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.47228609371099 | (37.7384265182794, -122.472286093711) | |||
| 101383 | 101383 | 117334 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.47228609371099 | (37.7384265182794, -122.472286093711) | |||
| 107856 | 107856 | 117332 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.47228609371099 | (37.7384265182794, -122.472286093711) | |||
| 102733 | 102733 | 47029 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.43184543930599 | (37.7702201068925, -122.431845439306) | |
| 89566 | 89566 | 117002 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.732245771866396 | -122.43889383012801 | (37.7322457718664, -122.438893830128) | |
| 11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
| 1562 | 1562 | 251589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778123 | 6007098.02705 | 2095773.46513 | 37.7349961804395 | -122.417881894445 | (37.7349961804395, -122.417881894445) | |
| 86791 | 86791 | 47143 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2179 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777489 | 5991297.44493317 | 2100594.37185861 | 37.7473312629118 | -122.472860991281 | (37.7473312629118, -122.472860991281) | |
| 124932 | 124932 | 115384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 324 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | ||
| 119819 | 119819 | 94699 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 475 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777440 | 5992793.3715699995 | 2112229.57702 | 37.7793649566555 | -122.468534651493 | (37.7793649566555, -122.468534651493) |
| 91101 | 91101 | 115160 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | |||
| 108824 | 108824 | 115159 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | |||
| 143110 | 143110 | 115161 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | |||
| 47324 | 47324 | 114551 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322005 | -122.401957083855 | (37.759370822322, -122.401957083855) | ||
| 11339 | 11339 | 117430 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.226919999 | 2091583.55482 | 37.723327093656295 | -122.42766442668301 | (37.7233270936563, -122.427664426683) | ||
| 112328 | 112328 | 111742 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1737 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776572 | 5990114.7617 | 2111254.66631 | 37.776533029826396 | -122.477729702528 | (37.7765330298264, -122.477729702528) | |
| 78597 | 78597 | 48554 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | |||
| 138710 | 138710 | 115293 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644.0 | 37.7474306230823 | -122.47506779234502 | (37.7474306230823, -122.475067792345) | |||
| 129487 | 129487 | 115382 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 625 Moultrie St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | ||
| 116818 | 116818 | 113391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2151 15TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602.0 | 2100781.0 | 37.7478613219593 | -122.47182147099899 | (37.7478613219593, -122.471821470999) | |
| 140292 | 140292 | 114248 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2151 15TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2015 12:00:00 AM | 2 | Permit Number 776062 | 5991602.0 | 2100781.0 | 37.7478613219593 | -122.47182147099899 | (37.7478613219593, -122.471821470999) | |
| 78538 | 78538 | 114900 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.46372345992201 | (37.7599902919139, -122.463723459922) | |||
| 2608 | 2608 | 115877 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927543999 | (37.7936051429156, -122.42615927544) | ||
| 7482 | 7482 | 115876 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123488996 | -122.426020771756 | (37.793613123489, -122.426020771756) | ||
| 109173 | 109173 | 107236 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3326 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2015 12:00:00 AM | Permit Number 775776 | 6006851.0 | 2102663.4 | 37.753900487576296 | -122.419224541208 | (37.7539004875763, -122.419224541208) | |||
| 31314 | 31314 | 52821 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | ||
| 76323 | 76323 | 52820 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989777.027869999 | 2111978.2933900002 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | ||
| 124136 | 124136 | 114796 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | |||
| 100390 | 100390 | 110438 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 224 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775407 | 6007788.2 | 2109003.3 | 37.7713611206973 | -122.416432516069 | (37.7713611206973, -122.416432516069) | |
| 108218 | 108218 | 110457 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 501 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775373 | 5991635.3 | 2099042.5 | 37.7430897750827 | -122.47157965579599 | (37.7430897750827, -122.471579655796) | |||
| 110515 | 110515 | 92271 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||
| 127294 | 127294 | 34943 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3968 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | Permit Number 775333 | 6003347.35755113 | 2102457.99102165 | 37.753138543477704 | -122.43132628846001 | (37.7531385434777, -122.43132628846) | ||
| 130201 | 130201 | 30935 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.721685664556496 | -122.45622643891501 | (37.7216856645565, -122.456226438915) | |
| 157490 | 157490 | 30936 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.9946800005 | 2091121.8923 | 37.7215880844914 | -122.45622643891501 | (37.7215880844914, -122.456226438915) | |
| 4873 | 4873 | 243284 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | |
| 4880 | 4880 | 253705 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 4887 | 4887 | 236267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.76708301789029 | -122.41664693661998 | (37.7670830178903, -122.41664693662) | |
| 4888 | 4888 | 151878 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007623.77597 | 2107385.0882099997 | 37.7669086438472 | -122.41688659964599 | (37.7669086438472, -122.416886599646) | |
| 4889 | 4889 | 253706 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 4900 | 4900 | 31068 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.41676211549999 | (37.7669118184545, -122.4167621155) | |
| 115771 | 115771 | 109859 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1575 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775087 | 5992103.1 | 2104731.7 | 37.758737897777706 | -122.47037637766898 | (37.7587378977777, -122.470376377669) |
| 118626 | 118626 | 114647 | Private 5 | Eriobotrya deflexa :: Bronze Loquat 49 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | |||
| 133684 | 133684 | 114562 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 2 | Permit Number 774856 | 6005427.7937900005 | 2117145.93262 | 37.793585761622296 | -122.425176769692 | (37.7935857616223, -122.425176769692) | ||
| 87614 | 87614 | 109098 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 442 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774790 | 6003487.8 | 2102768.8 | 37.753999909780795 | -122.430862790198 | (37.7539999097808, -122.430862790198) |
| 94875 | 94875 | 54774 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2015 12:00:00 AM | 3 | 4x7 | Permit Number 774786 | 5994308.33481958 | 2105643.99316865 | 37.7613700750969 | -122.462815904231 | (37.7613700750969, -122.462815904231) | |
| 80969 | 80969 | 108934 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591001 | (37.7386556931549, -122.42007742591) |
| 10856 | 10856 | 108684 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.71537922895679 | -122.44081399618601 | (37.7153792289568, -122.440813996186) | |
| 94944 | 94944 | 108615 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 136 Precita Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.746964004181706 | -122.417421212351 | (37.7469640041817, -122.417421212351) | |
| 76019 | 76019 | 108612 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | |
| 117776 | 117776 | 67731 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774581 | 5992402.99511967 | 2105448.3839166 | 37.7607230584725 | -122.46939137901 | (37.7607230584725, -122.46939137901) | |
| 152828 | 152828 | 40677 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 195 Maynard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2015 12:00:00 AM | 1 | Permit Number 774326 | 6004652.689680001 | 2093800.0056200002 | 37.729439578770204 | -122.426195845473 | (37.7294395787702, -122.426195845473) | |
| 13845 | 13845 | 117146 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | |
| 15089 | 15089 | 117148 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | |
| 15752 | 15752 | 117149 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.155180001 | 2097982.19203 | 37.7413315821976 | -122.40133403893499 | (37.7413315821976, -122.401334038935) | |
| 15833 | 15833 | 117147 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978001 | (37.7414998183769, -122.40118925978) | |
| 18623 | 18623 | 117138 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 84121 | 84121 | 117143 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 95513 | 95513 | 117140 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 103897 | 103897 | 117136 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 109812 | 109812 | 117145 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 111043 | 111043 | 117137 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 112757 | 112757 | 117142 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 116617 | 116617 | 117139 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 123153 | 123153 | 117141 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 139017 | 139017 | 117144 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 78772 | 78772 | 38319 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |||
| 109284 | 109284 | 38317 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1810 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |
| 113037 | 113037 | 38321 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1810 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |||
| 102243 | 102243 | 111193 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | |
| 103008 | 103008 | 111194 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | ||
| 124259 | 124259 | 56711 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | |||
| 9003 | 9003 | 33126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.7731800005 | 2118925.97012 | 37.7982114272598 | -122.44127631424601 | (37.7982114272598, -122.441276314246) | |
| 62140 | 62140 | 52647 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 850@ FULTON 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 774180 | 5982028.38924 | 2109948.2493 | 37.7724733883273 | -122.505605444469 | (37.7724733883273, -122.505605444469) | ||
| 143800 | 143800 | 109075 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773945 | 5993143.3 | 2105315.7 | 37.760401497127795 | -122.466821372375 | (37.7604014971278, -122.466821372375) |
| 140692 | 140692 | 108155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 875 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773852 | 5984778.38849 | 2109898.30957 | 37.772497726788 | -122.496089384061 | (37.772497726788, -122.496089384061) | |
| 10324 | 10324 | 108369 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773814 | 6001475.26516 | 2090061.55368 | 37.7189945287407 | -122.436912960177 | (37.7189945287407, -122.436912960177) |
| 186042 | 186042 | 72426 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4250X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 11 | 3x3 | Permit Number 773790 | 5990138.03134 | 2109951.66223 | 37.772956689267204 | -122.47755394624 | (37.7729566892672, -122.47755394624) |
| 102973 | 102973 | 37595 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 681 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773784 | 5992529.93541662 | 2110827.20816005 | 37.7754992113625 | -122.469343875957 | (37.7754992113625, -122.469343875957) | |
| 111424 | 111424 | 37596 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 681 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773784 | 5992531.87149 | 2110821.5175099997 | 37.775483698256394 | -122.469336764375 | (37.7754836982564, -122.469336764375) | |
| 99008 | 99008 | 108432 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2676 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773725 | 6010053.51551 | 2103992.82932 | 37.7577306409511 | -122.40824320120701 | (37.7577306409511, -122.408243201207) |
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");