search

TechnologyRediscovery / codenforce

municipal code enforcement database application
GNU General Public License v3.0
2 stars 3 forks source link

Synchronize and implement revised linked object roles for scraping #225

Open edarsow opened 2 years ago

edarsow commented 2 years ago

The official unofficial linkedobjectrole table data:


INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (100, 'ParcelMailingaddress', 'contains', 'standard mailing address on parcel', '2021-07-13 12:14:31.377882-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (101, 'ParcelHuman', 'associated with', 'default parcel-human role', '2021-08-05 15:47:10.920067-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (102, 'MailingaddressHuman', 'gets mail at', 'default human-mailing role', '2021-08-05 15:48:00.373826-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (104, 'OccApplicationHuman', 'applicant', 'the person completing the application', '2022-02-23 11:20:29.20346-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (105, 'CECaseHuman', 'associated with', 'default code enforcement case - human role', '2022-02-23 11:20:53.55565-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (106, 'OccPeriodHuman', 'associated with', 'default occupnacy period - person association', '2022-02-23 11:21:20.252497-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (107, 'ParcelUnitHuman', 'associated with', 'default parcel unit - person role', '2022-02-23 11:22:22.756677-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (108, 'CitationHuman', 'associated with', 'default citation - person role', '2022-02-23 11:22:37.84544-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (109, 'EventHuman', 'associated with ', 'default event - person role', '2022-02-23 11:22:51.325155-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (110, 'CitationHuman', 'defendant', 'defendant of the citation', '2022-02-23 11:23:25.965335-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (111, 'CitationHuman', 'witness - defense', 'defense witness', '2022-02-23 11:23:41.220574-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (112, 'CitationHuman', 'witness - code officer', 'plaintiff witness', '2022-02-23 11:24:01.037725-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (113, 'ParcelUnitHuman', 'tenant', 'tenant of the parcel unit', '2022-02-23 11:24:54.230676-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (114, 'ParcelUnitHuman', 'manager', 'manager of the parcel unit', '2022-02-23 11:25:11.207171-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (115, 'CitationDocketHuman', 'associated with', 'default citation docket - person role', '2022-03-10 17:13:14.849026-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (116, 'ParcelHuman', 'currently owns', 'is the parcel owner', '2022-04-27 07:43:24.80819-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (117, 'ParcelHuman', 'formerly owned', 'was a former owner', '2022-04-27 07:43:37.800121-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (118, 'ParcelHuman', 'in process buyer', 'intends to purchase property', '2022-04-27 07:44:14.623487-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (236, 'ParcelHuman', 'Tax Bill Mailing Addressee', 'The name listed above the Tax Bill Mailing Address', '2022-05-11 16:00:16.663794-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (103, 'MailingaddressHuman', 'Owner mailing address', 'The address listed at the bottom of the county profile page', '2022-02-18 16:45:47.278684-05', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (234, 'ParcelMailingaddress', 'Tax Bill Mailing Address', 'The address listed under the "Tax Bill Mailing Address"', '2022-05-11 13:54:38.438303-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (235, 'ParcelMailingaddress', 'County property address', 'The address listed to the left of the Owner Name on county website', '2022-05-11 15:59:30.219628-04', NULL, NULL);
INSERT INTO public.linkedobjectrole (lorid, lorschema, title, description, createdts, deactivatedts, notes) VALUES (237, 'ParcelHuman', 'Owner Name', 'The name listed as "Owner Name:" in the upper right of the county profile page', '2022-05-11 16:05:37.584135-04', NULL, NULL);