Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5677 | 5677 | 19923 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 11160 | 11160 | 19922 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 11940 | 11940 | 19758 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY15 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 153311 | 153311 | 119966 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5987215.946719999 | 2112352.1893599997 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | |||
| 106101 | 106101 | 90588 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2242 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988605.860309999 | 2110576.30478 | 37.774582755065104 | -122.48289963543999 | (37.7745827550651, -122.48289963544) | ||
| 105391 | 105391 | 90862 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2233 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988638.673219999 | 2110518.9023599997 | 37.7744270531648 | -122.4827819229 | (37.7744270531648, -122.4827819229) | ||
| 112353 | 112353 | 90863 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2207 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988677.47069 | 2110522.18301 | 37.7744383181626 | -122.482647957161 | (37.7744383181626, -122.482647957161) | ||
| 87078 | 87078 | 90864 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | ||
| 118563 | 118563 | 90587 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2200X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988720.72128 | 2110579.96701 | 37.7745994931186 | -122.482502581896 | (37.7745994931186, -122.482502581896) | ||
| 114860 | 114860 | 90865 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2207 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988736.61915 | 2110526.67364 | 37.7744540891609 | -122.482443682946 | (37.7744540891609, -122.482443682946) | ||
| 124538 | 124538 | 90586 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988739.4165199995 | 2110581.09487 | 37.7746036774674 | -122.482437994797 | (37.7746036774674, -122.482437994797) | ||
| 116698 | 116698 | 90585 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2200X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988755.94443 | 2110581.0496 | 37.7746045146176 | -122.48238081885201 | (37.7746045146176, -122.482380818852) | ||
| 105475 | 105475 | 90584 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2150X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988880.62132 | 2110585.72387 | 37.7746246005815 | -122.481949884411 | (37.7746246005815, -122.481949884411) | ||
| 144530 | 144530 | 90866 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2151X Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988924.2943400005 | 2110530.35666 | 37.774475117412294 | -122.481794756145 | (37.7744751174123, -122.481794756145) | ||
| 145646 | 145646 | 91010 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2134 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988937.91177 | 2110588.16813 | 37.7746346435588 | -122.48175188676599 | (37.7746346435588, -122.481751886766) | ||
| 47101 | 47101 | 67973 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31694 | 5988948.22001 | 2110531.76438 | 37.7744803739464 | -122.48171209676799 | (37.7744803739464, -122.481712096768) | |
| 162667 | 162667 | 65010 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | ||
| 100732 | 100732 | 90583 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2116 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988996.38069 | 2110588.45382 | 37.7746388278925 | -122.481549654427 | (37.7746388278925, -122.481549654427) | ||
| 120215 | 120215 | 90582 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989019.95807 | 2110588.86895 | 37.77464133862679 | -122.48146812693301 | (37.7746413386268, -122.481468126933) | ||
| 111122 | 111122 | 90580 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989065.94752 | 2110592.46721 | 37.7746538923373 | -122.481309305666 | (37.7746538923373, -122.481309305666) | ||
| 106028 | 106028 | 90868 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2045 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989180.48685 | 2110539.97505 | 37.774516421933896 | -122.480909251758 | (37.7745164219339, -122.480909251758) | ||
| 97868 | 97868 | 90578 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2050X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989208.063569999 | 2110596.77372 | 37.7746739782763 | -122.48081801885701 | (37.7746739782763, -122.480818018857) | ||
| 47277 | 47277 | 90869 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.2902599997 | 37.774521679169396 | -122.48081139016199 | (37.7745216791694, -122.480811390162) | ||
| 141884 | 141884 | 90577 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2050X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989223.999 | 2110597.6554400004 | 37.7746773254621 | -122.48076296020201 | (37.7746773254621, -122.480762960202) | ||
| 125720 | 125720 | 90871 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989249.74132 | 2110541.7912 | 37.774525433906206 | -122.48066982287901 | (37.7745254339062, -122.480669822879) | ||
| 41621 | 41621 | 120834 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.48059571456498 | (37.7745306911578, -122.480595714565) | |||
| 124225 | 124225 | 90872 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2027 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989286.8509 | 2110543.19375 | 37.7745314416669 | -122.48054155780599 | (37.7745314416669, -122.480541557806) | ||
| 78334 | 78334 | 90576 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2020 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989294.17784 | 2110601.6564700003 | 37.7746923899334 | -122.48052049321001 | (37.7746923899334, -122.48052049321) | ||
| 129274 | 129274 | 90575 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2008 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989345.62252 | 2110602.70137 | 37.774698248555204 | -122.48034261421301 | (37.7746982485552, -122.480342614213) | ||
| 114633 | 114633 | 90873 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2015 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989357.495080001 | 2110545.80132 | 37.7745427066681 | -122.480297379549 | (37.7745427066681, -122.480297379549) | ||
| 138400 | 138400 | 90574 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1950 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989503.12005 | 2110610.6462 | 37.774729213880704 | -122.47979838607701 | (37.7747292138807, -122.479798386077) | ||
| 129042 | 129042 | 90874 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1941 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989523.27614 | 2110553.23403 | 37.774572746859704 | -122.47972446102101 | (37.7745727468597, -122.479724461021) | ||
| 45678 | 45678 | 70389 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.47967027105899 | (37.7747342353889, -122.479670271059) | ||
| 80397 | 80397 | 90572 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989583.92326 | 2110610.46088 | 37.774733398944704 | -122.479518860914 | (37.7747333989447, -122.479518860914) | ||
| 91907 | 91907 | 90879 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.0238099997 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | ||
| 139450 | 139450 | 90880 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1901X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989653.273680001 | 2110557.04805 | 37.7745907701264 | -122.47927505813101 | (37.7745907701264, -122.479275058131) | ||
| 83303 | 83303 | 90571 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989655.61233 | 2110613.51621 | 37.7747459519392 | -122.47927110015301 | (37.7747459519392, -122.479271100153) | ||
| 56244 | 56244 | 65529 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | ||
| 90507 | 90507 | 90570 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1830 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989885.34607 | 2110621.45957 | 37.7747811022825 | -122.478476993955 | (37.7747811022825, -122.478476993955) | ||
| 146278 | 146278 | 90883 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1827 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989887.73623 | 2110565.21832 | 37.7746268180643 | -122.478464612476 | (37.7746268180643, -122.478464612476) | ||
| 95330 | 95330 | 90569 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.282380001 | 2110623.46415 | 37.7747886345028 | -122.47835629000099 | (37.7747886345028, -122.478356290001) | ||
| 109934 | 109934 | 90568 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1818 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989946.281719999 | 2110622.60957 | 37.774787797349205 | -122.478266291409 | (37.7747877973492, -122.478266291409) | ||
| 100760 | 100760 | 90567 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1800 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5989974.77369 | 2110623.83605 | 37.77479281883429 | -122.47816782258002 | (37.7747928188343, -122.47816782258) | ||
| 95423 | 95423 | 90884 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.9065900003 | 37.774664776015705 | -122.477624799049 | (37.7746647760157, -122.477624799049) | ||
| 105099 | 105099 | 90885 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1733 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990174.4288 | 2110576.33984 | 37.7746739946122 | -122.47747370962601 | (37.7746739946122, -122.477473709626) | ||
| 142244 | 142244 | 90886 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1715 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990248.62617 | 2110577.3664599997 | 37.774681118557794 | -122.477217123809 | (37.7746811185578, -122.477217123809) | ||
| 46628 | 46628 | 90888 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.389219999 | 2110587.7825599997 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | ||
| 42415 | 42415 | 122016 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.774725954752796 | -122.47639488146099 | (37.7747259547528, -122.476394881461) | |||
| 75789 | 75789 | 90892 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1543 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990781.4854 | 2110598.61863 | 37.774770372701504 | -122.475375427468 | (37.7747703727015, -122.475375427468) | ||
| 94538 | 94538 | 90894 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.866169999 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | ||
| 79054 | 79054 | 100424 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 88841 | 88841 | 100425 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 158009 | 158009 | 213852 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991160.0842699995 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | |||
| 135531 | 135531 | 124090 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 601 Funston Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991893.39709 | 2111137.1044099997 | 37.776313297478204 | -122.471568380763 | (37.7763132974782, -122.471568380763) | ||||
| 118427 | 118427 | 88525 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 626x Funston Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51466 | 5991969.3 | 2111151.0 | 37.7763558419216 | -122.47130682669399 | (37.7763558419216, -122.471306826694) | |||
| 84441 | 84441 | 90554 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1150 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992007.5751 | 2110699.64473 | 37.7751187568292 | -122.47114153279199 | (37.7751187568292, -122.471141532792) | ||
| 129112 | 129112 | 90897 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1145 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992033.67177 | 2110642.90774 | 37.774964481845394 | -122.471047125233 | (37.7749644818454, -122.471047125233) | ||
| 127917 | 127917 | 90555 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992035.9437 | 2110699.81053 | 37.7751208528883 | -122.471043412514 | (37.7751208528883, -122.471043412514) | ||
| 86262 | 86262 | 90896 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992053.33041 | 2110644.47867 | 37.7749699321879 | -122.47097923688 | (37.7749699321879, -122.47097923688) | ||
| 25708 | 25708 | 41912 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | |
| 34152 | 34152 | 41913 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 642 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992259.32657 | 2111046.49076 | 37.7760856603427 | -122.470295940533 | (37.7760856603427, -122.470295940533) | |
| 52082 | 52082 | 123105 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 498 11th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992529.16869 | 2112181.64232 | 37.7792180760249 | -122.46944514164801 | (37.7792180760249, -122.469445141648) | |||
| 150026 | 150026 | 111741 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 498x 11th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5992530.718830001 | 2112167.7442799998 | 37.7791800053719 | -122.469438767189 | (37.7791800053719, -122.469438767189) | |||
| 185002 | 185002 | 123179 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992862.96444 | 2110216.5600400004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | |||
| 96342 | 96342 | 67314 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 666 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 7 | Permit Number 30795 | 5992883.6827 | 2110925.23066 | 37.77578879069 | -122.468127322089 | (37.77578879069, -122.468127322089) | |
| 62637 | 62637 | 123208 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.780673502077896 | -122.467400140372 | (37.7806735020779, -122.467400140372) | |||
| 76557 | 76557 | 123210 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | |||
| 62629 | 62629 | 123211 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993134.492000001 | 2112639.5046599996 | 37.780510205416704 | -122.46738439918501 | (37.7805102054167, -122.467384399185) | |||
| 82630 | 82630 | 8913 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4455X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5993194.92162 | 2112721.50101 | 37.780738833580706 | -122.46718130985201 | (37.7807388335807, -122.467181309852) | |||
| 49905 | 49905 | 43686 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.798359999 | 2114426.59889 | 37.785431180637005 | -122.46666917491999 | (37.785431180637, -122.46666917492) | |
| 47985 | 47985 | 83223 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1446-48 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50888 | 5993687.91761966 | 2105648.90031529 | 37.7613477954461 | -122.464962006978 | (37.7613477954461, -122.464962006978) | |
| 70189 | 70189 | 44257 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 122 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2001 12:00:00 AM | 9 | Permit Number 43690 | 5993988.26127 | 2114691.75826 | 37.7861943888941 | -122.464579892109 | (37.7861943888941, -122.464579892109) | ||
| 31204 | 31204 | 34256 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.3944099997 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | |
| 188003 | 188003 | 34259 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.46453448944901 | (37.7855927810379, -122.464534489449) | |
| 37502 | 37502 | 34257 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 160 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39597 | 5993997.84726 | 2114498.92628 | 37.78566547740571 | -122.464532720679 | (37.7856654774057, -122.464532720679) | |
| 184533 | 184533 | 36967 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39594 | 5994314.223669999 | 2112999.17695 | 37.781565804395704 | -122.463329288102 | (37.7815658043957, -122.463329288102) | |
| 75960 | 75960 | 36966 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.520930001 | 2112981.13075 | 37.781516271518505 | -122.463326949801 | (37.7815162715185, -122.463326949801) | |
| 171042 | 171042 | 41934 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 615 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42293 | 5994683.51563 | 2111320.0131599996 | 37.776976538320106 | -122.461929924013 | (37.7769765383201, -122.461929924013) | |
| 81498 | 81498 | 88509 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 81712 | 81712 | 88507 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 85750 | 85750 | 88508 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 90269 | 90269 | 88511 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 102080 | 102080 | 88510 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 141178 | 141178 | 88506 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | |||
| 72018 | 72018 | 41933 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 610 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 6 | Permit Number 42292 | 5994729.714980001 | 2111330.05881 | 37.7770067806052 | -122.461770835952 | (37.7770067806052, -122.461770835952) | |
| 89007 | 89007 | 81225 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 225 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49728 | 5994438.42452426 | 2091412.78636228 | 37.7223022264954 | -122.46133430098699 | (37.7223022264954, -122.461334300987) | ||
| 144360 | 144360 | 31982 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 232 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | 3x3 | Permit Number 35382 | 5994946.26899 | 2113981.48738 | 37.7842993574965 | -122.461213955921 | (37.7842993574965, -122.461213955921) |
| 171371 | 171371 | 31983 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.724640001 | 2113855.38064 | 37.7839533587811 | -122.46118939688499 | (37.7839533587811, -122.461189396885) |
| 95196 | 95196 | 83512 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49725 | 5994714.51593994 | 2090381.39140811 | 37.719486148882 | -122.460305233079 | (37.719486148882, -122.460305233079) | ||
| 127743 | 127743 | 84048 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49723 | 5995065.73258922 | 2090627.8481306 | 37.7201830572422 | -122.45910905051599 | (37.7201830572422, -122.459109050516) | ||
| 162238 | 162238 | 80705 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3118 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50051 | 5996015.97757 | 2111454.39172 | 37.77742212663279 | -122.457330280254 | (37.7774221266328, -122.457330280254) | |
| 64650 | 64650 | 213853 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 339 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996569.29854 | 2106950.5997200003 | 37.7650876471008 | -122.455090641935 | (37.7650876471008, -122.455090641935) | |||
| 90981 | 90981 | 79256 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 627 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50884 | 5996581.50943321 | 2107294.3742688 | 37.7660322643278 | -122.455073251071 | (37.7660322643278, -122.455073251071) | ||
| 91806 | 91806 | 88523 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
| 118308 | 118308 | 81505 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49730 | 5996533.25550088 | 2090072.07142613 | 37.7187412808671 | -122.453996225339 | (37.7187412808671, -122.453996225339) | ||
| 97864 | 97864 | 87845 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 6 Minerva St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 3x3 | Permit Number 50752 | 5996525.4 | 2089078.3 | 37.7160121664781 | -122.453951648081 | (37.7160121664781, -122.453951648081) | |||
| 81470 | 81470 | 83567 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | ||
| 122901 | 122901 | 83991 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | ||
| 86876 | 86876 | 88243 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2745 Turk Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51229 | 5997744.2 | 2111601.2 | 37.7779243335514 | -122.451362410862 | (37.7779243335514, -122.451362410862) | |||
| 78043 | 78043 | 88136 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690.0 | 2096237.0 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");