trees
2,365 rows where qSpecies_id = 31 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169533 | 137038 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009796.46818 | 2116817.71138 | 37.7929303716781 | -122.410037553588 | (37.7929303716781, -122.410037553588) | 3 | 1 | 10 | 28857 | 21 | |||
174564 | 137037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009816.75031 | 2116820.89237 | 37.7929402426503 | -122.409967600744 | (37.7929402426503, -122.409967600744) | 3 | 1 | 10 | 28857 | 21 | |||
64445 | 17617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | 9 | 7 | 6 | 28861 | 5 | |||
10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
18715 | 17618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
83733 | 17620 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
157575 | 17619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
16269 | 198600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013090.52825 | 2107110.01033 | 37.7664593236741 | -122.397958554166 | (37.7664593236741, -122.397958554166) | 14 | 3 | 8 | 28856 | 20 | |||
143227 | 198599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013108.22745 | 2107111.70363 | 37.7664649588148 | -122.397897454223 | (37.7664649588148, -122.397897454223) | 14 | 3 | 8 | 28856 | 20 | |||
164728 | 198598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013134.44315 | 2107112.3448 | 37.766468179289 | -122.397806823228 | (37.766468179289, -122.397806823228) | 14 | 3 | 8 | 28856 | 20 | |||
169265 | 110630 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991857 | 2101850 | 37.7508112705894 | -122.471017566011 | (37.7508112705894, -122.471017566011) | 1 | 8 | 4 | 29491 | 12 | |||||
23450 | 91035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.406633247496 | (37.7775764693736, -122.406633247496) | 14 | 2 | 9 | 28853 | 34 | ||
24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
93167 | 91037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.406498774175 | (37.7776845332645, -122.406498774175) | 14 | 2 | 9 | 28853 | 34 | ||
104469 | 91034 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010653.2937 | 2111194.8106 | 37.7775392048064 | -122.406676440472 | (37.7775392048064, -122.406676440472) | 14 | 2 | 9 | 28853 | 34 | ||
105551 | 91033 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.7774769212136 | -122.406759301284 | (37.7774769212136, -122.406759301284) | 14 | 2 | 9 | 28853 | 34 | ||
110000 | 91036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | 14 | 2 | 9 | 28853 | 34 | ||
165047 | 91032 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010616.6864 | 2111159.8673 | 37.7774412104334 | -122.406800614681 | (37.7774412104334, -122.406800614681) | 14 | 2 | 9 | 28853 | 34 | ||
37815 | 36939 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.7864999276851 | -122.461372345087 | (37.7864999276851, -122.461372345087) | 11 | 6 | 1 | 54 | 11 | |
145910 | 17499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002048.76612 | 2091365.28566 | 37.7226068644033 | -122.435023785838 | (37.7226068644033, -122.435023785838) | 9 | 7 | 6 | 28861 | 5 | ||
134930 | 7405 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1065 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6010535.4473 | 2111084.5056 | 37.7772297388865 | -122.407076335552 | (37.7772297388865, -122.407076335552) | 14 | 2 | 9 | 28853 | 34 | ||
81203 | 4566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106X Virginia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2016 12:00:00 AM | 12 | 3X3 | 6006479.71302 | 2098542.22808 | 37.7425637694016 | -122.420216071529 | (37.7425637694016, -122.420216071529) | 2 | 7 | 7 | 28859 | 2 | ||
92343 | 4565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106X Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006455.63138 | 2098554.07674 | 37.7425949462063 | -122.420300179707 | (37.7425949462063, -122.420300179707) | 2 | 7 | 7 | 28859 | 2 | |||
110263 | 119755 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106x Octavia St Frontage West | 10 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
29404 | 23635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | 2 | 7 | 7 | 28859 | 2 | |||
49721 | 30802 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.83021 | 37.733802178321 | -122.43669510479 | (37.733802178321, -122.43669510479) | 9 | 7 | 5 | 63 | 40 |
179924 | 26628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | 10 | 3 | 8 | 58 | 1 | ||
177023 | 123692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 11 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995433.73143 | 2113533.85695 | 37.7830983254289 | -122.459495088037 | (37.7830983254289, -122.459495088037) | 11 | 6 | 2 | 54 | 11 | |||
70144 | 17490 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 11 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3X3 | 6001895.26392 | 2091509.73666 | 37.7229947770751 | -122.435564737019 | (37.7229947770751, -122.435564737019) | 9 | 7 | 6 | 28861 | 5 | |||
157149 | 140522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1100 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003844.9407 | 2111829.9916 | 37.7788999800677 | -122.430274131855 | (37.7788999800677, -122.430274131855) | 15 | 9 | 11 | 29490 | 41 | |||
17580 | 17622 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004279.3637264 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | 9 | 7 | 6 | 28861 | 5 | |||
101647 | 17621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6004336.28169 | 2089926.31484 | 37.7187853887157 | -122.427013910159 | (37.7187853887157, -122.427013910159) | 9 | 7 | 6 | 28861 | 5 | |||
186652 | 28264 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1100X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003899.2367 | 2111834.49982 | 37.7789154337837 | -122.430086622126 | (37.7789154337837, -122.430086622126) | 7 | 9 | 11 | 29490 | 41 | |||
71134 | 17624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | 9 | 7 | 6 | 28861 | 5 | |||
193000 | 17623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6004371.84322 | 2089954.85636 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | 9 | 7 | 6 | 28861 | 5 | |||
30944 | 180566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 111 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004117.41747 | 2094047.56106 | 37.7300890412712 | -122.428063967571 | (37.7300890412712, -122.428063967571) | 9 | 7 | 6 | 28861 | 5 | |||
118933 | 242666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1110 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003798.0893 | 2101733.84258 | 37.7511757357942 | -122.429715924165 | (37.7511757357942, -122.429715924165) | 2 | 4 | 5 | 28862 | 22 | |||
143813 | 242665 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1110 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003796.20784 | 2101754.26295 | 37.7512316988054 | -122.429723886759 | (37.7512316988054, -122.429723886759) | 2 | 4 | 5 | 28862 | 22 | |||
176835 | 140553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1111 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003847.0209 | 2111777.1269 | 37.7787549445338 | -122.430263163045 | (37.7787549445338, -122.430263163045) | 15 | 9 | 11 | 29492 | 41 | |||
27895 | 23744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1111X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003857.72301 | 2111778.219 | 37.7787585493448 | -122.430226218205 | (37.7787585493448, -122.430226218205) | 15 | 9 | 11 | 29492 | 41 | |||
29360 | 201851 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1119 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010210.791 | 2110772.6508 | 37.7763552850367 | -122.408177430978 | (37.7763552850367, -122.408177430978) | 8 | 2 | 9 | 28853 | 34 | |||
81593 | 95635 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 111X 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777379 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | |
68297 | 242376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 112 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005382.46829 | 2102954.4101 | 37.7546167200124 | -122.424323769035 | (37.7546167200124, -122.424323769035) | 2 | 4 | 5 | 28859 | 19 | |||
68907 | 98928 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 112 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005385 | 2103055 | 37.7548930594212 | -122.424322167644 | (37.7548930594212, -122.424322167644) | 2 | 4 | 5 | 28859 | 19 | ||||
19592 | 23636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 112 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6006546.53068 | 2098501.49483 | 37.7424556897773 | -122.419982145278 | (37.7424556897773, -122.419982145278) | 2 | 7 | 7 | 28859 | 2 | |||
1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
144740 | 17625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1132 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6004425.09493 | 2089870.49616 | 37.7186371444562 | -122.426702945308 | (37.7186371444562, -122.426702945308) | 9 | 7 | 6 | 28861 | 5 | |||
18245 | 66733 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1133 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/1991 12:00:00 AM | Permit Number 29980 | 6008997 | 2116859 | 37.7929988993441 | -122.41280668477 | (37.7929988993441, -122.41280668477) | 5 | 1 | 10 | 28857 | 21 | |||
129288 | 180561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.7129170389625 | -122.437192888562 | (37.7129170389625, -122.437192888562) | 9 | 7 | 6 | 28861 | 5 | |||
169869 | 180560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1134 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 6001363.50733 | 2087875.35573 | 37.7129853640648 | -122.437142819708 | (37.7129853640648, -122.437142819708) | 9 | 7 | 6 | 28861 | 5 | |||
88227 | 17627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2005 12:00:00 AM | 3 | 3X3 | 6004380.7126814 | 2089954.6929998 | 37.718865821274 | -122.426862349848 | (37.718865821274, -122.426862349848) | 9 | 7 | 6 | 28861 | 5 | ||
117636 | 51892 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48104 | 6004381.23162594 | 2089955.54800101 | 37.7188681982632 | -122.42686061692 | (37.7188681982632, -122.42686061692) | 9 | 7 | 6 | 28861 | 5 | |||
170816 | 17626 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004454.01436 | 2089904.4684 | 37.7187320598162 | -122.426605400341 | (37.7187320598162, -122.426605400341) | 9 | 7 | 6 | 28861 | 5 | |||
49086 | 239919 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1146 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781978 | 6009451.28129 | 2102498.7476 | 37.7535944875974 | -122.410220499083 | (37.7535944875974, -122.410220499083) | 2 | 4 | 7 | 28859 | 19 | |
163341 | 137046 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1149 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008987.23365 | 2116902.13898 | 37.7931168002562 | -122.412843528313 | (37.7931168002562, -122.412843528313) | 5 | 1 | 10 | 28857 | 21 | |||
38103 | 242736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6000751.24207 | 2105647.23063 | 37.761747947223 | -122.440532872599 | (37.761747947223, -122.440532872599) | 15 | 5 | 5 | 28862 | 3 | |||
41761 | 242738 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000793.83368 | 2105649.34692 | 37.7617561832258 | -122.440385717444 | (37.7617561832258, -122.440385717444) | 15 | 5 | 5 | 28862 | 3 | |||
51582 | 242735 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000736.15625 | 2105646.04373 | 37.7617438292481 | -122.440584963137 | (37.7617438292481, -122.440584963137) | 15 | 5 | 5 | 28862 | 3 | |||
133252 | 242737 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000767.45695 | 2105648.39413 | 37.7617520652142 | -122.440476875422 | (37.7617520652142, -122.440476875422) | 15 | 5 | 5 | 28862 | 3 | |||
2469 | 260495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
8039 | 260496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
27935 | 253392 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
70032 | 253393 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
183902 | 253394 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
51995 | 242637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1155 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009490.58468 | 2102465.6938 | 37.7535059322676 | -122.410082245404 | (37.7535059322676, -122.410082245404) | 2 | 4 | 7 | 28859 | 19 | |||
18804 | 85789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | 8 | 2 | 9 | 28853 | 34 | ||
64696 | 242448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997336.0067 | 2106240.14847 | 37.7631808847241 | -122.452387528971 | (37.7631808847241, -122.452387528971) | 15 | 5 | 11 | 29492 | 12 | |||
118750 | 85788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1161 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009943.5141 | 2110517.0093 | 37.775638383908 | -122.409083977926 | (37.775638383908, -122.409083977926) | 8 | 2 | 9 | 28853 | 34 | ||
172075 | 83229 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | 13 | 9 | 1 | 28858 | 17 | |
116487 | 56779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 118 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1974 12:00:00 AM | 10 | 3x3 | Permit Number 14000 | 6004445.70809 | 2092827.36067 | 37.7267572104766 | -122.426842159439 | (37.7267572104766, -122.426842159439) | 9 | 7 | 6 | 28861 | 5 | |
172458 | 23638 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 VIRGINIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 12 | 4x4 | Permit Number 776560 | 6006594 | 2098480 | 37.7423993441016 | -122.419816485332 | (37.7423993441016, -122.419816485332) | 2 | 7 | 7 | 28859 | 2 | |
12615 | 87685 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 Virginia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | 2 | 7 | 7 | 28859 | 2 | |||
165082 | 85760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1196 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009690.0521 | 2110363.0901 | 37.7752015556324 | -122.409949900924 | (37.7752015556324, -122.409949900924) | 8 | 2 | 9 | 28853 | 34 | ||
141982 | 64959 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 12 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1989 12:00:00 AM | 11 | Permit Number 25993 | 6001806.8392 | 2121193.66551 | 37.8044945533421 | -122.437995616222 | (37.8044945533421, -122.437995616222) | 13 | 9 | 1 | 57 | 17 | ||
24576 | 248409 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 120 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998272.8596 | 2108056.6857 | 37.7682222644528 | -122.449278164682 | (37.7682222644528, -122.449278164682) | 15 | 5 | 11 | 29492 | 9 | |||
87095 | 88329 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 120 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940 | 2092960 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | 9 | 7 | 6 | 28861 | 5 | |||
4643 | 76181 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) | 8 | 2 | 9 | 28853 | 34 | |||
3023 | 137045 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.7925550234358 | -122.412997178389 | (37.7925550234358, -122.412997178389) | 5 | 1 | 10 | 28857 | 21 | |||
77089 | 56515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17376 | 6008990.48315 | 2116704.87455 | 37.7925753427324 | -122.412818332001 | (37.7925753427324, -122.412818332001) | 5 | 1 | 10 | 28857 | 21 | ||
81493 | 137044 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008949.11114 | 2116700.62228 | 37.7925613447696 | -122.412961180311 | (37.7925613447696, -122.412961180311) | 5 | 1 | 10 | 28857 | 21 | |||
87166 | 16411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
126690 | 16415 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
87092 | 242400 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 5 | 6004412.57648 | 2096019.13863 | 37.7355192458083 | -122.427183945908 | (37.7355192458083, -122.427183945908) | 2 | 7 | 5 | 28861 | 2 | ||||
184015 | 242401 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 3 | 6004422.12829 | 2096026.22682 | 37.7355392485419 | -122.427151426394 | (37.7355392485419, -122.427151426394) | 2 | 7 | 5 | 28861 | 2 | ||||
34723 | 242403 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008707.95248 | 2101269.88955 | 37.7501786250428 | -122.412704235035 | (37.7501786250428, -122.412704235035) | 2 | 4 | 7 | 28859 | 19 | |||
55359 | 44113 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
86168 | 44116 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
114039 | 44114 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
156020 | 44112 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
80710 | 81876 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1209 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52375 | 6013966.08986 | 2105691.70822 | 37.762613702073 | -122.394830783137 | (37.762613702073, -122.394830783137) | 10 | 3 | 8 | 28856 | 29 | |
105010 | 83024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1209 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52375 | 6013948.88284 | 2105690.73542 | 37.7626100742202 | -122.394890228324 | (37.7626100742202, -122.394890228324) | 10 | 3 | 8 | 28856 | 29 | |
4995 | 242611 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 121 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6006528.89277 | 2098549.54535 | 37.7425866319823 | -122.420046541223 | (37.7425866319823, -122.420046541223) | 2 | 7 | 7 | 28859 | 2 | |||
47938 | 85786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | 8 | 2 | 9 | 28853 | 34 | ||
49834 | 85787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6009621.8032 | 2110211.384 | 37.7747811809083 | -122.410175277249 | (37.7747811809083, -122.410175277249) | 8 | 2 | 9 | 28853 | 34 | ||
54691 | 198499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016506.22051 | 2102490.10595 | 37.7539636880787 | -122.38582213748 | (37.7539636880787, -122.38582213748) | 10 | 3 | 8 | 28856 | 29 | |||
95343 | 198500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6016504.90448 | 2102523.10402 | 37.754054221042 | -122.385828988529 | (37.754054221042, -122.385828988529) | 10 | 3 | 8 | 28856 | 29 | |||
163757 | 198498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6016508.17513 | 2102448.92255 | 37.753850715249 | -122.385812507548 | (37.753850715249, -122.385812507548) | 10 | 3 | 8 | 28856 | 29 | |||
25246 | 242379 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1217 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011152.0776 | 2102554.59258 | 37.7538430143636 | -122.40434267049 | (37.7538430143636, -122.40434267049) | 10 | 4 | 8 | 28859 | 19 | |||
58501 | 242380 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1217 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011151.17373 | 2102568.66425 | 37.7538816015592 | -122.404346786677 | (37.7538816015592, -122.404346786677) | 10 | 4 | 8 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );