trees
11,761 rows where qSpecies_id = 17 sorted by Longitude descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144628 | 58178 | Permitted Site 7 | Tree(s) :: 17 | 1225 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1978 12:00:00 AM | Permit Number 17165 | 5980845.45874958 | 2106718.95428183 | 37.7635369974083 | -122.509457359298 | (37.7635369974083, -122.509457359298) | 1 | 8 | 3 | 56 | 35 | |||
20492 | 108957 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
58107 | 108955 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
91190 | 108956 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
94765 | 108953 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
129946 | 108954 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
178293 | 66721 | Permitted Site 7 | Tree(s) :: 17 | 1444 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | Permit Number 29963 | 5980948.12244708 | 2105220.40445494 | 37.7594284644995 | -122.508991005813 | (37.7594284644995, -122.508991005813) | 1 | 8 | 3 | 56 | 35 | |||
11759 | 66722 | Permitted Site 7 | Tree(s) :: 17 | 1448 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | Permit Number 29964 | 5980949.03538883 | 2105193.86750643 | 37.7593556554787 | -122.508985878013 | (37.7593556554787, -122.508985878013) | 1 | 8 | 3 | 56 | 35 | |||
168628 | 30893 | Permitted Site 7 | Tree(s) :: 17 | 762 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34720 | 5981083.10854015 | 2110529.64234403 | 37.7740140460133 | -122.508918381294 | (37.7740140460133, -122.508918381294) | 11 | 6 | 2 | 55 | 26 | ||||
127150 | 105337 | Undocumented 4 | Tree(s) :: 17 | 4701X LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x4 | 5981020 | 2106919 | 37.7640965553617 | -122.508868541389 | (37.7640965553617, -122.508868541389) | 11 | 8 | 3 | 55 | 35 | ||||
167616 | 54783 | Permitted Site 7 | Tree(s) :: 17 | 854 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1972 12:00:00 AM | Permit Number 10632 | 5981105.51814859 | 2109901.96843925 | 37.7722919587991 | -122.508794252455 | (37.7722919587991, -122.508794252455) | 11 | 6 | 2 | 55 | 26 | |||
166558 | 59770 | Permitted Site 7 | Tree(s) :: 17 | 133 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1981 12:00:00 AM | Permit Number 19213 | 5981239.37864566 | 2112931.41031893 | 37.7806178019191 | -122.508556162178 | (37.7806178019191, -122.508556162178) | 11 | 6 | 2 | 55 | 26 | |||
68782 | 59690 | Permitted Site 7 | Tree(s) :: 17 | 128 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19117 | 5981244.342209 | 2112983.63407711 | 37.7807614853819 | -122.508542869186 | (37.7807614853819, -122.508542869186) | 11 | 6 | 2 | 55 | 15 | |||
124921 | 183337 | DPW Maintained 1 | Tree(s) :: 17 | 4709 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5981120.829 | 2106873.2612 | 37.7639769129553 | -122.508516413825 | (37.7639769129553, -122.508516413825) | 1 | 8 | 3 | 56 | 35 | |||
85997 | 111996 | Significant Tree 6 | Tree(s) :: 17 | 501 Point Lobos Ave | Front Yard : Yard | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775626 | 5981249.6 | 2112592.5 | 37.7796878572283 | -122.508495636007 | (37.7796878572283, -122.508495636007) | 11 | 6 | 2 | 55 | 26 | ||
147854 | 64462 | Permitted Site 7 | Tree(s) :: 17 | 1738 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1988 12:00:00 AM | Permit Number 25329 | 5981049.52002107 | 2103228.35878357 | 37.7539648530856 | -122.508492449778 | (37.7539648530856, -122.508492449778) | 1 | 8 | 3 | 56 | 35 | |||
9527 | 184625 | DPW Maintained 1 | Tree(s) :: 17 | 1762 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2017 12:00:00 AM | 3 | 4x4 | Permit Number 778834 | 5981059.357 | 2103059.0208 | 37.7535004788576 | -122.508445862177 | (37.7535004788576, -122.508445862177) | 1 | 8 | 3 | 56 | 35 | |
100967 | 59688 | Permitted Site 7 | Tree(s) :: 17 | 121 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19115 | 5981305.55363342 | 2112933.90216575 | 37.7806285438096 | -122.508327420378 | (37.7806285438096, -122.508327420378) | 11 | 6 | 2 | 55 | 26 | |||
162007 | 56081 | Permitted Site 7 | Tree(s) :: 17 | 436 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12179 | 5981319.11647903 | 2112553.81490181 | 37.7795857362334 | -122.508252280354 | (37.7795857362334, -122.508252280354) | 11 | 6 | 2 | 55 | 26 | |||
118790 | 67686 | Permitted Site 7 | Tree(s) :: 17 | 1339 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | Permit Number 31291 | 5981181.94376706 | 2105952.49861044 | 37.7614523660953 | -122.508236691393 | (37.7614523660953, -122.508236691393) | 1 | 8 | 3 | 56 | 35 | |||
43763 | 183351 | DPW Maintained 1 | Tree(s) :: 17 | 1214 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5981199.8295 | 2106780.9272 | 37.7637280462203 | -122.508236325462 | (37.7637280462203, -122.508236325462) | 1 | 8 | 3 | 56 | 35 | |||
161800 | 56083 | Permitted Site 7 | Tree(s) :: 17 | 741 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1992 12:00:00 AM | Permit Number 30425 | 5981335.16255903 | 2110682.62925034 | 37.7744489582315 | -122.508057855787 | (37.7744489582315, -122.508057855787) | 11 | 6 | 2 | 55 | 26 | |||
62894 | 56090 | Permitted Site 7 | Tree(s) :: 17 | 761 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12188 | 5981339.91382434 | 2110552.04113046 | 37.7740906815722 | -122.508031726591 | (37.7740906815722, -122.508031726591) | 11 | 6 | 2 | 55 | 26 | |||
12571 | 261236 | Permitted Site 7 | Tree(s) :: 17 | 1966 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784901 | 5981171.78192 | 2101687.9139 | 37.7497424323589 | -122.507955330593 | (37.7497424323589, -122.507955330593) | 1 | 8 | 3 | 29491 | 35 | |
151049 | 56078 | Permitted Site 7 | Tree(s) :: 17 | 706 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1973 12:00:00 AM | Permit Number 12175 | 5981379.05102496 | 2110906.51972934 | 37.7750662816644 | -122.50792265909 | (37.7750662816644, -122.50792265909) | 11 | 6 | 2 | 55 | 26 | |||
146053 | 61900 | Permitted Site 7 | Tree(s) :: 17 | 867 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1985 12:00:00 AM | Permit Number 21943 | 5981366.38514908 | 2109833.22098099 | 37.7721185718465 | -122.507886803182 | (37.7721185718465, -122.507886803182) | 11 | 6 | 2 | 55 | 26 | |||
17829 | 106868 | Undocumented 4 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout | Tree | Private 2 | 5981193.7 | 2101737.6 | 37.7498801477899 | -122.507883225183 | (37.7498801477899, -122.507883225183) | 1 | 8 | 3 | 29491 | 35 | ||||||
9440 | 56089 | Permitted Site 7 | Tree(s) :: 17 | 756 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12187 | 5981390.92918714 | 2110580.04946016 | 37.7741705900693 | -122.507857337664 | (37.7741705900693, -122.507857337664) | 11 | 6 | 2 | 55 | 26 | |||
159291 | 54067 | Permitted Site 7 | Tree(s) :: 17 | 1637 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9790 | 5981251.61714201 | 2103927.27155082 | 37.7558957776852 | -122.507845425767 | (37.7558957776852, -122.507845425767) | 1 | 8 | 3 | 56 | 35 | |||
97119 | 54068 | Permitted Site 7 | Tree(s) :: 17 | 1643 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9791 | 5981252.96111373 | 2103888.20574043 | 37.7557885932785 | -122.507837878985 | (37.7557885932785, -122.507837878985) | 1 | 8 | 3 | 56 | 35 | |||
42982 | 56092 | Permitted Site 7 | Tree(s) :: 17 | 772 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1973 12:00:00 AM | Permit Number 12191 | 5981394.73019993 | 2110475.57894961 | 37.7738839686542 | -122.507836435135 | (37.7738839686542, -122.507836435135) | 11 | 6 | 2 | 55 | 26 | |||
142215 | 184898 | DPW Maintained 1 | Tree(s) :: 17 | 2000 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981206.6066 | 2101266.9977 | 37.7485887668624 | -122.50780367561 | (37.7485887668624, -122.50780367561) | 1 | 8 | 3 | 29491 | 35 | |||
93525 | 54074 | Permitted Site 7 | Tree(s) :: 17 | 1671 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | Permit Number 9797 | 5981259.23298317 | 2103705.89858469 | 37.7552883992367 | -122.507802660949 | (37.7552883992367, -122.507802660949) | 1 | 8 | 3 | 56 | 35 | |||
174405 | 184632 | DPW Maintained 1 | Tree(s) :: 17 | 1815 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981296.796 | 2102696.4914 | 37.752519066521 | -122.507597863232 | (37.752519066521, -122.507597863232) | 1 | 8 | 3 | 56 | 35 | |||
181215 | 67570 | Permitted Site 7 | Tree(s) :: 17 | 4624 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1992 12:00:00 AM | Permit Number 31124 | 5981426.53219043 | 2106254.71506567 | 37.7622965759839 | -122.507413199968 | (37.7622965759839, -122.507413199968) | 1 | 8 | 3 | 56 | 35 | |||
179214 | 57052 | Permitted Site 7 | Tree(s) :: 17 | 521 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | Permit Number 14316 | 5981589.02223488 | 2112200.66670301 | 37.7786319973673 | -122.507292369346 | (37.7786319973673, -122.507292369346) | 11 | 6 | 2 | 55 | 26 | |||
60299 | 57053 | Permitted Site 7 | Tree(s) :: 17 | 523 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | Permit Number 14317 | 5981589.51098722 | 2112187.23341084 | 37.7785951423029 | -122.507289681711 | (37.7785951423029, -122.507289681711) | 11 | 6 | 2 | 55 | 26 | |||
46138 | 106666 | Undocumented 4 | Tree(s) :: 17 | 1878 48TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981378.4 | 2102298.1 | 37.7514300033234 | -122.507286113612 | (37.7514300033234, -122.507286113612) | 1 | 8 | 3 | 56 | 35 | |||||
87744 | 184463 | DPW Maintained 1 | Tree(s) :: 17 | 2149 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981371.9257 | 2100438.3719 | 37.7463233314532 | -122.507170550739 | (37.7463233314532, -122.507170550739) | 1 | 8 | 3 | 29491 | 35 | |||
102784 | 54525 | Permitted Site 7 | Tree(s) :: 17 | 4516 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | Permit Number 10319 | 5981602.01155743 | 2111000.2670884 | 37.7753368186476 | -122.507158359451 | (37.7753368186476, -122.507158359451) | 11 | 6 | 2 | 55 | 26 | |||
32725 | 106972 | Significant Tree 6 | Tree(s) :: 17 | 464 46TH AVE | 3 | Front Yard : Yard | Tree | Private 2 | 08/07/2014 12:00:00 AM | Permit Number 773827 | 5981646.2 | 2112608 | 37.7797537818913 | -122.507124798545 | (37.7797537818913, -122.507124798545) | 11 | 6 | 2 | 55 | 26 | |||
29684 | 57051 | Permitted Site 7 | Tree(s) :: 17 | 514 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | Permit Number 14315 | 5981639.52159463 | 2112242.85726003 | 37.7787508145235 | -122.507120806359 | (37.7787508145235, -122.507120806359) | 11 | 6 | 2 | 55 | 26 | |||
20760 | 184403 | DPW Maintained 1 | Tree(s) :: 17 | 2082 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981400.5223 | 2100912.6701 | 37.7476273056723 | -122.507106847904 | (37.7476273056723, -122.507106847904) | 1 | 8 | 3 | 29491 | 35 | |||
58038 | 85387 | DPW Maintained 1 | Tree(s) :: 17 | 2082 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | 3 | Permit Number 49658 | 5981401.1992 | 2100902.179 | 37.7475985399209 | -122.507103729118 | (37.7475985399209, -122.507103729118) | 1 | 8 | 3 | 29491 | 35 | ||
140707 | 184386 | DPW Maintained 1 | Tree(s) :: 17 | 2206 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981432.167 | 2100021.6921 | 37.7451827930944 | -122.506931344351 | (37.7451827930944, -122.506931344351) | 1 | 8 | 3 | 29491 | 35 | |||
148741 | 54695 | Permitted Site 7 | Tree(s) :: 17 | 666 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | Permit Number 10527 | 5981677.5279871 | 2111198.25359544 | 37.7758848788826 | -122.50691182431 | (37.7758848788826, -122.50691182431) | 11 | 6 | 2 | 55 | 26 | |||
93701 | 108947 | DPW Maintained 1 | Tree(s) :: 17 | 1575 47TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774852 | 5981531.9 | 2104370 | 37.7571278936884 | -122.506908971542 | (37.7571278936884, -122.506908971542) | 1 | 8 | 3 | 56 | 35 | |
80124 | 55177 | Permitted Site 7 | Tree(s) :: 17 | 1539 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1972 12:00:00 AM | Permit Number 11085 | 5981537.81640802 | 2104604.5408231 | 37.7577722243752 | -122.506905907557 | (37.7577722243752, -122.506905907557) | 1 | 8 | 3 | 56 | 35 | |||
171310 | 184369 | DPW Maintained 1 | Tree(s) :: 17 | 2246 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981440.3419 | 2099772.3553 | 37.7444986652432 | -122.506884586267 | (37.7444986652432, -122.506884586267) | 1 | 8 | 3 | 29491 | 35 | |||
122489 | 37094 | Permitted Site 7 | Tree(s) :: 17 | 1430 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2012 12:00:00 AM | Permit Number 769143 | 5981564.60244372 | 2105338.34211292 | 37.7597886105878 | -122.506867700504 | (37.7597886105878, -122.506867700504) | 1 | 8 | 3 | 56 | 35 | |||
191571 | 114546 | DPW Maintained 1 | Tree(s) :: 17 | 1623 47TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | 8 | 3x3 | Permit Number 776946 | 5981544 | 2104016 | 37.7561566229771 | -122.506840869024 | (37.7561566229771, -122.506840869024) | 1 | 8 | 3 | 56 | 35 | |
143303 | 184165 | DPW Maintained 1 | Tree(s) :: 17 | 1587 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5981553.7564 | 2104301.6861 | 37.7569416102721 | -122.506828318107 | (37.7569416102721, -122.506828318107) | 1 | 8 | 3 | 56 | 35 | |||
193051 | 66758 | Permitted Site 7 | Tree(s) :: 17 | 871 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1991 12:00:00 AM | Permit Number 30011 | 5981675.71173469 | 2109818.0130109 | 37.7720950354815 | -122.506815707649 | (37.7720950354815, -122.506815707649) | 11 | 6 | 2 | 55 | 26 | |||
112651 | 37117 | DPW Maintained 1 | Tree(s) :: 17 | 4542 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 3 | Permit Number 39708 | 5981604.0022 | 2106261.3364 | 37.7623252085322 | -122.506799899678 | (37.7623252085322, -122.506799899678) | 1 | 8 | 3 | 56 | 35 | |
30251 | 183155 | DPW Maintained 1 | Tree(s) :: 17 | 2322 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981458.7309 | 2099250.8498 | 37.7430678392852 | -122.506782328683 | (37.7430678392852, -122.506782328683) | 1 | 8 | 3 | 29491 | 35 | |||
71839 | 184185 | DPW Maintained 1 | Tree(s) :: 17 | 1651 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780218 | 5981567.9659 | 2103842.553 | 37.7556817980764 | -122.50674512418 | (37.7556817980764, -122.50674512418) | 1 | 8 | 3 | 56 | 35 | |
73969 | 37099 | DPW Maintained 1 | Tree(s) :: 17 | 1530 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 774502 | 5981587.98949699 | 2104658.53862904 | 37.7579234415311 | -122.506736396207 | (37.7579234415311, -122.506736396207) | 1 | 8 | 3 | 56 | 35 | |
162030 | 64602 | Permitted Site 7 | Tree(s) :: 17 | 1560 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1988 12:00:00 AM | Permit Number 25505 | 5981594.72512125 | 2104462.75137917 | 37.757386262152 | -122.506698580978 | (37.757386262152, -122.506698580978) | 1 | 8 | 3 | 56 | 35 | |||
122159 | 59687 | Permitted Site 7 | Tree(s) :: 17 | 18 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19113 | 5981808.86522212 | 2113023.99934667 | 37.7809055720971 | -122.506592939163 | (37.7809055720971, -122.506592939163) | 11 | 6 | 2 | 55 | 15 | |||
173181 | 59686 | Permitted Site 7 | Tree(s) :: 17 | 16 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19112 | 5981818.04797674 | 2113027.73665857 | 37.7809163743319 | -122.506561449311 | (37.7809163743319, -122.506561449311) | 11 | 6 | 2 | 55 | 15 | |||
115485 | 55832 | Permitted Site 7 | Tree(s) :: 17 | 5445 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | Permit Number 11881 | 5981805.62110307 | 2111636.81019559 | 37.7770965690305 | -122.50650125619 | (37.7770965690305, -122.50650125619) | 11 | 6 | 2 | 55 | 26 | |||
175768 | 184564 | DPW Maintained 1 | Tree(s) :: 17 | 4045 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780224 | 5981651.1237 | 2103482.1376 | 37.7546970960302 | -122.506430816504 | (37.7546970960302, -122.506430816504) | 1 | 8 | 3 | 56 | 35 | |
81128 | 55822 | Permitted Site 7 | Tree(s) :: 17 | 1766 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1973 12:00:00 AM | Permit Number 11870 | 5981642.38990968 | 2103064.44192141 | 37.7535497077257 | -122.506430045924 | (37.7535497077257, -122.506430045924) | 1 | 8 | 3 | 56 | 35 | |||
135701 | 102604 | Significant Tree 6 | Tree(s) :: 17 | 401 45th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2013 12:00:00 AM | Permit Number 769720 | 5981859.7 | 2112893.4 | 37.7805499779863 | -122.506407391963 | (37.7805499779863, -122.506407391963) | 11 | 6 | 2 | 55 | 26 | |||
7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 | ||||||
90294 | 59685 | Permitted Site 7 | Tree(s) :: 17 | 9 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1981 12:00:00 AM | Permit Number 19111 | 5981869.97905935 | 2113002.22649448 | 37.7808493885238 | -122.506379904979 | (37.7808493885238, -122.506379904979) | 11 | 6 | 2 | 55 | 26 | |||
131853 | 51086 | DPW Maintained 1 | Tree(s) :: 17 | 4526 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | 0 | Permit Number 769194 | 5981733 | 2106264 | 37.7623401174583 | -122.50635394981 | (37.7623401174583, -122.50635394981) | 1 | 8 | 3 | 56 | 35 | ||
115827 | 59947 | Permitted Site 7 | Tree(s) :: 17 | 539 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1981 12:00:00 AM | Permit Number 19421 | 5981902.93720095 | 2112090.82991088 | 37.7783489028792 | -122.506198288815 | (37.7783489028792, -122.506198288815) | 11 | 6 | 2 | 55 | 26 | |||
45338 | 61041 | Permitted Site 7 | Tree(s) :: 17 | 1275 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1983 12:00:00 AM | Permit Number 20865 | 5981785.66752955 | 2106419.61016337 | 37.7627704789217 | -122.50618333455 | (37.7627704789217, -122.50618333455) | 1 | 8 | 3 | 56 | 35 | |||
70869 | 68568 | Permitted Site 7 | Tree(s) :: 17 | 565 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | Permit Number 32458 | 5981909.48461528 | 2111916.20414692 | 37.7778698173833 | -122.506162687643 | (37.7778698173833, -122.506162687643) | 11 | 6 | 2 | 55 | 26 | |||
57784 | 58032 | Permitted Site 7 | Tree(s) :: 17 | 1226 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1977 12:00:00 AM | Permit Number 17001 | 5981826.77698713 | 2106737.06458385 | 37.7636445375869 | -122.506064692753 | (37.7636445375869, -122.506064692753) | 1 | 8 | 3 | 56 | 35 | |||
157565 | 65293 | Permitted Site 7 | Tree(s) :: 17 | 695 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1989 12:00:00 AM | Permit Number 28106 | 5981942.36946582 | 2111033.0981994 | 37.7754470035592 | -122.505983437587 | (37.7754470035592, -122.505983437587) | 11 | 6 | 2 | 55 | 26 | |||
23690 | 108209 | Permitted Site 7 | Tree(s) :: 17 | 524 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2014 12:00:00 AM | 3 | Permit Number 773704 | 5981973.19232 | 2112153.30127 | 37.7785245664452 | -122.505959887315 | (37.7785245664452, -122.505959887315) | 11 | 6 | 2 | 55 | 26 | ||
103380 | 106898 | Permitted Site 7 | Tree(s) :: 17 | 2738 GREAT HWY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778416 | 5981641.3 | 2096638.3 | 37.7359052479554 | -122.505957409506 | (37.7359052479554, -122.505957409506) | 1 | 8 | 3 | 29491 | 35 | |
160084 | 69010 | Permitted Site 7 | Tree(s) :: 17 | 1465 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1994 12:00:00 AM | Permit Number 33013 | 5981830.19076636 | 2105125.43358687 | 37.7592196611682 | -122.505933391825 | (37.7592196611682, -122.505933391825) | 1 | 8 | 3 | 56 | 35 | |||
172289 | 68566 | Permitted Site 7 | Tree(s) :: 17 | 765 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | Permit Number 32456 | 5981960.2279751 | 2110548.35930144 | 37.7741171035812 | -122.505885716149 | (37.7741171035812, -122.505885716149) | 11 | 6 | 2 | 55 | 26 | |||
35562 | 63915 | Permitted Site 7 | Tree(s) :: 17 | 2327 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1987 12:00:00 AM | Permit Number 24634 | 5981720.58287666 | 2099244.75828899 | 37.743066529793 | -122.505876479418 | (37.743066529793, -122.505876479418) | 1 | 8 | 3 | 29491 | 35 | |||
4623 | 106966 | Undocumented 4 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | 1 | 8 | 3 | 29491 | 35 | ||||||
13111 | 57916 | DPW Maintained 1 | Tree(s) :: 17 | 2226 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1977 12:00:00 AM | 7 | Permit Number 16874 | 5981746.2224 | 2099923.5924 | 37.7449319286698 | -122.505838142048 | (37.7449319286698, -122.505838142048) | 1 | 8 | 3 | 29491 | 35 | |
67516 | 57915 | Permitted Site 7 | Tree(s) :: 17 | 2222 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1977 12:00:00 AM | Permit Number 16873 | 5981747.46539374 | 2099952.79601376 | 37.7450121868229 | -122.505836008721 | (37.7450121868229, -122.505836008721) | 1 | 8 | 3 | 29491 | 35 | |||
19136 | 102260 | Undocumented 4 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.7613293147111 | -122.505832545781 | (37.7613293147111, -122.505832545781) | 1 | 8 | 3 | 56 | 35 | |||
188785 | 66147 | Permitted Site 7 | Tree(s) :: 17 | 2363 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1990 12:00:00 AM | Permit Number 29214 | 5981728.77718383 | 2099008.22301274 | 37.7424175518576 | -122.505830614119 | (37.7424175518576, -122.505830614119) | 1 | 8 | 3 | 29491 | 35 | |||
133965 | 67879 | DPW Maintained 1 | Tree(s) :: 17 | 2395 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1993 12:00:00 AM | 0 | Permit Number 31571 | 5981736.0610128 | 2098797.96942293 | 37.7418406824775 | -122.505789845634 | (37.7418406824775, -122.505789845634) | 1 | 8 | 3 | 29491 | 35 | ||
8193 | 79990 | DPW Maintained 1 | Tree(s) :: 17 | 3655 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981694.1032 | 2096684.9357 | 37.7360364047838 | -122.505778307285 | (37.7360364047838, -122.505778307285) | 1 | 8 | 3 | 29491 | 35 | |||
21116 | 65999 | Permitted Site 7 | Tree(s) :: 17 | 2350 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1990 12:00:00 AM | Permit Number 29033 | 5981778.01457275 | 2099088.86845604 | 37.7426418798163 | -122.505666345883 | (37.7426418798163, -122.505666345883) | 1 | 8 | 3 | 29491 | 35 | |||
107954 | 105206 | DPW Maintained 1 | Tree(s) :: 17 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774528 | 5981725.3 | 2096580 | 37.7357501162313 | -122.505662672753 | (37.7357501162313, -122.505662672753) | 1 | 8 | 3 | 29491 | 35 | ||
186051 | 107857 | Undocumented 4 | Tree(s) :: 17 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774528 | 5981725.3 | 2096580 | 37.7357501162313 | -122.505662672753 | (37.7357501162313, -122.505662672753) | 1 | 8 | 3 | 29491 | 35 | ||||
97206 | 58151 | Permitted Site 7 | Tree(s) :: 17 | 8045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1978 12:00:00 AM | Permit Number 17135 | 5982089.93927351 | 2112348.15750341 | 37.7790664555862 | -122.50557046999 | (37.7790664555862, -122.50557046999) | 11 | 6 | 2 | 55 | 26 | |||
99876 | 110204 | DPW Maintained 1 | Tree(s) :: 17 | 1570 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2015 12:00:00 AM | 3 | 3x3 | 5981926.8 | 2104412.1 | 37.7572667361687 | -122.505546399753 | (37.7572667361687, -122.505546399753) | 1 | 8 | 3 | 56 | 35 | ||
100184 | 59267 | DPW Maintained 1 | Tree(s) :: 17 | 4417 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1980 12:00:00 AM | 7 | Permit Number 18602 | 5982005.4942 | 2106221.0655 | 37.7622382706375 | -122.505408327781 | (37.7622382706375, -122.505408327781) | 1 | 8 | 3 | 56 | 35 | ||
169686 | 58059 | Permitted Site 7 | Tree(s) :: 17 | 465 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1977 12:00:00 AM | Permit Number 17028 | 5982194.09106997 | 2112651.2305521 | 37.7799047337804 | -122.505232640938 | (37.7799047337804, -122.505232640938) | 11 | 6 | 2 | 55 | 26 | |||
75345 | 183137 | DPW Maintained 1 | Tree(s) :: 17 | 3515 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5981958.3374 | 2099418.2679 | 37.7435569304689 | -122.505067258282 | (37.7435569304689, -122.505067258282) | 1 | 8 | 3 | 29491 | 35 | |||
26939 | 114032 | DPW Maintained 1 | Tree(s) :: 17 | 4345x LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778067 | 5982152 | 2106880 | 37.764056136262 | -122.504950459897 | (37.764056136262, -122.504950459897) | 1 | 8 | 3 | 56 | 35 | |
93058 | 93037 | Permitted Site 7 | Tree(s) :: 17 | 1220 45th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/14/2010 12:00:00 AM | Permit Number 53146 | 5982155.6 | 2106783.3 | 37.7637908375908 | -122.504930842514 | (37.7637908375908, -122.504930842514) | 1 | 8 | 3 | 56 | 35 | |||
52114 | 55810 | Permitted Site 7 | Tree(s) :: 17 | 1431 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | Permit Number 11857 | 5982132.57987767 | 2105357.65042574 | 37.7598750569605 | -122.504904810312 | (37.7598750569605, -122.504904810312) | 1 | 8 | 3 | 56 | 35 | |||
147071 | 55811 | DPW Maintained 1 | Tree(s) :: 17 | 1435 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | 6 | Permit Number 11858 | 5982133.47728316 | 2105331.56508435 | 37.7598034868382 | -122.504899773682 | (37.7598034868382, -122.504899773682) | 1 | 8 | 3 | 56 | 35 | ||
17077 | 70380 | DPW Maintained 1 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | 1 | 8 | 3 | 56 | 35 | |||
95999 | 107525 | Permitted Site 7 | Tree(s) :: 17 | 3606 TARAVAL ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981997.1 | 2098820.7 | 37.7419184550143 | -122.504888957614 | (37.7419184550143, -122.504888957614) | 1 | 8 | 3 | 29491 | 35 | ||||||
51472 | 55812 | Permitted Site 7 | Tree(s) :: 17 | 1459 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | Permit Number 11859 | 5982138.86171606 | 2105175.05303596 | 37.7593740660807 | -122.504869554101 | (37.7593740660807, -122.504869554101) | 1 | 8 | 3 | 56 | 35 | |||
139147 | 55813 | Permitted Site 7 | Tree(s) :: 17 | 1467 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | Permit Number 11860 | 5982140.65652703 | 2105122.88235316 | 37.7592309258195 | -122.504859480986 | (37.7592309258195, -122.504859480986) | 1 | 8 | 3 | 56 | 35 |
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) );