trees
835 rows where qSpecies_id = 122 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
| 1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
| 2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
| 6630 | 30591 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34560 | |||||||||||||
| 9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
| 13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 14833 | 20055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 14981 | 20060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
| 1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 4487 | 259159 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 5685 | 245867 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.7751980841556 | -122.426098447818 | (37.7751980841556, -122.426098447818) | 7 | 9 | 11 | 28852 | 10 | |||
| 15560 | 261375 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | 7 | 9 | 11 | 28852 | 10 | ||||
| 16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 | |||
| 25315 | 33658 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 575 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37746 | 6004659.15076187 | 2110673.58419475 | 37.7757708537128 | -122.427375053318 | (37.7757708537128, -122.427375053318) | 7 | 9 | 11 | 28852 | 10 | |||
| 27101 | 52597 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 421@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2006 12:00:00 AM | Permit Number 48691 | 6005029.01915461 | 2110416.12997637 | 37.7750848587198 | -122.426077252438 | (37.7750848587198, -122.426077252438) | 7 | 9 | 11 | 28852 | 10 | ||
| 33995 | 245838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | 7 | 9 | 11 | 28852 | 10 | |||
| 40042 | 220092 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 24 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006394.36568 | 2110096.52086 | 37.774284361671 | -122.421331508756 | (37.774284361671, -122.421331508756) | 7 | 9 | 11 | 28852 | 10 | |||
| 55154 | 220686 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004903.16789 | 2110400.70337 | 37.7750353872943 | -122.426511501216 | (37.7750353872943, -122.426511501216) | 7 | 9 | 11 | 28852 | 10 | |||
| 60882 | 61342 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | 7 | 9 | 11 | 28852 | 10 | ||
| 62359 | 61344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.427218716009 | (37.7748381087345, -122.427218716009) | 7 | 9 | 11 | 28852 | 10 | ||
| 68287 | 245868 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 415 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005026.3603 | 2110433.2652 | 37.7751317575952 | -122.426087670118 | (37.7751317575952, -122.426087670118) | 7 | 9 | 11 | 28852 | 10 | |||
| 75189 | 245839 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.7753359789868 | -122.4261291969 | (37.7753359789868, -122.4261291969) | 7 | 9 | 11 | 28852 | 10 | |||
| 78673 | 51542 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50569 | 6005029.52693365 | 2110412.24682315 | 37.7750742252257 | -122.42607521942 | (37.7750742252257, -122.42607521942) | 7 | 9 | 11 | 28852 | 10 | ||
| 81881 | 33643 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 473 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37737 | 6005146.14820368 | 2110741.54826683 | 37.7759849973486 | -122.425695243602 | (37.7759849973486, -122.425695243602) | 7 | 9 | 11 | 28852 | 10 | |||
| 88289 | 220687 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004894.47532 | 2110399.44382 | 37.7750314374717 | -122.426541481018 | (37.7750314374717, -122.426541481018) | 7 | 9 | 11 | 28852 | 10 | |||
| 92759 | 52598 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | 7 | 9 | 11 | 28852 | 10 | |||
| 99912 | 220688 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | 7 | 9 | 11 | 28852 | 10 | |||
| 103337 | 69125 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 447 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33148 | 6005264.64007943 | 2110758.08466494 | 37.7760370972093 | -122.425286525812 | (37.7760370972093, -122.425286525812) | 7 | 9 | 11 | 28852 | 10 | ||
| 116433 | 142264 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.7758095850789 | -122.427435282317 | (37.7758095850789, -122.427435282317) | 7 | 9 | 11 | 28852 | 10 | |||
| 120775 | 142261 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 575 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004683.1776 | 2110693.6136 | 37.7758272084051 | -122.427293365492 | (37.7758272084051, -122.427293365492) | 7 | 9 | 11 | 28852 | 10 | |||
| 126725 | 61125 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 476 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 20976 | 6004690.15549132 | 2110384.59589639 | 37.7749791159526 | -122.427247210171 | (37.7749791159526, -122.427247210171) | 7 | 9 | 11 | 28852 | 10 | ||
| 128227 | 33633 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 282 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | Permit Number 37729 | 6006046.09364695 | 2110919.64612747 | 37.7765248233176 | -122.422594750669 | (37.7765248233176, -122.422594750669) | 7 | 9 | 11 | 28852 | 10 | ||
| 151287 | 51453 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 427 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47771 | 6004926.82550892 | 2110358.25622266 | 37.7749201751389 | -122.426426641342 | (37.7749201751389, -122.426426641342) | 7 | 9 | 11 | 28852 | 10 | |||
| 155053 | 220683 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 364 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004832.89357 | 2109879.94078 | 37.7736015271323 | -122.426717502624 | (37.7736015271323, -122.426717502624) | 7 | 9 | 11 | 28852 | 10 | |||
| 155174 | 245840 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 421 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005021.78 | 2110481.0306 | 37.775262650872 | -122.426106915566 | (37.775262650872, -122.426106915566) | 7 | 9 | 11 | 28852 | 10 | |||
| 158170 | 220685 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 452 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004772.24556 | 2110355.93232 | 37.7749050548484 | -122.426961200922 | (37.7749050548484, -122.426961200922) | 7 | 9 | 11 | 28852 | 10 | |||
| 160201 | 124751 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004689.62752 | 2110692.77739 | 37.7758252771447 | -122.427270993988 | (37.7758252771447, -122.427270993988) | 7 | 9 | 11 | 28852 | 10 | |||
| 175721 | 220684 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 452 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004755.35153 | 2110353.8827 | 37.7748984718146 | -122.427019494961 | (37.7748984718146, -122.427019494961) | 7 | 9 | 11 | 28852 | 10 | |||
| 187603 | 61341 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1985 12:00:00 AM | Permit Number 22558 | 6004883.03697194 | 2110411.47227967 | 37.7750638180483 | -122.426581905478 | (37.7750638180483, -122.426581905478) | 7 | 9 | 11 | 28852 | 10 | ||
| 189601 | 61340 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 441 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21245 | 6004862.65889815 | 2110356.13037945 | 37.7749107106258 | -122.426648455983 | (37.7749107106258, -122.426648455983) | 7 | 9 | 11 | 28852 | 10 | ||
| 40817 | 120111 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6004952 | 2108176 | 37.7689296510264 | -122.426184162815 | (37.7689296510264, -122.426184162815) | 8 | 4 | 5 | 28853 | 19 | |||
| 52115 | 220667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1337 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007176.02734 | 2107716.44116 | 37.7677932655629 | -122.418458791748 | (37.7677932655629, -122.418458791748) | 8 | 4 | 7 | 28853 | 19 | |||
| 191071 | 49975 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1337@ 14th Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/2003 12:00:00 AM | Permit Number 46726 | 6007190.27597203 | 2107705.69793456 | 37.7677645693117 | -122.418408745471 | (37.7677645693117, -122.418408745471) | 8 | 4 | 7 | 28853 | 19 | ||
| 111975 | 102846 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.7864225266356 | -122.394412832193 | (37.7864225266356, -122.394412832193) | 6 | 2 | 9 | 28855 | 6 | |||
| 164166 | 102849 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 31 Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
| 5666 | 81675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
| 7242 | 83227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.397163015669 | (37.7601232913798, -122.397163015669) | 10 | 3 | 8 | 28856 | 29 | |||
| 12288 | 199070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1130 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | 6013384.89381 | 2101721.18884 | 37.7516791861622 | -122.3965626049 | (37.7516791861622, -122.3965626049) | 10 | 3 | 8 | 28856 | 29 | ||||
| 13307 | 37952 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.7639157629311 | -122.396754475262 | (37.7639157629311, -122.396754475262) | 14 | 3 | 8 | 28856 | 29 | ||
| 13458 | 37949 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.397224649796 | (37.7586622221997, -122.397224649796) | 10 | 3 | 8 | 28856 | 29 | |
| 17915 | 35351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) | 10 | 3 | 8 | 28856 | 29 |
| 19224 | 261621 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1821 25th St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
| 19563 | 261622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1281x Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012916 | 2101714 | 37.7516333407735 | -122.398183607514 | (37.7516333407735, -122.398183607514) | 10 | 3 | 8 | 28856 | 29 | ||||
| 22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
| 23190 | 188515 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1401 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014455.23285 | 2101981.54762 | 37.7524535851846 | -122.392879417078 | (37.7524535851846, -122.392879417078) | 10 | 3 | 8 | 28856 | 1 | ||||
| 32263 | 67530 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.7660886653923 | -122.394807417822 | (37.7660886653923, -122.394807417822) | 14 | 3 | 8 | 28856 | 20 | |
| 34409 | 188513 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.394797995654 | (37.7659112417232, -122.394797995654) | 14 | 3 | 8 | 28856 | 20 | |||
| 41138 | 188519 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1451 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012046.50101 | 2101636.39558 | 37.7513717861857 | -122.401185012303 | (37.7513717861857, -122.401185012303) | 10 | 3 | 8 | 28856 | 29 | ||||
| 41465 | 67531 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.7658520487611 | -122.394795132512 | (37.7658520487611, -122.394795132512) | 14 | 3 | 8 | 28856 | 20 | ||
| 59364 | 188514 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013990.92762 | 2106981.76261 | 37.7661572890446 | -122.394835230264 | (37.7661572890446, -122.394835230264) | 14 | 3 | 8 | 28856 | 20 | |||
| 66532 | 67603 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216 | (37.7642517131045, -122.39677434216) | 14 | 3 | 8 | 28856 | 29 | ||
| 67998 | 67547 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.7555368181877 | -122.401581480218 | (37.7555368181877, -122.401581480218) | 10 | 3 | 8 | 28856 | 29 | |
| 69704 | 188516 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1506 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6014137.77003 | 2102020.80679 | 37.7525437439982 | -122.393980012793 | (37.7525437439982, -122.393980012793) | 10 | 3 | 8 | 28856 | 29 | |||
| 90686 | 188520 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | 10 | 3 | 8 | 28856 | 29 | |||
| 115064 | 188512 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 41 | Front Yard : Yard | Tree | Private 2 | 5 | 6014229.23402 | 2106696.64866 | 37.7653876762377 | -122.393991007905 | (37.7653876762377, -122.393991007905) | 14 | 3 | 8 | 28856 | 20 | ||||
| 119130 | 188521 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013271.44792 | 2104826.12778 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | 10 | 3 | 8 | 28856 | 29 | |||
| 126712 | 67589 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1005 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31156 | 6015546.93269222 | 2104381.58378925 | 37.7591041527051 | -122.389271681432 | (37.7591041527051, -122.389271681432) | 10 | 3 | 8 | 28856 | 29 | ||
| 134490 | 67563 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1067 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31115 | 6011664.16143038 | 2103412.99241656 | 37.7562285940169 | -122.402632116673 | (37.7562285940169, -122.402632116673) | 10 | 3 | 8 | 28856 | 29 | ||
| 135408 | 188518 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | 10 | 3 | 8 | 28856 | 29 | |||
| 146577 | 45337 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1239 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | 14 | 3 | 8 | 28856 | 29 | ||
| 149308 | 188517 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2000 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012457.67401 | 2102853.63518 | 37.7547369917341 | -122.399848584652 | (37.7547369917341, -122.399848584652) | 10 | 3 | 8 | 28856 | 29 | |||
| 150711 | 44091 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 807 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2000 12:00:00 AM | 6 | Permit Number 43606 | 6011323.91393 | 2104520.92035 | 37.7592517161218 | -122.40388677626 | (37.7592517161218, -122.40388677626) | 10 | 3 | 8 | 28856 | 29 | ||
| 166756 | 67583 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1081 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31148 | 6011670.33317 | 2103332.09659 | 37.7560068164771 | -122.402605084052 | (37.7560068164771, -122.402605084052) | 10 | 3 | 8 | 28856 | 29 | |
| 179587 | 35336 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2311 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2005 12:00:00 AM | 1 | Permit Number 48271 | 6010839.4517 | 2105063.96093 | 37.7607157062843 | -122.405600536935 | (37.7607157062843, -122.405600536935) | 10 | 3 | 8 | 28856 | 29 | |
| 186914 | 67491 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1053 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 11 | Permit Number 31016 | 6011662.71218 | 2103457.28078 | 37.7563501191849 | -122.402640243074 | (37.7563501191849, -122.402640243074) | 10 | 3 | 8 | 28856 | 29 | |
| 11831 | 66789 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.8005250955758 | -122.42292350049 | (37.8005250955758, -122.42292350049) | 13 | 9 | 1 | 28858 | 32 |
| 15666 | 44745 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 8 | Permit Number 43862 | 6006829.6851 | 2117719.85237 | 37.7952406976494 | -122.420366856354 | (37.7952406976494, -122.420366856354) | 13 | 9 | 10 | 28858 | 32 | ||
| 25803 | 35250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.8006015626823 | -122.42238315977 | (37.8006015626823, -122.42238315977) | 13 | 9 | 1 | 28858 | 32 | |
| 34736 | 35252 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.422525509838 | (37.8005900423666, -122.422525509838) | 13 | 9 | 1 | 28858 | 32 | |
| 35015 | 50381 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 6 | 3x3 | Permit Number 47040 | 6006481.85746 | 2119759.67415 | 37.8008219271496 | -122.421715351995 | (37.8008219271496, -122.421715351995) | 13 | 9 | 1 | 28858 | 32 | |
| 64202 | 253615 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221 | 2118816 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | 13 | 9 | 10 | 28858 | 32 | ||
| 68255 | 42696 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | 5 | 1 | 10 | 28858 | 32 | |
| 69468 | 124758 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.7942702662113 | -122.419903713582 | (37.7942702662113, -122.419903713582) | 13 | 9 | 10 | 28858 | 32 | |||
| 72507 | 35266 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.422306489847 | (37.798273260158, -122.422306489847) | 13 | 9 | 10 | 28858 | 32 |
| 91842 | 50382 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 4 | Permit Number 47040 | 6006491.715 | 2119759.4717 | 37.8008219271374 | -122.421681226333 | (37.8008219271374, -122.421681226333) | 13 | 9 | 1 | 28858 | 32 | ||
| 103175 | 35258 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.423172956092 | (37.8015923223752, -122.423172956092) | 5 | 9 | 1 | 28858 | 32 | |
| 112476 | 38501 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.7974092298161 | -122.420467894474 | (37.7974092298161, -122.420467894474) | 13 | 9 | 10 | 28858 | 32 | ||
| 137852 | 35265 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.7980573523528 | -122.422285851072 | (37.7980573523528, -122.422285851072) | 13 | 9 | 10 | 28858 | 32 | |
| 138647 | 44744 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2001 12:00:00 AM | 6 | Permit Number 43862 | 6006848.33301 | 2117722.6808 | 37.7952495146165 | -122.420302532344 | (37.7952495146165, -122.420302532344) | 13 | 9 | 10 | 28858 | 32 | ||
| 144059 | 66784 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 20 Culebra Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1992 12:00:00 AM | Permit Number 30056 | 6006381.97640479 | 2120210.98917161 | 37.8020554906142 | -122.422093063103 | (37.8020554906142, -122.422093063103) | 5 | 9 | 1 | 28858 | 32 | ||
| 175021 | 42685 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | 5 | 9 | 1 | 28858 | 32 |
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) );