trees
2,984 rows where qSpecies_id = 44 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
13741 | 119763 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
18704 | 119765 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
18795 | 119764 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
12697 | 137870 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2055 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002867.7613 | 2115410.9293 | 37.7886769333923 | -122.433910609054 | (37.7886769333923, -122.433910609054) | 13 | 9 | 1 | 29490 | 27 | |||
15105 | 24812 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2425 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002709.02465 | 2116620.06864 | 37.7919879109555 | -122.434546304291 | (37.7919879109555, -122.434546304291) | 13 | 9 | 1 | 29490 | 27 | ||
25316 | 7336 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002905.15105 | 2115557.99031 | 37.789082847149 | -122.433791761396 | (37.789082847149, -122.433791761396) | 13 | 9 | 1 | 29490 | 27 | |
26160 | 136100 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2930 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999486.95671 | 2117397.99438 | 37.7939404560513 | -122.445750612317 | (37.7939404560513, -122.445750612317) | 13 | 9 | 1 | 57 | 27 | |||
28667 | 136097 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2240 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999362.2119 | 2116523.51189 | 37.791532235263 | -122.44611930918 | (37.791532235263, -122.44611930918) | 13 | 6 | 1 | 29490 | 27 | |||
30041 | 24571 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2252 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002831.27198 | 2116073.36845 | 37.7904937512412 | -122.434084229923 | (37.7904937512412, -122.434084229923) | 13 | 9 | 1 | 29490 | 27 | ||
32755 | 80131 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52336 | 6004315.45310997 | 2119112.20443091 | 37.7989217398797 | -122.429165826066 | (37.7989217398797, -122.429165826066) | 13 | 9 | 1 | 57 | 17 | ||
33976 | 100959 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1520 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2012 12:00:00 AM | 9 | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.7848302351077 | -122.444821957123 | (37.7848302351077, -122.444821957123) | 15 | 6 | 1 | 29490 | 31 | |
36342 | 33137 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 3103 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | 13 | 9 | 1 | 57 | 17 | ||
37485 | 136083 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2711 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001124.17772 | 2116882.42475 | 37.7926181783305 | -122.440048693805 | (37.7926181783305, -122.440048693805) | 13 | 6 | 1 | 29490 | 27 | |||
37904 | 7358 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2318 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6002802.77917 | 2116286.95252 | 37.7910785812701 | -122.434198088572 | (37.7910785812701, -122.434198088572) | 13 | 9 | 1 | 29490 | 27 | ||
38050 | 136071 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2408 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002762.77731 | 2116555.74479 | 37.7918143454067 | -122.434355719034 | (37.7918143454067, -122.434355719034) | 13 | 9 | 1 | 29490 | 27 | |||
40433 | 141050 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 182 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5996588.3852 | 2113109.5611 | 37.7819996451361 | -122.455469802956 | (37.7819996451361, -122.455469802956) | 11 | 6 | 1 | 54 | 31 | |||
40969 | 87920 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1395 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50946 | 5999712.5114 | 2113603.5874 | 37.7835348830065 | -122.444697314266 | (37.7835348830065, -122.444697314266) | 15 | 6 | 1 | 29490 | 31 | |
42611 | 141043 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 178 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996586.3547 | 2113155.248 | 37.7821249727501 | -122.455480130585 | (37.7821249727501, -122.455480130585) | 11 | 6 | 1 | 54 | 31 | |||
44518 | 136079 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2451 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002228.43922 | 2116576.94804 | 37.7918422199011 | -122.436206043599 | (37.7918422199011, -122.436206043599) | 13 | 9 | 1 | 29490 | 27 | |||
45896 | 136104 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2749 Pierce St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001552.22851 | 2117904.90821 | 37.7954500103743 | -122.438640922935 | (37.7954500103743, -122.438640922935) | 13 | 9 | 1 | 57 | 27 | |||
47081 | 48824 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2101 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2002 12:00:00 AM | 7 | Permit Number 46049 | 5999845.49718 | 2116152.30853 | 37.7905405951075 | -122.444420465553 | (37.7905405951075, -122.444420465553) | 13 | 6 | 1 | 29490 | 27 | ||
47131 | 38041 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1517 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40243 | 6000105.0251 | 2114271.6766 | 37.7853916739939 | -122.443387376648 | (37.7853916739939, -122.443387376648) | 15 | 6 | 1 | 29490 | 31 |
49575 | 139094 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1327 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999729.5956 | 2113469.2662 | 37.7831670466549 | -122.444628552271 | (37.7831670466549, -122.444628552271) | 15 | 6 | 1 | 29490 | 31 | |||
50813 | 140923 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 151 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996521.3777 | 2113367.1001 | 37.7827029337701 | -122.455720238688 | (37.7827029337701, -122.455720238688) | 11 | 6 | 1 | 54 | 31 | |||
51085 | 33135 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 3103 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | 13 | 9 | 1 | 57 | 17 | ||
53105 | 136156 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 774 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007537.99806 | 2120955.25152 | 37.8041641801856 | -122.418145463436 | (37.8041641801856, -122.418145463436) | 5 | 1 | 1 | 308 | 32 | |||
55210 | 93117 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2033 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2009 12:00:00 AM | 3x3 | Permit Number 777147 | 6000411 | 2115602 | 37.7890618407655 | -122.442424340369 | (37.7890618407655, -122.442424340369) | 13 | 6 | 1 | 29490 | 27 | ||
55416 | 136090 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1821 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999477.21011 | 2115295.85698 | 37.7881679839041 | -122.445633097005 | (37.7881679839041, -122.445633097005) | 13 | 6 | 1 | 29490 | 31 | |||
55449 | 136111 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2211 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005481.41278 | 2117624.02094 | 37.7949015003653 | -122.425025275317 | (37.7949015003653, -122.425025275317) | 13 | 9 | 1 | 28858 | 27 | |||
57538 | 137869 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2055 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002869.2066 | 2115428.9956 | 37.7887266208629 | -122.433906900398 | (37.7887266208629, -122.433906900398) | 13 | 9 | 1 | 29490 | 27 | |||
58020 | 100961 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1520 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2012 12:00:00 AM | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.7848302351077 | -122.444821957123 | (37.7848302351077, -122.444821957123) | 15 | 6 | 1 | 29490 | 31 | ||
58127 | 136082 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2711 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001110.76206 | 2116876.25639 | 37.7926004778836 | -122.440094669854 | (37.7926004778836, -122.440094669854) | 13 | 6 | 1 | 29490 | 27 | |||
59733 | 136068 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2301 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2007 12:00:00 AM | 5 | Width 4ft | Permit Number 27163 | 6002757.38982 | 2116271.99757 | 37.7910349425641 | -122.434354064289 | (37.7910349425641, -122.434354064289) | 13 | 9 | 1 | 29490 | 27 | |
59997 | 9861 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1350X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2009 12:00:00 AM | 3 | 4X4 | 6005510.31895 | 2114302.95438 | 37.7857843157652 | -122.424688888506 | (37.7857843157652, -122.424688888506) | 13 | 9 | 1 | 28858 | 41 | ||
60002 | 31214 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2558 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2002 12:00:00 AM | 7 | Permit Number 44658 | 6002505.92368 | 2116137.62608 | 37.7906517162521 | -122.435214511362 | (37.7906517162521, -122.435214511362) | 13 | 9 | 1 | 29490 | 27 | ||
60864 | 54467 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2033 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2009 12:00:00 AM | 3x3 | Permit Number 51998 | 6000404.63305738 | 2115603.8762241 | 37.7890666294836 | -122.442446503861 | (37.7890666294836, -122.442446503861) | 13 | 6 | 1 | 29490 | 27 | ||
62110 | 136061 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3311 Pacific Ave | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 5ft | 5998344.32344 | 2116484.47626 | 37.7913668733358 | -122.449638359017 | (37.7913668733358, -122.449638359017) | 13 | 6 | 1 | 54 | 31 | |||
63977 | 87924 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1395 Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50946 | 5999717.4766 | 2113559.9568 | 37.7834153680144 | -122.444676999607 | (37.7834153680144, -122.444676999607) | 15 | 6 | 1 | 29490 | 31 | |
65556 | 23935 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2186X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2011 12:00:00 AM | 3 | 3x3 | 6003526.3275571 | 2115251.7410053 | 37.7882771931097 | -122.431620698179 | (37.7882771931097, -122.431620698179) | 13 | 9 | 1 | 29490 | 27 | ||
67518 | 136078 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2501 Jackson St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002125.65368 | 2116692.08 | 37.792152502181 | -122.43656992546 | (37.792152502181, -122.43656992546) | 13 | 6 | 1 | 29490 | 27 | |||
69034 | 42847 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2507 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 7 | Permit Number 45197 | 6006203.58131 | 2119416.66834 | 37.7998644243564 | -122.422653916865 | (37.7998644243564, -122.422653916865) | 13 | 9 | 1 | 28858 | 32 | |
69623 | 141026 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 170 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996584.6626 | 2113204.996 | 37.7822614704827 | -122.455489581155 | (37.7822614704827, -122.455489581155) | 11 | 6 | 1 | 54 | 31 | |||
73118 | 52001 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3311 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2005 12:00:00 AM | 6 | Permit Number 48219 | 5998322.36129 | 2116482.21861 | 37.7913594179595 | -122.449714184473 | (37.7913594179595, -122.449714184473) | 13 | 6 | 1 | 54 | 31 | ||
73157 | 27381 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2540 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6006997.70161 | 2121072.6946 | 37.8044562233376 | -122.420023542879 | (37.8044562233376, -122.420023542879) | 5 | 1 | 1 | 28858 | 32 | |||
74534 | 24573 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2100 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002899.36519 | 2115591.06429 | 37.78917333154 | -122.433814144628 | (37.78917333154, -122.433814144628) | 13 | 9 | 1 | 29490 | 27 | |
76904 | 24577 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2100 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/1996 12:00:00 AM | 5 | 3X3 | 6002897.54633 | 2115611.42006 | 37.7892291200774 | -122.433821893176 | (37.7892291200774, -122.433821893176) | 13 | 9 | 1 | 29490 | 27 | ||
77465 | 87922 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1395 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50946 | 5999715.0612 | 2113582.0975 | 37.78347602281 | -122.44468694784 | (37.78347602281, -122.44468694784) | 15 | 6 | 1 | 29490 | 31 | |
77879 | 250908 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 279 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986800.41209 | 2114076.10104 | 37.7840869836575 | -122.489402342842 | (37.7840869836575, -122.489402342842) | 11 | 6 | 1 | 55 | 33 | |||
78366 | 106624 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 156 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | Permit Number 778450 | 5996579.9247 | 2113340.3647 | 37.7826328851799 | -122.455515759177 | (37.7826328851799, -122.455515759177) | 11 | 6 | 1 | 54 | 31 | ||
79984 | 11017 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2540 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007000.76456 | 2121055.6377 | 37.8044095620003 | -122.420011732067 | (37.8044095620003, -122.420011732067) | 5 | 1 | 1 | 28858 | 32 | |||
80429 | 38504 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2448 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | Permit Number 40495 | 6006719.11813993 | 2119590.22485423 | 37.8003700386069 | -122.420882291974 | (37.8003700386069, -122.420882291974) | 5 | 9 | 1 | 28858 | 32 | ||
81058 | 250329 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 155 27th Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5987389.94758 | 2114941.60729 | 37.7864978133672 | -122.487426387523 | (37.7864978133672, -122.487426387523) | 11 | 6 | 1 | 55 | 33 | |||
81545 | 48740 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2555 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2002 12:00:00 AM | 2 | Permit Number 46021 | 6003085.61249 | 2117414.49162 | 37.7941905629061 | -122.433300100232 | (37.7941905629061, -122.433300100232) | 13 | 9 | 1 | 29490 | 27 | ||
84165 | 136070 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2322 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6002792.97811 | 2116354.63153 | 37.7912638541958 | -122.434236840357 | (37.7912638541958, -122.434236840357) | 13 | 9 | 1 | 29490 | 27 | |||
84349 | 136085 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2475 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002297.02887 | 2117042.73685 | 37.7931250524351 | -122.436002068349 | (37.7931250524351, -122.436002068349) | 13 | 9 | 1 | 29490 | 27 | |||
85361 | 100087 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003216.8 | 2118972.8 | 37.7984767167189 | -122.432957560795 | (37.7984767167189, -122.432957560795) | 13 | 9 | 1 | 57 | 17 | |||||
86237 | 141027 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 170 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996585.001 | 2113219.2097 | 37.7823005169542 | -122.455489438079 | (37.7823005169542, -122.455489438079) | 11 | 6 | 1 | 54 | 31 | |||
86584 | 36158 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 124 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/2011 12:00:00 AM | 5 | Permit Number 768284 | 5996572.4794 | 2113546.802 | 37.7831992799989 | -122.455556442282 | (37.7831992799989, -122.455556442282) | 11 | 6 | 1 | 54 | 31 | |
88288 | 80093 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1800-1804 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52336 | 6004315.45310997 | 2119112.20443091 | 37.7989217398797 | -122.429165826066 | (37.7989217398797, -122.429165826066) | 13 | 9 | 1 | 57 | 17 | ||
88432 | 136088 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2986 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000447.39515 | 2116180.32861 | 37.790651854736 | -122.442339953224 | (37.790651854736, -122.442339953224) | 13 | 6 | 1 | 29490 | 27 | |||
88523 | 80132 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 2907-2909 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52336 | 6004303.44564273 | 2119114.6178643 | 37.7989276868106 | -122.429207548051 | (37.7989276868106, -122.429207548051) | 13 | 9 | 1 | 57 | 17 | ||
89089 | 30037 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2231 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 6005477.24721 | 2117649.17337 | 37.794970327277 | -122.425041479277 | (37.794970327277, -122.425041479277) | 13 | 9 | 1 | 28858 | 27 | ||
90796 | 136095 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3124 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999717.83603 | 2116079.0763 | 37.7903322339046 | -122.444856897539 | (37.7903322339046, -122.444856897539) | 13 | 6 | 1 | 29490 | 27 | |||
92044 | 136072 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2431 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002704.27518 | 2116650.26812 | 37.7920705613506 | -122.434564897775 | (37.7920705613506, -122.434564897775) | 13 | 9 | 1 | 29490 | 27 | |||
94103 | 11016 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.420005826233 | (37.804348902732, -122.420005826233) | 5 | 1 | 1 | 28858 | 32 | |||
97925 | 90489 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 157 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2014 11:55:00 AM | 3 | 3x3 | 5988004.43303 | 2114943.08312 | 37.7865376821644 | -122.485300555524 | (37.7865376821644, -122.485300555524) | 11 | 6 | 1 | 55 | 33 | ||
98053 | 136069 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002763.98127 | 2116238.68089 | 37.7909438376399 | -122.434328875174 | (37.7909438376399, -122.434328875174) | 13 | 9 | 1 | 29490 | 27 | |||
99848 | 41781 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2836 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | 11 | Permit Number 42193 | 6001115.85631 | 2116271.77232 | 37.7909410119784 | -122.44003367961 | (37.7909410119784, -122.44003367961) | 13 | 6 | 1 | 29490 | 27 | ||
101245 | 58365 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1546 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/1980 12:00:00 AM | 16 | Permit Number 18645 | 6000148.706 | 2114288.9048 | 37.7854414690289 | -122.44323749213 | (37.7854414690289, -122.44323749213) | 15 | 6 | 1 | 29490 | 27 | ||
105696 | 7357 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002807.95732 | 2116239.44488 | 37.7909484313614 | -122.434176774665 | (37.7909484313614, -122.434176774665) | 13 | 9 | 1 | 29490 | 27 | |||
106087 | 100958 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1520 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769191 | 5999686.3 | 2114075.9 | 37.7848302351077 | -122.444821957123 | (37.7848302351077, -122.444821957123) | 15 | 6 | 1 | 29490 | 31 | |
106173 | 87923 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1395 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50946 | 5999715.8663 | 2113572.0336 | 37.7834484358894 | -122.44468343892 | (37.7834484358894, -122.44468343892) | 15 | 6 | 1 | 29490 | 31 | |
106930 | 136076 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2501 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001468.15322 | 2116599.52865 | 37.7918609950398 | -122.438838246815 | (37.7918609950398, -122.438838246815) | 13 | 6 | 1 | 29490 | 27 | |||
107468 | 136109 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1840 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005424.09798 | 2115877.91207 | 37.7901038870467 | -122.425099292201 | (37.7901038870467, -122.425099292201) | 13 | 9 | 1 | 28858 | 27 | |||
108961 | 64429 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2552 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 6 | Permit Number 25281 | 6006994.6099 | 2121088.36171 | 37.8044990670436 | -122.420035354544 | (37.8044990670436, -122.420035354544) | 5 | 1 | 1 | 28858 | 32 | ||
111375 | 136087 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2475 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002328.01711 | 2117044.0845 | 37.7931305131109 | -122.4358949438 | (37.7931305131109, -122.4358949438) | 13 | 9 | 1 | 29490 | 27 | |||
111949 | 136096 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 3124 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999701.12722 | 2116078.56348 | 37.7903298722611 | -122.444914671774 | (37.7903298722611, -122.444914671774) | 13 | 6 | 1 | 29490 | 27 | |||
112249 | 136086 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2475 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002313.34104 | 2117042.73082 | 37.7931259625508 | -122.43594562691 | (37.7931259625508, -122.43594562691) | 13 | 9 | 1 | 29490 | 27 | |||
112607 | 136157 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 774 Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007521.76946 | 2120952.68455 | 37.8041562184887 | -122.41820144175 | (37.8041562184887, -122.41820144175) | 5 | 1 | 1 | 308 | 32 | |||
113860 | 141248 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 35 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996490.2429 | 2114312.3122 | 37.7852964478862 | -122.455896303327 | (37.7852964478862, -122.455896303327) | 11 | 6 | 1 | 54 | 31 | |||
115321 | 110973 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2231 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002796.68152 | 2115999.3322 | 37.7902885034734 | -122.434198615596 | (37.7902885034734, -122.434198615596) | 13 | 9 | 1 | 29490 | 27 | |||
116019 | 45370 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2550 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | 6 | Permit Number 44355 | 6002540.62821 | 2116142.92874 | 37.7906682466794 | -122.435094815171 | (37.7906682466794, -122.435094815171) | 13 | 9 | 1 | 29490 | 27 | ||
117568 | 136091 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1916 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999479.5114 | 2115623.26075 | 37.7890670802258 | -122.445648688558 | (37.7890670802258, -122.445648688558) | 13 | 6 | 1 | 29490 | 27 | |||
117806 | 136094 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2101 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999848.13168 | 2116122.37091 | 37.7904585445707 | -122.444409197947 | (37.7904585445707, -122.444409197947) | 13 | 6 | 1 | 29490 | 27 | |||
118083 | 41632 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 233 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42112 | 5985857.93299624 | 2114290.75052478 | 37.7846212855735 | -122.492678748494 | (37.7846212855735, -122.492678748494) | 11 | 6 | 1 | 55 | 33 | |||
120233 | 123991 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 25 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5993916.44062 | 2115373.28149 | 37.7880615249469 | -122.464877883035 | (37.7880615249469, -122.464877883035) | 11 | 6 | 1 | 54 | 11 | |||
121145 | 136077 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2501 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001495.68997 | 2116602.91699 | 37.7918718651439 | -122.438743212728 | (37.7918718651439, -122.438743212728) | 13 | 6 | 1 | 29490 | 27 | |||
121248 | 106622 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 156 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | Permit Number 778450 | 5996579.2478 | 2113322.09 | 37.7825826688577 | -122.455516779687 | (37.7825826688577, -122.455516779687) | 11 | 6 | 1 | 54 | 31 | ||
125148 | 250907 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 279 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986800.59954 | 2114084.91795 | 37.7841112033057 | -122.489402342861 | (37.7841112033057, -122.489402342861) | 11 | 6 | 1 | 55 | 33 | |||
126129 | 33136 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 3103 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | 13 | 9 | 1 | 57 | 17 | ||
129056 | 24569 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2325 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2001 12:00:00 AM | 4 | 3X3 | 6002751.62684 | 2116304.73966 | 37.7911245168302 | -122.434376345892 | (37.7911245168302, -122.434376345892) | 13 | 9 | 1 | 29490 | 27 | ||
129363 | 136102 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2785 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000265.24445 | 2117449.53048 | 37.7941263665902 | -122.443061371388 | (37.7941263665902, -122.443061371388) | 13 | 9 | 1 | 57 | 27 | |||
131754 | 11436 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2100X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1998 12:00:00 AM | 3 | 3X3 | 6005581.91283 | 2117259.85377 | 37.7939072656655 | -122.424651612384 | (37.7939072656655, -122.424651612384) | 13 | 9 | 1 | 28858 | 27 | ||
131935 | 54752 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2711 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1972 12:00:00 AM | 4 | Permit Number 10600 | 6001093.70548 | 2116875.25307 | 37.79259675199 | -122.44015361411 | (37.79259675199, -122.44015361411) | 13 | 6 | 1 | 29490 | 27 |
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) );