trees
467 rows where Police Districts = 7 and qSpecies_id = 8
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 30925 | 176229 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001482.8368 | 2089045.33875 | 37.7162046599834 | -122.43681408062 | (37.7162046599834, -122.43681408062) | 9 | 7 | 6 | 28861 | 5 | |||
| 31379 | 251733 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
| 31475 | 176232 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | 9 | 7 | 6 | 28861 | 5 | |||
| 31788 | 64128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 627 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24899 | 6002528.44281747 | 2098851.45130448 | 37.7431893908467 | -122.433900486749 | (37.7431893908467, -122.433900486749) | 2 | 7 | 5 | 63 | 7 | ||
| 31809 | 223570 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007482.05364 | 2095699.08707 | 37.7348135594986 | -122.416548907823 | (37.7348135594986, -122.416548907823) | 2 | 7 | 7 | 28859 | 2 | |||
| 31891 | 63321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1987 12:00:00 AM | Permit Number 23894 | 6009704.28478725 | 2099627.84542916 | 37.7457258041449 | -122.409142988334 | (37.7457258041449, -122.409142988334) | 2 | 7 | 7 | 28859 | 2 | ||
| 32261 | 223373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Bosworth St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6003068.252 | 2095170.80318 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | 2 | 7 | 5 | 28861 | 25 | ||||
| 32619 | 223416 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 418 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009155.95431 | 2100059.10664 | 37.7468792184109 | -122.411069498672 | (37.7468792184109, -122.411069498672) | 2 | 7 | 7 | 28859 | 2 | |||
| 32770 | 60516 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20119 | 6004763.14449697 | 2099853.52664846 | 37.7460674222913 | -122.42624480255 | (37.7460674222913, -122.42624480255) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | |
| 33240 | 63451 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1987 12:00:00 AM | 3x7 | Permit Number 24039 | 6007051.75115976 | 2095783.35007581 | 37.7350207178849 | -122.418042587516 | (37.7350207178849, -122.418042587516) | 2 | 7 | 7 | 28859 | 2 | |
| 33669 | 96929 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.7334451019942 | -122.429455740482 | (37.7334451019942, -122.429455740482) | 2 | 7 | 5 | 28861 | 25 | ||
| 34014 | 223422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 356 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008795.6118 | 2100034.66543 | 37.7467918942422 | -122.412313806947 | (37.7467918942422, -122.412313806947) | 2 | 7 | 7 | 28859 | 2 | |||
| 35633 | 246625 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3300 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 1 | 6009033.3388 | 2099395.8346 | 37.7450511430894 | -122.411446641942 | (37.7450511430894, -122.411446641942) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | |
| 37052 | 223427 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008897.95249 | 2100223.67255 | 37.747316608191 | -122.411973275956 | (37.747316608191, -122.411973275956) | 2 | 7 | 7 | 28859 | 2 | |||
| 38375 | 115384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
| 38466 | 49860 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
| 38540 | 223557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 443 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007525.59802 | 2096829.0318 | 37.737918588483 | -122.416478372193 | (37.737918588483, -122.416478372193) | 2 | 7 | 7 | 28859 | 2 | |||
| 38592 | 45299 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
| 39029 | 103456 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003658 | 2091068 | 37.721881827041 | -122.429439831937 | (37.721881827041, -122.429439831937) | 9 | 7 | 6 | 28861 | 5 | ||||
| 40532 | 223443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Day St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003241.07095 | 2098648.16117 | 37.742671617906 | -122.431421899403 | (37.742671617906, -122.431421899403) | 2 | 7 | 5 | 63 | 22 | |||
| 40764 | 207590 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5998520.92157 | 2094401.97974 | 37.7307439689499 | -122.447437181086 | (37.7307439689499, -122.447437181086) | 9 | 7 | 4 | 59 | 40 | |||
| 42001 | 223564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.411350181559 | (37.7408301058168, -122.411350181559) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 43045 | 63309 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1987 12:00:00 AM | Permit Number 23875 | 6009653.46041158 | 2099624.96602916 | 37.7457150505348 | -122.409318529175 | (37.7457150505348, -122.409318529175) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 43621 | 223578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006732.92847 | 2098549.7578 | 37.7425987089604 | -122.419341059038 | (37.7425987089604, -122.419341059038) | 2 | 7 | 7 | 28859 | 2 | |||
| 43995 | 67217 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30673 | 6007859.73782149 | 2096940.24415247 | 37.7382427386023 | -122.415330954317 | (37.7382427386023, -122.415330954317) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 |
| 44380 | 180623 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 755 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:23:00 AM | 3 | Width 6ft | 6002495.21129 | 2087156.55582 | 37.7110759621502 | -122.433179952615 | (37.7110759621502, -122.433179952615) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 45479 | 108934 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591 | (37.7386556931549, -122.42007742591) | 2 | 7 | 7 | 28859 | 2 |
| 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 | ||||
| 45695 | 64260 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25062 | 6009914.7515977 | 2100087.93471467 | 37.7470008969248 | -122.408447669408 | (37.7470008969248, -122.408447669408) | 2 | 7 | 7 | 28859 | 2 | ||
| 45743 | 161753 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022 | 2087749 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | 9 | 7 | 6 | 28861 | 5 | |
| 46051 | 207593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998975.03938 | 2093802.03245 | 37.7291225947148 | -122.445824099527 | (37.7291225947148, -122.445824099527) | 9 | 7 | 4 | 28861 | 40 | |||
| 46240 | 49866 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
| 46342 | 223655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003599.33439 | 2095266.26783 | 37.733406009884 | -122.429941944474 | (37.733406009884, -122.429941944474) | 2 | 7 | 5 | 28861 | 25 | |||
| 46350 | 223481 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007869.12634 | 2096919.97239 | 37.7381876044595 | -122.415297058717 | (37.7381876044595, -122.415297058717) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 48911 | 32226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1524 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 10 | Permit Number 35545 | 6008720.30382 | 2099880.58736 | 37.7463646038601 | -122.412563325657 | (37.7463646038601, -122.412563325657) | 2 | 7 | 7 | 28859 | 2 | |
| 49203 | 63377 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23957 | 6006914.1385317 | 2095742.66094638 | 37.7349012482628 | -122.418515480064 | (37.7349012482628, -122.418515480064) | 2 | 7 | 7 | 28859 | 2 | ||
| 49346 | 223656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 18811 | 6003648.75382 | 2095269.66073 | 37.7334181246305 | -122.429771329596 | (37.7334181246305, -122.429771329596) | 2 | 7 | 5 | 28861 | 25 | ||
| 49362 | 63315 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23882 | 6009191.36429374 | 2100247.35620947 | 37.7473980957636 | -122.410960347715 | (37.7473980957636, -122.410960347715) | 2 | 7 | 7 | 28859 | 2 | ||
| 50209 | 97899 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
| 50524 | 207695 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.7244713658451 | -122.456366191771 | (37.7244713658451, -122.456366191771) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |
| 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 | |
| 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 | |||
| 51053 | 58102 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23965 | 6006689.2765112 | 2095813.61990221 | 37.7350834242778 | -122.41929794049 | (37.7350834242778, -122.41929794049) | 2 | 7 | 7 | 28859 | 2 | ||
| 51168 | 96928 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.7334451019942 | -122.429455740482 | (37.7334451019942, -122.429455740482) | 2 | 7 | 5 | 28861 | 25 | ||
| 51264 | 49857 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
| 51931 | 223568 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007653.2155 | 2095688.14958 | 37.7347931520797 | -122.415956366103 | (37.7347931520797, -122.415956366103) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 53500 | 223412 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009299.39544 | 2099281.89074 | 37.7447531977014 | -122.410518617161 | (37.7447531977014, -122.410518617161) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 53859 | 63380 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23960 | 6006871.71117456 | 2095746.20400929 | 37.7349085881089 | -122.41866241779 | (37.7349085881089, -122.41866241779) | 2 | 7 | 7 | 28859 | 2 | ||
| 55466 | 52669 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 346@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2006 12:00:00 AM | Permit Number 48750 | 6004271.44295602 | 2099877.18374076 | 37.7461045741604 | -122.427946728117 | (37.7461045741604, -122.427946728117) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |
| 57067 | 223583 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006884.54394 | 2096272.57358 | 37.7363546053711 | -122.418655365578 | (37.7363546053711, -122.418655365578) | 2 | 7 | 7 | 28859 | 2 | |||
| 57637 | 63381 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 289 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23961 | 6006861.89612331 | 2095799.20465588 | 37.7350535636056 | -122.418700109332 | (37.7350535636056, -122.418700109332) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |
| 59464 | 223477 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006251.94836 | 2095849.23921 | 37.7351565869995 | -122.420812471312 | (37.7351565869995, -122.420812471312) | 2 | 7 | 7 | 28859 | 2 | |||
| 59875 | 223439 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003417.4163 | 2098613.92622 | 37.7425876095457 | -122.430809705719 | (37.7425876095457, -122.430809705719) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |
| 59905 | 49865 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
| 60323 | 64125 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 623 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24896 | 6002552.88374737 | 2098852.79748639 | 37.7431944740998 | -122.433816072766 | (37.7431944740998, -122.433816072766) | 2 | 7 | 5 | 63 | 7 | ||
| 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 |
| 61714 | 223582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 57 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008286.43047 | 2100056.77298 | 37.7468240108166 | -122.414076076165 | (37.7468240108166, -122.414076076165) | 2 | 7 | 7 | 28859 | 2 | |||
| 62074 | 223520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 78 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004976.40139 | 2096163.67746 | 37.7359479859053 | -122.425244869978 | (37.7359479859053, -122.425244869978) | 2 | 7 | 5 | 28859 | 2 | |||
| 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 | |
| 62521 | 223577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6007069.07199 | 2097998.10728 | 37.7411029259504 | -122.418139669131 | (37.7411029259504, -122.418139669131) | 2 | 7 | 7 | 28859 | 2 | |||
| 63011 | 102695 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000881 | 2096712 | 37.7372213335044 | -122.439443565515 | (37.7372213335044, -122.439443565515) | 2 | 7 | 5 | 63 | 7 | |||
| 63475 | 246471 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Duncan St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6004508.79253 | 2099888.97742 | 37.7461503817506 | -122.427126843434 | (37.7461503817506, -122.427126843434) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |
| 64127 | 251732 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:20:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
| 64284 | 223521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 793 27th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001408.82629 | 2099966.50087 | 37.7461874535894 | -122.437851664431 | (37.7461874535894, -122.437851664431) | 2 | 7 | 5 | 63 | 22 | |||
| 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 |
| 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 | |
| 64743 | 223374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 14 Lundys Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007165.43911 | 2099578.09983 | 37.7454466559323 | -122.417918440397 | (37.7454466559323, -122.417918440397) | 2 | 7 | 7 | 28859 | 2 | |||
| 65530 | 176226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 915 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002121.3261 | 2088534.63061 | 37.7148386356627 | -122.434570661505 | (37.7148386356627, -122.434570661505) | 9 | 7 | 6 | 28861 | 5 | |||
| 65784 | 224099 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6003688.86609 | 2098162.22587 | 37.7413627203269 | -122.429838900151 | (37.7413627203269, -122.429838900151) | 2 | 7 | 5 | 63 | 7 | |||
| 66970 | 223659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 18811 | 6003694.10013 | 2095275.57225 | 37.7334369240608 | -122.429614976149 | (37.7334369240608, -122.429614976149) | 2 | 7 | 5 | 28861 | 25 | ||
| 68615 | 246490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6004063.56102 | 2099816.02709 | 37.7459248893202 | -122.428661198349 | (37.7459248893202, -122.428661198349) | 2 | 7 | 5 | 63 | 22 | |||
| 68862 | 223569 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007635.55401 | 2095689.61237 | 37.7347961756026 | -122.416017531695 | (37.7347961756026, -122.416017531695) | 2 | 7 | 7 | 28859 | 2 | |||
| 69103 | 63370 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1987 12:00:00 AM | 8 | 3x3 | Permit Number 23949 | 6007368.29978773 | 2095756.91555198 | 37.7349659457424 | -122.416946291173 | (37.7349659457424, -122.416946291173) | 2 | 7 | 7 | 28859 | 2 | |
| 69377 | 180634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:16:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
| 69549 | 63385 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 219 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23966 | 6006529.47672641 | 2095826.96456486 | 37.7351110645595 | -122.419851373342 | (37.7351110645595, -122.419851373342) | 2 | 7 | 7 | 28859 | 2 | ||
| 69865 | 207591 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 207 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999361.39835 | 2094045.00117 | 37.7298117829776 | -122.444505884965 | (37.7298117829776, -122.444505884965) | 9 | 7 | 4 | 28861 | 40 | |||
| 70626 | 223482 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4044 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008350.87212 | 2096284.49377 | 37.7364697824441 | -122.413586482552 | (37.7364697824441, -122.413586482552) | 10 | 7 | 7 | 28859 | 2 | |||
| 70702 | 64142 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 387 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24915 | 6003450.8356786 | 2098610.10956553 | 37.7425790233006 | -122.430693879032 | (37.7425790233006, -122.430693879032) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | |
| 71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
| 72272 | 45790 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2001 12:00:00 AM | Permit Number 44428 | 6003953.11185898 | 2099806.69128577 | 37.7458930039208 | -122.429042450873 | (37.7458930039208, -122.429042450873) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |
| 72623 | 223539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6003387.19904 | 2098534.72149 | 37.7423684195723 | -122.430908536723 | (37.7423684195723, -122.430908536723) | 2 | 7 | 5 | 63 | 22 | |||
| 72718 | 64414 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25261 | 6003697.20020727 | 2098175.28884646 | 37.741399060208 | -122.429811015213 | (37.741399060208, -122.429811015213) | 2 | 7 | 5 | 63 | 7 |
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) );