trees
327 rows where Police Districts = 6 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1238 | 144982 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990689.31249 | 2110785.3324 | 37.7752776943529 | -122.4757079065 | (37.7752776943529, -122.4757079065) | 11 | 6 | 2 | 54 | 26 | ||
| 1304 | 91006 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5988072.26413 | 2111179.36369 | 37.7762075240837 | -122.484789675521 | (37.7762075240837, -122.484789675521) | 11 | 6 | 2 | 55 | 26 | ||
| 2248 | 90191 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1860X Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.44542 | 37.7766336380006 | -122.478900695137 | (37.7766336380006, -122.478900695137) | 11 | 6 | 2 | 55 | 26 | |||
| 3110 | 126516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3449 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5997745.83933 | 2116374.85745 | 37.7910316321555 | -122.451701179872 | (37.7910316321555, -122.451701179872) | 11 | 6 | 1 | 54 | 31 | |||
| 4081 | 145032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 154 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 5991192.39146 | 2114393.22168 | 37.7852131174265 | -122.47423097869 | (37.7852131174265, -122.47423097869) | 11 | 6 | 2 | 54 | 26 | |||
| 5142 | 259872 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
| 6040 | 90220 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987751.08815 | 2111228.00123 | 37.7763223582458 | -122.485904267418 | (37.7763223582458, -122.485904267418) | 11 | 6 | 2 | 55 | 26 | ||
| 6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
| 6857 | 83788 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 482 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994387.70821 | 2112243.63782 | 37.779495530287 | -122.463020234423 | (37.779495530287, -122.463020234423) | 11 | 6 | 2 | 54 | 11 | |||
| 7259 | 90542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 632 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993688.832385 | 2110751.462082 | 37.7753581349738 | -122.465329502856 | (37.7753581349738, -122.465329502856) | 11 | 6 | 2 | 54 | 11 | ||
| 7521 | 82066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 178 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6x9 | 5993381.48495 | 2114348.32206 | 37.7852164089009 | -122.466654188344 | (37.7852164089009, -122.466654188344) | 11 | 6 | 2 | 54 | 11 | ||
| 8256 | 144400 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5987240.24391 | 2111690.94043 | 37.7775636765575 | -122.487705414786 | (37.7775636765575, -122.487705414786) | 11 | 6 | 2 | 55 | 26 | |||
| 9088 | 123748 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2015 07:10:00 AM | 15 | Width 3ft | 5995551.56394 | 2110826.65908 | 37.7756718539675 | -122.458891368973 | (37.7756718539675, -122.458891368973) | 11 | 6 | 2 | 54 | 11 | ||
| 9588 | 144974 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990690 | 2111380 | 37.7769105282448 | -122.475748963166 | (37.7769105282448, -122.475748963166) | 11 | 6 | 2 | 54 | 26 | ||
| 11087 | 122015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1799 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990132.5051 | 2110630.33529 | 37.7748198185001 | -122.477622678128 | (37.7748198185001, -122.477622678128) | 11 | 6 | 2 | 55 | 26 | |||
| 11395 | 69965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5992352.53877 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | 11 | 6 | 2 | 54 | 11 | |||
| 12028 | 261519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:20:00 PM | Width 4ft | 5982910.9702 | 2111318.38005 | 37.7762872714849 | -122.502653994406 | (37.7762872714849, -122.502653994406) | 11 | 6 | 2 | 55 | 26 | |||
| 13516 | 90326 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989640.77384 | 2111238.69513 | 37.7764616586133 | -122.479368175716 | (37.7764616586133, -122.479368175716) | 11 | 6 | 2 | 55 | 26 | ||
| 14055 | 90182 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990417.75212 | 2111322.65396 | 37.7767372842601 | -122.476686550978 | (37.7767372842601, -122.476686550978) | 11 | 6 | 2 | 55 | 26 | ||
| 14607 | 144226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 786 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:53:00 PM | 0 | Width 4ft | 5982632.5127 | 2110441.98121 | 37.7738645680338 | -122.503552325389 | (37.7738645680338, -122.503552325389) | 11 | 6 | 2 | 55 | 26 | ||
| 15156 | 90172 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990908.22712 | 2111337.09849 | 37.7768053819444 | -122.474990924283 | (37.7768053819444, -122.474990924283) | 11 | 6 | 2 | 54 | 26 | ||
| 15652 | 147295 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987874.57425 | 2110110.67904 | 37.7732616993961 | -122.485395090629 | (37.7732616993961, -122.485395090629) | 11 | 6 | 2 | 55 | 26 | |||
| 17626 | 90350 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992328.99634 | 2111334.95536 | 37.7768817336944 | -122.470075945794 | (37.7768817336944, -122.470075945794) | 11 | 6 | 2 | 54 | 11 | ||
| 18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
| 20721 | 120492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | 11 | 6 | 2 | 55 | 26 | |||
| 21414 | 124354 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1100 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992180.38847 | 2111384.61555 | 37.7770094950384 | -122.470593638633 | (37.7770094950384, -122.470593638633) | 11 | 6 | 2 | 54 | 11 | |||
| 22379 | 122307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.476307253497 | (37.7766000733292, -122.476307253497) | 11 | 6 | 2 | 55 | 26 | |||
| 23398 | 122165 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991266.55577 | 2111104.42075 | 37.776187272392 | -122.473734392293 | (37.776187272392, -122.473734392293) | 11 | 6 | 2 | 54 | 26 | |||
| 24453 | 120820 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989571.70093 | 2114608.17958 | 37.7857093094708 | -122.47985374027 | (37.7857093094708, -122.47985374027) | 11 | 6 | 2 | 55 | 26 | |||
| 26608 | 90340 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990615.55567 | 2111280.455278 | 37.7766328895552 | -122.475999214233 | (37.7766328895552, -122.475999214233) | 11 | 6 | 2 | 55 | 26 | ||
| 27990 | 7136 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 336X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | ||
| 28197 | 91005 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2415 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988054.23451 | 2111177.58374 | 37.776201586759 | -122.4848519135 | (37.776201586759, -122.4848519135) | 11 | 6 | 2 | 55 | 26 | ||
| 28349 | 90183 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990402.31364 | 2111319.28606 | 37.776727141439 | -122.476739710576 | (37.776727141439, -122.476739710576) | 11 | 6 | 2 | 55 | 26 | ||
| 28930 | 90335 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.830083 | 2111264.66899 | 37.7765642703859 | -122.477505345978 | (37.7765642703859, -122.477505345978) | 11 | 6 | 2 | 55 | 26 | ||
| 30286 | 90215 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2434 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987937.95416 | 2111227.93997 | 37.7763330776559 | -122.485257849615 | (37.7763330776559, -122.485257849615) | 11 | 6 | 2 | 55 | 26 | ||
| 31142 | 90343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990837.83753 | 2111277.85575 | 37.7766386380593 | -122.475230094421 | (37.7766386380593, -122.475230094421) | 11 | 6 | 2 | 54 | 26 | ||
| 31460 | 7681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.55121 | 37.7753907066265 | -122.461904549943 | (37.7753907066265, -122.461904549943) | 11 | 6 | 2 | 54 | 11 | ||
| 31535 | 101129 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990852.81168 | 2113469.73907 | 37.7826578128527 | -122.475338361197 | (37.7826578128527, -122.475338361197) | 11 | 6 | 2 | 54 | 26 | |||
| 32114 | 123721 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995382.67333 | 2111440.05096 | 37.7773463562681 | -122.459520034239 | (37.7773463562681, -122.459520034239) | 11 | 6 | 2 | 54 | 11 | |||
| 32632 | 90910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5993421.38614 | 2110692.49557 | 37.7751808014585 | -122.46625036778 | (37.7751808014585, -122.46625036778) | 11 | 6 | 2 | 54 | 11 | ||
| 32637 | 122259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991408.07058 | 2113443.99656 | 37.7826193002424 | -122.473415543385 | (37.7826193002424, -122.473415543385) | 11 | 6 | 2 | 54 | 26 | |||
| 32996 | 90901 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992730.980543 | 2110676.551916 | 37.7750971658671 | -122.468637454404 | (37.7750971658671, -122.468637454404) | 11 | 6 | 2 | 54 | 11 | ||
| 33760 | 90909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 743 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993328.71642 | 2110689.5573 | 37.7751673865441 | -122.466570716861 | (37.7751673865441, -122.466570716861) | 11 | 6 | 2 | 54 | 11 | ||
| 34296 | 90168 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991509.01668 | 2111361.24003 | 37.7769064676002 | -122.472914393951 | (37.7769064676002, -122.472914393951) | 11 | 6 | 2 | 54 | 26 | ||
| 36651 | 90175 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990861.10816 | 2111339.14839 | 37.7768082795829 | -122.47515407092 | (37.7768082795829, -122.47515407092) | 11 | 6 | 2 | 54 | 26 | ||
| 37282 | 95858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5993372.82916 | 2114637.22815 | 37.7860091664792 | -122.466705142577 | (37.7860091664792, -122.466705142577) | 11 | 6 | 2 | 54 | 11 | |||
| 38972 | 111744 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5990148.86908 | 2111256.53838 | 37.7765401493402 | -122.47761185344 | (37.7765401493402, -122.47761185344) | 11 | 6 | 2 | 55 | 26 | |||
| 39752 | 91007 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988091.7784 | 2111178.02295 | 37.7762049792996 | -122.484722072811 | (37.7762049792996, -122.484722072811) | 11 | 6 | 2 | 55 | 26 | ||
| 40386 | 90164 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1108 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992192.434047 | 2111377.6526 | 37.776991073192 | -122.470551462384 | (37.776991073192, -122.470551462384) | 11 | 6 | 2 | 54 | 11 | ||
| 41009 | 144432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 774 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 3ft | 5987587.51741 | 2110684.06235 | 37.7748193215988 | -122.486430151825 | (37.7748193215988, -122.486430151825) | 11 | 6 | 2 | 55 | 26 | ||
| 42029 | 254843 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1814 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5993025 | 2112122 | 37.7790829564028 | -122.467725532477 | (37.7790829564028, -122.467725532477) | 11 | 6 | 2 | 54 | 11 | |||
| 42228 | 7682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.55121 | 37.7753907066265 | -122.461904549943 | (37.7753907066265, -122.461904549943) | 11 | 6 | 2 | 54 | 11 | ||
| 42539 | 90178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990743.86008 | 2111332.65292 | 37.7767836486034 | -122.475559188643 | (37.7767836486034, -122.475559188643) | 11 | 6 | 2 | 54 | 26 | ||
| 43159 | 90539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 546 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5993965.73496 | 2110768.06622 | 37.7754196906156 | -122.464372845695 | (37.7754196906156, -122.464372845695) | 11 | 6 | 2 | 54 | 11 | ||
| 44826 | 145641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 3ft | 5994643.50438 | 2112521.18188 | 37.7802723230532 | -122.462155466817 | (37.7802723230532, -122.462155466817) | 11 | 6 | 2 | 54 | 11 | ||
| 45253 | 90176 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/17/2016 07:32:00 AM | 3 | 3x3 | 5990794.25741 | 2111335.28271 | 37.776793790701 | -122.47538504305 | (37.776793790701, -122.47538504305) | 11 | 6 | 2 | 54 | 26 | ||
| 48117 | 254837 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992465 | 2114587 | 37.7858188208387 | -122.469842298582 | (37.7858188208387, -122.469842298582) | 11 | 6 | 2 | 54 | 11 | |||
| 48123 | 90166 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991544.41484 | 2111361.65556 | 37.7769096577615 | -122.472791972421 | (37.7769096577615, -122.472791972421) | 11 | 6 | 2 | 54 | 26 | ||
| 48792 | 122341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 04th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2017 12:00:00 AM | 3 | 3x3 | 5994600 | 2112752 | 37.780903582725 | -122.462322713118 | (37.780903582725, -122.462322713118) | 11 | 6 | 2 | 54 | 11 | ||
| 48823 | 90347 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1351 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991383.39522 | 2111300.26974 | 37.776731786489 | -122.473344504612 | (37.776731786489, -122.473344504612) | 11 | 6 | 2 | 54 | 26 | ||
| 49564 | 114655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001302.3779 | 2113905.5111 | 37.7844544851842 | -122.439218650192 | (37.7844544851842, -122.439218650192) | 15 | 6 | 11 | 29490 | 13 | |||
| 50283 | 122031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990343.843 | 2110450.87965 | 37.7743393443985 | -122.476878509257 | (37.7743393443985, -122.476878509257) | 11 | 6 | 2 | 55 | 26 | |||
| 51535 | 123749 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5995567.69989 | 2110826.72314 | 37.7756729573603 | -122.458835555737 | (37.7756729573603, -122.458835555737) | 11 | 6 | 2 | 54 | 11 | ||
| 51629 | 90998 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2545 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987618.41516 | 2111163.66443 | 37.7761379752311 | -122.486358489761 | (37.7761379752311, -122.486358489761) | 11 | 6 | 2 | 55 | 26 | ||
| 51936 | 123028 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 738 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991970.4168 | 2110394.80661 | 37.7742796046287 | -122.471247855577 | (37.7742796046287, -122.471247855577) | 11 | 6 | 2 | 54 | 11 | |||
| 52362 | 124532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992651.91776 | 2111347.60988 | 37.7769351421706 | -122.468959793565 | (37.7769351421706, -122.468959793565) | 11 | 6 | 2 | 54 | 11 | |||
| 52716 | 114651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001524.5433 | 2113938.4711 | 37.7845576244995 | -122.438452398093 | (37.7845576244995, -122.438452398093) | 15 | 6 | 11 | 29490 | 13 | |||
| 53531 | 90553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1090 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992323.62833 | 2110709.32554 | 37.7751636133682 | -122.470048949636 | (37.7751636133682, -122.470048949636) | 11 | 6 | 2 | 54 | 11 | ||
| 55443 | 90161 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1000X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992485.27988 | 2111393.76315 | 37.7770522373591 | -122.469539600379 | (37.7770522373591, -122.469539600379) | 11 | 6 | 2 | 54 | 11 | ||
| 56020 | 90181 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1640 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990451.67378 | 2111322.99271 | 37.7767401818846 | -122.476569231876 | (37.7767401818846, -122.476569231876) | 11 | 6 | 2 | 55 | 26 | ||
| 56183 | 90906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 4 | 3x3 | 5992776.28818 | 2110667.73592 | 37.7750755767076 | -122.468480085109 | (37.7750755767076, -122.468480085109) | 11 | 6 | 2 | 54 | 11 | ||
| 56390 | 138230 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998494.0384 | 2112624.2642 | 37.7807763098306 | -122.448842177387 | (37.7807763098306, -122.448842177387) | 15 | 6 | 2 | 54 | 16 | |||
| 56815 | 90187 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1826 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989876.68913 | 2111302.12921 | 37.776649530669 | -122.478556726612 | (37.776649530669, -122.478556726612) | 11 | 6 | 2 | 55 | 26 | ||
| 60250 | 2768 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 238 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2005 12:00:00 AM | 7 | 3X3 | 5994792.46278 | 2110798.98024 | 37.7755521919136 | -122.461515261652 | (37.7755521919136, -122.461515261652) | 11 | 6 | 2 | 54 | 11 | ||
| 60251 | 101124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990795.23328 | 2113422.41957 | 37.7825245490117 | -122.475534099586 | (37.7825245490117, -122.475534099586) | 11 | 6 | 2 | 54 | 26 | |||
| 60411 | 90324 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989502.24352 | 2111235.4245 | 37.7764446312789 | -122.479847146645 | (37.7764446312789, -122.479847146645) | 11 | 6 | 2 | 55 | 26 | ||
| 60973 | 90325 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1921 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989582.35832 | 2111234.7631 | 37.7764474692851 | -122.479569961566 | (37.7764474692851, -122.479569961566) | 11 | 6 | 2 | 55 | 26 | ||
| 62823 | 90339 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990541.50098 | 2111271.1479 | 37.7766030398525 | -122.476254708345 | (37.7766030398525, -122.476254708345) | 11 | 6 | 2 | 55 | 26 | ||
| 63446 | 90328 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1849X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989790.54801 | 2111243.58929 | 37.7764837946672 | -122.478850428089 | (37.7764837946672, -122.478850428089) | 11 | 6 | 2 | 55 | 26 | ||
| 65265 | 90904 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 925 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992720.2562 | 2110664.48698 | 37.7750634192844 | -122.468673673873 | (37.7750634192844, -122.468673673873) | 11 | 6 | 2 | 54 | 11 | ||
| 66682 | 123726 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 598 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993863.8164 | 2110765.62701 | 37.7754071178751 | -122.464725226052 | (37.7754071178751, -122.464725226052) | 11 | 6 | 2 | 54 | 11 | |||
| 68724 | 120402 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988664 | 2114068 | 37.7841733536199 | -122.482954484434 | (37.7841733536199, -122.482954484434) | 11 | 6 | 2 | 55 | 26 | |||
| 68965 | 90546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 826 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 2 | 3x3 | 5993034.20515 | 2110734.52982 | 37.7752738693606 | -122.467592759821 | (37.7752738693606, -122.467592759821) | 11 | 6 | 2 | 54 | 11 | ||
| 70450 | 75463 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1806 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5989925.9266 | 2111303.98207 | 37.7766574766255 | -122.47838653717 | (37.7766574766255, -122.47838653717) | 11 | 6 | 2 | 55 | 26 | ||
| 71479 | 120490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989039.20971 | 2110535.30773 | 37.7744953937056 | -122.481397609154 | (37.7744953937056, -122.481397609154) | 11 | 6 | 2 | 55 | 26 | |||
| 71780 | 72330 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2761 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1996 12:00:00 AM | 9 | 5995926.57923 | 2110675.1717 | 37.7752774586568 | -122.457583143432 | (37.7752774586568, -122.457583143432) | 11 | 6 | 2 | 54 | 16 | ||
| 72450 | 91000 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2533 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987666.18452 | 2111163.57696 | 37.7761405192841 | -122.486193238376 | (37.7761405192841, -122.486193238376) | 11 | 6 | 2 | 55 | 26 | ||
| 73059 | 90540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 550X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2014 12:00:00 AM | 3 | 3x3 | 5993951.099186 | 2110760.95535 | 37.7753993224191 | -122.464422957483 | (37.7753993224191, -122.464422957483) | 11 | 6 | 2 | 54 | 11 | ||
| 73262 | 119937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5987300.15523 | 2111149.41702 | 37.7760803002726 | -122.487458375319 | (37.7760803002726, -122.487458375319) | 11 | 6 | 2 | 55 | 26 | |||
| 73552 | 123730 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 442 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5994233.00826 | 2110778.83471 | 37.7754646605749 | -122.463449073067 | (37.7754646605749, -122.463449073067) | 11 | 6 | 2 | 54 | 11 | ||
| 73723 | 7680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2008 12:00:00 AM | 6 | 3x3 | 5994929.5013 | 2110751.87573 | 37.7754307421541 | -122.461037800693 | (37.7754307421541, -122.461037800693) | 11 | 6 | 2 | 54 | 11 | ||
| 74309 | 101123 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990813.05778 | 2113422.53635 | 37.7825259029173 | -122.475472443708 | (37.7825259029173, -122.475472443708) | 11 | 6 | 2 | 54 | 26 | |||
| 75156 | 91003 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2449 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5987916.77213 | 2111175.55765 | 37.7761880165196 | -122.48532727859 | (37.7761880165196, -122.48532727859) | 11 | 6 | 2 | 55 | 26 | ||
| 75430 | 100358 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | 11 | 6 | 2 | 54 | 26 | ||||
| 77104 | 124533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992637.18811 | 2111348.18178 | 37.7769358614128 | -122.469010789113 | (37.7769358614128, -122.469010789113) | 11 | 6 | 2 | 54 | 11 | |||
| 78245 | 90163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992466.887805 | 2111387.622086 | 37.7770343127004 | -122.469602776563 | (37.7770343127004, -122.469602776563) | 11 | 6 | 2 | 54 | 11 | ||
| 78978 | 124534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992622.68332 | 2111346.91424 | 37.7769315430211 | -122.469060872907 | (37.7769315430211, -122.469060872907) | 11 | 6 | 2 | 54 | 11 | |||
| 79395 | 90330 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1831 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 2 | 3x3 | 5989853.25507 | 2111244.33044 | 37.7764894706591 | -122.478633563095 | (37.7764894706591, -122.478633563095) | 11 | 6 | 2 | 55 | 26 | ||
| 79617 | 90899 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992439.368739 | 2110665.968462 | 37.7750512566564 | -122.469645424238 | (37.7750512566564, -122.469645424238) | 11 | 6 | 2 | 54 | 11 | ||
| 84308 | 2781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3X3 | 5994323.8414 | 2110783.97336 | 37.775484002867 | -122.463135234951 | (37.775484002867, -122.463135234951) | 11 | 6 | 2 | 54 | 11 |
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) );