trees
2,365 rows where qSpecies_id = 31 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34763 | 121610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 22nd St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 11 | 6012951.69217 | 2103797.77434 | 37.7573569210097 | -122.398206359645 | (37.7573569210097, -122.398206359645) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||||
16029 | 198662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013921.99886 | 2107418.77263 | 37.7673533891782 | -122.395104256175 | (37.7673533891782, -122.395104256175) | 14 | 3 | 9 | 310 | 20 | |||
16748 | 96876 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | 9 | 7 | 6 | 28861 | 25 | |||||
22011 | 198661 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | 14 | 3 | 9 | 310 | 20 | |||
22856 | 180559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 192 Dublin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004156.47541 | 2089333.3612 | 37.7171470982496 | -122.427593206665 | (37.7171470982496, -122.427593206665) | 9 | 7 | 6 | 28861 | 5 | |||
24709 | 123166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 579 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5992807.48236 | 2111535.86844 | 37.7774610360275 | -122.468435352622 | (37.7774610360275, -122.468435352622) | 11 | 6 | 2 | 54 | 11 | ||||
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 | |||
45948 | 198666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013864.8595 | 2107478.20715 | 37.7675134055349 | -122.395306058649 | (37.7675134055349, -122.395306058649) | 14 | 3 | 9 | 310 | 20 | |||
46084 | 198654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014045.10244 | 2107292.39517 | 37.7670132295924 | -122.394669603922 | (37.7670132295924, -122.394669603922) | 14 | 3 | 9 | 310 | 20 | |||
72725 | 198658 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013985.93072 | 2107349.0106 | 37.7671653930992 | -122.39487823676 | (37.7671653930992, -122.39487823676) | 14 | 3 | 9 | 310 | 20 | |||
87486 | 242763 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000829.7469 | 2106510.44882 | 37.764122601704 | -122.440323264923 | (37.764122601704, -122.440323264923) | 15 | 5 | 5 | 28862 | 3 | |||
93406 | 198655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014030.31136 | 2107306.63823 | 37.7670515155374 | -122.3947217619 | (37.7670515155374, -122.3947217619) | 14 | 3 | 9 | 310 | 20 | |||
104116 | 137054 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 218 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6011688.33574 | 2119796.92138 | 37.8012164174502 | -122.403701277593 | (37.8012164174502, -122.403701277593) | 3 | 1 | 10 | 308 | 23 | |||
111607 | 198659 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013968.57822 | 2107369.74118 | 37.7672213498189 | -122.39493970902 | (37.7672213498189, -122.39493970902) | 14 | 3 | 9 | 310 | 20 | |||
117357 | 242704 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4137 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 3ft | 6002148.00481 | 2104679.56565 | 37.7591704102124 | -122.435632805824 | (37.7591704102124, -122.435632805824) | 2 | 4 | 5 | 28862 | 3 | |||
118364 | 198512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 681 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6013048.29942 | 2103920.61394 | 37.7576995923826 | -122.397880868001 | (37.7576995923826, -122.397880868001) | 10 | 3 | 8 | 28856 | 29 | |||
126507 | 180540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5998917.8755 | 2091146.49396 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | 9 | 7 | 6 | 28861 | 25 | |||
131307 | 198663 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013906.85624 | 2107433.38054 | 37.7673926571763 | -122.395157656112 | (37.7673926571763, -122.395157656112) | 14 | 3 | 9 | 310 | 20 | |||
155122 | 198665 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6013878.81115 | 2107466.84131 | 37.7674829733764 | -122.395257005115 | (37.7674829733764, -122.395257005115) | 14 | 3 | 9 | 310 | 20 | |||
155428 | 198656 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014014.86759 | 2107324.11249 | 37.7670986373305 | -122.394776403817 | (37.7670986373305, -122.394776403817) | 14 | 3 | 9 | 310 | 20 | |||
175198 | 198664 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013893.51882 | 2107448.48806 | 37.7674333973606 | -122.39520484712 | (37.7674333973606, -122.39520484712) | 14 | 3 | 9 | 310 | 20 | |||
176412 | 137024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003051.10397 | 2117478.36483 | 37.7943639845568 | -122.433424069968 | (37.7943639845568, -122.433424069968) | 13 | 9 | 1 | 29490 | 27 | |||
181698 | 198507 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701 Rhode Island St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6011858.82974 | 2105091.40426 | 37.7608480082603 | -122.402076874465 | (37.7608480082603, -122.402076874465) | 10 | 3 | 8 | 28856 | 29 | |||
185910 | 198653 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6014062.16151 | 2107274.88823 | 37.7669661078202 | -122.394609372737 | (37.7669661078202, -122.394609372737) | 14 | 3 | 9 | 310 | 20 | |||
192802 | 198660 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013952.39137 | 2107385.97936 | 37.7672650361872 | -122.394996834841 | (37.7672650361872, -122.394996834841) | 14 | 3 | 9 | 310 | 20 | |||
41166 | 17580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003780.63082 | 2090335.55969 | 37.7198776495042 | -122.428963734788 | (37.7198776495042, -122.428963734788) | 9 | 7 | 6 | 28861 | 5 | |||
51709 | 173899 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
59632 | 17589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503 | -122.42930461652 | (37.720035114503, -122.42930461652) | 9 | 7 | 6 | 28861 | 5 | |||
68264 | 173898 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
71414 | 17582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.429028371762 | (37.7199031291015, -122.429028371762) | 9 | 7 | 6 | 28861 | 5 | |||
86900 | 103275 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
102675 | 99285 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2839 Pacific Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 6000571.30245 | 2116798.91345 | 37.7923573884461 | -122.441955660321 | (37.7923573884461, -122.441955660321) | 13 | 6 | 1 | 29490 | 27 | ||||
118552 | 110612 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586 | 2101167 | 37.7490933856104 | -122.461530994698 | (37.7490933856104, -122.461530994698) | 1 | 8 | 4 | 29491 | 40 | ||
123382 | 17591 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003659.63671 | 2090407.22668 | 37.7200675818369 | -122.429387077163 | (37.7200675818369, -122.429387077163) | 9 | 7 | 6 | 28861 | 5 | |||
127492 | 17584 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.429104673852 | (37.7199371612464, -122.429104673852) | 9 | 7 | 6 | 28861 | 5 | |||
153301 | 17587 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003703.48138 | 2090378.19842 | 37.7199903588363 | -122.429233452259 | (37.7199903588363, -122.429233452259) | 9 | 7 | 6 | 28861 | 5 | |||
164087 | 17578 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003799.63122 | 2090323.67437 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | 9 | 7 | 6 | 28861 | 5 | |||
186333 | 103276 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
4702 | 198610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6016166.07078 | 2108644.55968 | 37.7708436706185 | -122.387427776296 | (37.7708436706185, -122.387427776296) | 14 | 3 | 9 | 310 | 20 | ||||
6477 | 215562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | 9 | 8 | 4 | 59 | 40 | |||
6913 | 215496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 69 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993975.72153 | 2097357.94979 | 37.7385995461283 | -122.463364953343 | (37.7385995461283, -122.463364953343) | 1 | 8 | 4 | 59 | 40 | |||
9179 | 215530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994021.33126 | 2097709.05499 | 37.7395662211057 | -122.463232727835 | (37.7395662211057, -122.463232727835) | 1 | 8 | 4 | 59 | 40 | |||
16709 | 215479 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 85 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992627.2877 | 2096233.38868 | 37.7354340044744 | -122.467945378584 | (37.7354340044744, -122.467945378584) | 1 | 8 | 4 | 59 | 40 | |||
17062 | 198453 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015012.52649 | 2106269.21439 | 37.7642575368696 | -122.391251877095 | (37.7642575368696, -122.391251877095) | 14 | 3 | 9 | 310 | 29 | |||
19733 | 215491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 45 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993998.37881 | 2097545.6525 | 37.7391162363258 | -122.463300232728 | (37.7391162363258, -122.463300232728) | 1 | 8 | 4 | 59 | 40 | |||
21205 | 215567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 254 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993893.11792 | 2096318.45791 | 37.735740600456 | -122.463575134792 | (37.735740600456, -122.463575134792) | 9 | 8 | 4 | 59 | 40 | |||
21307 | 215486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.7395492454888 | -122.463120453749 | (37.7395492454888, -122.463120453749) | 1 | 8 | 4 | 59 | 40 | |||
21448 | 215545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993953.28384 | 2097231.84575 | 37.7382520031164 | -122.463433382759 | (37.7382520031164, -122.463433382759) | 1 | 8 | 4 | 59 | 40 | |||
23988 | 198459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | 14 | 3 | 9 | 310 | 29 | |||
24238 | 215561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994051.56415 | 2096391.91316 | 37.7359514186289 | -122.463032656549 | (37.7359514186289, -122.463032656549) | 9 | 8 | 4 | 59 | 40 | |||
24769 | 198491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 907 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015266.77203 | 2104421.22514 | 37.7591974636091 | -122.390243388116 | (37.7591974636091, -122.390243388116) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
34182 | 198607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016227.74089 | 2108648.22285 | 37.7708571442621 | -122.387214711603 | (37.7708571442621, -122.387214711603) | 14 | 3 | 9 | 310 | 20 | ||||
34642 | 198561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014636.30194 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | 10 | 3 | 8 | 58 | 1 | |||
35787 | 198528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014599.09575 | 2096195.70079 | 37.7365748475583 | -122.391977349386 | (37.7365748475583, -122.391977349386) | 10 | 3 | 8 | 58 | 1 | |||
38442 | 198473 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015189.15616 | 2104818.6313 | 37.7602843500682 | -122.39053959244 | (37.7602843500682, -122.39053959244) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
39873 | 215541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993946.31928 | 2097307.15629 | 37.7384583858397 | -122.463462926386 | (37.7384583858397, -122.463462926386) | 1 | 8 | 4 | 59 | 40 | |||
40054 | 198640 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015953.10569 | 2108752.97494 | 37.7711295579122 | -122.388172001232 | (37.7711295579122, -122.388172001232) | 14 | 3 | 9 | 310 | 20 | ||||
40087 | 215483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.462953960472 | (37.7397934743851, -122.462953960472) | 1 | 8 | 4 | 59 | 40 | |||
40289 | 215500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618 | -122.463015880573 | (37.736806354618, -122.463015880573) | 9 | 8 | 4 | 59 | 40 | |||
40473 | 215488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 33 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994033.38086 | 2097656.16741 | 37.7394216991581 | -122.463187229312 | (37.7394216991581, -122.463187229312) | 1 | 8 | 4 | 59 | 40 | |||
41088 | 198525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014663.37225 | 2096146.01075 | 37.736441977204 | -122.391751642923 | (37.736441977204, -122.391751642923) | 10 | 3 | 8 | 58 | 1 | |||
41378 | 198530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014455.10696 | 2096302.51395 | 37.7368601394856 | -122.392482653249 | (37.7368601394856, -122.392482653249) | 10 | 3 | 8 | 58 | 1 | |||
42812 | 215548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994023.18881 | 2096729.95205 | 37.7368779550533 | -122.463155280903 | (37.7368779550533, -122.463155280903) | 9 | 8 | 4 | 59 | 40 | |||
43335 | 215497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 73 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993976.24019 | 2097340.186 | 37.738550801067 | -122.46336187137 | (37.738550801067, -122.46336187137) | 1 | 8 | 4 | 59 | 40 | |||
44496 | 198622 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015766.21634 | 2108621.93006 | 37.7707593807704 | -122.388809313913 | (37.7707593807704, -122.388809313913) | 14 | 3 | 9 | 310 | 20 | ||||
44552 | 198462 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014805.14744 | 2106272.79418 | 37.7642558551341 | -122.391969398478 | (37.7642558551341, -122.391969398478) | 14 | 3 | 9 | 310 | 29 | |||
44710 | 215501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 225 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994092.6368 | 2096583.02497 | 37.7364785301452 | -122.462904513945 | (37.7364785301452, -122.462904513945) | 9 | 8 | 4 | 59 | 40 | |||
44812 | 198627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015673.13601 | 2108738.35245 | 37.7710738916798 | -122.389139413673 | (37.7710738916798, -122.389139413673) | 14 | 3 | 9 | 310 | 20 | ||||
45131 | 198642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016136.74684 | 2108760.92666 | 37.7711615647777 | -122.387537328991 | (37.7711615647777, -122.387537328991) | 14 | 3 | 9 | 310 | 20 | ||||
45197 | 215559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994067.05947 | 2096413.85404 | 37.7360125554181 | -122.462980674831 | (37.7360125554181, -122.462980674831) | 9 | 8 | 4 | 59 | 40 | |||
45264 | 198574 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014815.04425 | 2114132.68239 | 37.7858379025473 | -122.392484987011 | (37.7858379025473, -122.392484987011) | 6 | 2 | 9 | 28855 | 6 | |||
46213 | 215494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 61 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993979.60004 | 2097443.67302 | 37.7388351442124 | -122.463357762357 | (37.7388351442124, -122.463357762357) | 1 | 8 | 4 | 59 | 40 | |||
47939 | 215564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 250 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993972.9824 | 2096339.81611 | 37.7358038461725 | -122.463300563692 | (37.7358038461725, -122.463300563692) | 9 | 8 | 4 | 59 | 40 | |||
48815 | 215543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993948.48206 | 2097274.4923 | 37.7383688232683 | -122.46345307882 | (37.7383688232683, -122.46345307882) | 1 | 8 | 4 | 59 | 40 | |||
49082 | 198557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014596.8944 | 2096198.85091 | 37.7365833749264 | -122.391985180675 | (37.7365833749264, -122.391985180675) | 10 | 3 | 8 | 58 | 1 | |||
50726 | 215532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 42 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993980.35431 | 2097605.67891 | 37.7392800154546 | -122.463366907564 | (37.7392800154546, -122.463366907564) | 1 | 8 | 4 | 59 | 40 | |||
51789 | 198487 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6015204.943 | 2104516.59795 | 37.7594559071887 | -122.390463888397 | (37.7594559071887, -122.390463888397) | 10 | 3 | 8 | 28856 | 29 | |||
54459 | 198563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014720.16797 | 2114187.47554 | 37.7859830827904 | -122.392817069764 | (37.7859830827904, -122.392817069764) | 6 | 2 | 9 | 28855 | 6 | |||
54694 | 215525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 478 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994741.9738 | 2100056.97706 | 37.7460545185029 | -122.460911199901 | (37.7460545185029, -122.460911199901) | 1 | 8 | 4 | 29491 | 40 | |||
56446 | 198623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | 14 | 3 | 9 | 310 | 20 | ||||
57450 | 215485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 21 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994064.51337 | 2097723.86139 | 37.7396093633696 | -122.463084497953 | (37.7396093633696, -122.463084497953) | 1 | 8 | 4 | 59 | 40 | |||
58392 | 215480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 55 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992620.87783 | 2096424.47164 | 37.7359583002413 | -122.467981434219 | (37.7359583002413, -122.467981434219) | 1 | 8 | 4 | 59 | 40 | |||
59271 | 215556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994083.61734 | 2096486.44711 | 37.7362128317539 | -122.462928693117 | (37.7362128317539, -122.462928693117) | 9 | 8 | 4 | 59 | 40 | |||
59298 | 215558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994076.83101 | 2096438.60242 | 37.7360810711916 | -122.462948685927 | (37.7360810711916, -122.462948685927) | 9 | 8 | 4 | 59 | 40 | |||
59407 | 198638 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015910.55807 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | 14 | 3 | 9 | 310 | 20 | ||||
60183 | 198611 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6016143.32489 | 2108643.38282 | 37.7708391794209 | -122.387506373441 | (37.7708391794209, -122.387506373441) | 14 | 3 | 9 | 310 | 20 | ||||
61963 | 198601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6016359.83761 | 2108655.37305 | 37.7708840915587 | -122.386758280474 | (37.7708840915587, -122.386758280474) | 14 | 3 | 9 | 310 | 20 | ||||
62302 | 198549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1742 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6014473.93082 | 2096284.01772 | 37.7368103979679 | -122.392416277009 | (37.7368103979679, -122.392416277009) | 10 | 3 | 8 | 58 | 1 | |||
63563 | 215484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.7396792290015 | -122.46304340523 | (37.7396792290015, -122.46304340523) | 1 | 8 | 4 | 59 | 40 | |||
66944 | 198633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015806.09479 | 2108744.28476 | 37.7710975501444 | -122.388679914958 | (37.7710975501444, -122.388679914958) | 14 | 3 | 9 | 310 | 20 |
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) );