trees
6,344 rows where qSpecies_id = 19 sorted by Zip Codes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
11199 | 73361 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984617.03994 | 2094708.01424 | 37.730779908566 | -122.495526924733 | (37.730779908566, -122.495526924733) | 1 | 8 | 4 | 64 | 35 | |||
13657 | 73537 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984627.56608 | 2094712.464 | 37.7307927427943 | -122.495490862808 | (37.7307927427943, -122.495490862808) | 1 | 8 | 4 | 64 | 35 | |||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
28492 | 208698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4130 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992075.90201 | 2088383.47737 | 37.713848227595 | -122.469280529167 | (37.713848227595, -122.469280529167) | 9 | 8 | 6 | 64 | 24 | |||
32989 | 50828 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Kempton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47347 | 5992329.33717846 | 2087607.86910297 | 37.7117332358721 | -122.468348178801 | (37.7117332358721, -122.468348178801) | 9 | 8 | 4 | 64 | 24 | |||
34244 | 208692 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Arch St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992715.18147 | 2091115.28005 | 37.7213860176206 | -122.467269473301 | (37.7213860176206, -122.467269473301) | 9 | 8 | 6 | 64 | 24 | |||
41877 | 114072 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 454 ARBALLO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
42314 | 177337 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 151 Morningside Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5985552.21468 | 2094749.49981 | 37.730948533249 | -122.492296977222 | (37.730948533249, -122.492296977222) | 1 | 8 | 4 | 64 | 35 | |||
52931 | 208687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 395 Byxbee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991938.37587 | 2091181.64136 | 37.7215233557961 | -122.469959478655 | (37.7215233557961, -122.469959478655) | 9 | 8 | 6 | 64 | 24 | |||
65713 | 45350 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Vernon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2001 12:00:00 AM | Permit Number 44178 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821 | (37.7207553141827, -122.46815485821) | 9 | 8 | 6 | 64 | 24 | |||
79924 | 208688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Vernon St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5992460.83183 | 2090875.38614 | 37.7207126412465 | -122.468131239666 | (37.7207126412465, -122.468131239666) | 9 | 8 | 6 | 64 | 24 | |||
83194 | 208697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Garfield St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993327.08056 | 2090460.08559 | 37.7196223166853 | -122.465106762081 | (37.7196223166853, -122.465106762081) | 9 | 8 | 6 | 64 | 24 | |||
91976 | 208700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Eucalyptus Dr | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5990998.47136 | 2094705.01684 | 37.731143287718 | -122.473465306694 | (37.731143287718, -122.473465306694) | 1 | 8 | 4 | 64 | 40 | |||
96214 | 208691 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Arch St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992715.41868 | 2091126.56279 | 37.7214170109678 | -122.467269473306 | (37.7214170109678, -122.467269473306) | 9 | 8 | 6 | 64 | 24 | |||
96226 | 103029 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | Permit Number 767522 | 5993810.5 | 2090074.3 | 37.7185909063027 | -122.463407787149 | (37.7185909063027, -122.463407787149) | 9 | 8 | 6 | 64 | 24 | |||
104304 | 47377 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 528 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45294 | 5993282.7857759 | 2090700.56531767 | 37.7202800615282 | -122.465277330566 | (37.7202800615282, -122.465277330566) | 9 | 8 | 6 | 64 | 24 | ||
118232 | 208690 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 266 Vernon St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992479.67005 | 2089630.07877 | 37.7172944179741 | -122.467975588622 | (37.7172944179741, -122.467975588622) | 9 | 8 | 6 | 64 | 24 | |||
120186 | 185055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989329.6935 | 2096044.7466 | 37.7347250633047 | -122.479332473096 | (37.7347250633047, -122.479332473096) | 1 | 8 | 3 | 64 | 35 | |||
133048 | 52973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 238 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48954 | 5991975.4138169 | 2090110.54331743 | 37.7185845236626 | -122.46975350981 | (37.7185845236626, -122.46975350981) | 9 | 8 | 6 | 64 | 24 | ||
137322 | 185058 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2201 Yorba St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986122.6096 | 2096370.9604 | 37.7354339667533 | -122.490444296494 | (37.7354339667533, -122.490444296494) | 1 | 8 | 3 | 64 | 35 | |||
156440 | 208694 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 528 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993272.92946 | 2090693.81146 | 37.7202609486599 | -122.465310909985 | (37.7202609486599, -122.465310909985) | 9 | 8 | 6 | 64 | 24 | |||
160994 | 253716 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x15 | 5989962 | 2095532 | 37.7333538971055 | -122.477108940264 | (37.7333538971055, -122.477108940264) | 1 | 8 | 4 | 64 | 35 | ||||
164295 | 208693 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 599 Arch St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992715.7483 | 2091102.30804 | 37.7213504323647 | -122.467266571212 | (37.7213504323647, -122.467266571212) | 9 | 8 | 6 | 64 | 24 | |||
168787 | 208699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Eucalyptus Dr | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5991017.27177 | 2094704.62034 | 37.7311432877287 | -122.473400282119 | (37.7311432877287, -122.473400282119) | 1 | 8 | 4 | 64 | 40 | |||
172407 | 47328 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 585 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45258 | 5993756.61747977 | 2091094.97603539 | 37.7213903322657 | -122.463668074108 | (37.7213903322657, -122.463668074108) | 9 | 8 | 6 | 64 | 24 | ||
175864 | 208695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 575 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993481.53031 | 2089678.1348 | 37.7174841731343 | -122.464516142224 | (37.7174841731343, -122.464516142224) | 9 | 8 | 6 | 64 | 24 | |||
185352 | 45352 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Vernon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2001 12:00:00 AM | Permit Number 44178 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821 | (37.7207553141827, -122.46815485821) | 9 | 8 | 6 | 64 | 24 | |||
186802 | 208684 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 585 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993765.24366 | 2091036.89871 | 37.7212313630082 | -122.463634043094 | (37.7212313630082, -122.463634043094) | 9 | 8 | 6 | 64 | 24 | |||
188161 | 53132 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4130 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2006 12:00:00 AM | Permit Number 49068 | 5992156.9 | 2088377.1 | 37.713835397146 | -122.469000108736 | (37.713835397146, -122.469000108736) | 9 | 8 | 6 | 64 | 24 | ||
190682 | 208689 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 455 Vernon St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 5992461.84626 | 2090851.0446 | 37.7206458639025 | -122.468125963363 | (37.7206458639025, -122.468125963363) | 9 | 8 | 6 | 64 | 24 | |||
1369 | 229980 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 542 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1982 12:00:00 AM | 15 | Width 3ft | Permit Number 19660 | 6003257.39485 | 2095864.57819 | 37.735029463323 | -122.431166815702 | (37.735029463323, -122.431166815702) | 2 | 7 | 5 | 63 | 7 | |
1463 | 229983 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 568 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1982 12:00:00 AM | 15 | Width 2ft | Permit Number 19661 | 6003129.34202 | 2095763.1248 | 37.7347436380916 | -122.431602298905 | (37.7347436380916, -122.431602298905) | 2 | 7 | 5 | 63 | 7 | |
2840 | 208818 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 204 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001433.86045 | 2094986.8847 | 37.7325160147058 | -122.437408581945 | (37.7325160147058, -122.437408581945) | 9 | 7 | 5 | 63 | 40 | |||
7602 | 5107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2680 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002305.28224 | 2096351.99681 | 37.736313802225 | -122.434493443022 | (37.736313802225, -122.434493443022) | 2 | 7 | 5 | 63 | 7 | ||
8047 | 229934 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 602 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002630.53663 | 2098906.06974 | 37.7433451534675 | -122.433551376193 | (37.7433451534675, -122.433551376193) | 2 | 7 | 5 | 63 | 22 | |||
8813 | 229976 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.20133 | 2096023.86311 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | 2 | 7 | 5 | 63 | 7 | |
10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
11013 | 60619 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 209 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20243 | 6004834.14454804 | 2097168.79499693 | 37.7386997741774 | -122.425808230058 | (37.7386997741774, -122.425808230058) | 2 | 7 | 5 | 63 | 7 | ||
12591 | 230252 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 85 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004316.63271 | 2097687.7392 | 37.7400954181634 | -122.427634504424 | (37.7400954181634, -122.427634504424) | 2 | 7 | 5 | 63 | 7 | |||
13634 | 230270 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 20 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002718.44452 | 2095941.61151 | 37.7352104231079 | -122.433035659081 | (37.7352104231079, -122.433035659081) | 2 | 7 | 5 | 63 | 7 | |||
14518 | 230256 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1725 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003994.56432 | 2098095.65503 | 37.7411972387569 | -122.428777157838 | (37.7411972387569, -122.428777157838) | 2 | 7 | 5 | 63 | 7 | |||
15639 | 230263 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 38 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002830.02953 | 2095510.93393 | 37.7340342096948 | -122.432619115583 | (37.7340342096948, -122.432619115583) | 2 | 7 | 5 | 63 | 7 | |||
16245 | 234784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2019 12:00:00 AM | 3 | 3x5 | Permit Number 784584 | 6002739.51006 | 2095878.74653 | 37.7350390051434 | -122.432958338056 | (37.7350390051434, -122.432958338056) | 2 | 7 | 5 | 63 | 7 | |
16578 | 230273 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002558.95964 | 2096114.39228 | 37.7356757917016 | -122.433599400016 | (37.7356757917016, -122.433599400016) | 2 | 7 | 5 | 63 | 7 | |||
19456 | 229979 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 536 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1982 12:00:00 AM | 11 | Width 3ft | Permit Number 19659 | 6003305.39384 | 2095901.6279 | 37.7351339132885 | -122.431003509611 | (37.7351339132885, -122.431003509611) | 2 | 7 | 5 | 63 | 7 | |
19653 | 230141 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 847 Duncan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001042.04806 | 2099649.19746 | 37.7452953504113 | -122.439097197601 | (37.7452953504113, -122.439097197601) | 2 | 4 | 5 | 63 | 22 | |||
19738 | 60123 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 298 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19650 | 6004272.79376242 | 2096671.25180618 | 37.7373018951098 | -122.42771367587 | (37.7373018951098, -122.42771367587) | 2 | 7 | 5 | 63 | 7 | ||
22442 | 229907 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 75 High St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999808.77765 | 2100760.24663 | 37.7482757729119 | -122.4434414204 | (37.7482757729119, -122.4434414204) | 2 | 4 | 5 | 63 | 22 | |||
23034 | 229533 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 378 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003437.74987 | 2099538.28585 | 37.7451268390366 | -122.430805349393 | (37.7451268390366, -122.430805349393) | 2 | 7 | 5 | 63 | 22 | |||
27656 | 59382 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 476 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19658 | 6003601.47411303 | 2096143.32697895 | 37.7358143364909 | -122.429997089324 | (37.7358143364909, -122.429997089324) | 2 | 7 | 5 | 63 | 7 | ||
29119 | 230272 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002571.70156 | 2096102.90486 | 37.7356449728457 | -122.433554525631 | (37.7356449728457, -122.433554525631) | 2 | 7 | 5 | 63 | 7 | |||
30018 | 60117 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 14 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19642 | 6004839.88177356 | 2098293.71651362 | 37.7417888775719 | -122.425868444921 | (37.7417888775719, -122.425868444921) | 2 | 7 | 5 | 63 | 7 | ||
31993 | 229530 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 422 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003162.48036 | 2098642.46973 | 37.7426515360474 | -122.431693236559 | (37.7426515360474, -122.431693236559) | 2 | 7 | 5 | 63 | 22 | |||
32159 | 60131 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 568 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19661 | 6003100.360251 | 2095761.63487373 | 37.7347379043363 | -122.431702392408 | (37.7347379043363, -122.431702392408) | 2 | 7 | 5 | 63 | 7 | ||
32247 | 60631 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20257 | 6003462.71077549 | 2096034.20965645 | 37.735506865485 | -122.430469065238 | (37.735506865485, -122.430469065238) | 2 | 7 | 5 | 63 | 7 | ||
32446 | 64127 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 647 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24898 | 6002406.23818147 | 2098844.72039568 | 37.7431639736769 | -122.434322556442 | (37.7431639736769, -122.434322556442) | 2 | 7 | 5 | 63 | 7 | ||
32457 | 56591 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 521 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1988 12:00:00 AM | 3x3 | Permit Number 25102 | 6003281.28786158 | 2096142.65442587 | 37.7357943512286 | -122.431104050323 | (37.7357943512286, -122.431104050323) | 2 | 7 | 5 | 63 | 7 | ||
32909 | 229974 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 484 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003591.05254 | 2096123.4602 | 37.7357591966153 | -122.430031704025 | (37.7357591966153, -122.430031704025) | 2 | 7 | 5 | 63 | 7 | |||
33767 | 229962 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 218 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004758.15665 | 2097096.60052 | 37.7384972500442 | -122.426065822387 | (37.7384972500442, -122.426065822387) | 2 | 7 | 5 | 63 | 7 | |||
34070 | 229992 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 337 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004130.31569 | 2096499.51437 | 37.7368222825163 | -122.428194052738 | (37.7368222825163, -122.428194052738) | 2 | 7 | 5 | 63 | 7 | |||
34720 | 30801 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 199 Burnside Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | Permit Number 34666 | 6001085.22188443 | 2095491.07454236 | 37.7338805765559 | -122.438650020361 | (37.7338805765559, -122.438650020361) | 9 | 7 | 5 | 63 | 40 | |||
35540 | 208816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 166 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001550.6502 | 2095223.1861 | 37.7331714828785 | -122.437021724195 | (37.7331714828785, -122.437021724195) | 9 | 7 | 5 | 63 | 40 | |||
35551 | 229977 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 522 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1980 12:00:00 AM | 14 | Width 2ft | Permit Number 18744 | 6003363.64026 | 2095947.46217 | 37.7352630640274 | -122.430805400661 | (37.7352630640274, -122.430805400661) | 2 | 7 | 5 | 63 | 7 | |
36527 | 229527 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 481 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002866.01524 | 2098582.31418 | 37.7424695537155 | -122.432714030041 | (37.7424695537155, -122.432714030041) | 2 | 7 | 5 | 63 | 22 | |||
36941 | 5111 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2700 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6002328.55465 | 2096230.80286 | 37.7359823525955 | -122.434404318399 | (37.7359823525955, -122.434404318399) | 2 | 7 | 5 | 63 | 7 | |||
38469 | 229972 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 476 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003622.52641 | 2096147.74227 | 37.7358276521265 | -122.429924618138 | (37.7358276521265, -122.429924618138) | 2 | 7 | 5 | 63 | 7 | |||
41087 | 47710 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45505 | 6002613.96578563 | 2096324.44810828 | 37.7362556776497 | -122.433424228715 | (37.7362556776497, -122.433424228715) | 2 | 7 | 5 | 63 | 7 | ||
41970 | 5687 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1512 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2007 12:00:00 AM | 3 | 5X8 | 6005211.56964 | 2099494.14545 | 37.7451059801576 | -122.424668644665 | (37.7451059801576, -122.424668644665) | 2 | 7 | 5 | 63 | 22 | ||
41992 | 5663 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1362 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2016 05:24:00 AM | 3 | 10x6 | 6005158.4970374 | 2100409.5544217 | 37.7476164858345 | -122.424917276216 | (37.7476164858345, -122.424917276216) | 2 | 7 | 5 | 63 | 22 | ||
43037 | 229538 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1329 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003920.37299 | 2100540.31864 | 37.7479055211374 | -122.429207959185 | (37.7479055211374, -122.429207959185) | 2 | 4 | 5 | 63 | 22 | |||
43248 | 229474 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004545.85369 | 2099802.96595 | 37.7459163097869 | -122.426992565663 | (37.7459163097869, -122.426992565663) | 2 | 7 | 5 | 63 | 22 | |||
43677 | 229522 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | Width 2ft | 6004493.41372 | 2100695.79384 | 37.7483648435728 | -122.427237482541 | (37.7483648435728, -122.427237482541) | 2 | 4 | 5 | 63 | 22 | ||
45233 | 230267 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 284 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004529.36655 | 2096546.5023 | 37.7369738713537 | -122.426817703279 | (37.7369738713537, -122.426817703279) | 2 | 7 | 5 | 63 | 7 | |||
45537 | 229961 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004863.3925 | 2097433.75126 | 37.7394289368899 | -122.425725957794 | (37.7394289368899, -122.425725957794) | 2 | 7 | 5 | 63 | 7 | |||
46069 | 51762 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 137 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | Permit Number 48029 | 6004669.43811399 | 2097526.56698943 | 37.7396728258328 | -122.426403174041 | (37.7396728258328, -122.426403174041) | 2 | 7 | 5 | 63 | 7 | |||
46104 | 229973 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 476 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003612.53694 | 2096138.9527 | 37.7358029522402 | -122.429958528868 | (37.7358029522402, -122.429958528868) | 2 | 7 | 5 | 63 | 7 | |||
47007 | 65353 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 31 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | 17 | Permit Number 28188 | 6002634.44804827 | 2096298.89617511 | 37.7361866799376 | -122.433351587817 | (37.7361866799376, -122.433351587817) | 2 | 7 | 5 | 63 | 7 | |
47541 | 229995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2019 12:00:00 AM | 3 | Width 3ft | 6003974.00039 | 2096997.36638 | 37.7381804251836 | -122.428769983958 | (37.7381804251836, -122.428769983958) | 2 | 7 | 5 | 63 | 7 | ||
48188 | 208813 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 190 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999509.64392 | 2095791.25518 | 37.7346150449508 | -122.444118814056 | (37.7346150449508, -122.444118814056) | 9 | 7 | 4 | 63 | 40 | |||
48456 | 208814 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 130 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001590.72469 | 2095366.55133 | 37.7335674085034 | -122.436893435894 | (37.7335674085034, -122.436893435894) | 9 | 7 | 5 | 63 | 40 | |||
48664 | 229560 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 269 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004742.03772 | 2100152.34613 | 37.7468867187664 | -122.42633905892 | (37.7468867187664, -122.42633905892) | 2 | 7 | 5 | 63 | 22 | |||
48874 | 230268 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 51 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002614.04478 | 2096013.44224 | 37.7354017314015 | -122.43340173802 | (37.7354017314015, -122.43340173802) | 2 | 7 | 5 | 63 | 7 | |||
49875 | 230274 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 31 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002657.37043 | 2096282.85162 | 37.7361439256854 | -122.433271189717 | (37.7361439256854, -122.433271189717) | 2 | 7 | 5 | 63 | 7 | |||
50882 | 60124 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 331 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19651 | 6004171.40037001 | 2096525.55404865 | 37.7368961060941 | -122.428053860011 | (37.7368961060941, -122.428053860011) | 2 | 7 | 5 | 63 | 7 | ||
51143 | 104236 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1265 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.7355870653858 | -122.441184993439 | (37.7355870653858, -122.441184993439) | 9 | 7 | 4 | 63 | 40 | ||||
52156 | 230000 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 319 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004052.06224 | 2096760.37461 | 37.7375341175153 | -122.428483197344 | (37.7375341175153, -122.428483197344) | 2 | 7 | 5 | 63 | 7 | |||
53165 | 60611 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 62 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20235 | 6004863.65784783 | 2097891.67649788 | 37.7406863107232 | -122.425757625585 | (37.7406863107232, -122.425757625585) | 2 | 7 | 5 | 63 | 7 | ||
54950 | 65383 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 18 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2002 12:00:00 AM | Permit Number 28222 | 6002986.29488356 | 2095473.55821936 | 37.7339404452074 | -122.432076190121 | (37.7339404452074, -122.432076190121) | 2 | 7 | 5 | 63 | 7 | ||
56124 | 229536 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1610 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003959.98466 | 2098799.97819 | 37.7431291911685 | -122.428946924678 | (37.7431291911685, -122.428946924678) | 2 | 7 | 5 | 63 | 22 | |||
56275 | 121468 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002578 | 2096112 | 37.735670303373 | -122.4335333993 | (37.735670303373, -122.4335333993) | 2 | 7 | 5 | 63 | 7 | |||
56329 | 229482 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1557 Church St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6004608.55119 | 2099805.21218 | 37.7459260224871 | -122.426775926168 | (37.7459260224871, -122.426775926168) | 2 | 7 | 5 | 63 | 22 | |||
57011 | 229903 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1728 Diamond St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6002025.61901 | 2099027.89563 | 37.7436453183836 | -122.435651736554 | (37.7436453183836, -122.435651736554) | 2 | 7 | 5 | 63 | 22 | |||
57558 | 30816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 149 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 11 | Permit Number 34678 | 6001071.06827 | 2094917.99352 | 37.7323062235503 | -122.438657903956 | (37.7323062235503, -122.438657903956) | 9 | 7 | 4 | 63 | 40 | |
59612 | 229899 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1406 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001969.28788 | 2099943.13342 | 37.7461551463582 | -122.435911989572 | (37.7461551463582, -122.435911989572) | 2 | 7 | 5 | 63 | 22 | |||
60478 | 51763 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 137 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | Permit Number 48029 | 6004669.43811399 | 2097526.56698943 | 37.7396728258328 | -122.426403174041 | (37.7396728258328, -122.426403174041) | 2 | 7 | 5 | 63 | 7 | |||
60541 | 61748 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3847 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1984 12:00:00 AM | 30 | 3x3 | Permit Number 21754 | 6004877.67688594 | 2100735.98842192 | 37.7484969322785 | -122.425911569476 | (37.7484969322785, -122.425911569476) | 2 | 4 | 5 | 63 | 22 | |
60789 | 62377 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4363 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31445 | 6001568.2849775 | 2100554.14182611 | 37.7478100425712 | -122.437342348198 | (37.7478100425712, -122.437342348198) | 2 | 4 | 5 | 63 | 22 | ||
61340 | 62458 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1323 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31527 | 6003278.76592531 | 2100540.0511229 | 37.7478684439554 | -122.431426587211 | (37.7478684439554, -122.431426587211) | 2 | 4 | 5 | 63 | 22 |
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) );