trees
1,196 rows where SiteOrder = 1 and 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
146546 | 136974 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001080.18174 | 2119739.07113 | 37.8004592737451 | -122.440405888327 | (37.8004592737451, -122.440405888327) | 13 | 9 | 1 | 57 | 17 | |||
40679 | 123696 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995493.19231 | 2113537.8911 | 37.7831128208781 | -122.459289671188 | (37.7831128208781, -122.459289671188) | 11 | 6 | 2 | 54 | 11 | |||
134543 | 242778 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 McCoppin St | 1 | : | Tree | Private 2 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | 8 | 2 | 9 | 28853 | 19 | |||
121544 | 215482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994118.54253 | 2097814.90929 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) | 1 | 8 | 4 | 59 | 40 | |||
82231 | 141754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003957.9028 | 2113249.5012 | 37.7828039980646 | -122.429984636672 | (37.7828039980646, -122.429984636672) | 7 | 9 | 11 | 29490 | 41 | |||
146011 | 242590 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000566.18522 | 2102752.01252 | 37.7537878463488 | -122.440965200093 | (37.7537878463488, -122.440965200093) | 2 | 4 | 5 | 28862 | 22 | |||
97426 | 17495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002027.05349 | 2091378.72089 | 37.722642521628 | -122.43509980193 | (37.722642521628, -122.43509980193) | 9 | 7 | 6 | 28861 | 5 | |||
184345 | 198593 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013352.21579 | 2107122.2943 | 37.7665076235661 | -122.397054279536 | (37.7665076235661, -122.397054279536) | 14 | 3 | 8 | 28856 | 20 | |||
154623 | 17608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/26/1999 12:00:00 AM | 40 | 6x9 | 6004130.9636 | 2090056.2016 | 37.7191304172171 | -122.427732862395 | (37.7191304172171, -122.427732862395) | 9 | 7 | 6 | 28861 | 5 | ||
64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
43528 | 17611 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
124514 | 244421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005693.2117 | 2109673.0661 | 37.7730821016693 | -122.423726816669 | (37.7730821016693, -122.423726816669) | 7 | 9 | 11 | 28852 | 10 | |||
165131 | 16605 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 101 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2014 12:00:00 AM | 18 | 3X3 | Permit Number 773154 | 6002878.7558281 | 2107677.2386142 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | 15 | 5 | 5 | 28862 | 3 | |
126316 | 17496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2003 12:00:00 AM | 3 | 2X2 | 6002048.59392 | 2091411.20621 | 37.7227329421421 | -122.435027663714 | (37.7227329421421, -122.435027663714) | 9 | 7 | 6 | 28861 | 5 | ||
18136 | 112514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1014 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992342.97239 | 2113476.2606 | 37.7827619817135 | -122.47018356399 | (37.7827619817135, -122.47018356399) | 11 | 6 | 2 | 54 | 11 | |||
175502 | 17615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6004156.70512 | 2090037.90942 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | 9 | 7 | 6 | 28861 | 5 | |||
99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
95773 | 244344 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005605.8565 | 2109917.6606 | 37.7737487675431 | -122.424046387097 | (37.7737487675431, -122.424046387097) | 7 | 9 | 11 | 28852 | 10 | |||
166196 | 119736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
60428 | 180515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004177.13289 | 2090077.86698 | 37.7191925171931 | -122.427574815527 | (37.7191925171931, -122.427574815527) | 9 | 7 | 6 | 28861 | 5 | |||
17980 | 180512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004254.69534 | 2090025.204 | 37.7190523030053 | -122.427302962162 | (37.7190523030053, -122.427302962162) | 9 | 7 | 6 | 28861 | 5 | |||
8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
148137 | 17616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1030 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004194.38835 | 2090014.04434 | 37.719018250172 | -122.427510625535 | (37.719018250172, -122.427510625535) | 9 | 7 | 6 | 28861 | 5 | |||
77852 | 7013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.7743154774203 | -122.435062751747 | (37.7743154774203, -122.435062751747) | 15 | 5 | 11 | 29492 | 10 | ||
185186 | 46875 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) | 3 | 1 | 10 | 308 | 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 | |||
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 | |||
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 | |||||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||||
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 | |
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 | |
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
37320 | 85785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 5 | 3x3 | 6009541.3755 | 2110133.2543 | 37.7745621465765 | -122.410447976342 | (37.7745621465765, -122.410447976342) | 8 | 2 | 9 | 28853 | 34 | ||
121496 | 53398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1972 12:00:00 AM | 9 | Permit Number 9833 | 6008515.21769 | 2116802.84208 | 37.7928176497632 | -122.414469707612 | (37.7928176497632, -122.414469707612) | 5 | 1 | 10 | 28858 | 21 | ||
177374 | 117609 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1227 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x3 | 6009518.3962 | 2110117.1687 | 37.7745166910375 | -122.410526330451 | (37.7745166910375, -122.410526330451) | 8 | 2 | 9 | 28853 | 34 | |||
87031 | 85761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009463.2457 | 2110145.8929 | 37.7745924689532 | -122.410719136445 | (37.7745924689532, -122.410719136445) | 8 | 2 | 9 | 28853 | 34 | ||
4577 | 137042 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008994.19297 | 2117174.51361 | 37.7938650649634 | -122.412838714232 | (37.7938650649634, -122.412838714232) | 3 | 1 | 10 | 28857 | 21 | |||
66162 | 14595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1237 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5999420.8847 | 2108569.3753 | 37.7696955800463 | -122.445344141815 | (37.7696955800463, -122.445344141815) | 15 | 5 | 11 | 29492 | 9 | ||
189690 | 198667 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 124 Russ St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010302.39718 | 2111555.70743 | 37.7785105043828 | -122.407915770511 | (37.7785105043828, -122.407915770511) | 14 | 2 | 9 | 28853 | 34 | |||
41142 | 49606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | 8 | 2 | 9 | 28853 | 34 | |
20821 | 85762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | 8 | 2 | 9 | 28853 | 34 | ||
122624 | 14598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1247 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 12:00:00 AM | 45 | 3X3 | 5999428.6068 | 2108510.475 | 37.7695342955042 | -122.445313195872 | (37.7695342955042, -122.445313195872) | 15 | 5 | 11 | 29492 | 9 | ||
73437 | 51550 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1247 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2005 12:00:00 AM | Permit Number 47849 | 5999742.39026173 | 2108428.18336747 | 37.7693262500826 | -122.444221920277 | (37.7693262500826, -122.444221920277) | 15 | 5 | 11 | 29492 | 9 | |||
157351 | 120817 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989574.75375 | 2114524.02395 | 37.7854784191704 | -122.47983701814 | (37.7854784191704, -122.47983701814) | 11 | 6 | 2 | 55 | 26 | |||
4856 | 17502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002131.24887 | 2091360.19572 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | 9 | 7 | 6 | 28861 | 5 | |||
155620 | 23640 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 12 | 3X3 | 6006550.3772 | 2098540.77805 | 37.7425637693939 | -122.419971632183 | (37.7425637693939, -122.419971632183) | 2 | 7 | 7 | 28859 | 2 | ||
182519 | 85784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1257 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2015 11:19:00 AM | 3 | 3x3 | 6009427.6278 | 2110025.2513 | 37.7742592182749 | -122.410833824093 | (37.7742592182749, -122.410833824093) | 8 | 2 | 9 | 28853 | 34 | ||
70956 | 41880 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 126 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42256 | 6004087.67177215 | 2108230.12497736 | 37.7690293739028 | -122.429177676408 | (37.7690293739028, -122.429177676408) | 7 | 9 | 5 | 28862 | 3 | |
44282 | 55984 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1260 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1974 12:00:00 AM | 8 | Permit Number 12058 | 6008765.405 | 2116672.96891 | 37.7924751016038 | -122.41359485524 | (37.7924751016038, -122.41359485524) | 5 | 1 | 10 | 28857 | 21 | ||
177161 | 112747 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1262 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008734.43896 | 2116668.83333 | 37.7924620074572 | -122.413701706384 | (37.7924620074572, -122.413701706384) | 5 | 1 | 10 | 28857 | 21 | |||
107680 | 200975 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1275 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6009315.029 | 2109918.3974 | 37.7739595082871 | -122.411215775633 | (37.7739595082871, -122.411215775633) | 8 | 2 | 9 | 28853 | 34 | |||
15645 | 137035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 128 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008088.76932 | 2112909.47489 | 37.7821034452579 | -122.415669449996 | (37.7821034452579, -122.415669449996) | 7 | 10 | 9 | 28852 | 36 | |||
185571 | 215478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1283 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5992361.60735 | 2106714.7447 | 37.7641977589329 | -122.4696267106 | (37.7641977589329, -122.4696267106) | 11 | 8 | 11 | 56 | 12 | |||
140558 | 85781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1285 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2012 12:00:00 AM | 3 | 3x3 | 6009302.3903 | 2109906.9077 | 37.7739272514432 | -122.411258683374 | (37.7739272514432, -122.411258683374) | 8 | 2 | 9 | 28853 | 34 | ||
2305 | 251465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
189741 | 242375 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 130 Church St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004079.07598 | 2108183.78189 | 37.7689016404155 | -122.429204103801 | (37.7689016404155, -122.429204103801) | 7 | 9 | 5 | 28862 | 3 |
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) );