Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 98308 | 98308 | 107371 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 448 BROADWAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | ||||
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 107985 | 107985 | 92049 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 2850 | 2850 | 27607 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001133.4058 | 2111053.0447 | 37.7766127217509 | -122.439598674592 | (37.7766127217509, -122.439598674592) | |||
| 3035 | 3035 | 240686 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.749767577309605 | -122.40709853768499 | (37.7497675773096, -122.407098537685) | |
| 3230 | 3230 | 1713 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085005 | -122.40074798855 | (37.796643729085, -122.40074798855) | |||
| 5667 | 5667 | 102263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2037 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001878.76288 | 2115606.3786400002 | 37.78915741351871 | -122.437346392945 | (37.7891574135187, -122.437346392945) | |||
| 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) | ||
| 7797 | 7797 | 6925 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 460 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005200.4571 | 2110629.3361 | 37.7756799587692 | -122.42549938705099 | (37.7756799587692, -122.425499387051) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 16227 | 16227 | 7404 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1060 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 24 | 3X3 | 6010543.2443 | 2111181.3457 | 37.777496075538004 | -122.407056190657 | (37.777496075538, -122.407056190657) | ||
| 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) | |
| 17457 | 17457 | 25179 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999420.685330001 | 2104753.2461200003 | 37.7592174321694 | -122.445070446966 | (37.7592174321694, -122.445070446966) | ||
| 19126 | 19126 | 89429 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2608 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990547.63767 | 2112005.7823900003 | 37.778620499636 | -122.476287153711 | (37.778620499636, -122.476287153711) | ||
| 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) | ||
| 23366 | 23366 | 227653 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.43128265198901 | (37.7563447763019, -122.431282651989) | |||
| 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) | |
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 26269 | 26269 | 207097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 451 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996075.95126 | 2096408.69413 | 37.7361138982453 | -122.45603479789301 | (37.7361138982453, -122.456034797893) | |||
| 26316 | 26316 | 176960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 242 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012452.5611 | 2087695.0016599998 | 37.7131142557927 | -122.39880247885701 | (37.7131142557927, -122.398802478857) | |||
| 27723 | 27723 | 129402 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3000 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999090.32735 | 2119096.86414 | 37.7985824452762 | -122.44724531075 | (37.7985824452762, -122.44724531075) | |||
| 29311 | 29311 | 199962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018011.0370000005 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | |||
| 29861 | 29861 | 227623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001957.40527 | 2101134.69618 | 37.7494262207603 | -122.43603832812599 | (37.7494262207603, -122.436038328126) | |||
| 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) | ||||
| 30701 | 30701 | 71808 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5989823.9383 | 2098417.3202 | 37.741268233056395 | -122.477797097779 | (37.7412682330564, -122.477797097779) | ||
| 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) | |
| 31281 | 31281 | 227616 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 246 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999006.659659999 | 2106731.5709599997 | 37.764625778676 | -122.44664468051 | (37.764625778676, -122.44664468051) | |||
| 31453 | 31453 | 207072 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 245 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994440.698340001 | 2100406.16627 | 37.7469959638947 | -122.46197828057899 | (37.7469959638947, -122.461978280579) | |||
| 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) | |
| 33924 | 33924 | 38574 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | |
| 34205 | 34205 | 207067 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 319 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992889.43355 | 2094705.1306900003 | 37.731252923187796 | -122.466927982745 | (37.7312529231878, -122.466927982745) | |||
| 34489 | 34489 | 183440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098754.1113 | 37.7421770482141 | -122.47877029228998 | (37.7421770482141, -122.47877029229) | |||
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 35192 | 35192 | 191336 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015056.82202 | 2108488.85287 | 37.7703546363753 | -122.391253838509 | (37.7703546363753, -122.391253838509) | |||
| 35287 | 35287 | 35365 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | |
| 35610 | 35610 | 176951 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 63 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012562.34064 | 2087723.35892 | 37.7131982353775 | -122.398425029786 | (37.7131982353775, -122.398425029786) | |||
| 36363 | 36363 | 207082 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992234.50744 | 2102126.7079 | 37.7515928656239 | -122.46973226583799 | (37.7515928656239, -122.469732265838) | |||
| 37113 | 37113 | 176939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012245.82216 | 2087941.3179099998 | 37.7137790697309 | -122.399534325569 | (37.7137790697309, -122.399534325569) | |||
| 37340 | 37340 | 227600 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 308 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6006510.89149 | 2104242.1298 | 37.7582161548565 | -122.420512774045 | (37.7582161548565, -122.420512774045) | |||
| 37486 | 37486 | 227656 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 148 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001371.492269999 | 2107387.94373 | 37.7665628167523 | -122.43851240444799 | (37.7665628167523, -122.438512404448) | |||
| 37575 | 37575 | 176976 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002487.993290001 | 2086859.8664400002 | 37.710260908397395 | -122.433183714473 | (37.7102609083974, -122.433183714473) | |||
| 38136 | 38136 | 46819 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 366 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 10 | Permit Number 44897 | 6004049.020819999 | 2091179.47735 | 37.7222100502291 | -122.428096112963 | (37.7222100502291, -122.428096112963) | |
| 38656 | 38656 | 176952 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.713231664082706 | -122.39812684519698 | (37.7132316640827, -122.398126845197) | |||
| 38876 | 38876 | 142250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 41237 | 41237 | 207083 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992235.15443 | 2102157.44312 | 37.7516772939722 | -122.469732265856 | (37.7516772939722, -122.469732265856) | |||
| 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) | ||
| 43673 | 43673 | 247493 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 806 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | |||
| 43921 | 43921 | 227634 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3238 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008149.92124 | 2100968.79152 | 37.7493205414166 | -122.414612642259 | (37.7493205414166, -122.414612642259) | |||
| 44149 | 44149 | 30586 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481001 | (37.7726573855875, -122.43410610481) | |
| 44547 | 44547 | 191291 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.39328832798701 | (37.7755965678638, -122.393288327987) | |||
| 44629 | 44629 | 129403 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | |||
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 45275 | 45275 | 227654 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004930.05045 | 2104005.07306 | 37.7574760371124 | -122.42596313868201 | (37.7574760371124, -122.425963138682) | |||
| 45357 | 45357 | 120682 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2917 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989597.69972 | 2111917.78775 | 37.7783237566214 | -122.479566877639 | (37.7783237566214, -122.479566877639) | |||
| 45384 | 45384 | 119342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.78070095968079 | -122.492222971302 | (37.7807009596808, -122.492222971302) | |||
| 45505 | 45505 | 176953 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012671.13481 | 2087736.7840599997 | 37.713241158228705 | -122.39804993876999 | (37.7132411582287, -122.39804993877) | |||
| 46075 | 46075 | 191248 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010994.55519 | 2105384.5641 | 37.7616046825239 | -122.405086676019 | (37.7616046825239, -122.405086676019) | |||
| 46359 | 46359 | 129457 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | |||
| 46965 | 46965 | 176936 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012351.49393 | 2087873.7751200001 | 37.713599500286 | -122.399164344459 | (37.713599500286, -122.399164344459) | |||
| 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) | |||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 47927 | 47927 | 227620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005907.97007 | 2102264.4901400004 | 37.752752018913796 | -122.422457421298 | (37.7527520189138, -122.422457421298) | |||
| 49423 | 49423 | 37645 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990141.86983 | 2111994.48348 | 37.7785659364855 | -122.477690019436 | (37.7785659364855, -122.477690019436) | |
| 49437 | 49437 | 227622 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221001 | (37.748648223551, -122.43700910221) | |||
| 49816 | 49816 | 207050 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | |||
| 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) | |||
| 51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
| 52561 | 52561 | 114222 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 2x2 | 6012512.59554 | 2087744.0784200002 | 37.713252355697605 | -122.398598420002 | (37.7132523556976, -122.398598420002) | |||
| 52608 | 52608 | 207096 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 447 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996040.3151 | 2096410.52388 | 37.7361168767915 | -122.456158138087 | (37.7361168767915, -122.456158138087) | |||
| 52761 | 52761 | 129417 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003236.15275 | 2117871.33798 | 37.795453484440706 | -122.432811866398 | (37.7954534844407, -122.432811866398) | |||
| 53050 | 53050 | 245954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.44920319850401 | (37.7671425117336, -122.449203198504) | |||
| 54047 | 54047 | 176922 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003957.47292 | 2089506.6993599997 | 37.7176117887305 | -122.42829341070801 | (37.7176117887305, -122.428293410708) | |||
| 54202 | 54202 | 117939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983833.6821099995 | 2109720.9042700003 | 37.7719552435785 | -122.49934405400101 | (37.7719552435785, -122.499344054001) | |||
| 54446 | 54446 | 129451 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1147 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007395.89235 | 2119499.90916 | 37.80016017810029 | -122.418533970572 | (37.8001601781003, -122.418533970572) | |||
| 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) | ||
| 54686 | 54686 | 142249 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 619 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004863.0676 | 2110879.3064 | 37.7763472473304 | -122.42668430629101 | (37.7763472473304, -122.426684306291) | |||
| 55800 | 55800 | 227661 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003680.16981 | 2096890.8857099998 | 37.7378714190205 | -122.42977831104099 | (37.7378714190205, -122.429778311041) | |||
| 56287 | 56287 | 227611 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6008811.16325 | 2101739.4503099998 | 37.751473726132005 | -122.412380510571 | (37.751473726132, -122.412380510571) | |||
| 56357 | 56357 | 43807 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 530 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43437 | 5988458.677999999 | 2112363.29745 | 37.7794807721264 | -122.48353979825899 | (37.7794807721264, -122.483539798259) | |
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 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) | ||
| 57506 | 57506 | 227659 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003786.3248 | 2109251.28052 | 37.771816154325 | -122.430292880621 | (37.771816154325, -122.430292880621) | |||
| 57672 | 57672 | 119485 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5526 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5986205.51331 | 2109807.2757599996 | 37.772331260735605 | -122.49114618500799 | (37.7723312607356, -122.491146185008) | |||
| 58227 | 58227 | 227613 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010812.412330001 | 2099853.77151 | 37.746408165199796 | -122.405327133143 | (37.7464081651998, -122.405327133143) | |||
| 58867 | 58867 | 247173 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6001348.76723 | 2108505.96887 | 37.7696313440465 | -122.438671125768 | (37.7696313440465, -122.438671125768) | |||
| 59034 | 59034 | 129459 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 458 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011895.81451 | 2118092.21584 | 37.7965472956624 | -122.402863344166 | (37.7965472956624, -122.402863344166) | |||
| 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) | |
| 60304 | 60304 | 191330 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014815.79386 | 2110104.2477700002 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | |||
| 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) | ||
| 61708 | 61708 | 227660 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 195 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.73974812787179 | -122.43178856828101 | (37.7397481278718, -122.431788568281) |
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");