Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6092 | 6092 | 46303 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 7478 | 7478 | 46291 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10371 | 10371 | 46304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11759 | 11759 | 46302 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 97919 | 97919 | 11876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 107376 | 107376 | 11877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 139746 | 139746 | 11878 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 98502 | 98502 | 40800 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.711322874409596 | -122.458004690935 | (37.7113228744096, -122.458004690935) | |||
| 104545 | 104545 | 51892 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48104 | 6004381.23162594 | 2089955.54800101 | 37.7188681982632 | -122.42686061692 | (37.7188681982632, -122.42686061692) | |||
| 124040 | 124040 | 17622 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004279.363726401 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | |||
| 10375 | 10375 | 17615 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004156.70512 | 2090037.9094200002 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | |||
| 11239 | 11239 | 17609 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004106.27078 | 2090068.65464 | 37.7191632136975 | -122.42781910286999 | (37.7191632136975, -122.42781910287) | |||
| 12237 | 12237 | 17610 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004083.7901099995 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | |||
| 84787 | 84787 | 17611 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 118411 | 118411 | 17613 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 142590 | 142590 | 17612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 13109 | 13109 | 17606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 945X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004029.89293 | 2090169.1541 | 37.7194348422149 | -122.428090270065 | (37.7194348422149, -122.428090270065) | |||
| 10792 | 10792 | 17605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 937 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003999.6997 | 2090190.6100400002 | 37.7194920472054 | -122.428196165219 | (37.7194920472054, -122.428196165219) | |||
| 12044 | 12044 | 17598 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003858.866640001 | 2090228.3157 | 37.719587609170006 | -122.42868565992399 | (37.71958760917, -122.428685659924) | |||
| 175570 | 175570 | 180543 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 790 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 15 | Width 3ft | 6003544.6260400005 | 2090426.4873900001 | 37.720113955375794 | -122.42978600294799 | (37.7201139553758, -122.429786002948) | ||
| 78604 | 78604 | 17574 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 752X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 16 | 3x3 | 6003494.26805 | 2090459.52433 | 37.7202018157394 | -122.429962428847 | (37.7202018157394, -122.429962428847) | ||
| 12028 | 12028 | 17573 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6003469.3677199995 | 2090473.15538 | 37.720237833385404 | -122.430049472832 | (37.7202378333854, -122.430049472832) | |||
| 12659 | 12659 | 17567 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6003448.03192 | 2090486.73855 | 37.7202739213865 | -122.430124192087 | (37.7202739213865, -122.430124192087) | |||
| 11718 | 11718 | 17568 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6003419.6169300005 | 2090505.6702299998 | 37.720324294201 | -122.430223763218 | (37.720324294201, -122.430223763218) | |||
| 10288 | 10288 | 17565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.720429991522295 | -122.43015957951599 | (37.7204299915223, -122.430159579516) | |||
| 12788 | 12788 | 17558 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 632 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003270.54295 | 2090597.85658 | 37.7205689727677 | -122.430745637999 | (37.7205689727677, -122.430745637999) | |||
| 11202 | 11202 | 17556 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003246.79786 | 2090613.7194400001 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | |||
| 11027 | 11027 | 17557 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 631 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003296.79143 | 2090629.3686 | 37.7206569849073 | -122.430657152829 | (37.7206569849073, -122.430657152829) | |||
| 12168 | 12168 | 17555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 625 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003276.00472 | 2090644.70105 | 37.7206979067656 | -122.430730099534 | (37.7206979067656, -122.430730099534) | |||
| 12833 | 12833 | 17553 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.720753626054204 | -122.430852753549 | (37.7207536260542, -122.430852753549) | |||
| 11491 | 11491 | 17552 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 611 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003214.50174 | 2090682.11363 | 37.72079714875721 | -122.430945364856 | (37.7207971487572, -122.430945364856) | |||
| 5180 | 5180 | 17545 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6003118.2023599995 | 2090743.3942599997 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | |||
| 105003 | 105003 | 13321 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 435X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1997 12:00:00 AM | 5 | 3X3 | 6002797.38385 | 2090943.99635 | 37.7214925769985 | -122.432405907456 | (37.7214925769985, -122.432405907456) | ||
| 12801 | 12801 | 17521 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 301X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002512.93657 | 2091121.04264 | 37.7219625730029 | -122.433401808174 | (37.7219625730029, -122.433401808174) | |||
| 87102 | 87102 | 17494 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001936.09269 | 2091434.7408900002 | 37.722791174441106 | -122.43541823832199 | (37.7227911744411, -122.435418238322) | |||
| 141057 | 141057 | 17493 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6001898.43212 | 2091454.2052 | 37.722842480127 | -122.435549814469 | (37.722842480127, -122.435549814469) | |||
| 10763 | 10763 | 17492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 43 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6001974.03166 | 2091459.77916 | 37.722862078497705 | -122.435288881679 | (37.7228620784977, -122.435288881679) | |||
| 12453 | 12453 | 17491 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001944.766 | 2091477.8994200001 | 37.722910170637896 | -122.435391342346 | (37.7229101706379, -122.435391342346) | |||
| 61149 | 61149 | 96876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 12233 | 12233 | 17490 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 11 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6001895.26392 | 2091509.73666 | 37.7229947770751 | -122.435564737019 | (37.7229947770751, -122.435564737019) | |||
| 135957 | 135957 | 51918 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.924319999 | 2091688.24542 | 37.72335998726889 | -122.443166369055 | (37.7233599872689, -122.443166369055) | |
| 81200 | 81200 | 88338 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541.0 | 2091742.0 | 37.723669175153205 | -122.43334915015801 | (37.7236691751532, -122.433349150158) | |||
| 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) | ||
| 127445 | 127445 | 66565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702438996 | -122.426754065425 | (37.725220702439, -122.426754065425) | ||
| 11102 | 11102 | 56779 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1974 12:00:00 AM | 10 | 3x3 | Permit Number 14000 | 6004445.70809 | 2092827.36067 | 37.726757210476606 | -122.42684215943899 | (37.7267572104766, -122.426842159439) | |
| 94108 | 94108 | 88329 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 120 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940.0 | 2092960.0 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | |||
| 109273 | 109273 | 58204 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1978 12:00:00 AM | 18 | 3x3 | Permit Number 17195 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | |
| 144247 | 144247 | 113083 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | ||||
| 132509 | 132509 | 46780 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.43357175935301 | (37.7283552769641, -122.433571759353) | |
| 103920 | 103920 | 117152 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.72855094559029 | -122.389513905896 | (37.7285509455903, -122.389513905896) | |||
| 59286 | 59286 | 46632 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.728578532365496 | -122.389527911332 | (37.7285785323655, -122.389527911332) |
| 103372 | 103372 | 81863 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.729301806319704 | -122.459920577502 | (37.7293018063197, -122.459920577502) | ||
| 77382 | 77382 | 22315 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
| 92068 | 92068 | 22316 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
| 2748 | 2748 | 30802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.8302099998 | 37.733802178321 | -122.43669510478998 | (37.733802178321, -122.43669510479) |
| 88869 | 88869 | 32534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 118928 | 118928 | 32532 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 128748 | 128748 | 32533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 97468 | 97468 | 52332 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.45929215094101 | (37.7353714395789, -122.459292150941) | ||||
| 121291 | 121291 | 47711 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.73697948454021 | -122.435360375218 | (37.7369794845402, -122.435360375218) | ||
| 174601 | 174601 | 31036 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.737554295604895 | -122.41810281760901 | (37.7375542956049, -122.418102817609) | ||
| 89302 | 89302 | 31777 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.74110093693479 | -122.47907928432699 | (37.7411009369348, -122.479079284327) | ||
| 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) | |||
| 162741 | 162741 | 33151 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.741869787152204 | -122.487350256926 | (37.7418697871522, -122.487350256926) | |
| 95763 | 95763 | 33602 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | ||
| 90349 | 90349 | 23649 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 213 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 12 | 3X3 | 6006799.15969 | 2098412.34568 | 37.7422251360414 | -122.41910230566002 | (37.7422251360414, -122.41910230566) | ||
| 110089 | 110089 | 23648 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 209 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 3 | 3X3 | 6006784.42246 | 2098421.4785 | 37.7422493827951 | -122.419153910226 | (37.7422493827951, -122.419153910226) | ||
| 143378 | 143378 | 23638 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 VIRGINIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 12 | 4x4 | Permit Number 776560 | 6006594.0 | 2098480.0 | 37.7423993441016 | -122.41981648533199 | (37.7423993441016, -122.419816485332) | |
| 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) | |||
| 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) | ||
| 139417 | 139417 | 23644 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 197 Virginia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 8 | 3X3 | 6006643.75963 | 2098486.4882900002 | 37.7424199625796 | -122.41964489142 | (37.7424199625796, -122.41964489142) | ||
| 136282 | 136282 | 242614 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Virginia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 8 | Width 3ft | 6006648.68245 | 2098490.72536 | 37.7424318739254 | -122.419628170307 | (37.7424318739254, -122.419628170307) | ||
| 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) | ||
| 17373 | 17373 | 4565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106X Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006455.63138 | 2098554.07674 | 37.742594946206296 | -122.420300179707 | (37.7425949462063, -122.420300179707) | |||
| 84660 | 84660 | 64129 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 662 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52075 | 6002246.83688253 | 2098888.05007266 | 37.7432738978208 | -122.43487682109199 | (37.7432738978208, -122.434876821092) | ||
| 110663 | 110663 | 43563 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 511 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | ||
| 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) | ||
| 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) | ||
| 17647 | 17647 | 7645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3299 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2008 12:00:00 AM | 3 | 4x4 | 6008510.32989 | 2099428.74367 | 37.74511215491329 | -122.41325744669201 | (37.7451121549133, -122.413257446692) | ||
| 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) | |||
| 113790 | 113790 | 44268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 125148 | 125148 | 44267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 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) | |||
| 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) | ||
| 92898 | 92898 | 47527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 1 | 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) | ||
| 108477 | 108477 | 45798 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.44386708589701 | (37.7469614974882, -122.443867085897) | |||
| 139998 | 139998 | 38953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.41364913267701 | (37.747044527767, -122.413649132677) | |||
| 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) | |||
| 17624 | 17624 | 4231 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3992 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2003 12:00:00 AM | 3 | 3X3 | 6003972.48487 | 2100441.01893 | 37.7476358171535 | -122.429020679863 | (37.7476358171535, -122.429020679863) | ||
| 17684 | 17684 | 7603 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3143 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 20 | 5x5 | 6008454.26481 | 2100356.41026 | 37.7476561733017 | -122.413516907381 | (37.7476561733017, -122.413516907381) | ||
| 79538 | 79538 | 52664 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1328C. CHAVEZ Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50454 | 6003228.63897895 | 2100503.21297012 | 37.747764453898604 | -122.431597294154 | (37.7477644538986, -122.431597294154) | ||
| 17364 | 17364 | 7595 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3079 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008433.91036 | 2100662.40633 | 37.7484952272826 | -122.413608931409 | (37.7484952272826, -122.413608931409) | |||
| 92031 | 92031 | 7591 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3025 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | |||
| 119628 | 119628 | 7596 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3085 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | |||
| 105072 | 105072 | 7584 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
| 109710 | 109710 | 7588 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3000X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
| 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) | ||
| 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) | |||
| 17777 | 17777 | 7574 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2970 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008349.21001 | 2101154.19809 | 37.749840820806 | -122.413936609291 | (37.749840820806, -122.413936609291) |
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");