trees
262 rows where Fire Prevention Districts = 9 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32 | 264850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 172 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007951 | 2093149 | 37.7278379340298 | -122.414747181337 | (37.7278379340298, -122.414747181337) | 9 | 3 | 7 | 309 | 5 | |||
| 1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
| 2532 | 72297 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.434290747523 | (37.7209821527804, -122.434290747523) | 9 | 7 | 6 | 28861 | 5 | |||
| 3696 | 262180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 263 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009676.04228 | 2087903.41357 | 37.713531417046 | -122.408413797613 | (37.713531417046, -122.408413797613) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | |||
| 7204 | 262178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 235 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009840.919 | 2087844.03033 | 37.713377594646 | -122.407839737463 | (37.713377594646, -122.407839737463) | 9 | 7 | 8 | 309 | 39 | ||
| 7695 | 262179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009723.14992 | 2087886.44693 | 37.713487468075 | -122.408249780165 | (37.713487468075, -122.408249780165) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | ||
| 10976 | 262163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | |||
| 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 | ||
| 19771 | 31015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.43661 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | 9 | 7 | 6 | 28861 | 5 | ||
| 19777 | 117430 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.22692 | 2091583.55482 | 37.7233270936563 | -122.427664426683 | (37.7233270936563, -122.427664426683) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 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 | |||
| 27050 | 44420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.7106843218039 | -122.433736745364 | (37.7106843218039, -122.433736745364) | 9 | 7 | 6 | 28861 | 5 | |
| 29323 | 84791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176 | 2090606 | 37.7205292596373 | -122.434529703705 | (37.7205292596373, -122.434529703705) | 9 | 7 | 6 | 28861 | 5 | |||
| 30539 | 67015 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | 9 | 8 | 6 | 28861 | 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 | |||
| 32978 | 66244 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | 9 | 8 | 6 | 28861 | 24 | ||
| 36614 | 40677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 195 Maynard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 1 | Permit Number 774326 | 6004652.68968 | 2093800.00562 | 37.7294395787702 | -122.426195845473 | (37.7294395787702, -122.426195845473) | 9 | 7 | 6 | 28861 | 5 | |
| 37755 | 39665 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41055 | 5993542.26347395 | 2090641.85281267 | 37.7201338116039 | -122.464376148313 | (37.7201338116039, -122.464376148313) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | |
| 40773 | 41963 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46995 | 5993511.89759083 | 2094752.0237459 | 37.73141758734 | -122.464779433581 | (37.73141758734, -122.464779433581) | 9 | 8 | 4 | 59 | 40 | ||
| 43567 | 30935 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.7216856645565 | -122.456226438915 | (37.7216856645565, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
| 44789 | 44020 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2000 12:00:00 AM | Permit Number 43561 | 6001434.84212338 | 2091667.66659412 | 37.7234022554793 | -122.437167620555 | (37.7234022554793, -122.437167620555) | 9 | 7 | 6 | 28861 | 25 | |||
| 48084 | 39666 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | ||
| 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 | |
| 56619 | 67275 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 282 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 8 | Permit Number 30749 | 6004343.26025 | 2091654.32947 | 37.7235305328868 | -122.427112803239 | (37.7235305328868, -122.427112803239) | 9 | 7 | 6 | 28861 | 5 | |
| 63071 | 58747 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30343 | 5995606.37444292 | 2090757.94596432 | 37.7205713407191 | -122.457249650747 | (37.7205713407191, -122.457249650747) | 9 | 8 | 6 | 28861 | 24 | ||
| 76476 | 46258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 22 Leo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44543 | 6001485.63381 | 2091410.0324 | 37.7226977372868 | -122.436973607764 | (37.7226977372868, -122.436973607764) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | ||
| 87941 | 52641 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 171@ LAKEVIEW Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2006 12:00:00 AM | Permit Number 48723 | 5997085.87939987 | 2088850.31270085 | 37.7154182864299 | -122.451997937847 | (37.7154182864299, -122.451997937847) | 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 | |||
| 88778 | 59756 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1981 12:00:00 AM | 15 | Permit Number 19194 | 6003645.40594 | 2091044.70066 | 37.7218171391456 | -122.42948170562 | (37.7218171391456, -122.42948170562) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 106652 | 108684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.7153792289568 | -122.440813996186 | (37.7153792289568, -122.440813996186) | 9 | 7 | 6 | 28861 | 5 | |
| 112357 | 52984 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | Permit Number 49125 | 5994735.92329309 | 2091572.62185735 | 37.7227582139901 | -122.460317500192 | (37.7227582139901, -122.460317500192) | 9 | 8 | 4 | 28861 | 24 | |||
| 113126 | 65476 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/1992 12:00:00 AM | Permit Number 28357 | 5994791.83411089 | 2091786.89258453 | 37.7233497659919 | -122.460139745717 | (37.7233497659919, -122.460139745717) | 9 | 8 | 4 | 28861 | 24 | ||
| 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 | ||
| 133236 | 35731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Dunsmuir St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39008 | 6008063.83773317 | 2094291.11517944 | 37.7309802758886 | -122.414437878529 | (37.7309802758886, -122.414437878529) | 9 | 3 | 7 | 309 | 28 | ||
| 135849 | 65483 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28367 | 5994794.44790156 | 2091930.41721855 | 37.7237440004853 | -122.460141103458 | (37.7237440004853, -122.460141103458) | 9 | 8 | 4 | 28861 | 24 | ||
| 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 | ||
| 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 | ||
| 138025 | 31017 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 143396 | 84789 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176 | 2090606 | 37.7205292596373 | -122.434529703705 | (37.7205292596373, -122.434529703705) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 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 | ||
| 148740 | 42130 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2011 12:00:00 AM | Permit Number 767992 | 5998983.29782445 | 2093814.78501268 | 37.7291580818069 | -122.445796466287 | (37.7291580818069, -122.445796466287) | 9 | 7 | 4 | 28861 | 40 | |||
| 151895 | 35732 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39008 | 6008063.83773317 | 2094291.11517944 | 37.7309802758886 | -122.414437878529 | (37.7309802758886, -122.414437878529) | 9 | 3 | 7 | 309 | 28 | ||
| 155694 | 31037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.432988809779 | (37.7114464558494, -122.432988809779) | 9 | 7 | 6 | 28861 | 5 | |
| 156725 | 35729 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Dunsmuir St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39008 | 6008063.83773317 | 2094291.11517944 | 37.7309802758886 | -122.414437878529 | (37.7309802758886, -122.414437878529) | 9 | 3 | 7 | 309 | 28 | ||
| 173274 | 67306 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773656 | 5997299.10481202 | 2090605.17719866 | 37.7202489476622 | -122.451387434099 | (37.7202489476622, -122.451387434099) | 9 | 8 | 6 | 28861 | 24 | ||
| 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 | |
| 176884 | 39667 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | ||
| 177363 | 44431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.7104965784279 | -122.434087529513 | (37.7104965784279, -122.434087529513) | 9 | 7 | 6 | 28861 | 5 | |
| 182996 | 31016 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |
| 191324 | 30936 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.99468 | 2091121.8923 | 37.7215880844914 | -122.456226438915 | (37.7215880844914, -122.456226438915) | 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 | |||
| 25043 | 253081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
| 30263 | 253080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
| 176058 | 81911 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3X3 | Permit Number 49718 | 5996247.30096369 | 2090708.70815365 | 37.7204729351862 | -122.455030627418 | (37.7204729351862, -122.455030627418) | 9 | 8 | 6 | 28861 | 24 | ||
| 2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
| 8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
| 13251 | 262414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6003118 | 2094425 | 37.7310688083977 | -122.431546013106 | (37.7310688083977, -122.431546013106) | 9 | 7 | 5 | 28861 | 25 | |
| 20834 | 251731 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 749 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:28:00 AM | 3 | 3x3 | 6002542 | 2087174 | 37.7111265141547 | -122.433019485161 | (37.7111265141547, -122.433019485161) | 9 | 7 | 6 | 28861 | 5 | ||
| 21319 | 91088 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207 | 2088751 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | 9 | 8 | 6 | 64 | 24 | ||
| 27608 | 251772 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 29548 | 251781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070 | 2087245 | 37.7112378586553 | -122.438112149268 | (37.7112378586553, -122.438112149268) | 9 | 7 | 6 | 28861 | 5 | ||
| 30876 | 88307 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 9 | 7 | 6 | 28861 | 5 | ||
| 33032 | 95765 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767501 | 6004737 | 2091251 | 37.7224453364084 | -122.425723020763 | (37.7224453364084, -122.425723020763) | 9 | 7 | 6 | 28861 | 5 | |
| 40210 | 84682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | 9 | 8 | 6 | 28861 | 24 | ||
| 44074 | 254618 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781521 | 6003337.103 | 2094600.11874 | 37.73156206108 | -122.430801029135 | (37.73156206108, -122.430801029135) | 9 | 7 | 5 | 28861 | 25 |
| 45628 | 251771 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 46531 | 251773 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | ||
| 53756 | 251780 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001110 | 2087312 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |
| 61468 | 95763 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 417 Moscow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004111.77372 | 2090686.36945 | 37.7208596345484 | -122.42784407255 | (37.7208596345484, -122.42784407255) | 9 | 7 | 6 | 28861 | 5 |
| 63637 | 95714 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 649 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767469 | 6004402.3 | 2092291.6 | 37.7252836757454 | -122.426954078943 | (37.7252836757454, -122.426954078943) | 9 | 7 | 6 | 28861 | 5 | |
| 64302 | 108554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
| 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 | |
| 72474 | 108891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.224 | 37.7307509423916 | -122.447388264722 | (37.7307509423916, -122.447388264722) | 9 | 7 | 4 | 59 | 40 | |
| 72729 | 15860 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.443454540602 | (37.7139670145471, -122.443454540602) | 9 | 7 | 6 | 28861 | 25 | |||
| 73815 | 117002 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.7322457718664 | -122.438893830128 | (37.7322457718664, -122.438893830128) | 9 | 7 | 4 | 63 | 40 | |
| 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 | |
| 80662 | 88308 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 9 | 7 | 6 | 28861 | 5 | ||
| 82021 | 88310 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 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 | ||
| 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 |
| 87911 | 251759 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 248 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001757 | 2086582 | 37.7094564535298 | -122.43569030601 | (37.7094564535298, -122.43569030601) | 9 | 7 | 6 | 28861 | 5 | ||||
| 91286 | 84679 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49720 | 5996250.33825299 | 2090885.9667732 | 37.7209598197785 | -122.455032930449 | (37.7209598197785, -122.455032930449) | 9 | 8 | 6 | 28861 | 24 | ||
| 111574 | 88309 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 Amazon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | 9 | 7 | 6 | 28861 | 5 | ||
| 116488 | 108888 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772760 | 5997727.10617 | 2094743.09717 | 37.7316352013333 | -122.450206090909 | (37.7316352013333, -122.450206090909) | 9 | 7 | 4 | 59 | 40 | |
| 122709 | 108553 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
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) );