trees
327 rows where Police Districts = 6 and qSpecies_id = 8 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3799 | 63192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 7 | Permit Number 33572 | 5984052.00356 | 2112858.19024 | 37.7805821307687 | -122.498820690141 | (37.7805821307687, -122.498820690141) | 11 | 6 | 2 | 55 | 26 | |
4434 | 31506 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 275 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 7 | Permit Number 35066 | 5998177.9524 | 2112750.4955 | 37.7811048271727 | -122.449944767442 | (37.7811048271727, -122.449944767442) | 15 | 6 | 2 | 54 | 16 | |
5142 | 259872 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
5654 | 31560 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 178 Ewing Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | 15 | 6 | 2 | 54 | 16 | |||
6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
6857 | 83788 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 482 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994387.70821 | 2112243.63782 | 37.779495530287 | -122.463020234423 | (37.779495530287, -122.463020234423) | 11 | 6 | 2 | 54 | 11 | |||
10256 | 68236 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1515 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 9 | Permit Number 32031 | 5990787.04658 | 2113362.94185 | 37.7823607651124 | -122.475558077431 | (37.7823607651124, -122.475558077431) | 11 | 6 | 2 | 54 | 26 | |
11395 | 69965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5992352.53877 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | 11 | 6 | 2 | 54 | 11 | |||
12360 | 38902 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 276 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 5 | Permit Number 40716 | 5997044.32666189 | 2112582.61364036 | 37.780578937997 | -122.453854397363 | (37.780578937997, -122.453854397363) | 11 | 6 | 2 | 54 | 16 | |
18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
21637 | 41577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 715 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2000 12:00:00 AM | 7 | Permit Number 42091 | 5981330.80652 | 2110844.76376 | 37.7748938752615 | -122.50808495995 | (37.7748938752615, -122.50808495995) | 11 | 6 | 2 | 55 | 26 | ||
24334 | 48686 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
26008 | 54985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 610 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 1 | Permit Number 10863 | 5990982.11543 | 2111201.05221 | 37.7764361179599 | -122.474725393074 | (37.7764361179599, -122.474725393074) | 11 | 6 | 2 | 54 | 26 | ||
27976 | 67374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 6 | Permit Number 30868 | 5992412.40492 | 2111393.18626 | 37.7770464413981 | -122.469791653286 | (37.7770464413981, -122.469791653286) | 11 | 6 | 2 | 54 | 11 | |
30184 | 68222 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 7 | Permit Number 32012 | 5991360.03028 | 2113443.03788 | 37.7826138859716 | -122.473581670612 | (37.7826138859716, -122.473581670612) | 11 | 6 | 2 | 54 | 26 | |
30640 | 38839 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 947 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40668 | 5992575.8845778 | 2114792.63949005 | 37.7863898589993 | -122.469473646902 | (37.7863898589993, -122.469473646902) | 11 | 6 | 2 | 54 | 11 | ||
35739 | 37602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 510 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/26/1998 12:00:00 AM | 0 | Permit Number 40029 | 5992226.61347 | 2111944.07676 | 37.7785482961825 | -122.470474488792 | (37.7785482961825, -122.470474488792) | 11 | 6 | 2 | 54 | 11 | |
38599 | 48554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | 11 | 6 | 2 | 55 | 26 | |||
44430 | 45523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 153 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2001 12:00:00 AM | 4 | Permit Number 44284 | 5996204.70963 | 2113340.17454 | 37.782610825272 | -122.456813820837 | (37.782610825272, -122.456813820837) | 11 | 6 | 1 | 54 | 31 | ||
44731 | 112816 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 575 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | Permit Number 773547 | 5992490.3 | 2111549.9 | 37.7774812369392 | -122.46953360311 | (37.7774812369392, -122.46953360311) | 11 | 6 | 2 | 54 | 11 | |||
45768 | 47096 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 108 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | 15 | 6 | 2 | 54 | 16 | ||
48488 | 66494 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2454 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2014 12:00:00 AM | 3 | Permit Number 29655 | 6001767.8317 | 2114666.7908 | 37.7865712397422 | -122.437662882365 | (37.7865712397422, -122.437662882365) | 13 | 6 | 11 | 29490 | 27 | |
57658 | 56170 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 657 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 3 | Permit Number 12278 | 5990945.58459 | 2110914.19297 | 37.7756463641696 | -122.474830819328 | (37.7756463641696, -122.474830819328) | 11 | 6 | 2 | 54 | 26 | ||
58711 | 68462 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32324 | 5991504.44002823 | 2113463.17784531 | 37.7826775467792 | -122.473083548968 | (37.7826775467792, -122.473083548968) | 11 | 6 | 2 | 54 | 26 | ||
60242 | 63429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 174 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1987 12:00:00 AM | 1 | Permit Number 24014 | 5988702.91741 | 2114182.56462 | 37.7844901800735 | -122.482828244548 | (37.7844901800735, -122.482828244548) | 11 | 6 | 2 | 55 | 26 | ||
64406 | 30963 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1900 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2018 12:00:00 AM | 3 | Permit Number 781472 | 6001995.095 | 2115110.3689 | 37.7878021107927 | -122.436908375591 | (37.7878021107927, -122.436908375591) | 13 | 6 | 1 | 29490 | 27 | |
67865 | 36987 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39609 | 5993070.986847 | 2113501.00043119 | 37.7828719719487 | -122.467666762888 | (37.7828719719487, -122.467666762888) | 11 | 6 | 2 | 54 | 11 | ||
69628 | 114796 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | 11 | 6 | 2 | 55 | 26 | |||
71780 | 72330 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2761 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1996 12:00:00 AM | 9 | 5995926.57923 | 2110675.1717 | 37.7752774586568 | -122.457583143432 | (37.7752774586568, -122.457583143432) | 11 | 6 | 2 | 54 | 16 | ||
74477 | 42137 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 4 | Permit Number 42432 | 5991232.26761 | 2112071.30225 | 37.7788400781617 | -122.47392356042 | (37.7788400781617, -122.47392356042) | 11 | 6 | 2 | 54 | 26 | |
76174 | 104074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/06/2013 12:00:00 AM | 2 | Permit Number 770392 | 5986000.25731 | 2110187.13166 | 37.7733622428275 | -122.491884144737 | (37.7733622428275, -122.491884144737) | 11 | 6 | 2 | 55 | 26 | ||
77685 | 68223 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1330 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 9 | Permit Number 781803 | 5991325.89713 | 2113444.25067 | 37.7826152391743 | -122.473699843984 | (37.7826152391743, -122.473699843984) | 11 | 6 | 2 | 54 | 26 | |
78689 | 59079 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 630 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 4 | Permit Number 18379 | 5993622.03165 | 2110755.91143 | 37.7753664990592 | -122.465560903584 | (37.7753664990592, -122.465560903584) | 11 | 6 | 2 | 54 | 11 | ||
80158 | 48688 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
85787 | 43656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 456 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 6 | Permit Number 43300 | 5992830.57415 | 2112373.65794 | 37.7797627126323 | -122.46841643858 | (37.7797627126323, -122.46841643858) | 11 | 6 | 2 | 54 | 11 | |
87734 | 52647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 850@ FULTON 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 1 | Permit Number 774180 | 5982028.38924 | 2109948.2493 | 37.7724733883273 | -122.505605444469 | (37.7724733883273, -122.505605444469) | 11 | 6 | 2 | 55 | 26 | ||
88163 | 47405 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45316 | 5993431.14199 | 2111760.19377 | 37.7781129765464 | -122.466294232497 | (37.7781129765464, -122.466294232497) | 11 | 6 | 2 | 54 | 11 | |
88258 | 59129 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1992 12:00:00 AM | 11 | Permit Number 30380 | 5992485.89514 | 2112129.74225 | 37.7790730716469 | -122.46959106216 | (37.7790730716469, -122.46959106216) | 11 | 6 | 2 | 54 | 11 | ||
91433 | 67384 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 632 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | 8 | Permit Number 30880 | 5992568.1848 | 2111126.41775 | 37.7763229702913 | -122.469233345827 | (37.7763229702913, -122.469233345827) | 11 | 6 | 2 | 54 | 11 | |
91585 | 47461 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1818 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45366 | 6000024.69468 | 2115221.29089 | 37.787994486693 | -122.443733540863 | (37.787994486693, -122.443733540863) | 13 | 6 | 1 | 29490 | 27 | |
91856 | 56379 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191@ 23rd Ave 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2012 12:00:00 AM | 2 | Permit Number 769038 | 5988661.1856 | 2114079.0461 | 37.7842035193233 | -122.482965030995 | (37.7842035193233, -122.482965030995) | 11 | 6 | 2 | 55 | 26 | ||
93890 | 81627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 351 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990871.84274 | 2113035.63499 | 37.7814669864176 | -122.475240820306 | (37.7814669864176, -122.475240820306) | 11 | 6 | 2 | 54 | 26 | |||
95151 | 42138 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 579 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 8 | Permit Number 42433 | 5991254.31627 | 2111466.88915 | 37.7771818025968 | -122.473803180798 | (37.7771818025968, -122.473803180798) | 11 | 6 | 2 | 54 | 26 | |
102384 | 37595 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 681 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773784 | 5992529.93541662 | 2110827.20816005 | 37.7754992113625 | -122.469343875957 | (37.7754992113625, -122.469343875957) | 11 | 6 | 2 | 54 | 11 | |
103104 | 37660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | 4 | Permit Number 47116 | 5991908.79894 | 2112136.43002 | 37.7790580641946 | -122.471587940685 | (37.7790580641946, -122.471587940685) | 11 | 6 | 2 | 54 | 11 | |
111195 | 66496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 6 | Permit Number 29657 | 6001602.2551 | 2113943.9812 | 37.7845771738803 | -122.438183936989 | (37.7845771738803, -122.438183936989) | 15 | 6 | 11 | 29490 | 13 | |
113554 | 68676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 233 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32585 | 5992731.02851 | 2113895.02943 | 37.783934233118 | -122.468871549364 | (37.783934233118, -122.468871549364) | 11 | 6 | 2 | 54 | 11 | |
115511 | 68221 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1320 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 8 | Permit Number 32011 | 5991372.40112 | 2113442.77696 | 37.7826138859717 | -122.473538854201 | (37.7826138859717, -122.473538854201) | 11 | 6 | 2 | 54 | 26 | |
117323 | 67317 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 715 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1992 12:00:00 AM | 11 | Permit Number 30798 | 5992850.64132 | 2110569.51812 | 37.7748101916189 | -122.468215736984 | (37.7748101916189, -122.468215736984) | 11 | 6 | 2 | 54 | 11 | |
124643 | 95601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 131 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2011 12:00:00 AM | 2 | Permit Number 767201 | 5990817.89228 | 2114523.5069 | 37.78554914201 | -122.475536133375 | (37.78554914201, -122.475536133375) | 11 | 6 | 2 | 54 | 26 | ||
126095 | 51650 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 570 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47934 | 5982893.41884075 | 2111911.16830587 | 37.7779138636534 | -122.502758598437 | (37.7779138636534, -122.502758598437) | 11 | 6 | 2 | 55 | 26 | |||
133995 | 38086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2501 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.7849591037257 | -122.441572302214 | (37.7849591037257, -122.441572302214) | 15 | 6 | 11 | 29490 | 13 | ||
134127 | 41592 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 829 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42101 | 5987864.02178214 | 2110316.45521242 | 37.7738260885282 | -122.485446695956 | (37.7738260885282, -122.485446695956) | 11 | 6 | 2 | 55 | 26 | |||
134790 | 41374 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2918 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | Permit Number 42011 | 5989628.92991844 | 2111970.3143396 | 37.7784697940849 | -122.479462685957 | (37.7784697940849, -122.479462685957) | 11 | 6 | 2 | 55 | 26 | |||
143792 | 37596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 681 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773784 | 5992531.87149 | 2110821.51751 | 37.7754836982564 | -122.469336764375 | (37.7754836982564, -122.469336764375) | 11 | 6 | 2 | 54 | 11 | |
149295 | 56328 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 770 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1973 12:00:00 AM | 1 | Permit Number 12464 | 5991021.31096 | 2110150.29677 | 37.7735533016924 | -122.47451310498 | (37.7735533016924, -122.47451310498) | 11 | 6 | 2 | 54 | 26 | ||
154025 | 41945 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 653 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42303 | 5993457.88058 | 2111001.78107 | 37.7760321220276 | -122.466146606961 | (37.7760321220276, -122.466146606961) | 11 | 6 | 2 | 54 | 11 | |
156485 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 4355 ANZA ST | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | 11 | 6 | 2 | 55 | 26 | ||||
159703 | 42139 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 583 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 5 | Permit Number 42434 | 5991253.84873 | 2111457.82315 | 37.7771568827635 | -122.4738041366 | (37.7771568827635, -122.4738041366) | 11 | 6 | 2 | 54 | 26 | |
162025 | 67376 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 924 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 3 | Permit Number 30871 | 5992711.29916 | 2111406.94821 | 37.7771014998466 | -122.468758695805 | (37.7771014998466, -122.468758695805) | 11 | 6 | 2 | 54 | 11 | |
173146 | 47404 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 522 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2013 12:00:00 AM | 1 | Permit Number 771051 | 5993469.13316 | 2111905.11444 | 37.7785130815905 | -122.466173342611 | (37.7785130815905, -122.466173342611) | 11 | 6 | 2 | 54 | 11 | |
174474 | 47462 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1818 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 7 | Permit Number 45366 | 6000023.68636 | 2115243.51305 | 37.788055445441 | -122.443738626559 | (37.788055445441, -122.443738626559) | 13 | 6 | 1 | 29490 | 27 | |
178014 | 48687 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
180135 | 47097 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 108 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | 15 | 6 | 2 | 54 | 16 | ||
182782 | 56166 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 623 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12274 | 5990937.74428 | 2111139.59084 | 37.7762647906594 | -122.474874396612 | (37.7762647906594, -122.474874396612) | 11 | 6 | 2 | 54 | 26 | ||
183879 | 51750 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | 6 | Permit Number 48020 | 5989629.76736 | 2112987.41168 | 37.7812625086441 | -122.4795342239 | (37.7812625086441, -122.4795342239) | 11 | 6 | 2 | 55 | 26 | ||
185481 | 36988 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39609 | 5993070.986847 | 2113501.00043119 | 37.7828719719487 | -122.467666762888 | (37.7828719719487, -122.467666762888) | 11 | 6 | 2 | 54 | 11 | ||
188358 | 64226 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | Permit Number 32010 | 5991523.10149866 | 2113391.31438149 | 37.7824813099729 | -122.473013746659 | (37.7824813099729, -122.473013746659) | 11 | 6 | 2 | 54 | 26 | ||
188581 | 50218 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2536 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 2 | Permit Number 46925 | 5987649.93004 | 2111223.20837 | 37.7763033030168 | -122.486253845001 | (37.7763033030168, -122.486253845001) | 11 | 6 | 2 | 55 | 26 | |
27990 | 7136 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 336X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | ||
60250 | 2768 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 238 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 7 | 3X3 | 5994792.46278 | 2110798.98024 | 37.7755521919136 | -122.461515261652 | (37.7755521919136, -122.461515261652) | 11 | 6 | 2 | 54 | 11 | ||
84308 | 2781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3X3 | 5994323.8414 | 2110783.97336 | 37.775484002867 | -122.463135234951 | (37.775484002867, -122.463135234951) | 11 | 6 | 2 | 54 | 11 | ||
87691 | 2766 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 238 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/17/2016 07:20:00 AM | 3 | 3X3 | 5994832.64296 | 2110801.15039 | 37.775560463187 | -122.461376427046 | (37.775560463187, -122.461376427046) | 11 | 6 | 2 | 54 | 11 | ||
111908 | 1674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 210 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 3 | 3X3 | 5994926.2487 | 2111484.88343 | 37.7774431994746 | -122.461102194735 | (37.7774431994746, -122.461102194735) | 11 | 6 | 2 | 54 | 11 | ||
126010 | 2780 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3X3 | 5994352.48624 | 2110783.72462 | 37.7754849699587 | -122.46303612831 | (37.7754849699587, -122.46303612831) | 11 | 6 | 2 | 54 | 11 | ||
129472 | 19295 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 6 | 3X3 | 5995238.34395 | 2110816.54883 | 37.7756260846481 | -122.459974134414 | (37.7756260846481, -122.459974134414) | 11 | 6 | 2 | 54 | 11 | ||
130500 | 18913 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.7895937169197 | -122.436453930026 | (37.7895937169197, -122.436453930026) | 13 | 6 | 1 | 29490 | 27 | |||
147510 | 7141 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5994485.13476 | 2110733.5683 | 37.7753548940822 | -122.462573629796 | (37.7753548940822, -122.462573629796) | 11 | 6 | 2 | 54 | 11 | |||
162249 | 2779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2016 07:24:00 AM | 3 | 3X3 | 5994373.0105 | 2110784.17458 | 37.7754873876631 | -122.462965163182 | (37.7754873876631, -122.462965163182) | 11 | 6 | 2 | 54 | 11 | ||
1304 | 91006 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5988072.26413 | 2111179.36369 | 37.7762075240837 | -122.484789675521 | (37.7762075240837, -122.484789675521) | 11 | 6 | 2 | 55 | 26 | ||
2248 | 90191 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1860X Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.44542 | 37.7766336380006 | -122.478900695137 | (37.7766336380006, -122.478900695137) | 11 | 6 | 2 | 55 | 26 | |||
3255 | 72399 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 794-798 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769948 | 5990094.17599 | 2109997.03923 | 37.7730787370976 | -122.477708963104 | (37.7730787370976, -122.477708963104) | 11 | 6 | 2 | 55 | 26 |
6040 | 90220 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987751.08815 | 2111228.00123 | 37.7763223582458 | -122.485904267418 | (37.7763223582458, -122.485904267418) | 11 | 6 | 2 | 55 | 26 | ||
7259 | 90542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 632 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993688.832385 | 2110751.462082 | 37.7753581349738 | -122.465329502856 | (37.7753581349738, -122.465329502856) | 11 | 6 | 2 | 54 | 11 | ||
13516 | 90326 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989640.77384 | 2111238.69513 | 37.7764616586133 | -122.479368175716 | (37.7764616586133, -122.479368175716) | 11 | 6 | 2 | 55 | 26 | ||
14055 | 90182 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990417.75212 | 2111322.65396 | 37.7767372842601 | -122.476686550978 | (37.7767372842601, -122.476686550978) | 11 | 6 | 2 | 55 | 26 | ||
14415 | 72426 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4250X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | Permit Number 773790 | 5990138.03134 | 2109951.66223 | 37.7729566892672 | -122.47755394624 | (37.7729566892672, -122.47755394624) | 11 | 6 | 2 | 55 | 26 | |
15156 | 90172 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990908.22712 | 2111337.09849 | 37.7768053819444 | -122.474990924283 | (37.7768053819444, -122.474990924283) | 11 | 6 | 2 | 54 | 26 | ||
17626 | 90350 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992328.99634 | 2111334.95536 | 37.7768817336944 | -122.470075945794 | (37.7768817336944, -122.470075945794) | 11 | 6 | 2 | 54 | 11 | ||
23082 | 96956 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988378.9117 | 2110569.83713 | 37.7745517889402 | -122.483684211452 | (37.7745517889402, -122.483684211452) | 11 | 6 | 2 | 55 | 26 | ||
23880 | 96952 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782532 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | 11 | 6 | 2 | 55 | 26 | |
26608 | 90340 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990615.55567 | 2111280.455278 | 37.7766328895552 | -122.475999214233 | (37.7766328895552, -122.475999214233) | 11 | 6 | 2 | 55 | 26 | ||
28197 | 91005 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2415 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988054.23451 | 2111177.58374 | 37.776201586759 | -122.4848519135 | (37.776201586759, -122.4848519135) | 11 | 6 | 2 | 55 | 26 | ||
28349 | 90183 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990402.31364 | 2111319.28606 | 37.776727141439 | -122.476739710576 | (37.776727141439, -122.476739710576) | 11 | 6 | 2 | 55 | 26 | ||
28930 | 90335 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.830083 | 2111264.66899 | 37.7765642703859 | -122.477505345978 | (37.7765642703859, -122.477505345978) | 11 | 6 | 2 | 55 | 26 | ||
30286 | 90215 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2434 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987937.95416 | 2111227.93997 | 37.7763330776559 | -122.485257849615 | (37.7763330776559, -122.485257849615) | 11 | 6 | 2 | 55 | 26 | ||
31142 | 90343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990837.83753 | 2111277.85575 | 37.7766386380593 | -122.475230094421 | (37.7766386380593, -122.475230094421) | 11 | 6 | 2 | 54 | 26 | ||
31460 | 7681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.55121 | 37.7753907066265 | -122.461904549943 | (37.7753907066265, -122.461904549943) | 11 | 6 | 2 | 54 | 11 | ||
31535 | 101129 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990852.81168 | 2113469.73907 | 37.7826578128527 | -122.475338361197 | (37.7826578128527, -122.475338361197) | 11 | 6 | 2 | 54 | 26 | |||
32632 | 90910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5993421.38614 | 2110692.49557 | 37.7751808014585 | -122.46625036778 | (37.7751808014585, -122.46625036778) | 11 | 6 | 2 | 54 | 11 |
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) );