trees
2,984 rows where qSpecies_id = 44 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
9584 | 45722 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 235 02nd St | 23 | 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 | |||
9962 | 36495 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 98 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39378 | 5995169.4338934 | 2093305.35572926 | 37.7275408124282 | -122.458944352189 | (37.7275408124282, -122.458944352189) | 9 | 7 | 4 | 28861 | 40 | ||
10073 | 72254 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 435 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003385.22958 | 2091049.68788 | 37.7218160986223 | -122.430381423381 | (37.7218160986223, -122.430381423381) | 9 | 7 | 6 | 28861 | 5 | |||
10085 | 71433 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 270 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010029.1823 | 2121294.154 | 37.8052346245987 | -122.409548430822 | (37.8052346245987, -122.409548430822) | 3 | 1 | 10 | 308 | 23 | |||
10349 | 73404 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1817 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6005442.66502 | 2092673.38524 | 37.7263907466339 | -122.423384762607 | (37.7263907466339, -122.423384762607) | 9 | 7 | 7 | 309 | 5 | |||
10939 | 76392 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015910.96314 | 2112668.39256 | 37.7818780913398 | -122.3885911303 | (37.7818780913398, -122.3885911303) | 6 | 2 | 9 | 28856 | 6 | |||
11010 | 46518 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 557 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2002 12:00:00 AM | 6 | Permit Number 44682 | 6005115.9175 | 2111449.1523 | 37.7779261968351 | -122.425850198804 | (37.7779261968351, -122.425850198804) | 7 | 9 | 11 | 28852 | 10 | |
11179 | 31164 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 543 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34865 | 5992980.10658 | 2090785.65178 | 37.7204962284105 | -122.46632976451 | (37.7204962284105, -122.46632976451) | 9 | 8 | 6 | 64 | 24 | |
11821 | 70515 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1740 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6006352.41597 | 2116998.84277 | 37.7932340799326 | -122.421967042561 | (37.7932340799326, -122.421967042561) | 13 | 9 | 10 | 28858 | 32 | |||
12284 | 57912 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1655 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1977 12:00:00 AM | 6 | Permit Number 16870 | 6006574 | 2116577 | 37.7920882991947 | -122.4211703781 | (37.7920882991947, -122.4211703781) | 13 | 9 | 10 | 28858 | 21 | |
12441 | 101341 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 600 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 10 | Permit Number 32655 | 6008852.9454 | 2120786.882 | 37.8037758043003 | -122.413583058795 | (37.8037758043003, -122.413583058795) | 3 | 1 | 10 | 308 | 23 | ||
13430 | 41165 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 101 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | 6 | Permit Number 41886 | 6012835.78991 | 2114885.77965 | 37.7877956196074 | -122.399385587567 | (37.7877956196074, -122.399385587567) | 12 | 2 | 9 | 28855 | 6 | ||
13784 | 34495 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 185 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38218 | 6008672.47995951 | 2097726.39703626 | 37.7404469880804 | -122.4125764416 | (37.7404469880804, -122.4125764416) | 10 | 7 | 7 | 28859 | 2 | ||
13834 | 41252 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 155 Minna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41945 | 6012533.02981985 | 2114448.22388081 | 37.7865773148555 | -122.40040234125 | (37.7865773148555, -122.40040234125) | 12 | 2 | 9 | 28855 | 6 | |||
13866 | 31865 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 320 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 10 | Permit Number 35307 | 6006529.44451 | 2097322.15123 | 37.7392165134332 | -122.419957553322 | (37.7392165134332, -122.419957553322) | 2 | 7 | 7 | 28859 | 2 | |
14107 | 75903 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 48X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015346.77192 | 2112652.30526 | 37.781802636415 | -122.390541862342 | (37.781802636415, -122.390541862342) | 6 | 2 | 9 | 28856 | 6 | |||
14383 | 41321 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2501 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2000 12:00:00 AM | Permit Number 41987 | 6008891.76752422 | 2103891.36263257 | 37.757386915423 | -122.412253847995 | (37.757386915423, -122.412253847995) | 2 | 4 | 7 | 28859 | 19 | |||
14400 | 74565 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2 Townsend St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015593.8419 | 2112504.14165 | 37.7814095157871 | -122.389676756776 | (37.7814095157871, -122.389676756776) | 6 | 2 | 9 | 28856 | 6 | |||
14421 | 70575 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 376 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6014355.40259 | 2112201.17484 | 37.780508887923 | -122.393939974074 | (37.780508887923, -122.393939974074) | 6 | 2 | 9 | 28856 | 6 | |||
14495 | 71449 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 372 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6011710.51408 | 2119095.92189 | 37.7992928818086 | -122.403575181848 | (37.7992928818086, -122.403575181848) | 3 | 1 | 10 | 308 | 23 | |||
14810 | 81954 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1361-1363 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6003958.5762 | 2112837.8735 | 37.7816738092081 | -122.42995293526 | (37.7816738092081, -122.42995293526) | 7 | 9 | 11 | 29490 | 41 | |||
15060 | 67218 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 67 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30674 | 6004275.36148655 | 2108843.45765699 | 37.7707240599176 | -122.428572194222 | (37.7707240599176, -122.428572194222) | 7 | 9 | 11 | 29492 | 10 | ||
15467 | 31824 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 201 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | 4 | Permit Number 45448 | 6009316.55308 | 2110688.06938 | 37.7760729324473 | -122.411264885376 | (37.7760729324473, -122.411264885376) | 8 | 2 | 9 | 28853 | 34 | ||
15561 | 76374 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015895.28661 | 2112670.71771 | 37.7818836068963 | -122.388645526664 | (37.7818836068963, -122.388645526664) | 6 | 2 | 9 | 28856 | 6 | |||
16119 | 40698 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 100 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | 9 | 7 | 7 | 309 | 5 | |||
16793 | 68761 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 50 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/1997 12:00:00 AM | Permit Number 32684 | 6003960.97119147 | 2105124.66245865 | 37.7604953479062 | -122.429394440481 | (37.7604953479062, -122.429394440481) | 2 | 4 | 5 | 28862 | 3 | ||
17137 | 74718 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2 Townsend St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015601.81755 | 2112509.36844 | 37.7814243096271 | -122.389649529825 | (37.7814243096271, -122.389649529825) | 6 | 2 | 9 | 28856 | 6 | |||
18036 | 72269 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 550 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6003171.66265 | 2090288.8451 | 37.719714892907 | -122.431065391947 | (37.719714892907, -122.431065391947) | 9 | 7 | 6 | 28861 | 5 | |||
18256 | 59759 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 351 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1981 12:00:00 AM | 5 | Permit Number 19197 | 6003911.2246 | 2091379.68793 | 37.722751987086 | -122.428586705712 | (37.722751987086, -122.428586705712) | 9 | 7 | 6 | 28861 | 5 | ||
18293 | 72906 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2456 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989862.7219 | 2098647.8266 | 37.74190339464 | -122.477679844345 | (37.74190339464, -122.477679844345) | 1 | 8 | 3 | 29491 | 35 | |||
18944 | 22285 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 4800 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 6014905.6735 | 2095512.4095 | 37.7347156849635 | -122.390869630779 | (37.7347156849635, -122.390869630779) | 10 | 3 | 8 | 58 | 1 | ||||
19187 | 83156 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1424 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6013323.08625 | 2105703.49891 | 37.7626103035533 | -122.397055543092 | (37.7626103035533, -122.397055543092) | 14 | 3 | 8 | 28856 | 29 | |||
19474 | 40110 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 181 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/1999 12:00:00 AM | 8 | Permit Number 41329 | 6012414.10718 | 2114018.23842 | 37.7853900428467 | -122.400783567509 | (37.7853900428467, -122.400783567509) | 12 | 2 | 9 | 28855 | 6 | ||
19770 | 42905 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 3266 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42818 | 6008404.68857974 | 2104492.58475061 | 37.7590103906497 | -122.413980896225 | (37.7590103906497, -122.413980896225) | 2 | 4 | 7 | 28859 | 19 | ||
20070 | 58011 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 273 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | Permit Number 16978 | 6004745.95622433 | 2100143.84407133 | 37.7468635955697 | -122.426324903854 | (37.7468635955697, -122.426324903854) | 2 | 7 | 5 | 63 | 22 | ||
20073 | 66938 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2001 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1992 12:00:00 AM | 11 | Permit Number 30264 | 5999304.6432 | 2111145.9532 | 37.7767635706095 | -122.445931557256 | (37.7767635706095, -122.445931557256) | 15 | 5 | 11 | 29492 | 16 | ||
20083 | 37012 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1160 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | Permit Number 46140 | 6009450.69417267 | 2102415.32802293 | 37.7533654031898 | -122.410216640239 | (37.7533654031898, -122.410216640239) | 2 | 4 | 7 | 28859 | 19 | ||
20928 | 45721 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 235 02nd St | 22 | 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 | |||
21223 | 41516 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 208 Peninsula Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.7128663589013 | -122.398684103253 | (37.7128663589013, -122.398684103253) | 10 | 3 | 8 | 309 | 1 | |||
21351 | 37036 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39647 | 6004089.21663471 | 2098352.61253716 | 37.7419081418708 | -122.428468194772 | (37.7419081418708, -122.428468194772) | 2 | 7 | 5 | 63 | 7 | ||
21603 | 40937 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 525 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | 20 | Permit Number 41798 | 6013400.10228 | 2111194.56324 | 37.7776918245638 | -122.397174227516 | (37.7776918245638, -122.397174227516) | 6 | 2 | 9 | 28856 | 34 | ||
21655 | 179258 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5989486.24295 | 2090206.21416 | 37.7187030225094 | -122.478364452564 | (37.7187030225094, -122.478364452564) | 1 | 8 | 4 | 64 | 14 | ||||
21689 | 40724 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 220 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41703 | 6008982.90566384 | 2097366.59293774 | 37.7394764615772 | -122.411477693492 | (37.7394764615772, -122.411477693492) | 10 | 7 | 7 | 28859 | 2 | ||
21811 | 52381 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 11TA MARINA Gladeview Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2005 12:00:00 AM | Permit Number 48507 | 5997800.54761885 | 2101816.94019096 | 37.7510624629123 | -122.450461957109 | (37.7510624629123, -122.450461957109) | 1 | 5 | 4 | 63 | 38 | |||
22274 | 187491 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 750 Velasco Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6006526.88476 | 2086669.88596 | 37.7099675513223 | -122.419210983794 | (37.7099675513223, -122.419210983794) | 9 | 7 | 8 | 309 | 39 | ||||
23143 | 36490 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 95 Westwood Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | ||
23494 | 63717 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 235 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1995 12:00:00 AM | Permit Number 24381 | 6007960.71408693 | 2100297.5102895 | 37.7474667218299 | -122.415219414208 | (37.7474667218299, -122.415219414208) | 2 | 7 | 7 | 28859 | 2 | ||
23552 | 48956 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1027 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46143 | 6008645.82394943 | 2102562.73741605 | 37.7537250076262 | -122.413010481414 | (37.7537250076262, -122.413010481414) | 2 | 4 | 7 | 28859 | 19 | |||
23873 | 40439 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 200 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1999 12:00:00 AM | Permit Number 41531 | 6008075.13920751 | 2097687.39390418 | 37.7403063515947 | -122.414639058783 | (37.7403063515947, -122.414639058783) | 2 | 7 | 7 | 28859 | 2 | |||
23980 | 213788 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 409 Edna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998741.33387 | 2094177.61147 | 37.7301404995723 | -122.446659047172 | (37.7301404995723, -122.446659047172) | 9 | 7 | 4 | 28861 | 40 | ||||
24561 | 40408 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1434 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1999 12:00:00 AM | Permit Number 41510 | 5995916.82585047 | 2093587.1639469 | 37.7283575243545 | -122.45638099687 | (37.7283575243545, -122.45638099687) | 9 | 7 | 4 | 28861 | 40 | ||
25304 | 37449 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 439 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39922 | 6010002.74219325 | 2098558.07324133 | 37.7428051587072 | -122.408035532333 | (37.7428051587072, -122.408035532333) | 10 | 7 | 7 | 28859 | 2 | ||
25474 | 39062 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 170 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40775 | 6007083.8764671 | 2106322.81708573 | 37.7639615128545 | -122.418678689976 | (37.7639615128545, -122.418678689976) | 8 | 4 | 7 | 28859 | 19 | ||
25583 | 67177 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 39 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30623 | 6006917.58798394 | 2097076.37412002 | 37.7385635241286 | -122.418598100484 | (37.7385635241286, -122.418598100484) | 2 | 7 | 7 | 28859 | 2 | ||
25890 | 49360 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1875@ EVANS Marin St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | Permit Number 46338 | 6013645.17254623 | 2100501.4512395 | 37.7483445287597 | -122.395577071832 | (37.7483445287597, -122.395577071832) | 10 | 3 | 8 | 58 | 1 | |||
25927 | 239066 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 100x McCoppin St | 9 | Median : Yard | Tree | DPW 1 | 4 | 6005897.29527 | 2109110.01262 | 37.7715476104631 | -122.4229808384 | (37.7715476104631, -122.4229808384) | 8 | 2 | 9 | 28853 | 19 | ||||
26037 | 65257 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1116 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | Permit Number 41363 | 6009436.98979788 | 2102661.78090656 | 37.7540413394573 | -122.410281432576 | (37.7540413394573, -122.410281432576) | 2 | 4 | 7 | 28859 | 19 | ||
26133 | 47286 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2850 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45229 | 6010236.13037587 | 2101085.34021251 | 37.7497575458278 | -122.40740666911 | (37.7497575458278, -122.40740666911) | 2 | 4 | 7 | 28859 | 19 | ||
26147 | 38014 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 33 Ardenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40225 | 5991299.44143565 | 2096251.1163118 | 37.7354059111486 | -122.472537488142 | (37.7354059111486, -122.472537488142) | 1 | 8 | 4 | 29491 | 40 | |||
26644 | 36999 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2879 23rd St | 5 | 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 | |||
26728 | 51177 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2550& VICENTE 24th Ave | 29 | 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 | |||
27424 | 40833 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 150 Spear St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/1999 12:00:00 AM | Permit Number 41765 | 6014612.03281771 | 2116330.74454319 | 37.7918619982363 | -122.393341229651 | (37.7918619982363, -122.393341229651) | 12 | 2 | 9 | 28855 | 6 | |||
28322 | 35715 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 131 06TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 38999 | 6010279 | 2112410 | 37.7808548811168 | -122.408056973756 | (37.7808548811168, -122.408056973756) | 14 | 2 | 9 | 28853 | 34 | |||
28587 | 34529 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 426 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 9 | Permit Number 38238 | 6003601.04008 | 2090970.70967 | 37.7216114641874 | -122.429629792483 | (37.7216114641874, -122.429629792483) | 9 | 7 | 6 | 28861 | 5 | ||
30454 | 41254 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 155 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41945 | 6012533.02981985 | 2114448.22388081 | 37.7865773148555 | -122.40040234125 | (37.7865773148555, -122.40040234125) | 12 | 2 | 9 | 28855 | 6 | |||
30607 | 50269 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 287 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46974 | 6006321.20125143 | 2096107.66060659 | 37.7358700580341 | -122.420591377056 | (37.7358700580341, -122.420591377056) | 2 | 7 | 7 | 28859 | 2 | ||
30711 | 31343 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 240 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 7 | Permit Number 34954 | 6006171.37375 | 2111269.23628 | 37.7774917802638 | -122.422186212726 | (37.7774917802638, -122.422186212726) | 7 | 9 | 11 | 28852 | 10 | |
30752 | 34567 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 167 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38275 | 6008857.58855433 | 2097786.07138285 | 37.74062122784 | -122.411940622198 | (37.74062122784, -122.411940622198) | 10 | 7 | 7 | 28859 | 2 | ||
30843 | 196775 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1200x Owen St | 4 | Median : Yard | Tree | DPW 1 | 4 | 6013724.81339 | 2108580.18859 | 37.7705314116112 | -122.395867690649 | (37.7705314116112, -122.395867690649) | 14 | 3 | 9 | 310 | 20 | ||||
30946 | 44103 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2447 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2000 12:00:00 AM | Permit Number 43615 | 6011288.79690349 | 2102274.03740272 | 37.7530803106012 | -122.403850120301 | (37.7530803106012, -122.403850120301) | 10 | 4 | 8 | 28859 | 19 | |||
31499 | 66823 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1945 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | 12 | Permit Number 30119 | 5998494.0785 | 2110339.7621 | 37.7745036601214 | -122.448677450991 | (37.7745036601214, -122.448677450991) | 15 | 5 | 11 | 29492 | 16 | |
32230 | 247915 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 399 Franconia St | 6 | Side Yard : Yard | Tree | Private 2 | 6 | 6009998.26355 | 2098850.98079 | 37.7436091683313 | -122.408071670679 | (37.7436091683313, -122.408071670679) | 2 | 7 | 7 | 28859 | 2 | ||||
32304 | 31481 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 475 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 6 | Permit Number 35047 | 6001541.53738 | 2103070.3048 | 37.7547173037741 | -122.43761500873 | (37.7547173037741, -122.43761500873) | 2 | 4 | 5 | 28862 | 22 | |
32694 | 38669 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 928 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1998 12:00:00 AM | 9 | Permit Number 40589 | 6000959.3566 | 2111998.7761 | 37.7791995528302 | -122.440268597715 | (37.7791995528302, -122.440268597715) | 15 | 5 | 11 | 29490 | 41 | |
32712 | 51934 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 329 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48161 | 6009143.0719 | 2121468.743 | 37.8056643107542 | -122.412627287124 | (37.8056643107542, -122.412627287124) | 3 | 1 | 10 | 308 | 23 |
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) );