trees

2,365 rows where qSpecies_id = 31

✎ View and edit SQL

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)
25726 215523 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 80 Northwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995460.48677 2094242.81923 37.7301315873058 -122.458006001202 (37.7301315873058, -122.458006001202) 9 7 4 28861 40
25809 242477 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2831 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008363.71798 2101936.55898 37.7519898227944 -122.413941777714 (37.7519898227944, -122.413941777714) 2 4 7 28859 19
25820 25189 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3733 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6000311.6199976 2102932.6354717 37.7542692908961 -122.441858505139 (37.7542692908961, -122.441858505139) 2 4 5 63 38
25912 215526 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 478 Dewey Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994752.10675 2100066.65325 37.7460816699447 -122.460876862898 (37.7460816699447, -122.460876862898) 1 8 4 29491 40
26005 137018 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2716 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6001024.79883 2116912.49705 37.7926950910553 -122.440394705264 (37.7926950910553, -122.440394705264) 13 6 1 29490 27
26225 244356 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Octavia St 4 Median : Cutout Tree DPW 1     7 Width 0ft   6005588.2934 2110426.5412 37.7751450388721 -122.424143338216 (37.7751450388721, -122.424143338216) 7 9 11 28852 10
26267 198618 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 454 Mission Bay Blvd South 7 Sidewalk: Curb side : Yard Tree Private 2     5     6015853.85549 2108626.75005 37.770777472425 -122.388506502268 (37.770777472425, -122.388506502268) 14 3 9 310 20
26272 9765 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 827X Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6000964.4329 2111657.6469 37.7782631876883 -122.440226567073 (37.7782631876883, -122.440226567073) 15 5 11 29490 41
26333 85767 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1400X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6008747.4583 2109466.0696 37.7726856753072 -122.41314711365 (37.7726856753072, -122.41314711365) 8 2 9 28853 34
26377 18527 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3104X Folsom St 4 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6008391.22062 2100547.0534 37.7481760966626 -122.413748394121 (37.7481760966626, -122.413748394121) 2 4 7 28859 2
26388 244359 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 6 Median : Cutout Tree DPW 1     5 Width 0ft   6005522.1928 2110456.2865 37.7752229798737 -122.424374111287 (37.7752229798737, -122.424374111287) 7 9 11 28852 10
26514 17556 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 626 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6003246.79786 2090613.71944 37.7206111833437 -122.430828848684 (37.7206111833437, -122.430828848684) 9 7 6 28861 5
26544 50045 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3928 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM   3x3 Permit Number 46776 6003593.46976323 2102471.5753466 37.753189787602 -122.430476153053 (37.753189787602, -122.430476153053) 2 4 5 28862 22
26567 110786 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 410 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012080 2118442 37.7975180016372 -122.402250623365 (37.7975180016372, -122.402250623365) 3 1 10 308 23
26629 7553 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2896 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 3X3   6008325.6957 2101595.54831 37.751051348746 -122.41404914235 (37.751051348746, -122.41404914235) 2 4 7 28859 19
26663 85795 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 985 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 12 3x3   6011121.9774 2111644.9134 37.7788012938106 -122.405086799447 (37.7788012938106, -122.405086799447) 14 2 9 28856 34
26707 242697 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 264 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001741.09826 2104301.70162 37.7581097668584 -122.437013028641 (37.7581097668584, -122.437013028641) 2 4 5 28862 3
26729 7657 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3334 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6008459.10706 2099217.21001 37.7445284544392 -122.413419609751 (37.7445284544392, -122.413419609751) 2 7 7 28859 2
26830 97057 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 227 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6003560 2106944 37.7654681015181 -122.430911059584 (37.7654681015181, -122.430911059584) 8 4 5 28862 3
26832 7543 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2872 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6008316.06064 2101754.32335 37.7514867681181 -122.414093692993 (37.7514867681181, -122.414093692993) 2 4 7 28859 19
26836 198657 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 10 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6013998.08453 2107337.5024 37.7671344699085 -122.394835392165 (37.7671344699085, -122.394835392165) 14 3 9 310 20
26914 242771 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 930 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002454.1308 2102779.02186 37.7539693556059 -122.434438191367 (37.7539693556059, -122.434438191367) 2 4 5 28862 22
26952 137023 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003036.9655 2117481.25366 37.7943711144001 -122.433473197238 (37.7943711144001, -122.433473197238) 13 9 1 29490 27
26996 242532 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2140 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/21/2007 12:00:00 AM 7 Width 3ft   6008084.96302 2105937.52751 37.7629599086871 -122.41518894402 (37.7629599086871, -122.41518894402) 8 4 7 28859 19
27032 119717 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 10 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
27123 242567 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2121 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008134.5513 2106113.05528 37.7634446540583 -122.415029859359 (37.7634446540583, -122.415029859359) 8 4 7 28859 19
27268 16442 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1395 Newcomb Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
27279 7440 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2528 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6008209.2972 2103689.65921 37.7567947646774 -122.414599835016 (37.7567947646774, -122.414599835016) 2 4 7 28859 19
27340 242558 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2355 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008208.12172 2104777.36989 37.7597813034931 -122.414680872925 (37.7597813034931, -122.414680872925) 2 4 7 28859 19
27440 33762 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1800X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/11/1996 12:00:00 AM 5 3x3 Permit Number 37814 6003491.84820405 2114902.28438826 37.7873157193536 -122.431715030855 (37.7873157193536, -122.431715030855) 13 9 11 29490 27
27643 7457 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2577 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008281.25133 2103428.77827 37.7560824872415 -122.414332532234 (37.7560824872415, -122.414332532234) 2 4 7 28859 19
27672 107994 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4410x 23RD ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000358 2102265 37.7524387685866 -122.441650202415 (37.7524387685866, -122.441650202415) 2 4 5 28862 22
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
27897 242493 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2500 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6008201.36551 2103826.65132 37.7571704681572 -122.414636959936 (37.7571704681572, -122.414636959936) 2 4 7 28859 19
27901 7664 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3348 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6008462.72403 2099121.09112 37.7442647363292 -122.413400306703 (37.7442647363292, -122.413400306703) 2 7 7 28859 2
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
28247 91339 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 829 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2009 12:00:00 AM 1 3x3 Permit Number 52060 6012087.196 2112565.923 37.7813840839391 -122.401812466037 (37.7813840839391, -122.401812466037) 6 2 9 28856 34
28371 108235 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 131 RUSS ST 8 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010302 2111707 37.7789258960759 -122.407927816208 (37.7789258960759, -122.407927816208) 14 2 9 28853 34
28436 17602 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 912 Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6003897.46129 2090203.63126 37.7195220153206 -122.428550493605 (37.7195220153206, -122.428550493605) 9 7 6 28861 5
28443 198576 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 425 01st St 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   6014783.08484 2114165.12178 37.7859251988423 -122.392597828542 (37.7859251988423, -122.392597828542) 6 2 9 28855 6
28588 17551 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 601 Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6003191.74591 2090695.76954 37.7208333554501 -122.431024998907 (37.7208333554501, -122.431024998907) 9 7 6 28861 5
28621 198494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015476.06266 2104658.66701 37.7598610346751 -122.389536136987 (37.7598610346751, -122.389536136987) 10 3 8 28856 29
28726 242418 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6005476.19264 2102018.01843 37.7520508975422 -122.423933062164 (37.7520508975422, -122.423933062164) 2 4 5 28859 19
28774 242588 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 660 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6002106.32831 2102091.37064 37.7520614807656 -122.435591781438 (37.7520614807656, -122.435591781438) 2 4 5 28862 22
28789 31076 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 8   Permit Number 34816 6006020.69113 2107294.38947 37.7665693044606 -122.422424975532 (37.7665693044606, -122.422424975532) 8 4 5 28853 19
28829 123586 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 62 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994279.04973 2115190.28174 37.787579957729 -122.463610042193 (37.787579957729, -122.463610042193) 11 6 1 54 11
28840 137884 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1928 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003417.2048 2115384.0895 37.7886344027041 -122.432007699107 (37.7886344027041, -122.432007699107) 13 9 1 29490 27
28907 113443 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 742 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5994762.07163 2110522.43311 37.7747911175465 -122.461600336607 (37.7747911175465, -122.461600336607) 11 6 2 54 11
28962 136999 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2452 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6002307.2495 2116764.38372 37.7923613472576 -122.435946778048 (37.7923613472576, -122.435946778048) 13 9 1 29490 27
29010 141480 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2210 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998945.488 2111497.8751 37.7777093428916 -122.447199310957 (37.7777093428916, -122.447199310957) 15 6 2 54 16
29074 109434 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 7 DANVERS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999816.1 2105451.8 37.7611580492101 -122.443753102957 (37.7611580492101, -122.443753102957) 15 5 5 28862 3
29302 7646 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3301 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3x3   6008513.44624 2099397.67081 37.745027010685 -122.413244473962 (37.745027010685, -122.413244473962) 2 7 7 28859 2
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
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
29420 244397 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 200x Octavia St 8 Median : Cutout Tree DPW 1     4 Width 0ft   6005625.7095 2110167.0444 37.7744346360097 -122.423995450078 (37.7744346360097, -122.423995450078) 7 9 11 28852 10
29434 215512 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993946.59661 2096298.31331 37.7356883696217 -122.463388778181 (37.7356883696217, -122.463388778181) 9 8 4 59 40
29511 244254 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 200x Octavia St 1 Median : Cutout Tree DPW 1     6 Width 0ft   6005646.3317 2110018.1063 37.7740268522621 -122.423913520847 (37.7740268522621, -122.423913520847) 7 9 11 28852 10
29698 242600 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 Surrey St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002217.82403 2096159.00983 37.7357789394319 -122.434782025597 (37.7357789394319, -122.434782025597) 2 7 5 63 7
29840 242773 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1514 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6002543.02817 2101051.83615 37.749231959098 -122.43400730909 (37.749231959098, -122.43400730909) 2 4 5 28862 22
29914 198681 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 Russ St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6010294.84433 2111624.83118 37.7786998791448 -122.407946774624 (37.7786998791448, -122.407946774624) 14 2 9 28853 34
29976 244375 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 5 Median : Cutout Tree DPW 1     6 Width 0ft   6005617.5038 2109823.1115 37.7734898161448 -122.423999372272 (37.7734898161448, -122.423999372272) 7 9 11 28852 10
30064 242461 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 206 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006823.0502 2098332.30015 37.7420066942676 -122.419014023301 (37.7420066942676, -122.419014023301) 2 7 7 28859 2
30137 52300 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 264 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 5 3x3 Permit Number 53169 6001736.20846819 2104306.03679934 37.758121392277 -122.437030249981 (37.758121392277, -122.437030249981) 2 4 5 28862 3
30156 198691 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301 Newcomb Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6016677.93992 2094927.14945 37.7332068541071 -122.384701486 (37.7332068541071, -122.384701486) 10 3 8 58 1
30193 31614 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2146 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1995 12:00:00 AM 12   Permit Number 35135 6001571.0697 2119772.3198 37.8005785040659 -122.43870960599 (37.8005785040659, -122.43870960599) 13 9 1 57 17
30218 97985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     16     6015230.10587 2104016.74085 37.7580848025885 -122.390341937645 (37.7580848025885, -122.390341937645) 10 3 8 28856 29
30219 7647 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3302 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6008452.78429 2099390.30637 37.7450033836799 -122.413453712108 (37.7450033836799, -122.413453712108) 2 7 7 28859 2
30298 215566 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 250 Santa Paula Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993936.1007 2096327.5375 37.7357680072927 -122.463427186434 (37.7357680072927, -122.463427186434) 9 8 4 59 40
30309 137034 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1756 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6005175.40466 2117844.84093 37.7954905257115 -122.426099835651 (37.7954905257115, -122.426099835651) 13 9 1 28858 27
30451 242430 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6005000.31444 2109901.75025 37.7736708747372 -122.426139921128 (37.7736708747372, -122.426139921128) 7 9 11 28852 10
30661 242456 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 145 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5999380.76435 2107349.43867 37.7663436510568 -122.445395186755 (37.7663436510568, -122.445395186755) 15 5 5 29492 9
30695 255050 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199x 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008753 2110574 37.7757281025158 -122.413206304146 (37.7757281025158, -122.413206304146) 8 2 9 28853 34
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
31182 244424 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100x Octavia St 4 Median : Cutout Tree DPW 1     5 Width 0ft   6005686.3603 2109729.9326 37.7732378565997 -122.423754560713 (37.7732378565997, -122.423754560713) 7 9 11 28852 10
31486 244396 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 200x Octavia St 7 Median : Cutout Tree DPW 1     4 Width 0ft   6005626.4733 2110143.3671 37.7743696669954 -122.423991123858 (37.7743696669954, -122.423991123858) 7 9 11 28852 10
31630 109498 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2440 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5989239.6228 2098735.6386 37.7421083236068 -122.479840718717 (37.7421083236068, -122.479840718717) 1 8 3 29491 35
31673 119709 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
31677 138807 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2355 PINE ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 0ft   6002661.6347 2115086.2451 37.7877737339769 -122.434600550462 (37.7877737339769, -122.434600550462) 13 9 11 29490 27
31679 17592 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 801X Persia Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1     50 3x3   6003646.11767 2090408.41073 37.7200700675728 -122.429433892277 (37.7200700675728, -122.429433892277) 9 7 6 28861 5
31707 242484 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2675 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008307.71975 2102954.44615 37.7547815657263 -122.414207437417 (37.7547815657263, -122.414207437417) 2 4 7 28859 19
31708 198480 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 800 Minnesota St 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   6015199.5579 2104656.07032 37.7598385696177 -122.390492258425 (37.7598385696177, -122.390492258425) 10 3 8 28856 29
31801 242443 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1331 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6003922.38967 2100509.16496 37.7478200945407 -122.429198764536 (37.7478200945407, -122.429198764536) 2 4 5 63 22
32217 242427 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6005044.68577 2109860.00586 37.77355876256 -122.425983461566 (37.77355876256, -122.425983461566) 7 9 11 28852 10
32248 137656 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1370 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002616.7582 2111653.0845 37.7783445947245 -122.434510246189 (37.7783445947245, -122.434510246189) 15 5 11 29490 41
32368 242591 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4412 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6000545.74742 2102300.80991 37.7525477891746 -122.441003511213 (37.7525477891746, -122.441003511213) 2 4 5 28862 22
32458 7507 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2732 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008276.1167 2102495.63386 37.7535199958745 -122.414284269217 (37.7535199958745, -122.414284269217) 2 4 7 28859 19
32495 105218 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2100 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2014 12:00:00 AM 2 3x3 Permit Number 772439 5999896.69925 2116138.83336 37.790506517102 -122.444242341317 (37.790506517102, -122.444242341317) 13 6 1 29490 27
32626 7461 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2590 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3x3   6008225.96589 2103367.55132 37.7559112662001 -122.414519396076 (37.7559112662001, -122.414519396076) 2 4 7 28859 19
32719 242505 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2618 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008253.889 2102895.90395 37.7546177982782 -122.414389457507 (37.7546177982782, -122.414389457507) 2 4 7 28859 19
32785 115468 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 83 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5993932.33914 2114999.07157 37.7870349634341 -122.464795691681 (37.7870349634341, -122.464795691681) 11 6 1 54 11
32829 242711 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3836 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002806.04485 2103594.72393 37.7562290488364 -122.433279472464 (37.7562290488364, -122.433279472464) 2 4 5 28862 3
32856 198447 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015324.46824 2106281.29518 37.7643080149349 -122.390173794086 (37.7643080149349, -122.390173794086) 14 3 9 310 29
33091 242450 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 131 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998044.50081 2105941.804 37.7624022705703 -122.44991559303 (37.7624022705703, -122.44991559303) 15 5 11 29492 9
33215 198644 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 421 Mission Bay Blvd North 3 Sidewalk: Curb side : Yard Tree Private 2     7     6016180.11848 2108766.38719 37.7711789603624 -122.387387684488 (37.7711789603624, -122.387387684488) 14 3 9 310 20
33254 119798 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 6 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
33260 7579 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2995 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 4x4   6008416.03486 2101001.24422 37.7494245965646 -122.41369470787 (37.7494245965646, -122.41369470787) 2 4 7 28859 19
33483 119753 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 8 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
33488 198652 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 421 Mission Bay Blvd North 11 Sidewalk: Curb side : Yard Tree Private 2     8     6016352.81609 2108774.30794 37.7712102720761 -122.386790863815 (37.7712102720761, -122.386790863815) 14 3 9 310 20
33495 242479 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2743 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008338.99479 2102440.60653 37.7533724350926 -122.414062929853 (37.7533724350926, -122.414062929853) 2 4 7 28859 19
33627 39478 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2856 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 777203 5999897.32915775 2117456.37972289 37.7941241886563 -122.44433488583 (37.7941241886563, -122.44433488583) 13 9 1 57 27

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);