trees
861 rows where qSpecies_id = 18 sorted by qLegalStatus_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▲ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135688 | 1716 | Landmark tree 11 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x15 | 6012528.51285 | 2117974.41064 | 37.7962591384932 | -122.400665775228 | (37.7962591384932, -122.400665775228) | 3 | 1 | 10 | 28860 | 4 | |||
3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8858 | 261455 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
11157 | 261456 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15415 | 261457 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
20425 | 44213 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1601 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 43660 | 5993363.56248215 | 2104576.56937915 | 37.7583847466967 | -122.466005883185 | (37.7583847466967, -122.466005883185) | 1 | 8 | 4 | 56 | 12 | ||
25393 | 31771 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
25613 | 37524 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1154 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779577 | 6007313.66795 | 2115327.60271 | 37.7886994328701 | -122.418522478123 | (37.7886994328701, -122.418522478123) | 13 | 9 | 10 | 28858 | 21 |
26449 | 37034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 266 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.425773019549 | (37.7422146471398, -122.425773019549) | 2 | 7 | 5 | 63 | 22 | ||
31466 | 45705 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2919 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44379 | 6009358.73784624 | 2102738.93586586 | 37.754248802934 | -122.410557495705 | (37.754248802934, -122.410557495705) | 2 | 4 | 7 | 28859 | 19 | ||
33337 | 108294 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | |||
36272 | 108295 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
42397 | 4516 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
42693 | 105034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
42904 | 31734 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005 | 2098357 | 37.7411131158778 | -122.477166650257 | (37.7411131158778, -122.477166650257) | 1 | 8 | 3 | 29491 | 35 | ||
47953 | 105316 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | ||||
49133 | 81638 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.401916029713 | (37.7237978701092, -122.401916029713) | 10 | 3 | 7 | 309 | 28 | ||
56833 | 38678 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.7766245566345 | -122.439428187036 | (37.7766245566345, -122.439428187036) | 15 | 5 | 11 | 29492 | 10 | ||
62609 | 52479 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | 10 | 7 | 7 | 28859 | 2 | ||
70376 | 30582 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
70731 | 30584 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
70900 | 30508 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 363 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40123 | 6009708.62861324 | 2092740.2698514 | 37.7268142455477 | -122.408642172932 | (37.7268142455477, -122.408642172932) | 10 | 3 | 7 | 309 | 28 | ||
77639 | 16894 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.425186971324 | (37.7745648206797, -122.425186971324) | 7 | 9 | 11 | 28852 | 10 | ||
78623 | 97442 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||||
80345 | 41525 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.7336937659006 | -122.37859297315 | (37.7336937659006, -122.37859297315) | 10 | 3 | 8 | 58 | 1 | |||
80923 | 83341 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 422-24 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50786 | 6002931.20131858 | 2105783.16408091 | 37.762245079378 | -122.433002986091 | (37.762245079378, -122.433002986091) | 15 | 4 | 5 | 28862 | 3 | ||
83215 | 32892 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) | 11 | 5 | 11 | 56 | 12 |
84169 | 42428 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42578 | 5997011.02141138 | 2094977.36766372 | 37.7322374467316 | -122.452698626411 | (37.7322374467316, -122.452698626411) | 9 | 7 | 4 | 59 | 40 | ||
87832 | 176961 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 41 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781344 | 6011207.15899 | 2087778.71194 | 37.7132746363936 | -122.403112916852 | (37.7132746363936, -122.403112916852) | 9 | 7 | 8 | 309 | 39 |
87905 | 101350 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
88007 | 4548 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
90924 | 31792 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | 15 | 5 | 5 | 29492 | 9 | ||
93851 | 39928 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | 9 | 7 | 8 | 309 | 39 | |||
94349 | 94202 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232 | 2118962 | 37.7987302484859 | -122.415602598872 | (37.7987302484859, -122.415602598872) | 5 | 1 | 10 | 308 | 32 | |
98941 | 34270 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.488372976967 | (37.7872778329962, -122.488372976967) | 11 | 6 | 1 | 55 | 33 | ||
102523 | 31731 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005 | 2098357 | 37.7411131158778 | -122.477166650257 | (37.7411131158778, -122.477166650257) | 1 | 8 | 3 | 29491 | 35 | ||
104978 | 48988 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2002 12:00:00 AM | Permit Number 46175 | 6005014.67029629 | 2099626.41666977 | 37.7454580443014 | -122.4253588996 | (37.7454580443014, -122.4253588996) | 2 | 7 | 5 | 63 | 22 | ||
105414 | 104725 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | ||
105451 | 31795 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 141 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35265 | 6001336.75578377 | 2108526.84088843 | 37.7696879701055 | -122.438714168685 | (37.7696879701055, -122.438714168685) | 15 | 5 | 5 | 29492 | 9 | ||
105695 | 98153 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | 11 | 6 | 2 | 54 | 26 | |||
106589 | 65445 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 922 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | 13 | 1 | 10 | 28858 | 21 | ||
106718 | 31776 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
107011 | 105032 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
108911 | 105033 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
109190 | 34272 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
112886 | 101353 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
115855 | 39927 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | 9 | 7 | 8 | 309 | 39 | |||
117570 | 96626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
118708 | 34269 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.488372976967 | (37.7872778329962, -122.488372976967) | 11 | 6 | 1 | 55 | 33 | ||
121397 | 31773 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
128101 | 55533 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.7598488349738 | -122.439733631625 | (37.7598488349738, -122.439733631625) | 2 | 4 | 5 | 28862 | 3 | ||
128245 | 55357 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | 2 | 4 | 5 | 28862 | 22 | |||
135442 | 30583 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
138410 | 101359 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.413295071436 | (37.803771736238, -122.413295071436) | 3 | 1 | 10 | 308 | 23 | ||
140002 | 45704 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2923 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44378 | 6009338.32453862 | 2102737.8165792 | 37.7542445851646 | -122.410628011277 | (37.7542445851646, -122.410628011277) | 2 | 4 | 7 | 28859 | 19 | ||
141908 | 50485 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.7204059497171 | -122.454008375647 | (37.7204059497171, -122.454008375647) | 9 | 8 | 6 | 28861 | 24 | ||
142412 | 63101 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.7598517794365 | -122.439687471955 | (37.7598517794365, -122.439687471955) | 2 | 4 | 5 | 28862 | 3 | ||
144937 | 93854 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875 | 2103807 | 37.7561278331456 | -122.474556183246 | (37.7561278331456, -122.474556183246) | 1 | 8 | 4 | 56 | 12 | ||
147379 | 16905 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 441 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6004878.06154 | 2110135.30859 | 37.774305258574 | -122.426579447402 | (37.774305258574, -122.426579447402) | 7 | 9 | 11 | 28852 | 10 | ||
148005 | 97286 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768450 | 5993053 | 2098535 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | 1 | 8 | 4 | 59 | 40 | |||
150193 | 30585 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
150513 | 37577 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | 2 | 4 | 5 | 28862 | 3 | ||
152651 | 27626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008495.09386 | 2120769.31703 | 37.8037074748624 | -122.414820184334 | (37.8037074748624, -122.414820184334) | 5 | 1 | 10 | 308 | 23 | |||
153284 | 30569 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | Permit Number 34546 | 6003788.00361454 | 2109234.47759535 | 37.771770112694 | -122.430285874486 | (37.771770112694, -122.430285874486) | 7 | 9 | 11 | 29492 | 10 | ||
153462 | 108297 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
154682 | 4547 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
154792 | 108296 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
163187 | 38679 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.7766245566345 | -122.439428187036 | (37.7766245566345, -122.439428187036) | 15 | 5 | 11 | 29492 | 10 | ||
164798 | 37466 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | 10 | 7 | 7 | 28859 | 2 | ||
165903 | 31772 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
167223 | 104724 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | |||
170331 | 36895 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39548 | 6001738.91463484 | 2103541.42716619 | 37.7560221127265 | -122.436966152078 | (37.7560221127265, -122.436966152078) | 2 | 4 | 5 | 28862 | 3 | ||
170885 | 109806 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.470479988054 | (37.764483341532, -122.470479988054) | 11 | 8 | 11 | 56 | 12 |
180161 | 34271 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
192751 | 64085 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | 1 | 8 | 4 | 29491 | 40 | |||
194062 | 96627 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
194237 | 31775 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
7739 | 262320 | Section 806 (d) 5 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2567 31st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/07/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785009 | 5986744.29234 | 2097795.22153 | 37.7393809030196 | -122.48839957369 | (37.7393809030196, -122.48839957369) | 1 | 8 | 3 | 29491 | 35 | |
22042 | 102557 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
28352 | 102555 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
32862 | 102563 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
36210 | 102562 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
54279 | 102559 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
72314 | 102564 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
75100 | 99759 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4295x 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.435981539714 | (37.7495164396885, -122.435981539714) | 2 | 4 | 5 | 28862 | 22 | ||||
86958 | 112623 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6012539 | 2087662 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | 10 | 3 | 8 | 309 | 1 | ||||
91278 | 102561 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
98008 | 99758 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4295x 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.435981539714 | (37.7495164396885, -122.435981539714) | 2 | 4 | 5 | 28862 | 22 | ||||
104464 | 102565 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
111235 | 107371 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 448 BROADWAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | 3 | 1 | 10 | 308 | 23 | ||||
115276 | 122590 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6008161 | 2119143 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | 5 | 1 | 10 | 308 | 32 | |||||
131073 | 102554 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );