sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
162153 201632 2 15 451 Galvez Ave 6 2 1 1     2 Width 3ft   6021871.21572 2093119.8757200001 37.728530265257504 -122.366622037185 (37.7285302652575, -122.366622037185)
25954 201635 2 15 451 Galvez Ave 5 2 1 1     2 Width 3ft   6021853.58241 2093133.73067 37.7285673424948 -122.36668395282301 (37.7285673424948, -122.366683952823)
61764 201633 2 15 451 Galvez Ave 4 2 1 1     2 Width 3ft   6021837.4277 2093144.7538400001 37.7285967251547 -122.36674056154699 (37.7285967251547, -122.366740561547)
186137 201634 2 15 451 Galvez Ave 3 2 1 1     2 Width 3ft   6021819.77945 2093157.84467 37.728631703379996 -122.366802476247 (37.72863170338, -122.366802476247)
152013 201631 2 15 451 Galvez Ave 2 2 1 1     2 Width 3ft   6021802.56362 2093169.8437599998 37.728663707547 -122.366862820783 (37.728663707547, -122.366862820783)
147489 201630 2 15 451 Galvez Ave 1 2 1 1     12 Width 3ft   6021771.18031 2093196.4626099998 37.72873507866179 -122.36697315229799 (37.7287350786618, -122.366973152298)
60882 201626 2 15 401 Galvez Ave 9 2 1 1     8 Width 3ft   6021390.17472 2093479.1465200002 37.729490394945294 -122.36830984254298 (37.7294903949453, -122.368309842543)
61834 201616 2 44 0 Innes Ct 1 2 1 1     1 Width 3ft   6021349.55513 2092801.0747099998 37.7276263098888 -122.36840346285801 (37.7276263098888, -122.368403462858)
67615 201618 2 15 401 Galvez Ave 3 2 1 1     9 Width 3ft   6021223.045080001 2093587.4702 37.7297786672424 -122.36889511322701 (37.7297786672424, -122.368895113227)
162543 201617 2 15 401 Galvez Ave 1 2 1 1     10 Width 3ft   6021188.31873 2093585.6418599999 37.729771742469794 -122.369015041404 (37.7297717424698, -122.369015041404)
2417 201819 2 48 100 Friedell St 3 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
33142 201605 2 44 570 Innes Ave 1 2 1 1     1 Width 3ft   6021066.69823 2093118.6837900002 37.7284828925695 -122.369403250859 (37.7284828925695, -122.369403250859)
2408 201820 2 48 100 Friedell St 4 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
71242 201604 2 44 570 Innes Ave 2 2 1 1     1 Width 3ft   6021044.33252 2093135.00772 37.7285264880895 -122.369481698744 (37.7285264880895, -122.369481698744)
2383 201821 2 48 100 Friedell St 5 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 201822 2 48 100 Friedell St 6 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2402 201606 2 44 598 Innes Ave 1 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.4635700001 37.7287012794353 -122.36979738594101 (37.7287012794353, -122.369797385941)
2465 201607 2 44 598 Innes Ave 2 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.8340900003 37.7287396409072 -122.36986751418699 (37.7287396409072, -122.369867514187)
176019 201608 2 44 598 Innes Ave 3 2 1 1     1 Width 3ft   6020912.48689 2093230.64881 37.7287818667771 -122.369944109446 (37.7287818667771, -122.369944109446)
28938 201582 2 11 601 Donahue St 7 2 1 1     1 Width 5ft   6020666.22255 2092954.7050599998 37.7280106612574 -122.370776399631 (37.7280106612574, -122.370776399631)
157712 201581 2 11 601 Donahue St 6 2 1 1     1 Width 5ft   6020642.22702 2092924.8193 37.7279272833017 -122.370857288241 (37.7279272833017, -122.370857288241)
179913 201580 2 11 601 Donahue St 5 2 1 1     1 Width 5ft   6020628.78345 2092907.8245700002 37.7278798809349 -122.370902588897 (37.7278798809349, -122.370902588897)
188792 201569 2 180 600 Donahue St 2 2 1 1     13 Width 5ft   6020624.73776 2092976.30056 37.728067680971606 -122.370921308297 (37.7280676809716, -122.370921308297)
69081 201579 2 11 601 Donahue St 4 2 1 1     1 Width 5ft   6020614.668740001 2092891.85925 37.7278352682694 -122.370950280826 (37.7278352682694, -122.370950280826)
164394 201578 2 11 601 Donahue St 3 2 1 1     1 Width 5ft   6020600.888259999 2092872.2369900001 37.727780632667105 -122.370996564459 (37.7277806326671, -122.370996564459)
188512 201577 2 11 601 Donahue St 2 2 1 1     1 Width 5ft   6020588.137 2092854.48102 37.727731178034894 -122.37103941895799 (37.7277311780349, -122.371039418958)
61517 201542 2 60 601 Innes Ave 11 2 1 1     28     6020585.50312 2093400.1960900002 37.7292294638519 -122.37108624845699 (37.7292294638519, -122.371086248457)
71593 201576 2 11 601 Donahue St 1 2 1 1     1 Width 5ft   6020573.723230001 2092835.80455 37.7276791045865 -122.37108795716101 (37.7276791045865, -122.371087957161)
60468 201541 2 291 601 Innes Ave 10 2 1 1     2     6020571.225269999 2093411.7582900003 37.7292604275206 -122.371136408139 (37.7292604275206, -122.371136408139)
47543 201520 2 16 501 Griffith St 3 2 1 1     5 Width 6ft   6019241.773440001 2094383.32833 37.7318550858427 -122.37579982552 (37.7318550858427, -122.37579982552)
163764 201519 2 16 501 Griffith St 2 2 1 1     6 Width 6ft   6019223.74724 2094361.07733 37.7317929966527 -122.375860604396 (37.7317929966527, -122.375860604396)
27606 201518 2 16 501 Griffith St 1 2 1 1     8 Width 6ft   6019207.673780001 2094338.78719 37.7317309074526 -122.37591462936199 (37.7317309074526, -122.375914629362)
25205 195981 2 86 401 Amador St 12 2 1 1     7     6018524.13374 2099557.3325900002 37.746022348857295 -122.37864001312799 (37.7460223488573, -122.378640013128)
187127 195982 2 86 401 Amador St 11 2 1 1     10     6018502.102580001 2099556.87815 37.746019886521296 -122.378716163238 (37.7460198865213, -122.378716163238)
29206 195983 2 86 401 Amador St 10 2 1 1     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939)
26910 195984 2 86 401 Amador St 9 2 1 1     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093)
130066 195985 2 86 401 Amador St 8 2 1 1     5     6018474.359130001 2099556.32192 37.74601682971289 -122.378812058831 (37.7460168297129, -122.378812058831)
46984 195986 2 86 401 Amador St 7 2 1 1     3     6018468.61509 2099561.7634900003 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987)
130871 195987 2 86 401 Amador St 6 2 1 1     6     6018466.53487 2099573.76457 37.7460642923433 -122.378840325441 (37.7460642923433, -122.378840325441)
164903 201371 2 97 1 Hare St 1 2 1 1     12     6018297.03999 2095334.9344400002 37.7344159629251 -122.379132069983 (37.7344159629251, -122.379132069983)
120047 195988 2 86 401 Amador St 5 2 1 1     3     6018362.603680001 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078)
61850 195989 2 86 401 Amador St 4 2 1 1     3     6018358.23149 2099573.02507 37.7460562901585 -122.37921477706699 (37.7460562901585, -122.379214777067)
69871 195990 2 86 401 Amador St 3 2 1 1     4     6018348.89198 2099575.3229 37.746062084515295 -122.379247231793 (37.7460620845153, -122.379247231793)
177923 195991 2 86 401 Amador St 2 2 1 1     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321)
137238 188678 2 5 2 Middle Point Rd 1 2 1 1     9     6018276.23172 2096494.25688 37.7375980862711 -122.37928451136999 (37.7375980862711, -122.37928451137)
181178 188679 2 5 2 Middle Point Rd 2 2 1 1     8     6018264.75043 2096477.95592 37.7375526939091 -122.379323076118 (37.7375526939091, -122.379323076118)
149276 195992 2 86 401 Amador St 1 2 1 1     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446)
157197 201370 2 8 175 Middle Point Rd 3 2 1 1     2 Width 5ft   6018229.792119999 2095294.6367900001 37.734301605121104 -122.37936177213699 (37.7343016051211, -122.379361772137)
62585 201369 2 8 175 Middle Point Rd 2 2 1 1     2 Width 5ft   6018228.8289 2095275.93541 37.7342502016868 -122.379363803718 (37.7342502016868, -122.379363803718)
151671 201368 2 8 175 Middle Point Rd 1 2 1 1     2 Width 5ft   6018226.9732800005 2095256.66698 37.734197192029704 -122.379368881264 (37.7341971920297, -122.379368881264)
24760 188680 2 5 2 Middle Point Rd 3 2 1 1     8     6018245.47476 2096448.1212400002 37.7374697107694 -122.37938765012501 (37.7374697107694, -122.379387650125)
179817 190643 2 322 2 Middle Point Rd 4 2 1 1     8     6018217.5284400005 2096361.1167799998 37.7372292724971 -122.379478232531 (37.7372292724971, -122.379478232531)
61771 201441 2 8 50 Middle Point Rd 1 2 1 1     4 Width 5ft   6018208.2556 2096140.7000900002 37.7366235404482 -122.37949498601601 (37.7366235404482, -122.379494986016)
38144 201442 2 8 50 Middle Point Rd 2 2 1 1     3 Width 5ft   6018207.71631 2096124.7676 37.736579763236705 -122.37949574413601 (37.7365797632367, -122.379495744136)
70501 201446 2 8 96 Middle Point Rd 1 2 1 1     2 Width 7ft   6018203.56195 2095942.2457299998 37.7360783651123 -122.37949743215599 (37.7360783651123, -122.379497432156)
23444 201445 2 8 50 Middle Point Rd 5 2 1 1     4 Width 5ft   6018205.83588 2096062.22823 37.7364079387746 -122.379497902505 (37.7364079387746, -122.379497902505)
64672 201451 2 8 96 Middle Point Rd 6 2 1 1     2 Width 7ft   6018201.15931 2095830.10025 37.735770303244294 -122.379497951066 (37.7357703032443, -122.379497951066)
188352 188681 2 5 2 Middle Point Rd 5 2 1 1     20     6018210.72448 2096306.49238 37.7370789094531 -122.379497963675 (37.7370789094531, -122.379497963675)
47708 201384 2 8 120 Middle Point Rd 4 2 1 1     2 Width 7ft   6018192.32323 2095410.89535 37.73461876184721 -122.379499389078 (37.7346187618472, -122.379499389078)
180999 201383 2 8 120 Middle Point Rd 3 2 1 1     2 Width 7ft   6018192.817430001 2095435.4996599997 37.7346863476974 -122.379499389088 (37.7346863476974, -122.379499389088)
71342 201450 2 8 96 Middle Point Rd 5 2 1 1     3 Width 7ft   6018200.75737 2095847.6313 37.735818417881106 -122.379500558206 (37.7358184178811, -122.379500558206)
179491 201452 2 8 96 Middle Point Rd 7 2 1 1     1 Width 7ft   6018199.95572 2095808.82115 37.7357118086525 -122.37950063464199 (37.7357118086525, -122.379500634642)
160952 201444 2 8 50 Middle Point Rd 4 2 1 1     2 Width 5ft   6018205.67502 2096093.6651299999 37.7364942494189 -122.379500641858 (37.7364942494189, -122.379500641858)
34335 201443 2 8 50 Middle Point Rd 3 2 1 1     3 Width 5ft   6018205.670580001 2096108.31022 37.736534461697104 -122.379501674263 (37.7365344616971, -122.379501674263)
176290 201449 2 8 96 Middle Point Rd 4 2 1 1     2 Width 7ft   6018200.77353 2095868.3398 37.7358752802274 -122.37950194045901 (37.7358752802274, -122.379501940459)
76492 201448 2 8 96 Middle Point Rd 3 2 1 1     2 Width 7ft   6018201.246669999 2095899.23828 37.735960147450704 -122.379502450391 (37.7359601474507, -122.379502450391)
67195 201447 2 8 96 Middle Point Rd 2 2 1 1     2 Width 7ft   6018201.6528199995 2095922.70915 37.7360246162273 -122.379502676117 (37.7360246162273, -122.379502676117)
68023 201453 2 8 96 Middle Point Rd 8 2 1 1     2 Width 7ft   6018197.87092 2095750.8837 37.7355526088591 -122.37950381915199 (37.7355526088591, -122.379503819152)
184383 201380 2 8 100 Middle Point Rd 4 2 1 1     3 Width 10ft   6018193.3537099995 2095527.6615900001 37.7349394357932 -122.379503935163 (37.7349394357932, -122.379503935163)
72620 201382 2 8 120 Middle Point Rd 2 2 1 1     2 Width 7ft   6018191.80275 2095463.53858 37.7347632810917 -122.379504844387 (37.7347632810917, -122.379504844387)
66076 201385 2 8 120 Middle Point Rd 5 2 1 1     2 Width 5ft   6018189.447380001 2095346.27491 37.7344411682206 -122.37950484439399 (37.7344411682206, -122.379504844394)
149823 201454 2 8 96 Middle Point Rd 9 2 1 1     1 Width 7ft   6018196.93035 2095729.08903 37.73549271311771 -122.379505557543 (37.7354927131177, -122.379505557543)
157882 201381 2 8 120 Middle Point Rd 1 2 1 1     1 Width 7ft   6018192.01331 2095500.19369 37.7348639404214 -122.379506661926 (37.7348639404214, -122.379506661926)
176121 201386 2 8 120 Middle Point Rd 6 2 1 1     2 Width 5ft   6018188.14311 2095325.0086400001 37.7343827032917 -122.379507876895 (37.7343827032917, -122.379507876895)
153539 201377 2 8 100 Middle Point Rd 1 2 1 1     3 Width 10ft   6018193.606000001 2095600.54319 37.7351395682275 -122.379508124199 (37.7351395682275, -122.379508124199)
171255 201379 2 8 100 Middle Point Rd 3 2 1 1     2 Width 10ft   6018192.62892 2095551.89867 37.7350059460682 -122.379508124201 (37.7350059460682, -122.379508124201)
169795 201378 2 8 100 Middle Point Rd 2 2 1 1     2 Width 10ft   6018192.57747 2095584.31528 37.7350949528572 -122.379510553277 (37.7350949528572, -122.379510553277)
156271 201455 2 60 131 Catalina St 1 2 1 1     3 Width 5ft   6018178.0225 2096034.8800400002 37.73633131204021 -122.379592166743 (37.7363313120402, -122.379592166743)
180950 191595 2 11 450 Amador St 1 2 1 1     6 Width 5ft   6018244.80067 2099614.53285 37.7461640064735 -122.379609893298 (37.7461640064735, -122.379609893298)
35188 191596 2 11 450 Amador St 2 2 1 1     4 Width 5ft   6018234.420580001 2099614.56318 37.74616351723 -122.379645788832 (37.74616351723, -122.379645788832)
158582 201456 2 60 131 Catalina St 2 2 1 1     3 Width 5ft   6018152.99448 2096035.88358 37.736332687111 -122.379678769657 (37.736332687111, -122.379678769657)
27154 192389 2 10 450 Amador St 3 2 1 1     13 Width 5ft   6018217.012999999 2099612.2395900004 37.746156176965606 -122.37970582128901 (37.7461561769656, -122.379705821289)
61641 201457 2 60 131 Catalina St 3 2 1 1     6 Width 5ft   6018132.65618 2096036.7926 37.736334061269005 -122.37974915152 (37.736334061269, -122.37974915152)
135784 191597 2 11 450 Amador St 4 2 1 1     5 Width 5ft   6018199.64479 2099611.87547 37.746154219150796 -122.37976585371099 (37.7461542191508, -122.379765853711)
167624 201458 2 60 131 Catalina St 4 2 1 1     3 Width 5ft   6018111.7846800005 2096036.1618400002 37.7363311780414 -122.37982126995001 (37.7363311780414, -122.37982126995)
154309 201459 2 60 131 Catalina St 5 2 1 1     3 Width 5ft   6018080.74427 2096037.10445 37.736332053971296 -122.379928656194 (37.7363320539713, -122.379928656194)
62552 201477 2 60 200 Catalina St 6 2 1 1     3 Width 5ft   6017976.131469999 2095993.98649 37.7362078890842 -122.380287354394 (37.7362078890842, -122.380287354394)
172918 201460 2 60 221 Catalina St 1 2 1 1     6 Width 5ft   6017973.047069999 2096042.30781 37.7363403996791 -122.380301375718 (37.7363403996791, -122.380301375718)
59368 201476 2 60 200 Catalina St 5 2 1 1     3 Width 5ft   6017960.44466 2095995.0605900001 37.736209972812 -122.38034166533899 (37.736209972812, -122.380341665339)
186199 201461 2 60 221 Catalina St 2 2 1 1     3 Width 5ft   6017953.45292 2096043.24066 37.7363418799584 -122.380369186391 (37.7363418799584, -122.380369186391)
165445 201475 2 60 200 Catalina St 4 2 1 1     3 Width 5ft   6017932.44765 2095996.0751900002 37.73621121387271 -122.38043853402 (37.7362112138727, -122.38043853402)
186851 201462 2 60 221 Catalina St 3 2 1 1     4 Width 5ft   6017931.88164 2096043.5768799998 37.736341612873 -122.380443791448 (37.736341612873, -122.380443791448)
183263 201474 2 60 200 Catalina St 3 2 1 1     3 Width 5ft   6017913.7738 2095996.98532 37.73621268247221 -122.380503161112 (37.7362126824722, -122.380503161112)
50508 201463 2 60 221 Catalina St 4 2 1 1     4 Width 5ft   6017910.1596099995 2096044.43658 37.736342774794004 -122.380518954089 (37.736342774794, -122.380518954089)
83012 201473 2 60 200 Catalina St 2 2 1 1     3 Width 5ft   6017891.6083 2095998.1068 37.736214538679 -122.380579875087 (37.736214538679, -122.380579875087)
75131 199412 2 356 450 Amador St 5 2 1 1     16     6017962.7763 2099598.9904099996 37.7461057708787 -122.380584028138 (37.7461057708787, -122.380584028138)
178359 201464 2 60 221 Catalina St 5 2 1 1     4 Width 5ft   6017881.76944 2096045.3386099997 37.7363436849175 -122.380617174457 (37.7363436849175, -122.380617174457)
44546 201472 2 60 200 Catalina St 1 2 1 1     3 Width 5ft   6017871.79142 2095999.43852 37.7362171017244 -122.38064848344601 (37.7362171017244, -122.380648483446)
32205 201465 2 60 221 Catalina St 6 2 1 1     5 Width 5ft   6017857.702409999 2096046.34832 37.736345129211294 -122.380700455256 (37.7363451292113, -122.380700455256)
25481 198281 2 51 500 Amador St 1 2 1 1     2 Width 8ft   6017868.75025 2099595.89007 37.7460920687928 -122.380908946009 (37.7460920687928, -122.380908946009)
138563 108589 6 17 1139x HUDSON AVE 1 2 1 1           6017760.0 2094672.0 37.732566047797704 -122.38094273978099 (37.7325660477977, -122.380942739781)
Powered by Datasette · Query took 23.363ms · Data source: data.sfgov.org