trees
575 rows where qSpecies_id = 123 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6080 | 19758 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY15 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 9823 | 19923 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY37 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 15070 | 19922 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY37 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 104412 | 119966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5987215.94672 | 2112352.18936 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | 11 | 6 | 2 | 55 | 26 | |||
| 121645 | 90588 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2242 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988605.86031 | 2110576.30478 | 37.7745827550651 | -122.48289963544 | (37.7745827550651, -122.48289963544) | 11 | 6 | 2 | 55 | 26 | ||
| 128004 | 90862 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2233 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988638.67322 | 2110518.90236 | 37.7744270531648 | -122.4827819229 | (37.7744270531648, -122.4827819229) | 11 | 6 | 2 | 55 | 26 | ||
| 147178 | 90863 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988677.47069 | 2110522.18301 | 37.7744383181626 | -122.482647957161 | (37.7744383181626, -122.482647957161) | 11 | 6 | 2 | 55 | 26 | ||
| 67783 | 90864 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | 11 | 6 | 2 | 55 | 26 | ||
| 163714 | 90587 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988720.72128 | 2110579.96701 | 37.7745994931186 | -122.482502581896 | (37.7745994931186, -122.482502581896) | 11 | 6 | 2 | 55 | 26 | ||
| 141497 | 90865 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988736.61915 | 2110526.67364 | 37.7744540891609 | -122.482443682946 | (37.7744540891609, -122.482443682946) | 11 | 6 | 2 | 55 | 26 | ||
| 36193 | 90586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988739.41652 | 2110581.09487 | 37.7746036774674 | -122.482437994797 | (37.7746036774674, -122.482437994797) | 11 | 6 | 2 | 55 | 26 | ||
| 155950 | 90585 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988755.94443 | 2110581.0496 | 37.7746045146176 | -122.482380818852 | (37.7746045146176, -122.482380818852) | 11 | 6 | 2 | 55 | 26 | ||
| 115389 | 90584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2150X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988880.62132 | 2110585.72387 | 37.7746246005815 | -122.481949884411 | (37.7746246005815, -122.481949884411) | 11 | 6 | 2 | 55 | 26 | ||
| 170751 | 90866 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2151X Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988924.29434 | 2110530.35666 | 37.7744751174123 | -122.481794756145 | (37.7744751174123, -122.481794756145) | 11 | 6 | 2 | 55 | 26 | ||
| 190395 | 91010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988937.91177 | 2110588.16813 | 37.7746346435588 | -122.481751886766 | (37.7746346435588, -122.481751886766) | 11 | 6 | 2 | 55 | 26 | ||
| 106929 | 67973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 3 | Permit Number 31694 | 5988948.22001 | 2110531.76438 | 37.7744803739464 | -122.481712096768 | (37.7744803739464, -122.481712096768) | 11 | 6 | 2 | 55 | 26 | |
| 109111 | 90583 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2116 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988996.38069 | 2110588.45382 | 37.7746388278925 | -122.481549654427 | (37.7746388278925, -122.481549654427) | 11 | 6 | 2 | 55 | 26 | ||
| 161059 | 90582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989019.95807 | 2110588.86895 | 37.7746413386268 | -122.481468126933 | (37.7746413386268, -122.481468126933) | 11 | 6 | 2 | 55 | 26 | ||
| 45602 | 65010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | 11 | 6 | 2 | 55 | 26 | ||
| 148837 | 90580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989065.94752 | 2110592.46721 | 37.7746538923373 | -122.481309305666 | (37.7746538923373, -122.481309305666) | 11 | 6 | 2 | 55 | 26 | ||
| 120276 | 90868 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989180.48685 | 2110539.97505 | 37.7745164219339 | -122.480909251758 | (37.7745164219339, -122.480909251758) | 11 | 6 | 2 | 55 | 26 | ||
| 112842 | 90578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2050X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989208.06357 | 2110596.77372 | 37.7746739782763 | -122.480818018857 | (37.7746739782763, -122.480818018857) | 11 | 6 | 2 | 55 | 26 | ||
| 14948 | 90869 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.29026 | 37.7745216791694 | -122.480811390162 | (37.7745216791694, -122.480811390162) | 11 | 6 | 2 | 55 | 26 | ||
| 188806 | 90577 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2050X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989223.999 | 2110597.65544 | 37.7746773254621 | -122.480762960202 | (37.7746773254621, -122.480762960202) | 11 | 6 | 2 | 55 | 26 | ||
| 26438 | 90871 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989249.74132 | 2110541.7912 | 37.7745254339062 | -122.480669822879 | (37.7745254339062, -122.480669822879) | 11 | 6 | 2 | 55 | 26 | ||
| 110974 | 120834 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.480595714565 | (37.7745306911578, -122.480595714565) | 11 | 6 | 2 | 55 | 26 | |||
| 33458 | 90872 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2027 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989286.8509 | 2110543.19375 | 37.7745314416669 | -122.480541557806 | (37.7745314416669, -122.480541557806) | 11 | 6 | 2 | 55 | 26 | ||
| 27838 | 90576 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2020 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989294.17784 | 2110601.65647 | 37.7746923899334 | -122.48052049321 | (37.7746923899334, -122.48052049321) | 11 | 6 | 2 | 55 | 26 | ||
| 22012 | 90575 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2008 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989345.62252 | 2110602.70137 | 37.7746982485552 | -122.480342614213 | (37.7746982485552, -122.480342614213) | 11 | 6 | 2 | 55 | 26 | ||
| 147966 | 90873 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2015 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989357.49508 | 2110545.80132 | 37.7745427066681 | -122.480297379549 | (37.7745427066681, -122.480297379549) | 11 | 6 | 2 | 55 | 26 | ||
| 181100 | 90574 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1950 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989503.12005 | 2110610.6462 | 37.7747292138807 | -122.479798386077 | (37.7747292138807, -122.479798386077) | 11 | 6 | 2 | 55 | 26 | ||
| 23421 | 90874 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1941 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989523.27614 | 2110553.23403 | 37.7745727468597 | -122.479724461021 | (37.7745727468597, -122.479724461021) | 11 | 6 | 2 | 55 | 26 | ||
| 3710 | 70389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.479670271059 | (37.7747342353889, -122.479670271059) | 11 | 6 | 2 | 55 | 26 | |||
| 42514 | 90572 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989583.92326 | 2110610.46088 | 37.7747333989447 | -122.479518860914 | (37.7747333989447, -122.479518860914) | 11 | 6 | 2 | 55 | 26 | ||
| 88525 | 90879 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.02381 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | 11 | 6 | 2 | 55 | 26 | ||
| 188061 | 90880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1901X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989653.27368 | 2110557.04805 | 37.7745907701264 | -122.479275058131 | (37.7745907701264, -122.479275058131) | 11 | 6 | 2 | 55 | 26 | ||
| 48428 | 90571 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989655.61233 | 2110613.51621 | 37.7747459519392 | -122.479271100153 | (37.7747459519392, -122.479271100153) | 11 | 6 | 2 | 55 | 26 | ||
| 62144 | 65529 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | 11 | 6 | 2 | 55 | 26 | ||
| 191286 | 90883 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1827 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989887.73623 | 2110565.21832 | 37.7746268180643 | -122.478464612476 | (37.7746268180643, -122.478464612476) | 11 | 6 | 2 | 55 | 26 | ||
| 77851 | 90569 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.28238 | 2110623.46415 | 37.7747886345028 | -122.478356290001 | (37.7747886345028, -122.478356290001) | 11 | 6 | 2 | 55 | 26 | ||
| 79595 | 90884 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.90659 | 37.7746647760157 | -122.477624799049 | (37.7746647760157, -122.477624799049) | 11 | 6 | 2 | 55 | 26 | ||
| 115541 | 90885 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1733 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990174.4288 | 2110576.33984 | 37.7746739946122 | -122.477473709626 | (37.7746739946122, -122.477473709626) | 11 | 6 | 2 | 55 | 26 | ||
| 182007 | 90886 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1715 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990248.62617 | 2110577.36646 | 37.7746811185578 | -122.477217123809 | (37.7746811185578, -122.477217123809) | 11 | 6 | 2 | 55 | 26 | ||
| 55070 | 90888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.38922 | 2110587.78256 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | 11 | 6 | 2 | 55 | 26 | ||
| 157100 | 122016 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.7747259547528 | -122.476394881461 | (37.7747259547528, -122.476394881461) | 11 | 6 | 2 | 55 | 26 | |||
| 40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
| 60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
| 106851 | 90892 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1543 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990781.4854 | 2110598.61863 | 37.7747703727015 | -122.475375427468 | (37.7747703727015, -122.475375427468) | 11 | 6 | 2 | 54 | 26 | ||
| 89642 | 90894 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.86617 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | 11 | 6 | 2 | 54 | 26 | ||
| 152731 | 213852 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991160.08427 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | 1 | 8 | 11 | 56 | 12 | |||
| 116896 | 124090 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 601 Funston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5991893.39709 | 2111137.10441 | 37.7763132974782 | -122.471568380763 | (37.7763132974782, -122.471568380763) | 11 | 6 | 2 | 54 | 11 | ||||
| 157957 | 88525 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 626x Funston Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51466 | 5991969.3 | 2111151 | 37.7763558419216 | -122.471306826694 | (37.7763558419216, -122.471306826694) | 11 | 6 | 2 | 54 | 11 | |||
| 38813 | 90554 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992007.5751 | 2110699.64473 | 37.7751187568292 | -122.471141532792 | (37.7751187568292, -122.471141532792) | 11 | 6 | 2 | 54 | 11 | ||
| 23653 | 90897 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992033.67177 | 2110642.90774 | 37.7749644818454 | -122.471047125233 | (37.7749644818454, -122.471047125233) | 11 | 6 | 2 | 54 | 11 | ||
| 27091 | 90555 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992035.9437 | 2110699.81053 | 37.7751208528883 | -122.471043412514 | (37.7751208528883, -122.471043412514) | 11 | 6 | 2 | 54 | 11 | ||
| 61838 | 90896 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992053.33041 | 2110644.47867 | 37.7749699321879 | -122.47097923688 | (37.7749699321879, -122.47097923688) | 11 | 6 | 2 | 54 | 11 | ||
| 44084 | 41912 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | 11 | 6 | 2 | 54 | 11 | |
| 87429 | 41913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992259.32657 | 2111046.49076 | 37.7760856603427 | -122.470295940533 | (37.7760856603427, -122.470295940533) | 11 | 6 | 2 | 54 | 11 | |
| 191980 | 123105 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498 11th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992529.16869 | 2112181.64232 | 37.7792180760249 | -122.469445141648 | (37.7792180760249, -122.469445141648) | 11 | 6 | 2 | 54 | 11 | |||
| 142722 | 111741 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498x 11th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5992530.71883 | 2112167.74428 | 37.7791800053719 | -122.469438767189 | (37.7791800053719, -122.469438767189) | 11 | 6 | 2 | 54 | 11 | |||
| 130878 | 123179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992862.96444 | 2110216.56004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | 11 | 6 | 2 | 54 | 11 | |||
| 100139 | 67314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 666 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1992 12:00:00 AM | 7 | Permit Number 30795 | 5992883.6827 | 2110925.23066 | 37.77578879069 | -122.468127322089 | (37.77578879069, -122.468127322089) | 11 | 6 | 2 | 54 | 11 | |
| 64123 | 123208 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.7806735020779 | -122.467400140372 | (37.7806735020779, -122.467400140372) | 11 | 6 | 2 | 54 | 11 | |||
| 76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
| 116652 | 123211 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993134.492 | 2112639.50466 | 37.7805102054167 | -122.467384399185 | (37.7805102054167, -122.467384399185) | 11 | 6 | 2 | 54 | 11 | |||
| 39857 | 8913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4455X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5993194.92162 | 2112721.50101 | 37.7807388335807 | -122.467181309852 | (37.7807388335807, -122.467181309852) | 11 | 6 | 2 | 54 | 11 | |||
| 144340 | 43686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.79836 | 2114426.59889 | 37.785431180637 | -122.46666917492 | (37.785431180637, -122.46666917492) | 11 | 6 | 2 | 54 | 11 | |
| 4479 | 83223 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1446-48 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50888 | 5993687.91761966 | 2105648.90031529 | 37.7613477954461 | -122.464962006978 | (37.7613477954461, -122.464962006978) | 1 | 8 | 11 | 56 | 12 | |
| 132385 | 44257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 122 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2001 12:00:00 AM | 9 | Permit Number 43690 | 5993988.26127 | 2114691.75826 | 37.7861943888941 | -122.464579892109 | (37.7861943888941, -122.464579892109) | 11 | 6 | 1 | 54 | 11 | ||
| 150853 | 34256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.39441 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | 11 | 6 | 1 | 54 | 11 | |
| 74281 | 34259 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.464534489449 | (37.7855927810379, -122.464534489449) | 11 | 6 | 1 | 54 | 11 | |
| 123918 | 34257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39597 | 5993997.84726 | 2114498.92628 | 37.7856654774057 | -122.464532720679 | (37.7856654774057, -122.464532720679) | 11 | 6 | 1 | 54 | 11 | |
| 103672 | 36967 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39594 | 5994314.22367 | 2112999.17695 | 37.7815658043957 | -122.463329288102 | (37.7815658043957, -122.463329288102) | 11 | 6 | 2 | 54 | 11 | |
| 113993 | 36966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.52093 | 2112981.13075 | 37.7815162715185 | -122.463326949801 | (37.7815162715185, -122.463326949801) | 11 | 6 | 2 | 54 | 11 | |
| 39809 | 88509 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 47581 | 88507 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 66880 | 88511 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 71898 | 88508 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 96159 | 88510 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 180009 | 88506 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | |||
| 69913 | 81225 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 225 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49728 | 5994438.42452426 | 2091412.78636228 | 37.7223022264954 | -122.461334300987 | (37.7223022264954, -122.461334300987) | 9 | 8 | 4 | 28861 | 24 | ||
| 101968 | 41934 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 615 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42293 | 5994683.51563 | 2111320.01316 | 37.7769765383201 | -122.461929924013 | (37.7769765383201, -122.461929924013) | 11 | 6 | 2 | 54 | 11 | |
| 84189 | 83512 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49725 | 5994714.51593994 | 2090381.39140811 | 37.719486148882 | -122.460305233079 | (37.719486148882, -122.460305233079) | 9 | 8 | 6 | 28861 | 24 | ||
| 5657 | 41933 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42292 | 5994729.71498 | 2111330.05881 | 37.7770067806052 | -122.461770835952 | (37.7770067806052, -122.461770835952) | 11 | 6 | 2 | 54 | 11 | |
| 34046 | 31982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 232 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 12 | 3x3 | Permit Number 35382 | 5994946.26899 | 2113981.48738 | 37.7842993574965 | -122.461213955921 | (37.7842993574965, -122.461213955921) | 11 | 6 | 2 | 54 | 11 |
| 143264 | 31983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.72464 | 2113855.38064 | 37.7839533587811 | -122.461189396885 | (37.7839533587811, -122.461189396885) | 11 | 6 | 2 | 54 | 11 |
| 32350 | 84048 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49723 | 5995065.73258922 | 2090627.8481306 | 37.7201830572422 | -122.459109050516 | (37.7201830572422, -122.459109050516) | 9 | 8 | 6 | 28861 | 24 | ||
| 116142 | 80705 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3118 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50051 | 5996015.97757 | 2111454.39172 | 37.7774221266328 | -122.457330280254 | (37.7774221266328, -122.457330280254) | 11 | 6 | 2 | 54 | 16 | |
| 60418 | 88523 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 10 Valdez Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417 | 2093827.6 | 37.7290464055545 | -122.454669245202 | (37.7290464055545, -122.454669245202) | 9 | 7 | 4 | 28861 | 40 | |||
| 101659 | 87845 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 6 Minerva St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 3x3 | Permit Number 50752 | 5996525.4 | 2089078.3 | 37.7160121664781 | -122.453951648081 | (37.7160121664781, -122.453951648081) | 9 | 8 | 6 | 28861 | 24 | |||
| 151959 | 81505 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49730 | 5996533.25550088 | 2090072.07142613 | 37.7187412808671 | -122.453996225339 | (37.7187412808671, -122.453996225339) | 9 | 8 | 6 | 28861 | 24 | ||
| 48378 | 213853 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 339 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996569.29854 | 2106950.59972 | 37.7650876471008 | -122.455090641935 | (37.7650876471008, -122.455090641935) | 15 | 5 | 11 | 29492 | 12 | |||
| 60565 | 79256 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 627 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50884 | 5996581.50943321 | 2107294.3742688 | 37.7660322643278 | -122.455073251071 | (37.7660322643278, -122.455073251071) | 15 | 5 | 11 | 29492 | 12 | ||
| 46483 | 83567 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | 15 | 5 | 11 | 29492 | 12 | ||
| 153745 | 83991 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | 15 | 5 | 11 | 29492 | 12 | ||
| 27312 | 88136 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690 | 2096237 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | 9 | 7 | 4 | 59 | 40 | |||
| 71637 | 88243 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2745 Turk Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51229 | 5997744.2 | 2111601.2 | 37.7779243335514 | -122.451362410862 | (37.7779243335514, -122.451362410862) | 15 | 6 | 2 | 54 | 16 | |||
| 66671 | 38887 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.65961 | 2115308.75845 | 37.7881263812657 | -122.450296300351 | (37.7881263812657, -122.450296300351) | 13 | 6 | 1 | 54 | 31 | |
| 144038 | 38888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998132.12011 | 2115294.26521 | 37.7880867274765 | -122.45028674235 | (37.7880867274765, -122.45028674235) | 13 | 6 | 1 | 54 | 31 | |
| 121788 | 213854 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 494 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998170.4747 | 2095280.37565 | 37.7331358031646 | -122.448711968308 | (37.7331358031646, -122.448711968308) | 9 | 7 | 4 | 59 | 40 |
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) );