Is anyone aware of how to separate tag_string from the posts.csv from /db-export/ into
tags.general,
tags.characters,
tags.meta,
tags.artist,
tags.lore,
tags.copyright,
tags.invalid?

Tag string for post 22:

tag_string: '1:1 2007 anthro anus areola autopenetration bangs belly biped black_collar blue_hair bodily_fluids body_part_in_pussy breasts breasts_apart collar collar_only console countershading dark_body dark_collar dark_skin dark_tail dark_wings digital_media_(artwork) dragon electronic_device eye_through_hair fangs female female_penetrated female_penetrating gaming genital_fluids genitals grey_background grey_body grey_markings grey_skin grey_tail grey_wings hair hair_over_eye half-closed_eyes handheld holding_object irys lidded_eyes light_areola light_breasts light_nipples long_bangs looking_at_object lying markings masturbation medium_breasts membrane_(anatomy) membranous_wings monotone_breasts multicolored_body multicolored_hair multicolored_skin multicolored_wings multitasking narrowed_eyes navel nintendo nintendo_ds nintendo_ds_family nipples non-mammal_breasts nude on_back one_eye_obstructed penetration pillow playing_videogame purple_eyes pussy pussy_juice pussy_juice_on_tail scalie simple_background smile smirk solo source_request spiked_collar spikes spread_legs spread_wings spreading stripes syrinoth syrinoth_(character) tail_fetish tail_in_pussy tail_masturbation tail_play tan_areola tan_nipples translucent translucent_hair two_tone_body two_tone_hair two_tone_skin two_tone_wings vaginal vaginal_masturbation vaginal_penetration video_games white_belly white_body white_breasts white_countershading white_pussy white_skin white_wings wings'

e621 response for post 22:

"tags": {
"general": [
"anthro",
"anus",
"areola",
"autopenetration",
"bangs",
"belly",
"biped",
"black_collar",
"blue_hair",
"bodily_fluids",
"body_part_in_pussy",
"breasts",
"breasts_apart",
"collar",
"collar_only",
"console",
"countershading",
"dark_body",
"dark_collar",
"dark_skin",
"dark_tail",
"dark_wings",
"electronic_device",
"eye_through_hair",
"fangs",
"female",
"female_penetrated",
"female_penetrating",
"gaming",
"genital_fluids",
"genitals",
"grey_background",
"grey_body",
"grey_markings",
"grey_skin",
"grey_tail",
"grey_wings",
"hair",
"hair_over_eye",
"half-closed_eyes",
"handheld",
"holding_object",
"lidded_eyes",
"light_areola",
"light_breasts",
"light_nipples",
"long_bangs",
"looking_at_object",
"lying",
"markings",
"masturbation",
"medium_breasts",
"membrane_(anatomy)",
"membranous_wings",
"monotone_breasts",
"multicolored_body",
"multicolored_hair",
"multicolored_skin",
"multicolored_wings",
"multitasking",
"narrowed_eyes",
"navel",
"nipples",
"non-mammal_anus",
"non-mammal_breasts",
"non-mammal_navel",
"non-mammal_nipples",
"non-mammal_pussy",
"nude",
"on_back",
"one_eye_obstructed",
"penetration",
"pillow",
"playing_videogame",
"purple_eyes",
"pussy",
"pussy_juice",
"pussy_juice_on_tail",
"simple_background",
"smile",
"smirk",
"solo",
"spiked_collar",
"spikes",
"spread_legs",
"spread_wings",
"spreading",
"stripes",
"tail_fetish",
"tail_in_pussy",
"tail_masturbation",
"tail_play",
"tan_areola",
"tan_nipples",
"translucent",
"translucent_hair",
"two_tone_body",
"two_tone_hair",
"two_tone_skin",
"two_tone_wings",
"vaginal",
"vaginal_masturbation",
"vaginal_penetration",
"video_games",
"white_belly",
"white_body",
"white_breasts",
"white_countershading",
"white_pussy",
"white_skin",
"white_wings",
"wings"
],
"species": [
"dragon",
"scalie"
],
"character": [
"irys",
"syrinoth_(character)"
],
"copyright": [
"nintendo",
"nintendo_ds",
"nintendo_ds_family"
],
"artist": [
"syrinoth"
],
"invalid": [],
"lore": [],
"meta": [
"1:1",
"2007",
"digital_media_(artwork)",
"source_request"
]
}

I've looked at the tag_aliases, tag_implications, and tags csv files from /db-export/ yet can't seem to figure out how to separate them into categories.

Any help would be appreciated.

There's a field called category in tags.csv. You'll need to manually convert that into the actual name though. Take a look here under categories to know which number is which.

earlopain said:
Earlopain

Thanks mate!

Building off this. How are tag implications and tag aliases included in any posts .json?

I read through the API page for tag implications, and from what I can tell, the antecedent name should push a consequent name to the appropriate tag key if it's an active tag implication. Is this correct?

Also, are both tags and their aliases included in any posts .json in the same manner?

Thanks in advance c:

Tag implications do change the tags you get from posts.json. On update or creation the tag string gets modified to contain the targets of the implication. The result is that a post tagged only male_penetrating_female contains 7 tags, all those that get added through implications and implications of those implications.

If I would add the tag male_on_male which is aliased away to male/male you would only find the target of the alias in the response.

earlopain said:
Tag implications do change the tags you get from posts.json. On update or creation the tag string gets modified to contain the targets of the implication. The result is that a post tagged only male_penetrating_female contains 7 tags, all those that get added through implications and implications of those implications.

If I would add the tag male_on_male which is aliased away to male/male you would only find the target of the alias in the response.

In the context of posts.json from /db_export/:

Are the tag implications already contained in tag_string? Or do they need to be added? And is it the same situation for tag_alieses?

lightsbane said:
In the context of posts.json from /db_export/:

Are the tag implications already contained in tag_string? Or do they need to be added? And is it the same situation for tag_alieses?

They should already be contained in there since it is, as the name suggests, a db export. The db field does actually contain the resolved tags and not what the user might have input in the beginning.