sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
101348 27884 1 15 280 The Embarcadero 14 1 1 9   01/31/2001 12:00:00 AM 12     6015985.589 2013289.4130000002 37.5090039879895 -122.38142014589701 (37.5090039879895, -122.381420145897)
114566 114692 1 48 391 Girard St 2 1 1 9 3 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)
119175 108830 1 18 46 Ney St   1 1 9 1     3x3   6003763.1265 2093992.4287599998 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217)
100382 115402 1 229 218 Richland Ave 1 1 1 9   01/29/2016 12:00:00 AM 3   Permit Number 776284 6005779.9 2096086.1 37.7357803359495 -122.42246134044301 (37.7357803359495, -122.422461340443)
4972 3572 1 11 100X Cargo Way 7 1 1 9   04/10/2017 09:42:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
5040 3573 1 11 100X Cargo Way 8 1 1 9   04/10/2017 09:44:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
51545 3580 1 78 100X Cargo Way 15 1 1 9     6 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
66646 3581 1 97 100X Cargo Way 16 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
79713 3575 1 41 100X Cargo Way 10 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
84280 3576 1 41 100X Cargo Way 11 1 1 9   03/01/2006 12:00:00 AM 3 3x3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
84902 3682 1 36 100X Cargo Way 118 1 1 9     18 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
85875 3577 1 76 100X Cargo Way 12 1 1 9     3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
95791 3567 1 41 100X Cargo Way 2 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
101112 3570 1 2 100X Cargo Way 5 1 1 9     12 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
103648 3574 1 41 100X Cargo Way 9 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
103993 3578 1 76 100X Cargo Way 13 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
113278 3568 1 41 100X Cargo Way 3 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
117261 3583 1 78 100X Cargo Way 18 1 1 9   05/31/1996 12:00:00 AM 8 3x3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
118559 3686 1 5 100X Cargo Way 1 11 1 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
138764 3571 1 41 100X Cargo Way 6 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
23209 83033 5 41 100X Cargo Way 3 1 1 9   02/04/2006 12:00:00 AM 1     6018894.74802 2097554.01331 37.7405420574702 -122.377219490814 (37.7405420574702, -122.377219490814)
4983 83050 5 232 100X Cargo Way 2 1 1 9   02/04/2006 12:00:00 AM 1     6018877.26977 2097567.07885 37.7405769700435 -122.377280830842 (37.7405769700435, -122.377280830842)
134600 83049 5 2 100X Cargo Way 5 1 1 9   02/04/2006 12:00:00 AM 11     6018864.1607099995 2097578.2563400003 37.7406069390666 -122.377326932804 (37.7406069390666, -122.377326932804)
4989 83048 5 11 100X Cargo Way 4 1 1 9   04/10/2017 09:41:00 AM 3     6018843.8838 2097592.61577 37.7406452501696 -122.37739803950001 (37.7406452501696, -122.3773980395)
43784 83046 5 80 100X Cargo Way 6 1 1 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
4949 83043 5 41 100X Cargo Way 9 1 1 9   03/18/2017 02:49:00 PM 3     6018760.2720099995 2097656.0724299997 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139)
4998 83042 5 77 100X Cargo Way 10 1 1 9   03/18/2017 02:54:00 PM 3     6018742.83505 2097668.8048 37.740848882771 -122.37775271773 (37.740848882771, -122.37775271773)
4985 83041 5 11 100X Cargo Way 11 1 1 9   04/10/2017 09:47:00 AM 3     6018722.37051 2097684.4746 37.74089078129229 -122.377824564564 (37.7408907812923, -122.377824564564)
5059 83040 5 76 100X Cargo Way 12 1 1 9   02/04/2006 12:00:00 AM 6     6018704.22704 2097697.64106 37.740925933998 -122.37788821227699 (37.740925933998, -122.377888212277)
153213 83039 2 76 100X Cargo Way 13 1 1 9   02/04/2006 12:00:00 AM 12     6018611.72965 2097767.00037 37.741111283369705 -122.378212851336 (37.7411112833697, -122.378212851336)
5054 83037 5 78 100X Cargo Way 15 1 1 9   02/04/2006 12:00:00 AM 5     6018575.81097 2097793.86484 37.74118306815279 -122.378338911137 (37.7411830681528, -122.378338911137)
5000 83036 5 97 100X Cargo Way 16 1 1 9   03/18/2017 02:55:00 PM 3     6018559.56213 2097806.04485 37.7412156164156 -122.378395939846 (37.7412156164156, -122.378395939846)
5038 83035 5 78 100X Cargo Way 17 1 1 9   04/10/2017 09:50:00 AM 3     6018541.89406 2097818.9676900003 37.741250126083706 -122.37845792741501 (37.7412501260837, -122.378457927415)
4980 83034 5 78 100X Cargo Way 18 1 1 9   03/18/2017 02:59:00 PM 3     6018525.50747 2097831.43609 37.7412834585567 -122.37851545254298 (37.7412834585567, -122.378515452543)
22342 3584 1 233 100X Cargo Way 19 1 1 9   12/11/1998 12:00:00 AM 3 3X3   6018506.82441 2097843.80813 37.7413163998229 -122.378580911506 (37.7413163998229, -122.378580911506)
4987 27477 1 11 100X Cargo Way 20 1 1 9   04/10/2017 09:59:00 AM 3 3X3   6018492.70308 2097854.80306 37.7413458112573 -122.378630501891 (37.7413458112573, -122.378630501891)
4969 3585 1 11 100X Cargo Way 21 1 1 9   05/01/2017 03:02:00 PM 3 3x3   6018473.32905 2097868.47388 37.7413822805579 -122.37869844028299 (37.7413822805579, -122.378698440283)
5052 3586 1 78 100X Cargo Way 22 1 1 9   04/10/2017 10:01:00 AM 3 3X3   6018456.23147 2097881.24253 37.74141639814229 -122.378758444849 (37.7414163981423, -122.378758444849)
159024 3587 1 2 100X Cargo Way 23 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018440.3984199995 2097892.70026 37.7414469858874 -122.378813986102 (37.7414469858874, -122.378813986102)
5014 3588 5 11 100X Cargo Way 24 1 1 9   04/10/2017 10:07:00 AM 3 3X3   6018423.14615 2097904.9005 37.7414795341434 -122.37887448618 (37.7414795341434, -122.37887448618)
56191 3589 1 78 100X Cargo Way 25 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6018406.34137 2097917.94858 37.741514435040294 -122.37893349789302 (37.7415144350403, -122.378933497893)
22322 3590 1 78 100X Cargo Way 26 1 1 9   03/01/2006 12:00:00 AM 3 3X3   6018389.26392 2097931.71648 37.7415512973552 -122.378993502451 (37.7415512973552, -122.378993502451)
22353 3591 1 76 100X Cargo Way 27 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018372.01456 2097944.0595 37.741584237724396 -122.37905400254499 (37.7415842377244, -122.379054002545)
5065 3592 5 11 100X Cargo Way 28 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6018357.04475 2097955.64275 37.741615217581796 -122.379106567936 (37.7416152175818, -122.379106567936)
23256 3593 5 97 100X Cargo Way 29 1 1 9   04/06/2016 12:00:00 AM 7 3X3   6018341.35218 2097966.95491 37.7416454132021 -122.379161613636 (37.7416454132021, -122.379161613636)
5049 3594 5 78 100X Cargo Way 30 1 1 9     12 3x3   6018322.1359 2097981.33701 37.741683843926396 -122.379229056502 (37.7416838439264, -122.379229056502)
4962 3595 1 78 100X Cargo Way 31 1 1 9   03/18/2017 03:05:00 PM 3 3X3   6018306.03367 2097993.65704 37.741716784307606 -122.379285588775 (37.7417167843076, -122.379285588775)
4978 3596 1 11 100X Cargo Way 32 1 1 9   05/01/2017 03:07:00 PM 3 3X3   6018288.66955 2098007.43076 37.7417536466133 -122.379346585295 (37.7417536466133, -122.379346585295)
4931 3597 1 11 100X Cargo Way 33 1 1 9   11/03/2017 12:00:00 AM 3 3X3   6018273.82586 2098018.1543799997 37.7417822729228 -122.37939865514299 (37.7417822729228, -122.379398655143)
5063 3598 5 78 100X Cargo Way 34 1 1 9   05/01/2017 03:10:00 PM 3 3X3   6018255.028469999 2098031.9569200003 37.7418191352571 -122.37946460960501 (37.7418191352571, -122.379464609605)
1076 3599 1 78 100X Cargo Way 35 1 1 9   05/01/2017 03:11:00 PM 3 3X3   6018236.38581 2098046.3275599997 37.7418575659771 -122.37953006857799 (37.7418575659771, -122.379530068578)
4945 3600 5 78 100X Cargo Way 36 1 1 9   05/01/2017 03:14:00 PM 3 3X3   6018222.967130001 2098056.59418 37.7418850159701 -122.379577179554 (37.7418850159701, -122.379577179554)
5023 3601 5 78 100X Cargo Way 37 1 1 9   04/10/2017 10:11:00 AM 3 3X3   6018206.00756 2098069.0742900004 37.7419183484432 -122.379636687689 (37.7419183484432, -122.379636687689)
22313 3602 5 2 100X Cargo Way 38 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018187.24152 2098084.4470599997 37.7419595239099 -122.379702643058 (37.7419595239099, -122.379702643058)
13941 3603 1 78 100X Cargo Way 39 1 1 9     12 3X3   6018171.24251 2098094.76588 37.741986974834106 -122.379758679838 (37.7419869748341, -122.379758679838)
16197 3604 1 78 100X Cargo Way 40 1 1 9     6 3X3   6018155.728019999 2098107.78819 37.742021875700296 -122.37981322911999 (37.7420218757003, -122.37981322912)
22352 3605 5 78 100X Cargo Way 41 1 1 9     6 3X3   6018137.75637 2098119.86028 37.7420540318827 -122.37987620861601 (37.7420540318827, -122.379876208616)
15214 3606 1 78 100X Cargo Way 42 1 1 9     12 3X3   6018122.20462 2098131.02661 37.742083834489605 -122.379930757907 (37.7420838344896, -122.379930757907)
22330 3607 5 11 100X Cargo Way 43 1 1 9     6 3x3   6018106.23722 2098142.91565 37.742115598557895 -122.37998679465001 (37.7421155985579, -122.37998679465)
22338 3608 5 78 100X Cargo Way 44 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018087.01832 2098157.15518 37.7421536371939 -122.380054237523 (37.7421536371939, -122.380054237523)
22337 3609 5 78 100X Cargo Way 45 1 1 9     9 3X3   6018070.77279 2098169.47823 37.7421865775631 -122.380111266222 (37.7421865775631, -122.380111266222)
22333 3610 5 233 100X Cargo Way 46 1 1 9     6 3X3   6018056.230380001 2098180.90993 37.742217164400294 -122.380162344118 (37.7422171644003, -122.380162344118)
3317 253413 2 29 2433 23rd Ave 1 1 1 9 3     3x3   5989193.66308 2098780.80152 37.7422296590049 -122.48000293550501 (37.7422296590049, -122.480002935505)
22318 3611 5 97 100X Cargo Way 47 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6018038.2961099995 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637)
22328 3612 5 78 100X Cargo Way 48 1 1 9     6 3X3   6018020.628269999 2098207.76094 37.7422889275932 -122.380287312129 (37.7422889275932, -122.380287312129)
16754 3613 1 2 100X Cargo Way 49 1 1 9     6 3X3   6018003.94992 2098219.94993 37.742321475865296 -122.380345828295 (37.7423214758653, -122.380345828295)
5066 3614 5 11 100X Cargo Way 50 1 1 9     12 3X3   6017985.84349 2098232.4529 37.742354807434396 -122.380409304248 (37.7423548074344, -122.380409304248)
13427 3615 1 2 100X Cargo Way 51 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017970.88261 2098244.46459 37.7423869635862 -122.380461869644 (37.7423869635862, -122.380461869644)
15552 3616 1 78 100X Cargo Way 52 1 1 9     12 3X3   6017954.336080001 2098256.07975 37.7424179434233 -122.38051989028901 (37.7424179434233, -122.380519890289)
1081 3617 5 2 100X Cargo Way 53 1 1 9   05/01/2017 03:16:00 PM 3 3X3   6017937.25359 2098269.56212 37.742454020638796 -122.380579893948 (37.7424540206388, -122.380579893948)
5070 3618 5 78 100X Cargo Way 54 1 1 9     12 3X3   6017899.85524 2098296.735 37.7425265680461 -122.380711096061 (37.7425265680461, -122.380711096061)
16830 3619 1 78 100X Cargo Way 55 1 1 9     6 3X3   6017883.8496199995 2098309.7670299998 37.742561468052294 -122.380767345063 (37.7425614680523, -122.380767345063)
5035 3620 1 78 100X Cargo Way 56 1 1 9   05/01/2017 03:20:00 PM 3 3X3   6017867.03936 2098322.52996 37.7425955847281 -122.380826357655 (37.7425955847281, -122.380826357655)
1079 3621 5 78 100X Cargo Way 57 1 1 9   05/01/2017 03:22:00 PM 3 3X3   6017849.66978 2098333.64293 37.7426251400454 -122.380887189608 (37.7426251400454, -122.380887189608)
22346 3622 5 11 100X Cargo Way 58 1 1 9     6 3X3   6017832.2114699995 2098347.65106 37.7426626399605 -122.380948529647 (37.7426626399605, -122.380948529647)
22348 3623 5 2 100X Cargo Way 59 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017813.51979 2098359.7555299997 37.7426948446985 -122.38101400211 (37.7426948446985, -122.38101400211)
4994 3624 5 78 100X Cargo Way 60 1 1 9   05/01/2017 03:25:00 PM 3 3X3   6017797.96297 2098371.7943700003 37.742727042232396 -122.38106863050601 (37.7427270422324, -122.381068630506)
22324 3625 1 78 100X Cargo Way 61 1 1 9     6 3X3   6017781.374919999 2098384.59743 37.7427612812112 -122.38112687781 (37.7427612812112, -122.38112687781)
22349 3626 5 233 100X Cargo Way 62 1 1 9     12 3X3   6017765.800369999 2098395.89545 37.7427914435713 -122.38118151611201 (37.7427914435713, -122.381181516112)
22336 3627 1 97 100X Cargo Way 63 1 1 9   04/06/2016 12:00:00 AM 3 3X3   6017747.14415 2098409.63099 37.7428281287262 -122.381246979566 (37.7428281287262, -122.381246979566)
22335 3628 5 78 100X Cargo Way 64 1 1 9     6 3X3   6017730.69941 2098422.13413 37.7428615520079 -122.38130471064899 (37.7428615520079, -122.381304710649)
22341 3629 5 2 100X Cargo Way 65 1 1 9     6 3X3   6017712.663240001 2098437.04484 37.7429014981049 -122.38136811194201 (37.7429014981049, -122.381368111942)
22321 3630 5 50 100X Cargo Way 66 1 1 9     12 3X3   6017698.24794 2098446.68655 37.7429271764597 -122.381418626885 (37.7429271764597, -122.381418626885)
4973 3631 5 78 100X Cargo Way 67 1 1 9   05/01/2017 03:27:00 PM 3 3X3   6017682.09522 2098458.88711 37.7429597849556 -122.381475327351 (37.7429597849556, -122.381475327351)
22340 3632 5 78 100X Cargo Way 68 1 1 9     6 3X3   6017663.5913 2098472.7680200003 37.7429968775117 -122.38154027458799 (37.7429968775117, -122.381540274588)
14783 3633 1 78 100X Cargo Way 69 1 1 9     6 3X3   6017649.0599 2098484.04513 37.743027039860394 -122.381591304811 (37.7430270398604, -122.381591304811)
22310 3634 5 233 100X Cargo Way 70 1 1 9     6 3X3   6017632.60306 2098495.95511 37.743058833606604 -122.38164903679899 (37.7430588336066, -122.381649036799)
13855 3635 1 78 100X Cargo Way 71 1 1 9   05/31/1996 12:00:00 AM 3 3x3   6017615.70257 2098508.02238 37.7430910347139 -122.38170831381201 (37.7430910347139, -122.381708313812)
22315 3636 5 78 100X Cargo Way 72 1 1 9     12 3X3   6017599.14752 2098522.45762 37.7431297568333 -122.38176656108601 (37.7431297568333, -122.381766561086)
22332 3637 1 78 100X Cargo Way 73 1 1 9     6 3X3   6017581.37685 2098535.7297 37.7431652179942 -122.381828930869 (37.7431652179942, -122.381828930869)
22327 3638 5 11 100X Cargo Way 74 1 1 9     6 3X3   6017567.18226 2098548.9302 37.7432006800566 -122.381878930467 (37.7432006800566, -122.381878930467)
22344 3639 5 97 100X Cargo Way 75 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017551.66161 2098562.89956 37.743238180001995 -122.381933568796 (37.743238180002, -122.381933568796)
14056 3640 1 78 100X Cargo Way 76 1 1 9     12 3X3   6017536.43295 2098576.56598 37.7432748642351 -122.381987176477 (37.7432748642351, -122.381987176477)
4948 3641 1 78 100X Cargo Way 77 1 1 9   05/01/2017 03:31:00 PM 3 3X3   6017517.08856 2098593.13553 37.7433192925522 -122.38205521738999 (37.7433192925522, -122.38205521739)
22339 3642 5 78 100X Cargo Way 78 1 1 9     6 3X3   6017503.4842 2098606.02713 37.7433539389383 -122.382103154832 (37.7433539389383, -122.382103154832)
22311 3643 5 78 100X Cargo Way 79 1 1 9     6 3X3   6017487.6627 2098619.8542 37.7433910314633 -122.382158823763 (37.7433910314633, -122.382158823763)
5067 3644 1 78 100X Cargo Way 80 1 1 9   04/10/2017 10:15:00 AM 3 3X3   6017471.8409400005 2098633.68097 37.7434281231236 -122.382214493629 (37.7434281231236, -122.382214493629)
22350 3645 5 11 100X Cargo Way 81 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017457.23238 2098648.52258 37.7434680683118 -122.38226603915399 (37.7434680683118, -122.382266039154)
4950 3646 5 78 100X Cargo Way 82 1 1 9   04/10/2017 10:16:00 AM 3 3X3   6017441.11571 2098662.50366 37.7435055673357 -122.38232273959999 (37.7435055673357, -122.3823227396)
22347 3647 5 233 100X Cargo Way 83 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6017425.17191 2098677.66921 37.7435463281955 -122.38237892474599 (37.7435463281955, -122.382378924746)
5058 3648 5 233 100X Cargo Way 84 1 1 9   05/31/1996 12:00:00 AM 3 3X3   6017409.48154 2098690.6025 37.7435809736936 -122.382434078367 (37.7435809736936, -122.382434078367)
Powered by Datasette · Query took 5.729ms · Data source: data.sfgov.org