trees
2,984 rows where qSpecies_id = 44
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86 | 239818 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 219 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007803 | 2098062 | 37.7413196437149 | -122.415606526646 | (37.7413196437149, -122.415606526646) | 2 | 7 | 7 | 28859 | 2 | |||
549 | 63156 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.4693765688 | (37.7605085633711, -122.4693765688) | 1 | 8 | 4 | 56 | 12 | ||
576 | 196628 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 147 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6012615.71361 | 2114306.35859 | 37.78619239642 | -122.400106306963 | (37.78619239642, -122.400106306963) | 12 | 2 | 9 | 28855 | 6 | |||
643 | 239888 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 600x Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008652.64365 | 2096913.58009 | 37.7382140571273 | -122.412587583947 | (37.7382140571273, -122.412587583947) | 10 | 7 | 7 | 28859 | 2 | |||
853 | 239879 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 98x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007643 | 2096532 | 37.7371096061155 | -122.41605142546 | (37.7371096061155, -122.41605142546) | 2 | 7 | 7 | 28859 | 2 | |||
909 | 239889 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1090 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008075 | 2097674 | 37.7402695670625 | -122.414638592511 | (37.7402695670625, -122.414638592511) | 2 | 7 | 7 | 28859 | 2 | |||
1043 | 99282 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1500 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 6003016.20305 | 2114040.83621 | 37.7849234280868 | -122.433299082538 | (37.7849234280868, -122.433299082538) | 13 | 9 | 11 | 29490 | 13 | |||
1103 | 5214 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 835 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 12/09/2001 12:00:00 AM | 3 | 3X3 | 6001489.0793 | 2111327.2763 | 37.7773859294292 | -122.438387950593 | (37.7773859294292, -122.438387950593) | 15 | 5 | 11 | 29492 | 41 | |
1215 | 253279 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | ROW IS 10' tree is street tree | |||||||||||||
1283 | 41795 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1201 08th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42196 | 6012618.34920617 | 2107219.96513791 | 37.7667349263458 | -122.39959946704 | (37.7667349263458, -122.39959946704) | 14 | 3 | 8 | 28856 | 20 | ||
1418 | 239822 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 459 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007877.86373 | 2096695.54674 | 37.7375718719474 | -122.415250966677 | (37.7375718719474, -122.415250966677) | 2 | 7 | 7 | 28859 | 2 | |||
1634 | 239981 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 822 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003059.22614 | 2103447.6834 | 37.7558396702922 | -122.432393383958 | (37.7558396702922, -122.432393383958) | 2 | 4 | 5 | 28862 | 22 | |||
1639 | 27492 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2016 12:00:00 AM | 3 | 3X3 | 6006409.07404 | 2101649.59564 | 37.7510919153811 | -122.420680862742 | (37.7510919153811, -122.420680862742) | 2 | 4 | 5 | 28859 | 19 | ||
1726 | 179199 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 65 Blythdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006710.21835 | 2086918.77417 | 37.710661269476 | -122.41859498419 | (37.710661269476, -122.41859498419) | 9 | 7 | 8 | 309 | 39 | |||
1746 | 136062 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1776 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006341.69714 | 2116340.45076 | 37.7914256952996 | -122.421957338886 | (37.7914256952996, -122.421957338886) | 13 | 9 | 10 | 28858 | 21 | |||
1753 | 136092 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2940 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000097.27545 | 2116458.41469 | 37.7913954447862 | -122.44357132927 | (37.7913954447862, -122.44357132927) | 13 | 6 | 1 | 29490 | 27 | |||
1863 | 239881 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 98x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007643 | 2096532 | 37.7371096061155 | -122.41605142546 | (37.7371096061155, -122.41605142546) | 2 | 7 | 7 | 28859 | 2 | |||
1877 | 239990 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 415 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003615.05068 | 2103303.384 | 37.7554749601184 | -122.43046086767 | (37.7554749601184, -122.43046086767) | 2 | 4 | 5 | 28862 | 22 | |||
1962 | 122597 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
2172 | 53666 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/1969 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) | 13 | 9 | 10 | 28858 | 21 |
2316 | 238954 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 601 Alabama St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009016.01194 | 2105344.62154 | 37.7613842047483 | -122.411926853834 | (37.7613842047483, -122.411926853834) | 2 | 4 | 7 | 28859 | 19 | |||
2380 | 51181 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2550& VICENTE 24th Ave | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.7400043920325 | -122.480761277613 | (37.7400043920325, -122.480761277613) | 1 | 8 | 3 | 29491 | 35 | |||
2406 | 71438 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 671 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003019.09073 | 2089456.91868 | 37.717421959831 | -122.431533418034 | (37.717421959831, -122.431533418034) | 9 | 7 | 6 | 28861 | 5 | |||
2510 | 179262 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 705 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005334.00984 | 2092468.15203 | 37.7258210881568 | -122.423745792743 | (37.7258210881568, -122.423745792743) | 9 | 7 | 7 | 309 | 5 | |||
2543 | 239891 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1090 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008075 | 2097674 | 37.7402695670625 | -122.414638592511 | (37.7402695670625, -122.414638592511) | 2 | 7 | 7 | 28859 | 2 | |||
2665 | 93046 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 155 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5987682.5 | 2114946.6 | 37.7865285787391 | -122.486414608476 | (37.7865285787391, -122.486414608476) | 11 | 6 | 1 | 55 | 33 | |||
2765 | 70112 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1370 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001294.7984 | 2110430.7519 | 37.7749132467463 | -122.438995763743 | (37.7749132467463, -122.438995763743) | 15 | 5 | 11 | 29492 | 10 | |||
2773 | 71586 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 3x3 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | 9 | 8 | 6 | 28861 | 25 | ||
2881 | 89636 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3449X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5987913.17496 | 2111856.82902 | 37.7780583867588 | -122.485389725897 | (37.7780583867588, -122.485389725897) | 11 | 6 | 2 | 55 | 26 | ||
2885 | 102680 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 6 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
3120 | 239081 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 317 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004345.11972 | 2098953.38932 | 37.7435722151987 | -122.427626157827 | (37.7435722151987, -122.427626157827) | 2 | 7 | 5 | 63 | 22 | |||
3200 | 196841 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 385 Channel | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014074.004 | 2109042.91847 | 37.7718213847826 | -122.39469223806 | (37.7718213847826, -122.39469223806) | 14 | 3 | 9 | 310 | 20 | |||
3349 | 179251 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 689 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002976.09571 | 2089391.08009 | 37.7172387445483 | -122.431677333844 | (37.7172387445483, -122.431677333844) | 9 | 7 | 6 | 28861 | 5 | |||
3515 | 40789 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 27 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41740 | 5993852.22414759 | 2092279.20351858 | 37.7246474428237 | -122.463423485902 | (37.7246474428237, -122.463423485902) | 9 | 8 | 4 | 59 | 40 | ||
3517 | 239880 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 98x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007643 | 2096532 | 37.7371096061155 | -122.41605142546 | (37.7371096061155, -122.41605142546) | 2 | 7 | 7 | 28859 | 2 | |||
3572 | 142573 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2201 MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008919.584 | 2120909.0921 | 37.8041151042823 | -122.413361099144 | (37.8041151042823, -122.413361099144) | 3 | 1 | 10 | 308 | 23 | |||
3653 | 16338 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 862X Monterey Blvd | 8 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996505.10477 | 2094713.35848 | 37.7314835390346 | -122.454428620411 | (37.7314835390346, -122.454428620411) | 9 | 7 | 4 | 59 | 40 | ||
3792 | 46228 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 55 02nd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44531 | 6012528.68122922 | 2115201.03212894 | 37.7886441073773 | -122.400470285309 | (37.7886441073773, -122.400470285309) | 12 | 2 | 9 | 28855 | 6 | |||
3934 | 31841 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1186 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 4 | Permit Number 41234 | 6009746.4587 | 2110415.4092 | 37.7753483728099 | -122.409758470745 | (37.7753483728099, -122.409758470745) | 8 | 2 | 9 | 28853 | 34 | |
4065 | 239795 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 201 Charles St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004844.35768 | 2097219.09299 | 37.738838458235 | -122.425776496984 | (37.738838458235, -122.425776496984) | 2 | 7 | 5 | 63 | 7 | |||
4072 | 100150 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 4007 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002942 | 2105314 | 37.7609574805046 | -122.432932117926 | (37.7609574805046, -122.432932117926) | 2 | 4 | 5 | 28862 | 3 | |||
4103 | 73436 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 376 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014381.64402 | 2112223.83347 | 37.7805725617252 | -122.393850778385 | (37.7805725617252, -122.393850778385) | 6 | 2 | 9 | 28856 | 6 | |||
4280 | 264767 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 90x Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
4310 | 247395 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 250 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6001848.3229 | 2109217.0966 | 37.7716123305054 | -122.436994101291 | (37.7716123305054, -122.436994101291) | 15 | 5 | 11 | 29492 | 9 | |||
4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
4523 | 239897 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 166 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007503.26191 | 2100211.86794 | 37.7472058476779 | -122.416795191638 | (37.7472058476779, -122.416795191638) | 2 | 7 | 7 | 28859 | 2 | |||
4750 | 113090 | Section 806 (d) 5 | Pyrus calleryana :: Ornamental Pear 44 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.60872 | 37.7303322746045 | -122.41230559973 | (37.7303322746045, -122.41230559973) | 9 | 3 | 7 | 309 | 28 | ||
4899 | 23093 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1370 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1992 12:00:00 AM | 3 | 3X3 | 6006411.8269 | 2101585.66917 | 37.7509165430738 | -122.420666805454 | (37.7509165430738, -122.420666805454) | 2 | 4 | 5 | 28859 | 19 | ||
5028 | 240104 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 8 Landers St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004442.24489 | 2107681.42962 | 37.7675428547359 | -122.427912126062 | (37.7675428547359, -122.427912126062) | 8 | 4 | 5 | 28862 | 3 | |||
5136 | 240078 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3990 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003770.97869 | 2104233.06218 | 37.7580364676148 | -122.429987934902 | (37.7580364676148, -122.429987934902) | 2 | 4 | 5 | 28862 | 3 | |||
5186 | 179269 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 100 Brussels St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010196.1208 | 2094056.79073 | 37.730456426018 | -122.407049673023 | (37.730456426018, -122.407049673023) | 10 | 3 | 7 | 309 | 28 | |||
5241 | 136060 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3130 Pacific Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999150.97483 | 2116651.4742 | 37.7918715206943 | -122.446859395465 | (37.7918715206943, -122.446859395465) | 11 | 6 | 1 | 29490 | 30 | |||
5317 | 196636 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 575 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6012797.81978 | 2114999.00834 | 37.7881044027504 | -122.399524910545 | (37.7881044027504, -122.399524910545) | 12 | 2 | 9 | 28855 | 6 | |||
5323 | 104579 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 201X Channel St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6011985.48737 | 2113104.04931 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | 6 | 2 | 9 | 28853 | 34 | ||||
5557 | 80574 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988121.26409 | 2111709.35839 | 37.777665594619 | -122.484659059603 | (37.777665594619, -122.484659059603) | 11 | 6 | 2 | 55 | 26 | |||
5573 | 259598 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1535 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015492 | 2095493 | 37.734694905807 | -122.388841127643 | (37.734694905807, -122.388841127643) | 10 | 3 | 8 | 58 | 1 | ||||
5597 | 122852 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 74 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6013493.20807 | 2114537.24556 | 37.7868752453512 | -122.397086580503 | (37.7868752453512, -122.397086580503) | 6 | 2 | 9 | 28855 | 6 | |||
5616 | 196859 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 434 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011421.85676 | 2112297.76071 | 37.7806106201269 | -122.404095350623 | (37.7806106201269, -122.404095350623) | 14 | 2 | 9 | 28853 | 34 | |||
5713 | 239106 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 34 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008173.01148 | 2100024.11906 | 37.7467279794217 | -122.414465959253 | (37.7467279794217, -122.414465959253) | 2 | 7 | 7 | 28859 | 2 | |||
5760 | 239043 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 10 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006946.59098 | 2109912.56327 | 37.7738103766763 | -122.419408203329 | (37.7738103766763, -122.419408203329) | 8 | 2 | 9 | 28853 | 19 | |||
5803 | 239820 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 601 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007678.77556 | 2096492.92101 | 37.737004315193 | -122.415924966284 | (37.737004315193, -122.415924966284) | 2 | 7 | 7 | 28859 | 2 | |||
5833 | 213762 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 10 Burnside Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6001221.74362 | 2095979.85162 | 37.7352304105563 | -122.438213027321 | (37.7352304105563, -122.438213027321) | 2 | 7 | 5 | 63 | 7 | |||
5853 | 85552 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 320 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008325.98929 | 2108714.16712 | 37.7705974578492 | -122.414551808542 | (37.7705974578492, -122.414551808542) | 8 | 2 | 9 | 28853 | 19 | |||
5879 | 213844 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 15 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995181.09817 | 2096185.33307 | 37.7354492003227 | -122.459112479366 | (37.7354492003227, -122.459112479366) | 9 | 7 | 4 | 59 | 40 | |||
6134 | 44234 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 599 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2001 12:00:00 AM | Permit Number 43674 | 6014264.27015126 | 2112071.58281381 | 37.7801479924912 | -122.394246170943 | (37.7801479924912, -122.394246170943) | 6 | 2 | 9 | 28856 | 6 | |||
6156 | 49713 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 20 Arco Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | Permit Number 46525 | 5999460.35062419 | 2093111.47695612 | 37.7272541884473 | -122.444096744934 | (37.7272541884473, -122.444096744934) | 9 | 7 | 6 | 28861 | 25 | |||
6443 | 45729 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 235 02nd St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | 6 | 2 | 9 | 28855 | 6 | |||
6448 | 71319 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 582 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003518.59818 | 2089824.00632 | 37.7184582009508 | -122.429833021282 | (37.7184582009508, -122.429833021282) | 9 | 7 | 6 | 28861 | 5 | |||
6467 | 239934 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3274 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007890.85621 | 2100954.47753 | 37.7492666801299 | -122.415507483891 | (37.7492666801299, -122.415507483891) | 2 | 4 | 7 | 28859 | 19 | |||
6515 | 16335 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 862X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996588.55754 | 2094717.49275 | 37.7314996764704 | -122.454140408353 | (37.7314996764704, -122.454140408353) | 9 | 7 | 4 | 59 | 40 | ||
6632 | 79052 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1166 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | 6009403.22119 | 2110965.12543 | 37.7768385235124 | -122.410984649444 | (37.7768385235124, -122.410984649444) | 8 | 2 | 9 | 28853 | 34 | ||
6701 | 42911 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2900 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42822 | 6008853.88469765 | 2103932.85927525 | 37.7574987299949 | -122.412387795343 | (37.7574987299949, -122.412387795343) | 2 | 4 | 7 | 28859 | 19 | ||
6761 | 179217 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005575.94717 | 2088046.16302 | 37.7136929155569 | -122.42259534402 | (37.7136929155569, -122.42259534402) | 9 | 7 | 8 | 309 | 18 | |||
6791 | 139093 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1327 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999727.163 | 2113489.3348 | 37.7832220110255 | -122.444638410955 | (37.7832220110255, -122.444638410955) | 15 | 6 | 1 | 29490 | 31 | ||
6831 | 262158 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 502 Beale St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 6ft | 6015915.20756 | 2113918.4239 | 37.785310630932 | -122.388663733465 | (37.785310630932, -122.388663733465) | 6 | 2 | 9 | 28856 | 6 | ||||
6855 | 196898 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 144 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010212 | 2112178 | 37.7802141122229 | -122.408272392553 | (37.7802141122229, -122.408272392553) | 14 | 2 | 9 | 28853 | 34 | |||
6899 | 196758 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 866 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011094.36919 | 2109083.82475 | 37.7717675927403 | -122.40500193289 | (37.7717675927403, -122.40500193289) | 14 | 2 | 9 | 28853 | 34 | |||
6918 | 51193 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2550& VICENTE 24th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.7400043920325 | -122.480761277613 | (37.7400043920325, -122.480761277613) | 1 | 8 | 3 | 29491 | 35 | |||
6993 | 239890 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1090 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008075 | 2097674 | 37.7402695670625 | -122.414638592511 | (37.7402695670625, -122.414638592511) | 2 | 7 | 7 | 28859 | 2 | |||
7073 | 37000 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2879 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1998 12:00:00 AM | Permit Number 39616 | 6009576.40115772 | 2102750.87061758 | 37.7542937736186 | -122.409805600758 | (37.7542937736186, -122.409805600758) | 2 | 4 | 7 | 28859 | 19 | |||
7111 | 100960 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1520 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2012 12:00:00 AM | 6 | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.7848302351077 | -122.444821957123 | (37.7848302351077, -122.444821957123) | 15 | 6 | 1 | 29490 | 31 | |
7164 | 71334 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 491 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010883.76567 | 2111750.03943 | 37.7790766258278 | -122.40591827913 | (37.7790766258278, -122.40591827913) | 14 | 2 | 9 | 28853 | 34 | |||
7278 | 111739 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 498x 11TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992500 | 2112397 | 37.7798077038492 | -122.469561728712 | (37.7798077038492, -122.469561728712) | 11 | 6 | 2 | 54 | 11 | ||||
7547 | 119857 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 401 Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
7940 | 245907 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 205 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001841.0498 | 2108801.5549 | 37.7704709427473 | -122.436989504702 | (37.7704709427473, -122.436989504702) | 15 | 5 | 11 | 29492 | 9 | |||
8019 | 70074 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 91 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013768.5355 | 2112749.30227 | 37.7819812876472 | -122.396008662095 | (37.7819812876472, -122.396008662095) | 6 | 2 | 9 | 28856 | 6 | |||
8315 | 196872 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 490x Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011142 | 2112015 | 37.7798185846813 | -122.405043598408 | (37.7798185846813, -122.405043598408) | 14 | 2 | 9 | 28853 | 34 | |||
8321 | 81276 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 358 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008507.95071 | 2108616.15322 | 37.7703385555957 | -122.413915465329 | (37.7703385555957, -122.413915465329) | 8 | 2 | 9 | 28853 | 19 | |||
8389 | 238316 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 71 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000727.81383 | 2104893.59115 | 37.7596773040948 | -122.440559845088 | (37.7596773040948, -122.440559845088) | 2 | 4 | 5 | 28862 | 3 | |||
8536 | 65203 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 319 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 13 | 6x7 | Permit Number 27189 | 6003782.01447 | 2091682.57324 | 37.7235763299662 | -122.429054942226 | (37.7235763299662, -122.429054942226) | 9 | 7 | 6 | 28861 | 5 |
8547 | 239084 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 317 29th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004449.02369 | 2098959.15693 | 37.7435939284334 | -122.427267294155 | (37.7435939284334, -122.427267294155) | 2 | 7 | 5 | 63 | 22 | |||
8721 | 74866 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2 Townsend St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015612.0948 | 2112518.9573 | 37.7814512083448 | -122.389614645118 | (37.7814512083448, -122.389614645118) | 6 | 2 | 9 | 28856 | 6 | |||
8947 | 90512 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 601X 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988116.27135 | 2111840.86835 | 37.7780263932704 | -122.484685980299 | (37.7780263932704, -122.484685980299) | 11 | 6 | 2 | 55 | 26 | ||
9098 | 71536 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1159 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6007487.54298 | 2118815.04438 | 37.7982848704132 | -122.418168241475 | (37.7982848704132, -122.418168241475) | 5 | 1 | 10 | 28858 | 32 | |||
9150 | 179209 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1772 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6006471.88428 | 2087727.6982 | 37.7128689836826 | -122.419476073376 | (37.7128689836826, -122.419476073376) | 9 | 7 | 8 | 309 | 39 | |||
9228 | 39870 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 3626 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41421 | 6006079.92775485 | 2101440.50496023 | 37.7504992440337 | -122.421804236007 | (37.7504992440337, -122.421804236007) | 2 | 4 | 5 | 28859 | 19 | ||
9380 | 259601 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1606 Newcomb Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015178 | 2095783 | 37.7354737780225 | -122.389946992713 | (37.7354737780225, -122.389946992713) | 10 | 3 | 8 | 58 | 1 | |||||
9430 | 83463 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.7793166153117 | -122.407540511299 | (37.7793166153117, -122.407540511299) | 14 | 2 | 9 | 28853 | 34 | ||
9473 | 96596 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3342 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988207.53014 | 2111924.69302 | 37.7782618665825 | -122.484376437025 | (37.7782618665825, -122.484376437025) | 11 | 6 | 2 | 55 | 26 | ||
9519 | 241264 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 32 Harry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6003140.40772 | 2097623.29696 | 37.7398518718547 | -122.431696807774 | (37.7398518718547, -122.431696807774) | 2 | 7 | 5 | 63 | 7 |
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) );