Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo
| 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 | |||||||||
| 148678 | 148678 | 180562 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4101 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5991620.890430001 | 2086817.0358099998 | 37.70952085356139 | -122.470739173794 | (37.7095208535614, -122.470739173794) | |||
| 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) | |||
| 150445 | 150445 | 180561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.712917038962495 | -122.437192888562 | (37.7129170389625, -122.437192888562) | |||
| 165192 | 165192 | 180560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 6001363.50733 | 2087875.35573 | 37.7129853640648 | -122.437142819708 | (37.7129853640648, -122.437142819708) | |||
| 44061 | 44061 | 180541 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 762 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002189.480330001 | 2089236.03979 | 37.716768418898795 | -122.43438521053301 | (37.7167684188988, -122.434385210533) | |||
| 137877 | 137877 | 180559 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 192 Dublin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6004156.4754099995 | 2089333.3612 | 37.717147098249605 | -122.427593206665 | (37.7171470982496, -122.427593206665) | |||
| 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) | |||
| 54259 | 54259 | 180512 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004254.69534 | 2090025.2040000001 | 37.71905230300529 | -122.427302962162 | (37.7190523030053, -122.427302962162) | |||
| 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) | |||
| 65179 | 65179 | 180513 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1027 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004235.638830001 | 2090036.93621 | 37.719083439333204 | -122.427369668478 | (37.7190834393332, -122.427369668478) | |||
| 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) | |||
| 149925 | 149925 | 180515 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004177.13289 | 2090077.86698 | 37.7191925171931 | -122.427574815527 | (37.7191925171931, -122.427574815527) | |||
| 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) | |||
| 177135 | 177135 | 180539 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2063 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000471.84431 | 2090162.7563 | 37.7192153258175 | -122.440388640236 | (37.7192153258175, -122.440388640236) | |||
| 173144 | 173144 | 180516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004155.91588 | 2090090.6053799998 | 37.7192262939354 | -122.427649061763 | (37.7192262939354, -122.427649061763) | |||
| 30655 | 30655 | 180517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004131.62894 | 2090104.3716099998 | 37.719262719168896 | -122.42773399285299 | (37.7192627191689, -122.427733992853) | |||
| 38828 | 38828 | 180542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 990 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004004.09033 | 2090139.32192 | 37.7193514696869 | -122.42817733523 | (37.7193514696869, -122.42817733523) | |||
| 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) | |||
| 160059 | 160059 | 180518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003927.65212 | 2090238.59404 | 37.7196197239493 | -122.42844862563 | (37.7196197239493, -122.42844862563) | |||
| 174369 | 174369 | 180519 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003897.75198 | 2090254.30542 | 37.719661171900796 | -122.42855309895701 | (37.7196611719008, -122.428553098957) | |||
| 65813 | 65813 | 180520 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6003878.6160699995 | 2090266.0202 | 37.71969225516521 | -122.42862007955799 | (37.7196922551652, -122.428620079558) | |||
| 78526 | 78526 | 97030 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 278 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997252.0 | 2090493.0 | 37.7199382378616 | -122.451542171872 | (37.7199382378616, -122.451542171872) | |||
| 147164 | 147164 | 215518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 278 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997249.4841 | 2090499.4445099998 | 37.719955788905295 | -122.451551333026 | (37.7199557889053, -122.451551333026) | |||
| 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) | ||
| 161969 | 161969 | 180521 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 703 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003571.912830001 | 2090460.5542799998 | 37.7202090407058 | -122.429694110218 | (37.7202090407058, -122.429694110218) | |||
| 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) | |||
| 74127 | 74127 | 180522 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 703 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6003548.0155 | 2090475.44462 | 37.7202485730803 | -122.42977777681699 | (37.7202485730803, -122.429777776817) | |||
| 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) | |||
| 147593 | 147593 | 180523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 703 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003530.180369999 | 2090485.1231200001 | 37.720274138132 | -122.42984011692499 | (37.720274138132, -122.429840116925) | |||
| 187214 | 187214 | 180524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 703 Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6003506.1468400005 | 2090499.6144299998 | 37.72031256704079 | -122.429924226024 | (37.7203125670408, -122.429924226024) | |||
| 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) | |||
| 153735 | 153735 | 180525 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003487.94744 | 2090511.7245099999 | 37.72034478796721 | -122.429987998761 | (37.7203447879672, -122.429987998761) | |||
| 36663 | 36663 | 180526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003462.66428 | 2090526.46403 | 37.7203838275255 | -122.43007644527701 | (37.7203838275255, -122.430076445277) | |||
| 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) | |||
| 175423 | 175423 | 180545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 590 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003050.747769999 | 2090737.10045 | 37.720938850417 | -122.43151533538601 | (37.720938850417, -122.431515335386) | |||
| 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) | |||
| 5186 | 5186 | 180527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003103.45709 | 2090752.9991099997 | 37.720985491961 | -122.43133426946301 | (37.720985491961, -122.431334269463) | |||
| 72890 | 72890 | 215517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 164 Howth St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997515.643519999 | 2090995.9765400002 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | |||
| 177606 | 177606 | 180528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 403 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002884.7745199995 | 2090891.4425599999 | 37.7213532310447 | -122.43210007098301 | (37.7213532310447, -122.432100070983) | |||
| 182674 | 182674 | 180529 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 403 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6002841.07955 | 2090920.68428 | 37.7214310448921 | -122.432253199447 | (37.7214310448921, -122.432253199447) | |||
| 40052 | 40052 | 180530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 403 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6002817.9895 | 2090936.4052799998 | 37.721472902024004 | -122.432334137535 | (37.721472902024, -122.432334137535) | |||
| 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) | ||
| 76760 | 76760 | 180531 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002788.2945 | 2090951.75373 | 37.721513361625 | -122.43243788061199 | (37.721513361625, -122.432437880612) | |||
| 165946 | 165946 | 180532 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002770.13876 | 2090966.12434 | 37.721551790572704 | -122.432501665928 | (37.7215517905727, -122.432501665928) | |||
| 180867 | 180867 | 180533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002751.65611 | 2090978.09371 | 37.7215836076762 | -122.43256640991699 | (37.7215836076762, -122.432566409917) | |||
| 74806 | 74806 | 180534 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002734.62326 | 2090983.4567 | 37.7215973673155 | -122.43262567073299 | (37.7215973673155, -122.432625670733) | |||
| 177758 | 177758 | 180558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 391 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002652.4584800005 | 2091031.88145 | 37.7217256708875 | -122.432913149844 | (37.7217256708875, -122.432913149844) | |||
| 47667 | 47667 | 180557 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 391 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002620.620709999 | 2091051.6763400002 | 37.7217782173661 | -122.43302461809799 | (37.7217782173661, -122.433024618098) | |||
| 186182 | 186182 | 180540 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998917.8755 | 2091146.4939599999 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | |||
| 138691 | 138691 | 180556 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002572.40601 | 2091082.8372 | 37.721861043143605 | -122.433193508995 | (37.7218610431436, -122.433193508995) | |||
| 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) | |||
| 24976 | 24976 | 180546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 228 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002372.12567 | 2091162.28093 | 37.722067814370206 | -122.433891501616 | (37.7220678143702, -122.433891501616) | |||
| 75085 | 75085 | 180547 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002320.38624 | 2091195.17926 | 37.7221552095645 | -122.434072702398 | (37.7221552095645, -122.434072702398) | |||
| 176925 | 176925 | 180548 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002299.71139 | 2091209.35662 | 37.722192964028295 | -122.434145183247 | (37.7221929640283, -122.434145183247) | |||
| 64148 | 64148 | 180549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002285.837859999 | 2091218.55546 | 37.722217434571796 | -122.43419379793 | (37.7222174345718, -122.43419379793) | |||
| 178955 | 178955 | 180555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.72224222258421 | -122.43398729649799 | (37.7222422225842, -122.433987296498) | |||
| 164166 | 164166 | 180550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002268.14618 | 2091228.5970299998 | 37.7222440023296 | -122.43425567127899 | (37.7222440023296, -122.434255671279) | |||
| 169145 | 169145 | 180554 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 201 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002324.53042 | 2091240.40597 | 37.722279627184 | -122.434061608377 | (37.722279627184, -122.434061608377) | |||
| 66157 | 66157 | 180553 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 201 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002310.385869999 | 2091249.4561400001 | 37.722303674165396 | -122.43411114931699 | (37.7223036741654, -122.434111149317) | |||
| 53940 | 53940 | 180551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001942.54043 | 2091434.1953900002 | 37.7227900428055 | -122.435395910889 | (37.7227900428055, -122.435395910889) | |||
| 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) | |||
| 28496 | 28496 | 180552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001906.70426 | 2091457.0894099998 | 37.722850869347205 | -122.435521425698 | (37.7228508693472, -122.435521425698) | |||
| 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) | |||
| 152982 | 152982 | 198514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1601 Bay Shore Blvd | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012038.03347 | 2091375.16372 | 37.723196132582395 | -122.400493582929 | (37.7231961325824, -122.400493582929) | |||
| 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) | ||
| 73807 | 73807 | 180563 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 88 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001669.16687 | 2092383.58847 | 37.725381332271496 | -122.436408819134 | (37.7253813322715, -122.436408819134) | |||
| 168976 | 168976 | 180538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010266.12531 | 2092269.81 | 37.7255536693496 | -122.40668177206899 | (37.7255536693496, -122.406681772069) | |||
| 34482 | 34482 | 180537 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010311.60374 | 2092285.69304 | 37.7255998252705 | -122.40652567494101 | (37.7255998252705, -122.406525674941) | |||
| 47795 | 47795 | 180536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010343.05054 | 2092296.39853 | 37.725630979562794 | -122.40641771941401 | (37.7256309795628, -122.406417719414) | |||
| 28346 | 28346 | 180535 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010393.23752 | 2092315.54751 | 37.7256863661069 | -122.406245574796 | (37.7256863661069, -122.406245574796) | |||
| 61428 | 61428 | 180565 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004047.94044 | 2092448.5749599999 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | |||
| 47809 | 47809 | 180564 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 522 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003993.12546 | 2092482.75388 | 37.7257853967595 | -122.428382173808 | (37.7257853967595, -122.428382173808) | |||
| 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) | |||
| 62617 | 62617 | 180568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 136 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007069.5119199995 | 2093001.96725 | 37.7273846467688 | -122.417784094277 | (37.7273846467688, -122.417784094277) |
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");