trees
44 rows where Neighborhoods (old) = 26 and qSpecies_id = 123
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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) );