Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 16163 | 16163 | 26637 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X3 | |||||||
| 22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 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) | |||
| 11281 | 11281 | 1166 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.1618700002 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | ||
| 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) | |||
| 12432 | 12432 | 17625 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6004425.094930001 | 2089870.4961599999 | 37.7186371444562 | -122.426702945308 | (37.7186371444562, -122.426702945308) | |||
| 13153 | 13153 | 17626 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004454.014359999 | 2089904.4684 | 37.718732059816205 | -122.42660540034099 | (37.7187320598162, -122.426605400341) | |||
| 11929 | 11929 | 17621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004336.281690001 | 2089926.3148400001 | 37.7187853887157 | -122.42701391015899 | (37.7187853887157, -122.427013910159) | |||
| 13231 | 13231 | 17623 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6004371.84322 | 2089954.8563599999 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | |||
| 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) | |||
| 11164 | 11164 | 17617 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | |||
| 12487 | 12487 | 17616 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1030 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004194.38835 | 2090014.0443400003 | 37.719018250172 | -122.42751062553499 | (37.719018250172, -122.427510625535) | |||
| 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) | |||
| 12681 | 12681 | 17608 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1999 12:00:00 AM | 40 | 6x9 | 6004130.9636 | 2090056.2016 | 37.7191304172171 | -122.427732862395 | (37.7191304172171, -122.427732862395) | ||
| 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) | |||
| 18738 | 18738 | 17618 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6004182.578886599 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 49109 | 49109 | 17607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 948X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003925.750010201 | 2090181.5613292998 | 37.719463016991504 | -122.42845113758601 | (37.7194630169915, -122.428451137586) | |||
| 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) | |||
| 10537 | 10537 | 17602 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | |||
| 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) | |||
| 11611 | 11611 | 17597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 844 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003772.37846 | 2090279.5258799999 | 37.71972332585371 | -122.428988267402 | (37.7197233258537, -122.428988267402) | |||
| 144473 | 144473 | 17599 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 901X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6003845.6513541 | 2090290.9535450002 | 37.719758851010496 | -122.42873580329399 | (37.7197588510105, -122.428735803294) | |||
| 12598 | 12598 | 17596 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 822 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6003747.6295300005 | 2090297.4937 | 37.719771260609996 | -122.429075096066 | (37.71977126061, -122.429075096066) | |||
| 10968 | 10968 | 17595 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003715.34966 | 2090318.2223099999 | 37.719826349498895 | -122.42918815340401 | (37.7198263494989, -122.429188153404) | |||
| 12133 | 12133 | 17594 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 808 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6003660.5889 | 2090352.7029799998 | 37.719917925661 | -122.42937989966002 | (37.719917925661, -122.42937989966) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 116866 | 116866 | 17563 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 701X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4.5x4.5 | 6003386.5742173 | 2090579.4616613 | 37.7205250375642 | -122.430343243034 | (37.7205250375642, -122.430343243034) | |||
| 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) | |||
| 13029 | 13029 | 17562 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 645 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003332.52001 | 2090606.8773 | 37.72059725284729 | -122.43053204633001 | (37.7205972528473, -122.43053204633) | |||
| 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) | |||
| 12017 | 12017 | 17554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 620 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003227.93089 | 2090625.05216 | 37.7206412314956 | -122.43089487419901 | (37.7206412314956, -122.430894874199) | |||
| 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) | |||
| 11534 | 11534 | 17549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 600 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6003191.593230001 | 2090648.1169 | 37.7207025031963 | -122.431022127369 | (37.7207025031963, -122.431022127369) | |||
| 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) | |||
| 10722 | 10722 | 17551 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003191.74591 | 2090695.7695400002 | 37.720833355450104 | -122.43102499890699 | (37.7208333554501, -122.431024998907) | |||
| 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) | |||
| 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) | |||
| 12701 | 12701 | 17544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 537 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003083.60804 | 2090766.94886 | 37.7210226699524 | -122.431403876997 | (37.7210226699524, -122.431403876997) | |||
| 12120 | 12120 | 17542 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 525 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2011 12:00:00 AM | 3 | 3x3 | 6003053.24569 | 2090786.85001 | 37.7210755932558 | -122.43151025062099 | (37.7210755932558, -122.431510250621) | ||
| 12027 | 12027 | 17535 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003034.530590001 | 2090798.32089 | 37.721106028988295 | -122.431575761713 | (37.7211060289883, -122.431575761713) | |||
| 90119 | 90119 | 17543 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 531 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002997.1960546 | 2090824.1673225 | 37.7211748813523 | -122.43170666065201 | (37.7211748813523, -122.431706660652) | |||
| 12929 | 12929 | 17531 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 444 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002851.30461 | 2090860.81338 | 37.72126723246829 | -122.43221358070299 | (37.7212672324683, -122.432213580703) | |||
| 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) | |||
| 10894 | 10894 | 17530 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002769.64699 | 2090910.4417700002 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | |||
| 10940 | 10940 | 17528 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002717.3851 | 2090942.2754900001 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | |||
| 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) | ||
| 127055 | 127055 | 17532 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 445X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002799.2909021 | 2090948.5412154999 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | |||
| 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) | |||
| 10349 | 10349 | 17525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6002628.09189 | 2091001.6668200002 | 37.721641326157204 | -122.43299522107401 | (37.7216413261572, -122.432995221074) | |||
| 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) | |||
| 10866 | 10866 | 17524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | |||
| 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) | |||
| 105761 | 105761 | 17526 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 349X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002579.5148665 | 2091086.6599396 | 37.7218719428007 | -122.43316920852699 | (37.7218719428007, -122.433169208527) | |||
| 11558 | 11558 | 17522 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 307 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002546.66743 | 2091098.28956 | 37.7219020117492 | -122.433283584179 | (37.7219020117492, -122.433283584179) | |||
| 84936 | 84936 | 17517 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002447.6310917 | 2091110.4885814 | 37.721929888666104 | -122.43362679863199 | (37.7219298886661, -122.433626798632) | |||
| 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) | |||
| 128570 | 128570 | 17523 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002491.8541480005 | 2091141.7505443 | 37.7220182361725 | -122.43347616382499 | (37.7220182361725, -122.433476163825) | |||
| 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) | |||
| 13058 | 13058 | 17513 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002376.23219 | 2091204.63173 | 37.7221843332317 | -122.433880332025 | (37.7221843332317, -122.433880332025) | |||
| 114604 | 114604 | 17511 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 226 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/1999 12:00:00 AM | 12 | 3X3 | 6002275.9984778 | 2091218.3515509 | 37.722216316223104 | -122.434227795703 | (37.7222163162231, -122.434227795703) | ||
| 118239 | 118239 | 17483 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 220X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002262.892318901 | 2091226.5881509997 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | |||
| 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) | |||
| 11476 | 11476 | 17503 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 131 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002145.061290001 | 2091350.8283900002 | 37.7225726352947 | -122.434689881929 | (37.7225726352947, -122.434689881929) | |||
| 10351 | 10351 | 17502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002131.248869999 | 2091360.1957200002 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | |||
| 12439 | 12439 | 17499 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002048.76612 | 2091365.2856599998 | 37.722606864403296 | -122.435023785838 | (37.7226068644033, -122.435023785838) | ||
| 11883 | 11883 | 17495 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002027.05349 | 2091378.7208900002 | 37.722642521627996 | -122.43509980193001 | (37.722642521628, -122.43509980193) | |||
| 12309 | 12309 | 17496 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2003 12:00:00 AM | 3 | 2X2 | 6002048.59392 | 2091411.2062099997 | 37.7227329421421 | -122.43502766371401 | (37.7227329421421, -122.435027663714) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |
| 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");