trees
73 rows where Fire Prevention Districts = 8, Supervisor Districts = 7 and qSpecies_id = 50
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 991 | 38251 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | 8 | 4 | 7 | 28853 | 19 | ||
| 1652 | 243315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 40 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006628.53628 | 2105662.75814 | 37.7621234987325 | -122.420206730272 | (37.7621234987325, -122.420206730272) | 8 | 4 | 7 | 28859 | 19 | |||
| 2118 | 73083 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.418411696436 | (37.7635727856768, -122.418411696436) | 8 | 4 | 7 | 28859 | 19 | ||
| 2489 | 224583 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008562.45401 | 2106796.83945 | 37.7653462039852 | -122.413598242063 | (37.7653462039852, -122.413598242063) | 8 | 4 | 7 | 28859 | 19 | |
| 3670 | 229792 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | 8 | 4 | 7 | 28853 | 19 | |||
| 5058 | 228531 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009451.25319 | 2106552.40785 | 37.7647249190387 | -122.410506818932 | (37.7647249190387, -122.410506818932) | 8 | 4 | 7 | 28859 | 19 | |||
| 8056 | 224581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008597.08192 | 2106800.15076 | 37.7653572404576 | -122.413478706001 | (37.7653572404576, -122.413478706001) | 8 | 4 | 7 | 28859 | 19 | |
| 9710 | 239955 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3448 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | 2x3 | Permit Number 50576 | 6006541.34834 | 2105555.19292 | 37.7618232366876 | -122.420500644884 | (37.7618232366876, -122.420500644884) | 8 | 4 | 7 | 28859 | 19 | |
| 10242 | 52219 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
| 13570 | 34057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | 8 | 4 | 7 | 28859 | 19 | ||
| 14632 | 224584 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.413665425938 | (37.76534068665, -122.413665425938) | 8 | 4 | 7 | 28859 | 19 | |
| 15488 | 228530 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6009448.17881 | 2106596.433 | 37.7648456296528 | -122.410520561485 | (37.7648456296528, -122.410520561485) | 8 | 4 | 7 | 28859 | 19 | |||
| 19464 | 224582 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008579.87348 | 2106797.48808 | 37.7653489631036 | -122.413538037855 | (37.7653489631036, -122.413538037855) | 8 | 4 | 7 | 28859 | 19 | |
| 20654 | 37663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 12 | 6x6 | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 |
| 26670 | 226355 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2175 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008795.60516 | 2105650.73446 | 37.7622123526471 | -122.412710792894 | (37.7622123526471, -122.412710792894) | 8 | 4 | 7 | 28859 | 19 | |||
| 27550 | 228526 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.70378 | 2106296.28434 | 37.7640099687976 | -122.411210045617 | (37.7640099687976, -122.411210045617) | 8 | 4 | 7 | 28859 | 19 | |||
| 28802 | 226329 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007821.99816 | 2105868.63243 | 37.7627559568505 | -122.416093572069 | (37.7627559568505, -122.416093572069) | 8 | 4 | 7 | 28859 | 19 | |||
| 33145 | 226330 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007820.88393 | 2105900.22293 | 37.7628426343977 | -122.416099663169 | (37.7628426343977, -122.416099663169) | 8 | 4 | 7 | 28859 | 19 | |||
| 34711 | 44001 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 35048 | 46554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
| 35810 | 34056 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | 8 | 4 | 7 | 28859 | 19 | ||
| 37180 | 44003 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 37788 | 34059 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | 12 | 6x7 | Permit Number 37961 | 6009447.37701969 | 2106694.23265708 | 37.7651141201322 | -122.410530241296 | (37.7651141201322, -122.410530241296) | 8 | 4 | 7 | 28859 | 19 | |
| 39204 | 108736 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1351 Minna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | 8 | 4 | 7 | 28853 | 19 | ||
| 43233 | 226460 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007913.34927 | 2105633.2143 | 37.7621146889646 | -122.415760949718 | (37.7621146889646, -122.415760949718) | 8 | 4 | 7 | 28859 | 19 | |||
| 43994 | 229790 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007575.95086 | 2107340.46198 | 37.7667834204423 | -122.417048857113 | (37.7667834204423, -122.417048857113) | 8 | 4 | 7 | 28853 | 19 | |||
| 45724 | 229789 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007559.60101 | 2107340.57096 | 37.7667827999232 | -122.417105416394 | (37.7667827999232, -122.417105416394) | 8 | 4 | 7 | 28853 | 19 | |||
| 52561 | 226312 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2180 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008090.95388 | 2105786.60151 | 37.7625458374421 | -122.4151575397 | (37.7625458374421, -122.4151575397) | 8 | 4 | 7 | 28859 | 19 | |||
| 52726 | 226462 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007188.60102 | 2106179.35089 | 37.7635734837649 | -122.418306305386 | (37.7635734837649, -122.418306305386) | 8 | 4 | 7 | 28859 | 19 | |||
| 53104 | 229794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 270 14th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.7683822351787 | -122.419295689168 | (37.7683822351787, -122.419295689168) | 8 | 4 | 7 | 28853 | 19 | |||
| 57222 | 95619 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767387 | 6007152 | 2106175 | 37.7635594768753 | -122.418432588523 | (37.7635594768753, -122.418432588523) | 8 | 4 | 7 | 28859 | 19 | |
| 60589 | 226459 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3242 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007896.86765 | 2105631.29342 | 37.7621084881288 | -122.415817817459 | (37.7621084881288, -122.415817817459) | 8 | 4 | 7 | 28859 | 19 | |||
| 64720 | 228525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.7639713843042 | -122.411209189472 | (37.7639713843042, -122.411209189472) | 8 | 4 | 7 | 28859 | 19 | |||
| 72715 | 44010 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 76731 | 46556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
| 76930 | 226311 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2070 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008053.75125 | 2106490.49002 | 37.7644764615472 | -122.415336042545 | (37.7644764615472, -122.415336042545) | 8 | 4 | 7 | 28859 | 19 | |||
| 77562 | 226327 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007824.63975 | 2105811.28938 | 37.7625986546389 | -122.416080374504 | (37.7625986546389, -122.416080374504) | 8 | 4 | 7 | 28859 | 19 | |||
| 84269 | 228528 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | 8 | 4 | 7 | 28859 | 19 | |||
| 90509 | 52078 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 266 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 3x3 | Permit Number 50281 | 6006938.43131737 | 2107937.41791562 | 37.7683866372255 | -122.419296287373 | (37.7683866372255, -122.419296287373) | 8 | 4 | 7 | 28853 | 19 | ||
| 95611 | 46553 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | ||
| 99838 | 228533 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | 8 | 4 | 7 | 28853 | 19 | |||
| 106771 | 228529 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | 8 | 4 | 7 | 28859 | 19 | |||
| 108707 | 52220 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
| 110578 | 226461 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2080 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008035.4164 | 2106222.97967 | 37.7637409096456 | -122.415380518518 | (37.7637409096456, -122.415380518518) | 8 | 4 | 7 | 28859 | 19 | |||
| 112129 | 50512 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2170 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47148 | 6008097.65074175 | 2105795.48714346 | 37.7625706116889 | -122.415135006616 | (37.7625706116889, -122.415135006616) | 8 | 4 | 7 | 28859 | 19 | ||
| 112615 | 52218 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
| 117144 | 52221 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
| 117876 | 228535 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009303.88793 | 2107359.35357 | 37.766932343692 | -122.411073521351 | (37.766932343692, -122.411073521351) | 8 | 4 | 7 | 28853 | 19 | |||
| 119587 | 228527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6009241.97976 | 2106321.44557 | 37.7640790151609 | -122.4112143273 | (37.7640790151609, -122.4112143273) | 8 | 4 | 7 | 28859 | 19 | |||
| 119841 | 34060 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 3x3 | Permit Number 37962 | 6009449.36433284 | 2106657.97750104 | 37.7650146832031 | -122.410520807301 | (37.7650146832031, -122.410520807301) | 8 | 4 | 7 | 28859 | 19 | |
| 124901 | 229806 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 34 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006429.32331 | 2105675.27923 | 37.7621466517725 | -122.420896621801 | (37.7621466517725, -122.420896621801) | 8 | 4 | 7 | 28859 | 19 | |||
| 128607 | 229793 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Trainor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008301.70607 | 2108167.22951 | 37.7690943309545 | -122.414597094793 | (37.7690943309545, -122.414597094793) | 8 | 4 | 7 | 28853 | 19 | |||
| 131487 | 228534 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009327.35781 | 2107359.80868 | 37.7669349094434 | -122.410992374607 | (37.7669349094434, -122.410992374607) | 8 | 4 | 7 | 28853 | 19 | |||
| 132012 | 37661 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
| 139411 | 228538 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009238.10189 | 2107354.62318 | 37.7669156657401 | -122.411300731452 | (37.7669156657401, -122.411300731452) | 8 | 4 | 7 | 28853 | 19 | |||
| 145930 | 44005 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 147417 | 229791 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007593.88535 | 2107340.09456 | 37.7667834204575 | -122.416986798497 | (37.7667834204575, -122.416986798497) | 8 | 4 | 7 | 28853 | 19 | |||
| 150230 | 37662 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
| 150448 | 46555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
| 154249 | 228539 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009212.74652 | 2107353.73928 | 37.7669118166657 | -122.411388369502 | (37.7669118166657, -122.411388369502) | 8 | 4 | 7 | 28853 | 19 | |||
| 157743 | 38250 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40360 | 6007553.94098134 | 2107334.22981902 | 37.7667650702265 | -122.417124544174 | (37.7667650702265, -122.417124544174) | 8 | 4 | 7 | 28853 | 19 | ||
| 158779 | 226356 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2793 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008207.55 | 2106773.70397 | 37.7652627442076 | -122.414824138541 | (37.7652627442076, -122.414824138541) | 8 | 4 | 7 | 28859 | 19 | |||
| 160150 | 52222 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
| 175061 | 228532 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009375.26414 | 2107362.10106 | 37.7669438900682 | -122.410826835502 | (37.7669438900682, -122.410826835502) | 8 | 4 | 7 | 28853 | 19 | |||
| 175900 | 229803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006754.85376 | 2105853.73018 | 37.7626549800545 | -122.419783396906 | (37.7626549800545, -122.419783396906) | 8 | 4 | 7 | 28859 | 19 | |||
| 176140 | 44012 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 177064 | 44004 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 177993 | 228536 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009279.45147 | 2107357.51638 | 37.7669259288053 | -122.411157913712 | (37.7669259288053, -122.411157913712) | 8 | 4 | 7 | 28853 | 19 | |||
| 184588 | 38249 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40360 | 6007553.94098134 | 2107334.22981902 | 37.7667650702265 | -122.417124544174 | (37.7667650702265, -122.417124544174) | 8 | 4 | 7 | 28853 | 19 | ||
| 186236 | 226328 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007822.68734 | 2105830.62056 | 37.7626516238081 | -122.416088496301 | (37.7626516238081, -122.416088496301) | 8 | 4 | 7 | 28859 | 19 | |||
| 191118 | 44013 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 193942 | 36713 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 34 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39499 | 6006412.25485032 | 2105738.01834436 | 37.7623179565756 | -122.420960109842 | (37.7623179565756, -122.420960109842) | 8 | 4 | 7 | 28859 | 19 | ||
| 194227 | 228537 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009258.78622 | 2107356.53697 | 37.7669220806253 | -122.411229322595 | (37.7669220806253, -122.411229322595) | 8 | 4 | 7 | 28853 | 19 |
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) );