2,984 rows where qSpecies_id = 44

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);