trees
83 rows where SiteOrder = 5 and qSpecies_id = 31
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
96 | 137041 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009697.84819 | 2116804.05029 | 37.7928873337267 | -122.410377820179 | (37.7928873337267, -122.410377820179) | 3 | 1 | 10 | 28857 | 21 | ||
2605 | 19985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
3373 | 119797 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
4429 | 97836 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
5601 | 180565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | |||
6820 | 244317 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005516.527 | 2110492.6418 | 37.7753224827652 | -122.424396296997 | (37.7753224827652, -122.424396296997) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||||
8560 | 242617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007051.1369 | 2096685.57383 | 37.7374979908344 | -122.418108653317 | (37.7374979908344, -122.418108653317) | 2 | 7 | 7 | 28859 | 2 | |||
10022 | 46302 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
10966 | 109166 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
15578 | 119832 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
16163 | 32994 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.84928 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | 6 | 2 | 9 | 28853 | 6 | |
16699 | 97434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380x Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
19427 | 242615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6006637.73336 | 2098498.23096 | 37.7424518658562 | -122.419666561475 | (37.7424518658562, -122.419666561475) | 2 | 7 | 7 | 28859 | 2 | |||
19858 | 109170 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
19940 | 141752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003991.9132 | 2113242.703 | 37.7827872579582 | -122.429866489942 | (37.7827872579582, -122.429866489942) | 7 | 9 | 11 | 29490 | 41 | |||
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 | ||
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 | |||
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 | |||
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 | |||
33825 | 119679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
34377 | 242501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6008245.58425 | 2103032.19484 | 37.7549915556163 | -122.414427820813 | (37.7549915556163, -122.414427820813) | 2 | 4 | 7 | 28859 | 19 | |||
35356 | 23645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 197 Virginia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006675.2549665 | 2098483.0974626 | 37.7424124262119 | -122.419535749262 | (37.7424124262119, -122.419535749262) | 2 | 7 | 7 | 28859 | 2 | |||
35889 | 14842 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.433664099691 | (37.7783201948721, -122.433664099691) | 15 | 5 | 11 | 29492 | 41 | ||
36250 | 244237 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005569.1894 | 2110157.879 | 37.7744062789 | -122.42419031207 | (37.7744062789, -122.42419031207) | 7 | 9 | 11 | 28852 | 10 | |||
38863 | 215511 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993997.50574 | 2096315.53912 | 37.7357386003548 | -122.463214016518 | (37.7357386003548, -122.463214016518) | 9 | 8 | 4 | 59 | 40 | |||
45691 | 242627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3198X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008398.66283 | 2100389.30262 | 37.7477433661635 | -122.413711502709 | (37.7477433661635, -122.413711502709) | 2 | 7 | 7 | 28859 | 2 | |||
50160 | 35613 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2839 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768494 | 6000560.21131744 | 2116797.97814823 | 37.7923541883271 | -122.44199396864 | (37.7923541883271, -122.44199396864) | 13 | 6 | 1 | 29490 | 27 | |
53195 | 242563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2225 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008187.74732 | 2105188.05934 | 37.7609078176594 | -122.414780403586 | (37.7609078176594, -122.414780403586) | 2 | 4 | 7 | 28859 | 19 | |||
53446 | 137648 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1399 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002615.378 | 2111605.9586 | 37.7782151204473 | -122.434511650396 | (37.7782151204473, -122.434511650396) | 15 | 5 | 11 | 29492 | 41 | |||
55145 | 119750 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
60158 | 244357 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005584.9883 | 2110453.4536 | 37.7752187471852 | -122.424156685679 | (37.7752187471852, -122.424156685679) | 7 | 9 | 11 | 28852 | 10 | |||
61430 | 201186 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6013494.3037 | 2113910.8362 | 37.785155331286 | -122.397038852127 | (37.785155331286, -122.397038852127) | 6 | 2 | 9 | 28856 | 6 | |||
63241 | 180537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010311.60374 | 2092285.69304 | 37.7255998252705 | -122.406525674941 | (37.7255998252705, -122.406525674941) | 10 | 3 | 7 | 309 | 28 | |||
63874 | 242550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2498 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008196.71123 | 2103917.27186 | 37.7574190299918 | -122.414659469074 | (37.7574190299918, -122.414659469074) | 2 | 4 | 7 | 28859 | 19 | |||
68996 | 119785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
69247 | 242533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2200 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008112.40906 | 2105462.60197 | 37.7616574151672 | -122.41506039942 | (37.7616574151672, -122.41506039942) | 2 | 4 | 7 | 28859 | 19 | |||
69775 | 141788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1451 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003916.891 | 2113177.719 | 37.7826045793627 | -122.430121397753 | (37.7826045793627, -122.430121397753) | 7 | 9 | 11 | 29490 | 41 | |||
72644 | 198605 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016273.49532 | 2108650.02611 | 37.770864629317 | -122.387056570311 | (37.770864629317, -122.387056570311) | 14 | 3 | 9 | 310 | 20 | ||||
72945 | 104450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
76275 | 198486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015201.9775 | 2104548.15133 | 37.7595423814855 | -122.390476349396 | (37.7595423814855, -122.390476349396) | 10 | 3 | 8 | 28856 | 29 | |||
76364 | 198457 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014932.72283 | 2106269.38668 | 37.7642535807685 | -122.391527909594 | (37.7642535807685, -122.391527909594) | 14 | 3 | 9 | 310 | 29 | |||
76571 | 198567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014762.73223 | 2114145.20399 | 37.7858693788244 | -122.392666849695 | (37.7858693788244, -122.392666849695) | 6 | 2 | 9 | 28855 | 6 | |||
80215 | 119712 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
80786 | 137010 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3099 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000011.70054 | 2116065.93819 | 37.7903129263564 | -122.443839205833 | (37.7903129263564, -122.443839205833) | 13 | 6 | 1 | 29490 | 27 | |||
81839 | 87308 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
84003 | 136959 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000575.50747 | 2118297.87683 | 37.7964733875853 | -122.442048753659 | (37.7964733875853, -122.442048753659) | 13 | 9 | 1 | 57 | 17 | |||
84788 | 7632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
92927 | 17581 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003766.78664 | 2090331.92818 | 37.7198668945342 | -122.429011330508 | (37.7198668945342, -122.429011330508) | 9 | 7 | 6 | 28861 | 5 | |||
97015 | 7585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
98495 | 198597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013173.33118 | 2107113.60808 | 37.7664738135381 | -122.397672404268 | (37.7664738135381, -122.397672404268) | 14 | 3 | 8 | 28856 | 20 | |||
101072 | 201910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.7283734198726 | -122.394550072331 | (37.7283734198726, -122.394550072331) | 10 | 3 | 8 | 58 | 1 | |||
102605 | 198431 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010792.95104 | 2106448.61245 | 37.7645150469552 | -122.405858902288 | (37.7645150469552, -122.405858902288) | 8 | 4 | 8 | 28859 | 19 | |||
106595 | 244258 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005634.1112 | 2110100.5951 | 37.7742526566427 | -122.423961660724 | (37.7742526566427, -122.423961660724) | 7 | 9 | 11 | 28852 | 10 | |||
112210 | 18528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 5 | 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 | |||
115537 | 141758 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003941.7467 | 2113359.8855 | 37.7831061707931 | -122.430048406845 | (37.7831061707931, -122.430048406845) | 7 | 9 | 11 | 29490 | 41 | |||
119447 | 244425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005682.2494 | 2109755.2828 | 37.7733072300695 | -122.423770583723 | (37.7733072300695, -122.423770583723) | 7 | 9 | 11 | 28852 | 10 | |||
119458 | 198631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015760.25573 | 2108742.67593 | 37.7710905920838 | -122.388838362899 | (37.7710905920838, -122.388838362899) | 14 | 3 | 9 | 310 | 20 | ||||
121839 | 198694 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016624.01227 | 2094969.82171 | 37.7333210410161 | -122.384890902109 | (37.7333210410161, -122.384890902109) | 10 | 3 | 8 | 58 | 1 | |||
124441 | 138804 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2375 PINE ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6002587.4194 | 2115073.5588 | 37.7877346872688 | -122.43485641346 | (37.7877346872688, -122.43485641346) | 13 | 9 | 11 | 29490 | 27 | |||
126016 | 254720 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
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 | |||
146249 | 137644 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002895.9646 | 2111642.4368 | 37.7783312042358 | -122.433543607233 | (37.7783312042358, -122.433543607233) | 15 | 5 | 11 | 29492 | 41 | |||
148260 | 46503 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.412275670972 | (37.7768559207247, -122.412275670972) | 8 | 2 | 9 | 28853 | 34 | |||
151948 | 198577 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014773.44374 | 2114176.75281 | 37.7859565995548 | -122.392631998283 | (37.7859565995548, -122.392631998283) | 6 | 2 | 9 | 28855 | 6 | |||
153984 | 198616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015899.97958 | 2108629.87401 | 37.7707886060492 | -122.388347174795 | (37.7707886060492, -122.388347174795) | 14 | 3 | 9 | 310 | 20 | ||||
154022 | 215544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993951.56494 | 2097251.7365 | 37.738306519129 | -122.463440768884 | (37.738306519129, -122.463440768884) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
158870 | 198585 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013694.72301 | 2107142.03178 | 37.7665808787261 | -122.395870983078 | (37.7665808787261, -122.395870983078) | 14 | 3 | 8 | 28856 | 20 | |
160435 | 198477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6015195.39275 | 2104723.40813 | 37.7600232337056 | -122.390511369019 | (37.7600232337056, -122.390511369019) | 10 | 3 | 8 | 28856 | 29 | |||
160953 | 198437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015533.99841 | 2106294.64452 | 37.7643562887343 | -122.389450014314 | (37.7643562887343, -122.389450014314) | 14 | 3 | 9 | 310 | 29 | |||
166938 | 215571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 32 Malta Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5999675.11481 | 2095972.75757 | 37.7351228462426 | -122.443559761297 | (37.7351228462426, -122.443559761297) | 9 | 7 | 4 | 63 | 40 | |||
168835 | 198646 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016222.39627 | 2108768.06856 | 37.771185918433 | -122.387241559965 | (37.771185918433, -122.387241559965) | 14 | 3 | 9 | 310 | 20 | ||||
171104 | 246539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | 7 | 9 | 11 | 28852 | 10 | |||
172529 | 137051 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008522.47154 | 2116730.9321 | 37.7926206100987 | -122.414439518287 | (37.7926206100987, -122.414439518287) | 5 | 1 | 10 | 28858 | 21 | |||
172858 | 242481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008312.86294 | 2102875.74333 | 37.7545657545136 | -122.414184082927 | (37.7545657545136, -122.414184082927) | 2 | 4 | 7 | 28859 | 19 | |||
175267 | 119821 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
178124 | 198467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6015376.19959 | 2105766.90453 | 37.7628984786941 | -122.389958933463 | (37.7628984786941, -122.389958933463) | 14 | 3 | 8 | 28856 | 29 | |||
182514 | 198695 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 Baldwin Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017823.53796 | 2093627.90873 | 37.7297026844336 | -122.3806505222 | (37.7297026844336, -122.3806505222) | 10 | 3 | 8 | 58 | 1 | |||
188111 | 97225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.91351 | 37.7332595687675 | -122.384799975236 | (37.7332595687675, -122.384799975236) | 10 | 3 | 8 | 58 | 1 | ||
188406 | 198496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015478.89402 | 2104602.20916 | 37.7597061705092 | -122.389522401658 | (37.7597061705092, -122.389522401658) | 10 | 3 | 8 | 28856 | 29 | |||
189177 | 198679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010343.11508 | 2111575.05475 | 37.7785659071229 | -122.40777627577 | (37.7785659071229, -122.40777627577) | 14 | 2 | 9 | 28853 | 34 | |||
191448 | 242716 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3880 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002505.00154 | 2103577.91214 | 37.7561658049102 | -122.434319380161 | (37.7561658049102, -122.434319380161) | 2 | 4 | 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) );