sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
86739 86757 1 84 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
117606 86758 1 180 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
114230 86759 1 61 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
120349 86760 1 61 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
125822 86761 1 61 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
123656 86762 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
117988 86763 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
89740 86764 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
80300 86765 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
105408 86766 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
117147 86767 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
90997 86768 1 362 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
15790 87061 1 40     19 1 1       3x3 Permit Number 50003          
116169 87111 1 3 470 West Portal Ave 2 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
89237 87112 1 3 470 West Portal Ave 3 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
66024 87113 1 3 470 West Portal Ave 4 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
141981 87114 1 3 470 West Portal Ave 5 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
143327 87115 1 3 470 West Portal Ave 6 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
94096 100243 5 17 1326-1332 Shotwell St   19 1 1           6008043.0 2100485.0 37.7479861507453 -122.41494814206699 (37.7479861507453, -122.414948142067)
126465 101951 7 17 21 Lyell St   19 1 1           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292)
49960 105135 3 26 175X ESMERALDA AVE 1 19 1 2     26     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
128729 105136 3 38 175X ESMERALDA AVE 2 19 1 2           6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
109114 105137 3 3 175X ESMERALDA AVE 3 19 1 2     18     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
143716 105138 3 3 175X ESMERALDA AVE 4 19 1 2     25     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
139638 105139 3 3 175X ESMERALDA AVE 4 19 1 2     25     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
98700 105140 3 3 125X ESMERALDA AVE 1 19 1 2     12     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
116266 105664 2 17 317X DORADO TER 1 19 1 1     10     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
145561 105665 2 40 317X DORADO TER 2 19 1 1     24     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
105735 105666 2 40 317X DORADO TER 3 19 1 1     22     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
85276 105668 2 36 301X DORADO TER 2 19 1 1     12     5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
78014 107210 2 3 603 PERALTA AVE 1 19 1 1     30     6009839.9 2098688.7 37.7431547125392 -122.40860781001498 (37.7431547125392, -122.408607810015)
117494 107817 3 3 501X BROTHERHOOD WAY   19 1 2           5991892.0 2087849.0 37.712370053151204 -122.469877266524 (37.7123700531512, -122.469877266524)
111345 114949 7 3 1X WOODACRE DR 1 19 1 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
114979 118322 6 82 720 BATTERY ST 1 19 1 1           6012486.0 2118560.0 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686)
35785 138256 2 1 2600 GEARY BLVD 1 19 1 1     5 Width 0ft   5999357.6908 2113236.4692 37.7825066175753 -122.44589843946899 (37.7825066175753, -122.445898439469)
74158 138257 2 224 2600 GEARY BLVD 2 19 1 1     4 Width 0ft   5999359.7213 2113228.3471 37.7824844323354 -122.445890830511 (37.7824844323354, -122.445890830511)
53561 138259 2 1 2600 GEARY BLVD 27 19 1 1     19 Width 0ft   5999063.9407 2113176.2302 37.782324439437204 -122.44691034713499 (37.7823244394372, -122.446910347135)
33000 138260 2 38 2600 GEARY BLVD 28 19 1 1     2 Width 0ft   5999060.2181 2113180.9681 37.7823372358083 -122.446923566676 (37.7823372358083, -122.446923566676)
67056 138263 2 1 2600 GEARY BLVD 31 19 1 1     17 Width 0ft   5999038.5591 2113167.7696 37.7822997587534 -122.44699754685101 (37.7822997587534, -122.446997546851)
164558 138264 2 38 2600 GEARY BLVD 32 19 1 1     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.44699593627199 (37.7823276740968, -122.446995936272)
24279 138266 2 47 2600 GEARY BLVD 34 19 1 1     19 Width 0ft   5999024.6838 2113178.2607 37.7823277718518 -122.44704630425699 (37.7823277718518, -122.447046304257)
137300 142638 2 15 333 BAY ST 2 19 1 1     8 Width 0ft   6009068.3546 2121458.9525 37.8056332348144 -122.41288516543301 (37.8056332348144, -122.412885165433)
137444 142738 2 15 333 BAY ST 3 19 1 1     11 Width 0ft   6009098.7568 2121462.5595 37.805644845194 -122.412780209055 (37.805644845194, -122.412780209055)
24212 181351 2 47 2300 Sunset Blvd 5 19 1 1     32 Width 0ft   5985090.6387 2098949.4558 37.7424534945744 -122.49420214621 (37.7424534945744, -122.49420214621)
149629 181352 2 3 2300 Sunset Blvd 13 19 1 1     25 Width 0ft   5985091.6384 2099018.9366 37.7426443285892 -122.494203809651 (37.7426443285892, -122.494203809651)
60510 181353 2 3 2300 Sunset Blvd 15 19 1 1     34 Width 0ft   5985103.1353 2099041.4304 37.7427067632535 -122.49416571483 (37.7427067632535, -122.49416571483)
178149 181354 2 47 2300 Sunset Blvd 19 19 1 1     25 Width 0ft   5985076.1427 2099074.9211 37.742797140118796 -122.494261514147 (37.7427971401188, -122.494261514147)
182857 181357 2 3 2400 Sunset Blvd 12 19 1 1     25 Width 0ft   5985137.6741 2098360.3342 37.740838677714294 -122.49399610623999 (37.7408386777143, -122.49399610624)
64302 181358 2 3 2400 Sunset Blvd 14 19 1 1     11 Width 0ft   5985132.3618 2098384.2396 37.7409040046765 -122.49401623531 (37.7409040046765, -122.49401623531)
39945 181359 2 3 2400 Sunset Blvd 31 19 1 1     22 Width 0ft   5985110.4485 2098473.2209 37.741147041149 -122.494098558838 (37.741147041149, -122.494098558838)
137771 181360 2 47 2400 Sunset Blvd 49 19 1 1     47 Width 0ft   5985113.1047 2098629.2701 37.7415756656355 -122.494100873291 (37.7415756656355, -122.494100873291)
131395 183037 2 8 2523 43rd Ave 1 19 1 1     15 Width 0ft   5983009.062000001 2097931.9719 37.7395377337872 -122.50132425344299 (37.7395377337872, -122.501324253443)
160873 185390 2 154 2300 Sunset Blvd 1 19 1 1     2 Width 0ft   5985092.6382 2098924.4627 37.742384987274704 -122.49419339090001 (37.7423849872747, -122.4941933909)
152791 185391 2 168 2300 Sunset Blvd 2 19 1 1     1 Width 0ft   5985125.1292 2098935.9595 37.7424184556167 -122.49408189561899 (37.7424184556167, -122.494081895619)
185674 185392 2 47 2300 Sunset Blvd 3 19 1 1     38 Width 0ft   5985108.1339 2098944.4572 37.7424407935289 -122.494141285581 (37.7424407935289, -122.494141285581)
183931 185393 2 47 2300 Sunset Blvd 6 19 1 1     30 Width 0ft   5985089.6389999995 2098965.9512 37.742498727988895 -122.49420681837499 (37.7424987279889, -122.494206818375)
35616 185394 2 168 2300 Sunset Blvd 4 19 1 1     1 Width 0ft   5985078.642000001 2098945.9568 37.7424431852403 -122.494243368761 (37.7424431852403, -122.494243368761)
53924 185395 2 24 2300 Sunset Blvd 7 19 1 1     1 Width 0ft   5985077.1425 2098975.4486 37.7425240740104 -122.494250726815 (37.7425240740104, -122.494250726815)
181170 185396 2 108 2300 Sunset Blvd 8 19 1 1     5 Width 0ft   5985088.1394 2098992.4439 37.742571382036 -122.49421395573499 (37.742571382036, -122.494213955735)
53840 185397 2 180 2300 Sunset Blvd 10 19 1 1     2 Width 0ft   5985126.1289 2099011.9385 37.742627131937 -122.49408403757799 (37.742627131937, -122.494084037578)
26814 185398 2 1 2300 Sunset Blvd 11 19 1 1     6 Width 0ft   5985116.1317 2099019.9363 37.7426485067542 -122.49411919382099 (37.7426485067542, -122.494119193821)
159653 185399 2 108 2300 Sunset Blvd 12 19 1 1     2 Width 0ft   5985110.1333 2099026.9344 37.7426673706481 -122.49414044992399 (37.7426673706481, -122.494140449924)
76866 185401 2 108 2300 Sunset Blvd 14 19 1 1     3 Width 0ft   5985086.14 2099023.9352 37.74265773164 -122.494223189599 (37.74265773164, -122.494223189599)
152435 185402 2 180 2300 Sunset Blvd 16 19 1 1     2 Width 0ft   5985125.6291 2099042.93 37.742712196982495 -122.494088049359 (37.7427121969825, -122.494088049359)
131257 185403 2 180 2300 Sunset Blvd 17 19 1 1     1 Width 0ft   5985110.6332 2099073.9214 37.742796413512 -122.49414218382499 (37.742796413512, -122.494142183825)
167557 185404 2 108 2300 Sunset Blvd 18 19 1 1     2 Width 0ft   5985080.6415 2099060.4251 37.7427576012847 -122.494244890555 (37.7427576012847, -122.494244890555)
38464 185405 2 3 2300 Sunset Blvd 20 19 1 1     23 Width 0ft   5985107.634 2099090.4168 37.7428415299236 -122.494153769583 (37.7428415299236, -122.494153769583)
137933 185406 2 3 2300 Sunset Blvd 21 19 1 1     15 Width 0ft   5985111.1331 2099102.9134 37.742876046964604 -122.494142591708 (37.7428760469646, -122.494142591708)
46337 185407 2 180 2300 Sunset Blvd 22 19 1 1     2 Width 0ft   5985075.6429 2099093.4159999997 37.742847892869 -122.49426460522899 (37.742847892869, -122.494264605229)
73057 185408 2 47 2300 Sunset Blvd 23 19 1 1     10 Width 0ft   5985102.6354 2099127.4066 37.742942801420796 -122.49417377884599 (37.7429428014208, -122.494173778846)
149365 185409 2 143 2300 Sunset Blvd 24 19 1 1     8 Width 0ft   5985081.6412 2099150.9001 37.7430060796886 -122.494248101225 (37.7430060796886, -122.494248101225)
170252 185410 2 143 2300 Sunset Blvd 25 19 1 1     8 Width 0ft   5985099.6362 2099155.3989 37.7430194852088 -122.494186211855 (37.7430194852088, -122.494186211855)
162943 185411 2 45 2300 Sunset Blvd 26 19 1 1     10 Width 0ft   5985100.1361 2099184.3909 37.7430991186582 -122.49418661978599 (37.7430991186582, -122.494186619786)
162312 185412 2 3 2300 Sunset Blvd 28 19 1 1     47 Width 0ft   5985078.1422 2099185.3906 37.7431005765205 -122.494262741341 (37.7431005765205, -122.494262741341)
33040 185413 2 45 2300 Sunset Blvd 29 19 1 1     4 Width 0ft   5985092.6382 2099208.8841 37.7431659316065 -122.49421435006501 (37.7431659316065, -122.494214350065)
62482 185414 2 47 2300 Sunset Blvd 30 19 1 1     3 Width 0ft   5985079.1419 2099209.8838 37.743167886728 -122.494261089675 (37.743167886728, -122.494261089675)
57913 185415 2 3 2300 Sunset Blvd 31 19 1 1     16 Width 0ft   5985091.6384 2099216.8819 37.743187832897 -122.494218396427 (37.743187832897, -122.494218396427)
38172 185416 2 47 2300 Sunset Blvd 32 19 1 1     5 Width 0ft   5985081.6412 2099232.3776 37.743229794878296 -122.49425410551599 (37.7432297948783, -122.494254105516)
53374 185417 2 47 2300 Sunset Blvd 33 19 1 1     24 Width 0ft   5985081.6412 2099246.8736 37.7432695969748 -122.49425517376801 (37.7432695969748, -122.494255173768)
60508 185418 2 108 2300 Sunset Blvd 34 19 1 1     3 Width 0ft   5985092.1383 2099264.8686 37.7433196206545 -122.494220204145 (37.7433196206545, -122.494220204145)
179741 185419 2 108 2300 Sunset Blvd 35 19 1 1     3 Width 0ft   5985098.1367 2099271.3668 37.7433378139676 -122.49419994238899 (37.7433378139676, -122.494199942389)
174524 185420 2 108 2300 Sunset Blvd 36 19 1 1     3 Width 0ft   5985096.6371 2099279.3646 37.7433596860109 -122.494205716911 (37.7433596860109, -122.494205716911)
177017 185421 2 108 2300 Sunset Blvd 37 19 1 1     3 Width 0ft   5985094.1378 2099288.8619999997 37.7433856170495 -122.494215058601 (37.7433856170495, -122.494215058601)
187450 185422 2 108 2300 Sunset Blvd 38 19 1 1     4 Width 0ft   5985084.6404 2099285.363 37.7433754539691 -122.494247639854 (37.7433754539691, -122.494247639854)
60439 185423 2 24 2300 Sunset Blvd 39 19 1 1     1 Width 0ft   5985071.643999999 2099284.3632 37.7433719482454 -122.494292503743 (37.7433719482454, -122.494292503743)
147893 185424 2 108 2300 Sunset Blvd 40 19 1 1     3 Width 0ft   5985084.6404 2099301.8584 37.7434207458763 -122.49424885544599 (37.7434207458763, -122.494248855446)
132393 185426 2 3 2300 Sunset Blvd 42 19 1 1     8 Width 0ft   5985086.6398 2099317.3541 37.7434634098799 -122.49424308404801 (37.7434634098799, -122.494243084048)
179607 185430 2 47 2300 Sunset Blvd 46 19 1 1     3 Width 0ft   5985106.6343 2099374.8382 37.7436224157034 -122.49417818512899 (37.7436224157034, -122.494178185129)
25247 185431 2 47 2300 Sunset Blvd 47 19 1 1     40 Width 0ft   5985098.6365 2099386.335 37.743653514796705 -122.49420668637899 (37.7436535147967, -122.494206686379)
181515 185432 2 47 2300 Sunset Blvd 48 19 1 1     28 Width 0ft   5985081.6412 2099386.335 37.7436525202566 -122.49426545113899 (37.7436525202566, -122.494265451139)
134264 185433 2 47 2300 Sunset Blvd 49 19 1 1     2 Width 0ft   5985073.6434 2099396.3323 37.7436795021074 -122.49429384193199 (37.7436795021074, -122.494293841932)
57083 185434 2 47 2300 Sunset Blvd 50 19 1 1     20 Width 0ft   5985080.6415 2099410.3284 37.7437183411386 -122.494270675975 (37.7437183411386, -122.494270675975)
157058 185451 2 47 2400 Sunset Blvd 1 19 1 1     30 Width 0ft   5985130.3697 2098228.1903 37.740475418723506 -122.49401162519399 (37.7404754187235, -122.494011625194)
57892 185452 2 180 2400 Sunset Blvd 2 19 1 1     1 Width 0ft   5985111.1125 2098241.4711 37.7405107574318 -122.49407918667299 (37.7405107574318, -122.494079186673)
34013 185453 2 47 2400 Sunset Blvd 3 19 1 1     32 Width 0ft   5985125.7214 2098256.744 37.740553547520705 -122.494029800854 (37.7405535475207, -122.494029800854)
76180 185454 2 47 2400 Sunset Blvd 4 19 1 1     25 Width 0ft   5985131.0337 2098272.681 37.7405976170701 -122.494012607503 (37.7405976170701, -122.494012607503)
44552 185455 2 1 2400 Sunset Blvd 5 19 1 1     4 Width 0ft   5985131.0337 2098285.2977 37.7406322591341 -122.494013537118 (37.7406322591341, -122.494013537118)
Powered by Datasette · Query took 4.839ms · Data source: data.sfgov.org