trees
2,365 rows where qSpecies_id = 31 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11729 | 244288 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.424108218812 | (37.7739922036556, -122.424108218812) | 7 | 9 | 11 | 28852 | 10 | |||
14903 | 91162 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.34702 | 2112584.78934 | 37.7811570014217 | -122.419024399678 | (37.7811570014217, -122.419024399678) | 7 | 9 | 9 | 28852 | 36 | |
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 | |||
24722 | 244306 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303 | (37.7753816404734, -122.42418868303) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
34818 | 245849 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 251 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005124.4628 | 2109778.1319 | 37.7733384648593 | -122.425701672194 | (37.7733384648593, -122.425701672194) | 7 | 9 | 11 | 28852 | 10 | |||
35000 | 244311 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
37182 | 109162 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | |||
37362 | 242429 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005025.33066 | 2109905.44475 | 37.7736824328302 | -122.426053649163 | (37.7736824328302, -122.426053649163) | 7 | 9 | 11 | 28852 | 10 | |||
39077 | 103271 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
41710 | 244310 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005563.2696 | 2110605.957 | 37.7756362582127 | -122.424242664251 | (37.7756362582127, -122.424242664251) | 7 | 9 | 11 | 28852 | 10 | |||
43059 | 244376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | 7 | 9 | 11 | 28852 | 10 | |||
43824 | 246542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126 | (37.772505687922, -122.42377321126) | 7 | 9 | 11 | 28852 | 10 | |||
50705 | 246545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | 7 | 9 | 11 | 28852 | 10 | |||
53252 | 244930 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005316.3896 | 2109945.8285 | 37.7738097625345 | -122.425049704262 | (37.7738097625345, -122.425049704262) | 7 | 9 | 11 | 28852 | 10 | |||
54713 | 91161 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007091.03056 | 2112582.20177 | 37.7811486961969 | -122.419097960601 | (37.7811486961969, -122.419097960601) | 7 | 9 | 9 | 28852 | 36 | |
56148 | 246538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | 7 | 9 | 11 | 28852 | 10 | |||
59252 | 244309 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005567.5189 | 2110582.8218 | 37.7755729745028 | -122.424226319105 | (37.7755729745028, -122.424226319105) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
60396 | 245223 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | 7 | 9 | 11 | 28852 | 10 | |||
60593 | 242431 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 308 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004963.84675 | 2109896.18712 | 37.7736535385006 | -122.42626567242 | (37.7736535385006, -122.42626567242) | 7 | 9 | 11 | 28852 | 10 | |||
61325 | 244354 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005594.4313 | 2110381.2151 | 37.7750209309426 | -122.424118881689 | (37.7750209309426, -122.424118881689) | 7 | 9 | 11 | 28852 | 10 | |||
61528 | 136986 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 Hayes St | 3 | : | Tree | Private 2 | 19 | Width 4ft | 6004705.5479 | 2110850.60835 | 37.7762595426756 | -122.427227166401 | (37.7762595426756, -122.427227166401) | 7 | 9 | 11 | 28852 | 10 | |||
64742 | 245869 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 265 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005113.693 | 2109858.5889 | 37.7735587716848 | -122.425744654224 | (37.7735587716848, -122.425744654224) | 7 | 9 | 11 | 28852 | 10 | |||
64986 | 245225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | Width 0ft | 6005059 | 2109842 | 37.7735101318079 | -122.425932664502 | (37.7735101318079, -122.425932664502) | 7 | 9 | 11 | 28852 | 10 | ||
66993 | 244411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6005560.024 | 2110238.8403 | 37.7746280615118 | -122.424227776164 | (37.7746280615118, -122.424227776164) | 7 | 9 | 11 | 28852 | 10 | |||
70024 | 246553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6005726.46493 | 2109532.06592 | 37.7726968262309 | -122.423601762727 | (37.7726968262309, -122.423601762727) | 7 | 9 | 11 | 28852 | 10 | |||
72628 | 244361 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | 7 | 9 | 11 | 28852 | 10 | |||
73424 | 242432 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004922.33437 | 2109891.99021 | 37.7736396682718 | -122.426408971312 | (37.7736396682718, -122.426408971312) | 7 | 9 | 11 | 28852 | 10 | |||
74412 | 244259 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) | 7 | 9 | 11 | 28852 | 10 | |||
74986 | 244345 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005607.2268 | 2109894.3659 | 37.7736848832921 | -122.424039990106 | (37.7736848832921, -122.424039990106) | 7 | 9 | 11 | 28852 | 10 | |||
75473 | 244305 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.7753208695982 | -122.424177304818 | (37.7753208695982, -122.424177304818) | 7 | 9 | 11 | 28852 | 10 | |||
75735 | 54877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 317 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1972 12:00:00 AM | 4x3 | Permit Number 10739 | 6005042.77490786 | 2109859.41873684 | 37.7735570424684 | -122.425990029724 | (37.7735570424684, -122.425990029724) | 7 | 9 | 11 | 28852 | 10 | ||
76811 | 244287 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005585.9927 | 2110033.382 | 37.7740653890161 | -122.424123330561 | (37.7740653890161, -122.424123330561) | 7 | 9 | 11 | 28852 | 10 | |||
81285 | 244426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.7733541831734 | -122.423776541571 | (37.7733541831734, -122.423776541571) | 7 | 9 | 11 | 28852 | 10 | |||
84532 | 244398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005622.6544 | 2110184.6115 | 37.7744826985313 | -122.42400726776 | (37.7744826985313, -122.42400726776) | 7 | 9 | 11 | 28852 | 10 | |||
84842 | 244328 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | 7 | 9 | 11 | 28852 | 10 | |||
85836 | 244364 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005534.4686 | 2110345.8041 | 37.7749203151844 | -122.424323786781 | (37.7749203151844, -122.424323786781) | 7 | 9 | 11 | 28852 | 10 | |||
86066 | 69124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.425679204983 | (37.7760283687547, -122.425679204983) | 7 | 9 | 11 | 28852 | 10 | |
86911 | 244468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | 7 | 9 | 11 | 28852 | 10 | |||
87612 | 244235 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | 7 | 9 | 11 | 28852 | 10 | |||
87801 | 244358 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | 7 | 9 | 11 | 28852 | 10 | |||
87894 | 244467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005631.8918 | 2109690.1946 | 37.7731256707262 | -122.423940148458 | (37.7731256707262, -122.423940148458) | 7 | 9 | 11 | 28852 | 10 | |||
88042 | 244423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | 7 | 9 | 11 | 28852 | 10 | |||
89789 | 244330 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.423838604142 | (37.7736448835433, -122.423838604142) | 7 | 9 | 11 | 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 | |||
96653 | 242433 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004899.43089 | 2109888.25231 | 37.7736281101874 | -122.426487931787 | (37.7736281101874, -122.426487931787) | 7 | 9 | 11 | 28852 | 10 | |||
96695 | 12261 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2000 12:00:00 AM | 3 | 3X3 | 6004982.9117 | 2111116.4652 | 37.7770052022278 | -122.426286620749 | (37.7770052022278, -122.426286620749) | 7 | 9 | 11 | 28852 | 10 | ||
98566 | 242426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 317 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005001.43117 | 2109853.31909 | 37.7735379576528 | -122.426132609638 | (37.7735379576528, -122.426132609638) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||||
100227 | 244327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.423804755705 | (37.773436531636, -122.423804755705) | 7 | 9 | 11 | 28852 | 10 | |||
100699 | 246540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | 7 | 9 | 11 | 28852 | 10 | |||
102320 | 244307 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005574.129 | 2110533.2464 | 37.775437225715 | -122.424199926569 | (37.775437225715, -122.424199926569) | 7 | 9 | 11 | 28852 | 10 | |||
103899 | 246541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.7724418486558 | -122.423755901126 | (37.7724418486558, -122.423755901126) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
108330 | 244284 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005583.7013 | 2110055.5318 | 37.7741260776332 | -122.424132832467 | (37.7741260776332, -122.424132832467) | 7 | 9 | 11 | 28852 | 10 | |||
112920 | 244466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | 7 | 9 | 11 | 28852 | 10 | |||
115223 | 91160 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007065.15922 | 2112579.7073 | 37.7811403900434 | -122.419187285764 | (37.7811403900434, -122.419187285764) | 7 | 9 | 9 | 28852 | 36 | |
115729 | 244312 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005504.7234 | 2110575.2675 | 37.7755486863335 | -122.424443006762 | (37.7755486863335, -122.424443006762) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
119514 | 246544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6005666.89387 | 2109521.55091 | 37.7726645918273 | -122.42380707794 | (37.7726645918273, -122.42380707794) | 7 | 9 | 11 | 28852 | 10 | |||
120641 | 100077 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005310 | 2109942 | 37.7737988894613 | -122.425071534475 | (37.7737988894613, -122.425071534475) | 7 | 9 | 11 | 28852 | 10 | ||||
120909 | 245848 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 251 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005123.1957 | 2109797.771 | 37.7733923174645 | -122.425707453362 | (37.7733923174645, -122.425707453362) | 7 | 9 | 11 | 28852 | 10 | ||
121002 | 251466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
122715 | 244283 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005579.1186 | 2110077.6816 | 37.7741866368779 | -122.424150260413 | (37.7741866368779, -122.424150260413) | 7 | 9 | 11 | 28852 | 10 | |||
124048 | 246554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.7727396879137 | -122.423612306376 | (37.7727396879137, -122.423612306376) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
126195 | 244399 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005618.8355 | 2110208.2889 | 37.7745474953334 | -122.424022162207 | (37.7745474953334, -122.424022162207) | 7 | 9 | 11 | 28852 | 10 | |||
127051 | 244478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | 7 | 9 | 11 | 28852 | 10 | |||
127336 | 244316 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005509.917 | 2110533.7186 | 37.7754348964248 | -122.424422084884 | (37.7754348964248, -122.424422084884) | 7 | 9 | 11 | 28852 | 10 | |||
129666 | 244331 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005661.6953 | 2109906.0133 | 37.7737199393103 | -122.423852403284 | (37.7737199393103, -122.423852403284) | 7 | 9 | 11 | 28852 | 10 | |||
131533 | 47022 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769670 | 6004925.00265887 | 2109895.52879881 | 37.7736495352098 | -122.426399993288 | (37.7736495352098, -122.426399993288) | 7 | 9 | 11 | 28852 | 10 |
135699 | 244329 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005667.8615 | 2109858.0536 | 37.773588601657 | -122.423827662517 | (37.773588601657, -122.423827662517) | 7 | 9 | 11 | 28852 | 10 | |||
135919 | 244410 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005558.4964 | 2110254.116 | 37.7746699186287 | -122.424234147092 | (37.7746699186287, -122.424234147092) | 7 | 9 | 11 | 28852 | 10 | |||
137108 | 137036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 128 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008091.14561 | 2112874.2674 | 37.7820069075434 | -122.415658735479 | (37.7820069075434, -122.415658735479) | 7 | 10 | 9 | 28852 | 36 | |||
138929 | 246537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | 7 | 9 | 11 | 28852 | 10 | |||
142693 | 244455 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | 7 | 9 | 11 | 28852 | 10 | |||
143338 | 244477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | 7 | 9 | 11 | 28852 | 10 | |||
145347 | 244456 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.7733190115017 | -122.423971237778 | (37.7733190115017, -122.423971237778) | 7 | 9 | 11 | 28852 | 10 | |||
147586 | 244236 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005567.6618 | 2110181.5564 | 37.7744712050545 | -122.424197280606 | (37.7744712050545, -122.424197280606) | 7 | 9 | 11 | 28852 | 10 | |||
150725 | 63592 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | 3x3 | Permit Number 24223 | 6005148 | 2109920 | 37.7737293302527 | -122.425630352746 | (37.7737293302527, -122.425630352746) | 7 | 9 | 11 | 28852 | 10 | ||
150944 | 244257 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005636.4025 | 2110083.7918 | 37.7742066482035 | -122.423952539557 | (37.7742066482035, -122.423952539557) | 7 | 9 | 11 | 28852 | 10 | |||
151318 | 244400 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005615.7803 | 2110234.2576 | 37.7746186266053 | -122.424034577863 | (37.7746186266053, -122.424034577863) | 7 | 9 | 11 | 28852 | 10 | |||
151443 | 244401 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.7252 | 2110260.2263 | 37.7746897578806 | -122.424046993197 | (37.7746897578806, -122.424046993197) | 7 | 9 | 11 | 28852 | 10 | |||
153189 | 244353 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005598.6806 | 2110351.942 | 37.7749407940225 | -122.424102100187 | (37.7749407940225, -122.424102100187) | 7 | 9 | 11 | 28852 | 10 | |||
154989 | 244465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | 7 | 9 | 11 | 28852 | 10 | |||
157220 | 142251 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 471 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005162.3875 | 2110758.8534 | 37.7760334306508 | -122.425640299516 | (37.7760334306508, -122.425640299516) | 7 | 9 | 11 | 28852 | 10 | |||
157796 | 244256 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | 7 | 9 | 11 | 28852 | 10 | |||
159379 | 92019 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 52167 | 6008096 | 2112840 | 37.7819130903868 | -122.415639514466 | (37.7819130903868, -122.415639514466) | 7 | 10 | 9 | 28852 | 36 | |||
161873 | 246555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.7728152903163 | -122.423623602744 | (37.7728152903163, -122.423623602744) | 7 | 9 | 11 | 28852 | 10 | |||
164111 | 244308 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005570.3518 | 2110556.8538 | 37.7755018326332 | -122.424214672145 | (37.7755018326332, -122.424214672145) | 7 | 9 | 11 | 28852 | 10 |
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) );