trees

199 rows where Supervisor Districts = 7 and qSpecies_id = 123 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
11610 241384 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008146.34247 2105906.05304 37.7628769363446 -122.414974425147 (37.7628769363446, -122.414974425147) 8 4 7 28859 19
13645 70110 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 79 Stoneyford Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6006114.15907 2093862.38939 37.7296933683514 -122.421147824905 (37.7296933683514, -122.421147824905) 9 7 7 28861 5
14811 241276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010713.5875 2101085.71194 37.7497852786664 -122.405755620526 (37.7497852786664, -122.405755620526) 10 4 7 28859 19
15698 241342 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2122 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009546.72381 2104789.44467 37.7598895755605 -122.410052140597 (37.7598895755605, -122.410052140597) 2 4 7 28859 19
16220 179280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010456.33755 2094955.50587 37.7329386663832 -122.406213356571 (37.7329386663832, -122.406213356571) 10 3 7 309 28
16406 241355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2970 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009659.81185 2101050.9246 37.7496307742409 -122.409397182327 (37.7496307742409, -122.409397182327) 2 4 7 28859 19
22095 241295 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1350 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007154.42592 2107655.79566 37.7676255312226 -122.418529207767 (37.7676255312226, -122.418529207767) 8 4 7 28853 19
25956 241315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007487.69135 2105254.04954 37.7610496524471 -122.417206271746 (37.7610496524471, -122.417206271746) 2 4 7 28859 19
30264 241366 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1399 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010111.5288 2101104.25474 37.7498025060946 -122.40783888207 (37.7498025060946, -122.40783888207) 2 4 7 28859 19
32834 241370 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009531.75591 2102750.92335 37.7542914163323 -122.409959999651 (37.7542914163323, -122.409959999651) 2 4 7 28859 19
36145 241371 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2865 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009580.01982 2102754.75587 37.7543046444459 -122.40979336069 (37.7543046444459, -122.40979336069) 2 4 7 28859 19
39070 241380 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4050 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008348.5979 2096262.44881 37.7364091240834 -122.413592786804 (37.7364091240834, -122.413592786804) 10 7 7 28859 2
42098 241379 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3702 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008438.87775 2097614.97452 37.7401279331501 -122.413376271417 (37.7401279331501, -122.413376271417) 2 7 7 28859 2
50595 241318 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 280 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007336.81249 2108065.49507 37.7687607355409 -122.417927400355 (37.7687607355409, -122.417927400355) 8 4 7 28853 19
51857 241278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010738.66995 2101021.37362 37.7496100223844 -122.405664352824 (37.7496100223844, -122.405664352824) 10 4 7 28859 19
52753 241325 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007441.87524 2107194.22963 37.766374357512 -122.417502238664 (37.766374357512, -122.417502238664) 8 4 7 28853 19
52926 241317 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007335.93397 2108086.9588 37.7688196204438 -122.417931960818 (37.7688196204438, -122.417931960818) 8 4 7 28853 19
54649 241274 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2616 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010311.63301 2104008.02665 37.7577868194278 -122.407351591615 (37.7577868194278, -122.407351591615) 10 4 7 28859 19
56814 241333 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 259 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007398.77752 2108173.34419 37.7690603509832 -122.417720712761 (37.7690603509832, -122.417720712761) 8 4 7 28853 19
60684 241329 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 349 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007417.32507 2107664.81767 37.7676651004942 -122.417620510295 (37.7676651004942, -122.417620510295) 8 4 7 28853 19
67177 241335 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Coso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007049.61155 2099992.5386 37.7465780921238 -122.418348334311 (37.7465780921238, -122.418348334311) 2 7 7 28859 2
68023 241368 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2879 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009498.83241 2102749.66821 37.75428612472 -122.410073769282 (37.75428612472, -122.410073769282) 2 4 7 28859 19
73623 247601 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 6 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009211.63365 2096404.06359 37.7368463915456 -122.410618895163 (37.7368463915456, -122.410618895163) 10 7 7 28859 2
78586 241277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010729.0783 2101044.09639 37.749671877762 -122.405699121544 (37.749671877762, -122.405699121544) 10 4 7 28859 19
79863 241303 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007544.46079 2105381.89304 37.7614038747014 -122.417018988842 (37.7614038747014, -122.417018988842) 2 4 7 28859 19
80892 120913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 499X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     5 3x3   6007431 2106864 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
86391 241321 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 356 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007355.98691 2107612.7207 37.7675186027402 -122.417828978541 (37.7675186027402, -122.417828978541) 8 4 7 28853 19
86529 179278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 223 Pioche St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006228.66725 2093396.90262 37.7284216981869 -122.420718924746 (37.7284216981869, -122.420718924746) 9 7 7 309 5
88879 241357 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6008659.53051 2102232.08888 37.7528178906343 -122.412939704518 (37.7528178906343, -122.412939704518) 2 4 7 28859 19
89764 241327 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 377 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007424.50403 2107516.88319 37.7672593111026 -122.417585193005 (37.7672593111026, -122.417585193005) 8 4 7 28853 19
92157 121263 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 700 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     5 3x3   6007449 2105508 37.7617447647779 -122.41735808585 (37.7617447647779, -122.41735808585) 2 4 7 28859 19
92727 241365 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1475 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6010134.56863 2100721.5441 37.7487529567978 -122.407732226982 (37.7487529567978, -122.407732226982) 2 4 7 28859 19
95270 241307 Undocumented 4 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 629 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007511.70266 2105973.00163 37.7630250789657 -122.417174173153 (37.7630250789657, -122.417174173153) 8 4 7 28859 19
95383 241300 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007560.00542 2105104.33275 37.7606426327636 -122.416945560095 (37.7606426327636, -122.416945560095) 2 4 7 28859 19
102687 241279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010767.41286 2100951.64139 37.7494201602129 -122.405560047672 (37.7494201602129, -122.405560047672) 10 4 7 28859 19
103612 241364 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 826 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6009889.67634 2104361.42581 37.7587335483391 -122.408835831807 (37.7587335483391, -122.408835831807) 2 4 7 28859 19
103723 241301 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 765 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007553.45453 2105201.24032 37.7609083500518 -122.416975083028 (37.7609083500518, -122.416975083028) 2 4 7 28859 19
105407 241312 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 700 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007473.64747 2105479.75896 37.7616686081336 -122.41727083858 (37.7616686081336, -122.41727083858) 2 4 7 28859 19
105683 241297 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1534 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007142.6566 2107359.78421 37.7668120908263 -122.418548923599 (37.7668120908263, -122.418548923599) 8 4 7 28853 19
108520 241298 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007561.5863 2105063.97813 37.760531917228 -122.416937233294 (37.760531917228, -122.416937233294) 2 4 7 28859 19
111775 241385 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008146.20784 2105935.07496 37.7629566162671 -122.41497694503 (37.7629566162671, -122.41497694503) 8 4 7 28859 19
114516 241358 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 6ft   6008654.31002 2102275.26835 37.7529361586965 -122.412960810713 (37.7529361586965, -122.412960810713) 2 4 7 28859 19
118012 241319 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007346.30903 2107764.0705 37.7679336290724 -122.417873182915 (37.7679336290724, -122.417873182915) 8 4 7 28853 19
123616 241386 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008144.96622 2105963.39406 37.763034304202 -122.414983243884 (37.763034304202, -122.414983243884) 8 4 7 28859 19
123745 241313 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 720 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007476.61227 2105442.18225 37.7615655979969 -122.417257921613 (37.7615655979969, -122.417257921613) 2 4 7 28859 19
123994 121589 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270x South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007359 2108191 37.7691065911809 -122.417859552844 (37.7691065911809, -122.417859552844) 8 4 7 28853 19
126071 241306 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 635 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007512.51553 2105948.57414 37.7629580524843 -122.417169630685 (37.7629580524843, -122.417169630685) 8 4 7 28859 19
129554 120951 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 741 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6007568 2105341 37.7612929159977 -122.416934678899 (37.7612929159977, -122.416934678899) 2 4 7 28859 19
131142 241308 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007488.17208 2106401.00941 37.7641989649233 -122.417285889641 (37.7641989649233, -122.417285889641) 8 4 7 28859 19
133550 241356 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3041 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009354.55363 2100986.01535 37.749435439707 -122.410448197535 (37.749435439707, -122.410448197535) 2 4 7 28859 19
134611 241336 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 11 Lundys Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007215.53058 2099620.48751 37.7455658619754 -122.417748235597 (37.7455658619754, -122.417748235597) 2 7 7 28859 2
135886 241369 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009515.68514 2102750.48038 37.7542892993236 -122.410015545387 (37.7542892993236, -122.410015545387) 2 4 7 28859 19
137034 241359 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 707 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 8ft   6008539.21153 2104376.13627 37.7586982040894 -122.413507415061 (37.7586982040894, -122.413507415061) 2 4 7 28859 19
137048 241309 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007486.87936 2106417.71309 37.7642447566068 -122.417291544578 (37.7642447566068, -122.417291544578) 8 4 7 28859 19
139041 241316 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007332.32989 2108125.54734 37.7689253726442 -122.41794716295 (37.7689253726442, -122.41794716295) 8 4 7 28853 19
140031 241328 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 373 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007423.72887 2107548.58471 37.7673463124187 -122.417590121285 (37.7673463124187, -122.417590121285) 8 4 7 28853 19
141436 247600 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009197.59612 2096407.47189 37.7368549629719 -122.410667669902 (37.7368549629719, -122.410667669902) 10 7 7 28859 2
143289 241382 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008151.18943 2105840.29781 37.762696660032 -122.414953006889 (37.762696660032, -122.414953006889) 8 4 7 28859 19
143795 247599 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 10ft   6009183.00439 2096409.33052 37.7368592482464 -122.410718251366 (37.7368592482464, -122.410718251366) 10 7 7 28859 2
144829 241322 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 442 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007381.66806 2107115.42092 37.7661545793962 -122.417704898167 (37.7661545793962, -122.417704898167) 8 4 7 28853 19
151093 241311 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 550 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007420.66445 2106451.36867 37.7643334414537 -122.417522949121 (37.7643334414537, -122.417522949121) 8 4 7 28859 19
153411 241275 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010636.10474 2101276.89456 37.750305890826 -122.406037027383 (37.750305890826, -122.406037027383) 10 4 7 28859 19
153861 120915 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 499X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6007431 2106864 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
159489 241280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1334 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010312.03054 2101467.09279 37.7508100021879 -122.40717110848 (37.7508100021879, -122.40717110848) 2 4 7 28859 19
160517 241330 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 335 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007413.91501 2107730.15032 37.7678442967163 -122.417636936423 (37.7678442967163, -122.417636936423) 8 4 7 28853 19
160938 241304 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007541.98711 2105410.71397 37.7614828711499 -122.417029586455 (37.7614828711499, -122.417029586455) 2 4 7 28859 19
162673 241334 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 245 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007405.72375 2108268.9659 37.7693232965496 -122.417703464652 (37.7693232965496, -122.417703464652) 8 4 7 28853 19
164484 241331 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 315 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007407.0994 2107837.87856 37.7681397096173 -122.417668147376 (37.7681397096173, -122.417668147376) 8 4 7 28853 19
165115 241383 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008148.21617 2105873.00555 37.7627863008585 -122.414965605482 (37.7627863008585, -122.414965605482) 8 4 7 28859 19
167044 241320 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007347.08663 2107747.30956 37.7678876512341 -122.417869305024 (37.7678876512341, -122.417869305024) 8 4 7 28853 19
168558 241302 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 741 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007545.5728 2105350.70249 37.7613182952255 -122.417012932805 (37.7613182952255, -122.417012932805) 2 4 7 28859 19
170652 179279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 223 Pioche St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6006275.12702 2093408.77207 37.7284569075468 -122.420559152977 (37.7284569075468, -122.420559152977) 9 7 7 309 5
176194 241296 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1350 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007156.61283 2107616.82741 37.7675186566968 -122.41851887996 (37.7675186566968, -122.41851887996) 8 4 7 28853 19
176735 241332 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 263 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007398.28361 2108137.64954 37.7689623140896 -122.417719890785 (37.7689623140896, -122.417719890785) 8 4 7 28853 19
177426 241314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 722 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007476.75646 2105385.74126 37.7614106322283 -122.417253423206 (37.7614106322283, -122.417253423206) 2 4 7 28859 19
180734 241381 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008153.50864 2105811.23118 37.7626169800981 -122.414942928177 (37.7626169800981, -122.414942928177) 8 4 7 28859 19
181888 241310 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007485.43036 2106430.0255 37.7642784820932 -122.417297428844 (37.7642784820932, -122.417297428844) 8 4 7 28859 19
186656 241344 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009557.96176 2104644.45965 37.7594921093986 -122.410003038507 (37.7594921093986, -122.410003038507) 2 4 7 28859 19
190029 241343 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2170 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009555.07772 2104672.73912 37.7595695967776 -122.410015009398 (37.7595695967776, -122.410015009398) 2 4 7 28859 19
193578 241299 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007561.10393 2105083.16851 37.7605845824436 -122.416940261287 (37.7605845824436, -122.416940261287) 2 4 7 28859 19
193922 179281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010435.48171 2094947.68687 37.7329160304499 -122.406284910247 (37.7329160304499, -122.406284910247) 10 3 7 309 28
17020 82125 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 317 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2008 12:00:00 AM 5 3x3 Permit Number 50070 6006739.55759841 2104266.9934198 37.75829730851 -122.41972370977 (37.75829730851, -122.41972370977) 2 4 7 28859 19
72441 82759 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 49 Samoset St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2008 12:00:00 AM   3x3 Permit Number 50251 6009929.1659667 2099164.47966506 37.744466098795 -122.408332701789 (37.744466098795, -122.408332701789) 2 7 7 28859 2
131374 82729 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 49 Samoset St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2008 12:00:00 AM   3x3 Permit Number 50251 6009929.1659667 2099164.47966506 37.744466098795 -122.408332701789 (37.744466098795, -122.408332701789) 2 7 7 28859 2
109489 25585 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1100 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1997 12:00:00 AM 30 3X3   6008661.2482385 2097297.4630516 37.7392685988549 -122.412584962687 (37.7392685988549, -122.412584962687) 10 7 7 28859 2
184282 25586 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150X Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1997 12:00:00 AM 30 3X3   6008754.8829591 2097365.1323636 37.7394596586207 -122.412265995986 (37.7394596586207, -122.412265995986) 10 7 7 28859 2
1298 91659 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1015 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007624.666917 2103742.941155 37.7569082017019 -122.4166254819 (37.7569082017019, -122.4166254819) 2 4 7 28859 19
6410 91640 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1427 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007757.588641 2101343.923892 37.7503285203588 -122.415995902486 (37.7503285203588, -122.415995902486) 2 4 7 28859 19
15558 91677 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 599 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007489.042117 2106191.625958 37.7636240956729 -122.417268041752 (37.7636240956729, -122.417268041752) 8 4 7 28859 19
15680 91641 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1401X South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007749.533216 2101489.31094 37.7507272674606 -122.416034053567 (37.7507272674606, -122.416034053567) 2 4 7 28859 19
20067 91584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007359.06414 2107782.395856 37.7679846640127 -122.417830363455 (37.7679846640127, -122.417830363455) 8 4 7 28853 19
22150 91686 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 377 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007415.631785 2107493.688708 37.7671951252581 -122.417614236777 (37.7671951252581, -122.417614236777) 8 4 7 28853 19
29262 91646 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1271 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007705.648787 2102264.402582 37.7528530260896 -122.416240700263 (37.7528530260896, -122.416240700263) 2 4 7 28859 19
29419 91588 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007384.392817 2107339.273033 37.7667693781679 -122.417711341871 (37.7667693781679, -122.417711341871) 8 4 7 28853 19
35434 91607 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 882 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007541.210677 2104526.186296 37.759054118783 -122.416969598799 (37.759054118783, -122.416969598799) 2 4 7 28859 19
35939 91612 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1108 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007615.164408 2103191.40433 37.755393273338 -122.416619275738 (37.755393273338, -122.416619275738) 2 4 7 28859 19
38921 91625 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1434 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007720.12849 2101296.976541 37.7501975073399 -122.416122118115 (37.7501975073399, -122.416122118115) 2 4 7 28859 19
39867 91624 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1424 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007717.03025 2101352.89464 37.7503508716121 -122.416136791792 (37.7503508716121, -122.416136791792) 2 4 7 28859 19
41188 91672 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007532.676036 2105403.706321 37.7614631059869 -122.417061293148 (37.7614631059869, -122.417061293148) 2 4 7 28859 19
41845 91616 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1200X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007645 2102652 37.7539138699857 -122.416477888477 (37.7539138699857, -122.416477888477) 2 4 7 28859 19

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