trees

137 rows where Fire Prevention Districts = 2 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention 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)
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
2223 241387 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 43 Whitney St 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 3ft   6004298.90777 2098020.68858 37.7410086185538 -122.42771950655 (37.7410086185538, -122.42771950655) 2 7 5 63 7
4885 71351 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 118 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2008 12:00:00 AM   3x3 Permit Number 50915 5999898.11886666 2105092.21291824 37.7601753897516 -122.44344360556 (37.7601753897516, -122.44344360556) 2 4 5 28862 3
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
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
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
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
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
20731 63489 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 319 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50934 6006645.5795298 2096080.30995427 37.7358132351331 -122.419467931102 (37.7358132351331, -122.419467931102) 2 7 7 28859 2
21100 241341 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009762.27519 2105459.58065 37.7617416960496 -122.409353942929 (37.7617416960496, -122.409353942929) 2 4 8 28859 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
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
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
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
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
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
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
42600 91638 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1453 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007765.644065 2101198.536844 37.7499297732176 -122.415957751819 (37.7499297732176, -122.415957751819) 2 4 7 28859 19
43855 91617 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1200X South Van Ness Ave 2 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
47749 84105 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3909 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50417 6003719.39167552 2102426.4465388 37.7530730069117 -122.430037470862 (37.7530730069117, -122.430037470862) 2 4 5 28862 22
47891 37711 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 720 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 6   Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
50197 91660 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 999 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/01/2007 12:00:00 AM 3 3x3   6007618.393891 2103856.158531 37.7572187178563 -122.416655196612 (37.7572187178563, -122.416655196612) 2 4 7 28859 19
53423 91645 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300X South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007675.941296 2102071.044433 37.7523204379956 -122.416329740365 (37.7523204379956, -122.416329740365) 2 4 7 28859 19
53750 91599 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 700 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007449 2105508 37.7617447647779 -122.41735808585 (37.7617447647779, -122.41735808585) 2 4 7 28859 19
56651 91619 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1286 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007670.444381 2102173.036115 37.7526001749043 -122.416355973027 (37.7526001749043, -122.416355973027) 2 4 7 28859 19
57032 91601 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 746 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007497.69689 2105311.935767 37.7612091575166 -122.417175768763 (37.7612091575166, -122.417175768763) 2 4 7 28859 19
57267 241390 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 381 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004068.12547 2098354.29911 37.7419115792635 -122.428541241382 (37.7419115792635, -122.428541241382) 2 7 5 63 7
59988 91630 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1490x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007737.478632 2100983.83524 37.7493386674544 -122.41603994665 (37.7493386674544, -122.41603994665) 2 4 7 28859 19
60318 91631 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1500 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007741.508083 2100911.11035 37.7491392078361 -122.416020863166 (37.7491392078361, -122.416020863166) 2 4 7 28859 19
60767 91618 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1240 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007656.818859 2102429.616316 37.7533039196294 -122.41642126514 (37.7533039196294, -122.41642126514) 2 4 7 28859 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
67599 91656 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1141 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007665.027497 2103014.499609 37.7549103375799 -122.416434303552 (37.7549103375799, -122.416434303552) 2 4 7 28859 19
67982 241367 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3747 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005339.63853 2104274.22686 37.7582382098444 -122.424565763112 (37.7582382098444, -122.424565763112) 2 4 5 28859 19
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
68475 91629 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1474 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007732.521449 2101073.304189 37.7495840503135 -122.416063424016 (37.7495840503135, -122.416063424016) 2 4 7 28859 19
69848 91667 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007551.894714 2105056.665982 37.7605112945984 -122.416970234051 (37.7605112945984, -122.416970234051) 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
74691 52826 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3063 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52281 6009164.51309648 2101559.46503951 37.7509993493006 -122.411145866905 (37.7509993493006, -122.411145866905) 2 4 7 28859 19
75224 52663 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 772 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM 4 3x3 Permit Number 50440 6001423.61779826 2102059.9147838 37.7519363103852 -122.437950438082 (37.7519363103852, -122.437950438082) 2 4 5 28862 22
75362 91635 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1515 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007819 2100813 37.7488741754589 -122.415745948384 (37.7488741754589, -122.415745948384) 2 4 7 28859 19
75650 241361 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 608 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009795.10344 2105420.22693 37.7616354789124 -122.409237625525 (37.7616354789124, -122.409237625525) 2 4 8 28859 19
77309 91657 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1133 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007662.546411 2103059.279009 37.7550331520704 -122.416446055556 (37.7550331520704, -122.416446055556) 2 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
81154 91654 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1169 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007673.711302 2102857.771696 37.7544804867979 -122.416393171829 (37.7544804867979, -122.416393171829) 2 4 7 28859 19
81234 241340 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009746.5481 2105459.14432 37.7617396168174 -122.409408306065 (37.7617396168174, -122.409408306065) 2 4 8 28859 19
81519 32351 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 9   Permit Number 36907 6009560.84271 2104624.99701 37.7594388308635 -122.409991700751 (37.7594388308635, -122.409991700751) 2 4 7 28859 19
82690 241362 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009794.30933 2105409.48411 37.7616059370772 -122.409239613928 (37.7616059370772, -122.409239613928) 2 4 8 28859 19
84687 91615 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1176 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007636.253645 2102810.779435 37.754349350274 -122.416519382003 (37.754349350274, -122.416519382003) 2 4 7 28859 19
84968 241376 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3777 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004606.4364 2101890.62925 37.7516519753774 -122.426931737306 (37.7516519753774, -122.426931737306) 2 4 5 28862 22
86392 241360 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 600 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009793.68997 2105435.76266 37.7616780573116 -122.409243610512 (37.7616780573116, -122.409243610512) 2 4 8 28859 19
87512 91604 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 802 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007516.377022 2104974.620116 37.7602840176254 -122.417087260164 (37.7602840176254, -122.417087260164) 2 4 7 28859 19
87982 91650 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007697.947405 2102409.42617 37.7532507948704 -122.416277603857 (37.7532507948704, -122.416277603857) 2 4 7 28859 19
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
89482 91663 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 859 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007573.699386 2104662.928197 37.7594314080197 -122.416866925134 (37.7594314080197, -122.416866925134) 2 4 7 28859 19
90241 241363 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009795.29828 2105395.5079 37.7615676169818 -122.409235207249 (37.7615676169818, -122.409235207249) 2 4 8 28859 19
92135 241378 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 273 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004715.15963 2100148.28162 37.746874039199 -122.426431711567 (37.746874039199, -122.426431711567) 2 7 5 63 22
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
93244 86800 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 71 Miguel St   Sidewalk: Curb side : Cutout Tree Private 2   10/09/2007 12:00:00 AM   3x3 Permit Number 49752 6003860 2097292 37.7389829690297 -122.429185143196 (37.7389829690297, -122.429185143196) 2 7 5 63 7
94776 91627 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1468 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007730.662506 2101106.855019 37.7496760688109 -122.416072228065 (37.7496760688109, -122.416072228065) 2 4 7 28859 19
95212 91600 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 722 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007467 2105381 37.7613970649262 -122.417286830828 (37.7613970649262, -122.417286830828) 2 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
96199 91639 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1435 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007760.067233 2101299.189418 37.7502058289413 -122.415984163776 (37.7502058289413, -122.415984163776) 2 4 7 28859 19
98123 241389 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 47 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6002625.89983 2096003.53123 37.7353751906151 -122.43336004273 (37.7353751906151, -122.43336004273) 2 7 5 63 7
100115 91632 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1540 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007748.949212 2100776.810346 37.748770868614 -122.415985622241 (37.748770868614, -122.415985622241) 2 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
103864 32350 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 11   Permit Number 36907 6009568.01706 2104596.56642 37.7593611689943 -122.40996488119 (37.7593611689943, -122.40996488119) 2 4 7 28859 19
104248 241377 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 281 27th St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004660.79755 2100144.09881 37.7468594809746 -122.426619392873 (37.7468594809746, -122.426619392873) 2 7 5 63 22
104883 241373 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004532.87463 2101890.40961 37.7516472125622 -122.427186107874 (37.7516472125622, -122.427186107874) 2 4 5 28862 22
105398 91651 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007697.947405 2102409.42617 37.7532507948704 -122.416277603857 (37.7532507948704, -122.416277603857) 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
105739 43561 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 598 28th St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50500 6002046.37252319 2099459.05244765 37.7448303525831 -122.435610815213 (37.7448303525831, -122.435610815213) 2 7 5 63 22
108205 91655 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1155 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007669.369399 2102936.135663 37.7546954122234 -122.416413737633 (37.7546954122234, -122.416413737633) 2 4 7 28859 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
109816 241388 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1769 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6003420.97531 2097978.60034 37.7408433528415 -122.430752071748 (37.7408433528415, -122.430752071748) 2 7 5 63 7
109877 241372 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004512.71197 2101888.89737 37.7516419200596 -122.427255725271 (37.7516419200596, -122.427255725271) 2 4 5 28862 22
111472 91628 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1474 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007732.521449 2101073.304189 37.7495840503135 -122.416063424016 (37.7495840503135, -122.416063424016) 2 4 7 28859 19
111602 91634 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1515 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007819 2100813 37.7488741754589 -122.415745948384 (37.7488741754589, -122.415745948384) 2 4 7 28859 19
111765 91613 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1116 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007617.645495 2103146.62493 37.7552704588724 -122.416607523387 (37.7552704588724, -122.416607523387) 2 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
115294 246445 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 457 Duncan St 1 : Tree Private 2     8 Width 3ft   6003558.45361 2099788.20108 37.7458198862793 -122.430405804901 (37.7458198862793, -122.430405804901) 2 7 5 63 22
116693 84100 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3909 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50417 6003719.39167552 2102426.4465388 37.7530730069117 -122.430037470862 (37.7530730069117, -122.430037470862) 2 4 5 28862 22
122308 91633 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1515 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007819 2100813 37.7488741754589 -122.415745948384 (37.7488741754589, -122.415745948384) 2 4 7 28859 19
123335 241374 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3783 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004551.11836 2101892.73239 37.7516546220636 -122.427123184105 (37.7516546220636, -122.427123184105) 2 4 5 28862 22
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
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
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
132267 91658 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1073 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007642.630657 2103418.725072 37.7560189888407 -122.416540390694 (37.7560189888407, -122.416540390694) 2 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
135185 241339 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2707 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009729.78186 2105457.4669 37.761734071584 -122.409466175622 (37.761734071584, -122.409466175622) 2 4 8 28859 19
135561 91626 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1450 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007725.085674 2101207.507592 37.749952124518 -122.416098640357 (37.749952124518, -122.416098640357) 2 4 7 28859 19
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
135948 84422 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3324-3330 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50579 6007386.65215888 2105022.29149516 37.7604076136969 -122.417539297454 (37.7604076136969, -122.417539297454) 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)
);