import{s as ce,a as E,e as L,b as ie,t as ge,c as F,h as pe,d as X,f as c,g as _e,i as be,j as O,k as R,l as K,m as ye,n as le,o as $e,p as he,q as we,r as ke,u as W}from"../chunks/scheduler.BZlHRu_0.js";import{S as ve,i as ze,c as D,a as S,m as N,t as g,b,d as Z,e as H,g as ee}from"../chunks/index.a_oafgNU.js";import{s as Ce,Q as ae,p as Re,r as ue,C as qe}from"../chunks/VennDiagram.svelte_svelte_type_style_lang.BbIdL-mm.js";import{w as Ee}from"../chunks/entry.ZK3zkBMq.js";import{e as Fe,h as G,p as Te}from"../chunks/button.Bf4ByDiF.js";import{p as Ie}from"../chunks/stores.DPt2XqOW.js";import{D as je,B as Y,A as xe,Q as te}from"../chunks/AreaMap.BWWL8FHZ.js";function De(o){return{c(){this.h()},l(n){this.h()},h(){document.title="Evidence"},m:W,p:W,d:W}}function me(o){let n,r;return n=new te({props:{queryID:"date_range",queryResult:o[1]}}),{c(){D(n.$$.fragment)},l(a){S(n.$$.fragment,a)},m(a,m){N(n,a,m),r=!0},p(a,m){const d={};m&2&&(d.queryResult=a[1]),n.$set(d)},i(a){r||(g(n.$$.fragment,a),r=!0)},o(a){b(n.$$.fragment,a),r=!1},d(a){H(n,a)}}}function fe(o){let n,r;return n=new te({props:{queryID:"aggregate_stats",queryResult:o[2]}}),{c(){D(n.$$.fragment)},l(a){S(n.$$.fragment,a)},m(a,m){N(n,a,m),r=!0},p(a,m){const d={};m&4&&(d.queryResult=a[2]),n.$set(d)},i(a){r||(g(n.$$.fragment,a),r=!0)},o(a){b(n.$$.fragment,a),r=!1},d(a){H(n,a)}}}function de(o){let n,r;return n=new te({props:{queryID:"fares_by_pickup_location",queryResult:o[3]}}),{c(){D(n.$$.fragment)},l(a){S(n.$$.fragment,a)},m(a,m){N(n,a,m),r=!0},p(a,m){const d={};m&8&&(d.queryResult=a[3]),n.$set(d)},i(a){r||(g(n.$$.fragment,a),r=!0)},o(a){b(n.$$.fragment,a),r=!1},d(a){H(n,a)}}}function Se(o){let n,r,a,m,d,i,I,A=o[0].borough+"",_,V,q,f,k,y,$,M,v,Q,p,z,h,U,T,C,w;function j(e,t){return De}let x=j()(o),l=o[1]&&me(o);f=new je({props:{name:"date_range",data:o[1],dates:"day"}});let u=o[2]&&fe(o);$=new Y({props:{data:o[2],value:"rides",fmt:"num0"}}),v=new Y({props:{data:o[2],value:"fare_amount",fmt:"usd1m"}}),p=new Y({props:{data:o[2],value:"trip_distance",fmt:'#,##0 "mi"'}}),h=new Y({props:{data:o[2],value:"fare_per_mile",fmt:"usd2"}});let s=o[3]&&de(o);return C=new xe({props:{data:o[3],geoJsonUrl:"/taxi_zones.geojson",geoId:"objectid",areaCol:"pickup_location_id",value:"rides",valueFmt:"num0",title:"Rides by Pickup Location",labelCol:"zone",tooltip:[{id:"zone",showColumnName:!1,valueClass:"text-xl font-semibold"},{id:"borough",showColumnName:!1,valueClass:"text-sm text-gray-500"},{id:"rides",fmt:"num0",fieldClass:"text-[grey]",valueClass:"text-[green]"},{id:"fare_amount",fmt:"usd",fieldClass:"text-[grey]",valueClass:"text-[green]"},{id:"trip_distance",fmt:"num0",fieldClass:"text-[grey]",valueClass:"text-[green]"}]}}),{c(){n=E(),x.c(),r=L("meta"),a=L("meta"),m=ie(),d=E(),i=L("h1"),I=L("a"),_=ge(A),V=E(),l&&l.c(),q=E(),D(f.$$.fragment),k=E(),u&&u.c(),y=E(),D($.$$.fragment),M=E(),D(v.$$.fragment),Q=E(),D(p.$$.fragment),z=E(),D(h.$$.fragment),U=E(),s&&s.c(),T=E(),D(C.$$.fragment),this.h()},l(e){n=F(e);const t=pe("svelte-6lktun",document.head);x.l(t),r=X(t,"META",{name:!0,content:!0}),a=X(t,"META",{name:!0,content:!0}),m=ie(),t.forEach(c),d=F(e),i=X(e,"H1",{class:!0,id:!0});var P=_e(i);I=X(P,"A",{href:!0});var J=_e(I);_=be(J,A),J.forEach(c),P.forEach(c),V=F(e),l&&l.l(e),q=F(e),S(f.$$.fragment,e),k=F(e),u&&u.l(e),y=F(e),S($.$$.fragment,e),M=F(e),S(v.$$.fragment,e),Q=F(e),S(p.$$.fragment,e),z=F(e),S(h.$$.fragment,e),U=F(e),s&&s.l(e),T=F(e),S(C.$$.fragment,e),this.h()},h(){O(r,"name","twitter:card"),O(r,"content","summary"),O(a,"name","twitter:site"),O(a,"content","@evidence_dev"),O(I,"href","#paramsborough"),O(i,"class","markdown"),O(i,"id","paramsborough")},m(e,t){R(e,n,t),x.m(document.head,null),K(document.head,r),K(document.head,a),K(document.head,m),R(e,d,t),R(e,i,t),K(i,I),K(I,_),R(e,V,t),l&&l.m(e,t),R(e,q,t),N(f,e,t),R(e,k,t),u&&u.m(e,t),R(e,y,t),N($,e,t),R(e,M,t),N(v,e,t),R(e,Q,t),N(p,e,t),R(e,z,t),N(h,e,t),R(e,U,t),s&&s.m(e,t),R(e,T,t),N(C,e,t),w=!0},p(e,[t]){x.p(e,t),(!w||t&1)&&A!==(A=e[0].borough+"")&&ye(_,A),e[1]?l?(l.p(e,t),t&2&&g(l,1)):(l=me(e),l.c(),g(l,1),l.m(q.parentNode,q)):l&&(ee(),b(l,1,1,()=>{l=null}),Z());const P={};t&2&&(P.data=e[1]),f.$set(P),e[2]?u?(u.p(e,t),t&4&&g(u,1)):(u=fe(e),u.c(),g(u,1),u.m(y.parentNode,y)):u&&(ee(),b(u,1,1,()=>{u=null}),Z());const J={};t&4&&(J.data=e[2]),$.$set(J);const re={};t&4&&(re.data=e[2]),v.$set(re);const oe={};t&4&&(oe.data=e[2]),p.$set(oe);const se={};t&4&&(se.data=e[2]),h.$set(se),e[3]?s?(s.p(e,t),t&8&&g(s,1)):(s=de(e),s.c(),g(s,1),s.m(T.parentNode,T)):s&&(ee(),b(s,1,1,()=>{s=null}),Z());const ne={};t&8&&(ne.data=e[3]),C.$set(ne)},i(e){w||(g(l),g(f.$$.fragment,e),g(u),g($.$$.fragment,e),g(v.$$.fragment,e),g(p.$$.fragment,e),g(h.$$.fragment,e),g(s),g(C.$$.fragment,e),w=!0)},o(e){b(l),b(f.$$.fragment,e),b(u),b($.$$.fragment,e),b(v.$$.fragment,e),b(p.$$.fragment,e),b(h.$$.fragment,e),b(s),b(C.$$.fragment,e),w=!1},d(e){e&&(c(n),c(d),c(i),c(V),c(q),c(k),c(y),c(M),c(Q),c(z),c(U),c(T)),x.d(e),c(r),c(a),c(m),l&&l.d(e),H(f,e),u&&u.d(e),H($,e),H(v,e),H(p,e),H(h,e),s&&s.d(e),H(C,e)}}}function Ne(o,n,r){let a,m;le(o,Ie,s=>r(19,a=s)),le(o,ue,s=>r(23,m=s));let{data:d}=n,{data:i={},customFormattingSettings:I,__db:A,inputs:_}=d;$e(ue,m="4e049e3b2a8bb91efd330a1ee52e17df",m);let V=Fe(Ee(_));he(V.subscribe(s=>r(6,_=s))),we(qe,{getCustomFormats:()=>I.customFormats||[]});const q=(s,e)=>Te(A.query,s,{query_name:e});Ce(q);let f=a.params;ke(()=>!0);let k={initialData:void 0,initialError:void 0},y=G`select * from taxi.dates`,$="select * from taxi.dates";i.date_range_data&&(i.date_range_data instanceof Error?k.initialError=i.date_range_data:k.initialData=i.date_range_data,i.date_range_columns&&(k.knownColumns=i.date_range_columns));let M,v=!1;const Q=ae.createReactive({callback:s=>{r(1,M=s)},execFn:q},{id:"date_range",...k});Q($,{noResolve:y,...k}),globalThis[Symbol.for("date_range")]={get value(){return M}};let p={initialData:void 0,initialError:void 0},z=G`select
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance,
  sum(fare_amount)/sum(trip_distance) as fare_per_mile
from taxi.summary_borough
left join zones.zones z on taxi.summary_borough.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')`,h=`select
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance,
  sum(fare_amount)/sum(trip_distance) as fare_per_mile
from taxi.summary_borough
left join zones.zones z on taxi.summary_borough.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')`;i.aggregate_stats_data&&(i.aggregate_stats_data instanceof Error?p.initialError=i.aggregate_stats_data:p.initialData=i.aggregate_stats_data,i.aggregate_stats_columns&&(p.knownColumns=i.aggregate_stats_columns));let U,T=!1;const C=ae.createReactive({callback:s=>{r(2,U=s)},execFn:q},{id:"aggregate_stats",...p});C(h,{noResolve:z,...p}),globalThis[Symbol.for("aggregate_stats")]={get value(){return U}};let w={initialData:void 0,initialError:void 0},j=G`select
  pickup_location_id,
  zone,
  borough,
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance
from taxi.location l
left join zones.zones z on l.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')
group by all
order by 1`,B=`select
  pickup_location_id,
  zone,
  borough,
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance
from taxi.location l
left join zones.zones z on l.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')
group by all
order by 1`;i.fares_by_pickup_location_data&&(i.fares_by_pickup_location_data instanceof Error?w.initialError=i.fares_by_pickup_location_data:w.initialData=i.fares_by_pickup_location_data,i.fares_by_pickup_location_columns&&(w.knownColumns=i.fares_by_pickup_location_columns));let x,l=!1;const u=ae.createReactive({callback:s=>{r(3,x=s)},execFn:q},{id:"fares_by_pickup_location",...w});return u(B,{noResolve:j,...w}),globalThis[Symbol.for("fares_by_pickup_location")]={get value(){return x}},o.$$set=s=>{"data"in s&&r(4,d=s.data)},o.$$.update=()=>{o.$$.dirty&16&&r(5,{data:i={},customFormattingSettings:I,__db:A}=d,i),o.$$.dirty&32&&Re.set(Object.keys(i).length>0),o.$$.dirty&524288&&r(0,f=a.params),o.$$.dirty&1920&&(y||!v?y||(Q($,{noResolve:y,...k}),r(10,v=!0)):Q($,{noResolve:y})),o.$$.dirty&65&&r(12,z=G`select
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance,
  sum(fare_amount)/sum(trip_distance) as fare_per_mile
from taxi.summary_borough
left join zones.zones z on taxi.summary_borough.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')`),o.$$.dirty&65&&r(13,h=`select
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance,
  sum(fare_amount)/sum(trip_distance) as fare_per_mile
from taxi.summary_borough
left join zones.zones z on taxi.summary_borough.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')`),o.$$.dirty&30720&&(z||!T?z||(C(h,{noResolve:z,...p}),r(14,T=!0)):C(h,{noResolve:z})),o.$$.dirty&65&&r(16,j=G`select
  pickup_location_id,
  zone,
  borough,
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance
from taxi.location l
left join zones.zones z on l.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')
group by all
order by 1`),o.$$.dirty&65&&r(17,B=`select
  pickup_location_id,
  zone,
  borough,
  sum(rides) as rides,
  sum(fare_amount) as fare_amount,
  sum(trip_distance) as trip_distance
from taxi.location l
left join zones.zones z on l.pickup_location_id = z.location_id
where day between '${_.date_range.start}' and '${_.date_range.end}'
and lower(borough) = lower('${f.borough}')
group by all
order by 1`),o.$$.dirty&491520&&(j||!l?j||(u(B,{noResolve:j,...w}),r(18,l=!0)):u(B,{noResolve:j}))},r(8,y=G`select * from taxi.dates`),r(9,$="select * from taxi.dates"),[f,M,U,x,d,i,_,k,y,$,v,p,z,h,T,w,j,B,l,a]}class Be extends ve{constructor(n){super(),ze(this,n,Ne,Se,ce,{data:4})}}export{Be as component};