sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
327 191528 2 62 201 16th St 3 1 1 1   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.38772046693501 (37.76689343092, -122.387720466935)
1513 251580 2 62 788 Harrison St 4 1 1 1       3x3   6012749.64869 2112405.5203400003 37.78098060211779 -122.39950942241998 (37.7809806021178, -122.39950942242)
2568 227812 2 62 79 Piedmont St 1 1 1 1     11 3x15   5999345.2069 2106945.6167 37.765232827359 -122.44548913263701 (37.765232827359, -122.445489132637)
2858 110567 2 62 201 08th St 1 1 1 1     12 3x3 Permit Number 779053 6009356.33336 2110648.62955 37.77596687089571 -122.411124487731 (37.7759668708957, -122.411124487731)
2906 140272 2 62 2040 Hayes St 4 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998087.0735 2109979.7192 37.7734917934815 -122.450059397698 (37.7734917934815, -122.450059397698)
2907 140271 2 62 2040 Hayes St 3 1 1 1   08/11/2017 12:00:00 AM 3 Width 0ft   5998106.0231 2109982.4655 37.773500418432704 -122.44999404654301 (37.7735004184327, -122.449994046543)
2911 140276 2 62 2040 Hayes St 8 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.773457874403704 -122.450331271992 (37.7734578744037, -122.450331271992)
2912 140274 2 62 2040 Hayes St 6 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998046.1533 2109973.9519 37.7734736163349 -122.45020053018699 (37.7734736163349, -122.450200530187)
2913 140273 2 62 2040 Hayes St 5 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998068.9478 2109976.9729 37.773483215641 -122.450121898862 (37.773483215641, -122.450121898862)
2922 140275 2 62 2040 Hayes St 7 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998028.0276 2109971.4803 37.773465792675 -122.450263051124 (37.773465792675, -122.450263051124)
2924 140269 2 62 2040 Hayes St 1 1 1 10 6 08/11/2017 12:00:00 AM 3 Width 0ft   5998144.7463 2109987.1343 37.7735154534297 -122.449860434482 (37.7735154534297, -122.449860434482)
2926 140270 2 62 2040 Hayes St 2 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998125.7967 2109984.6626 37.773507582533604 -122.44992580546001 (37.7735075825336, -122.44992580546)
5076 227766 2 62 65 Homestead St 1 1 1 1     12 4x4   6000997.83471 2101277.8848900003 37.749764821811 -122.439366802634 (37.749764821811, -122.439366802634)
5880 97919 2 62 333 Baker St 5 1 1 1     6 3x3   6000669.5517 2110132.6697 37.7740591934476 -122.44113722827299 (37.7740591934476, -122.441137228273)
7357 97916 2 62 333 Baker St 2 1 1 1     6 3x3   6000651.9591 2110235.6191 37.77434086442889 -122.441205471863 (37.7743408644289, -122.441205471863)
7449 97915 2 62 333 Baker St 1 1 1 1     6 3x3   6000647.534 2110270.503 37.7744363947481 -122.441223282456 (37.7744363947481, -122.441223282456)
7913 97918 2 62 333 Baker St 4 1 1 1     6 3x3   6000663.0359 2110165.9002 37.7741500648743 -122.44116215214198 (37.7741500648743, -122.441162152142)
9611 138137 2 62 1790 Laguna St 1 1 1 1       Width 0ft   6004447.4756 2114919.1759 37.7874162214119 -122.42840996490801 (37.7874162214119, -122.428409964908)
11928 105246 2 62 2439 22nd Ave 1 1 1 1     14 6x6   5989501.8448 2098751.2622 37.7421664525595 -122.478935190185 (37.7421664525595, -122.478935190185)
13963 100835 2 62 642 Natoma St 2 1 1 1     12 3x3   6009411.19134 2111256.02049 37.777637699760795 -122.41097762931999 (37.7776376997608, -122.41097762932)
14627 115035 2 62 788 Harrison St 1 1 1 1     4 3x3   6012851.17431 2112502.5973400003 37.781252811600794 -122.39916500906601 (37.7812528116008, -122.399165009066)
15638 121717 2 62 880 Pennsylvania Ave 13 1 1 1   12/22/2016 12:00:00 AM 3   Permit Number 779222 6014431.9321099995 2103065.57675 37.755428803314295 -122.39303583615101 (37.7554288033143, -122.393035836151)
15784 121716 2 62 880 Pennsylvania Ave 12 1 1 1   12/22/2016 12:00:00 AM 3 3x3 Permit Number 779222 6014431.75751 2103081.25316 37.7554718376765 -122.39303753677 (37.7554718376765, -122.39303753677)
16387 111703 2 62 1006 Tennessee St 1 1 1 1     6 6x12   6015488.19364 2104440.58048 37.7592628883951 -122.389478950919 (37.7592628883951, -122.389478950919)
16501 100834 2 62 642 Natoma St 1 1 1 1     12 3x3   6009421.99762 2111264.1253 37.7776605596195 -122.410940819169 (37.7776605596195, -122.410940819169)
16736 121715 2 62 880 Pennsylvania Ave 11 1 1 1   12/22/2016 12:00:00 AM 3   Permit Number 779222 6014429.69222 2103112.88568 37.7555585790683 -122.39304689240299 (37.7555585790683, -122.393046892403)
23828 177148 2 62 1100 Junipero Serra Blvd 11 4 1 1     3 Width 0ft   5991345.1062 2088786.2704900003 37.7149119421181 -122.47183574413401 (37.7149119421181, -122.471835744134)
23897 248466 2 62 144 Belvedere St 1 1 1 1     2 Width 0ft   5998292.5435 2107918.5956 37.7678442300261 -122.449200130602 (37.7678442300261, -122.449200130602)
24243 191114 2 62 1201 22nd St 5 1 1 1     19 Width 4ft   6014324.849769999 2103848.63349 37.7575729597541 -122.393460960954 (37.7575729597541, -122.393460960954)
24503 191147 2 62 44 Boardman Pl 3 1 1 1     9 Width 3ft   6011750.26705 2110044.73207 37.7744426675252 -122.40280071719201 (37.7744426675252, -122.402800717192)
24508 138147 2 62 1855 MCALLISTER ST 1 1 1 1     5 Width 0ft   6000229.7014 2111271.7391 37.777161724967996 -122.442740548891 (37.777161724968, -122.442740548891)
24517 129740 2 62 1 John Maher St 1 1 1 1     12 Width 2ft   6012353.73266 2119674.7684299997 37.8009181627066 -122.401390109871 (37.8009181627066, -122.401390109871)
24703 208140 2 62 9 Keystone Way 2 1 1 1     7 Width 3ft   5994042.19484 2092647.64079 37.7256700254358 -122.462793502527 (37.7256700254358, -122.462793502527)
24770 227722 2 62 845 Ashbury St 1 1 1 1     12 Width 4ft   5999121.83175 2107384.4786900003 37.7664250774754 -122.44629330369601 (37.7664250774754, -122.446293303696)
24970 227868 2 62 390 Sanchez St 4 1 1 1     7 Width 3ft   6003558.10771 2106024.70188 37.7629438234204 -122.430851992743 (37.7629438234204, -122.430851992743)
25393 228021 2 62 1054 Cole St 1 1 1 1     12 Width 3ft   5998157.054409999 2106607.36365 37.7642361689933 -122.44957427424102 (37.7642361689933, -122.449574274241)
25442 227871 2 62 3800 19th St 2 1 1 1     12 Width 3ft   6004234.236219999 2104844.24859 37.7597408654757 -122.428429354932 (37.7597408654757, -122.428429354932)
25463 200261 2 62 243 08th St 1 1 1 1     6 Width 3ft   6009424.87449 2110575.33974 37.7757694778185 -122.410882207661 (37.7757694778185, -122.410882207661)
25465 208048 2 62 2344 Funston Ave 1 1 1 1     4 Width 4ft   5992344.38135 2099463.27392 37.74428611053071 -122.469158483081 (37.7442861105307, -122.469158483081)
25607 227742 2 62 1232 Stanyan St 2 1 1 1     17 Width 4ft   5997482.84112 2105527.7140599997 37.761233131234896 -122.451828281975 (37.7612331312349, -122.451828281975)
25626 129738 2 62 6 John Maher St 6 1 1 1     7 Width 2ft   6012361.066869999 2119691.7640299997 37.800965237719204 -122.40136592529801 (37.8009652377192, -122.401365925298)
25648 191123 2 62 601 Carolina St 2 9 1 1     8 Width 8ft   6012425.58055 2105029.27463 37.7607090306229 -122.400112358502 (37.7607090306229, -122.400112358502)
25894 227929 2 62 3110 Castro St 1 1 1 1     8 Width 3ft   6002869.05371 2095746.24255 37.7346825264594 -122.432500998617 (37.7346825264594, -122.432500998617)
26117 129704 2 62 3000 Washington St 3 2 1 1     22 Width 3ft   6000269.523080001 2116153.9558 37.7905693023891 -122.442953484235 (37.7905693023891, -122.442953484235)
26172 246467 2 62 244 Duncan St 1 4 1 1     8 Width 4ft   6004891.34106 2099910.0636400003 37.7462299051934 -122.42580553881099 (37.7462299051934, -122.425805538811)
26311 227767 2 62 4475 24th St 1 9 1 1     11 Width 8ft   6000143.14107 2101645.6357400003 37.7507259002966 -122.442348757612 (37.7507259002966, -122.442348757612)
26456 246068 2 62 5 Central Ave 3 1 1 1     9 Width 0ft   5999954.0153 2108402.9707 37.7692690935594 -122.443488110434 (37.7692690935594, -122.443488110434)
26594 208099 2 62 2291 15th Ave 2 1 1 1     8 Width 3ft   5991681.99819 2099835.94672 37.745271077706704 -122.471475991035 (37.7452710777067, -122.471475991035)
26610 228013 2 62 1343 Cole St 1 1 1 1     11 Width 3ft   5998231.8221 2105759.10992 37.76191135493279 -122.449254558076 (37.7619113549328, -122.449254558076)
26638 200276 2 62 2 Lane St 4 1 1 1     3 Width 3ft   6017047.12766 2097054.90505 37.7390696568319 -122.383573170476 (37.7390696568319, -122.383573170476)
26653 208094 2 62 1284 07th Ave 1 1 1 1     10 Width 3ft   5993960.310959999 2106767.61522 37.7644351970401 -122.46410113478001 (37.7644351970401, -122.46410113478)
26876 129739 2 62 6 John Maher St 7 1 1 1     11 Width 2ft   6012352.16177 2119689.7384 37.8009591789808 -122.401396598486 (37.8009591789808, -122.401396598486)
27352 227958 2 62 3627 19th St 1 1 1 1     17 Width 5ft   6005410.5124699995 2104865.85603 37.7598666869207 -122.42436272946199 (37.7598666869207, -122.424362729462)
27545 140410 2 62 1325 FILLMORE ST 1 1 1 1     8 Width 0ft   6003227.817000001 2112933.649 37.7818953731726 -122.43248785744301 (37.7818953731726, -122.432487857443)
27561 227876 2 62 133 Collingwood St 2 1 1 1     7 Width 3ft   6002056.6842 2105072.72951 37.7602447556215 -122.43597676861 (37.7602447556215, -122.43597676861)
27635 129744 2 62 1 John Maher St 13 1 1 1     6 Width 2ft   6012609.98453 2119710.6419 37.801030956563395 -122.400505885653 (37.8010309565634, -122.400505885653)
27768 208072 2 62 48 Marcela Ave 3 2 1 1     1 Width 4ft   5994750.66862 2100768.2505900003 37.7480079970652 -122.460932676625 (37.7480079970652, -122.460932676625)
27892 208144 2 62 40 Garcia Ave 4 10 1 1     8 Width 3ft   5995206.64176 2099494.55804 37.7445369826924 -122.459263729149 (37.7445369826924, -122.459263729149)
27923 208116 2 62 239 Magellan Ave 1 1 1 1     13 Width 4ft   5994839.35424 2100452.13911 37.747145137147704 -122.460603103876 (37.7471451371477, -122.460603103876)
27930 129716 2 62 1087 Chestnut St 4 1 1 1     9 Width 4ft   6006809.35 2120459.5660099997 37.8027621146536 -122.42063180021299 (37.8027621146536, -122.420631800213)
28050 129731 2 62 332 Vallejo St 4 1 1 1     9 Width 4ft   6011929.52293 2119129.4911700003 37.7993972859062 -122.402819692899 (37.7993972859062, -122.402819692899)
28107 129718 2 62 1087 Chestnut St 6 1 1 1     7 Width 4ft   6006845.74669 2120464.39586 37.8027774273877 -122.42050619192699 (37.8027774273877, -122.420506191927)
28121 139774 2 62 1400 FILLMORE ST 8 1 1 1     4 Width 0ft   6003214.319 2113328.8398 37.782979702448394 -122.43256279089898 (37.7829797024484, -122.432562790899)
28215 247280 2 62 520 Ashbury St 1 1 1 1     3 Width 0ft   5998954.6357 2108912.2879 37.7706105046931 -122.446981556392 (37.7706105046931, -122.446981556392)
28393 129742 2 62 1 John Maher St 3 1 1 1     9 Width 2ft   6012372.32254 2119675.23965 37.8009204937473 -122.401325813756 (37.8009204937473, -122.401325813756)
28612 129695 2 62 2970 Washington St 4 1 1 1     8 Width 5ft   6000588.35894 2116200.69282 37.7907158028324 -122.441853689821 (37.7907158028324, -122.441853689821)
28751 72246 2 62 418 Lisbon St 1 1 1 1 1 01/06/1996 12:00:00 AM 6     6002360.66039 2091027.7988900002 37.721697906115104 -122.433921526363 (37.7216979061151, -122.433921526363)
28803 227813 2 62 168 Delmar St 1 1 1 1     14 Width 3ft   5999428.13676 2107230.4029200003 37.7660195129085 -122.445222775925 (37.7660195129085, -122.445222775925)
28836 200258 2 62 46 Boardman Pl 6 1 1 1     6 Width 3ft   6011826.839269999 2109963.92529 37.7742250657728 -122.40253015436501 (37.7742250657728, -122.402530154365)
29002 208061 2 62 2105 Funston Ave 6 1 1 1     6 Width 3ft   5992248.52602 2101024.65147 37.748567713538996 -122.46960356926901 (37.748567713539, -122.469603569269)
29073 227764 2 62 4314 26th St 3 1 1 1     9 Width 3ft   6001842.536180001 2100618.06148 37.7480011379615 -122.436398576738 (37.7480011379615, -122.436398576738)
29224 227995 2 62 321 Chattanooga St 1 1 1 1     4 Width 4ft   6004807.15163 2101805.7755 37.7514303338561 -122.426231597132 (37.7514303338561, -122.426231597132)
29318 248428 2 62 130 Belvedere St 1 1 1 1     8 Width 0ft   5998278.3106 2108020.0433 37.768121965532295 -122.449256670048 (37.7681219655323, -122.449256670048)
29643 246620 2 62 171 Ripley St 2 9 1 1     6 Width 5ft   6009078.777530001 2099136.29589 37.744341055486295 -122.411271191437 (37.7443410554863, -122.411271191437)
29850 129698 2 62 2970 Washington St 7 1 1 1     7 Width 5ft   6000533.7718 2116193.1450799997 37.7906919681164 -122.442042015953 (37.7906919681164, -122.442042015953)
30061 247344 2 62 213 Pierce St 2 1 1 1     8 Width 0ft   6002764.9406 2109273.4332 37.771819073738705 -122.43382749783899 (37.7718190737387, -122.433827497839)
30195 142197 2 62 333 BAKER ST 8 1 1 1     13 Width 0ft   6000681.6059 2110025.4851 37.773765578161296 -122.44108783944799 (37.7737655781613, -122.441087839448)
30224 227891 2 62 58 Walter St 1 1 1 1     3 Width 3ft   6003143.30655 2107929.00611 37.7681490697424 -122.432422664995 (37.7681490697424, -122.432422664995)
30357 227761 2 62 87 28th St 1 1 1 1     13 Width 4ft   6005426.61046 2099602.37866 37.745415306472204 -122.42393276538601 (37.7454153064722, -122.423932765386)
30431 208020 2 62 1285 06th Ave 1 1 1 1     5 Width 3ft   5994218.151430001 2106814.05581 37.7645775678277 -122.463212712505 (37.7645775678277, -122.463212712505)
30507 129709 2 62 2384 Vallejo St 1 1 1 1     15 Width 5ft   6002148.23302 2117769.42382 37.795111892265 -122.436568947899 (37.795111892265, -122.436568947899)
30686 200259 2 62 46 Boardman Pl 7 1 1 1     6 Width 3ft   6011837.77758 2109952.34907 37.7741938907772 -122.402491502385 (37.7741938907772, -122.402491502385)
31262 177151 2 62 183 Edinburgh St 1 1 1 1     7 Width 3ft   6004046.6041 2092611.27045 37.7261413007669 -122.428206457066 (37.7261413007669, -122.428206457066)
31295 227823 2 62 316 Highland Ave 1 1 1 1     5 Width 3ft   6006968.36013 2096533.98003 37.737077088338 -122.41838410663799 (37.737077088338, -122.418384106638)
31548 227788 2 62 394 Laidley St 1 1 1 1     16 Width 3ft   6003786.51974 2096596.76601 37.7370698550876 -122.42938963933099 (37.7370698550876, -122.429389639331)
31751 129693 2 62 2970 Washington St 2 1 1 1     15 Width 5ft   6000643.07515 2116204.21556 37.7907285930009 -122.44166462801701 (37.7907285930009, -122.441664628017)
31872 124631 2 62 725 Euclid Ave 2 2 1 1     10 Width 4ft   5996077.92539 2113787.58101 37.783832003391296 -122.45728481381501 (37.7838320033913, -122.457284813815)
31953 227817 2 62 177 Wool St 2 1 1 1     10 Width 3ft   6007367.5579 2097392.89252 37.7394579364345 -122.417064737348 (37.7394579364345, -122.417064737348)
31979 129746 2 62 1310 Montgomery St 1 1 1 1     6 Width 3ft   6011484.09994 2119879.99013 37.801433092922004 -122.40441387701401 (37.801433092922, -122.404413877014)
32066 208129 2 62 14 Ventura Ave 1 2 1 1     13 Width 3ft   5994035.372909999 2102011.52015 37.751380514111396 -122.463496334396 (37.7513805141114, -122.463496334396)
32527 248574 2 62 332 Frederick St 2 1 1 1     11 Width 0ft   5998368.8565 2107590.9345 37.7669489203591 -122.448912568843 (37.7669489203591, -122.448912568843)
32656 123589 2 62 32 05th Ave 1 1 1 1     7 Width 2ft   5994275.31768 2115360.29886 37.7880465633309 -122.463635298323 (37.7880465633309, -122.463635298323)
32695 191536 2 62 1150 22nd St 3 1 1 1     14 Width 4ft   6014495.86116 2103903.97635 37.7577344195295 -122.39287340149099 (37.7577344195295, -122.392873401491)
32758 208066 2 62 99 Pacheco St 2 2 1 1     15 Width 4ft   5994517.25257 2100489.12784 37.7472281625491 -122.46171957892099 (37.7472281625491, -122.461719578921)
32924 191543 2 62 700 Pennsylvania Ave 8 1 1 1     3 Width 3ft   6014401.59884 2103605.63066 37.7569099903147 -122.39317852616199 (37.7569099903147, -122.393178526162)
33165 129714 2 62 1087 Chestnut St 2 1 1 1     8 Width 4ft   6006770.61766 2120452.09935 37.8027394301331 -122.420765303696 (37.8027394301331, -122.420765303696)
33184 227781 2 62 585 Eureka St 1 1 1 1     10 Width 3ft   6001575.56604 2102446.1042 37.7530053336508 -122.437452632547 (37.7530053336508, -122.437452632547)
33223 191555 2 62 401 Rhode Island St 4 1 1 1     13 Width 4ft   6011789.66308 2106208.9715 37.7639127377095 -122.402394675067 (37.7639127377095, -122.402394675067)
33495 105991 2 62 997 Tennessee St 1 1 1 1     10 6x9   6015541.70538 2104536.18595 37.7595283673583 -122.389300555992 (37.7595283673583, -122.389300555992)
33653 208029 2 62 1635 08th Ave 1 2 1 1     16 Width 4ft   5993680.14998 2104375.72277 37.7578515328401 -122.464896406148 (37.7578515328401, -122.464896406148)
33815 228012 2 62 1317 Cole St 2 1 1 1     12 Width 3ft   5998216.16813 2105874.44581 37.762227142891504 -122.449317008786 (37.7622271428915, -122.449317008786)
Powered by Datasette · Query took 13.571ms · Data source: data.sfgov.org