HomeMy WebLinkAboutEmail Batch 2b145
From:Mortensen, Eric
Sent:Thursday, July 10, 2025 11:32 AM
To:Claudia Hajjar; Pfarr, Chad
Cc:Jon Andersen; David Murguia; Alex Zhou
Subject:RE: Verkada whitelisted
SVS Vehicle License Table (svs.tbl)
SVS Stolen License Plate Table (slr.tbl)
SVS Felony Vehicle / Felony License Plate Table (sfr.tbl
There tbl files are now in the 4hr script.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Monday, July 7, 2025 12:21 PM
To: Pfarr, Chad <cpfarr@slocity.org>; Mortensen, Eric <emortens@slocity.org>
Cc: Jon Andersen <jon.andersen@verkada.com>; David Murguia <david.murguia@verkada.com>; Alex Zhou
<alex.zhou@verkada.com>
Subject: Re: Verkada whitelisted
Hi Chad and Eric,
I hope you had a nice weekend, and thank you for the follow up! +Alex Zhou is working this week to test the stolen
vehicle data you provided. @Mortensen, Eric Are you able to provide the rest of the files mentioned in Chad's email to
ncic@verkada.com? We do not have login credentials to ca.doj.gov to access these directly.
On the migration side, we have planned to begin the migration on Wednesday 7/9. This is just a friendly reminder to
make sure all necessary footage and data is archived or downloaded. All archives and incidents will be retained on the
original Command org. Were you able to transfer over the user list, or will you need my assistance moving them over
to GovCloud?
Don't hesitate to contact me if you have any questions,
On Thu, Jul 3, 2025 at 11:49 AM Pfarr, Chad <cpfarr@slocity.org> wrote:
Happy Friday to everyone,
I received the following from my California DOJ contact this morning…
“Hi Chad,
146
It sounds like your vendor is referring to the LPR NCIC list that comes from the FBI, which the DOJ makes available to
California LEAs. The NCIC listing contains stolen vehicle information from all 50 states, whereas the data on CLEW is only
from California. The NCIC listing isn’t found on CLEW but is instead set up with the receiving agency as a secure file
transfer. To gain access to this file, an MOU is required, and as mentioned, that process is on hold at this time. I’m hoping we’ll
receive approval to move forward soon, but we’re unfortunately not there yet.
If you have a new vendor, you’d want to get them access to the data on CLEW (only California stolen vehicle information) so
they can automate the downloads for you. The files from CLEW should contain the following information:
SVS Vehicle License Table (svs.tbl)
SVS Stolen License Plate Table (slr.tbl)
SVS Felony Vehicle License Table (sfr.tbl)
MUPS – Amber Alert (SVS/ABS)
MUPS – Blue Alert (Q) (SVS/ABS)
MUPS – Missing and Suspect Vehicles (SVS/ABS)
MUPS – Silver Alert (SVS/ABS)
I’m assuming your vendor has or will automate the process for you, but if you’re interested in accessing the manual downloads,
you can do so here: https://clew.doj.ca.gov/svsabs “
I had a call with them to find out what’s going on with the MOU process being on hold. Sounds like the heads of Cal
DOJ is reworking some of the language in the MOU that would allow us to share the NCIC data. They went through
a similar exercise last year with the MOU for sharing CLEW data and it happened fairly quickly. Hopefully it’s similar
for the NCIC MOU updates. Not exactly what we were hoping for but at least we have some direction on the process
of obtaining the data.
Best, Cahd
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Wednesday, July 2, 2025 5:19 PM
To: Pfarr, Chad <cpfarr@slocity.org>; Mortensen, Eric <emortens@slocity.org>
Cc: David Murguia <david.murguia@verkada.com>; Jon Andersen <jon.andersen@verkada.com>; Alex Zhou
<alex.zhou@verkada.com>
Subject: Re: Verkada whitelisted
Hey Chad and Eric,
147
Just following up from our meeting today -
Below I've attached the migration consideration document we walked through, for your reference. We will plan to
start moving over devices on Wednesday July 9th. As mentioned, all archives and incidents will remain on the
original commercial Command org, and you will still have access to all of that data.
Prior to the migration, @Mortensen, Eric please let me know if you'd like my help manually moving over users, if the
Azure instance is not operational.
@Jon Andersen will work to send out the fingerprint cards to you so that we can get approved and obtain access to
more detailed NCIC/CLEW data. We'll also start testing CLEW's functionality in your Gov account next week
once @Alex Zhou returns.
Thank you both for your help throughout this process! Enjoy the holiday weekend.
Best,
On Thu, Jun 26, 2025 at 4:08 PM Claudia Hajjar <claudia.hajjar@verkada.com> wrote:
Thank you for the support token! I just threw a calendar invite your way!
Talk to you soon,
On Thu, Jun 26, 2025 at 2:58 PM Pfarr, Chad <cpfarr@slocity.org> wrote:
Sorry about that, I knew you would need both accounts and totally spaced. for the
Gov account.
How does 3:30 on 7/2 sound to discuss the migration?
148
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Thursday, June 26, 2025 10:22 AM
To: Pfarr, Chad <cpfarr@slocity.org>
Subject: Re: Verkada whitelisted
Hey Chad,
This is very exciting!! I just called and left you a message, but I'll reiterate it all here too. Do you mind also sending
a full access support token for the GovCloud account? This is where the NCIC data will be hosted.
If you're available, let's set up some time to discuss the migration of the cameras in your old org in more detail. Here
are some times next week that work for me:
Monday 6/30: 9-11 am PT
Tuesday 7/1: 1-3 pm
Wednesday 7/2: 2-4 pm
Now that we have California-specific data, how can we expand this to NCIC access in the state? I know that process
will entail us becoming an approved CJIS vendor and submit fingerprints, but I was informed by another CA
customer that the CLETS committee only meets twice a year to make approvals. So, I want to make sure we're on
the right path.
Thank you for your help thus far!
Talk soon,
On Thu, Jun 26, 2025 at 8:31 AM Pfarr, Chad <cpfarr@slocity.org> wrote:
Good morning Claudia!
I’ve got those cameras sitting in my office waiting for the return info so I’ll get that started.
149
We’re ready to go live with the CLEW data from my perspective. Everything’s been turned into DOJ so we can
start testing!!!
As far as our old account and all those cameras being migrated over to the new account, what do we need to do
to make that happen?
Also, do you know if there’s a way to migrate all my user accounts over quickly or do I need to build them out one
user at a time?
Thank you guys for all the work to get us to this point, we’re very excited! Chad
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Wednesday, June 25, 2025 4:20 PM
To: Pfarr, Chad <cpfarr@slocity.org>; Mortensen, Eric <emortens@slocity.org>
Cc: David Murguia <david.murguia@verkada.com>; Alex Zhou <alex.zhou@verkada.com>; Jon Andersen
<jon.andersen@verkada.com>; Heath, Taylor <theath@slocity.org>; Stevens, John <jstevens@slocity.org>
Subject: Re: Verkada whitelisted
Hey Lt. Pfarr,
I hope all is well. Below I'm attaching a return label for the 5 bullet cameras we are exchanging for the FIPS
cameras. Please let me know if you have any questions as you work to ship the old ones back and/or receive the
new ones.
On the NCIC integration side - Alex was able to deploy the CLEW data, so it should be good to go to test in your
org. Could you please provide an updated support token with full video and image access so that he can test the
integration?
Are there any updates on the state side? I want to make sure we've got all necessary paperwork/fingerprints handled
so that we can bring this integration live in CA.
Thank you again for all of your help,
On Thu, Jun 5, 2025 at 10:58 AM Alex Zhou <alex.zhou@verkada.com> wrote:
150
Thanks. In this case we will only parse the license plates and states for now. When we have more information we
can parse the rest of the data.
On Tue, Jun 3, 2025 at 5:17 PM Mortensen, Eric <emortens@slocity.org> wrote:
I do not have a list, I used the Google. I also don’t know the date, but I suspect it is the date reported stolen.
I’ve CC’d one of our Dispatch Supervisors and an Officer as they may have more information.
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Tuesday, June 3, 2025 5:11 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Claudia Hajjar <claudia.hajjar@verkada.com>; Pfarr, Chad <cpfarr@slocity.org>; David Murguia
<david.murguia@verkada.com>; Jon Andersen <jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Thanks. Do you mind sharing a comprehensive list of plate types so that I can have it parsed into a human
readable form? Also what is the date for and is it important to show it?
On Tue, Jun 3, 2025 at 5:03 PM Mortensen, Eric <emortens@slocity.org> wrote:
License Plate ID / Plate Type / Date
CA42=Disabled Veteran
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
151
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Tuesday, June 3, 2025 1:38 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Claudia Hajjar <claudia.hajjar@verkada.com>; Pfarr, Chad <cpfarr@slocity.org>; David Murguia
<david.murguia@verkada.com>; Jon Andersen <jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Eric,
Thanks for the update. Confirming that we have received the email.
Quick question: I checked the file we received and it looks like it only has 2 columns. The first one is apparently
a license plate. How should we parse and interpret the other column? It looks like the value can be broken down
into:
- 2 letters for state abbreviation, e.g. CA, TX, etc. Is this the state of the license plate?
- 2 digits that do not seem to have a clear meaning, such as 15, 19, 01, 37, etc.
- 8 digits that resemble a date stamp, for example "20220516". What is the meaning of this date?
If you could help us better understand the meaning of the data we will be able to display them in a more
meaningful way.
Thanks,
Alex
On Tue, Jun 3, 2025 at 1:03 PM Mortensen, Eric <emortens@slocity.org> wrote:
This has been completed, please let me know. We will be sending every 4 hours.
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
152
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Friday, May 16, 2025 12:05 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Claudia Hajjar <claudia.hajjar@verkada.com>; Pfarr, Chad <cpfarr@slocity.org>; David Murguia
<david.murguia@verkada.com>; Jon Andersen <jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Thank you! Could you also let us know when it's sent so that I can check on my side.
On Thu, May 15, 2025 at 2:19 PM Mortensen, Eric <emortens@slocity.org> wrote:
This is on me. I will make changes to get the CLEW data tomorrow. My apologies.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Thursday, May 15, 2025 10:58 AM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Claudia Hajjar <claudia.hajjar@verkada.com>; Pfarr, Chad <cpfarr@slocity.org>; David Murguia
<david.murguia@verkada.com>; Jon Andersen <jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Eric,
Could you please remind me of the schema request you mentioned?
We are still waiting for the following to proceed:
- The initial CLEW data file to be sent to ncic@verkada.com. This will allow us to begin creating the
necessary script for downloading, parsing, and ingesting the data. Would appreciate it if you could include a
stable keyword such as "CA CLEW" in the email title.
- Documentation or an explanation of the CLEW data schema. Understanding the schema is crucial for us to
correctly parse the data.
153
Thanks,
Alex
On Wed, May 14, 2025 at 4:53 PM Mortensen, Eric <emortens@slocity.org> wrote:
May I get the schema request re-sent.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Wednesday, May 14, 2025 4:44 PM
To: Pfarr, Chad <cpfarr@slocity.org>
Cc: Mortensen, Eric <emortens@slocity.org>; Alex Zhou <alex.zhou@verkada.com>; David Murguia
<david.murguia@verkada.com>; Jon Andersen <jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hey Chad,
Thank you for sending the devices and support tokens! I'll work with our Migration Specialist to get the
migration prepared and document ready for your signature.
Has Eric had a chance to send the schema over to Alex?
Best,
On Wed, May 14, 2025 at 9:27 AM Pfarr, Chad <cpfarr@slocity.org> wrote:
Good morning Claudia,
154
Support token for the commercial account is
Support token for the Gov account is
Bullet camera SN’s for swat:
Thanks for the help, Chad
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Friday, May 9, 2025 1:49 PM
To: Pfarr, Chad <cpfarr@slocity.org>
Cc: Mortensen, Eric <emortens@slocity.org>; David Murguia <david.murguia@verkada.com>; Alex Zhou
<alex.zhou@verkada.com>; Weston Reed <weston.reed@verkada.com>; Jon Andersen
<jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Chad,
Thanks for meeting with our team today. To recap, we'll have a one-pager for you to sign by next week
regarding the migration. Once that's signed, I'll give your organization a week or so to back up any footage
necessary and kick off the migration process.
In the meantime, could you please provide 30 day access support tokens (with full video/image access) from
both your original Command org and the new GovCloud org? This will enable our migration engineer and I
to access your Command orgs and move over the cameras. If necessary, here is an article on generating an
access support token: https://help.verkada.com/en/articles/5103976-enable-support-access#h_31ecb633d6
155
Could you also please provide the serial numbers of the 5 bullet cameras you'd like us to swap out for FIPS
bullet cameras? We appreciate your help!
Best,
On Wed, May 7, 2025 at 12:24 PM Claudia Hajjar <claudia.hajjar@verkada.com> wrote:
Thanks Chad! Just sent out an invite for Friday 5/9 at 10:30 am.
Talk to you then,
On Wed, May 7, 2025 at 12:02 PM Pfarr, Chad <cpfarr@slocity.org> wrote:
Sounds good. I’m available from noon to 4 tomorrow and from 7 till 2:30 on Friday. Not sure we need
Eric for this.
Thanks, Chad
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Tuesday, May 6, 2025 11:55 AM
To: Pfarr, Chad <cpfarr@slocity.org>
Cc: Mortensen, Eric <emortens@slocity.org>; David Murguia <david.murguia@verkada.com>; Alex Zhou
<alex.zhou@verkada.com>; Weston Reed <weston.reed@verkada.com>; Jon Andersen
<jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Chad and Eric,
I wanted to follow up from our meeting last week. I'd love to set up some time to discuss migrating your
cameras over to GovCloud and what this NCIC integration will look like. What is your availability this
week?
Best,
156
On Tue, Apr 29, 2025 at 10:52 AM Pfarr, Chad <cpfarr@slocity.org> wrote:
Yes, we’ll make 11:30 work.
Thanks
From: Claudia Hajjar <claudia.hajjar@verkada.com>
Sent: Tuesday, April 29, 2025 10:49 AM
To: Pfarr, Chad <cpfarr@slocity.org>
Cc: Mortensen, Eric <emortens@slocity.org>; David Murguia <david.murguia@verkada.com>; Alex Zhou
<alex.zhou@verkada.com>; Weston Reed <weston.reed@verkada.com>; Jon Andersen
<jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Chad,
Apologies I missed this. Does 11:30 am work for you? Unfortunately we can't make 11 am.
Best,
On Mon, Apr 28, 2025 at 2:05 PM Pfarr, Chad <cpfarr@slocity.org> wrote:
Hi Claudia,
Can we bump up from 11-11:30 tomorrow? That works for Eric and me.
Thanks, Chad
Sent from my iPhone
On Apr 28, 2025, at 11:11 AM, Claudia Hajjar <claudia.hajjar@verkada.com> wrote:
Hi Eric and Chad,
157
Does tomorrow Tuesday 4/29 at 11:30 am PT work for you? I've sent out a calendar
invite. If you're unavailable at this time, please let me know and I can reschedule.
Best,
On Thu, Apr 24, 2025 at 5:22 PM Mortensen, Eric <emortens@slocity.org> wrote:
I did not.. Can technical be provided on Monday post 1000 my hours or Tuesday post 1000, but
refrain from 1300 forward.
I’d like to get this working… I’m not the best *nix person, but I think with secondary technical
eye I can get this up and running next week….
..I also have most of Wednesday free as well and Friday is still open.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: David Murguia <david.murguia@verkada.com>
Sent: Thursday, April 24, 2025 5:20 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Alex Zhou <alex.zhou@verkada.com>; Claudia Hajjar <claudia.hajjar@verkada.com>; Pfarr,
Chad <cpfarr@slocity.org>; Weston Reed <weston.reed@verkada.com>; Jon Andersen
<jon.andersen@verkada.com>
Subject: RE: Verkada whitelisted
Hey Eric,
Apologies this completely slipped. Did you have a chance to work through the
integration?
158
Happy to set some time up tomorrow or monday or tuesday of next week.
On Tue, Apr 15, 2025 at 5:03 PM, David Murguia <david.murguia@verkada.com>
wrote:
Thank for the update Eric!
We'll go ahead and find some time for next week.
Looking forward to getting this setup.
-David
On Tue, Apr 15, 2025 at 4:05 PM, Eric Mortensen <emortens@slocity.org> wrote:
Verkada Team… I have moved some projects around. I have the *nix box finished form a
curl/wget side of things. I will be moving things around tomorrow to work on getting it into
the DMZ and opening the firewall for access.
I’m in training for most of the day Thursday and have a site walk on Friday, but can work on
the SFTP server later that day and over the weekend. Let me know what next week’s
schedule is looking like for testing from your servers to grab the file.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
159
From: David Murguia <david.murguia@verkada.com>
Sent: Monday, March 17, 2025 3:58 PM
To: Alex Zhou <alex.zhou@verkada.com>; Claudia Hajjar <claudia.hajjar@verkada.com>
Cc: Pfarr, Chad <cpfarr@slocity.org>; Mortensen, Eric <emortens@slocity.org>; Weston Reed
<weston.reed@verkada.com>; Jon Andersen <jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Eric and Chad,
Hope your week is off to a strong start. Wanted to see if you were able to get the
devices online (Chad) and if you were able to get to the CLEW SFTP setup.
-David
On Fri, Mar 14, 2025 at 11:02 AM, Alex Zhou <alex.zhou@verkada.com> wrote:
Hi Eric,
Checking in to see if you have any updates on setting up the SFTP? Is there anything
else you need from me?
Best,
Alex
On Thu, Feb 6, 2025 at 5:03 PM David Murguia <david.murguia@verkada.com>
wrote:
Leading up to the call, I now Eric, you had mentioned you were heads down kicking
off the new year on the IT side.
Have you had a chance to look at the credentials we provided?
160
On Thu, Feb 06, 2025 at 3:52 PM, Alex Zhou <alex.zhou@verkada.com> wrote:
Sounds good! Just sent you an invitation for 2:30pm tomorrow.
On Thu, Feb 6, 2025 at 3:49 PM Pfarr, Chad <cpfarr@slocity.org> wrote:
I’m good for all of the listed times on the 7th but none of the others.
Chad
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Thursday, February 6, 2025 3:28 PM
To: Pfarr, Chad <cpfarr@slocity.org>
Cc: David Murguia <david.murguia@verkada.com>; Mortensen, Eric
<emortens@slocity.org>; Weston Reed <weston.reed@verkada.com >; Jon Andersen
<jon.andersen@verkada.com>
Subject: Re: Verkada whitelisted
Hi Chad,
Here are some options:
- 2/7 (Fri): 11am-1pm, 2:30pm-3pm, 3:30pm-4pm
- 2/10 (Mon): 10:30am-11am, 1:30pm -2pm, 2:30pm-3pm, 3:30-4pm
- 2/11 (Tue): 11am-11:30am, 1pm-1:30pm, 2pm-2:30pm, or 3:30pm-5:30pm
Please let me know what works best for you and I will send you an invitation.
Thank you and I'm looking forward to talking to you soon!
Best,
Alex
161
On Wed, Feb 5, 2025 at 2:59 PM Pfarr, Chad <cpfarr@slocity.org> wrote:
I can. Do you want to push out a few dates/times?
Thanks, Chad
On Feb 5, 2025, at 2:09 PM, Alex Zhou
<alex.zhou@verkada.com> wrote:
Hi Eric and Chad,
Bumping up this thread. Would you be available to sync on this
topic?
Best,
Alex
On Mon, Jan 13, 2025 at 1:33 PM David Murguia
<david.murguia@verkada.com> wrote:
Hey Eric,
You free to meet tomorrow at 3:45pm PST.
Wanted to check in and see if there were any limitations or
blockers not the technical side.
Best,
David Murguia
162
<image001.jpg>
On Wed, Jan 08, 2025 at 12:52 PM, Eric Mortensen
<emortens@slocity.org> wrote:
I’ve been out of office for a bit and can return to this topic next
week if that works. I believe Chad will be out of leave for a bit,
so this should prob only include myself and your tech side.
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
From: David Murguia <david.murguia@verkada.com>
Sent: Monday, January 6, 2025 3:17 PM
To: Alex Zhou <alex.zhou@verkada.com>
Cc: Mortensen, Eric <emortens@slocity.org>; Weston Reed
<weston.reed@verkada.com>; Pfarr, Chad <cpfarr@slocity.org>; Jon
Andersen <jon.andersen@verkada.com>
Subject: Re: FW: Verkada whitelisted
Hi Chad and Eric,
Are you free for a quick sync this week? We can do Wed or
Thursday AM.
Best,
David
<image001.gif>
On Mon, Jan 06, 2025 at 11:45 AM, Alex Zhou
<alex.zhou@verkada.com> wrote:
163
Hi Eric,
Happy New Year! Hope everything is going well. Bump up the
thread and see if there's any update on your end.
And here is the public SSH key that we will use for
development and testing purposes:
==
Please let me know if there is anything else you need
from me.
Best,
Alex
On Fri, Dec 20, 2024 at 1:10 PM Alex Zhou
<alex.zhou@verkada.com> wrote:
Hi Eric,
164
When you are done for the setup, could you provide the path
to the SFTP server? Also can we have a few test files on that
SFTP for now so that we can test the cron job and pipeline
from our side? Thanks!
I will send you a public SSH key that's only for development
purposes. Once we have verified the end to end pipeline we
can swap to one that we will use for production.
Please let me know if there's anything else you need.
Best,
Alex
On Thu, Dec 19, 2024 at 6:58 PM David Murguia
<david.murguia@verkada.com> wrote:
Not our ideal but can we start with these static IPs?
This will be the quickest path while we think
through a subnet or subdomain to provide in
longer term.
Let us know if this works for you @Eric
-David
165
On Wed, Dec 18, 2024 at 3:34 PM, Eric Mortensen
<emortens@slocity.org> wrote:
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Wednesday, December 18, 2024 3:33 PM
To: Mortensen, Eric <emortens@slocity.org>; Weston Reed
<weston.reed@verkada.com>
Cc: David Murguia <david.murguia@verkada.com>; Pfarr, Chad
<cpfarr@slocity.org>; Jon Andersen
<jon.andersen@verkada.com>
Subject: Re: FW: Verkada whitelisted
Hi Eric,
@Weston Reed from our infra team suggested using a
trusted SSH key pair instead of static IP addresses due to the
management overhead of static IPs. Is this an acceptable
approach?
Best,
Alex
On Tue, Dec 17, 2024 at 6:34 PM Mortensen, Eric
<emortens@slocity.org> wrote:
Sounds good. I have a script setup for automated SVS
download, will just need the IP/subnet for setting up the
firewall rules to
I have a few more things to test out, but
Do you y’all need a copy of the current SVS to verify import
process?
166
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Alex Zhou <alex.zhou@verkada.com>
Sent: Tuesday, December 17, 2024 4:35 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: David Murguia <david.murguia@verkada.com>; Pfarr, Chad
<cpfarr@slocity.org>; Suraj Vathsa
<suraj.vathsa@verkada.com>; Jon Andersen
<jon.andersen@verkada.com>
Subject: Re: FW: Verkada whitelisted
Hi Eric,
Thanks for being flexible. I'll provide that information once
I have them set up on our end.
Best,
Alex
On Tue, Dec 17, 2024 at 8:45 AM Mortensen, Eric
<emortens@slocity.org> wrote:
This should be doable. I can work with our team to get
that configured on the firewall. Can you please provide
the IP or subnet of the system that will be accessing the
SFTP service?
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
167
From: David Murguia <david.murguia@verkada.com>
Sent: Monday, December 16, 2024 12:31 PM
To: Pfarr, Chad <cpfarr@slocity.org>; Mortensen, Eric
<emortens@slocity.org>; Alex Zhou
<alex.zhou@verkada.com>; Suraj Vathsa
<suraj.vathsa@verkada.com>
Cc: Jon Andersen <jon.andersen@verkada.com>
Subject: Re: FW: Verkada whitelisted
Hi Chad and Eric,
Thanks again for meeting last week. Sending over a few
updates.
Chad - Here is our MOU (CJIS
Addendum). (O
ur legal team has asked us to use this instead of sending
over attachment, however it's the same language as in the
attachment).
Eric - Looping in @Alex and @Suraj on our engineering
team. We wanted to see if you could provide a SFTP file
site that we could retrieve the list from?
We discussed and rather than having you upload the list to
us, we'd prefer to retrieve it. That way we have the
appropriate resources to triage in the chance the
integration breaks.
Please let me know if that works and we can move
forward with that architecture.
-David
168
On Thu, Dec 12, 2024 at 2:25 PM, Chad Pfarr
<cpfarr@slocity.org> wrote:
Got a call from the attorney right after our video call. I’m
good to sign the MOU. Can you send over a ready to
sign version with San Luis Obispo Police Department
listed in the “Customer” brackets and I can get it right
back to you.
From: David Murguia <david.murguia@verkada.com>
Sent: Monday, November 25, 2024 3:50 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Pfarr, Chad <cpfarr@slocity.org>; Jon Andersen
<jon.andersen@verkada.com>; Dan Polsby
<dan.polsby@verkada.com>
Subject: RE: Verkada whitelisted
Hi Eric and Lt. Chad,
Had a quick chance to sync with Eric.
Plan forward will be to get through MOU. After that we
can kickoff direct integration with your current server in
the short term while starting the process with CAL DOJ
to integrate directly to the SVS.
Find our MOU below, to get in front of your legal teams.
This is an approved MOU by our legal team (cc-ed here).
We will need to send this one over Ironclad to get it
signed, but wanted to send the PDF so you could get it
in front of your teams.
Added Jon (our Federal CISO) and Dan Polsby (Legal).
Best,
David Murguia
169
On Mon, Nov 25, 2024 at 11:31 AM, David Murguia
<david.murguia@verkada.com> wrote:
Good morning Eric and Lt Chad,
Sent a quick invite later today for 3pm. Please let me
know if that time works for you.
Just wanted to keep momentum on getting to a CAL
DOJ point of contact to kickoff vendor process for
CLETs.
-David
On Thu, Nov 21, 2024 at 5:03 PM, David Murguia
<david.murguia@verkada.com> wrote:
Chad,
Would you help coral the DOJ point of contact?
On Thu, Nov 21, 2024 at 5:02 PM, Eric Mortensen
<emortens@slocity.org> wrote:
I’m free’ish Friday if DOJ can get on a call or anytime on
Monday.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
170
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: David Murguia <david.murguia@verkada.com>
Sent: Thursday, November 21, 2024 4:54 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Pfarr, Chad <cpfarr@slocity.org>
Subject: RE: Verkada whitelisted
Hey Eric,
Would it make sense for us to jump on a call with Cal
DOJ together? On our end that tracks what we've been
seeing and we have resources and engineering help if
it comes down to needing to automate via an SFTP file
download. Although, ideally we can directly ping via
the public IP to DOJ, which we can also provide.
Let me know if you want to meet tomorrow or
Monday to discuss.
On Thu, Nov 21, 2024 at 4:36 PM, Eric Mortensen
<emortens@slocity.org> wrote:
From my last meeting with Cal DOJ I was specifically told
only authorized registered agencies were allowed access
to the hotlists and the automation (e.g. hot-linking via
authorized public IP). However, if there is word that we
can sponsor, we’d be happy to. We just need to know
what requirements are necessary. Previously DOJ had
informed me that they allow us as an agency to provide
copies of the SVS lists to vendors, but only for use for our
specific agency. However that is a manual process unless I
automate it with some scripting and a SFTP destination.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
171
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Pfarr, Chad <cpfarr@slocity.org>
Sent: Thursday, November 21, 2024 2:39 PM
To: David Murguia <david.murguia@verkada.com>;
Mortensen, Eric <emortens@slocity.org>
Subject: FW: Verkada whitelisted
David, meet Eric Mortensen from our IT department.
Eric, David is our new point of contact from Verkada
on the LPR project. David reached out yesterday
with an update that they have been going through
the process of obtaining access to SVS data in North
Carolina and are now starting the process in
California. North Carolina should start sending them
info in a couple weeks. Verkada has hit a roadblock
with Cal DOJ during their initial attempts to contact. I
dug up our emails from last year and this was the
last one I could find with some direction about where
to start. Did you have any further conversation with
Pryanka back then that might help give further
direction? They need the initial sponsor to let DOJ
know that were asking for the integration.
Thanks to you both in advance!
From: Mortensen, Eric <emortens@slocity.org>
Sent: Sunday, July 30, 2023 8:59 AM
To: Priyanka Sekhar <priyanka.sekhar@verkada.com>
Cc: Yi Xu <yi.xu@verkada.com>; Pfarr, Chad
<cpfarr@slocity.org>; Michele Casertano
<michele.casertano@verkada.com>
Subject: RE: Verkada whitelisted
Priyanka,
172
Here is what DOJ provided to us. I’m requesting we get
clarification from our coordinator regarding an outside
vendor’s access.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Priyanka Sekhar <priyanka.sekhar@verkada.com>
Sent: Wednesday, July 26, 2023 3:18 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Yi Xu <yi.xu@verkada.com>; Pfarr, Chad
<cpfarr@slocity.org>; Michele Casertano
<michele.casertano@verkada.com>
Subject: Re: Verkada whitelisted
Thanks Eric! Very helpful.
Let us know when you find out more.
On Tue, Jul 25, 2023 at 8:16 PM Mortensen, Eric
<emortens@slocity.org> wrote:
Priyanka,
Attached is some of the internet I can dig up today;
mostly it appears that NCIS access via CAL-DOJ is
authorized via the agency ya’ll will be working with (ref.
. I’ve reached out to my colleagues to identify
how we may gain access to the SVS list via a web portal
and from there get an idea of what the data structure is.
From there, I’ll probably make an inquiry in regards to a
3rd party access to the data.
173
However, it appears the Axon has direct access to the
SVS data through a direct agreement (looking to see
how that may be obtained).
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Priyanka Sekhar <priyanka.sekhar@verkada.com>
Sent: Tuesday, July 25, 2023 10:19 AM
To: Mortensen, Eric <emortens@slocity.org>; Yi Xu
<yi.xu@verkada.com>
Cc: Pfarr, Chad <cpfarr@slocity.org>; Michele Casertano
<michele.casertano@verkada.com>
Subject: Re: Verkada whitelisted
Hi Eric,
Thanks for meeting with us today! Summarizing the
key action items from our conversation here. The
following details will be necessary for us to start
working on NCIC integrations:
1. Format of the NCIC hotlist (is it a CSV or
txt file, what are the headers etc)
2. Contact at Cal DOJ who can help us
navigate compliance
3. Details on how other vendors (e.g. flock)
have gained permission to access the NCIC
lists
I'll add a placeholder to our calendar for next week -
we can adjust or reschedule as necessary as we get
closer.
174
Best,
Priyanka
On Mon, Jul 17, 2023 at 3:59 PM Mortensen, Eric
<emortens@slocity.org> wrote:
That time should work. I have a hard stop @ 1130 for
some training.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA 93401-3249
E emortensen@slocity.org
T 805.781.7529
From: Priyanka Sekhar
<priyanka.sekhar@verkada.com>
Sent: Monday, July 17, 2023 3:57 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Pfarr, Chad <cpfarr@slocity.org>
Subject: Re: Verkada whitelisted
Hey Eric,
I've set up some time with our engineering lead
next week to discuss implementation questions.
Please feel free to reschedule to a more convenient
time if needed. Chad - Added you for visibility and
you are welcome to join as well. The goal is to
make sure we understand each step required for
integration.
On Tue, Jul 11, 2023 at 3:26 PM Mortensen, Eric
<emortens@slocity.org> wrote:
I do not know for certain, but WA is setup
through the state so I’d point in that direction.
175
Eric Mortensen
IT Systems Engineer
E emortensen@slocity.org
T 805.781.7529
From: Pfarr, Chad <cpfarr@slocity.org>
Sent: Tuesday, July 11, 2023 3:22 PM
To: Priyanka Sekhar
<priyanka.sekhar@verkada.com>; Mortensen,
Eric <emortens@slocity.org>
Subject: RE: Verkada whitelisted
I have no idea. There has to be at least a
State level agreement because we didn’t
have to do this with Flock because they
already have the data flow already
established with CLETS. Eric do you know?
From: Priyanka Sekhar
<priyanka.sekhar@verkada.com>
Sent: Tuesday, July 11, 2023 3:20 PM
To: Mortensen, Eric <emortens@slocity.org>
Cc: Pfarr, Chad <cpfarr@slocity.org>
Subject: Re: Verkada whitelisted
This message is from an External Source. Use caution when deciding to open attachments, click links, or respond.
Thanks Eric! I think it makes sense for us to set up
a time with a representative from our engineering
team here. I'll get that set up asap.
Separately, Chad - do you know if submitting an
application to allow Verkada to get integrated with
the NCIC database holds valid across the nation?
Or will be only be able to deploy cameras in
California?
Thanks for your help!
176
On Fri, Jul 7, 2023 at 11:54 AM Mortensen, Eric
<emortens@slocity.org> wrote:
We have a /24 public subnet that we can assign a
single IP to allow ingress traffic through.
We’d need to be clear on how the ‘download’
would occur.
.
If there is a request for ingress internet traffic to
the Police network, it would require us to submit
an application to the CA-DOJ for a network
design refresh.
Feel free to reach out to my Cell directly for any
clarification I can provide.
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
990 Palm Street, San Luis Obispo, CA
93401-3249
E emortensen@slocity.org
C 805.431.5000
177
From: Pfarr, Chad <cpfarr@slocity.org>
Sent: Friday, July 7, 2023 11:39 AM
To: Mortensen, Eric <emortens@slocity.org>;
Priyanka Sekhar
<priyanka.sekhar@verkada.com>
Subject: RE: Verkada whitelisted
Eric meet Priyanka from Verkada. Priyanka,
Eric is my go to IT guy and will aid in getting
us moving on our project.
From my initial conversation with CLETS this
is what I got. “
Once we verify the address, we will
have it whitelisted.
At that point, the new camera vendor
can work with San Luis Obispo PD’s network
staff to get it to work.”
Let me know how I can help, Chad
From: Mortensen, Eric <emortens@slocity.org>
Sent: Friday, July 7, 2023 11:06 AM
To: Pfarr, Chad <cpfarr@slocity.org>
Subject: Re: Verkada whitelisted
I think I’ll need some more technical information
on that.. I’m around today and next week, they
can reach out directly
Eric Mortensen
IT Systems Engineer
City of San Luis Obispo
178
T 805.781.7529
From: Pfarr, Chad <cpfarr@slocity.org>
Sent: Friday, July 7, 2023 10:24:29 AM
To: Mortensen, Eric <emortens@slocity.org>
Subject: Verkada whitelisted
Wanted to start a conversation about getting
Verkada whitelisted with CLETS so we can
leverage their LPR features without us
having to manually input all the stolen
vehicles into a hot list. Do you know how to
go about making that happen?
Chad Pfarr
Police Lieutenant
Police Department
1042 Walnut Street, San Luis Obispo, CA
93401-2729
E cpfarr@slocity.org
T 805.781.7336
slocity.org
Stay connected with the City by signing up
for e-notifications
This e-mail, and any files transmitted with
it, are intended only for the person or
entity to which it is addressed and may
contain confidential, protected, and/or
privileged material. Any review, re-
transmission, dissemination or other use
of, or taking of any action in reliance
upon this information by persons or
entities other than the intended recipient,
is prohibited. If you received this in error,
please contact the sender and delete the
material from any computer.
179
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
180
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
181
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
182
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com
--
Claudia R. Hajjar
Product Specialist
(201) 410-9091
406 E 3rd Ave | San Mateo, CA 94401
claudia.hajjar@verkada.com