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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18174 | 18174 | 7503 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008331.5003 | 2102528.18533 | 37.753612485742295 | -122.41409504285 | (37.7536124857423, -122.41409504285) | |||
| 18255 | 18255 | 7469 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2623 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008298.43979 | 2103140.4111200003 | 37.7552916620849 | -122.414252686824 | (37.7552916620849, -122.414252686824) | |||
| 18329 | 18329 | 7501 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2004 12:00:00 AM | 6 | 3X3 | 6008270.89385 | 2102590.17173 | 37.7537792820952 | -122.414309019468 | (37.7537792820952, -122.414309019468) | ||
| 18353 | 18353 | 7435 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2520 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1999 12:00:00 AM | 18 | 3X3 | 6008207.33227 | 2103733.52781 | 37.756915107460706 | -122.414609734768 | (37.7569151074607, -122.414609734768) | ||
| 18443 | 18443 | 7462 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2595 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008288.941269999 | 2103332.41139 | 37.7558183176666 | -122.414299119707 | (37.7558183176666, -122.414299119707) | |||
| 18470 | 18470 | 7438 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2525 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008265.55566 | 2103676.03648 | 37.7567605203109 | -122.41440430801599 | (37.7567605203109, -122.414404308016) | |||
| 18529 | 18529 | 14595 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1237 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5999420.8847 | 2108569.3753 | 37.769695580046296 | -122.445344141815 | (37.7696955800463, -122.445344141815) | ||
| 18635 | 18635 | 102526 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 312 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769739 | 5998624.0 | 2115422.5 | 37.7884669637257 | -122.448594170268 | (37.7884669637257, -122.448594170268) | |||
| 18904 | 18904 | 7466 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2601 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008295.31777 | 2103224.31145 | 37.7555218579731 | -122.41426941961001 | (37.7555218579731, -122.41426941961) | |||
| 18924 | 18924 | 7460 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2585 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008283.172069999 | 2103400.23243 | 37.7560042147509 | -122.414323869978 | (37.7560042147509, -122.414323869978) | |||
| 18939 | 18939 | 7554 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2906 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.04331 | 2101493.18506 | 37.7507705264571 | -122.414026867047 | (37.7507705264571, -122.414026867047) | |||
| 19037 | 19037 | 7013 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.774315477420295 | -122.435062751747 | (37.7743154774203, -122.435062751747) | ||
| 19189 | 19189 | 7510 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2740 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008277.62193 | 2102459.7127 | 37.7534214490446 | -122.41427652245001 | (37.7534214490446, -122.41427652245) | |||
| 19273 | 19273 | 48943 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901001 | (37.7524811515419, -122.40536498901) | ||
| 19287 | 19287 | 7488 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008316.60225 | 2102810.93946 | 37.7543880278024 | -122.41416656683501 | (37.7543880278024, -122.414166566835) | |||
| 19327 | 19327 | 7658 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3335 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | 3 | 3x3 | 6008522.8365 | 2099251.39925 | 37.7446259085611 | -122.41320166263 | (37.7446259085611, -122.41320166263) | ||
| 19328 | 19328 | 7470 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2629 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6008300.06862 | 2103096.2458 | 37.755170485633 | -122.41424392921002 | (37.755170485633, -122.41424392921) | |||
| 19439 | 19439 | 28789 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2948 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6008341.65854 | 2101291.24867 | 37.7502167068411 | -122.413972416691 | (37.7502167068411, -122.413972416691) | ||
| 19576 | 19576 | 7525 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2804 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008301.92426 | 2102042.90132 | 37.7522783441942 | -122.41416299292601 | (37.7522783441942, -122.414162992926) | |||
| 19588 | 19588 | 7552 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2894 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008324.51175 | 2101611.42037 | 37.751094863355895 | -122.414054359326 | (37.7510948633559, -122.414054359326) | ||
| 19591 | 19591 | 7508 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2733 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008332.697980001 | 2102504.20303 | 37.753546703038296 | -122.41408920446699 | (37.7535467030383, -122.414089204467) | |||
| 19628 | 19628 | 7471 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2637 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008304.34072 | 2103057.49026 | 37.755064311682 | -122.414226413135 | (37.755064311682, -122.414226413135) | |||
| 19630 | 19630 | 7453 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2570 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008223.86046 | 2103457.0339200003 | 37.7561568467812 | -122.414533009104 | (37.7561568467812, -122.414533009104) | |||
| 19718 | 19718 | 23643 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6006665.3047400005 | 2098482.5639400003 | 37.742410400808296 | -122.419570116381 | (37.7424104008083, -122.419570116381) | ||
| 19810 | 19810 | 47528 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 19814 | 19814 | 7557 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2909 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2011 12:00:00 AM | 3 | 4x4 | 6008393.46054 | 2101471.49038 | 37.7507145193727 | -122.413806029524 | (37.7507145193727, -122.413806029524) | ||
| 19825 | 19825 | 7539 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2857 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008370.65475 | 2101801.07309 | 37.7516181986274 | -122.41390820600701 | (37.7516181986274, -122.413908206007) | |||
| 19952 | 19952 | 7655 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3331 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | 3 | 4x4 | 6008519.80485 | 2099268.2736299997 | 37.744672071672504 | -122.41321333853 | (37.7446720716725, -122.41321333853) | ||
| 20038 | 20038 | 7605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3161 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008457.15281 | 2100295.8297099997 | 37.747489994777105 | -122.413502636944 | (37.7474899947771, -122.413502636944) | |||
| 20066 | 20066 | 7641 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3289 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6008504.24968 | 2099498.35818 | 37.7453029595644 | -122.41328339301901 | (37.7453029595644, -122.413283393019) | |||
| 20069 | 20069 | 7575 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2970 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6008351.10034 | 2101124.2510900004 | 37.749758699223705 | -122.413927954233 | (37.7497586992237, -122.413927954233) | |||
| 20308 | 20308 | 7459 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2584 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008225.5922300005 | 2103401.76682 | 37.7560051931888 | -122.41452310937599 | (37.7560051931888, -122.414523109376) | |||
| 20424 | 20424 | 7549 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2883 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6008378.51382 | 2101648.7543099998 | 37.7512004068929 | -122.413870254611 | (37.7512004068929, -122.413870254611) | |||
| 20464 | 20464 | 7530 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2824 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008306.16811 | 2101970.47536 | 37.7520797172086 | -122.41414319344601 | (37.7520797172086, -122.414143193446) | |||
| 20521 | 20521 | 7487 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008318.247830001 | 2102788.20898 | 37.7543257074831 | -122.41415926793002 | (37.7543257074831, -122.41415926793) | |||
| 20562 | 20562 | 7634 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3256 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008430.659080001 | 2099734.11047 | 37.745946151106295 | -122.41355452874201 | (37.7459461511063, -122.413554528742) | |||
| 20687 | 20687 | 7517 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2771 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008345.2937199995 | 2102315.22385 | 37.753028516357006 | -122.41403227737801 | (37.753028516357, -122.414032277378) | |||
| 20695 | 20695 | 7467 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2608 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008233.92033 | 2103214.16495 | 37.755490548966996 | -122.414481033691 | (37.755490548967, -122.414481033691) | |||
| 20774 | 20774 | 7516 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2764 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x5 | 6008283.77365 | 2102310.17771 | 37.753011205311395 | -122.414244669368 | (37.7530112053114, -122.414244669368) | |||
| 20814 | 20814 | 9361 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 252 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 2x2 | 6001048.03235 | 2098320.17238 | 37.741646502277206 | -122.43898127678999 | (37.7416465022772, -122.43898127679) | |||
| 20891 | 20891 | 607 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008349.31996 | 2102181.9005400003 | 37.7526626667701 | -122.414008922882 | (37.7526626667701, -122.414008922882) | |||
| 20914 | 20914 | 4566 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106X Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 12 | 3X3 | 6006479.71302 | 2098542.22808 | 37.742563769401606 | -122.42021607152901 | (37.7425637694016, -122.420216071529) | ||
| 20985 | 20985 | 87685 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 Virginia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | |||
| 21053 | 21053 | 7515 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2760 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6008282.29064 | 2102342.6354400003 | 37.7531002436021 | -122.41425209418301 | (37.7531002436021, -122.414252094183) | |||
| 21079 | 21079 | 7447 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2553 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008274.59683 | 2103558.26276 | 37.7564376483819 | -122.414364707267 | (37.7564376483819, -122.414364707267) | |||
| 21092 | 21092 | 7500 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2709 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008323.747269999 | 2102623.75492 | 37.753874462753295 | -122.414128615438 | (37.7538744627533, -122.414128615438) | |||
| 21111 | 21111 | 7518 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2773 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008341.70972 | 2102366.99606 | 37.7531704698575 | -122.41404833388701 | (37.7531704698575, -122.414048333887) | |||
| 21142 | 21142 | 7514 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2757 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008339.77996 | 2102396.4575099996 | 37.753251255958 | -122.414057091485 | (37.753251255958, -122.414057091485) | |||
| 21157 | 21157 | 32488 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 282 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50560 | 6000387.70986 | 2106807.48138 | 37.7649130014568 | -122.44187345869899 | (37.7649130014568, -122.441873458699) | |
| 21173 | 21173 | 7444 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2542 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008213.31422 | 2103623.65609 | 37.7566137608307 | -122.41458127211901 | (37.7566137608307, -122.414581272119) | |||
| 21208 | 21208 | 7522 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6008356.19666 | 2102043.47464 | 37.752282966686295 | -122.413975350304 | (37.7522829666863, -122.413975350304) | |||
| 21254 | 21254 | 7533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2828 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008307.50976 | 2101942.03769 | 37.7520017091344 | -122.414136542092 | (37.7520017091344, -122.414136542092) | |||
| 21274 | 21274 | 7489 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008322.6919 | 2102757.85565 | 37.754242613729794 | -122.41414175185801 | (37.7542426137298, -122.414141751858) | |||
| 21297 | 21297 | 7521 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2790X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6008290.58191 | 2102188.16765 | 37.7526765756645 | -122.414212493437 | (37.7526765756645, -122.414212493437) | |||
| 21359 | 21359 | 7512 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2749 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008338.58227 | 2102420.44014 | 37.753317039572394 | -122.41406292987499 | (37.7533170395724, -122.414062929875) | |||
| 21393 | 21393 | 7546 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2877 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008375.68859 | 2101675.71306 | 37.751274270892 | -122.413881931411 | (37.751274270892, -122.413881931411) | |||
| 21409 | 21409 | 7441 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2533 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008268.72512 | 2103638.5572599997 | 37.7566577889552 | -122.414390694984 | (37.7566577889552, -122.414390694984) | |||
| 21417 | 21417 | 7439 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2530 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008208.94625 | 2103707.4827 | 37.7568436842019 | -122.414602309975 | (37.7568436842019, -122.414602309975) | |||
| 21473 | 21473 | 7499 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2701 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008322.359759999 | 2102659.08935 | 37.7539714051695 | -122.414135913444 | (37.7539714051695, -122.414135913444) | |||
| 21495 | 21495 | 7558 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2914 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3x3 | 6008334.08225 | 2101415.12982 | 37.7505564311505 | -122.414007378743 | (37.7505564311505, -122.414007378743) | ||
| 21569 | 21569 | 7502 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2715 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008326.89994 | 2102592.16702 | 37.7537879066042 | -122.414115478143 | (37.7537879066042, -122.414115478143) | |||
| 21643 | 21643 | 606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008351.06015 | 2102163.79121 | 37.75261304037179 | -122.41400162398399 | (37.7526130403718, -122.414001623984) | |||
| 21762 | 21762 | 7538 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2850 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008311.6922 | 2101838.15576 | 37.751716707677005 | -122.414114729924 | (37.751716707677, -122.414114729924) | |||
| 21774 | 21774 | 7556 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2908 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6008332.644180001 | 2101445.38004 | 37.7506394106909 | -122.41401449147301 | (37.7506394106909, -122.414014491473) | ||
| 21798 | 21798 | 7504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.67294 | 2102549.63808 | 37.75367134367279 | -122.414099421647 | (37.7536713436728, -122.414099421647) | |||
| 21812 | 21812 | 7578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2981 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2011 12:00:00 AM | 3 | 3x3 | 6008415.2713 | 2101072.56886 | 37.749620395175704 | -122.413702392551 | (37.7496203951757, -122.413702392551) | ||
| 21975 | 21975 | 7428 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2507 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008259.11324 | 2103798.38895 | 37.757096110403 | -122.414435245589 | (37.757096110403, -122.414435245589) | |||
| 22060 | 22060 | 7511 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2746 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6008278.19971 | 2102422.54069 | 37.7533194155643 | -122.414271894535 | (37.7533194155643, -122.414271894535) | |||
| 22081 | 22081 | 7458 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2576 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008224.65711 | 2103426.0166 | 37.7560717250334 | -122.41452805924 | (37.7560717250334, -122.41452805924) | |||
| 22094 | 22094 | 7457 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2577 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008281.25133 | 2103428.77827 | 37.7560824872415 | -122.414332532234 | (37.7560824872415, -122.414332532234) | |||
| 22126 | 22126 | 7507 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2732 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008276.1167 | 2102495.63386 | 37.7535199958745 | -122.41428426921699 | (37.7535199958745, -122.414284269217) | |||
| 22130 | 22130 | 7455 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2573 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008281.50576 | 2103458.70502 | 37.7561646735838 | -122.41433376971202 | (37.7561646735838, -122.414333769712) | |||
| 22148 | 22148 | 7498 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008269.84083 | 2102643.6447900003 | 37.7539260478636 | -122.414316444251 | (37.7539260478636, -122.414316444251) | |||
| 22153 | 22153 | 7505 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2722 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008270.982530001 | 2102559.5246200003 | 37.7536951370472 | -122.41430654453801 | (37.7536951370472, -122.414306544538) | |||
| 22184 | 22184 | 7519 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2779 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008346.733630001 | 2102261.81397 | 37.752881945755895 | -122.41402351977399 | (37.7528819457559, -122.414023519774) | |||
| 22268 | 22268 | 7450 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2561 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008277.67861 | 2103516.50911 | 37.75632317547829 | -122.41435109514799 | (37.7563231754783, -122.414351095148) | |||
| 22278 | 22278 | 7433 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2515 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008263.61131 | 2103755.8939400003 | 37.7569796814773 | -122.41441668270399 | (37.7569796814773, -122.414416682704) | |||
| 26322 | 26322 | 97267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769192 | 5999912.27224 | 2116008.29642 | 37.7901489853223 | -122.44417907581301 | (37.7901489853223, -122.444179075813) | |
| 27039 | 27039 | 91160 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007065.15922 | 2112579.7073 | 37.7811403900434 | -122.41918728576401 | (37.7811403900434, -122.419187285764) | |
| 27973 | 27973 | 97268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 769192 | 5999910.90621 | 2116024.41622 | 37.7901931681384 | -122.44418496098 | (37.7901931681384, -122.44418496098) | ||
| 28213 | 28213 | 91295 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3065 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52052 | 6000114.74904 | 2115757.9849799997 | 37.7894732446403 | -122.443460536396 | (37.7894732446403, -122.443460536396) | |
| 28795 | 28795 | 33125 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 13 | 6x7 | Permit Number 37358 | 6001538.52427 | 2119069.35252 | 37.7986464896046 | -122.43877182467699 | (37.7986464896046, -122.438771824677) |
| 29761 | 29761 | 94343 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 735 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53631 | 6009320.52267 | 2110260.04995 | 37.774897914235794 | -122.41122091122101 | (37.7748979142358, -122.411220911221) | |
| 29948 | 29948 | 55354 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 601 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 10 | 3x3 | Permit Number 11287 | 5993641.36369 | 2113466.98214 | 37.782811483217 | -122.46569104074301 | (37.782811483217, -122.465691040743) | |
| 30311 | 30311 | 56524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 623 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5994686.99201 | 2111263.70978 | 37.776822144368 | -122.461913814497 | (37.776822144368, -122.461913814497) | ||||
| 32519 | 32519 | 66997 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 816 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1992 12:00:00 AM | 5 | Permit Number 30351 | 6012151.3036 | 2112714.2862 | 37.7817950322681 | -122.40160111437099 | (37.7817950322681, -122.401601114371) | ||
| 34666 | 34666 | 57073 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.758419515877705 | -122.390379311651 | (37.7584195158777, -122.390379311651) | ||
| 34705 | 34705 | 30348 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 420 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1956 12:00:00 AM | 13 | Permit Number 31 | 6012919.88824 | 2105064.35635 | 37.760832905929604 | -122.39840522041901 | (37.7608329059296, -122.398405220419) | ||
| 35199 | 35199 | 32994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.849280001 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | |
| 36571 | 36571 | 83024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1209 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52375 | 6013948.88284 | 2105690.7354200003 | 37.762610074220206 | -122.39489022832399 | (37.7626100742202, -122.394890228324) | |
| 36737 | 36737 | 53651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 829 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1969 12:00:00 AM | 1 | Permit Number 6587 | 6012068.4217 | 2112548.0645 | 37.7813340008977 | -122.401876160632 | (37.7813340008977, -122.401876160632) | ||
| 37105 | 37105 | 51255 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.5117200003 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | ||
| 38337 | 38337 | 51849 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.43267780892599 | (37.7594924661239, -122.432677808926) | |||
| 39087 | 39087 | 55752 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2224 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | 19 | Permit Number 11785 | 6002371.1638 | 2118147.1071 | 37.7961615782478 | -122.435824610533 | (37.7961615782478, -122.435824610533) | ||
| 39204 | 39204 | 32023 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 18 | Permit Number 35413 | 6001158.18036 | 2116931.31755 | 37.792754360865295 | -122.43993455095699 | (37.7927543608653, -122.439934550957) | ||
| 39927 | 39927 | 32998 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.784654089848296 | -122.398013908317 | (37.7846540898483, -122.398013908317) | |
| 40339 | 40339 | 48429 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 10 | Permit Number 45807 | 6001230.18864 | 2118334.23878 | 37.7966105144187 | -122.439786028808 | (37.7966105144187, -122.439786028808) | |
| 40344 | 40344 | 31076 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.3894700003 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | |
| 40396 | 40396 | 97985 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6015230.10587 | 2104016.74085 | 37.7580848025885 | -122.39034193764499 | (37.7580848025885, -122.390341937645) | ||||
| 41952 | 41952 | 51434 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.724636968819205 | -122.433701359735 | (37.7246369688192, -122.433701359735) |
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");