trees
312 rows where Police Districts = 8 and qSpecies_id = 8 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 908 | 207538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993510.99578 | 2106611.92865 | 37.7639818164203 | -122.465643867796 | (37.7639818164203, -122.465643867796) | 1 | 8 | 11 | 56 | 12 | |||
| 2408 | 162789 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 237 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996026.23717 | 2090535.13208 | 37.71998365171 | -122.455782228671 | (37.71998365171, -122.455782228671) | 9 | 8 | 6 | 28861 | 24 | |||
| 5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
| 8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
| 11818 | 207596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994790.18426 | 2091971.80036 | 37.7238573834024 | -122.460158838768 | (37.7238573834024, -122.460158838768) | 9 | 8 | 4 | 28861 | 24 | |||
| 12056 | 207640 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.90266 | 2104824.95669 | 37.7589974714712 | -122.47017288688 | (37.7589974714712, -122.47017288688) | 1 | 8 | 4 | 56 | 12 | |||
| 12755 | 214559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1342 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | 11 | 8 | 11 | 56 | 12 | ||
| 16907 | 207595 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 506 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994790.50669 | 2091956.97642 | 37.7238166989736 | -122.460156650725 | (37.7238166989736, -122.460156650725) | 9 | 8 | 4 | 28861 | 24 | |||
| 17745 | 207576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1245 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993280.81145 | 2107003.85945 | 37.7650446756837 | -122.466468488529 | (37.7650446756837, -122.466468488529) | 11 | 8 | 11 | 56 | 12 | |||
| 18581 | 207557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 438 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993090.30731 | 2105981.36839 | 37.7622261896015 | -122.467053045158 | (37.7622261896015, -122.467053045158) | 1 | 8 | 11 | 56 | 12 | |||
| 19415 | 207567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993332.90632 | 2105478.86698 | 37.7608604521776 | -122.466177475135 | (37.7608604521776, -122.466177475135) | 1 | 8 | 4 | 56 | 12 | |||
| 20143 | 207679 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990677.2269 | 2100653.21825 | 37.7474569149997 | -122.475009933665 | (37.7474569149997, -122.475009933665) | 1 | 8 | 4 | 29491 | 40 | |||
| 20515 | 216642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.47656 | 37.7191402755735 | -122.45402201442 | (37.7191402755735, -122.45402201442) | 9 | 8 | 6 | 28861 | 24 | ||
| 20570 | 207594 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 234 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995665.54592 | 2091502.05532 | 37.7226178864794 | -122.457098912592 | (37.7226178864794, -122.457098912592) | 9 | 8 | 4 | 28861 | 24 | |||
| 22702 | 207672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993147.42915 | 2105300.29395 | 37.76035943445 | -122.466805971728 | (37.76035943445, -122.466805971728) | 1 | 8 | 4 | 56 | 12 | |||
| 24820 | 207648 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992116.65286 | 2104730.33527 | 37.7587349341825 | -122.470329406704 | (37.7587349341825, -122.470329406704) | 1 | 8 | 4 | 56 | 12 | |||
| 24915 | 207606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995896.38015 | 2090348.10443 | 37.7194626645441 | -122.456217581487 | (37.7194626645441, -122.456217581487) | 9 | 8 | 6 | 28861 | 24 | |||
| 25131 | 185158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.493801554637 | (37.7388527871834, -122.493801554637) | 1 | 8 | 3 | 29491 | 35 | |||
| 26247 | 207604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 146 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996244.76197 | 2090857.98578 | 37.7208826706709 | -122.45505018502 | (37.7208826706709, -122.45505018502) | 9 | 8 | 6 | 28861 | 24 | |||
| 26966 | 207618 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993529.31712 | 2090633.69129 | 37.720110655762 | -122.464420306879 | (37.720110655762, -122.464420306879) | 9 | 8 | 6 | 64 | 24 | |||
| 31050 | 162895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 989 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:58:00 AM | 3 | Width 0ft | 5995899.78819 | 2090467.68802 | 37.7197912084714 | -122.45621444284 | (37.7197912084714, -122.45621444284) | 9 | 8 | 6 | 28861 | 24 | ||
| 31204 | 207694 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991855.32533 | 2096348.4574 | 37.7357053452243 | -122.470622695389 | (37.7357053452243, -122.470622695389) | 1 | 8 | 4 | 59 | 40 | |||
| 32065 | 216902 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 174 Bright St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.463442003639 | (37.7138937098892, -122.463442003639) | 9 | 8 | 6 | 64 | 24 | ||
| 32358 | 207561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992400.09167 | 2105443.15658 | 37.7607085377924 | -122.469401040143 | (37.7607085377924, -122.469401040143) | 1 | 8 | 4 | 56 | 12 | |||
| 32991 | 207674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993300.45868 | 2105307.6542 | 37.7603884744706 | -122.466277253113 | (37.7603884744706, -122.466277253113) | 1 | 8 | 4 | 56 | 12 | |||
| 36200 | 207691 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992956.08252 | 2099027.95475 | 37.7431261613357 | -122.46701172672 | (37.7431261613357, -122.46701172672) | 1 | 8 | 4 | 59 | 40 | |||
| 36740 | 207701 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 San Jacinto Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993894.77182 | 2095194.29652 | 37.7326540264533 | -122.463487860092 | (37.7326540264533, -122.463487860092) | 9 | 8 | 4 | 59 | 40 | |||
| 36741 | 207621 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993736.2843 | 2088924.46634 | 37.7154294623887 | -122.463580914754 | (37.7154294623887, -122.463580914754) | 9 | 8 | 6 | 64 | 24 | |||
| 38208 | 207601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | 9 | 8 | 6 | 28861 | 24 | |||
| 42776 | 207608 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997723.56116 | 2090176.57785 | 37.7190964093462 | -122.449889363408 | (37.7190964093462, -122.449889363408) | 9 | 8 | 6 | 28861 | 24 | |||
| 43141 | 207571 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993664.12129 | 2104858.25974 | 37.7591755300323 | -122.464986884242 | (37.7591755300323, -122.464986884242) | 1 | 8 | 4 | 56 | 12 | |||
| 46447 | 175836 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994366.58552 | 2086543.72285 | 37.7089288002067 | -122.46122985489 | (37.7089288002067, -122.46122985489) | 9 | 8 | 6 | 28861 | 25 | |||
| 48490 | 207572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1640 09th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 1 | Width 6ft | 5993421.18819 | 2104299.1531 | 37.7576263578793 | -122.465786433692 | (37.7576263578793, -122.465786433692) | 1 | 8 | 4 | 56 | 12 | |||
| 49306 | 112862 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5990594 | 2098423 | 37.7413284897401 | -122.475134938873 | (37.7413284897401, -122.475134938873) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 50311 | 207583 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 71 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992880.01049 | 2098709.31276 | 37.7422468600076 | -122.467251597511 | (37.7422468600076, -122.467251597511) | 1 | 8 | 4 | 59 | 40 | |||
| 50502 | 207670 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990672.18333 | 2102133.32849 | 37.7515206186011 | -122.475135407975 | (37.7515206186011, -122.475135407975) | 1 | 8 | 4 | 29491 | 12 | |||
| 51578 | 207689 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2686 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990843.09068 | 2097123.05577 | 37.7377736096576 | -122.474178849468 | (37.7377736096576, -122.474178849468) | 1 | 8 | 4 | 29491 | 40 | |||
| 53000 | 207700 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 San Jacinto Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993887.14565 | 2095187.31864 | 37.7326344275184 | -122.463513719208 | (37.7326344275184, -122.463513719208) | 9 | 8 | 4 | 59 | 40 | |||
| 56204 | 207693 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992963.53977 | 2099050.31915 | 37.7431879987389 | -122.466987567326 | (37.7431879987389, -122.466987567326) | 1 | 8 | 4 | 59 | 40 | |||
| 56479 | 207688 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.475126663888 | (37.7412797470716, -122.475126663888) | 1 | 8 | 4 | 29491 | 40 | |||
| 57254 | 207697 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993442.50262 | 2102313.15594 | 37.7521745516283 | -122.465568443448 | (37.7521745516283, -122.465568443448) | 1 | 8 | 4 | 29491 | 12 | |||
| 59665 | 207585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991309.0934 | 2097696.30904 | 37.7393746016694 | -122.472609451563 | (37.7393746016694, -122.472609451563) | 1 | 8 | 4 | 29491 | 40 | |||
| 60174 | 207532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990908.40478 | 2104231.60064 | 37.757295609713 | -122.474471644475 | (37.757295609713, -122.474471644475) | 1 | 8 | 4 | 56 | 12 | |||
| 61104 | 182266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986219.9712 | 2105233.6732 | 37.759774269018 | -122.490759591455 | (37.759774269018, -122.490759591455) | 1 | 8 | 3 | 56 | 35 | |||
| 61161 | 207599 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994739.36013 | 2091570.55978 | 37.7227527497193 | -122.460305470535 | (37.7227527497193, -122.460305470535) | 9 | 8 | 4 | 28861 | 24 | |||
| 62175 | 207605 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994168.04761 | 2090360.81563 | 37.71939820295 | -122.462192668156 | (37.71939820295, -122.462192668156) | 9 | 8 | 6 | 28861 | 24 | |||
| 63012 | 207610 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Majestic Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5997347.38565 | 2089696.67863 | 37.7177571866363 | -122.451155061159 | (37.7177571866363, -122.451155061159) | 9 | 8 | 6 | 28861 | 24 | |||
| 63283 | 216859 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 249 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 08:28:00 AM | 3 | Width 3ft | 5994500.65492 | 2087744.19701 | 37.7122327349221 | -122.460853440033 | (37.7122327349221, -122.460853440033) | 9 | 8 | 6 | 28861 | 24 | ||
| 63304 | 207643 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992162.23499 | 2104876.45393 | 37.759138772946 | -122.470182404389 | (37.759138772946, -122.470182404389) | 1 | 8 | 4 | 56 | 12 | |||
| 64249 | 252820 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.68636 | 37.743137766616 | -122.499410557243 | (37.743137766616, -122.499410557243) | 1 | 8 | 3 | 29491 | 35 | ||
| 72062 | 207650 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5992348.57689 | 2106988.87327 | 37.7649496901864 | -122.469691736987 | (37.7649496901864, -122.469691736987) | 11 | 8 | 11 | 56 | 12 | |||
| 73572 | 207616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 385 Victoria St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993229.18719 | 2089803.61986 | 37.7178141748665 | -122.46539747963 | (37.7178141748665, -122.46539747963) | 9 | 8 | 6 | 64 | 24 | |||
| 74169 | 207565 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5993329.70544 | 2105554.91485 | 37.7610690750853 | -122.466194072125 | (37.7610690750853, -122.466194072125) | 1 | 8 | 4 | 56 | 12 | |||
| 74684 | 216641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 8 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:34:00 PM | 3 | Width 2ft | 5996523.62122 | 2089940.02354 | 37.7183781559031 | -122.454019995444 | (37.7183781559031, -122.454019995444) | 9 | 8 | 6 | 28861 | 24 | ||
| 77403 | 207649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992350.24318 | 2107007.29573 | 37.7650003696822 | -122.469687315036 | (37.7650003696822, -122.469687315036) | 11 | 8 | 11 | 56 | 12 | |||
| 78086 | 207586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1917 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993746.75792 | 2102455.06491 | 37.7525817412531 | -122.464526593251 | (37.7525817412531, -122.464526593251) | 1 | 8 | 4 | 29491 | 12 | |||
| 81292 | 207563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1453 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993327.97162 | 2105609.42801 | 37.7612186539421 | -122.466204030294 | (37.7612186539421, -122.466204030294) | 1 | 8 | 4 | 56 | 12 | |||
| 81670 | 207681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991411.6864 | 2097337.95206 | 37.738396582641 | -122.472228618364 | (37.738396582641, -122.472228618364) | 1 | 8 | 4 | 29491 | 40 | |||
| 81776 | 207535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1531 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990841.25621 | 2104949.97528 | 37.7592641852056 | -122.474756299665 | (37.7592641852056, -122.474756299665) | 1 | 8 | 4 | 56 | 12 | |||
| 81965 | 207682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2462 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5990792.7433 | 2098630.33856 | 37.7419093048628 | -122.474462888654 | (37.7419093048628, -122.474462888654) | 1 | 8 | 4 | 29491 | 40 | |||
| 82782 | 207684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990737.5825 | 2098918.54589 | 37.7426974518186 | -122.474674644836 | (37.7426974518186, -122.474674644836) | 1 | 8 | 4 | 29491 | 40 | |||
| 84796 | 207614 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 218 Lakeview Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997036.49742 | 2089508.96246 | 37.7172239569865 | -122.452216120002 | (37.7172239569865, -122.452216120002) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||
| 87618 | 207651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992350.99659 | 2106967.18215 | 37.7648902719794 | -122.469681788681 | (37.7648902719794, -122.469681788681) | 11 | 8 | 11 | 56 | 12 | |||
| 87643 | 207669 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1767 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993090.08288 | 2103453.39463 | 37.7552850196943 | -122.466870038526 | (37.7552850196943, -122.466870038526) | 1 | 8 | 4 | 56 | 12 | |||
| 89620 | 207671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1734 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990626.77188 | 2103577.88918 | 37.7554843697179 | -122.475397903889 | (37.7554843697179, -122.475397903889) | 1 | 8 | 4 | 56 | 12 | |||
| 90746 | 207611 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 64 Majestic Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5997222.96665 | 2089595.38167 | 37.7174719243608 | -122.451577817186 | (37.7174719243608, -122.451577817186) | 9 | 8 | 6 | 28861 | 24 | |||
| 92656 | 207620 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5993530.06082 | 2090669.11588 | 37.7202079660024 | -122.464420306871 | (37.7202079660024, -122.464420306871) | 9 | 8 | 6 | 64 | 24 | |||
| 92991 | 207597 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5994785.91009 | 2091770.68418 | 37.7233049208652 | -122.460159050094 | (37.7233049208652, -122.460159050094) | 9 | 8 | 4 | 28861 | 24 | |||
| 98479 | 207639 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993046.37719 | 2104789.3186 | 37.7589505970219 | -122.467118308968 | (37.7589505970219, -122.467118308968) | 1 | 8 | 4 | 56 | 12 | |||
| 99589 | 207584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994383.58117 | 2099287.47444 | 37.7439210289412 | -122.462094670844 | (37.7439210289412, -122.462094670844) | 1 | 8 | 4 | 59 | 40 | |||
| 100535 | 207654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1279 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992358.22699 | 2106733.7624 | 37.7642497811258 | -122.469639786754 | (37.7642497811258, -122.469639786754) | 11 | 8 | 11 | 56 | 12 | |||
| 100690 | 21338 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 103024 | 207564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1457 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993330.19725 | 2105578.31991 | 37.7611333676392 | -122.46619407211 | (37.7611333676392, -122.46619407211) | 1 | 8 | 4 | 56 | 12 | |||
| 103351 | 207537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993487.77014 | 2106611.56006 | 37.7639794646992 | -122.465724170953 | (37.7639794646992, -122.465724170953) | 1 | 8 | 11 | 56 | 12 | |||
| 107804 | 112688 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720 | 2088919 | 37.71541351482 | -122.4636368036 | (37.71541351482, -122.4636368036) | 9 | 8 | 6 | 64 | 24 | ||
| 108049 | 207559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992726.03942 | 2106443.21953 | 37.763473278578 | -122.468346500487 | (37.763473278578, -122.468346500487) | 1 | 8 | 11 | 56 | 12 | |||
| 108110 | 207678 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3137 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990981.20237 | 2100859.62837 | 37.7480412755876 | -122.473973874217 | (37.7480412755876, -122.473973874217) | 1 | 8 | 4 | 29491 | 40 | |||
| 109418 | 181738 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 2803 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5986967.0668 | 2107072.067 | 37.7648656060734 | -122.488310893002 | (37.7648656060734, -122.488310893002) | 1 | 8 | 3 | 56 | 35 | |||
| 111369 | 182485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985266.5327 | 2104584.1284 | 37.7579350567147 | -122.494009145875 | (37.7579350567147, -122.494009145875) | 1 | 8 | 3 | 56 | 35 | |||
| 114689 | 207579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2242 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991315.21064 | 2100156.8914 | 37.7461310831881 | -122.472767665701 | (37.7461310831881, -122.472767665701) | 1 | 8 | 4 | 29491 | 40 | |||
| 118485 | 207577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990606.99166 | 2102703.3769 | 37.7530820431036 | -122.475402462551 | (37.7530820431036, -122.475402462551) | 1 | 8 | 4 | 56 | 12 | |||
| 118919 | 207575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1272 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992404.81832 | 2106813.55032 | 37.7644715503328 | -122.469484450466 | (37.7644715503328, -122.469484450466) | 11 | 8 | 11 | 56 | 12 | |||
| 119964 | 207598 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5994786.89964 | 2091797.50496 | 37.7233786212014 | -122.460157571622 | (37.7233786212014, -122.460157571622) | 9 | 8 | 4 | 28861 | 24 | |||
| 120687 | 207582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 75 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992870.128 | 2098681.7297 | 37.7421705534178 | -122.467283762661 | (37.7421705534178, -122.467283762661) | 1 | 8 | 4 | 59 | 40 | |||
| 123328 | 207680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2475 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991693.59154 | 2098601.29032 | 37.7418816983798 | -122.471345960741 | (37.7418816983798, -122.471345960741) | 1 | 8 | 4 | 29491 | 40 | |||
| 123773 | 216862 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 272 Sadowa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 08:43:00 AM | 3 | Width 3ft | 5994260.82584 | 2087785.69998 | 37.7123328897311 | -122.461685361516 | (37.7123328897311, -122.461685361516) | 9 | 8 | 6 | 28861 | 24 | ||
| 124224 | 207580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2638 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991779.82441 | 2097449.35591 | 37.7387237676844 | -122.470963901766 | (37.7387237676844, -122.470963901766) | 1 | 8 | 4 | 29491 | 40 | |||
| 124290 | 207673 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993279.54162 | 2105307.7731 | 37.7603875940426 | -122.466349603556 | (37.7603875940426, -122.466349603556) | 1 | 8 | 4 | 56 | 12 | |||
| 125146 | 207600 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 543 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995134.72164 | 2091208.46348 | 37.7217812543709 | -122.458912596054 | (37.7217812543709, -122.458912596054) | 9 | 8 | 6 | 28861 | 24 | |||
| 128120 | 207566 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1465 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993331.08215 | 2105529.08118 | 37.7609982220075 | -122.466187433302 | (37.7609982220075, -122.466187433302) | 1 | 8 | 4 | 56 | 12 | |||
| 129643 | 216738 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 55 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:15:00 AM | 3 | Width 3ft | 5996190.92128 | 2090248.81596 | 37.7192069450213 | -122.455192295882 | (37.7192069450213, -122.455192295882) | 9 | 8 | 6 | 28861 | 24 | ||
| 130162 | 207578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 433 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993489.67948 | 2105251.0502 | 37.7602439704969 | -122.46561871914 | (37.7602439704969, -122.46561871914) | 1 | 8 | 4 | 56 | 12 | |||
| 130799 | 182614 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1866 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989725.7736 | 2102651.2747 | 37.7528878642991 | -122.478446043912 | (37.7528878642991, -122.478446043912) | 1 | 8 | 3 | 56 | 35 | |||
| 131680 | 207699 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 San Jacinto Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993874.29441 | 2095168.96747 | 37.7325832992673 | -122.463556817398 | (37.7325832992673, -122.463556817398) | 9 | 8 | 4 | 59 | 40 | |||
| 132215 | 251702 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 910 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:10:00 AM | 3 | 3x3 | 5995959 | 2089989 | 37.7184802428284 | -122.455975181765 | (37.7184802428284, -122.455975181765) | 9 | 8 | 6 | 28861 | 24 | ||
| 132333 | 207690 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 642 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991148.86446 | 2099110.57767 | 37.7432485446942 | -122.473266566413 | (37.7432485446942, -122.473266566413) | 1 | 8 | 4 | 29491 | 40 | |||
| 132916 | 207652 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1249 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992353.95742 | 2106910.47377 | 37.7647347369382 | -122.469667419325 | (37.7647347369382, -122.469667419325) | 11 | 8 | 11 | 56 | 12 | |||
| 133077 | 207573 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5992999.52261 | 2104555.29136 | 37.7583053145698 | -122.467263336346 | (37.7583053145698, -122.467263336346) | 1 | 8 | 4 | 56 | 12 |
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) );