Skip to content
Snippets Groups Projects

GeoModel with two veto station volumes

Merged GeoModel with two veto station volumes
dcasper/calypso:master-veto-factory into master
Merged Dave Casper requested to merge dcasper/calypso:master-veto-factory into master
Compare
and
42 files
+ 5109
− 131
Compare changes
  • Side-by-side
  • Inline
Files
42
DetectorDescription/GeoModel/FaserGeoModel/data/geomDB.sql
+ 50
− 55
@@ -106,41 +106,42 @@ CREATE TABLE IF NOT EXISTS "ELEMENTS_DATA2TAG" (
--
-- Tables for describing scintillator plates (and passive radiators)
--
DROP TABLE IF EXISTS "SCINTPLATE_DATA";
CREATE TABLE IF NOT EXISTS "SCINTPLATE_DATA" (
"SCINTPLATE_DATA_ID" SLONGLONG UNIQUE,
"MODEL" SLONGLONG,
"WIDTH" DOUBLE,
"HEIGHT" DOUBLE,
"THICKNESS" DOUBLE,
"MATERIAL" TEXT,
"SENSITIVE" SLONGLONG
DROP TABLE IF EXISTS "VETOTOPLEVEL_DATA";
CREATE TABLE IF NOT EXISTS "VETOTOPLEVEL_DATA" (
"VETOTOPLEVEL_DATA_ID" SLONGLONG UNIQUE,
"POSX" DOUBLE,
"POSY" DOUBLE,
"POSZ" DOUBLE,
"ROTX" DOUBLE,
"ROTY" DOUBLE,
"ROTZ" DOUBLE,
"ROTORDER" INT,
"LABEL" TEXT
);
--
-- The DATA2TAG tables associate specific rows of the corresponding
-- _DATA table with the referenced tag (from the HVS_TAG2NODE table).
-- This is a many-to-many relationship: each row may belong to
-- several tags, and each tag may apply to several rows.
DROP TABLE IF EXISTS "SCINTPLATE_DATA2TAG";
CREATE TABLE IF NOT EXISTS "SCINTPLATE_DATA2TAG" (
"SCINTPLATE_TAG_ID" SLONGLONG,
"SCINTPLATE_DATA_ID" SLONGLONG
);
-- Tables for describing scintillator stations (placements)
DROP TABLE IF EXISTS "SCINTSTATION_DATA";
CREATE TABLE IF NOT EXISTS "SCINTSTATION_DATA" (
"SCINTSTATION_DATA_ID" SLONGLONG UNIQUE,
"NAME" TEXT,
"MODEL" SLONGLONG,
"XPOS" DOUBLE,
"YPOS" DOUBLE,
"ZPOS" DOUBLE
-- unclear whether default rotation is needed; start by assuming it isn't
-- the orientation will be alignable in any case
);
DROP TABLE IF EXISTS "SCINTSTATION_DATA2TAG";
CREATE TABLE IF NOT EXISTS "SCINTSTATION_DATA2TAG" (
"SCINTSTATION_TAG_ID" SLONGLONG,
"SCINTSTATION_DATA_ID" SLONGLONG
DROP TABLE IF EXISTS "VETOTOPLEVEL_DATA2TAG";
CREATE TABLE IF NOT EXISTS "VETOTOPLEVEL_DATA2TAG" (
"VETOTOPLEVEL_TAG_ID" SLONGLONG,
"VETOTOPLEVEL_DATA_ID" SLONGLONG
);
--
DROP TABLE IF EXISTS "VETOSTATIONGENERAL_DATA";
CREATE TABLE IF NOT EXISTS "VETOSTATIONGENERAL_DATA" (
"VETOSTATIONGENERAL_DATA_ID" SLONGLONG UNIQUE,
"NUMPLATES" INT,
"WIDTH" DOUBLE,
"LENGTH" DOUBLE,
"THICKNESS" DOUBLE
);
--
DROP TABLE IF EXISTS "VETOSTATIONGENERAL_DATA2TAG";
CREATE TABLE IF NOT EXISTS "VETOSTATIONGENERAL_DATA2TAG" (
"VETOSTATIONGENERAL_TAG_ID" SLONGLONG,
"VETOSTATIONGENERAL_DATA_ID" SLONGLONG
);
-- Tables for scintillator materials.
-- Materials are recorded in two related nodes.
@@ -258,7 +259,7 @@ CREATE TABLE IF NOT EXISTS "SCINTIDENTIFIER_DATA" (
DROP TABLE IF EXISTS "SCINTIDENTIFIER_DATA2TAG";
CREATE TABLE IF NOT EXISTS "SCINTIDENTIFIER_DATA2TAG" (
"SCINTIDENTIFIER_TAG_ID" SLONGLONG,
"SCINTIDENTIFIER_DATA_ID" SLONGSLONG
"SCINTIDENTIFIER_DATA_ID" SLONGLONG
);
--
DROP TABLE IF EXISTS "TRACKERIDENTIFIER_DATA";
@@ -271,7 +272,7 @@ CREATE TABLE IF NOT EXISTS "TRACKERIDENTIFIER_DATA" (
DROP TABLE IF EXISTS "TRACKERIDENTIFIER_DATA2TAG";
CREATE TABLE IF NOT EXISTS "TRACKERIDENTIFIER_DATA2TAG" (
"TRACKERIDENTIFIER_TAG_ID" SLONGLONG,
"TRACKERIDENTIFIER_DATA_ID" SLONGSLONG
"TRACKERIDENTIFIER_DATA_ID" SLONGLONG
);
--
DROP TABLE IF EXISTS "CALOIDENTIFIER_DATA";
@@ -284,7 +285,7 @@ CREATE TABLE IF NOT EXISTS "CALOIDENTIFIER_DATA" (
DROP TABLE IF EXISTS "CALOIDENTIFIER_DATA2TAG";
CREATE TABLE IF NOT EXISTS "CALOIDENTIFIER_DATA2TAG" (
"CALOIDENTIFIER_TAG_ID" SLONGLONG,
"CALOIDENTIFIER_DATA_ID" SLONGSLONG
"CALOIDENTIFIER_DATA_ID" SLONGLONG
);
--
-- Part 2a: HVS data
@@ -302,8 +303,8 @@ INSERT INTO "HVS_NODE" VALUES (100, "Materials", 0, 1, NULL);
INSERT INTO "HVS_NODE" VALUES (101, "StdMaterials", 100, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (102, "StdMatComponents", 100, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (103, "Elements", 100, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (1001, "ScintPlate", 1, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (1002, "ScintStation", 1, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (1001, "VetoTopLevel", 11, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (1002, "VetoStationGeneral", 11, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (1003, "ScintMaterials", 1, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (1004, "ScintMatComponents", 1, 0, NULL);
INSERT INTO "HVS_NODE" VALUES (2003, "TrackerMaterials", 2, 0, NULL);
@@ -327,8 +328,8 @@ INSERT INTO "HVS_TAG2NODE" VALUES (100, "Materials-00", 100005, NULL, 0, 0, 1549
INSERT INTO "HVS_TAG2NODE" VALUES (101, "StdMaterials-00", 100006, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (102, "StdMatComponents-00", 100007, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (103, "Elements-00", 100008, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (1001, "ScintPlate-00", 100009, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (1002, "ScintStation-00", 100010, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (1001, "VetoTopLevel-00", 100009, NULL, 0, 0, 1567123200000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (1002, "VetoStationGeneral-00", 100010, NULL, 0, 0, 1567123200000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (1003, "ScintMaterials-00", 100011, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (1004, "ScintMatComponents-00", 100012, NULL, 0, 0, 1549238400000000000, NULL, 22);
INSERT INTO "HVS_TAG2NODE" VALUES (2003, "TrackerMaterials-00", 100021, NULL, 0, 0, 1550448000000000000, NULL, 22);
@@ -352,8 +353,8 @@ INSERT INTO "HVS_LTAG2LTAG" VALUES (0, 100000, 100, 100005);
INSERT INTO "HVS_LTAG2LTAG" VALUES (100, 100005, 101, 100006);
INSERT INTO "HVS_LTAG2LTAG" VALUES (100, 100005, 102, 100007);
INSERT INTO "HVS_LTAG2LTAG" VALUES (100, 100005, 103, 100008);
INSERT INTO "HVS_LTAG2LTAG" VALUES (1, 100001, 1001, 100009);
INSERT INTO "HVS_LTAG2LTAG" VALUES (1, 100001, 1002, 100010);
INSERT INTO "HVS_LTAG2LTAG" VALUES (11, 100015, 1001, 100009);
INSERT INTO "HVS_LTAG2LTAG" VALUES (11, 100015, 1002, 100010);
INSERT INTO "HVS_LTAG2LTAG" VALUES (1, 100001, 1003, 100011);
INSERT INTO "HVS_LTAG2LTAG" VALUES (1, 100001, 1004, 100012);
INSERT INTO "HVS_LTAG2LTAG" VALUES (2, 100002, 2003, 100021);
@@ -378,8 +379,8 @@ INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "Materials", "Materials-
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "StdMaterials", "StdMaterials-00", 100006);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "StdMatComponents", "StdMatComponents-00", 100007);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "Elements", "Elements-00", 100008);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "ScintPlate", "ScintPlate-00", 100009);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "ScintStation", "ScintStation-00", 100010);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "VetoTopLevel", "VetoTopLevel-00", 100009);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "VetoStationGeneral", "VetoStationGeneral-00", 100010);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "ScintMaterials", "ScintMaterials-00", 100011);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "ScintMatComponents", "ScintMatComponents-00", 100012);
INSERT INTO "HVS_TAGCACHE" VALUES ("FASER-00", "TrackerMaterials", "TrackerMaterials-00", 100021);
@@ -928,22 +929,16 @@ INSERT INTO "ELEMENTS_DATA2TAG" VALUES (100008, 90);
INSERT INTO "ELEMENTS_DATA2TAG" VALUES (100008, 91);
--
--
INSERT INTO "SCINTPLATE_DATA" VALUES (0, 0, 30.0, 30.0, 2.0, "scint::Scintillator", 1);
INSERT INTO "SCINTPLATE_DATA" VALUES (1, 1, 40.0, 20.0, 1.0, "scint::Scintillator", 1);
INSERT INTO "SCINTPLATE_DATA" VALUES (2, 2, 30.0, 30.0, 11.0, "std::Lead", 0);
INSERT INTO "SCINTPLATE_DATA2TAG" VALUES (100009, 0);
INSERT INTO "SCINTPLATE_DATA2TAG" VALUES (100009, 1);
INSERT INTO "SCINTPLATE_DATA2TAG" VALUES (100009, 2);
--
-- Assume 1cm gaps between magnet/plate/slab/plate
INSERT INTO "VETOTOPLEVEL_DATA" VALUES (0, 0.0, 0.0, -1650.0, 0.0, 0.0, 0.0, 321, "Veto");
INSERT INTO "VETOTOPLEVEL_DATA" VALUES (1, 0.0, 0.0, -100.0, 0.0, 0.0, 0.0, 321, "StationA");
INSERT INTO "VETOTOPLEVEL_DATA" VALUES (2, 0.0, 0.0, 100.0, 0.0, 0.0, 0.0, 321, "StationB");
INSERT INTO "VETOTOPLEVEL_DATA2TAG" VALUES (100009, 0);
INSERT INTO "VETOTOPLEVEL_DATA2TAG" VALUES (100009, 1);
INSERT INTO "VETOTOPLEVEL_DATA2TAG" VALUES (100009, 2);
--
INSERT INTO "SCINTSTATION_DATA" VALUES (0, "VetoPlateA", 0, 0.0, 0.0, -167.0 );
INSERT INTO "SCINTSTATION_DATA" VALUES (1, "VetoAbsorber", 2, 0.0, 0.0, -159.5 );
INSERT INTO "SCINTSTATION_DATA" VALUES (2, "VetoPlateB", 0, 0.0, 0.0, -152.0 );
INSERT INTO "SCINTSTATION_DATA2TAG" VALUES (100010, 0);
INSERT INTO "SCINTSTATION_DATA2TAG" VALUES (100010, 1);
INSERT INTO "SCINTSTATION_DATA2TAG" VALUES (100010, 2);
--
INSERT INTO "VETOSTATIONGENERAL_DATA" VALUES (0, 2, 300.0, 300.0, 20.0);
INSERT INTO "VETOSTATIONGENERAL_DATA2TAG" VALUES (100010, 0);
--
INSERT INTO "SCINTMATERIALS_DATA" VALUES (0, "Scintillator", 1.032);
INSERT INTO "SCINTMATERIALS_DATA2TAG" VALUES (100011, 0);