Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1485 | 1485 | 115988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.40325542520901 | (37.7963995082912, -122.403255425209) | |
| 5858 | 5858 | 18862 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3PL | 6004143.20725 | 2116038.00121 | 37.790471010977505 | -122.42954249260201 | (37.7904710109775, -122.429542492602) | |||
| 5887 | 5887 | 94203 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | |
| 6585 | 6585 | 44092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.790485736467296 | -122.429415161181 | (37.7904857364673, -122.429415161181) | |
| 7288 | 7288 | 111098 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 754 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.78760928190211 | -122.414263235869 | (37.7876092819021, -122.414263235869) | ||
| 8677 | 8677 | 18861 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6004226.06461 | 2116051.48796 | 37.790512733214 | -122.42925677349 | (37.790512733214, -122.42925677349) | |||
| 9120 | 9120 | 4533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 03:02:00 PM | 6 | 5x5 | 6005057.0165 | 2113679.5647 | 37.7840470307287 | -122.42621279071001 | (37.7840470307287, -122.42621279071) | ||
| 9146 | 9146 | 4532 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005027.0371 | 2113673.2533 | 37.784028006637996 | -122.42631605911998 | (37.784028006638, -122.42631605912) | |||
| 9151 | 9151 | 4530 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | |||
| 9193 | 9193 | 4549 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004652.295 | 2113623.5507 | 37.7838703460943 | -122.427608988739 | (37.7838703460943, -122.427608988739) | |||
| 9249 | 9249 | 4552 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.42727974188101 | (37.7839147367985, -122.427279741881) | |||
| 9257 | 9257 | 4531 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | |||
| 9465 | 9465 | 4553 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004771.4236 | 2113636.9625 | 37.7839139091534 | -122.427197803426 | (37.7839139091534, -122.427197803426) | |||
| 10378 | 10378 | 98180 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768099 | 6007169.16242 | 2091641.99398 | 37.7236560602499 | -122.417343266399 | (37.7236560602499, -122.417343266399) | |
| 16738 | 16738 | 28934 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 260 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009412.25627 | 2110486.9627400003 | 37.775526107775704 | -122.41091961406299 | (37.7755261077757, -122.410919614063) | ||
| 16799 | 16799 | 57069 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | |
| 20605 | 20605 | 23 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 729 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2011 12:00:00 AM | 3 | 4x4 | 6003875.846919999 | 2107718.3128400003 | 37.7676120683604 | -122.429873853201 | (37.7676120683604, -122.429873853201) | ||
| 24787 | 24787 | 56080 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 723 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2011 12:00:00 AM | 2 | 3x3 | Permit Number 51743 | 5981333.03596 | 2110794.79787 | 37.774756814986794 | -122.50807353876199 | (37.7747568149868, -122.508073538762) | |
| 28685 | 28685 | 99380 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 29379 | 29379 | 105035 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015087.4436800005 | 2107939.01173 | 37.768846592924 | -122.391109479333 | (37.768846592924, -122.391109479333) | |||
| 30187 | 30187 | 97675 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000810.80569 | 2117928.4487099997 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | ||||
| 31094 | 31094 | 87873 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | |
| 33248 | 33248 | 94086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53469 | 5987161.9603 | 2103493.9012 | 37.7550523122054 | -122.48737396285101 | (37.7550523122054, -122.487373962851) | |
| 37316 | 37316 | 35009 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | ||
| 42249 | 42249 | 105036 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x6 | Permit Number 771181 | 6015089.32821 | 2107914.09587 | 37.7687782840212 | -122.39110121906201 | (37.7687782840212, -122.391101219062) | ||
| 43089 | 43089 | 46211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.43261542476299 | (37.7915512424562, -122.432615424763) | ||
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 47568 | 47568 | 54838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.773438741186204 | -122.44770637361201 | (37.7734387411862, -122.447706373612) | ||
| 47584 | 47584 | 97338 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1917 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989797.6411 | 2106487.0994 | 37.763424185107496 | -122.478477988866 | (37.7634241851075, -122.478477988866) | |||
| 48721 | 48721 | 33958 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | ||
| 49002 | 49002 | 97113 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1345 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 18860 | 5989785.9448 | 2103084.5073 | 37.7540808992005 | -122.478269637351 | (37.7540808992005, -122.478269637351) | |||
| 49942 | 49942 | 105026 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015072.88546 | 2108163.93601 | 37.7694633776739 | -122.39117555971599 | (37.7694633776739, -122.391175559716) | |||
| 51167 | 51167 | 32295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1616 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 5 | Permit Number 36875 | 6011596.3586 | 2107020.1725 | 37.7661293203346 | -122.40312032520201 | (37.7661293203346, -122.403120325202) | ||
| 54469 | 54469 | 57397 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.41518604372601 | (37.7903739066804, -122.415186043726) | ||
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 59281 | 59281 | 54994 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.2702900004 | 37.77519937131321 | -122.47479813592301 | (37.7751993713132, -122.474798135923) | ||
| 59444 | 59444 | 80749 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 375 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52325 | 6004167.50654 | 2090267.3011900003 | 37.719712117607 | -122.42762157938101 | (37.719712117607, -122.427621579381) | |
| 59549 | 59549 | 105029 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.74883 | 2108086.46133 | 37.769250919128 | -122.391153321267 | (37.769250919128, -122.391153321267) | |||
| 60958 | 60958 | 48733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.764210939174106 | -122.489081723593 | (37.7642109391741, -122.489081723593) | ||
| 61686 | 61686 | 105315 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | |||||
| 62074 | 62074 | 94211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.760450569952205 | -122.39622637625799 | (37.7604505699522, -122.396226376258) | |
| 63792 | 63792 | 64471 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2332 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 4 | Permit Number 25341 | 6003518.39121 | 2116605.0137 | 37.7919924858215 | -122.431744816269 | (37.7919924858215, -122.431744816269) | ||
| 63865 | 63865 | 98154 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | Permit Number 768787 | 5991271.26635 | 2112266.2977400003 | 37.779377741026394 | -122.473802878969 | (37.7793777410264, -122.473802878969) | ||
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 66308 | 66308 | 105031 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015081.19497 | 2108038.83155 | 37.7691203294602 | -122.391138071471 | (37.7691203294602, -122.391138071471) | |||
| 67146 | 67146 | 105243 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 616 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770335 | 6007163.0512 | 2091665.3874599999 | 37.723719949895 | -122.417366048922 | (37.723719949895, -122.417366048922) | |
| 70706 | 70706 | 105027 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015075.4785400005 | 2108137.72551 | 37.7693915533068 | -122.391164757946 | (37.7693915533068, -122.391164757946) | |||
| 71525 | 71525 | 97676 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | ||||
| 76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
| 77131 | 77131 | 54664 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.975769999 | 2086866.6648099998 | 37.710828684568206 | -122.399434200424 | (37.7108286845682, -122.399434200424) | ||
| 79949 | 79949 | 4516 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.42642640211099 | (37.7846101140023, -122.426426402111) | |||
| 80995 | 80995 | 81638 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.40191602971301 | (37.7237978701092, -122.401916029713) | ||
| 81513 | 81513 | 102256 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 82615 | 82615 | 105316 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | ||||
| 83610 | 83610 | 105034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
| 89315 | 89315 | 99393 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 89862 | 89862 | 99399 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 90324 | 90324 | 30582 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 90650 | 90650 | 30584 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 91731 | 91731 | 83341 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 422-24 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50786 | 6002931.20131858 | 2105783.16408091 | 37.762245079378 | -122.433002986091 | (37.762245079378, -122.433002986091) | ||
| 92160 | 92160 | 39928 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | |||
| 92502 | 92502 | 101350 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 94438 | 94438 | 41525 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.733693765900604 | -122.37859297315 | (37.7336937659006, -122.37859297315) | |||
| 94707 | 94707 | 94202 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232.0 | 2118962.0 | 37.798730248485896 | -122.415602598872 | (37.7987302484859, -122.415602598872) | |
| 95142 | 95142 | 12754 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1730 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 2 | 3X4 | 5990033.131630001 | 2114754.17722 | 37.786136974525 | -122.478268017968 | (37.786136974525, -122.478268017968) | ||
| 95348 | 95348 | 97442 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 95689 | 95689 | 16894 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.42518697132401 | (37.7745648206797, -122.425186971324) | ||
| 97235 | 97235 | 4548 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 98803 | 98803 | 104725 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | ||
| 100674 | 100674 | 98153 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258.0 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | |||
| 100937 | 100937 | 105033 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
| 102408 | 102408 | 101353 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 102467 | 102467 | 105032 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
| 105384 | 105384 | 55357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | |||
| 105518 | 105518 | 39927 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | |||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 105851 | 105851 | 55533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.759848834973795 | -122.439733631625 | (37.7598488349738, -122.439733631625) | ||
| 108977 | 108977 | 99385 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 109705 | 109705 | 102257 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 2 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 110341 | 110341 | 99386 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 110478 | 110478 | 30583 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 111793 | 111793 | 93854 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875.0 | 2103807.0 | 37.7561278331456 | -122.47455618324601 | (37.7561278331456, -122.474556183246) | ||
| 111896 | 111896 | 63101 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.759851779436495 | -122.439687471955 | (37.7598517794365, -122.439687471955) | ||
| 111944 | 111944 | 16905 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 441 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6004878.06154 | 2110135.30859 | 37.774305258573996 | -122.426579447402 | (37.774305258574, -122.426579447402) | ||
| 112798 | 112798 | 99381 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 113044 | 113044 | 99398 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 113645 | 113645 | 97286 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768450 | 5993053.0 | 2098535.0 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | |||
| 114236 | 114236 | 30585 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 114337 | 114337 | 99387 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 115563 | 115563 | 101359 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 115661 | 115661 | 99395 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 117450 | 117450 | 108296 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 118595 | 118595 | 104724 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | |||
| 119172 | 119172 | 4547 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 119383 | 119383 | 108297 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 120267 | 120267 | 27626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008495.093859999 | 2120769.31703 | 37.8037074748624 | -122.41482018433399 | (37.8037074748624, -122.414820184334) | |||
| 120563 | 120563 | 34888 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 252 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774542 | 5990895.02345 | 2113704.92636 | 37.7833060185493 | -122.475209503253 | (37.7833060185493, -122.475209503253) | |
| 125055 | 125055 | 48453 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.45752914479601 | (37.7839689836389, -122.457529144796) | ||
| 125957 | 125957 | 108295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 128972 | 128972 | 108294 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) |
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");