trees
2,421 rows where qSpecies_id = 8 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20672 | 176230 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001498.44538 | 2089067.7688 | 37.7162671349894 | -122.436761734667 | (37.7162671349894, -122.436761734667) | 9 | 7 | 6 | 28861 | 5 | |||
| 167942 | 28261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 6012138.7194258 | 2089093.5243211 | 37.7169368272436 | -122.399985378545 | (37.7169368272436, -122.399985378545) | 10 | 7 | 8 | 309 | 39 | ||
| 136129 | 60469 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20062 | 5996935.23090665 | 2089095.72294646 | 37.7160834957462 | -122.452536343277 | (37.7160834957462, -122.452536343277) | 9 | 8 | 6 | 28861 | 24 | ||
| 95632 | 160567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 790 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:57:00 AM | 3 | Width 0ft | 6002104.08605 | 2089098.7371 | 37.716386568565 | -122.43467056359 | (37.716386568565, -122.43467056359) | 9 | 7 | 6 | 28861 | 5 | |
| 42579 | 176250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3562 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012131.39961 | 2089120.6063 | 37.7170107808051 | -122.400012580531 | (37.7170107808051, -122.400012580531) | 10 | 7 | 8 | 309 | 39 | |||
| 84483 | 51679 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2005 12:00:00 AM | Permit Number 47959 | 5997000.93217055 | 2089281.06298021 | 37.7165961605731 | -122.452322615904 | (37.7165961605731, -122.452322615904) | 9 | 8 | 6 | 28861 | 24 | ||
| 145999 | 53552 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 124 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20052 | 5997008.15708783 | 2089291.43789618 | 37.7166250615868 | -122.452298391323 | (37.7166250615868, -122.452298391323) | 9 | 8 | 6 | 28861 | 24 | ||
| 170286 | 160563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:34:00 PM | 3 | Width 0ft | Permit Number 47139 | 6002231.24921 | 2089300.0903 | 37.7169466582377 | -122.434245412715 | (37.7169466582377, -122.434245412715) | 9 | 7 | 6 | 28861 | 5 |
| 104392 | 176251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009692.49199 | 2089304.87658 | 37.717380467816 | -122.408455736945 | (37.717380467816, -122.408455736945) | 9 | 7 | 8 | 309 | 39 | |||
| 86459 | 50502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 744 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:37:00 PM | 3 | 3x3 | Permit Number 767517 | 6002255.61475 | 2089339.38797 | 37.7170559438579 | -122.434164000676 | (37.7170559438579, -122.434164000676) | 9 | 7 | 6 | 28861 | 5 |
| 170210 | 176249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012088.82637 | 2089370.3173 | 37.7176940632127 | -122.400177264384 | (37.7176940632127, -122.400177264384) | 10 | 7 | 8 | 309 | 39 | ||
| 99650 | 28257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3508X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012088.3375369 | 2089388.4108582 | 37.7177437172214 | -122.400180224111 | (37.7177437172214, -122.400180224111) | 10 | 7 | 8 | 309 | 39 | ||
| 144392 | 87531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3508X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012093.266153 | 2089389.252949 | 37.7177463042476 | -122.400163247094 | (37.7177463042476, -122.400163247094) | 10 | 7 | 8 | 309 | 39 | ||
| 153244 | 176248 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012084.62968 | 2089393.6592 | 37.7177579213627 | -122.400193408991 | (37.7177579213627, -122.400193408991) | 10 | 7 | 8 | 309 | 39 | ||
| 50739 | 160561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 730 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:42:00 PM | 3 | Width 0ft | 6002306.04947 | 2089419.84324 | 37.7172797185636 | -122.43399542008 | (37.7172797185636, -122.43399542008) | 9 | 7 | 6 | 28861 | 5 | |
| 17189 | 39942 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | 9 | 7 | 8 | 309 | 39 | ||
| 39141 | 66232 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 218 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | 12 | Permit Number 29329 | 5997099.27039938 | 2089468.87131755 | 37.7171174718407 | -122.451996253737 | (37.7171174718407, -122.451996253737) | 9 | 8 | 6 | 28861 | 24 | |
| 147523 | 160560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 718 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:51:00 PM | 3 | Width 0ft | 6002343.44923 | 2089479.71946 | 37.7174462478135 | -122.433870424183 | (37.7174462478135, -122.433870424183) | 9 | 7 | 6 | 28861 | 5 | |
| 84796 | 207614 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 218 Lakeview Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997036.49742 | 2089508.96246 | 37.7172239569865 | -122.452216120002 | (37.7172239569865, -122.452216120002) | 9 | 8 | 6 | 28861 | 24 | |||
| 142189 | 117442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | 9 | 7 | 6 | 28861 | 5 | ||
| 96234 | 160559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 710 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:15:00 PM | 3 | Width 0ft | 6002373.47799 | 2089525.51104 | 37.7175736853632 | -122.433769899784 | (37.7175736853632, -122.433769899784) | 9 | 7 | 6 | 28861 | 5 | |
| 71094 | 160845 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 669 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2017 03:09:00 PM | 3 | Width 0ft | 6002769.79165 | 2089568.51347 | 37.7177142412877 | -122.432403094831 | (37.7177142412877, -122.432403094831) | 9 | 7 | 6 | 28861 | 5 | |
| 120302 | 160846 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.83021 | 37.7177707025263 | -122.432363340291 | (37.7177707025263, -122.432363340291) | 9 | 7 | 6 | 28861 | 5 | |
| 90746 | 207611 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 64 Majestic Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5997222.96665 | 2089595.38167 | 37.7174719243608 | -122.451577817186 | (37.7174719243608, -122.451577817186) | 9 | 8 | 6 | 28861 | 24 | |||
| 10902 | 259838 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1997 12:00:00 AM | 3 | Permit Number 38009 | 5996907.65838 | 2089596.01103 | 37.7174555905703 | -122.452667732297 | (37.7174555905703, -122.452667732297) | 9 | 8 | 6 | 28861 | 24 | ||
| 50780 | 176252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | 10 | 7 | 8 | 309 | 39 | |||
| 175392 | 60458 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 64 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 8 | 3x3 | Permit Number 20044 | 5997231.4874629 | 2089612.30707346 | 37.717518885545 | -122.451549584962 | (37.717518885545, -122.451549584962) | 9 | 8 | 6 | 28861 | 24 |
| 162560 | 176253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Delta St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010117.92765 | 2089629.2495 | 37.7182949452416 | -122.407008046982 | (37.7182949452416, -122.407008046982) | 10 | 7 | 8 | 309 | 39 | |||
| 177300 | 60455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 60 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20041 | 5997245.01433776 | 2089631.74975866 | 37.7175730452663 | -122.451504230583 | (37.7175730452663, -122.451504230583) | 9 | 8 | 6 | 28861 | 24 | ||
| 136780 | 52253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 477 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2005 12:00:00 AM | 6 | Permit Number 48420 | 6010242.54537 | 2089633.75943 | 37.7183143013438 | -122.406577611683 | (37.7183143013438, -122.406577611683) | 10 | 7 | 8 | 309 | 39 | ||
| 92062 | 52985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | 5 | Permit Number 48967 | 6010218.63808 | 2089641.81604 | 37.7183350855707 | -122.406660816961 | (37.7183350855707, -122.406660816961) | 10 | 7 | 8 | 309 | 39 | ||
| 499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
| 63012 | 207610 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Majestic Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5997347.38565 | 2089696.67863 | 37.7177571866363 | -122.451155061159 | (37.7177571866363, -122.451155061159) | 9 | 8 | 6 | 28861 | 24 | |||
| 172131 | 176254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011871.08574 | 2089770.57713 | 37.7187809523661 | -122.400958007209 | (37.7187809523661, -122.400958007209) | 10 | 7 | 8 | 309 | 39 | |||
| 178147 | 207617 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 385 Victoria St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5993228.76427 | 2089783.48491 | 37.7177588647558 | -122.46539747963 | (37.7177588647558, -122.46539747963) | 9 | 8 | 6 | 64 | 24 | |||
| 186256 | 176231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001253.10056 | 2089784.48632 | 37.7182211342895 | -122.437661063033 | (37.7182211342895, -122.437661063033) | 9 | 7 | 6 | 28861 | 5 | |||
| 57686 | 160887 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 687 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:35:00 AM | 3 | Width 0ft | 6002277.90968 | 2089801.25761 | 37.7183254007788 | -122.434119936579 | (37.7183254007788, -122.434119936579) | 9 | 7 | 6 | 28861 | 5 | |
| 73572 | 207616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 385 Victoria St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993229.18719 | 2089803.61986 | 37.7178141748665 | -122.46539747963 | (37.7178141748665, -122.46539747963) | 9 | 8 | 6 | 64 | 24 | |||
| 25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 32297 | 48573 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 99353 | 48571 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 53101 | 34891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
| 181410 | 34892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
| 130316 | 160888 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 679 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:26:00 AM | 3 | Width 0ft | 6002304.81633 | 2089843.73714 | 37.7184435671833 | -122.43402996662 | (37.7184435671833, -122.43402996662) | 9 | 7 | 6 | 28861 | 5 | |
| 30817 | 51030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.62278 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | 10 | 7 | 8 | 309 | 28 | ||
| 4986 | 51031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.57141 | 2089923.66488 | 37.7191984823926 | -122.401143367398 | (37.7191984823926, -122.401143367398) | 10 | 7 | 8 | 309 | 28 | ||
| 74684 | 216641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 8 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:34:00 PM | 3 | Width 2ft | 5996523.62122 | 2089940.02354 | 37.7183781559031 | -122.454019995444 | (37.7183781559031, -122.454019995444) | 9 | 8 | 6 | 28861 | 24 | ||
| 181103 | 83378 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 586 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.7187900121188 | -122.430676716663 | (37.7187900121188, -122.430676716663) | 9 | 7 | 6 | 28861 | 5 | |
| 188987 | 216737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.50939 | 37.7184704425356 | -122.454167365558 | (37.7184704425356, -122.454167365558) | 9 | 8 | 6 | 28861 | 24 | ||
| 185311 | 58274 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 679 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 11 | Permit Number 28518 | 6002069.69674 | 2089980.14992 | 37.7188047799052 | -122.434852426303 | (37.7188047799052, -122.434852426303) | 9 | 7 | 6 | 28861 | 5 | |
| 132215 | 251702 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 910 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:10:00 AM | 3 | 3x3 | 5995959 | 2089989 | 37.7184802428284 | -122.455975181765 | (37.7184802428284, -122.455975181765) | 9 | 8 | 6 | 28861 | 24 | ||
| 1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
| 176334 | 65612 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 12 | Permit Number 28517 | 6002045.90134 | 2090021.05349 | 37.7189157409448 | -122.434937601102 | (37.7189157409448, -122.434937601102) | 9 | 7 | 6 | 28861 | 5 | |
| 4187 | 78365 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | 9 | 7 | 6 | 28861 | 5 | |||
| 132969 | 108369 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773814 | 6001475.26516 | 2090061.55368 | 37.7189945287407 | -122.436912960177 | (37.7189945287407, -122.436912960177) | 9 | 7 | 6 | 28861 | 5 |
| 85918 | 84126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.83718 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | 10 | 7 | 8 | 309 | 28 | |
| 50744 | 65610 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 655 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 10 | Permit Number 28515 | 6002150.88747 | 2090106.59961 | 37.7191565919832 | -122.434580819343 | (37.7191565919832, -122.434580819343) | 9 | 7 | 6 | 28861 | 5 | |
| 64665 | 160919 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 656 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:14:00 AM | 3 | Width 0ft | 6002115.87134 | 2090131.53749 | 37.7192230779683 | -122.43470363886 | (37.7192230779683, -122.43470363886) | 9 | 7 | 6 | 28861 | 5 | |
| 11167 | 78311 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002171.16475 | 2090137.23408 | 37.7192418585039 | -122.434512917837 | (37.7192418585039, -122.434512917837) | 9 | 7 | 6 | 28861 | 5 | |||
| 14507 | 78352 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.434490001335 | (37.71927207124, -122.434490001335) | 9 | 7 | 6 | 28861 | 5 | |||
| 181009 | 216746 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 935 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:04:00 AM | 3 | Width 3ft | 5995893.72973 | 2090148.9347 | 37.7189156393246 | -122.456212350117 | (37.7189156393246, -122.456212350117) | 9 | 8 | 6 | 28861 | 24 | ||
| 23668 | 66231 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/1994 12:00:00 AM | Permit Number 29328 | 5997721.47171687 | 2090151.04761265 | 37.7190261896858 | -122.449894746819 | (37.7190261896858, -122.449894746819) | 9 | 8 | 6 | 28861 | 24 | ||
| 118930 | 160918 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:50:00 AM | 3 | Width 0ft | 6002126.85051 | 2090151.34839 | 37.7192780975889 | -122.43466710393 | (37.7192780975889, -122.43466710393) | 9 | 7 | 6 | 28861 | 5 | |
| 85273 | 251682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 40 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:02:00 PM | 3 | 3x3 | 5996554 | 2090155 | 37.7189701727187 | -122.453930506054 | (37.7189701727187, -122.453930506054) | 9 | 8 | 6 | 28861 | 24 | ||
| 42776 | 207608 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997723.56116 | 2090176.57785 | 37.7190964093462 | -122.449889363408 | (37.7190964093462, -122.449889363408) | 9 | 8 | 6 | 28861 | 24 | |||
| 62310 | 160917 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 646 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:31:00 AM | 3 | Width 0ft | 6002146.55527 | 2090180.28989 | 37.719358683138 | -122.434601060409 | (37.719358683138, -122.434601060409) | 9 | 7 | 6 | 28861 | 5 | |
| 145458 | 207609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5997727.90986 | 2090186.78446 | 37.7191246831501 | -122.449875066876 | (37.7191246831501, -122.449875066876) | 9 | 8 | 6 | 28861 | 24 | |||
| 50125 | 251683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:00:00 PM | 3 | 3x3 | 5996555 | 2090205 | 37.7191075183288 | -122.453930658436 | (37.7191075183288, -122.453930658436) | 9 | 8 | 6 | 28861 | 24 | ||
| 192513 | 85040 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 946 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49388 | 5995963.8 | 2090215.2 | 37.7191016102225 | -122.455974934213 | (37.7191016102225, -122.455974934213) | 9 | 8 | 6 | 28861 | 24 | |||
| 20515 | 216642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.47656 | 37.7191402755735 | -122.45402201442 | (37.7191402755735, -122.45402201442) | 9 | 8 | 6 | 28861 | 24 | ||
| 145695 | 65471 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28352 | 5995649.70460039 | 2090232.90843382 | 37.7191322005073 | -122.457061914585 | (37.7191322005073, -122.457061914585) | 9 | 8 | 6 | 28861 | 24 | ||
| 129643 | 216738 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 55 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:15:00 AM | 3 | Width 3ft | 5996190.92128 | 2090248.81596 | 37.7192069450213 | -122.455192295882 | (37.7192069450213, -122.455192295882) | 9 | 8 | 6 | 28861 | 24 | ||
| 59880 | 49496 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 16 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 153447 | 49497 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 175482 | 49494 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 181745 | 49495 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 184359 | 49493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 136449 | 65460 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28338 | 5995896.95851716 | 2090334.96533864 | 37.7194266209016 | -122.45621463281 | (37.7194266209016, -122.45621463281) | 9 | 8 | 6 | 28861 | 24 | ||
| 17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
| 24915 | 207606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995896.38015 | 2090348.10443 | 37.7194626645441 | -122.456217581487 | (37.7194626645441, -122.456217581487) | 9 | 8 | 6 | 28861 | 24 | |||
| 26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
| 141956 | 84009 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50690 | 6011658.3598 | 2090351.5567 | 37.7203643356392 | -122.401734134722 | (37.7203643356392, -122.401734134722) | 10 | 7 | 8 | 309 | 28 | |
| 187784 | 176245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011861.55971 | 2090354.44953 | 37.7203836161938 | -122.401031937775 | (37.7203836161938, -122.401031937775) | 10 | 7 | 8 | 309 | 28 | |||
| 190107 | 161124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781528 | 6003266.33968 | 2090358.66738 | 37.7199119739285 | -122.430743107307 | (37.7199119739285, -122.430743107307) | 9 | 7 | 6 | 28861 | 5 | |
| 62175 | 207605 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994168.04761 | 2090360.81563 | 37.71939820295 | -122.462192668156 | (37.71939820295, -122.462192668156) | 9 | 8 | 6 | 28861 | 24 | |||
| 43410 | 176244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011881.09111 | 2090360.91966 | 37.7204024713802 | -122.400964878027 | (37.7204024713802, -122.400964878027) | 10 | 7 | 8 | 309 | 28 | |||
| 116544 | 176243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.7204250353617 | -122.400893277618 | (37.7204250353617, -122.400893277618) | 10 | 7 | 8 | 309 | 28 | |||
| 49669 | 39646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.5137176 | 2090402.3957614 | 37.7195128594848 | -122.462166418076 | (37.7195128594848, -122.462166418076) | 9 | 8 | 6 | 28861 | 24 | ||
| 13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
| 72397 | 176240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009052.31678 | 2090410.35877 | 37.7203800198047 | -122.41074656201 | (37.7203800198047, -122.41074656201) | 9 | 3 | 7 | 309 | 28 | |||
| 140001 | 176241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009064.84821 | 2090413.67882 | 37.7203898385876 | -122.410703479104 | (37.7203898385876, -122.410703479104) | 9 | 3 | 7 | 309 | 28 | |||
| 81467 | 176242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009078.67243 | 2090418.23511 | 37.7204031242939 | -122.41065601467 | (37.7204031242939, -122.41065601467) | 9 | 3 | 7 | 309 | 28 | |||
| 123359 | 39647 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 76 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41041 | 5994176.75103926 | 2090428.14003501 | 37.719583560751 | -122.462167463801 | (37.719583560751, -122.462167463801) | 9 | 8 | 6 | 28861 | 24 | ||
| 55786 | 95669 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
| 69871 | 95668 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
| 74862 | 95670 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
| 188535 | 95671 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
| 31050 | 162895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:58:00 AM | 3 | Width 0ft | 5995899.78819 | 2090467.68802 | 37.7197912084714 | -122.45621444284 | (37.7197912084714, -122.45621444284) | 9 | 8 | 6 | 28861 | 24 | ||
| 88741 | 40429 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 516 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | Permit Number 41524 | 6002015.10880124 | 2090488.09848269 | 37.7201963938126 | -122.435077424443 | (37.7201963938126, -122.435077424443) | 9 | 7 | 6 | 28861 | 5 | |||
| 139495 | 162893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:55:00 AM | 3 | Width 0ft | 5995900.91597 | 2090507.14729 | 37.7198996190417 | -122.456213396033 | (37.7198996190417, -122.456213396033) | 9 | 8 | 6 | 28861 | 24 |
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) );