trees
2,365 rows where qSpecies_id = 31 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172603 | 215549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994024.47246 | 2096717.64037 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | 9 | 8 | 4 | 59 | 40 | |||
| 75740 | 215550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | 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 | |||
| 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 | |||
| 117216 | 215529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 14 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994038.78637 | 2097743.43372 | 37.7396616220783 | -122.46317486995 | (37.7396616220783, -122.46317486995) | 1 | 8 | 4 | 59 | 40 | |||
| 162379 | 215509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 265 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994040.68753 | 2096338.79291 | 37.7358049370452 | -122.463066408082 | (37.7358049370452, -122.463066408082) | 9 | 8 | 4 | 59 | 40 | |||
| 156899 | 215487 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 25 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994042.19305 | 2097679.65263 | 37.7394866913615 | -122.46315846449 | (37.7394866913615, -122.46315846449) | 1 | 8 | 4 | 59 | 40 | |||
| 155254 | 215551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 212 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994048.13405 | 2096632.68749 | 37.7366123276804 | -122.463061979834 | (37.7366123276804, -122.463061979834) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 126898 | 215552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994058.81672 | 2096590.61886 | 37.7364974330117 | -122.463021994195 | (37.7364974330117, -122.463021994195) | 9 | 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 | |||
| 169600 | 215560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994063.02887 | 2096405.49286 | 37.7359893655189 | -122.462994003686 | (37.7359893655189, -122.462994003686) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 122274 | 215553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 224 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994066.55371 | 2096555.13843 | 37.736400458215 | -122.462992670901 | (37.736400458215, -122.462992670901) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 178456 | 215554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 224 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994072.66196 | 2096533.89593 | 37.7363424834197 | -122.462970011551 | (37.7363424834197, -122.462970011551) | 9 | 8 | 4 | 59 | 40 | |||
| 117696 | 215508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 261 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994073.52001 | 2096368.39822 | 37.7358881171279 | -122.462955041436 | (37.7358881171279, -122.462955041436) | 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 | |||
| 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 | |||
| 89450 | 215555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994079.01038 | 2096505.73845 | 37.7362655356317 | -122.462946020337 | (37.7362655356317, -122.462946020337) | 9 | 8 | 4 | 59 | 40 | |||
| 137860 | 215557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994081.97838 | 2096463.44747 | 37.7361495860356 | -122.462932691498 | (37.7361495860356, -122.462932691498) | 9 | 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 | |||
| 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 | |||
| 99531 | 215507 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 255 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994095.64493 | 2096399.41615 | 37.7359745590736 | -122.462880797029 | (37.7359745590736, -122.462880797029) | 9 | 8 | 4 | 59 | 40 | |||
| 180386 | 215502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 225 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994102.83883 | 2096543.31026 | 37.7363700710175 | -122.462866361103 | (37.7363700710175, -122.462866361103) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 163125 | 215506 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 255 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994105.35353 | 2096421.48762 | 37.7360357210632 | -122.462848831512 | (37.7360357210632, -122.462848831512) | 9 | 8 | 4 | 59 | 40 | |||
| 68728 | 215503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 233 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994106.38436 | 2096527.49502 | 37.7363268505023 | -122.462852955799 | (37.7363268505023, -122.462852955799) | 9 | 8 | 4 | 59 | 40 | |||
| 190436 | 215505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994112.73436 | 2096460.53675 | 37.7361433654214 | -122.462826145227 | (37.7361433654214, -122.462826145227) | 9 | 8 | 4 | 59 | 40 | |||
| 159643 | 215504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 235 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994113.80383 | 2096483.08652 | 37.7362053431037 | -122.462824083076 | (37.7362053431037, -122.462824083076) | 9 | 8 | 4 | 59 | 40 | |||
| 121544 | 215482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994118.54253 | 2097814.90929 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) | 1 | 8 | 4 | 59 | 40 | |||
| 175536 | 215516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 88 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994119.69741 | 2093345.38089 | 37.7275903136211 | -122.462576174158 | (37.7275903136211, -122.462576174158) | 9 | 8 | 4 | 59 | 40 | |||
| 175856 | 215481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.7399367588722 | -122.462836916405 | (37.7399367588722, -122.462836916405) | 1 | 8 | 4 | 59 | 40 | |||
| 67660 | 123533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3 05th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5994221.75726 | 2115563.21138 | 37.7886006193808 | -122.463835340542 | (37.7886006193808, -122.463835340542) | 11 | 6 | 1 | 54 | 11 | |||
| 121783 | 96758 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 54 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2014 12:00:00 AM | 24 | 4x4 | Permit Number 771133 | 5994277.34482 | 2115214.04583 | 37.7876451092051 | -122.463617666172 | (37.7876451092051, -122.463617666172) | 11 | 6 | 1 | 54 | 11 | |
| 12506 | 105953 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | 11 | 6 | 1 | 54 | 11 | ||
| 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 | |||
| 184052 | 123587 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 62 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994280.07322 | 2115179.97331 | 37.7875517125633 | -122.463605752716 | (37.7875517125633, -122.463605752716) | 11 | 6 | 1 | 54 | 11 | |||
| 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 | ||
| 144801 | 56524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 623 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5994686.99201 | 2111263.70978 | 37.776822144368 | -122.461913814497 | (37.776822144368, -122.461913814497) | 11 | 6 | 2 | 54 | 11 | ||||
| 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 | |||
| 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 | |||
| 145175 | 113444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 742 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994761.5711 | 2110535.58365 | 37.7748271966325 | -122.461603021673 | (37.7748271966325, -122.461603021673) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 96419 | 81863 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.7293018063197 | -122.459920577502 | (37.7293018063197, -122.459920577502) | 9 | 7 | 4 | 28861 | 40 | ||
| 37815 | 36939 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.7864999276851 | -122.461372345087 | (37.7864999276851, -122.461372345087) | 11 | 6 | 1 | 54 | 11 | |
| 81332 | 52332 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.459292150941 | (37.7353714395789, -122.459292150941) | 9 | 7 | 4 | 59 | 40 | ||||
| 121132 | 19301 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5995247.10654 | 2111496.409 | 37.7774933045144 | -122.459993084378 | (37.7774933045144, -122.459993084378) | 11 | 6 | 2 | 54 | 11 | |||
| 109904 | 40800 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.7113228744096 | -122.458004690935 | (37.7113228744096, -122.458004690935) | 9 | 8 | 6 | 28861 | 24 | |||
| 64264 | 123690 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 36 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995350.47696 | 2113583.46561 | 37.7832297501219 | -122.459786707236 | (37.7832297501219, -122.459786707236) | 11 | 6 | 2 | 54 | 11 | |||
| 60336 | 123691 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 35 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995371.26757 | 2113529.88581 | 37.7830838299438 | -122.459710898388 | (37.7830838299438, -122.459710898388) | 11 | 6 | 2 | 54 | 11 | |||
| 105562 | 123689 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 32 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995378.06567 | 2113584.47155 | 37.7832340986803 | -122.459691334885 | (37.7832340986803, -122.459691334885) | 11 | 6 | 2 | 54 | 11 | |||
| 178283 | 123688 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 26 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995407.44637 | 2113586.67183 | 37.7832418295416 | -122.459589849527 | (37.7832418295416, -122.459589849527) | 11 | 6 | 2 | 54 | 11 | |||
| 19934 | 123687 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 24 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995428.99259 | 2113586.04452 | 37.7832413460359 | -122.459515263281 | (37.7832413460359, -122.459515263281) | 11 | 6 | 2 | 54 | 11 | |||
| 177023 | 123692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 11 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995433.73143 | 2113533.85695 | 37.7830983254289 | -122.459495088037 | (37.7830983254289, -122.459495088037) | 11 | 6 | 2 | 54 | 11 | |||
| 51696 | 123686 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 14 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995454.47999 | 2113587.97447 | 37.7832481106401 | -122.459427227483 | (37.7832481106401, -122.459427227483) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 2661 | 123693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995461.17658 | 2113536.44974 | 37.7831070225625 | -122.459400327451 | (37.7831070225625, -122.459400327451) | 11 | 6 | 2 | 54 | 11 | |||
| 179512 | 123685 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 8 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995474.7934 | 2113587.5491 | 37.7832481106245 | -122.459356920862 | (37.7832481106245, -122.459356920862) | 11 | 6 | 2 | 54 | 11 | |||
| 150176 | 123694 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 7 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995476.23138 | 2113538.07017 | 37.7831123374099 | -122.459348361697 | (37.7831123374099, -122.459348361697) | 11 | 6 | 2 | 54 | 11 | |||
| 73095 | 215524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80 Northwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995481.22092 | 2094239.13462 | 37.7301226615312 | -122.457934054513 | (37.7301226615312, -122.457934054513) | 9 | 7 | 4 | 28861 | 40 | |||
| 40679 | 123696 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995493.19231 | 2113537.8911 | 37.7831128208781 | -122.459289671188 | (37.7831128208781, -122.459289671188) | 11 | 6 | 2 | 54 | 11 | |||
| 44191 | 123695 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995508.22475 | 2113538.45627 | 37.7831152369297 | -122.459237706338 | (37.7831152369297, -122.459237706338) | 11 | 6 | 2 | 54 | 11 | |||
| 136193 | 124598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3999 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5995587.64928 | 2115135.34669 | 37.7875044349012 | -122.459078597634 | (37.7875044349012, -122.459078597634) | 11 | 6 | 1 | 54 | 31 | |||
| 73412 | 215570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | 9 | 7 | 4 | 59 | 40 | |||
| 158576 | 124680 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3885 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995618.99956 | 2115788.29783 | 37.7892990644884 | -122.459017428632 | (37.7892990644884, -122.459017428632) | 11 | 6 | 1 | 54 | 31 | |||
| 68142 | 43942 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3885 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2000 12:00:00 AM | 11 | Permit Number 43530 | 5995636.78457 | 2115791.89347 | 37.7893099594942 | -122.458956155447 | (37.7893099594942, -122.458956155447) | 11 | 6 | 1 | 54 | 31 | ||
| 54139 | 47103 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.7771583581843 | -122.457996229218 | (37.7771583581843, -122.457996229218) | 11 | 6 | 2 | 54 | 16 | ||
| 47670 | 1208 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3141 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5995992.87885 | 2086942.40616 | 37.7101169521706 | -122.455637985173 | (37.7101169521706, -122.455637985173) | 9 | 7 | 6 | 28861 | 25 | |||
| 54889 | 136976 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 340 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996232.2691 | 2114976.93638 | 37.7871065186035 | -122.456836895121 | (37.7871065186035, -122.456836895121) | 11 | 6 | 1 | 54 | 31 | |||
| 77700 | 136975 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 340 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996232.67992 | 2114967.11027 | 37.7870795623305 | -122.456834762835 | (37.7870795623305, -122.456834762835) | 11 | 6 | 1 | 54 | 31 | |||
| 185644 | 141076 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 189 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5996534.5761 | 2113062.8589 | 37.7818683255127 | -122.455652579934 | (37.7818683255127, -122.455652579934) | 11 | 6 | 1 | 54 | 31 | |||
| 55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
| 37218 | 256504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3579 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997147.04528 | 2116001.57364 | 37.7899723836566 | -122.453746006699 | (37.7899723836566, -122.453746006699) | 11 | 6 | 1 | 54 | 31 | |||||
| 139032 | 114306 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997219 | 2107398 | 37.7663533458689 | -122.452875791584 | (37.7663533458689, -122.452875791584) | 15 | 5 | 11 | 29492 | 9 | ||||
| 69043 | 74234 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 13 | 5997222.04614 | 2115031.53176 | 37.7873132070818 | -122.45341644603 | (37.7873132070818, -122.45341644603) | 11 | 6 | 1 | 54 | 31 | ||
| 66630 | 72449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.453348481559 | (37.7873175292136, -122.453348481559) | 11 | 6 | 1 | 54 | 31 | ||
| 192705 | 215518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997249.4841 | 2090499.44451 | 37.7199557889053 | -122.451551333026 | (37.7199557889053, -122.451551333026) | 9 | 8 | 6 | 28861 | 24 | |||
| 51187 | 97030 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997252 | 2090493 | 37.7199382378616 | -122.451542171872 | (37.7199382378616, -122.451542171872) | 9 | 8 | 6 | 28861 | 24 | |||
| 117784 | 242606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997274 | 2107360 | 37.7662521591899 | -122.45268281502 | (37.7662521591899, -122.45268281502) | 15 | 5 | 11 | 29492 | 9 | |||
| 165534 | 72448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3681 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1996 12:00:00 AM | 11 | 5997285.67318 | 2115040.09705 | 37.7873403720155 | -122.453196929609 | (37.7873403720155, -122.453196929609) | 11 | 6 | 1 | 54 | 31 | ||
| 64696 | 242448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997336.0067 | 2106240.14847 | 37.7631808847241 | -122.452387528971 | (37.7631808847241, -122.452387528971) | 15 | 5 | 11 | 29492 | 12 | |||
| 152997 | 215517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 164 Howth St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997515.64352 | 2090995.97654 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | 9 | 8 | 6 | 28861 | 24 | |||
| 15262 | 73760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997597.70095 | 2116065.74811 | 37.7901744154595 | -122.452191417426 | (37.7901744154595, -122.452191417426) | 11 | 6 | 1 | 54 | 31 | |||
| 42142 | 53259 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 210 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | 15 | Permit Number 6149 | 5997600.12702 | 2115607.00528 | 37.7889149689082 | -122.452149910107 | (37.7889149689082, -122.452149910107) | 11 | 6 | 1 | 54 | 31 | ||
| 12738 | 72412 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997617.1015 | 2116066.53919 | 37.7901776988858 | -122.452124350462 | (37.7901776988858, -122.452124350462) | 11 | 6 | 1 | 54 | 31 | |||
| 58093 | 48676 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | 15 | 5 | 11 | 29492 | 9 | ||
| 98618 | 242453 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 140 Belgrave Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 2ft | 5997900.49529 | 2104918.67096 | 37.7595847638524 | -122.450339895864 | (37.7595847638524, -122.450339895864) | 15 | 5 | 11 | 29492 | 12 | |||
| 158935 | 242449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 150 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997972.72284 | 2105963.31603 | 37.7624572299272 | -122.450165395921 | (37.7624572299272, -122.450165395921) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 159763 | 242451 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5998061.5561 | 2105942.80556 | 37.7624059964569 | -122.449856677554 | (37.7624059964569, -122.449856677554) | 15 | 5 | 11 | 29492 | 9 | |||
| 111191 | 87288 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096 | 2105951 | 37.7624304670172 | -122.449738139948 | (37.7624304670172, -122.449738139948) | 15 | 5 | 11 | 29492 | 9 | ||
| 131687 | 87287 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096 | 2105951 | 37.7624304670172 | -122.449738139948 | (37.7624304670172, -122.449738139948) | 15 | 5 | 11 | 29492 | 9 | ||
| 71954 | 68197 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 417 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 7 | Permit Number 31977 | 5998129.56207 | 2114980.61061 | 37.7872253685036 | -122.450272974611 | (37.7872253685036, -122.450272974611) | 11 | 6 | 1 | 54 | 31 | ||
| 43928 | 62667 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 438 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50321 | 5998175.41267 | 2114969.52536 | 37.7871975551779 | -122.45011354281 | (37.7871975551779, -122.45011354281) | 13 | 6 | 1 | 54 | 31 | |
| 24576 | 248409 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 120 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998272.8596 | 2108056.6857 | 37.7682222644528 | -122.449278164682 | (37.7682222644528, -122.449278164682) | 15 | 5 | 11 | 29492 | 9 | |||
| 40722 | 94046 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 42 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 53454 | 5998445 | 2106022 | 37.7626453762737 | -122.44853619655 | (37.7626453762737, -122.44853619655) | 15 | 5 | 11 | 29492 | 9 | ||||
| 169881 | 52081 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.7637380891551 | -122.448274099423 | (37.7637380891551, -122.448274099423) | 15 | 5 | 11 | 29492 | 9 | |||
| 145602 | 242455 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 466 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998563.817 | 2106475.5967 | 37.7638976317819 | -122.448157915782 | (37.7638976317819, -122.448157915782) | 15 | 5 | 11 | 29492 | 9 |
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) );