Census Repository Facility, Version 2

[TEP 0]

This looks awesome! Great work!

I usually steer clear of mods, but I am a very grateful user of the excellent RCI Query Upgrade Mod by Equinox. Is there any chance that this could be made to work in a similar fashion, that is, without the building?

[Swamper77 90]

TEP,

Query UIs require a building to function. Otherwise, there is no way to call them.

-Swamper77

[schm0 27]

Originally posted by: RippleJet

Yes, I am considering a cheaper version without jobs. That has been requested also for farming communities, where 150 middle- and high-wealth jobs are not appropriate.quote>

I know you're busy with the CAM and whatnot, but I had a quick question. Do I understand that this building costs a lot of money to plop? I know we're going for realism here, but this building is a MOD, not a regular lot. Perhaps several different types of "repository branches"... a small shack with a little satellite on it for rural areas, a 2x2 small commercial office for suburban areas, and the existing tower for urban areas. Just a suggestion or three.

[RippleJet 36]

Originally posted by: schm0 I know you're busy with the CAM and whatnot, but I had a quick question. Do I understand that this building costs a lot of money to plop? I know we're going for realism here, but this building is a MOD, not a regular lot. Perhaps several different types of "repository branches"... a small shack with a little satellite on it for rural areas, a 2x2 small commercial office for suburban areas, and the existing tower for urban areas. Just a suggestion or three. quote>

I'm sorry I haven't been able to reply earlier. I'm actually on vacation, writing this off my laptop in Brussels, a long way from home.

However, CAM will be my first priority when returning home one week from now.

The cost for the Census Repository is 15,000 §, and that is unchanged from RalphaelNinja's original version.

Since I'm not a batter myself, I doubt there will be different versions for rural/city use (but who knows). However, as I've said before, I will return to this after the CAM is public and at least reduce the plop cost and the number of jobs it offers.

[mistershnerples 0]

ripplejet: i dLed the census. what does the available vacant jobs mean? so here's a link to my census. so if i have a large negative number, then there arent many jobs available and that there are that many looking for jobs? i dont understand why my residential population keeps going up if there aren't jobs available. however, the city to the east of this one is all IHT and has about like 103,000 jobs. so that may be why.

https://s29.photobucket.com/albums/c282/mistershnerples/?action=view&current=montereycensus-year196.jpg

[RippleJet 36]

Yes, the demand works on a regional basis. If there are jobs available in the region, the residential demand will still be there, even if there are no jobs available in the city itself.

If the neighbouring city has lots of IHT jobs, then you probably have quite a number of industrial commuters into that city (they are also reported by the Census Repository).

[patfirefghtr 160]

Rj thank you again M8 i got and will work with l8trs - pat

[nycyyz 0]

I downloaded the files but only got the simple screen. How do I get the advanced GUI?

[nycyyz 0]

Sorry, nevermind, I just found the link to the beta version 2 further down in this post. It was so small I missed it the first go around. Great program!!

[nycyyz 0]

I do have a question about the report. Why is the workforce number on the right hand side always around 2x the actual workforce in the city. I tried it on existing and brand new regions. Same result. I can see if if you have neighbor connections this might be (but for me it is almost always EXACTLY 2X), but for a brand new city with no connections it does the same. And I can tell you (the OP) are definitely right about existing regions and the CAM. Yikes. After working on the 10th city I got so many eternal commuters I have -1million vacant jobs, and my region didn't even have that many to begin with!!. I mean 2 million eternal commuters????? My region has just barely has over 2million residents.. LOL. I gonna have to isolate each city until jobs fill up and go onto the next one before I connect them all, otherwise I'll never get any residential demand in large regions. I know about the loop and eternal commuting, but I am recreating New York City and I want to stay true to the transit network as best I can, I don't want to have to put all my connections in the middle of the city. Thanks for this great report, I learned a lot of how this game works on the commuting angle. (the game engine is definitely broken I'm afraid!)

[RippleJet 36]

Originally posted by: nycyyz I do have a question about the report. Why is the workforce number on the right hand side always around 2x the actual workforce in the city. I tried it on existing and brand new regions. Same result. I can see if if you have neighbor connections this might be (but for me it is almost always EXACTLY 2X), but for a brand new city with no connections it does the same.quote>

The "workforce on the right", do you mean the regional workforce compared to the city workforce?

The regional numbers are always estimates, since you're only playing one city at a time.

Playing one city might increase the estimate of workforce in your neighbouring cities, without actually adding anything to those cities. In order to get a balanced and accurate estimation you need to switch between your cities quite often.

Originally posted by: nycyyz And I can tell you (the OP) are definitely right about existing regions and the CAM. Yikes. After working on the 10th city I got so many eternal commuters I have -1million vacant jobs, and my region didn't even have that many to begin with!!. I mean 2 million eternal commuters????? My region has just barely has over 2million residents.. LOL. I gonna have to isolate each city until jobs fill up and go onto the next one before I connect them all, otherwise I'll never get any residential demand in large regions. I know about the loop and eternal commuting, but I am recreating New York City and I want to stay true to the transit network as best I can, I don't want to have to put all my connections in the middle of the city.quote>

It might turn out to be rather difficult to layout an exact copy of New York without having eternal commuters. And getting rid of all your current eternal commuters might turn out to be even worse than you might think.

Originally posted by: nycyyz Thanks for this great report, I learned a lot of how this game works on the commuting angle. (the game engine is definitely broken I'm afraid!)quote>

Thank you nycyyz, and I can only agree!

However, you can still enjoy the game, if you are aware of the game engine faults and know how to avoid them.

[nycyyz 0]

Ya, the regional workforce. My question is why it is always exactly 2X the actual workforce, no matter what city I start, wheter if is a city in a existing region or a brand new city with no regional pop and no connections to any other city. Oh, and I know you can't get rid of the eternal commuters (tried that already), but what I'm gonna try to do is isolate each city until all the jobs are tapped out and start the next city, and so on, then when I'm finshed I'll  connect them (starting from the suburbs) and run the sim and they can commute all day long or in circles for I care as long as some of them find their way to the CBD(Mid-manhattan) I've noticed it does matter in what order you run the cities in. It's better to start from the burbs and move to CBD so that they find the nearest jobs) 

Its just screwing up my residential demand right now and I already have massive underdevelopment in the middle ring of cities(neighboorhoods) away from the CBD). I can only imagine how the suburbs will be(Long Island being almost all residential) . The city will probably be a sea of green zones, LOL

[Hahayoudied 3]

How do I download that program? I want it badly but I can't find the link that leads to the download section.

[RippleJet 36]

Originally posted by: Hahayoudied How do I download that program? I want it badly but I can't find the link that leads to the download section.quote>

Unless you've already noticed it by now, it is attached to the first post in this thread.

Just read the first post thoroughly, from the start till the very end. That's where you will find version 2.

[Dodgeme 0]

Seems i am the only one having trouble with it. Simcity stop responding when I query the Repository... Running the deluxe version of SimCity. Original mod was working fine. Strange.

Any suggestion? Thanks!

[RippleJet 36]

The only explanation I could come up with would be video card memory related,

since the query window is rather big (almost 800x600 pixels).

Do you think you could download the CAMeLot Counter and see if you have the same problems with that.

Its query window is exactly the same size.

If you do not use the CAM, you can always use the I don't deserve it cheat to plop it.

[SimNation 139]

Hey RippleJet

Wanted to ask you a question since you've been doing quite the extensive amount of modding with query information so far. Is it possible to collect stats for Transit?

Like Number of Subway,Bus,Mono Rail,Heavy rail, Elevated rail stations, Number of Mass Transit Riders, and the number of Riders using each of those forms of transit?

I was going to request someone make a bat for a Department of Mass Transit HQ (which tells all the information).Also Department related branches: Bus,Subway,Mono Rail,Heavy Rail,& Elevated rail each with there own main branches(ones that only tell the stats for each individual mass transit method)

You think this information is possible in a query?

[RippleJet 36]

A lot of that information is available in variables.
Below is an extract from LUA script adv_game_data.lua (available in simcity_1.dat at address TGI 0xCA63E2A3, 0x4A5E8EF6, 0xFFBF9CCF), showing all variables you can use for traffic related information.


-- Abbreviations

-- prefixes ---------------------------------------------
--   g -- Global value (city-wide).
--   l  -- Local  value value that has location object associated with it.
--   a   -- Average value.
--   t   -- Trend value.

-- suffixes ---------------------------------------------
--   p --   Values representing a percentages.
--   h   -- The highest value in its domain.
--   l   --  The lowest value in its domain.
--   subject -- Used for objects associated with variables using
--              'l' (local) prefix. This object holds the locality
--               data related to that variable. Hence
--               game.l_air_pollution_h_subject is a locality
--               object for the cell with the highest air pollution value.

.
.
.

-- Traffic -------------------
game.g_pothole_count = 0
game.g_road_funding_p = 0
game.g_masstransit_funding_p = 0
game.g_transit_strike = 0
game.g_transit_strike_chance = 0
game.ga_freight_trip_length = 0

game.g_bus_station_count = 0
game.ga_bus_station_utilization_p = 0
game.l_bus_station_utilization_pl = 0
game.l_bus_station_utilization_pl_subject = 0

game.g_monorail_station_count = 0
game.ga_monorail_station_utilization_p = 0
game.l_monorail_station_utilization_pl = 0
game.l_monorail_station_utilization_pl_subject = 0

game.g_monorail_station_count = 0
game.ga_monorail_station_utilization_p = 0
game.l_monorail_station_utilization_pl = 0
game.l_monorail_station_utilization_pl_subject = 0

game.g_train_station_count = 0
game.ga_train_station_utilization_p = 0
game.l_train_station_utilization_pl = 0
game.l_train_station_utilization_pl_subject = 0
 
game.g_subway_station_count = 0
game.ga_subway_station_utilization_p = 0
game.l_subway_station_utilization_pl = 0
game.l_subway_station_utilization_pl_subject = 0
 
game.g_road_tile_count = 0
game.g_rail_tile_count = 0
game.g_subway_tile_count = 0
game.g_highway_tile_count = 0
game.g_street_tile_count = 0
 
game.ga_road_congestion = 0 -- from 0 and up. Values under about 100 (duh!) indicate no congestion.
game.g_road_congestion_tile_count = 0
game.l_road_congestion_h = 0
game.l_road_congestion_h_subject = 0

game.ga_rail_congestion = 0 -- from 0 and up. Values under about 100 (duh!) indicate no congestion.
game.g_rail_congestion_tile_count = 0
game.l_rail_congestion_h = 0
game.l_rail_congestion_h_subject = 0

game.ga_subway_congestion = 0 -- from 0 and up. Values under about 100 (duh!) indicate no congestion.
game.g_subway_congestion_tile_count = 0
game.l_subway_congestion_h = 0
game.l_subway_congestion_h_subject = 0

[moniquetoi 0]

Where there any dependencies for the beta?  I have a brown box instead of a pic of the repository. 

[RippleJet 36]

Originally posted by: moniquetoi Where there any dependencies for the beta?  I have a brown box instead of a pic of the repository. quote>

 

Re-read the first post thoroughly.

There is a link to RalphaelNinja's original upload where the model is!

[SimNation 139]

Thanks for the quick reply RippleJet. I assume that this can be done with the tools available that I have all of. Ima make a few for those settings I want displayed in game when I get some free time to fool around with it.

[RippleJet 36]

iLive's Reader is the only tool you can use for this purpose.

Take a look at the query for the Census Repository in Reader.

You might want to start with RalphaelNinja's original Census Repository first, as that query is a lot easier to understand.

Once you've figured out how that query works, you should be able to create your own.

[flyinbird93 2]

I have a question. I don't have a pic to provide but maybe I explain it well enough you won't need one.

on my cities, under resedential on "available jobs in city" I have a rediculas 250k jobs. but when I look under regional available jobs it says im around -30k to -45k jobs.

I have extensivly been zoing tons of commercial to lower that negitave number and after covering half a large 3/4 a medium, and a whole small extra area I've droped that neg number from 300k to my 30-45k. I have a huge demand for r& and r&&. does this mean I've got 45k upper residents that are jobless and all this zoning I've done will need to be filled by r& and r&&?

I hope this made sence

EDIT:  here is a pic you can look at.  is the circled areas look normal?

[RippleJet 36]

The game does allow a negative amount of available jobs in the region, at least for a while,
especially as long as the region is steadily growing.
Once the the regional growth stagnates, the lack of jobs will start to take its toll though.

When playing specialized cities (separating residents and jobs), you will get quite a delay in how quickly your Sims find jobs across city borders.
As you can see, you've already got a large amount of commuters coming into this city from elsewhere in the region.
The longer you play, the more commtuers you will probably be seeing (unless the residential capacity is allowed to increase within the city).

[simsmart 1]

Sorry, but, I can't seem to find the lot in the menu.

[RippleJet 36]

Census Repository Facility, Version 3

Finally, and it didn't even take two years...

  

I've fixed all errors found in the query, such as the IR CAP relief and the restriction that commuters could only be counted 100 years backwards.

Now they are all accounted for.

I've also added some more information to the query.

Information that is particularly useful when analysing demand problems, such as the current tax rate, the EQ, and the city's name.

Thanks to Callagrafx and Colyn, version 3 of the Census Repository now has its own bats.

Thus, you will not need download RalphaelNinja's original bat to avoid having a brown box.

The Census Repository Vault is meant for rural towns and other locations where you want to encourage agricultural growth. It is cheaper to plop and cheaper to run, and employs only 5 over working clerks. Each instance of the vault you plop will provide an I-R CAP relief of 30,000, which will allow you to grow farms in bigger cities as well.

The Census Repository Facility isn't available in every city. You need to have a situation where you must soon provide CAP relief in order to keep your city growing. Like the vault, it appears high up in the rewards menu:

It needs to be plopped across a busy road in a commercial area.

It boosts commercial growth but you don't want to live too close to it.

It is more expensive to plop and to run than the Vault, as it employs up to 85 clerks.

However, you will get income from sims who love to drive under the glass corridors of this formidable formicarium.

Also do note that the bureaucrats do not take any responsibility for people getting run over while lining up at the entrance,

or for cars crashing into the entrance, which foul mouths claim is appearing out of nowhere.

And if your name is Harry Potter, go knock the door of some other phone booth.

More information, including installation instructions, can be found here.

Download Version 3 of the Census Repository Facility here.

[pmcgowan360 0]

Where is the attachement in the first post?

[leaderfrontier 0]

Hi,everyone,erm...I have some question about the Census Repository Facility.I had read the readme file but I would like understand the CRV more further and, sorry for my bad English grammer..

Well...firstly,for residential Capacity...what do the "drive" and the "demand" mean

Let give an example:

Aspect in column(Aspect in row)

R$(drive) : 500

If every R$ wish to have job(which mean,no jobless problem occur),the maximum number of R$ resident is 500?

on the other hand,it mean the total job provided for R$ by both commercial and industry sector is 500?

R$(Demand) : 1000

Well,about the demand,I think it is just more likely as the RCI graph?

Then,for Residential Capacity(city):300

Currently,population : 200

Currently the population is 200 but the actual population should be 300,if there is no more house built,the next updated pop will be 300?

Available Vacant Housing(city):100

If the above statement is correct,then I believe that Available Vacant Housing mean compare to the previous pop calculated,there is 100 more new resident will move into this city,am I correct?

Total Workforce(city):150

Currently,the total number of worker in this city is 150?

Total workforce(demand):200

The city will need more 50 worker? or need more 200 worker?

Available vacant job(city) : 250

There is 100 more jobs that provided by both commercial and industry sector if compared to the previous data calculation?

Well,at last

what do Region and Projected mean?

I know it might look mess,I apologize for it...

wish for getting any explanation....and seriously,I like this Census Repository Facility!!

[z1 566]

Hi,everyone,erm...I have some question about the Census Repository Facility.I had read the readme file but I would like understand the CRV more further and, sorry for my bad English grammer..

Well...firstly,for residential Capacity...what do the "drive" and the "demand" mean

For an excellent explanation of drives, please see RippleJet's tutorial Workforce and Occupation Demands (Drives). Note that drives are only one type of demand, however.

R$(Demand) : 1000

Well,about the demand,I think it is just more likely as the RCI graph?

As you indicate, total RCI demand is shown by the RCI Demand Graph.

Then,for Residential Capacity(city):300

Currently,population : 200

Currently the population is 200 but the actual population should be 300,if there is no more house built,the next updated pop will be 300?

Yes.

Available Vacant Housing(city):100

If the above statement is correct,then I believe that Available Vacant Housing mean compare to the previous pop calculated,there is 100 more new resident will move into this city,am I correct?

Not necessarily. It means that with the current structures, there is room for 100 more residents to move in. Whether or not they do depends on various factors.

[z1 566]

[This is continued from the previous post; the system would not permit all these quoted blocks in a single post.]

Total Workforce(city):150

Currently,the total number of worker in this city is 150?

Yes.

Total workforce(demand):200

The city will need more 50 worker? or need more 200 worker?

There is demand for an additional 200 workers.

Available vacant job(city) : 250

There is 100 more jobs that provided by both commercial and industry sector if compared to the previous data calculation?

Yes.

Well,at last

what do Region and Projected mean?

"Region" means the figures are for all the cities in the region put together. "Projected" is what these figures will be if current trends continue.